/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 vote308 views1 answer
Gogle query python simple
Python
-1 vote345 views1 answer
Negate an int in python
Python
0 vote322 views1 answer
Python datetime remove timezone
Python
0 vote300 views1 answer
Python decorator *args **kwargs
Python
0 vote311 views2 answers
Dataframe multiindex query
Python
1 vote293 views1 answer
Como unir dos listas python
Python
0 vote271 views1 answer
Gene wilder pure imagination
Python
0 vote295 views1 answer
Python site-packages pyspark
Python
3 votes311 views2 answers
What day i s it
Python
0 vote338 views2 answers
Import specific version of package python
Python