/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

1 vote147 views1 answer
How to convert int in python
Python
0 vote167 views2 answers
Get data from dynamodb using boto3
Python
-1 vote145 views1 answer
Anaconda 3 geopandas
Python
1 vote135 views1 answer
Python how to use a variable to trigger an event
Python
0 vote172 views1 answer
Sum the contents of a list python
Python
0 vote184 views1 answer
Dump ML Model
Python
2 votes140 views1 answer
Convert float in datetime python
Python
1 vote168 views1 answer
Incognito in selenium
Python
0 vote151 views1 answer
Python create local list
Python
0 vote175 views1 answer
Keep tkinter window below others
Python