Dataframe has no column names. How to add a header?
For any dataframe , say df , you can add/modify column names by passing the column names in a list to the df.columns method:
For example, if you want the column names to be 'A', 'B', 'C', 'D'],use this
df.columns = ['A', 'B', 'C', 'D’]
In your code , can you remove header=0? This basically tells pandas to take the first row as the column headers . Once you remove that , use the above to assign the column names