I currently have a dataframe that looks like this:
JavaScript
x
7
1
Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4
2
0 Sample Number Group Number Sample Name Group Name
3
1 1.0 1.0 s_1 g_1
4
2 2.0 1.0 s_2 g_1
5
3 3.0 1.0 s_3 g_1
6
4 4.0 2.0 s_4 g_2
7
I’m looking for a way to delete the header row and make the first row the new header row, so the new dataframe would look like this:
JavaScript
1
6
1
Sample Number Group Number Sample Name Group Name
2
0 1.0 1.0 s_1 g_1
3
1 2.0 1.0 s_2 g_1
4
2 3.0 1.0 s_3 g_1
5
3 4.0 2.0 s_4 g_2
6
I’ve tried stuff along the lines of if 'Unnamed' in df.columns:
then make the dataframe without the header
JavaScript
1
2
1
df.to_csv(newformat, header=False, index=False)
2
but I don’t seem to be getting anywhere.
Advertisement
Answer
JavaScript
1
4
1
new_header = df.iloc[0] #grab the first row for the header
2
df = df[1:] #take the data less the header row
3
df.columns = new_header #set the header row as the df header
4