/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 vote183 views1 answer
How to change dtype object to int
Python
0 vote179 views1 answer
Can there be an if statement inside an if statement python
Python
0 vote115 views1 answer
Unhapppy man with monwy
Python
0 vote160 views1 answer
Python render_template
Python
0 vote161 views1 answer
Python in a nutshell
Python
1 vote148 views1 answer
Django pass data between views
Python Django
2 votes225 views3 answers
Fill zeros left python
Python
0 vote171 views1 answer
Python get unique pairs from two lists
Python
0 vote167 views1 answer
Master python
Python
1 vote207 views1 answer
Django form list option
Python Django