Question

How can I use Python with Pandas to create a new.csv file with the headers "c1, c2, c3, c4, c5, c6" and the first line of data "8, 5, -9, 7, 2.1, 1.7" from the original.csv file?

Answer 1

import pandas as pd

#reading csv file
data=pd.read_csv('original.csv')

#creating headers
headers=['c1','c2','c3','c4','c5','c6']

#adding headers
data=pd.read_csv('original.csv',names=headers, header=None)

#writing data into new.csv file
data.to_csv('new.csv')

original.csv

new.csv

here 0 denotes the number of rows are 1,starting from 0