How do you remove the column name row when exporting a pandas DataFrame? How do you remove the column name row when exporting a pandas DataFrame? python python

How do you remove the column name row when exporting a pandas DataFrame?


python pandas csv dataframe header

You can write to csv without the header using header=False and without the index using index=False. If desired, you also can modify the separator using sep.

CSV example with no header row, omitting the header row:

df.to_csv('filename.csv', header=False)

TSV (tab-separated) example, omitting the index column:

df.to_csv('filename.tsv', sep='\t', index=False)

python pandas csv dataframe header

Figured out a way to do this:

df.to_csv('filename.csv', header = False)

This tells pandas to write a csv file without the header. You can do the same with df.to_excel.

python pandas csv dataframe header

If you pass header=False, you will get this error

TypeError: Passing a bool to header is invalid. Use header=None for no header or header=int or list-like of ints to specify the row(s) making up the column names

Instead, use header=None

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last