/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

0 vote164 views1 answer
Mathplolib avec date
Python
29 votes314 views4 answers
Basic flask app python
Python Flask
1 vote152 views2 answers
Pandas change diagonal
Python
0 vote156 views1 answer
Migrations.rename_field django
Python
2 votes119 views1 answer
Python insert object into list
Python
4 votes141 views3 answers
Csv to json
Python
4 votes142 views1 answer
Pandas add dataframe to the bottom of another
Python
0 vote162 views1 answer
Django model different schema
Python
0 vote155 views1 answer
Update numpy in python
Python
0 vote156 views1 answer
Inverted trapezium pattern in python
Python