{"id":971,"date":"2023-07-28T03:42:21","date_gmt":"2023-07-28T03:42:21","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membaca-csv\/"},"modified":"2023-07-28T03:42:21","modified_gmt":"2023-07-28T03:42:21","slug":"panda-membaca-csv","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membaca-csv\/","title":{"rendered":"Panduan utama: cara membaca file csv dengan pandas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">File CSV (nilai dipisahkan koma) adalah salah satu cara paling umum untuk menyimpan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, fungsi pandas <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.read_csv.html\" target=\"_blank\" rel=\"noopener noreferrer\">read_csv()<\/a> memungkinkan Anda membaca file CSV dengan mudah dengan Python dalam hampir semua format yang Anda inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan beberapa cara membaca file CSV dengan Python menggunakan file CSV berikut bernama <strong>&#8220;data.csv&#8221;<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>playerID,team,points\n1,Lakers,26\n2,Mavs,19\n3,Bucks,24\n4,Spurs,22<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Baca file CSV ke dalam pandas DataFrame<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membaca file CSV ke dalam pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import CSV file as DataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> ('data.csv')<\/strong><\/span>\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n        playerID team points\n0 1 Lakers 26\n1 2 Mavs 19\n2 3 Bucks 24\n3 4 Spurs 22<\/strong><\/span><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Membaca kolom tertentu dari file CSV<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membaca hanya kolom berlabel &#8220;playerID&#8221; dan &#8220;points&#8221; dari file CSV ke dalam pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import only specific columns from CSV file<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> ('data.csv', usecols=[' <span style=\"color: #008000;\">playerID<\/span> ',' <span style=\"color: #008000;\">points<\/span> '])<\/strong><\/span>\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n\tplayerID points\n0 1 26\n1 2 19\n2 3 24\n3 4 22<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Anda juga dapat menentukan indeks kolom untuk dibaca ke dalam DataFrame pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import only specific columns from CSV file<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> (' <span style=\"color: #008000;\">data.csv<\/span> ', usecols=[ <span style=\"color: #008000;\">0,1<\/span> ])<\/strong><\/span>\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n        playerID team\n0 1 Lakers\n1 2 Mavs\n2 3 Bucks\n3 4 Spurs<\/strong><\/span><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Tentukan baris header saat mengimpor file CSV<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Dalam beberapa kasus, baris header mungkin bukan baris pertama dalam file CSV.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, perhatikan file CSV berikut yang baris headernya sebenarnya muncul di baris kedua:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>random,data,values\nplayerID,team,points\n1,Lakers,26\n2,Mavs,19\n3,Bucks,24\n4,Spurs,22<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Untuk membaca file CSV ini ke dalam pandas DataFrame, kita dapat menentukan <strong>header=1<\/strong> sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import from CSV file and specify that header starts on second row<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> ('data.csv', header= <span style=\"color: #008000;\">1<\/span> )<\/strong><\/span>\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n        playerID team points\n0 1 Lakers 26\n1 2 Mavs 19\n2 3 Bucks 24\n3 4 Spurs 22<\/strong><\/span><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 4: Lewati baris saat mengimpor file CSV<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Anda juga dapat dengan mudah melewati baris saat mengimpor file CSV dengan menggunakan argumen <strong>skiprows<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kode berikut menunjukkan cara mengabaikan baris kedua saat mengimpor file CSV:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import from CSV file and skip second row<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> ('data.csv', skiprows=[ <span style=\"color: #008000;\">1 <span style=\"color: #000000;\">]<\/span><\/span> <span style=\"color: #000000;\">)<\/span><\/strong><\/span>\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n        playerID team points\n0 2 Mavs 19\n1 3 Bucks 24\n2 4 Spurs 22<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Dan kode berikut menunjukkan cara mengabaikan baris kedua <em>dan<\/em> ketiga saat mengimpor file CSV:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import from CSV file and skip second and third rows<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> ('data.csv', skiprows=[ <span style=\"color: #008000;\">1,2 <span style=\"color: #000000;\">]<\/span><\/span> <span style=\"color: #000000;\">)<\/span><\/strong><\/span>\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n        playerID team points\n1 3 Bucks 24\n2 4 Spurs 22<\/strong><\/span><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 5: Membaca file CSV dengan pembatas khusus<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terkadang Anda mungkin memiliki file CSV dengan pembatas selain koma.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, file CSV kita memiliki garis bawah sebagai pembatas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>playerID_team_points\n1_Lakers_26\n2_Mavs_19\n3_Bucks_24\n4_Spurs_22\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Untuk membaca file CSV ini ke dalam pandas, kita dapat menggunakan argumen <strong>sep<\/strong> untuk menentukan pembatas yang akan digunakan saat membaca file:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import from CSV file and specify delimiter to use<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> ('data.csv', sep=' <span style=\"color: #993300;\">_<\/span> ')<\/strong><\/span>\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n\tplayerID team points\n0 1 Lakers 26\n1 2 Mavs 19\n2 3 Bucks 24\n3 4 Spurs 22<\/strong><\/span><\/pre>\n<h2> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas panda umum lainnya:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-file-teks\/\" target=\"_blank\" rel=\"noopener\">Cara membaca file teks dengan Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-excel\/\" target=\"_blank\" rel=\"noopener\">Cara membaca file Excel dengan Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-tsv\/\" target=\"_blank\" rel=\"noopener\">Cara membaca file TSV dengan Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-html\/\" target=\"_blank\" rel=\"noopener\">Cara membaca tabel HTML dengan Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>File CSV (nilai dipisahkan koma) adalah salah satu cara paling umum untuk menyimpan data. Untungnya, fungsi pandas read_csv() memungkinkan Anda membaca file CSV dengan mudah dengan Python dalam hampir semua format yang Anda inginkan. Tutorial ini menjelaskan beberapa cara membaca file CSV dengan Python menggunakan file CSV berikut bernama &#8220;data.csv&#8221; : playerID,team,points 1,Lakers,26 2,Mavs,19 3,Bucks,24 [&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>Panduan Utama: Cara Membaca File CSV dengan Pandas - Statorials<\/title>\n<meta name=\"description\" content=\"Panduan lengkap membaca file CSV di pandas, termasuk beberapa 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-membaca-csv\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Panduan Utama: Cara Membaca File CSV dengan Pandas - Statorials\" \/>\n<meta property=\"og:description\" content=\"Panduan lengkap membaca file CSV di pandas, termasuk beberapa contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T03:42:21+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-membaca-csv\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-csv\/\",\"name\":\"Panduan Utama: Cara Membaca File CSV dengan Pandas - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T03:42:21+00:00\",\"dateModified\":\"2023-07-28T03:42:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Panduan lengkap membaca file CSV di pandas, termasuk beberapa contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-csv\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-csv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Panduan utama: cara membaca file csv dengan pandas\"}]},{\"@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":"Panduan Utama: Cara Membaca File CSV dengan Pandas - Statorials","description":"Panduan lengkap membaca file CSV di pandas, termasuk beberapa 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-membaca-csv\/","og_locale":"id_ID","og_type":"article","og_title":"Panduan Utama: Cara Membaca File CSV dengan Pandas - Statorials","og_description":"Panduan lengkap membaca file CSV di pandas, termasuk beberapa contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-csv\/","og_site_name":"Statorials","article_published_time":"2023-07-28T03:42:21+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-membaca-csv\/","url":"https:\/\/statorials.org\/id\/panda-membaca-csv\/","name":"Panduan Utama: Cara Membaca File CSV dengan Pandas - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T03:42:21+00:00","dateModified":"2023-07-28T03:42:21+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Panduan lengkap membaca file CSV di pandas, termasuk beberapa contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-csv\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-csv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Panduan utama: cara membaca file csv dengan pandas"}]},{"@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\/971"}],"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=971"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/971\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}