擅长:python、mysql、java
<p>您只需使用<code>regex</code>在列<strong>中保留数字,然后使用<code>series.astype('float')</code>将列转换为浮点</p>
<p>加:</p>
<pre><code>films.worldwide_gross = films.worldwide_gross.str.replace('\D',"",regex = True).astype(float)
</code></pre>
<p>完整代码:</p>
<pre><code>import pandas as pd
boxoffice_df=pd.read_html('https://en.wikipedia.org/wiki/List_of_highest-grossing_films')
films = boxoffice_df[1]
films.rename(columns = {'Worldwide gross(2020 $)':'worldwide_gross'}, inplace = True)
films.worldwide_gross = films.worldwide_gross.str.replace('\D',"",regex = True).astype(float)
films.worldwide_gross.sum(axis=0)
</code></pre>