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

5 votes166 views4 answers
Python int to binary string
Python
0 vote184 views1 answer
Python flask how to remove last character from string
Python Flask
11 votes176 views6 answers
Pandas join two columns
Python
0 vote156 views1 answer
Tuple and dictionary in python
Python
0 vote174 views1 answer
Python ordering items in a list
Python
1 vote156 views3 answers
Plot python x axis range
Python
18 votes181 views3 answers
Dataframe check for nan in iterrows
Python
0 vote203 views10 answers
Sqlite3 with flask web application CRUD pdf
Python Flask
0 vote199 views1 answer
Circular list python
Python
-1 vote168 views1 answer
How to normalize a 1d numpy array
Python