擅长:python、mysql、java
<p>IMHO,你可以用正则表达式</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
df = pd.read_csv(PATH, sep=r'[,|;\t"]+(?=\S)', engine='python')
</code></pre>
<p>这里有一些例子</p>
<pre class="lang-py prettyprint-override"><code>from io import StringIO
import pandas as pd
s1 = """a|b|c
1|2|3
"""
s2 = """a;b;c
1;2;3
"""
print(pd.read_csv(StringIO(s1), sep=r'[,|;\t"]+(?=\S)', engine='python'))
print()
print(pd.read_csv(StringIO(s2), sep=r'[,|;\t"]+(?=\S)', engine='python'))
a b c
0 1 2 3
a b c
0 1 2 3
</code></pre>