{"id":3256,"date":"2023-07-18T10:46:40","date_gmt":"2023-07-18T10:46:40","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/"},"modified":"2023-07-18T10:46:40","modified_gmt":"2023-07-18T10:46:40","slug":"kelompok-panda-per-kuartal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/","title":{"rendered":"Cara mengelompokkan berdasarkan kuartal di pandas dataframe (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk mengelompokkan baris per kuartal di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#convert date column to datetime<\/span>\ndf[' <span style=\"color: #ff0000;\">date<\/span> '] = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> (df[' <span style=\"color: #ff0000;\">date<\/span> '])\n\n<span style=\"color: #008080;\">#calculate sum of values, grouped by quarter\n<\/span>df. <span style=\"color: #3366ff;\">groupby<\/span> (df[' <span style=\"color: #ff0000;\">date<\/span> ']. <span style=\"color: #3366ff;\">dt<\/span> . <span style=\"color: #3366ff;\">to_period<\/span> (' <span style=\"color: #ff0000;\">Q<\/span> '))[' <span style=\"color: #ff0000;\">values<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengelompokkan baris per kuartal di kolom <strong>tanggal<\/strong> dan menghitung jumlah kolom <strong>nilai<\/strong> di DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara mengelompokkan berdasarkan kuartal di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki panda DataFrame berikut yang menunjukkan penjualan yang dilakukan oleh suatu perusahaan pada tanggal berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">date<\/span> ': pd. <span style=\"color: #3366ff;\">date_range<\/span> (start='1\/1\/2022', freq='M', periods= <span style=\"color: #008000;\">12<\/span> ),\n                   ' <span style=\"color: #ff0000;\">sales<\/span> ': [6, 8, 10, 5, 4, 8, 8, 3, 5, 14, 8, 3]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n         dirty date\n0 2022-01-31 6\n1 2022-02-28 8\n2 2022-03-31 10\n3 2022-04-30 5\n4 2022-05-31 4\n5 2022-06-30 8\n6 2022-07-31 8\n7 2022-08-31 3\n8 2022-09-30 5\n9 2022-10-31 14\n10 2022-11-30 8\n11 2022-12-31 3<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-panda\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Rentang Tanggal di Pandas<\/a><\/span><\/p>\n<p> <span style=\"color: #000000;\">Sintaks berikut dapat digunakan untuk menghitung jumlah penjualan yang dikelompokkan berdasarkan kuartal:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#convert date column to datetime and subtract one week<\/span>\ndf[' <span style=\"color: #ff0000;\">date<\/span> '] = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> (df[' <span style=\"color: #ff0000;\">date<\/span> '])\n\n<span style=\"color: #008080;\">#calculate sum of sales, grouped by quarter\n<\/span>df. <span style=\"color: #3366ff;\">groupby<\/span> (df[' <span style=\"color: #ff0000;\">date<\/span> ']. <span style=\"color: #3366ff;\">dt<\/span> . <span style=\"color: #3366ff;\">to_period<\/span> (' <span style=\"color: #ff0000;\">Q<\/span> '))[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n\ndate\n2022Q1 24\n2022Q2 17\n2022Q3 16\n2022Q4 25\nFreq: Q-DEC, Name: sales, dtype: int64\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sebanyak <b>24<\/b> penjualan dilakukan selama kuartal pertama.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>17<\/b> penjualan dilakukan selama kuartal kedua.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>16<\/b> penjualan dilakukan selama kuartal ketiga.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>25<\/b> penjualan dilakukan selama kuartal keempat.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks serupa untuk menghitung metrik lain, yang dikelompokkan berdasarkan kuartal.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menghitung nilai penjualan maksimum, yang dikelompokkan berdasarkan kuartal:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#convert date column to datetime<\/span>\ndf[' <span style=\"color: #ff0000;\">date<\/span> '] = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> (df[' <span style=\"color: #ff0000;\">date<\/span> '])\n\n<span style=\"color: #008080;\">#calculate max of sales, grouped by quarter\n<\/span>df. <span style=\"color: #3366ff;\">groupby<\/span> (df[' <span style=\"color: #ff0000;\">date<\/span> ']. <span style=\"color: #3366ff;\">dt<\/span> . <span style=\"color: #3366ff;\">to_period<\/span> (' <span style=\"color: #ff0000;\">Q<\/span> '))[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">max<\/span> ()\n\ndate\n2022Q1 10\n2022Q2 8\n2022Q3 8\n2022Q4 14\nFreq: Q-DEC, Name: sales, dtype: int64\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Penjualan puncak dalam satu bulan selama kuartal pertama adalah <strong>10<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan puncak dalam satu bulan selama kuartal kedua adalah <strong>8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan puncak dalam satu bulan selama kuartal ketiga adalah <strong>8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjualan puncak dalam satu bulan selama kuartal keempat adalah <strong>14<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap operasi <strong>groupby<\/strong> di pandas <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.groupby.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan berdasarkan bulan di Pandas DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan berdasarkan minggu di Pandas DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-berdasarkan-hitungan-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggunakan Groupby dan menghitung secara kondisional<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengelompokkan baris per kuartal di pandas DataFrame: #convert date column to datetime df[&#8216; date &#8216;] = pd. to_datetime (df[&#8216; date &#8216;]) #calculate sum of values, grouped by quarter df. groupby (df[&#8216; date &#8216;]. dt . to_period (&#8216; Q &#8216;))[&#8216; values &#8216;]. sum () Rumus khusus ini mengelompokkan baris [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara mengelompokkan berdasarkan kuartal di Pandas DataFrame (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris per kuartal di pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengelompokkan berdasarkan kuartal di Pandas DataFrame (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris per kuartal di pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T10:46:40+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/\",\"name\":\"Cara mengelompokkan berdasarkan kuartal di Pandas DataFrame (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T10:46:40+00:00\",\"dateModified\":\"2023-07-18T10:46:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan baris per kuartal di pandas DataFrame, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengelompokkan berdasarkan kuartal di pandas dataframe (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara mengelompokkan berdasarkan kuartal di Pandas DataFrame (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan baris per kuartal di pandas DataFrame, dengan sebuah contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengelompokkan berdasarkan kuartal di Pandas DataFrame (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan baris per kuartal di pandas DataFrame, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/","og_site_name":"Statorials","article_published_time":"2023-07-18T10:46:40+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/","url":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/","name":"Cara mengelompokkan berdasarkan kuartal di Pandas DataFrame (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T10:46:40+00:00","dateModified":"2023-07-18T10:46:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan baris per kuartal di pandas DataFrame, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-panda-per-kuartal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengelompokkan berdasarkan kuartal di pandas dataframe (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3256"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3256"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3256\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}