/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 vote214 views1 answer
Python - calculate the value range on a df
Python
0 vote235 views1 answer
MEMORY MANAGEMENT SYSTEM IN PYTHON
Python
0 vote222 views1 answer
Python socket set title
Python
0 vote223 views1 answer
Python web app with redis github
Python
1 vote243 views1 answer
Not getting spanish characters python
Python
1 vote311 views2 answers
ValueError: Cannot specify ',' with 's'.
Python
89 votes226 views6 answers
Requirements.txt python
Python
1 vote234 views1 answer
R vs python
Python
-1 vote239 views1 answer
What is append use
Python
0 vote231 views1 answer
Python split string into floats
Python