{"id":2469,"date":"2023-07-22T03:30:18","date_gmt":"2023-07-22T03:30:18","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/"},"modified":"2023-07-22T03:30:18","modified_gmt":"2023-07-22T03:30:18","slug":"panda-membagi-kerangka-data-berdasarkan-nilai-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/","title":{"rendered":"Pandas: cara membagi dataframe berdasarkan nilai kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk membagi pandas DataFrame berdasarkan nilai kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define value to split on<\/span>\nx = 20\n\n<span style=\"color: #008080;\">#define df1 as DataFrame where 'column_name' is &gt;= 20<\/span>\ndf1 = df[df[' <span style=\"color: #ff0000;\">column_name<\/span> '] <span style=\"color: #800080;\">&gt;=<\/span> x]\n\n<span style=\"color: #008080;\">#define df2 as DataFrame where 'column_name' is &lt; 20<\/span>\ndf2 = df[df[' <span style=\"color: #ff0000;\">column_name<\/span> '] <span style=\"color: #800080;\">&lt;<\/span> x]\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Pisahkan Pandas DataFrame berdasarkan Nilai Kolom<\/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: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame\n<span style=\"color: #000000;\">df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [22, 24, 19, 18, 14, 29, 31, 16],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n        team points rebounds\n0 to 22 11\n1 B 24 8\n2 C 19 10\n3 D 18 6\n4 E 14 6\n5 F 29 5\n6 G 31 9\n7:16:12<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk membagi DataFrame menjadi dua DataFrame yang mana yang pertama berisi baris yang &#8220;titiknya&#8221; lebih besar atau sama dengan 20 dan yang kedua berisi baris yang &#8220;titiknya&#8221; kurang dari 20:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define value to split on<\/span>\nx = 20\n\n<span style=\"color: #008080;\">#define df1 as DataFrame where 'points' is &gt;= 20<\/span>\ndf1 = df[df[' <span style=\"color: #ff0000;\">points<\/span> '] <span style=\"color: #800080;\">&gt;=<\/span> x]\n\n<span style=\"color: #008000;\">print<\/span> (df1)\n\n  team points rebounds\n0 to 22 11\n1 B 24 8\n5 F 29 5\n6 G 31 9\n\n<span style=\"color: #008080;\">#define df2 as DataFrame where 'points' is &lt; 20<\/span>\ndf2 = df[df[' <span style=\"color: #ff0000;\">points<\/span> '] <span style=\"color: #800080;\">&lt;<\/span> x]\n\n<span style=\"color: #008000;\">print<\/span> (df2)\n\n  team points rebounds\n2 C 19 10\n3 D 18 6\n4 E 14 6\n7:16:12\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menggunakan fungsi <strong>reset_index()<\/strong> untuk mengatur ulang nilai indeks untuk setiap DataFrame yang dihasilkan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define value to split on<\/span>\nx = 20\n\n<span style=\"color: #008080;\">#define df1 as DataFrame where 'points' is &gt;= 20<\/span>\ndf1 = df[df[' <span style=\"color: #ff0000;\">points<\/span> '] <span style=\"color: #800080;\">&gt;=<\/span> x]. <span style=\"color: #3366ff;\">reset_index<\/span> (drop= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008000;\">print<\/span> (df1)\n\n  team points rebounds\n0 to 22 11\n1 B 24 8\n2 F 29 5\n3 G 31 9\n\n<span style=\"color: #008080;\">#define df2 as DataFrame where 'points' is &lt; 20<\/span>\ndf2 = df[df[' <span style=\"color: #ff0000;\">points<\/span> '] <span style=\"color: #800080;\">&lt;<\/span> x]. <span style=\"color: #3366ff;\">reset_index<\/span> (drop= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008000;\">print<\/span> (df2)\n\n  team points rebounds\n0 C 19 10\n1 D 18 6\n2 E 14 6\n3:16:12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa indeks setiap DataFrame yang dihasilkan sekarang dimulai dari 0.<\/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 memperbaiki kesalahan umum lainnya dengan Python:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kesalahan-kunci-panda\/\" target=\"_blank\" rel=\"noopener\">Cara Memperbaiki KeyError di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/valueerror-tidak-dapat-mengubah-float-nan-menjadi-integer\/\" target=\"_blank\" rel=\"noopener\">Cara Memperbaiki: ValueError: Tidak dapat mengubah float NaN menjadi int<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/operan-tidak-dapat-disiarkan-dengan-formulir\/\" target=\"_blank\" rel=\"noopener\">Cara Memperbaiki: ValueError: Operan tidak dapat disiarkan dengan bentuk<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk membagi pandas DataFrame berdasarkan nilai kolom: #define value to split on x = 20 #define df1 as DataFrame where &#8216;column_name&#8217; is &gt;= 20 df1 = df[df[&#8216; column_name &#8216;] &gt;= x] #define df2 as DataFrame where &#8216;column_name&#8217; is &lt; 20 df2 = df[df[&#8216; column_name &#8216;] &lt; x] Contoh berikut [&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 membagi DataFrame berdasarkan nilai kolom - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membagi pandas DataFrame berdasarkan nilai kolom, 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\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara membagi DataFrame berdasarkan nilai kolom - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membagi pandas DataFrame berdasarkan nilai kolom, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T03:30:18+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\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/\",\"name\":\"Pandas: Cara membagi DataFrame berdasarkan nilai kolom - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T03:30:18+00:00\",\"dateModified\":\"2023-07-22T03:30:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membagi pandas DataFrame berdasarkan nilai kolom, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara membagi dataframe berdasarkan nilai kolom\"}]},{\"@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 membagi DataFrame berdasarkan nilai kolom - Statorials","description":"Tutorial ini menjelaskan cara membagi pandas DataFrame berdasarkan nilai kolom, 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\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara membagi DataFrame berdasarkan nilai kolom - Statorials","og_description":"Tutorial ini menjelaskan cara membagi pandas DataFrame berdasarkan nilai kolom, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-22T03:30:18+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\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/","url":"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/","name":"Pandas: Cara membagi DataFrame berdasarkan nilai kolom - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T03:30:18+00:00","dateModified":"2023-07-22T03:30:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membagi pandas DataFrame berdasarkan nilai kolom, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membagi-kerangka-data-berdasarkan-nilai-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara membagi dataframe berdasarkan nilai kolom"}]},{"@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\/2469"}],"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=2469"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2469\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}