Pandas read csv with columns name spread over multiple rows

Asked Nov 05 '21 at 15:54

Active Nov 05 '21 at 18:11

Viewed 996 times

While reading a csv file into pandas dataframe, I came into following situation: The column names were spread into multiple rows. I have attached a picture below. The problem is that now I have some columns to have duplicated name, but they are not. Is there a way to combine the columns from multiple row in single columns, without doing manual hack? Well the data points are not duplicated, but it misses some string from the column names, resulting into columns that may appear as repeated.

data = pd.read_csv("CO2.csv", header=54)

Thanks in advance

edited Nov 05 '21 at 18:11

asked Nov 05 '21 at 15:54

stackword_0

1

where is your read method? ideally you need to make sure of the `header` argument `pd.read_csv(...,header=[0,1,2])` – Umar.H Nov 05 '21 at 16:02
My read method is like: data = pd.read_csv("CO2.csv", header=54) – stackword_0 Nov 05 '21 at 16:04
try the above args – Umar.H Nov 05 '21 at 16:18

Pandas read csv with columns name spread over multiple rows

0 Answers0