<p>您只需打印这些文件,而不是将它们<a href="http://pandas.pydata.org/pandas-docs/dev/generated/pandas.DataFrame.apply.html" rel="nofollow">^{<cd1>}</a>-发送到数据框中,以下是一种方法:</p>
<p>创建一个函数来执行条带化(如果是unicode),或者如果已经是一个数字,则保留它:</p>
<pre><code>def no_comma_or_dollar(num):
if isinstance(num, unicode):
return float(num.lstrip('$').replace(',',''))
else:
return num
table[col_name] = table[col_name].apply(no_comma_or_dollar)
</code></pre>
<p>例如:</p>
^{pr2}$
<p>更新:</p>
<p>对于您给出的<code>thread</code>,我很想给出一个稍微懒一点的<code>no_comma_or_dollar</code>和{a2}:</p>
<pre><code>def no_comma_or_dollar2(num):
try:
return float(num.lstrip('$').replace(',',''))
except: # if you can't strip/replace/convert just leave it
return num
In [5]: thread.applymap(no_comma_or_dollar2)
Out[5]:
Consolidated Balance Sheet (USD $) Dec. 31, 2011 Sep. 30, 2012
0 In Millions, unless otherwise specified NaN NaN
1 Current assets NaN NaN
2 Cash and cash equivalents 2219 3029
3 Marketable securities - current 1461 1989
4 Accounts receivable - net 3867 4409
</code></pre>