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

0 vote197 views1 answer
Python permission denied on mac
Python
0 vote187 views1 answer
How to make default kwargs in python
Python
9 votes200 views3 answers
Get first line of file python
Python
0 vote192 views1 answer
How to import a all the modules in a packege python
Python
0 vote194 views1 answer
Python readlines end of file
Python
29 votes183 views1 answer
Sort a dataframe by a column valuepython
Python
5 votes196 views5 answers
Formatted string in python
Python
3 votes191 views6 answers
Squash commits git
Python
16 votes177 views4 answers
Dataframe find nan rows
Python
0 vote190 views1 answer
Return position of a unique value in python array
Python