擅长:python、mysql、java
<p>虽然有几种方法可以让它完全工作,但使用<code>csv</code>更容易做到这一点,我只想这样做:</p>
<pre><code>import csv, io, pandas as pd
data = io.StringIO()
with open("leb.csv", newline="") as fp:
reader = csv.reader(fp)
rows = [row[:3] + [','.join(row[3:])] for row in reader]
writer = csv.writer(data)
writer.writerows(rows)
data.seek(0)
df = pd.read_csv(data)
</code></pre>
<p>这有效地在熊猫看到输入数据之前修复了它。这给</p>
<pre><code>>>> df
ID ORIG TIME TEXT
0 364 1 7-10-15 This works fine
1 16254 1 7-10-15 But, I don't work :(
2 9846 0 7-10-15 Neither, do, I
</code></pre>