{"id":4130,"date":"2023-07-13T09:43:42","date_gmt":"2023-07-13T09:43:42","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/"},"modified":"2023-07-13T09:43:42","modified_gmt":"2023-07-13T09:43:42","slug":"panda-menggabungkan-file-csv","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/","title":{"rendered":"Cara menggabungkan banyak file csv di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan beberapa file CSV yang terletak di folder yang sama ke dalam pandas DataFrame:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\nimport<\/span> glob\nimport<\/span> bone\n\n#define path to CSV files\n<\/span>path = r' C:\\Users\\bob\\Documents\\my_data_files<\/span> '\n\n#identify all CSV files\n<\/span>all_files = glob. glob<\/span> ( os.path.join<\/span> (\" *.csv<\/span> \"<\/span> ))\n\n#merge all CSV files into one DataFrame\n<\/span>df = pd. concat<\/span> ((pd. read_csv<\/span> (f) for<\/span> f in<\/span> all_files), ignore_index= True<\/span> )\n<\/span><\/span><\/strong><\/pre>\n
 Contoh khusus ini akan menggabungkan semua file CSV yang terletak di folder bernama my_data_files<\/strong> menjadi satu Pandas DataFrame.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Menggabungkan beberapa file CSV di Pandas<\/strong><\/span><\/h2>\n
 Katakanlah saya memiliki folder di komputer saya bernama my_data_files<\/strong> yang berisi tiga file CSV:<\/span> <\/p>\n
\"\"<\/p>\n
 Setiap file CSV berisi dua kolom yang disebut poin<\/strong> dan assist<\/strong> , yang mewakili poin dan assist dari pemain bola basket yang berbeda.<\/span><\/p>\n
 Berikut tampilan CSV pertama yang disebut df1<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat menggunakan sintaks berikut untuk menggabungkan tiga file CSV dalam folder menjadi satu pandas DataFrame:<\/span><\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\nimport<\/span> glob\nimport<\/span> bone\n\n#define path to CSV files\n<\/span>path = r' C:\\Users\\bob\\Documents\\my_data_files<\/span> '\n\n#identify all CSV files\n<\/span>all_files = glob. glob<\/span> ( os.path.join<\/span> (\" *.csv<\/span> \"<\/span> ))\n\n#merge all CSV files into one DataFrame\n<\/span>df = pd. concat<\/span> ((pd. read_csv<\/span> (f) for<\/span> f in<\/span> all_files), ignore_index= True<\/span> )\n\n#view resulting DataFrame<\/span>\nprint<\/span> (df)\n\n    assist points\n0 4 3\n1 5 2\n2 5 4\n3 6 4\n4 8 6\n5 9 3\n6 2 3\n7 10 2\n8 14 9\n9 15 3\n10 6 10\n11 8 6\n12 9 4\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa ketiga file CSV telah berhasil diimpor dan digabungkan menjadi satu DataFrame.<\/span><\/p>\n
 DataFrame akhir berisi 13 baris dan 2 kolom.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas read_csv()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya dengan Python:<\/span><\/p>\n
 Pandas: Cara melewati baris saat membaca file CSV<\/a>
 Pandas: Cara menambahkan data ke file CSV yang sudah ada<\/a>
 Pandas: Cara menentukan tipe saat mengimpor file CSV<\/a>
 Pandas: Cara mengatur nama kolom saat mengimpor file CSV<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan beberapa file CSV yang terletak di folder yang sama ke dalam pandas DataFrame: import pandas as pd import glob import bone #define path to CSV files path = r’ C:\\Users\\bob\\Documents\\my_data_files ‘ #identify all CSV files all_files = glob. glob ( os.path.join (” *.csv ” )) #merge all […]<\/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 File CSV di Pandas (dengan Contoh) \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan beberapa file CSV di pandas, dengan 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\/panda-menggabungkan-file-csv\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggabungkan Beberapa File CSV di Pandas (dengan Contoh) \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan beberapa file CSV di pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T09:43:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fusioncsv1.jpg\" \/>\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-file-csv\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/\",\"name\":\"Cara Menggabungkan Beberapa File CSV di Pandas (dengan Contoh) \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T09:43:42+00:00\",\"dateModified\":\"2023-07-13T09:43:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan beberapa file CSV di pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan banyak file csv 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 File CSV di Pandas (dengan Contoh) \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggabungkan beberapa file CSV di pandas, dengan 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\/panda-menggabungkan-file-csv\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggabungkan Beberapa File CSV di Pandas (dengan Contoh) \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggabungkan beberapa file CSV di pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/","og_site_name":"Statorials","article_published_time":"2023-07-13T09:43:42+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fusioncsv1.jpg"}],"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-file-csv\/","url":"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/","name":"Cara Menggabungkan Beberapa File CSV di Pandas (dengan Contoh) \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T09:43:42+00:00","dateModified":"2023-07-13T09:43:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan beberapa file CSV di pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan banyak file csv 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\/4130"}],"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=4130"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4130\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}