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 vote141 views1 answer
Trends in yearly data python
Python
4 votes209 views3 answers
List element swapping python
Python
1 vote164 views1 answer
Split a given number in python
Python
3 votes203 views2 answers
How to install api in python
Python
0 vote130 views1 answer
How to get table schema sql pyodbc
Python
37 votes158 views6 answers
Upgrade package python
Python
0 vote139 views2 answers
Generate-thumbnails-in-django-with-pil
Python
1 vote139 views2 answers
Number of columns with no missing values
Python
0 vote143 views1 answer
Format numbers in column to percentage in python
Python
8 votes119 views1 answer
Python find runtime
Python