<p>我不确定我是否完全理解,但您似乎使用了重复的替换,对<code>.replace()</code>的调用多于必要的调用。你知道吗</p>
<p>以下是代码的简化版本:</p>
<pre><code>import csv
with open('demo.csv') as in_file, open('out.csv', 'w', newline='') as out_file:
reader = csv.DictReader(in_file)
writer = csv.DictWriter(out_file, fieldnames=reader.fieldnames)
writer.writeheader()
for row in reader:
new_row = {
k: v.replace('"', '').replace("'", '').strip()
for k, v in row.items()}
writer.writerow(new_row)
</code></pre>
<p>使用此代码,从输入开始<code>demo.csv</code></p>
<pre class="lang-none prettyprint-override"><code>id,message_id,date,text,tags,tweet_lang,source,place,geom,retweets,tweet_favorites,photo_url,quoted_status_id,user_id,user_name,user_location,followers,friends,user_favorites,status,user_lang,latitude,longitude,text_translated_en,src_lang,src_accuracy,text_translated_en_parallel,up_filter,prediction,probability_0,probability_1
10,569282882658807808,2015-02-21 23:49:50,fav,,,Twitter for Android,,0101000055B79C93C406DACC43C2B834440,,,,,1567775498,eliovmek,,,,,,,41.024757,28.787008,,zu,92.0,Social fav,,0,0.9732880735563579,0.026711926443642064
11,651384744010252288,2015-10-06 13:13:19,"Is I'm at she İlia? ",,,Foursquare,,0101000020E6100000B37CFA5B44063D4027A1D377277F4440,,,,,156044562,ajan34,,,,,,,40.99339197,29.02448058,,tr,98.0,"I'm at Fazıl Bey'in @aaa in Rome, Italy ",,0,0.9181253978980514,0.08187460210194858
11,651384744010252288,2015-10-06 13:13:19,"IsI'm at she İlia? ",,,Foursquare,,0101000020E6100000B37CFA5B44063D4027A1D377277F4440,,,,,156044562,ajan34,,,,,,,40.99339197,29.02448058,,tr,98.0,"I'm at Fazıl Bey'in @aaa in Rome, Italy ",,0,0.9181253978980514,0.08187460210194858
</code></pre>
<p>我们得到以下<code>out.csv</code>:</p>
<pre class="lang-none prettyprint-override"><code>id,message_id,date,text,tags,tweet_lang,source,place,geom,retweets,tweet_favorites,photo_url,quoted_status_id,user_id,user_name,user_location,followers,friends,user_favorites,status,user_lang,latitude,longitude,text_translated_en,src_lang,src_accuracy,text_translated_en_parallel,up_filter,prediction,probability_0,probability_1
10,569282882658807808,2015-02-21 23:49:50,fav,,,Twitter for Android,,0101000055B79C93C406DACC43C2B834440,,,,,1567775498,eliovmek,,,,,,,41.024757,28.787008,,zu,92.0,Social fav,,0,0.9732880735563579,0.026711926443642064
11,651384744010252288,2015-10-06 13:13:19,Is Im at she İlia?,,,Foursquare,,0101000020E6100000B37CFA5B44063D4027A1D377277F4440,,,,,156044562,ajan34,,,,,,,40.99339197,29.02448058,,tr,98.0,"Im at Fazıl Beyin @aaa in Rome, Italy",,0,0.9181253978980514,0.08187460210194858
11,651384744010252288,2015-10-06 13:13:19,IsIm at she İlia?,,,Foursquare,,0101000020E6100000B37CFA5B44063D4027A1D377277F4440,,,,,156044562,ajan34,,,,,,,40.99339197,29.02448058,,tr,98.0,"Im at Fazıl Beyin @aaa in Rome, Italy",,0,0.9181253978980514,0.08187460210194858
</code></pre>
<p>你打算这么做吗?你知道吗</p>