Day10 Pandas模组二

今天的影片为接续上一部的内容，以及介绍几个简单的统计函数
（还有短短的英文小教室...我要去跟英文老师跪算盘了呜呜呜）

以下为影片中有使用到的程序码

#使用元素为字典的串列建立DataFrame
import pandas as pd

data_1 = [{"Blue_peacock":20,"Green_peacock":30,"white_peacock":5},{"Blue_peacock":18,"Green_peacock":25,"white_peacock":4}]
years_1 = ["2019年", "2020年"]
zoo_1 = pd.DataFrame(data_1, index = years_1)
print(zoo_1)

#使用字典建立DataFrame
data_2 = {"Blue_peacock":[20,18], "Green_peacock":[30,25], "white_peacock":[5,4]}
years_2 = ["2019年", "2020年"]
zoo_2 = pd.DataFrame(data_2, index = years_2)
print(zoo_2)

import pandas as pd
data = {"Blue_peacock":[30,27,22], "Green_peacock":[30,26,24], "white_peacock":[30,28,20]}
years = [2019, 2020, 2021]
zoo = pd.DataFrame(data, index = years)
print(zoo)

#索引功能-直接索引
print(zoo['Green_peacock'])
print(zoo['Green_peacock'][2020])

#索引功能-使用属性
print("at:",zoo.at[2019,"Green_peacock"]) #列,行
print("iat:", zoo.iat[0,1])
print("loc:", zoo.loc[2020])
print("iloc:", zoo.iloc[0])

#简单的统计函数
import pandas as pd
data = {"Blue_peacock":[30,27,22], "Green_peacock":[26,30,24], "white_peacock":[10,15,20]}
location = [1, 2, 3]
zoo = pd.DataFrame(data, index = location)
print(zoo)

print("总和:", zoo["Green_peacock"].sum())
print("最多:", zoo["Green_peacock"].max())
print("最少:", zoo["Green_peacock"].min())
print("平均:", zoo["Green_peacock"].mean())
print("中位数:", zoo["Green_peacock"].median())
print("标准差:", zoo["Green_peacock"].std())

如果在影片中有说得不太清楚或错误的地方，欢迎留言告诉我，谢谢您的指教。