/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

20 votes279 views5 answers
How to merge two pandas dataframes on a column
Python
0 vote183 views1 answer
Run python script on remote server
Python
0 vote178 views1 answer
Comma separator f string python
Python
0 vote211 views1 answer
Unpersist cache pyspark
Python
3 votes186 views2 answers
Python use variable in another file
Python
7 votes178 views6 answers
Pandas delete spaces
Python
0 vote202 views1 answer
Where to import render in django
Python
0 vote202 views1 answer
The Python 2 bindings for rpm are needed for this module. If you require Python 3 support use the `dnf` Ansible module instead.. The Python 2 yum module is needed for this module. If you require Python 3 support use the `dnf` Ansible module instead.
Python
0 vote191 views1 answer
Set colour to inserplaintext qtextedit in python
Python
0 vote203 views1 answer
Apply numba to itertools import product
Python