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

3 votes144 views2 answers
Python execute bat file
Python
0 vote131 views1 answer
Oversampling using smote
Python
3 votes127 views4 answers
Get the path of a module in python
Python
0 vote127 views1 answer
Drop row pandas column value not a number
Python
39 votes128 views3 answers
How to write to the end of a file in python
Python
0 vote127 views1 answer
Adding function to a varieble in python
Python
0 vote159 views1 answer
Python 3 rimuovere l'ultimo carattere da stringa
Python
4 votes125 views3 answers
Txt to list python
Python
7 votes173 views2 answers
Show image in python
Python
2 votes136 views2 answers
Python module for converting miles to km
Python