Pandas数值计算与排序

来源：互联网发布：影楼设计软件编辑：程序博客网时间：2024/05/21 04:24

import pandas as pdfood_info = pd.read_csv("D:\\test\\food_info.csv")  #此处需要转义print(food_info.head(2))

   NDB_No                 Shrt_Desc  Water_(g)  Energ_Kcal  Protein_(g)  \0    1001          BUTTER WITH SALT      15.87         717         0.85   1    1002  BUTTER WHIPPED WITH SALT      15.87         717         0.85      Lipid_Tot_(g)  Ash_(g)  Carbohydrt_(g)  Fiber_TD_(g)  Sugar_Tot_(g)  \0          81.11     2.11            0.06           0.0           0.06   1          81.11     2.11            0.06           0.0           0.06           ...        Vit_A_IU  Vit_A_RAE  Vit_E_(mg)  Vit_D_mcg  Vit_D_IU  \0       ...          2499.0      684.0        2.32        1.5      60.0   1       ...          2499.0      684.0        2.32        1.5      60.0      Vit_K_(mcg)  FA_Sat_(g)  FA_Mono_(g)  FA_Poly_(g)  Cholestrl_(mg)  0          7.0      51.368       21.021        3.043           215.0  1          7.0      50.489       23.426        3.012           219.0  [2 rows x 36 columns]

#需求：将g转化为mgw_g = food_info["Water_(g)"]w_mg = w_g*1000food_info["Water_(mg)"] = w_mg   #在这这个文件里新添加一列print (w_g.head(3))print (w_mg.head(3))print (food_info["Water_(mg)"].head(3))

0    15.871    15.872     0.24Name: Water_(g), dtype: float640    15870.01    15870.02      240.0Name: Water_(g), dtype: float640    15870.01    15870.02      240.0Name: Water_(mg), dtype: float64

w_mg = food_info["Water_(g)"]*food_info["Vit_E_(mg)"]print (w_mg.head(3))

0    36.81841    36.81842     0.6720dtype: float64

w_mg = w_mg/w_mg.max()print (w_mg.head(3))

0    0.15871    0.15872    0.0024Name: Water_(g), dtype: float64

test = food_info["FA_Poly_(g)"]print (test.head(3))food_info.sort_values("FA_Poly_(g)",inplace=True)   #按照升序进行排序test = food_info["FA_Poly_(g)"]print (test.head(3))

701     22.5413634     0.0904492     1.367Name: FA_Poly_(g), dtype: float644348    0.04243    0.06154    0.0Name: FA_Poly_(g), dtype: float64

food_info.sort_values("FA_Poly_(g)",inplace=True,ascending=False)   #按照降序进行排序test = food_info["FA_Poly_(g)"]print (test.head(3))

656     74.623662     69.9008431    67.849Name: FA_Poly_(g), dtype: float64

0 0