我正在将数据框中的列四舍五入为最接近5的浮点数。在这之后,我将列值转换为字符串,但这样做时,浮点数会恢复为未四舍五入状态。我正在使用Python 2.7。
import pandas as pd
df=pd.read_excel(C:"path")
def custom_round(x, base=5):
return base * round(float(x)/base)
df['A'] = df['kl'].apply(lambda x: custom_round(x, base=.05))
df['b'] = "D = " + df['A'].astype(str)
kl A b
0.600001 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.600000 0.60 D = 0.6000000000000001
0.600000 0.60 D = 0.6000000000000001
0.600587 0.60 D = 0.6000000000000001
0.601573 0.60 D = 0.6000000000000001
0.601168 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.600000 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.600001 0.60 D = 0.6000000000000001
0.850001 0.85 D = 0.8500000000000001
{:,.2f}'.format(s)
中的数字改为2即可。 - Jose Vasquez