/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 vote353 views1 answer
Python apply function to dictionary values
Python
0 vote315 views1 answer
Taking a list of strings as input, our matching function returns the count of the number of strings whose first and last chars of the string are the same. Also, only consider strings with length of 2 or more. python
Python
3 votes351 views1 answer
How to set datetime format in python
Python
2 votes377 views1 answer
Python sys halt
Python
46 votes359 views4 answers
How to stop container in docker
Python
0 vote355 views1 answer
Form rendering options in django
Python Django
22 votes363 views6 answers
How to use dictionary in python
Python
0 vote310 views1 answer
Train_test_split without shuffle
Python
0 vote312 views1 answer
Open python choose encoding
Python
0 vote331 views1 answer
How to convert a axis label to non scientific notation in matploltlib
Python