{"id":2928,"date":"2023-07-20T01:28:28","date_gmt":"2023-07-20T01:28:28","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/"},"modified":"2023-07-20T01:28:28","modified_gmt":"2023-07-20T01:28:28","slug":"panda-menggabungkan-beberapa-kerangka-data","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/","title":{"rendered":"Cara menggabungkan beberapa dataframe di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk menggabungkan beberapa DataFrame sekaligus di panda:<\/span><\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\nfrom<\/span> functools import<\/span> reduce\n\n#define list of DataFrames\n<\/span>dfs = [df1, df2, df3]\n\n#merge all DataFrames into one\n<\/span>final_df = reduce(lambda left,right: pd.merge<\/span> (left,right,on=[' column_name<\/span> '],\n                                            how=' outer<\/span> '), dfs)<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya:<\/span><\/p>\n
 Contoh: Gabungkan<\/span> beberapa DataFrame di Pandas<\/strong><\/h2>\n
 Misalkan kita memiliki tiga panda DataFrames berikut yang berisi informasi tentang pemain bola basket dari tim berbeda:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrames\n<\/span>df1 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D'],\n                    ' points<\/span> ': [18, 22, 19, 14]})\n\ndf2 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C'],\n                    ' assists<\/span> ': [4, 9, 14]})\n\ndf3 = pd. DataFrame<\/span> ({' team<\/span> ': ['C', 'D', 'E', 'F'],\n                    ' rebounds<\/span> ': [10, 17, 11, 10]})\n\n#view DataFrames\n<\/span>print<\/span> (df1)\n\n  team points\n0 to 18\n1 B 22\n2 C 19\n3 D 14\n\nprint<\/span> (df2)\n\n  team assists\n0 to 4\n1 B 9\n2 C 14\n\nprint<\/span> (df3)\n\n  team rebounds\n0 C 10\n1 D 17\n2 E 11\n3 F 10\n<\/strong><\/pre>\n
 Kita dapat menggunakan sintaks berikut untuk menggabungkan ketiga DataFrame menjadi satu:<\/span><\/p>\n
 from<\/span> functools import<\/span> reduce\n\n#define list of DataFrames\n<\/span>dfs = [df1, df2, df3]\n\n#merge all DataFrames into one\n<\/span>final_df = reduce(lambda left,right: pd.merge<\/span> (left,right,on=[' team<\/span> '],\n                                            how=' outer<\/span> '), dfs)\n\n#view merged DataFrame\n<\/span>print<\/span> (final_df)\n\n  team points assists rebounds\n0 A 18.0 4.0 NaN\n1 B 22.0 9.0 NaN\n2 C 19.0 14.0 10.0\n3 D 14.0 NaN 17.0\n4 E NaN NaN 11.0\n5 F NaN NaN 10.0<\/strong><\/span><\/pre>\n
 Hasil akhirnya adalah DataFrame yang berisi informasi dari ketiga DataFrame.<\/span><\/span><\/p>\n
 Perhatikan bahwa nilai NaN<\/strong> digunakan untuk mengisi sel kosong di DataFrame akhir.<\/span><\/p>\n
 Untuk menggunakan nilai selain NaN<\/strong> untuk mengisi sel kosong, Anda dapat menggunakan fungsi fillna()<\/strong> :<\/span><\/p>\n
 from<\/span> functools import<\/span> reduce\n\n#define list of DataFrames\n<\/span>dfs = [df1, df2, df3]\n\n#merge all DataFrames into one\n<\/span>final_df = reduce(lambda left,right: pd.merge<\/span> (left,right,on=[' team<\/span> '],\n                                            how=' outer<\/span> '), dfs). fillna<\/span> (' none<\/span> ')\n\n#view merged DataFrame\n<\/span>print<\/span> (final_df)\n\n  team points assists rebounds\n0 A 18.0 4.0 none\n1 B 22.0 9.0 none\n2 C 19.0 14.0 10.0\n3 D 14.0 none 17.0\n4 E none none 11.0\n5 F none none 10.0<\/strong><\/span><\/pre>\n
 Masing-masing sel kosong sekarang diisi dengan ” none<\/strong> ” dan bukan NaN<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi penggabungan<\/strong> di pandas di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Cara menggabungkan dua Pandas DataFrames di index
 Cara menggabungkan Pandas DataFrames di beberapa kolom<\/a>
 Cara menumpuk beberapa Pandas DataFrames<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut untuk menggabungkan beberapa DataFrame sekaligus di panda: import pandas as pd from functools import reduce #define list of DataFrames dfs = [df1, df2, df3] #merge all DataFrames into one final_df = reduce(lambda left,right: pd.merge (left,right,on=[‘ column_name ‘], how=’ outer ‘), dfs) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya: […]<\/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 Menggabungkan Beberapa DataFrame di Pandas (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan beberapa DataFrame menjadi satu di panda, 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\/panda-menggabungkan-beberapa-kerangka-data\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggabungkan Beberapa DataFrame di Pandas (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan beberapa DataFrame menjadi satu di panda, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T01:28:28+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-menggabungkan-beberapa-kerangka-data\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/\",\"name\":\"Cara Menggabungkan Beberapa DataFrame di Pandas (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T01:28:28+00:00\",\"dateModified\":\"2023-07-20T01:28:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan beberapa DataFrame menjadi satu di panda, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan beberapa dataframe di pandas (dengan contoh)\"}]},{\"@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 Menggabungkan Beberapa DataFrame di Pandas (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menggabungkan beberapa DataFrame menjadi satu di panda, 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\/panda-menggabungkan-beberapa-kerangka-data\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggabungkan Beberapa DataFrame di Pandas (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menggabungkan beberapa DataFrame menjadi satu di panda, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/","og_site_name":"Statorials","article_published_time":"2023-07-20T01:28:28+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-menggabungkan-beberapa-kerangka-data\/","url":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/","name":"Cara Menggabungkan Beberapa DataFrame di Pandas (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T01:28:28+00:00","dateModified":"2023-07-20T01:28:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan beberapa DataFrame menjadi satu di panda, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-beberapa-kerangka-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan beberapa dataframe di pandas (dengan contoh)"}]},{"@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\/2928"}],"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=2928"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2928\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}