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 vote120 views1 answer
Find allurl in text python
Python
1 vote151 views1 answer
Django text area limit characters
Python Django
14 votes112 views5 answers
How to read a excel file in python
Python
4 votes125 views3 answers
How to use random tree in python
Python
-1 vote99 views1 answer
Python delete file from directory
Python
0 vote113 views1 answer
How to access range of tuples in python
Python
6 votes113 views4 answers
List iteration
Python
0 vote111 views1 answer
Add user agent selenium python canary
Python
0 vote115 views2 answers
Dataframe multiindex query
Python
0 vote127 views1 answer
Python - row slice dataframe by number of rows
Python