{"id":1327,"date":"2023-07-26T20:57:06","date_gmt":"2023-07-26T20:57:06","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/"},"modified":"2023-07-26T20:57:06","modified_gmt":"2023-07-26T20:57:06","slug":"panda-bergulir-yang-jahat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/","title":{"rendered":"Cara menghitung rata-rata pergerakan di pandas"},"content":{"rendered":"

<\/p>\n

\n

Rata-rata bergerak<\/strong> hanyalah rata-rata dari sejumlah periode sebelumnya dalam suatu deret waktu.<\/span><\/p>\n

Untuk menghitung rata-rata bergulir satu atau lebih kolom di pandas DataFrame, kita dapat menggunakan sintaks berikut:<\/span><\/p>\n

 df[' column_name<\/span> ']. rolling<\/span> ( rolling_window<\/span> ). mean<\/span> ()\n<\/strong><\/pre>\n
 Tutorial ini memberikan beberapa contoh penggunaan praktis fungsi ini.<\/span><\/p>\n
 Contoh: menghitung moving average pada panda<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n
 import<\/span> numpy as<\/span> np\nimport<\/span> pandas as<\/span> pd\n\n#make this example reproducible\n<\/span>n.p. random<\/span> . seeds<\/span> (0)\n\n#create dataset<\/span>\nperiod = np. arange<\/span> (1, 101, 1)\nleads = np. random<\/span> . uniform<\/span> (1, 20, 100)\nsales = 60 + 2*period + np. random<\/span> . normal<\/span> (loc=0, scale=.5*period, size=100)\ndf = pd. DataFrame<\/span> ({' period<\/span> ': period, ' leads<\/span> ': leads, ' sales<\/span> ': sales})\n\n#view first 10 rows\n<\/span>df. head<\/span> (10)\n\n   period leads sales\n0 1 11.427457 61.417425\n1 2 14.588598 64.900826\n2 3 12.452504 66.698494\n3 4 11.352780 64.927513\n4 5 9.049441 73.720630\n5 6 13.271988 77.687668\n6 7 9.314157 78.125728\n7 8 17.943687 75.280301\n8 9 19.309592 73.181613\n9 10 8.285389 85.272259\n<\/strong><\/pre>\n
 Kita dapat menggunakan sintaks berikut untuk membuat kolom baru yang berisi rata-rata pergerakan “penjualan” untuk 5 periode sebelumnya:<\/span><\/p>\n
 #find rolling mean of previous 5 sales periods\n<\/span>df[' rolling_sales_5<\/span> '] = df[' sales<\/span> ']. rolling<\/span> (5). mean<\/span> ()\n\n#view first 10 rows\n<\/span>df. head<\/span> (10)\n\n\tperiod leads sales rolling_sales_5\n0 1 11.427457 61.417425 NaN\n1 2 14.588598 64.900826 NaN\n2 3 12.452504 66.698494 NaN\n3 4 11.352780 64.927513 NaN\n4 5 9.049441 73.720630 66.332978\n5 6 13.271988 77.687668 69.587026\n6 7 9.314157 78.125728 72.232007\n7 8 17.943687 75.280301 73.948368\n8 9 19.309592 73.181613 75.599188\n9 10 8.285389 85.272259 77.909514\n<\/strong><\/pre>\n
 Kami dapat memverifikasi secara manual bahwa rata-rata penjualan bergulir yang ditampilkan untuk periode 5 adalah rata-rata dari 5 periode sebelumnya:<\/span><\/p>\n
 Rata-rata pergerakan pada periode 5: (61.417+64.900+66.698+64.927+73.720)\/5 = 66.33<\/strong><\/span><\/p>\n
 Kita dapat menggunakan sintaks serupa untuk menghitung rata-rata pergerakan beberapa kolom:<\/span><\/p>\n
 #find rolling mean of previous 5 leads periods \ndf[' rolling_leads_5<\/span> '] = df[' leads<\/span> ']. rolling<\/span> (5). mean<\/span> ()<\/span>\n\n#find rolling mean of previous 5 leads periods\n<\/span>df[' rolling_sales_5<\/span> '] = df[' sales<\/span> ']. rolling<\/span> (5). mean<\/span> ()\n\n#view first 10 rows\n<\/span>df. head<\/span> (10)\n\n\tperiod leads sales rolling_sales_5 rolling_leads_5\n0 1 11.427457 61.417425 NaN NaN\n1 2 14.588598 64.900826 NaN NaN\n2 3 12.452504 66.698494 NaN NaN\n3 4 11.352780 64.927513 NaN NaN\n4 5 9.049441 73.720630 66.332978 11.774156\n5 6 13.271988 77.687668 69.587026 12.143062\n6 7 9.314157 78.125728 72.232007 11.088174\n7 8 17.943687 75.280301 73.948368 12.186411\n8 9 19.309592 73.181613 75.599188 13.777773\n9 10 8.285389 85.272259 77.909514 13.624963\n<\/strong><\/pre>\n
 Kita juga dapat membuat plot garis cepat menggunakan Matplotlib untuk memvisualisasikan penjualan kotor versus rata-rata penjualan bergerak:<\/span> <\/p>\n
 import<\/span> matplotlib. pyplot<\/span> as<\/span> plt<\/span>\nplt. plot<\/span> (df[' rolling_sales_5<\/span> '], label=' Rolling Mean<\/span> ')<\/span>\nplt. plot<\/span> (df[' sales<\/span> '], label=' Raw Data<\/span> ')<\/span>\nplt. legend<\/span> ()<\/span>\nplt. ylabel<\/span> (' Sales<\/span> ')<\/span>\nplt. xlabel<\/span> (' Period<\/span> ')<\/span>\nplt. show<\/span> ()<\/span>\n<\/span><\/strong><\/pre>\n
\"Merencanakan<\/p>\n
 Garis biru menunjukkan rata-rata pergerakan penjualan 5 periode dan garis oranye menunjukkan data penjualan mentah.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n
 Cara menghitung korelasi geser pada panda<\/a>
 Cara menghitung rata-rata kolom di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Rata-rata bergerak hanyalah rata-rata dari sejumlah periode sebelumnya dalam suatu deret waktu. Untuk menghitung rata-rata bergulir satu atau lebih kolom di pandas DataFrame, kita dapat menggunakan sintaks berikut: df[‘ column_name ‘]. rolling ( rolling_window ). mean () Tutorial ini memberikan beberapa contoh penggunaan praktis fungsi ini. Contoh: menghitung moving average pada panda Misalkan kita memiliki […]<\/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":"\nCara Menghitung Rata-Rata Pergerakan di Pandas \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan untuk satu atau lebih kolom di pandas DataFrame, dengan 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\/panda-bergulir-yang-jahat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Rata-Rata Pergerakan di Pandas \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan untuk satu atau lebih kolom di pandas DataFrame, dengan contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T20:57:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/roulantmeanpandas1.png\" \/>\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\/panda-bergulir-yang-jahat\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/\",\"name\":\"Cara Menghitung Rata-Rata Pergerakan di Pandas \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T20:57:06+00:00\",\"dateModified\":\"2023-07-26T20:57:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan untuk satu atau lebih kolom di pandas DataFrame, dengan contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata pergerakan di pandas\"}]},{\"@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 Menghitung Rata-Rata Pergerakan di Pandas \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan untuk satu atau lebih kolom di pandas DataFrame, dengan 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\/panda-bergulir-yang-jahat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Rata-Rata Pergerakan di Pandas \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan untuk satu atau lebih kolom di pandas DataFrame, dengan contoh.","og_url":"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/","og_site_name":"Statorials","article_published_time":"2023-07-26T20:57:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/roulantmeanpandas1.png"}],"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\/panda-bergulir-yang-jahat\/","url":"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/","name":"Cara Menghitung Rata-Rata Pergerakan di Pandas \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T20:57:06+00:00","dateModified":"2023-07-26T20:57:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata pergerakan untuk satu atau lebih kolom di pandas DataFrame, dengan contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-bergulir-yang-jahat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata pergerakan di pandas"}]},{"@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\/1327"}],"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=1327"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1327\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}