pandas数值计算与排序方法
作者:数据阿伯 时间:2022-11-10 07:25:02
以下代码是基于python3.5.0编写的
import pandas
food_info = pandas.read_csv("food_info.csv")
# ---------------------特定列加减乘除-------------------------
print(food_info["Iron_(mg)"])
div_1000 = food_info["Iron_(mg)"] / 1000
add_100 = food_info["Iron_(mg)"] + 100
sub_100 = food_info["Iron_(mg)"] - 100
mult_2 = food_info["Iron_(mg)"]*2
# ---------------------某两列相乘---------------------------
water_energy = food_info["Water_(g)"] * food_info["Energ_Kcal"]
# ----------------------把某一列除1000,再添加新列----------------------------
iron_grams = food_info["Iron_(mg)"] / 1000
food_info["Iron_(g)"] = iron_grams
#-------------------Score=2×(Protein_(g))−0.75×(Lipid_Tot_(g))--------------
weighted_protein = food_info["Protein_(g)"] * 2
weighted_fat = -0.75 * food_info["Lipid_Tot_(g)"]
initial_rating = weighted_protein + weighted_fat
#----------------------------数据归一化-----------------------------------
max_calories = food_info["Energ_Kcal"].max() #找列最大值
normalized_calories = food_info["Energ_Kcal"] / max_calories
normalized_protein = food_info["Protein_(g)"] / food_info["Protein_(g)"].max()
normalized_fat = food_info["Lipid_Tot_(g)"] / food_info["Lipid_Tot_(g)"].max()
food_info["Normalized_Protein"] = normalized_protein
food_info["Normalized_Fat"] = normalized_fat
# -------------------------------排序----------------------------------
food_info.sort_values("Sodium_(mg)", inplace=True) #升序,inplace=True表示不从建DataFrame
print(food_info["Sodium_(mg)"])
food_info.sort_values("Sodium_(mg)", inplace=True, ascending=False) #降序,ascending=False表示降序
print(food_info["Sodium_(mg)"])
来源:https://blog.csdn.net/qq_32005671/article/details/61629873
标签:pandas,排序,数值,计算
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
np.newaxis 实现为 numpy.ndarray(多维数组)增加一个轴
2021-02-14 07:48:20
Python实现在线音乐播放器
2021-08-24 04:29:12
![](https://img.aspxhome.com/file/2023/3/79683_0s.jpg)
asp如何让页面过时并指定一个过时时间?
2010-05-13 16:40:00
python实现进度条的多种实现
2021-03-20 10:39:52
![](https://img.aspxhome.com/file/2023/1/82581_0s.png)
已解决卸载pip重新安装的方法
2023-09-27 22:08:02
![](https://img.aspxhome.com/file/2023/9/107059_0s.png)
使用Python设置tmpfs来加速项目的教程
2023-12-24 09:38:34
Python如何实现定时器功能
2023-04-13 23:19:28
Python流程控制if条件选择与for循环
2022-04-03 21:09:52
![](https://img.aspxhome.com/file/2023/8/131648_0s.png)
Pytorch 多块GPU的使用详解
2021-01-21 09:19:09
![](https://img.aspxhome.com/file/2023/0/135240_0s.jpg)
Protobuf在Cmake中的正确使用方法详解
2024-01-02 01:26:12
![](https://img.aspxhome.com/file/2023/1/123771_0s.png)
MySQL查询优化之explain的深入解析
2024-01-17 02:29:02
详解Python进阶之切片的误区与高级用法
2022-09-18 04:03:12
Python Matplotlib绘图基础详细教程
2024-01-16 04:34:41
![](https://img.aspxhome.com/file/2023/0/119710_0s.jpg)
Python设置Word全局样式和文本样式的示例代码
2022-06-29 05:06:07
![](https://img.aspxhome.com/file/2023/8/82558_0s.jpg)
python读取hdfs上的parquet文件方式
2021-04-07 11:54:31
python如何利用traceback获取详细的异常信息
2023-06-14 00:53:18
如何在ACCESS中插入超级链接?
2007-10-22 12:13:00
![](https://img.aspxhome.com/file/UploadPic/200710/22/2007102212225806s.gif)
vue 表单之通过v-model绑定单选按钮radio
2023-07-02 16:28:04
![](https://img.aspxhome.com/file/2023/8/139668_0s.gif)
perl子程序的运用及子程序中变量私有(my)声明的重要性
2023-08-10 18:13:49
Python实现设置显示屏分辨率
2021-05-16 01:32:36
![](https://img.aspxhome.com/file/2023/7/70867_0s.png)