Multiple delimiters pandas

>>> !cat castle.dat
c stuff
c more header
c begin data         
 1 1:.5
 1 2:6.5
 1 3:5.3
>>> df = pd.read_csv('castle.dat', skiprows=3, names=['a', 'b', 'c'], 
                     sep=' |:', engine='python')
>>> df
   a  b    c
0  1  1  0.5
1  1  2  6.5
2  1  3  5.3

Source: stackoverflow.com

Similar codes

-1 vote220 views1 answer
Django email verification
Python Django
1 vote220 views3 answers
Remove brackets from string python
Python
0 vote173 views1 answer
Python float till 2 decimal places
Python
2 votes194 views1 answer
Python create hash from string
Python
0 vote185 views1 answer
Ssl django nginx
Python
1 vote176 views2 answers
Pip clear download cache
Python
0 vote148 views1 answer
Pyttsx3 install
Python
1 vote217 views1 answer
Python saveAsTextFile
Python
2 votes209 views2 answers
Python isdigit negative
Python
6 votes182 views1 answer
Check 32 or 64 bit python
Python