/Python/Pandas remove multi header from dataframe

Pandas remove multi header from dataframe

df = pd.read_table('yourfile.csv', header=None, delim_whitespace=True, skiprows=1)
df.columns = ['0','POSITION_T','PROB','ID']
del df['0']

# filtering out the rows with `POSITION_T` value in corresponding column
df = df[df.POSITION_T.str.contains('POSITION_T') == False]

print(df)

Source: stackoverflow.com

Similar codes

1 vote152 views1 answer
How to add char to string python
Python
2 votes121 views1 answer
Python bin()
Python
3 votes129 views2 answers
Return df.iloc[1:]
Python
0 vote176 views1 answer
Python print stderr
Python
0 vote167 views1 answer
Check for nat entries pandas
Python
0 vote83 views1 answer
Python tqdm seet width
Python
20 votes123 views6 answers
List input python
Python
1 vote135 views2 answers
Python print utf-8
Python
0 vote114 views1 answer
Sort object by one attribute python
Python
0 vote124 views1 answer
Run all python files in a directory in windows
Python