擅长:python、mysql、java
<pre><code>import pandas as pd
pd.options.display.float_format = '${:,.2f}'.format
df = pd.DataFrame([123.4567, 234.5678, 345.6789, 456.7890],
index=['foo','bar','baz','quux'],
columns=['cost'])
print(df)
</code></pre>
<p>收益率</p>
<pre><code> cost
foo $123.46
bar $234.57
baz $345.68
quux $456.79
</code></pre>
<p>但这只在您希望<em>每个</em>float都用美元符号格式化时才有效。</p>
<p>否则,如果您只想对某些浮动设置美元格式,那么我认为您必须预先修改数据帧(将这些浮动转换为字符串):</p>
<pre><code>import pandas as pd
df = pd.DataFrame([123.4567, 234.5678, 345.6789, 456.7890],
index=['foo','bar','baz','quux'],
columns=['cost'])
df['foo'] = df['cost']
df['cost'] = df['cost'].map('${:,.2f}'.format)
print(df)
</code></pre>
<p>收益率</p>
<pre><code> cost foo
foo $123.46 123.4567
bar $234.57 234.5678
baz $345.68 345.6789
quux $456.79 456.7890
</code></pre>