{"id":986,"date":"2023-07-28T02:28:10","date_gmt":"2023-07-28T02:28:10","guid":{"rendered":"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/"},"modified":"2023-07-28T02:28:10","modified_gmt":"2023-07-28T02:28:10","slug":"menormalkan-kolom-kerangka-data-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/","title":{"rendered":"Cara menormalkan kolom di pandas dataframe"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin <strong>menormalkan<\/strong> nilai data dari satu atau lebih kolom di pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan dua cara untuk melakukan ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Normalisasi Min-Maks<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><b>Tujuan:<\/b> Mengonversi setiap nilai data menjadi nilai antara 0 dan 1.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Rumus:<\/strong> Nilai baru = (nilai \u2013 min) \/ (maks \u2013 min)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>2. Normalisasi rata-rata<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><b>Tujuan:<\/b> Menskalakan nilai sedemikian rupa sehingga rata-rata semua nilai adalah 0 dan std. dev. adalah 1.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Rumus:<\/strong> Nilai baru = (nilai \u2013 rata-rata) \/ (standar deviasi)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Mari kita lihat contoh cara menggunakan setiap metode pada pandas DataFrame.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: normalisasi min-maks<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd.DataFrame({'points': [25, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, 9, 12],\n                   'rebounds': [11, 8, 10, 6, 6]}) \n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #993300;\">print<\/span> (df)\n\n   points assists rebounds\n0 25 5 11\n1 12 7 8\n2 15 7 10\n3 14 9 6\n4 19 12 6\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menerapkan normalisasi min-maks ke setiap kolom DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>(df-df. <span style=\"color: #3366ff;\">min<\/span> ())\/(df. <span style=\"color: #3366ff;\">max<\/span> ()-df. <span style=\"color: #3366ff;\">min<\/span> ())\n\n        points assists rebounds\n0 1.000000 0.000000 1.0\n1 0.000000 0.285714 0.4\n2 0.230769 0.285714 0.8\n3 0.153846 0.571429 0.0\n4 0.538462 1.000000 0.0\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai maksimal di setiap kolom sekarang adalah <strong>1<\/strong> dan nilai min di setiap kolom sekarang menjadi <strong>0<\/strong> , dengan semua nilai lainnya antara 0 dan 1.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: normalisasi rata-rata<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita asumsikan lagi bahwa kita memiliki pandas DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd.DataFrame({'points': [25, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, 9, 12],\n                   'rebounds': [11, 8, 10, 6, 6]}) \n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #993300;\">print<\/span> (df)\n\n   points assists rebounds\n0 25 5 11\n1 12 7 8\n2 15 7 10\n3 14 9 6\n4 19 12 6\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menerapkan normalisasi rata-rata ke setiap kolom di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>(df- <span style=\"color: #3366ff;\">df.mean<\/span> ())\/df. <span style=\"color: #3366ff;\">std<\/span> ()\n\n        points assists rebounds\n0 1.554057 -1.133893 1.227881\n1 -0.971286 -0.377964 -0.087706\n2 -0.388514 -0.377964 0.789352\n3 -0.582772 0.377964 -0.964764\n4 0.388514 1.511858 -0.964764\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai-nilai pada setiap kolom kini dinormalisasi sedemikian rupa sehingga rata-rata nilai pada setiap kolom adalah 0 dan simpangan baku nilai pada setiap kolom adalah 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika titik data tertentu memiliki nilai normalisasi lebih besar dari 0, hal ini menunjukkan bahwa titik data tersebut lebih besar dari rata-rata kolomnya. Sebaliknya, nilai yang dinormalisasi kurang dari 0 menunjukkan bahwa titik data berada di bawah rata-rata kolomnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pandas: cara mengelompokkan dan menggabungkan beberapa kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-memfilter-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara memfilter Pandas DataFrame pada berbagai kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-yang-hilang\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghitung nilai yang hilang di Pandas DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menormalkan nilai data dari satu atau lebih kolom di pandas DataFrame. Tutorial ini menjelaskan dua cara untuk melakukan ini: 1. Normalisasi Min-Maks Tujuan: Mengonversi setiap nilai data menjadi nilai antara 0 dan 1. Rumus: Nilai baru = (nilai \u2013 min) \/ (maks \u2013 min) 2. Normalisasi rata-rata Tujuan: Menskalakan nilai sedemikian [&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 menormalkan kolom di Pandas DataFrame \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menormalkan kolom di pandas DataFrame, termasuk contohnya.\" \/>\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\/menormalkan-kolom-kerangka-data-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menormalkan kolom di Pandas DataFrame \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menormalkan kolom di pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T02:28:10+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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/\",\"name\":\"Cara menormalkan kolom di Pandas DataFrame \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T02:28:10+00:00\",\"dateModified\":\"2023-07-28T02:28:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menormalkan kolom di pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menormalkan kolom di pandas dataframe\"}]},{\"@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 menormalkan kolom di Pandas DataFrame \u2013 Statorials","description":"Penjelasan sederhana tentang cara menormalkan kolom di pandas DataFrame, termasuk contohnya.","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\/menormalkan-kolom-kerangka-data-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menormalkan kolom di Pandas DataFrame \u2013 Statorials","og_description":"Penjelasan sederhana tentang cara menormalkan kolom di pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-28T02:28:10+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/","url":"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/","name":"Cara menormalkan kolom di Pandas DataFrame \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T02:28:10+00:00","dateModified":"2023-07-28T02:28:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menormalkan kolom di pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menormalkan-kolom-kerangka-data-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menormalkan kolom di pandas dataframe"}]},{"@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\/986"}],"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=986"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/986\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}