pandas显示百分数,在pandas中将某些浮动数据框列设置为百分比

I am trying to write a paper in IPython notebook, but encountered some issues with display format. Say I have following dataframe df, is there any way to format var1 and var2 into 2 digit decimals and var3 into percentages.

var1 var2 var3

id

0 1.458315 1.500092 -0.005709

1 1.576704 1.608445 -0.005122

2 1.629253 1.652577 -0.004754

3 1.669331 1.685456 -0.003525

4 1.705139 1.712096 -0.003134

5 1.740447 1.741961 -0.001223

6 1.775980 1.770801 -0.001723

7 1.812037 1.799327 -0.002013

8 1.853130 1.822982 -0.001396

9 1.943985 1.868401 0.005732

The numbers inside are not multiplied by 100, e.g. -0.0057=-0.57%.

解决方案

replace the values using the round function, and format the string representation of the percentage numbers:

df['var2'] = pd.Series([round(val, 2)