How to write a pandas.DataFrame to csv file with custom header?

Question

This is my data frame 

import pandas as pd

df = pd.DataFrame([[1, 2], [3, 4]], columns=['a', 'b'])

I wanted to convert the data frame to CSV and also want to change names of columns for example:

numrows numcols note

1 2

3 4

Should I manually do it? or will pandas help me solve this? 

Answer 1

You need to first create a CSV file then write into the file and then append it to the data frame.

with open('file.csv', 'a') as file:

    file.write('Custom String\n')

    df.to_csv(file, header=False, index=False)

Click on this to see a similar solution.

You can use the below code in your case:

with open('file.csv', 'a') as file:

    file.write('numrows numcols note\n')

    df.to_csv(file, header=False, index=False)

Learn Python for Data Science Course to improve your technical knowledge.