/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 vote264 views1 answer
Python opencv create new image
Python
0 vote281 views1 answer
Xgboost algorithm in python
Python
0 vote222 views1 answer
Datetime decreasing date python
Python
0 vote265 views1 answer
Jet 4 access python password
Python
76 votes275 views6 answers
Main in python
Python
0 vote260 views1 answer
Python cv2 read image grayscale
Python
0 vote282 views1 answer
Git commit emoji
Python
28 votes394 views1 answer
Import "matplotlib" could not be resolved django
Python Django
23 votes357 views2 answers
Flask or django
Python Flask
20 votes268 views3 answers
String to float python
Python