回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>请帮我写代码</p>
<p>我要走了</p>
<pre><code>IndexError: list index out of range
</code></pre>
<p>当我使用</p>
<pre><code>split(",")[1] and split(",")[2]
</code></pre>
<p>这倒可以</p>
<pre><code>split(",")[0] and split(",")[-1]
</code></pre>
<p>谢谢你的帮助</p>
<pre><code> my data like this:
INPUT.csv
col0 col1 col2 col3 col4
blue, eight, line, aaa abc@123.com,xyz@123.com,ghi@123.com
green, nine, square, bbb sdf@123.com,wef@123.com,hft@123.com
expected output
OUTPUT.csv
col0 col1 col2 col3 col4 col5 col6
blue eight line aaa abc@123.com xyz@123.com ghi@123.com
green, nine, square, bbb sdf@123.com wef@123.com hft@123.com
</code></pre>
<p>到目前为止我的代码是:</p>
<pre><code>import csv
with open('INPUT.csv', 'r') as csv_file:
csv_reader = csv.DictReader(csv_file)
with open('OUTPUT.csv', 'w',encoding='utf-8') as new_file:
fieldnames = ['col0','col1','col2','col3','col4','col5','col6']
csv_writer = csv.DictWriter(new_file,lineterminator='\n' ,
fieldnames=fieldnames)
)
for row in csv_reader:
csv_writer.writerow({
"col0": row["col0"],
"col1": row["col1"],
"col4": row["col4"].split(",")[0].strip(),
"col5": row["col4"].split(",")[1].strip(),
"col6": row["col4"].split(",")[2].strip(),
})
</code></pre>