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

4 votes100 views1 answer
Python dictionary add key-value pair
Python
0 vote99 views1 answer
Python convert a dict to list or a list to dict or a slice a dict or sort a dict by key or value without import
Python
0 vote108 views2 answers
Python datetime now minus 3 hours
Python
1 vote129 views1 answer
Flask app route in different files
Python Flask
0 vote118 views1 answer
Python format() function uses.
Python
0 vote144 views1 answer
Screen.onkey python
Python
20 votes88 views4 answers
Add input to list python
Python
0 vote140 views1 answer
No module named 'bootstrap4' django
Python Django
-1 vote129 views1 answer
Pandas splitting the data based on the day type
Python
1 vote100 views1 answer
How to read zip csv file in python
Python