/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

2 votes268 views1 answer
Dataframe get list of index vlaues
Python
0 vote170 views1 answer
Python render_template
Python
0 vote258 views1 answer
Http://techforcurious.website/simulation-of-pendulum-vpython-tutorial-visual-python/
Python
-1 vote166 views1 answer
How to ask a yes or no question on python
Python
0 vote179 views1 answer
Python assert is not null
Python
0 vote166 views1 answer
Numpy index array all except
Python
0 vote192 views2 answers
Pairwise swap in data structure in python
Python
0 vote179 views1 answer
Et.dump export file to xml write method output
Python
1 vote188 views1 answer
Python retry
Python
1 vote179 views1 answer
Python open new chrome tab
Python