擅长:python、mysql、java
<p>对包含逗号的数字使用<code>thousands=','</code>参数</p>
<pre><code>In [1]: from pandas import read_csv
In [2]: d = read_csv('data.csv', thousands=',')
</code></pre>
<p>你可以检查奖池是数字的</p>
^{pr2}$
<p>要删除行-首先观察到,也可以选择最后一个</p>
<pre><code>In [7]: d.drop_duplicates('Contest_Date_EST', take_last=False)
Out[7]:
Sport Entry \
0 NBA NBA 3K Crossover #3 [3,000 Guaranteed] (Early ...
Contest_Date_EST Place Points Winnings_Non_Ticket Winnings_Ticket \
0 2015-03-01 13:00:00 35 283.25 13.33 0
Contest_Entries Entry_Fee Prize_Pool Places_Paid
0 171 20 3000 35
</code></pre>