/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 votes196 views1 answer
Flask give port number
Python
47 votes198 views4 answers
Python format float
Python
0 vote193 views1 answer
All alphabets
Python
0 vote164 views1 answer
How to take array input in python in single line
Python
2 votes190 views1 answer
Set django static root
Python
0 vote183 views1 answer
How to define a functio in python
Python
0 vote187 views1 answer
Punto1
Python
3 votes192 views1 answer
Python RuntimeError: tf.placeholder() is not compatible with eager execution.
Python
21 votes186 views6 answers
Print statement in python
Python
0 vote194 views1 answer
Star program in python using for loop
Python