{"id":3536,"date":"2023-07-16T23:28:53","date_gmt":"2023-07-16T23:28:53","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/"},"modified":"2023-07-16T23:28:53","modified_gmt":"2023-07-16T23:28:53","slug":"pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/","title":{"rendered":"Pandas: cara menggabungkan baris dengan nilai kolom yang sama"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan baris dengan nilai kolom yang sama di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define how to aggregate various fields\n<\/span>agg_functions = {' <span style=\"color: #ff0000;\">field1<\/span> ': ' <span style=\"color: #ff0000;\">first<\/span> ', ' <span style=\"color: #ff0000;\">field2<\/span> ': ' <span style=\"color: #ff0000;\">sum<\/span> ', ' <span style=\"color: #ff0000;\">field<\/span> ': ' <span style=\"color: #ff0000;\">sum<\/span> '}\n\n<span style=\"color: #008080;\">#create new DataFrame by combining rows with same id values\n<\/span>df_new = df. <span style=\"color: #3366ff;\">groupby<\/span> (df[' <span style=\"color: #ff0000;\">id<\/span> ']). <span style=\"color: #3366ff;\">aggregate<\/span> (agg_functions)\n<\/strong><\/pre>\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: Gabungkan Baris dengan Nilai Kolom yang Sama di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut yang berisi informasi tentang penjualan dan pengembalian yang dilakukan oleh berbagai karyawan suatu perusahaan:<\/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;\">#create dataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">id<\/span> ': [101, 101, 102, 103, 103, 103],\n                   ' <span style=\"color: #ff0000;\">employee<\/span> ': ['Dan', 'Dan', 'Rick', 'Ken', 'Ken', 'Ken'],\n                   ' <span style=\"color: #ff0000;\">sales<\/span> ': [4, 1, 3, 2, 5, 3],\n                   ' <span style=\"color: #ff0000;\">returns<\/span> ': [1, 2, 2, 1, 3, 2]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n    id employee sales returns\n0 101 Dan 4 1\n1 101 Dan 1 2\n2 102 Rick 3 2\n3 103 Ken 2 1\n4 103 Ken 5 3\n5 103 Ken 3 2<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menggabungkan baris yang memiliki nilai yang sama di kolom <strong>id<\/strong> dan kemudian menggabungkan kolom yang tersisa:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define how to aggregate various fields\n<\/span>agg_functions = {' <span style=\"color: #ff0000;\">employee<\/span> ': ' <span style=\"color: #ff0000;\">first<\/span> ', ' <span style=\"color: #ff0000;\">sales<\/span> ': ' <span style=\"color: #ff0000;\">sum<\/span> ', ' <span style=\"color: #ff0000;\">returns<\/span> ': ' <span style=\"color: #ff0000;\">sum<\/span> '}\n\n<span style=\"color: #008080;\">#create new DataFrame by combining rows with same id values\n<\/span>df_new = df. <span style=\"color: #3366ff;\">groupby<\/span> (df[' <span style=\"color: #ff0000;\">id<\/span> ']). <span style=\"color: #3366ff;\">aggregate<\/span> (agg_functions)\n\n<span style=\"color: #008080;\">#view new DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df_new)\n\n    employee sales returns\nid                          \n101 Dan 5 3\n102 Rick 3 2\n103 Ken 10 6\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">DataFrame baru menggabungkan semua baris dari DataFrame sebelumnya yang memiliki nilai yang sama pada kolom <strong>id<\/strong> , kemudian menghitung jumlah nilai pada kolom <strong>penjualan<\/strong> dan <strong>pengembalian<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Lihat <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/groupby.html\" target=\"_blank\" rel=\"noopener\">dokumentasi pandas<\/a> untuk daftar lengkap agregasi yang tersedia untuk digunakan dengan fungsi <strong>GroupBy()<\/strong> .<\/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 tugas umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/perbedaan-panda-antara-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mencari selisih antara dua kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perbedaan-panda-antar-baris\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mencari perbedaan antara dua garis<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mengurutkan-kolom-berdasarkan-nama\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengurutkan kolom berdasarkan nama<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan baris dengan nilai kolom yang sama di pandas DataFrame: #define how to aggregate various fields agg_functions = {&#8216; field1 &#8216;: &#8216; first &#8216;, &#8216; field2 &#8216;: &#8216; sum &#8216;, &#8216; field &#8216;: &#8216; sum &#8216;} #create new DataFrame by combining rows with same id values df_new = [&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 menggabungkan baris dengan nilai kolom yang sama \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan baris dengan nilai kolom yang sama di panda, beserta 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\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggabungkan baris dengan nilai kolom yang sama \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan baris dengan nilai kolom yang sama di panda, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T23:28:53+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\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/\",\"name\":\"Pandas: Cara menggabungkan baris dengan nilai kolom yang sama \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T23:28:53+00:00\",\"dateModified\":\"2023-07-16T23:28:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan baris dengan nilai kolom yang sama di panda, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggabungkan baris dengan nilai kolom yang sama\"}]},{\"@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 menggabungkan baris dengan nilai kolom yang sama \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggabungkan baris dengan nilai kolom yang sama di panda, beserta 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\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggabungkan baris dengan nilai kolom yang sama \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggabungkan baris dengan nilai kolom yang sama di panda, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/","og_site_name":"Statorials","article_published_time":"2023-07-16T23:28:53+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\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/","url":"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/","name":"Pandas: Cara menggabungkan baris dengan nilai kolom yang sama \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T23:28:53+00:00","dateModified":"2023-07-16T23:28:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan baris dengan nilai kolom yang sama di panda, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-menggabungkan-baris-dengan-nilai-kolom-yang-sama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggabungkan baris dengan nilai kolom yang sama"}]},{"@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\/3536"}],"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=3536"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3536\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}