How to export Pandas DataFrame to a CSV file?

Pandas - DataFrame to CSV file using tab separator

Last Updated : 27 Aug, 2021

Let's see how to convert a DataFrame to a CSV file using the tab separator. We will be using the to_csv() method to save a DataFrame as a csv file. To save the DataFrame with tab separators, we have to pass "\t" as the sep parameter in the to_csv() method.

Approach :

Import the Pandas and Numpy modules.
Create a DataFrame using the DataFrame() method.
Save the DataFrame as a csv file using the to_csv() method with the parameter sep as "\t".
Load the newly created CSV file using the read_csv() method as a DataFrame.
Display the new DataFrame.

Python3

# importing the modules
import pandas as pd
import numpy as np

# creating a DataFrame
students = {'Student': ['Amit', 'Cody', 
                        'Darren', 'Drew'],
            'RollNumber': [1, 5, 10, 15],
            'Grade': ['A', 'C', 'F', 'B']}
df = pd.DataFrame(students, 
                  columns =['Student', 'RollNumber', 
                            'Grade'])
# displaying the original DataFrame
print("Original DataFrame")
print(df)

# saving as a CSV file
df.to_csv('Students.csv', sep ='\t')

# loading the CSV file
new_df = pd.read_csv('Students.csv')

# displaying the new DataFrame
print('Data from Students.csv:')
print(new_df)

Output :

The contents of the Students.csv file are :

How to export Pandas DataFrame to a CSV file?

G

gauravbabbar25

Improve

Article Tags :

Practice Tags :

python

Similar Reads

How to write Pandas DataFrame as TSV using Python?

In this article, we will discuss how to write pandas dataframe as TSV using Python. Let's start by creating a data frame. It can be done by importing an existing file, but for simplicity, we will create our own. Python3 # importing the module import pandas as pd # creating some sample data sample =

How to export Pandas DataFrame to a CSV file?

Let us see how to export a Pandas DataFrame to a CSV file. We will be using the to_csv() function to save a DataFrame as a CSV file. DataFrame.to_csv() Syntax : to_csv(parameters) Parameters : path_or_buf : File path or object, if None is provided the result is returned as a string. sep : String of

How to Save Pandas Dataframe as gzip/zip File?

Pandas is an open-source library that is built on top of NumPy library. It is a Python package that offers various data structures and operations for manipulating numerical data and time series. It is mainly popular for importing and analyzing data much easier. Pandas is fast and it has high-perform

How to Convert Pandas to PySpark DataFrame ?

In this article, we will learn How to Convert Pandas to PySpark DataFrame. Sometimes we will get csv, xlsx, etc. format data, and we have to store it in PySpark DataFrame and that can be done by loading data in Pandas then converted PySpark DataFrame. For conversion, we pass the Pandas dataframe int

Export Pandas dataframe to a CSV file

When working on a Data Science project one of the key tasks is data management which includes data collection, cleaning and storage. Once our data is cleaned and processed itâ€™s essential to save it in a structured format for further analysis or sharing.A CSV (Comma-Separated Values) file is a widely

Convert Text File to CSV using Python Pandas

Converting Text File to CSV using Python Pandas refers to the process of transforming a plain text file (often with data separated by spaces, tabs, or other delimiters) into a structured CSV (Comma Separated Values) file using the Python Pandas library.In this article we will walk you through multip

Construct a DataFrame in Pandas using string data

Data comes in various formats and string data is one of the most common formats encountered when working with data sources such as CSV files, web scraping, or APIs. In this article, we will explore different ways to load string data into a Pandas DataFrame efficiently.Using StringIO()One way to crea

Convert CSV to HTML Table using Python Pandas and Flask Framework

In this article, we are going to convert a CSV file into an HTML table using Python Pandas and Flask Framework. Sample CSV file : USERNAME,IDENTIFIER,FIRST_NAME,LAST_NAME booker12,9012,Rachel,Booker grey07,2070,Laura,Grey johnson81,4081,Craig,Johnson jenkins46,9346,Mary,Jenkins smith79,5079,Jamie,Sm

PySpark - Read CSV file into DataFrame

In this article, we are going to see how to read CSV files into Dataframe. For this, we will use Pyspark and Python. Files Used: authorsbook_authorbooksRead CSV File into DataFrame Here we are going to read a single CSV into dataframe using spark.read.csv and then create dataframe with this data usi

Read a zipped file as a Pandas DataFrame

In this article, we will try to find out how can we read data from a zip file using a panda data frame.Â Why we need a zip file? People use related groups of files together and to make files compact, so they are easier and faster to share via the web. Zip files are ideal for archiving since they sav