In order to export pandas DataFrame to CSV without index (no row indices) use param index=False and to ignore/remove header use header=False param on to_csv() method. In this article, I will explain how to remove the index and header on the csv file with examples. Note that to_csv() method also supports several other params to write pandas DataFrame to CSV file.
1. Pandas to CSV without Index & Header
By default exporting a pandas DataFrame to CSV includes column names on the first row, row index on the first column, and writes a file with a comma-separated delimiter to separate columns. pandas.DataFrame.to_csv() method provides parameters to ignore an index and header while writing.
First, let’s create a DataFrame with a few rows and columns along with index and header names.
# Create a DataFrame
import pandas as pd
import numpy as np
technologies = {
'Courses':["Spark","PySpark","Hadoop","Python"],
'Fee' :[22000,25000,np.nan,24000],
'Duration':['30day',None,'55days',np.nan],
'Discount':[1000,2300,1000,np.nan]
}
df = pd.DataFrame(technologies)
2. Pandas to CSV with no Index
pandas DataFrame to CSV with no index can be done by using index=False param of to_csv() method. With this, you can specify ignore index while writing/exporting DataFrame to CSV file.
# Remover column header and index
df.to_csv("c:/tmp/courses.csv",index=False)
Writes courses.csv file without index.
Courses,Fee,Duration,Discount
Spark,22000.0,30day,1000.0
PySpark,25000.0,,2300.0
Hadoop,,55days,1000.0
Python,24000.0,,
3. Pandas to CSV without Header
To write DataFrame to CSV without column header (remove column names) use header=False param on to_csv() method.
# Remove header while writing
df.to_csv("c:/tmp/courses.csv",header=False)
Writes courses.csv file as.
0,Spark,22000.0,30day,1000.0
1,PySpark,25000.0,,2300.0
2,Hadoop,,55days,1000.0
3,Python,24000.0,,
4. Export without Index and Header
Let’s combine these and see how you can use both removing index and column names on the CSV files.
# Remove header & index while writing
df.to_csv("c:/tmp/courses.csv",header=False, index=False)
Conclusion
In this quick article, you have learned how to remove the header without column names and index while writing DataFrame to CSV file. Use param header=False to remove columns and use index=False to remove index (no row indices) on to_csv() method.
Happy Learning !!
Related Articles
- Install pandas on Windows Step-by-Step
- Select Multiple Columns in Pandas DataFrame
- How to Check If any Value is NaN in a Pandas DataFrame
- Select DataFrame Columns by Label or Index from Pandas
- Operator Chaining to Filter Pandas DataFrame Rows
- Differences between Pandas Join vs Merge
- Pandas – Convert JSON to CSV
- How to Read CSV from String in Pandas
- Pandas Read Multiple CSV Files into DataFrame
