/Python/ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators > 1 char and different from '\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.

ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators > 1 char and different from '\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.

ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators >1 char and different from '\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.

import pandas as pd
import io

temp=u"""a;b;c
1;1,8
1;2,1
1;3,6
1;4,3
1;5,7
"""
#after testing replace io.StringIO(temp) to filename
df = pd.read_csv(io.StringIO(temp), sep="[;,]", engine='python')
print (df)

   a  b  c
0  1  1  8
1  1  2  1
2  1  3  6
3  1  4  3
4  1  5  7

Source: stackoverflow.com

Similar codes

1 vote313 views1 answer
Django change value and save model object
Python
0 vote336 views1 answer
Django snippet 800
Python Django
0 vote290 views1 answer
Add text to jpg python
Python
0 vote294 views1 answer
Python Script to check how many images are broken
Python
0 vote285 views1 answer
Python - matching people based on city
Python
124 votes288 views6 answers
Pandas rename column
Python
0 vote302 views1 answer
How to change bit in integer in python
Python
1 vote297 views1 answer
X= [10] def List_ex(): x.append(20) def add_list(): x=[30,40] x.append(50) print (x) List_ex() print (x) add_list() print (x)
Python
2 votes316 views1 answer
Add a list in python
Python
0 vote323 views1 answer
Django versatileimagefield
Python Django