擅长:python、mysql、java
<p>坚持使用标准库,<code>re.split()</code>可以在以下任何字符处拆分一行:</p>
<pre><code>import re
with open(file_name) as fobj:
for line in fobj:
line_data = re.split('Delim_first|Delim_second|[|]', line)
print(line_data)
</code></pre>
<p>这将在分隔符<code>|</code>、<code>Delim_first</code>和<code>Delim_second</code>处拆分。</p>
<p>或者熊猫:</p>
<pre><code>import pandas as pd
df = pd.read_csv('multi_delim.csv', sep='Delim_first|Delim_second|[|]',
engine='python', header=None)
</code></pre>
<p>结果:</p>
<p><a href="https://i.stack.imgur.com/iVJfd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iVJfd.png" alt="enter image description here"/></a></p>