Pandas - delete column name
In pandas by default need column names.
But if really want 'remove'
columns what is strongly not recommended, because get duplicated column names is possible assign empty strings:
df.columns = [''] * len(df.columns)
But if need write df
to file without columns and index add parameter header=False
and index=False
to to_csv
or to_excel
.
df.to_csv('file.csv', header=False, index=False)
df.to_excel('file.xlsx', header=False, index=False)
If all you need is to print out without the headers then you can use the to_string()
and set header=False
, e.g.:
>>> print(df.to_string(header=False))
0 1 0 1
1 2 0 0
2 2 1 1
3 2 0 1
4 2 1 0
If you need to remove the header alone, uses '.values'.
df = df[:].values
But the above code will return a numpy array instead of dataframe. Converting the same again into dataframe will add default values to column names (0,1..).