39.数据格式化-设置百分比

 

#  apply()设置百分比   map ()设置百分比

#设置百分比 
import pandas as pd 
df=pd.read_excel ('格式化数据.xls') 
print (df) 
print('1.------apply()设置百分比------------------------------------------')
df['百分比']=df ['A1']. apply (lambda x:format (x,'.0%')) # 对A1列进行设置百分比 
print (df) 
df['百分比']=df ['A1']. apply (lambda x: format (x,'.2%')) #  
print (df) 
print('2.------map ()设置百分比----------------------------------------------')
#map()函数 
df['百分比']=df ['A1' ]. map (lambda x: format (x, '.2%' )) 
print(df)

A1        A2        A3        A4        A5
0  0.527350  0.410396  0.131101  0.565818  0.322695
1  0.007817  0.663029  0.480029  0.551382  0.603932
2  0.123241  0.935813  0.052935  0.207342  0.183324
3  0.405295  0.623856  0.254653  0.368602  0.751753
4  0.195120  0.623856  0.477747  0.592885  0.751753
1.------apply()设置百分比------------------------------------------
         A1        A2        A3        A4        A5 百分比
0  0.527350  0.410396  0.131101  0.565818  0.322695    53%
1  0.007817  0.663029  0.480029  0.551382  0.603932     1%
2  0.123241  0.935813  0.052935  0.207342  0.183324    12%
3  0.405295  0.623856  0.254653  0.368602  0.751753    41%
4  0.195120  0.623856  0.477747  0.592885  0.751753    20%
         A1        A2        A3        A4        A5  百分比
0  0.527350  0.410396  0.131101  0.565818  0.322695  52.73%
1  0.007817  0.663029  0.480029  0.551382  0.603932   0.78%
2  0.123241  0.935813  0.052935  0.207342  0.183324  12.32%
3  0.405295  0.623856  0.254653  0.368602  0.751753  40.53%
4  0.195120  0.623856  0.477747  0.592885  0.751753  19.51%
2.------map ()设置百分比----------------------------------------------
         A1        A2        A3        A4        A5  百分比
0  0.527350  0.410396  0.131101  0.565818  0.322695  52.73%
1  0.007817  0.663029  0.480029  0.551382  0.603932   0.78%
2  0.123241  0.935813  0.052935  0.207342  0.183324  12.32%
3  0.405295  0.623856  0.254653  0.368602  0.751753  40.53%
4  0.195120  0.623856  0.477747  0.592885  0.751753  19.51%