{"id":4133,"date":"2023-07-13T09:07:15","date_gmt":"2023-07-13T09:07:15","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/"},"modified":"2023-07-13T09:07:15","modified_gmt":"2023-07-13T09:07:15","slug":"pandas-ke-csv-kolom-tertentu","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/","title":{"rendered":"Pandas: ekspor kolom tertentu di dataframe ke file csv"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk hanya mengekspor kolom tertentu dari pandas DataFrame ke file CSV:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_csv<\/span> (' <span style=\"color: #ff0000;\">my_data.csv<\/span> ', columns=[' <span style=\"color: #ff0000;\">col1<\/span> ',' <span style=\"color: #ff0000;\">col4<\/span> ',' <span style=\"color: #ff0000;\">col6<\/span> '])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Argumen <strong>kolom<\/strong> memberi tahu panda kolom spesifik mana yang akan diekspor dari DataFrame ke file CSV.<\/span><\/p>\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: Ekspor kolom tertentu dari Pandas DataFrame ke file CSV<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/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<\/span>\ndf = 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> ': [18, 22, 19, 14, 14, 11, 20, 28],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\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 assists rebounds\n0 A 18 5 11\n1 B 22 7 8\n2 C 19 7 10\n3 D 14 9 6\n4 E 14 12 6\n5 F 11 9 5\n6 G 20 9 9\n7:28 4 12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika kita menggunakan fungsi <strong>to_csv()<\/strong> untuk mengekspor DataFrame ke file CSV, panda akan mengekspor semua kolom secara default:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#export DataFrame to CSV file<\/span>\ndf. <span style=\"color: #3366ff;\">to_csv<\/span> (' <span style=\"color: #ff0000;\">basketball_data.csv<\/span> ')\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Berikut tampilan file CSVnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32843 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/il1-1.png\" alt=\"\" width=\"487\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua kolom di DataFrame disertakan dalam file CSV.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengekspor hanya kolom tertentu dari DataFrame ke file CSV, kita dapat menggunakan argumen <strong>kolom<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan sintaks berikut untuk mengekspor hanya <strong>tim<\/strong> dan <strong>memantulkan<\/strong> kolom ke file CSV:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#export only team and rebounds columns from DataFrame to CSV file<\/span><span style=\"color: #000000;\">\ndf.<\/span> <span style=\"color: #3366ff;\">to_csv<\/span> <span style=\"color: #000000;\">('<\/span> <span style=\"color: #ff0000;\">basketball_data.csv<\/span> <span style=\"color: #000000;\">', columns=[' <span style=\"color: #ff0000;\">team<\/span> ',' <span style=\"color: #ff0000;\">rebounds<\/span> ']<\/span> <span style=\"color: #000000;\">)<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Berikut tampilan file CSVnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32849 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/specification1-1.png\" alt=\"\" width=\"502\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya kolom <strong>tim<\/strong> dan <strong>rebound<\/strong> yang disertakan dalam file CSV.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>to_csv()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.to_csv.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/panda-di-csv-tanpa-header\/\">Cara mengekspor data ke file CSV tanpa header di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menggabungkan-file-csv\/\">Cara menggabungkan beberapa file CSV di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-membaca-csv-hanya-baris-tertentu\/\" target=\"_blank\" rel=\"noopener\">Cara membaca hanya baris tertentu dari file CSV di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk hanya mengekspor kolom tertentu dari pandas DataFrame ke file CSV: df. to_csv (&#8216; my_data.csv &#8216;, columns=[&#8216; col1 &#8216;,&#8217; col4 &#8216;,&#8217; col6 &#8216;]) Argumen kolom memberi tahu panda kolom spesifik mana yang akan diekspor dari DataFrame ke file CSV. Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Ekspor [&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: Ekspor kolom tertentu di DataFrame ke file CSV - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekspor hanya kolom tertentu dari pandas DataFrame ke file CSV, 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\/pandas-ke-csv-kolom-tertentu\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Ekspor kolom tertentu di DataFrame ke file CSV - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekspor hanya kolom tertentu dari pandas DataFrame ke file CSV, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T09:07:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/il1-1.png\" \/>\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-ke-csv-kolom-tertentu\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/\",\"name\":\"Pandas: Ekspor kolom tertentu di DataFrame ke file CSV - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T09:07:15+00:00\",\"dateModified\":\"2023-07-13T09:07:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekspor hanya kolom tertentu dari pandas DataFrame ke file CSV, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: ekspor kolom tertentu di dataframe ke file csv\"}]},{\"@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: Ekspor kolom tertentu di DataFrame ke file CSV - Statorials","description":"Tutorial ini menjelaskan cara mengekspor hanya kolom tertentu dari pandas DataFrame ke file CSV, 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\/pandas-ke-csv-kolom-tertentu\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Ekspor kolom tertentu di DataFrame ke file CSV - Statorials","og_description":"Tutorial ini menjelaskan cara mengekspor hanya kolom tertentu dari pandas DataFrame ke file CSV, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/","og_site_name":"Statorials","article_published_time":"2023-07-13T09:07:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/il1-1.png"}],"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-ke-csv-kolom-tertentu\/","url":"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/","name":"Pandas: Ekspor kolom tertentu di DataFrame ke file CSV - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T09:07:15+00:00","dateModified":"2023-07-13T09:07:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekspor hanya kolom tertentu dari pandas DataFrame ke file CSV, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-ke-csv-kolom-tertentu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: ekspor kolom tertentu di dataframe ke file csv"}]},{"@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\/4133"}],"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=4133"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4133\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}