/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

66 votes339 views6 answers
How to open csv file in python
Python
0 vote326 views1 answer
Pyspark rdd sort by value descending
Python
0 vote338 views1 answer
Unique_together what is used of it in django
Python
0 vote367 views1 answer
Pipenv installs
Python
-1 vote324 views1 answer
Extract specific key values from python dictionary
Python
2 votes311 views1 answer
Python unchain list
Python
3 votes342 views6 answers
Fizz buzz python
Python
0 vote343 views1 answer
Not staments python
Python
0 vote385 views2 answers
Url namespaces for django rest router urls
Python Django
0 vote331 views1 answer
Smtplib send pdf
Python