/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

4 votes199 views2 answers
How to make a square shape in python
Python
1 vote192 views1 answer
Read csv python without id
Python
0 vote276 views1 answer
How to insert item at specifc index python
Python
0 vote157 views1 answer
From threading import thread ImportError: cannot import name 'thread' from 'threading' (/usr/lib/python3.7/threading.py)
Python
2 votes209 views1 answer
How to square each term of numpy array python
Python
27 votes252 views3 answers
Python date and time to datetime
Python
6 votes206 views1 answer
Load images pygame
Python
0 vote188 views1 answer
Jupyter notebook fancy print cross tab
Python
0 vote214 views1 answer
Get list of users django
Python Django
1 vote212 views1 answer
Droping Duplicates
Python