{"id":4234,"date":"2023-07-12T15:37:29","date_gmt":"2023-07-12T15:37:29","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/"},"modified":"2023-07-12T15:37:29","modified_gmt":"2023-07-12T15:37:29","slug":"kelompok-panda-dengan-sampel-ulang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/","title":{"rendered":"Pandas: cara mengambil sampel ulang deret waktu dengan groupby()"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Pengambilan sampel ulang<\/strong> data deret waktu berarti menggabungkan data dalam periode baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin mengambil sampel ulang rangkaian waktu di panda menggunakan operator <strong>groupby<\/strong> , Anda dapat menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>group = df. <span style=\"color: #3366ff;\">groupby<\/span> ([pd. <span style=\"color: #3366ff;\">Group<\/span> (freq=' <span style=\"color: #ff0000;\">W<\/span> '), ' <span style=\"color: #ff0000;\">store<\/span> '])\n\nresult = group[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> (). <span style=\"color: #3366ff;\">unstack<\/span> (' <span style=\"color: #ff0000;\">store<\/span> '). <span style=\"color: #3366ff;\">fillna<\/span> (0) \n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mengelompokkan baris kolom DataFrame menurut <strong>toko<\/strong> , lalu mengambil sampel ulang rangkaian waktu berdasarkan minggu ( <strong>freq=&#8217;W&#8217;<\/strong> ), lalu menghitung jumlah nilai di kolom <strong>penjualan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kami dapat mengambil sampel ulang data deret waktu ke periode waktu yang berbeda, termasuk:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>S<\/strong> : Detik<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>menit<\/strong> : Menit<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>H<\/strong> : Jam<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>J<\/strong> : Hari<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>W<\/strong> : Minggu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>G<\/strong> : Bulan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>T<\/strong> : Seperempat<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>J<\/strong> : Tahun<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara mengambil sampel ulang data deret waktu dengan operasi <strong>grup demi<\/strong> dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Contoh ulang deret waktu dengan groupby di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut yang menunjukkan total penjualan yang dilakukan setiap hari di dua toko berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">sales<\/span> ': [13, 14, 17, 17, 16, 22, 28, 10, 17, 10, 11],\n                   ' <span style=\"color: #ff0000;\">store<\/span> ': ['A', 'A', 'A', 'A', 'A', 'B', 'B', 'B', 'B', 'B', 'B']} ,\n                   index=pd. <span style=\"color: #3366ff;\">date_range<\/span> ('2023-01-06', '2023-01-16', freq='d'))\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n            sales store\n2023-01-06 13 A\n2023-01-07 14 A\n2023-01-08 17 A\n2023-01-09 17 A\n2023-01-10 16A\n2023-01-11 22 B\n2023-01-12 28 B\n2023-01-13 10 B\n2023-01-14 17 B\n2023-01-15 10 B\n2023-01-16 11 B<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin mengelompokkan baris berdasarkan <strong>store<\/strong> , lalu mengambil sampel ulang deret waktu berdasarkan minggu, lalu menghitung jumlah nilai di kolom <strong>penjualan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#group by store and resample time series by week<\/span>\ngroup = df. <span style=\"color: #3366ff;\">groupby<\/span> ([pd. <span style=\"color: #3366ff;\">Group<\/span> (freq=' <span style=\"color: #ff0000;\">W<\/span> '), ' <span style=\"color: #ff0000;\">store<\/span> '])\n\n<span style=\"color: #008080;\">#calculate sum of sales each week by store\n<\/span>result = group[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> (). <span style=\"color: #3366ff;\">unstack<\/span> (' <span style=\"color: #ff0000;\">store<\/span> '). <span style=\"color: #3366ff;\">fillna<\/span> (0)\n\n<span style=\"color: #008080;\">#view results<\/span>\n<span style=\"color: #008000;\">print<\/span> (result)\n\nstore AB\n2023-01-08 14.0 0.0\n2023-01-15 16.5 17.0\n2023-01-22 0.0 11.0\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah penjualan untuk minggu yang berakhir 01\/08\/2023 di toko A adalah <strong>14<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah penjualan untuk minggu yang berakhir 01\/08\/2023 di toko B adalah <strong>0<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami memilih untuk menghitung jumlah nilai di kolom <strong>penjualan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, kita dapat memilih metrik lain seperti jumlah, rata-rata, median, min, maks, dll.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cukup ganti <strong>sum()<\/strong> pada kode di atas dengan <strong>count()<\/strong> , <strong>Mean()<\/strong> , <strong>Median()<\/strong> , dll. untuk menghitung metrik pilihan Anda.<\/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 dengan Python:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/deret-waktu-matplotlib\/\" target=\"_blank\" rel=\"noopener\">Cara memplot deret waktu di Matplotlib<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-waktu-kelahiran-laut\/\" target=\"_blank\" rel=\"noopener\">Cara membuat plot deret waktu di Seaborn<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kartu-python\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung MAPE dari deret waktu dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pengambilan sampel ulang data deret waktu berarti menggabungkan data dalam periode baru. Jika Anda ingin mengambil sampel ulang rangkaian waktu di panda menggunakan operator groupby , Anda dapat menggunakan sintaks dasar berikut: group = df. groupby ([pd. Group (freq=&#8217; W &#8216;), &#8216; store &#8216;]) result = group[&#8216; sales &#8216;]. sum (). unstack (&#8216; store &#8216;). [&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>Pandas: Cara mengambil sampel ulang deret waktu dengan groupby() \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengambil sampel ulang rangkaian waktu di pandas saat menggunakan operasi groupby, termasuk 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-dengan-sampel-ulang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengambil sampel ulang deret waktu dengan groupby() \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengambil sampel ulang rangkaian waktu di pandas saat menggunakan operasi groupby, termasuk sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T15:37:29+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-dengan-sampel-ulang\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/\",\"name\":\"Pandas: Cara mengambil sampel ulang deret waktu dengan groupby() \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T15:37:29+00:00\",\"dateModified\":\"2023-07-12T15:37:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengambil sampel ulang rangkaian waktu di pandas saat menggunakan operasi groupby, termasuk sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengambil sampel ulang deret waktu dengan groupby()\"}]},{\"@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":"Pandas: Cara mengambil sampel ulang deret waktu dengan groupby() \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengambil sampel ulang rangkaian waktu di pandas saat menggunakan operasi groupby, termasuk 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-dengan-sampel-ulang\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengambil sampel ulang deret waktu dengan groupby() \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengambil sampel ulang rangkaian waktu di pandas saat menggunakan operasi groupby, termasuk sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/","og_site_name":"Statorials","article_published_time":"2023-07-12T15:37:29+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-dengan-sampel-ulang\/","url":"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/","name":"Pandas: Cara mengambil sampel ulang deret waktu dengan groupby() \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T15:37:29+00:00","dateModified":"2023-07-12T15:37:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengambil sampel ulang rangkaian waktu di pandas saat menggunakan operasi groupby, termasuk sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-panda-dengan-sampel-ulang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengambil sampel ulang deret waktu dengan groupby()"}]},{"@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\/4234"}],"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=4234"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4234\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}