回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个CSV,看起来像这样:</p>
<pre><code>F02303521,"Smith,Andy",GHI,"Smith,Andy",GHI,,,
F04300621,"Parker,Helen",CERT,"Yu,Betty",IOUS,,,
</code></pre>
<p>我想删除第二列等于第四列的所有行(例如当<code>Smith,Andy = Smith,Andy</code>)。我尝试在python中使用<code>"</code>作为分隔符并将列拆分为:</p>
<p><code>F02303521,</code><code>Smith,Andy</code><code>,GHI,</code><code>Smith,Andy</code><code>,GHI,,,</code></p>
<p>我尝试了以下python代码:</p>
^{pr2}$
<p>但对于这条线:</p>
<pre><code>PI = line.split('"')[1]
</code></pre>
<p>我得到:</p>
<blockquote>
<p>Traceback (most recent call last):
File "C:/Users/sskadamb/PycharmProjects/vastDeleteLine/manipulation.py", line 11, in
PI = line.split('"')[1]
IndexError: list index out of range</p>
</blockquote>
<p>我以为它能<code>PI = Smith,Andy</code><code>investigator = Smith,Andy</code>。。。为什么没有呢?在</p>
<p>任何帮助都将不胜感激,谢谢!在</p>