/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

3 votes279 views1 answer
Normalize values between 0 and 1 python
Python
0 vote319 views1 answer
Python string lower method
Python
14 votes308 views5 answers
How to read a excel file in python
Python
0 vote277 views1 answer
Autoscrapper installation
Python
0 vote297 views1 answer
Python selenium click on agree button
Python
0 vote270 views1 answer
Python nltk detecting clauses in sentences
Python
0 vote289 views2 answers
Python web scraping project
Python
0 vote347 views1 answer
Handling single exception
Python
0 vote283 views2 answers
Doing math in python
Python
2 votes300 views1 answer
How to add headers in csv file using python
Python