how to read the first row as the column names in pandas code example
Example 1: first row as column df
df.rename(columns=df.iloc[0])
Example 2: make first row column names pandas
In [24]: df.drop(df.index[1])
Out[24]:
1 foo bar baz
0 1 2 3
2 4 5 6