{"id":26338,"date":"2021-12-17T08:43:04","date_gmt":"2021-12-17T03:13:04","guid":{"rendered":"https:\/\/python-programs.com\/?p=26338"},"modified":"2021-12-17T08:43:04","modified_gmt":"2021-12-17T03:13:04","slug":"in-python-how-do-you-save-a-dataframe-as-a-csv-file","status":"publish","type":"post","link":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/","title":{"rendered":"In Python, How Do you Save a Dataframe as a csv File?"},"content":{"rendered":"<p><strong>Pandas Module in Python:<\/strong><\/p>\n<p>Pandas is an open-source library based on the NumPy library. It enables users to perform effective data analysis, cleaning, and preparation. Pandas is fast, and it provides users with high performance and productivity.<\/p>\n<p>The majority of the datasets you work with are referred to as DataFrames. DataFrames is a 2-Dimensional labeled Data Structure containing indexes for rows and columns, and each cell can store any form of value. DataFrames are simply Dictionary-based NumPy Arrays.<\/p>\n<h4>Creating a Dataframe<\/h4>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import os module using the import keyword.<\/li>\n<li>Import pandas module using the import keyword.<\/li>\n<li>Give some random list(fruits) as static input and store it in a variable.<\/li>\n<li>Create a dictionary for the list of the above fruits and store it in another variable.<\/li>\n<li>Pass the above fruit_dictnry as an argument to the pandas.DataFrame() function to create a dataframe for the above dictionary.<\/li>\n<li>\n<div>Print the above-obtained dataframe.<\/div>\n<\/li>\n<li>\n<div><span style=\"font-size: 16px;\">The Exit of the Program.<\/span><\/div>\n<\/li>\n<\/ul>\n<p><strong>Below is the implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\"># Import os module using the import keyword.\r\nimport os\r\n# Import pandas module using the import keyword.\r\nimport pandas\r\n# Give some random list(fruits) as static input and store it in a variable.\r\nfruit_lst = [\"Apple\", \"mango\", \"banana\", \"orange\", \"grapes\", \"Kiwi\"]\r\n# Create a dictionary for the above fruits list and store it in another variable.\r\nfruit_dictnry = {'Types of Fruits': fruit_lst}\r\n# Pass the above fruit_dictnry as an argument to the pandas.DataFrame() function\r\n# to create a dataframe for the above dictionary.\r\nrslt_dataframe = pandas.DataFrame(fruit_dictnry)\r\n# Print the above obtained dataframe.\r\nprint(rslt_dataframe)<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\"> Types of Fruits\r\n0           Apple\r\n1           mango\r\n2          banana\r\n3          orange\r\n4          grapes\r\n5            Kiwi<\/pre>\n<h4>How to Save this Dataframe?<\/h4>\n<p>We frequently encounter circumstances in which we need to save large amounts of data generated by scraping or analysis in an easy, accesible\u00a0\u00a0and readable form\u00a0rather shareable form.<\/p>\n<p>We can achieve this now by storing the data frame as a<strong> csv<\/strong> file.<\/p>\n<pre>dataframe.to_csv('filename.csv')<\/pre>\n<p>We can save a data frame as a CSV file using the <strong>pandas.to_csv()<\/strong> function. The file name must be passed as a parameter to the method.<\/p>\n<p><strong>Example<\/strong><\/p>\n<p><strong>Approach:<\/strong><\/p>\n<ul>\n<li>Import os module using the import keyword.<\/li>\n<li>Import pandas module using the import keyword.<\/li>\n<li>Give some random list(fruits) as static input and store it in a variable.<\/li>\n<li>Create a dictionary for the list of the above fruits and store it in another variable.<\/li>\n<li>Pass the above fruit_dictnry as an argument to the pandas.DataFrame() function to create a dataframe for the above dictionary.<\/li>\n<li>\n<div>Save the above dataframe as a CSV file using the to_csv() function by passing some random file name as an argument that you want to save with.<\/div>\n<\/li>\n<li>\n<div>Now the file will be saved as a csv file.<\/div>\n<\/li>\n<li>\n<div><span style=\"font-size: 16px;\">The Exit of the Program.<\/span><\/div>\n<\/li>\n<\/ul>\n<p><strong>Below is the implementation:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\">from pandas.core.frame import DataFrame\r\n# Import os module using the import keyword.\r\nimport os\r\n# Import pandas module using the import keyword.\r\nimport pandas\r\n# Give some random list(fruits) as static input and store it in a variable.\r\nfruit_lst = [\"Apple\", \"mango\", \"banana\", \"orange\", \"grapes\", \"Kiwi\"]\r\n# Create a dictionary for the above fruits list and store it in another variable.\r\nfruit_dictnry = {'Types of Fruits': fruit_lst}\r\n# Pass the above fruit_dictnry as an argument to the pandas.DataFrame() function\r\n# to create a dataframe for the above dictionary.\r\nrslt_dataframe = pandas.DataFrame(fruit_dictnry)\r\n# Save the above dataframe as a CSV file using the to_csv() function by passing \r\n# some random file name as an argument that you want to save with.\r\nrslt_dataframe.to_csv('fruits.csv')<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<table class=\"google-visualization-table-table\" style=\"height: 294px;\" width=\"534\" cellspacing=\"0\">\n<thead>\n<tr class=\"google-visualization-table-tr-head\">\n<th class=\"google-visualization-table-th gradient unsorted\" tabindex=\"0\" role=\"button\" aria-label=\"Sort column\"><\/th>\n<th class=\"google-visualization-table-th gradient unsorted\" tabindex=\"0\" role=\"button\" aria-label=\"Sort column\">Types of Fruits<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr class=\"google-visualization-table-tr-even\">\n<td class=\"google-visualization-table-td\" colspan=\"1\">0<\/td>\n<td class=\"google-visualization-table-td\" colspan=\"1\">Apple<\/td>\n<\/tr>\n<tr class=\"google-visualization-table-tr-odd\">\n<td class=\"google-visualization-table-td\" colspan=\"1\">1<\/td>\n<td class=\"google-visualization-table-td\" colspan=\"1\">mango<\/td>\n<\/tr>\n<tr class=\"google-visualization-table-tr-even\">\n<td class=\"google-visualization-table-td\" colspan=\"1\">2<\/td>\n<td class=\"google-visualization-table-td\" colspan=\"1\">banana<\/td>\n<\/tr>\n<tr class=\"google-visualization-table-tr-odd\">\n<td class=\"google-visualization-table-td\" colspan=\"1\">3<\/td>\n<td class=\"google-visualization-table-td\" colspan=\"1\">orange<\/td>\n<\/tr>\n<tr class=\"google-visualization-table-tr-even\">\n<td class=\"google-visualization-table-td\" colspan=\"1\">4<\/td>\n<td class=\"google-visualization-table-td\" colspan=\"1\">grapes<\/td>\n<\/tr>\n<tr class=\"google-visualization-table-tr-odd google-visualization-table-tr-sel\">\n<td class=\"google-visualization-table-td\" colspan=\"1\">5<\/td>\n<td class=\"google-visualization-table-td\" colspan=\"1\">Kiwi<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pandas Module in Python: Pandas is an open-source library based on the NumPy library. It enables users to perform effective data analysis, cleaning, and preparation. Pandas is fast, and it provides users with high performance and productivity. The majority of the datasets you work with are referred to as DataFrames. DataFrames is a 2-Dimensional labeled &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/\"> <span class=\"screen-reader-text\">In Python, How Do you Save a Dataframe as a csv File?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[5],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>In Python, How Do you Save a Dataframe as a csv File? - Python Programs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"In Python, How Do you Save a Dataframe as a csv File? - Python Programs\" \/>\n<meta property=\"og:description\" content=\"Pandas Module in Python: Pandas is an open-source library based on the NumPy library. It enables users to perform effective data analysis, cleaning, and preparation. Pandas is fast, and it provides users with high performance and productivity. The majority of the datasets you work with are referred to as DataFrames. DataFrames is a 2-Dimensional labeled &hellip; In Python, How Do you Save a Dataframe as a csv File? Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Python Programs\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/btechgeeks\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-17T03:13:04+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:site\" content=\"@btech_geeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vikram Chiluka\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/python-programs.com\/#organization\",\"name\":\"BTech Geeks\",\"url\":\"https:\/\/python-programs.com\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/btechgeeks\/\",\"https:\/\/www.linkedin.com\/in\/btechgeeks\",\"https:\/\/in.pinterest.com\/btechgeek\/\",\"https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg\",\"https:\/\/www.facebook.com\/btechgeeks\",\"https:\/\/twitter.com\/btech_geeks\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"contentUrl\":\"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png\",\"width\":350,\"height\":70,\"caption\":\"BTech Geeks\"},\"image\":{\"@id\":\"https:\/\/python-programs.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/python-programs.com\/#website\",\"url\":\"https:\/\/python-programs.com\/\",\"name\":\"Python Programs\",\"description\":\"Python Programs with Examples, How To Guides on Python\",\"publisher\":{\"@id\":\"https:\/\/python-programs.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/python-programs.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#webpage\",\"url\":\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/\",\"name\":\"In Python, How Do you Save a Dataframe as a csv File? - Python Programs\",\"isPartOf\":{\"@id\":\"https:\/\/python-programs.com\/#website\"},\"datePublished\":\"2021-12-17T03:13:04+00:00\",\"dateModified\":\"2021-12-17T03:13:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/python-programs.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"In Python, How Do you Save a Dataframe as a csv File?\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#webpage\"},\"author\":{\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/fb109fd98e2d5a15fd4dac9970797602\"},\"headline\":\"In Python, How Do you Save a Dataframe as a csv File?\",\"datePublished\":\"2021-12-17T03:13:04+00:00\",\"dateModified\":\"2021-12-17T03:13:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#webpage\"},\"wordCount\":374,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/python-programs.com\/#organization\"},\"articleSection\":[\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/fb109fd98e2d5a15fd4dac9970797602\",\"name\":\"Vikram Chiluka\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/python-programs.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c56c77f578d45de43af6feb443618ed7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c56c77f578d45de43af6feb443618ed7?s=96&d=mm&r=g\",\"caption\":\"Vikram Chiluka\"},\"url\":\"https:\/\/python-programs.com\/author\/vikram\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"In Python, How Do you Save a Dataframe as a csv File? - Python Programs","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:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/","og_locale":"en_US","og_type":"article","og_title":"In Python, How Do you Save a Dataframe as a csv File? - Python Programs","og_description":"Pandas Module in Python: Pandas is an open-source library based on the NumPy library. It enables users to perform effective data analysis, cleaning, and preparation. Pandas is fast, and it provides users with high performance and productivity. The majority of the datasets you work with are referred to as DataFrames. DataFrames is a 2-Dimensional labeled &hellip; In Python, How Do you Save a Dataframe as a csv File? Read More &raquo;","og_url":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/","og_site_name":"Python Programs","article_publisher":"https:\/\/www.facebook.com\/btechgeeks","article_published_time":"2021-12-17T03:13:04+00:00","twitter_card":"summary_large_image","twitter_creator":"@btech_geeks","twitter_site":"@btech_geeks","twitter_misc":{"Written by":"Vikram Chiluka","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/python-programs.com\/#organization","name":"BTech Geeks","url":"https:\/\/python-programs.com\/","sameAs":["https:\/\/www.instagram.com\/btechgeeks\/","https:\/\/www.linkedin.com\/in\/btechgeeks","https:\/\/in.pinterest.com\/btechgeek\/","https:\/\/www.youtube.com\/channel\/UC9MlCqdJ3lKqz2p5114SDIg","https:\/\/www.facebook.com\/btechgeeks","https:\/\/twitter.com\/btech_geeks"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/","url":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","contentUrl":"https:\/\/python-programs.com\/wp-content\/uploads\/2020\/11\/BTechGeeks.png","width":350,"height":70,"caption":"BTech Geeks"},"image":{"@id":"https:\/\/python-programs.com\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/python-programs.com\/#website","url":"https:\/\/python-programs.com\/","name":"Python Programs","description":"Python Programs with Examples, How To Guides on Python","publisher":{"@id":"https:\/\/python-programs.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/python-programs.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#webpage","url":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/","name":"In Python, How Do you Save a Dataframe as a csv File? - Python Programs","isPartOf":{"@id":"https:\/\/python-programs.com\/#website"},"datePublished":"2021-12-17T03:13:04+00:00","dateModified":"2021-12-17T03:13:04+00:00","breadcrumb":{"@id":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/python-programs.com\/"},{"@type":"ListItem","position":2,"name":"In Python, How Do you Save a Dataframe as a csv File?"}]},{"@type":"Article","@id":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#article","isPartOf":{"@id":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#webpage"},"author":{"@id":"https:\/\/python-programs.com\/#\/schema\/person\/fb109fd98e2d5a15fd4dac9970797602"},"headline":"In Python, How Do you Save a Dataframe as a csv File?","datePublished":"2021-12-17T03:13:04+00:00","dateModified":"2021-12-17T03:13:04+00:00","mainEntityOfPage":{"@id":"https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#webpage"},"wordCount":374,"commentCount":0,"publisher":{"@id":"https:\/\/python-programs.com\/#organization"},"articleSection":["Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/python-programs.com\/in-python-how-do-you-save-a-dataframe-as-a-csv-file\/#respond"]}]},{"@type":"Person","@id":"https:\/\/python-programs.com\/#\/schema\/person\/fb109fd98e2d5a15fd4dac9970797602","name":"Vikram Chiluka","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/python-programs.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c56c77f578d45de43af6feb443618ed7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c56c77f578d45de43af6feb443618ed7?s=96&d=mm&r=g","caption":"Vikram Chiluka"},"url":"https:\/\/python-programs.com\/author\/vikram\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/26338"}],"collection":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/comments?post=26338"}],"version-history":[{"count":3,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/26338\/revisions"}],"predecessor-version":[{"id":26342,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/posts\/26338\/revisions\/26342"}],"wp:attachment":[{"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/media?parent=26338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/categories?post=26338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/python-programs.com\/wp-json\/wp\/v2\/tags?post=26338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}