/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

0 vote139 views1 answer
Pytorch rolling window
Python
0 vote117 views1 answer
Python access each group
Python
0 vote121 views1 answer
Enumerate items python
Python
2 votes124 views1 answer
How to make a letter animation in python
Python
1 vote133 views1 answer
Elif in django template
Python
0 vote132 views1 answer
Selenium open inspect
Python
0 vote160 views1 answer
How to set and run flask app on terminal
Python Flask
0 vote143 views2 answers
Python dictionary rename key
Python
1 vote183 views1 answer
Delete and start fresh with db django
Python Django
-1 vote124 views1 answer
ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\__init__.py)
Python