{"id":3253,"date":"2023-07-18T11:09:02","date_gmt":"2023-07-18T11:09:02","guid":{"rendered":"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/"},"modified":"2023-07-18T11:09:02","modified_gmt":"2023-07-18T11:09:02","slug":"sekelompok-panda-per-minggu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/","title":{"rendered":"Cara mengelompokkan berdasarkan minggu 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 minggu di pandas DataFrame:<\/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> ']) - pd. <span style=\"color: #3366ff;\">to_timedelta<\/span> (7, unit=' <span style=\"color: #ff0000;\">d<\/span> ')\n\n<span style=\"color: #008080;\">#calculate sum of values, grouped by week\n<\/span>df. <span style=\"color: #3366ff;\">groupby<\/span> ([pd. <span style=\"color: #3366ff;\">Group<\/span> (key=' <span style=\"color: #ff0000;\">date<\/span> ', freq=' <span style=\"color: #ff0000;\">W<\/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 berdasarkan minggu di kolom <strong>tanggal<\/strong> dan menghitung jumlah nilai untuk 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 minggu 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\/5\/2022', freq='D', periods=15),\n                   ' <span style=\"color: #ff0000;\">sales<\/span> ': [6, 8, 9, 5, 4, 8, 8, 3, 5, 9, 8, 3, 4, 7, 7]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<span style=\"color: #008000;\">print<\/span><\/span> (df)\n\n         dirty date\n0 2022-01-05 6\n1 2022-01-06 8\n2 2022-01-07 9\n3 2022-01-08 5\n4 2022-01-09 4\n5 2022-01-10 8\n6 2022-01-11 8\n7 2022-01-12 3\n8 2022-01-13 5\n9 2022-01-14 9\n10 2022-01-15 8\n11 2022-01-16 3\n12 2022-01-17 4\n13 2022-01-18 7\n14 2022-01-19 7\n<\/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 minggu:<\/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> ']) - pd. <span style=\"color: #3366ff;\">to_timedelta<\/span> (7, unit=' <span style=\"color: #ff0000;\">d<\/span> ')\n\n<span style=\"color: #008080;\">#calculate sum of values, grouped by week\n<\/span>df. <span style=\"color: #3366ff;\">groupby<\/span> ([pd. <span style=\"color: #3366ff;\">Group<\/span> (key=' <span style=\"color: #ff0000;\">date<\/span> ', freq=' <span style=\"color: #ff0000;\">W<\/span> ')])[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ()\n\ndate\n2022-01-02 32\n2022-01-09 44\n2022-01-16 18\nFreq: W-SUN, 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;\">Ada total <b>32<\/b> penjualan selama seminggu yang dimulai setelah 1\/2\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada total <b>44<\/b> penjualan selama seminggu yang dimulai setelah 01\/09\/2022.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <b>18<\/b> penjualan dilakukan selama seminggu mulai hari setelah 16\/01\/2022.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perlu dicatat bahwa secara default, panda berasumsi bahwa minggu dimulai pada hari setelah Minggu ( <strong>W-SUN<\/strong> ).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, menurut <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/user_guide\/timeseries.html\" target=\"_blank\" rel=\"noopener\">dokumentasi<\/a> , Anda dapat mengubah nilai ini untuk <strong>Freq<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat menentukan <strong>Freq=W-MON<\/strong> jika Anda ingin setiap minggu dimulai pada hari setelah Senin (yaitu Selasa).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks serupa untuk menghitung nilai penjualan maksimum yang dikelompokkan berdasarkan minggu:<\/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> ']) - pd. <span style=\"color: #3366ff;\">to_timedelta<\/span> (7, unit=' <span style=\"color: #ff0000;\">d<\/span> ')\n\n<span style=\"color: #008080;\">#calculate max of values, grouped by week\n<\/span>df. <span style=\"color: #3366ff;\">groupby<\/span> ([pd. <span style=\"color: #3366ff;\">Group<\/span> (key=' <span style=\"color: #ff0000;\">date<\/span> ', freq=' <span style=\"color: #ff0000;\">W<\/span> ')])[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">max<\/span> ()\n\ndate\n2022-01-02 9\n2022-01-09 9\n2022-01-16 7\nFreq: W-SUN, 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 maksimum per hari selama seminggu mulai hari setelah 01\/02\/2022 adalah <strong>9<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah maksimum penjualan per hari selama seminggu yang dimulai setelah 01\/9\/2022 adalah <strong>9<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah maksimum penjualan per hari selama seminggu mulai hari setelah 16\/01\/2022 adalah <strong>7<\/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-hari\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan berdasarkan hari di Pandas DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-berdasarkan-hitungan-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan Groupby dan menghitung secara kondisional di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengelompokkan baris berdasarkan minggu di pandas DataFrame: #convert date column to datetime and subtract one week df[&#8216; date &#8216;] = pd. to_datetime (df[&#8216; date &#8216;]) &#8211; pd. to_timedelta (7, unit=&#8217; d &#8216;) #calculate sum of values, grouped by week df. groupby ([pd. Group (key=&#8217; date &#8216;, freq=&#8217; W [&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 minggu di Pandas DataFrame (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan minggu 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\/sekelompok-panda-per-minggu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengelompokkan berdasarkan minggu di Pandas DataFrame (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan minggu di pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T11:09:02+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-minggu\/\",\"url\":\"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/\",\"name\":\"Cara mengelompokkan berdasarkan minggu di Pandas DataFrame (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T11:09:02+00:00\",\"dateModified\":\"2023-07-18T11:09:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan minggu di pandas DataFrame, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengelompokkan berdasarkan minggu 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 minggu di Pandas DataFrame (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan minggu 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\/sekelompok-panda-per-minggu\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengelompokkan berdasarkan minggu di Pandas DataFrame (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan minggu di pandas DataFrame, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/","og_site_name":"Statorials","article_published_time":"2023-07-18T11:09:02+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-minggu\/","url":"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/","name":"Cara mengelompokkan berdasarkan minggu di Pandas DataFrame (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T11:09:02+00:00","dateModified":"2023-07-18T11:09:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan baris berdasarkan minggu di pandas DataFrame, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sekelompok-panda-per-minggu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengelompokkan berdasarkan minggu 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\/3253"}],"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=3253"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3253\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}