"""
from decimal import Decimal
def test():
result = ""
try:
# 计算公式：symbol_left + 格式化美元价 * value + symbol_right
# 公式参数说明：
# 格式化美元价: usaPrice的amount
# decimal_place： 是保留多少小数位
# dec_point： 是小数点符号
# thousands_sep:是千位分割符号
# 获取格式化美元价
usa_price_amount = Decimal('59.24')
value = Decimal('160.234')
symbol_left = '₹'
symbol_right = ""
decimal_place = '2'
dec_point = '.'
thousands_sep = ','
calculate_decimal = usa_price_amount * value
# 保留几位小数
save_decimal_place_str = "%.{0}f".format(int(decimal_place)) % (
calculate_decimal)
# 逗号
comma_str = ","
# 点号
dot_str = "."
if thousands_sep == comma_str and dec_point == dot_str:
thousands_sep_comma_str = "{:,}".format(Decimal(save_decimal_place_str))
result = symbol_left + thousands_sep_comma_str + symbol_right
else:
# 按照文档：由于小数点符号和千位分割符号，
# 会出现小数点符号是逗号，千位分割符号为点号
# 所以对save_decimal_place_str进行拆分
# 小数点左边
split_result = save_decimal_place_str.split('.')
radix_point_left_str = split_result[0]
# 小数点右边
radix_point_right_str = ""
if 1 < len(split_result):
radix_point_right_str = save_decimal_place_str.split('.')[1]
# 千分位的分隔符以逗号作为基准
thousands_sep_comma_str = "{:,}".format(
Decimal(radix_point_left_str))
# 如果千分位的分隔符不是逗号
if thousands_sep != comma_str:
radix_point_left_str = thousands_sep_comma_str.replace(',',
thousands_sep)
else:
radix_point_left_str = thousands_sep_comma_str
new_res = radix_point_left_str + dec_point + radix_point_right_str
result = symbol_left + new_res + symbol_right
except Exception as e:
pass
return result
print(test())
"""

 

 
I have a large dataframe which has a column called Lead Rev. This column is a field of numbers such as (100000 or 5000 etc.) I want to know how to format these numbers to show commas as thousand separators. The dataset has over 200,000 rows.
 
Is it something like: '{:,}'.format('Lead Rev')
 
which gives this error:
 
---------------------------------------------------------------------------
 
ValueError Traceback (most recent call last)
 
 in ()
 
----> 1 '{:,}'.format('Lead Rev')
 
ValueError: Cannot specify ',' or '_' with 's'.
 
解决方案
 
To make all your floats show comma separators by default in pandas versions 0.23 through 0.25 set the following:
 
pd.options.display.float_format = '{:,}'.format
 
In pandas version 1.0 this leads to some strange formatting in some cases.

 

 
I have a dataframe which has a column called "Lead Rev" This column is a field of numbers such as (100000 or 5000 etc..). I want to know how to format these numbers to show commas as thousand separators.
 
Is it something like: '{:,}'.format('Lead Rev')
 
'Lead Rev' is my column name. I have over 200,000 rows in my dataset.
 
This is my error:
 
ValueError Traceback (most recent call last)
 
in ()
 
----> 1 '{:,}'.format('Lead Rev')
 
ValueError: Cannot specify ',' or '_' with 's'.
 
解决方案
 
You can use apply() to get the desired result. This works with floating too
 
import pandas as pd
 
series1 = pd.Series({'Value': 353254})
 
series2 = pd.Series({'Value': 54464.43})
 
series3 = pd.Series({'Value': 6381763761})
 
df = pd.DataFrame([series1, series2, series3])
 
print(df.head())
 
Value
 
0 3.532540e+05
 
1 5.446443e+04
 
2 6.381764e+09
 
df['Value'] = df.apply(lambda x: "{:,}".format(x['Value']), axis=1)
 
print(df.head())
 
Value
 
0 353,254.0
 
1 54,464.43
 
2 6,381,763,761.0

 
 
 
 
 
  
>>>'{:,}'.format(1234567890)
>>>'1,234,567,890'
 
 
 
 
 
 
 

 
转载于:https://www.cnblogs.com/sea-stream/p/10232674.html