{"id":2918,"date":"2023-07-20T02:35:31","date_gmt":"2023-07-20T02:35:31","guid":{"rendered":"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/"},"modified":"2023-07-20T02:35:31","modified_gmt":"2023-07-20T02:35:31","slug":"sekelompok-panda-per-bulan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/","title":{"rendered":"Cara mengelompokkan berdasarkan bulan 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 berdasarkan bulan di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">groupby<\/span> (df. <span style=\"color: #3366ff;\">your_date_column<\/span> . <span style=\"color: #3366ff;\">dt<\/span> . <span style=\"color: #3366ff;\">month<\/span> )[' <span style=\"color: #ff0000;\">values_column<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengelompokkan baris berdasarkan tanggal di <strong>kolom_tanggal_Anda<\/strong> dan menghitung jumlah nilai untuk <strong>kolom_nilai<\/strong> di DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>dt.month()<\/strong> mengekstrak bulan dari kolom tanggal di panda.<\/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 bulan 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> ': <span style=\"color: #3366ff;\">pd.date_range<\/span> (start=' <span style=\"color: #ff0000;\">1\/1\/2020<\/span> ', freq=' <span style=\"color: #ff0000;\">W<\/span> ', periods= <span style=\"color: #008000;\">10<\/span> ),\n                   ' <span style=\"color: #ff0000;\">sales<\/span> ': [6, 8, 9, 11, 13, 8, 8, 15, 22, 9],\n                   ' <span style=\"color: #ff0000;\">returns<\/span> ': [0, 3, 2, 2, 1, 3, 2, 4, 1, 5]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n        date sales returns\n0 2020-01-05 6 0\n1 2020-01-12 8 3\n2 2020-01-19 9 2\n3 2020-01-26 11 2\n4 2020-02-02 13 1\n5 2020-02-09 8 3\n6 2020-02-16 8 2\n7 2020-02-23 15 4\n8 2020-03-01 22 1\n9 2020-03-08 9 5<\/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;\">Kita dapat menggunakan sintaks berikut untuk menghitung jumlah penjualan yang dikelompokkan berdasarkan bulan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#calculate sum of sales grouped by month\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> (df. <span style=\"color: #3366ff;\">date<\/span> . <span style=\"color: #3366ff;\">dt<\/span> . <span style=\"color: #3366ff;\">month<\/span> )[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n\ndate\n1 34\n2 44\n3 31\nName: sales, dtype: int64<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total penjualan yang dilakukan pada bulan 1 (Januari) adalah <strong>34<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total penjualan yang dilakukan pada bulan 2 (Februari) adalah <strong>44<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total penjualan yang dilakukan pada bulan 3 (Maret) adalah <strong>31<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks serupa untuk menghitung nilai penjualan maksimum yang dikelompokkan berdasarkan bulan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#calculate max of sales grouped by month\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> (df. <span style=\"color: #3366ff;\">date<\/span> . <span style=\"color: #3366ff;\">dt<\/span> . <span style=\"color: #3366ff;\">month<\/span> )[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">max<\/span> ()\n\ndate\n1 11\n2 15\n3 22\nName: sales, dtype: int64<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks serupa untuk menghitung nilai apa pun yang ingin kita kelompokkan berdasarkan nilai bulanan kolom tanggal.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap operasi GroupBy 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<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/jumlah-kumulatif-panda-per-grup\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung jumlah kumulatif per kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-dikelompokkan-berdasarkan-jumlah-unik\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung nilai unik berdasarkan kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-korelasi\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung korelasi berdasarkan kelompok<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengelompokkan baris berdasarkan bulan di pandas DataFrame: df. groupby (df. your_date_column . dt . month )[&#8216; values_column &#8216;]. sum () Rumus khusus ini mengelompokkan baris berdasarkan tanggal di kolom_tanggal_Anda dan menghitung jumlah nilai untuk kolom_nilai di DataFrame. Perhatikan bahwa fungsi dt.month() mengekstrak bulan dari kolom tanggal di panda. [&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 bulan di Pandas DataFrame (dengan contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan bulan di pandas DataFrame, dengan beberapa 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\/sekelompok-panda-per-bulan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengelompokkan berdasarkan bulan di Pandas DataFrame (dengan contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan bulan di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T02:35:31+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\/sekelompok-panda-per-bulan\/\",\"url\":\"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/\",\"name\":\"Cara mengelompokkan berdasarkan bulan di Pandas DataFrame (dengan contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T02:35:31+00:00\",\"dateModified\":\"2023-07-20T02:35:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan bulan di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengelompokkan berdasarkan bulan 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 bulan di Pandas DataFrame (dengan contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan bulan di pandas DataFrame, dengan beberapa 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\/sekelompok-panda-per-bulan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengelompokkan berdasarkan bulan di Pandas DataFrame (dengan contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan bulan di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/","og_site_name":"Statorials","article_published_time":"2023-07-20T02:35:31+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\/sekelompok-panda-per-bulan\/","url":"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/","name":"Cara mengelompokkan berdasarkan bulan di Pandas DataFrame (dengan contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T02:35:31+00:00","dateModified":"2023-07-20T02:35:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan bulan di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sekelompok-panda-per-bulan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengelompokkan berdasarkan bulan 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\/2918"}],"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=2918"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2918\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}