Removing header column from pandas dataframe

Question

I have the foll  dataframe   df     A   B 0  23  12 1  21  44 2  98  21   How do I remove the column names A and B from this dataframe  One way might be to write it into a csv file and then read it in specifying header None  is there a way to do that without writing out to csv and re-reading

User · Answer

How to get rid of a header first row  and an index first column    To write to CSV file   df   pandas DataFrame your array  df to csv  your array csv   header False  index False    To read from CSV file   df   pandas read csv  your array csv   a   df values   If you want to read a CSV file that doesn t contain a header  pass additional parameter header   df   pandas read csv  your array csv   header None

User · Answer

Haven t seen this solution yet so here s how I did it without using read csv  df rename columns   A      B        If you rename all your column names to empty strings your table will return without a header  And if you have a lot of columns in your table you can just create a dictionary first instead of renaming manually  df dict   dict fromkeys df columns      df rename columns   df dict

User · Answer

I had the same problem but solved it in this way  df   pd read csv  your-array csv   skiprows  0

User · Answer

I think you cant remove column names  only reset them by range with shape   print df shape 1  2  print range df shape 1    0  1   df columns   range df shape 1   print df     0   1 0  23  12 1  21  44 2  98  21   This is same as using to csv and read csv   print df to csv header None index False  23 12 21 44 98 21  print pd read csv io StringIO u   df to csv header None index False    header None      0   1 0  23  12 1  21  44 2  98  21   Next solution with skiprows   print df to csv index False  A B 23 12 21 44 98 21  print pd read csv io StringIO u   df to csv index False    header None  skiprows 1      0   1 0  23  12 1  21  44 2  98  21

[python] Removing header column from pandas dataframe

Examples related to python

Examples related to pandas