How to add header row to a pandas DataFrame

Question

I am reading a csv file into pandas  This csv file constists of four columns and some rows  but does not have a header row  which I want to add  I have been trying the following    Cov   pd read csv  path to file txt   sep   t   Frame pd DataFrame  Cov   columns     Sequence    Start    End    Coverage    Frame to csv  path to file txt   sep   t     But when I apply the code  I get the following Error   ValueError  Shape of passed values is  1  1   indices imply  4  1    What exactly does the error mean  And what would be a clean way in python to add a header row to my csv file pandas df

User · Answer

Alternatively you could read you csv with header None and then add it with df columns   Cov   pd read csv  path to file txt   sep   t   header None  Cov columns     Sequence    Start    End    Coverage

User · Answer

You can use names directly in the read csv      names   array-like  default None List of column names to use  If file   contains no header row  then you should explicitly pass header None   Cov   pd read csv  path to file txt                      sep   t                      names   Sequence    Start    End    Coverage

User · Answer

To fix your code you can simply change  Cov  to Cov values  the first parameter of pd DataFrame will become a multi-dimensional numpy array   Cov   pd read csv  path to file txt   sep   t   Frame pd DataFrame Cov values  columns     Sequence    Start    End    Coverage    Frame to csv  path to file txt   sep   t     But the smartest solution still is use pd read excel with header None and names columns list

User · Answer

col Names   Sequence    Start    End    Coverage   my CSV File  pd read csv  yourCSVFile csv  names col Names    having done this  just check it with well obviously I know  u know that  But still      my CSV File head     Hope it helps     Cheers

[python] How to add header row to a pandas DataFrame

Examples related to python

Examples related to csv

Examples related to pandas

Examples related to header