回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个名为“data.csv”的文件:</p>
<pre><code> 1997,Ford,E350
1997, Ford , E350
1997,Ford,E350,"Super, luxurious truck"
1997,Ford,E350,"Super ""luxurious"" truck"
1997,Ford,E350," Super luxurious truck "
"1997",Ford,E350
1997,Ford,E350
2000,Mercury,Cougar
</code></pre>
<p>我想把它解析成pandas数据框,这样数据框看起来如下:</p>
<pre><code> Year Make Model Description
0 1997 Ford E350 None
1 1997 Ford E350 None
2 1997 Ford E350 Super, luxurious truck
3 1997 Ford E350 Super "luxurious" truck
4 1997 Ford E350 Super luxurious truck
5 1997 Ford E350 None
6 1997 Ford E350 None
7 2000 Mercury Cougar None
</code></pre>
<p>我能做的就是:</p>
<pre><code> pd.read_table("data.csv", sep=r',', names=["Year", "Make", "Model", "Description"])
</code></pre>
<p>这让我明白了:</p>
<pre><code> Year Make Model Description
0 1997 Ford E350 None
1 1997 Ford E350 None
2 1997 Ford E350 Super, luxurious truck
3 1997 Ford E350 Super "luxurious" truck
4 1997 Ford E350 Super luxurious truck
5 1997 Ford E350 None
6 1997 Ford E350 None
7 2000 Mercury Cougar None
</code></pre>
<p>如果没有这些空白,如何获取数据帧?</p>