取某行
loc、iloc
取某列
[xxx]
转换成Numpy array
values
import numpy as np
import pandas as pd
arr = pd.DataFrame({
's1': [27.93, 58.08, 38.67, 45.83, 70.26, 46.61, 49.73, 34.02, 56.64, 57.28],
's2': [28.18, 50.61, 31.73, 31.48, 55.96, 22.73, 40.47, 42.02, 31.39, 64.21],
's3': [29.39, 51.62, 57.91, 45.94, 53.81, 45.77, 69.13, 28.75, 43.43, 55.79],
's4': [40.52, 48.55, 59.23, 71.21, 58.48, 63.63, 55.16, 34.90, 54.65, 68.03],
's5': [26.26, 54.03, 49.08, 46.53, 43.23, 56.79, 58.71, 26.43, 44.97, 54.16]
},
index=['05-21', '05-22', '05-23', '05-24', '05-25', '05-26', '05-27', '05-28', '05-29', '05-30'],
)
print(arr)
#取某行
print(arr.loc['05-21'])
print(arr.iloc[0])
#取某列
print(arr['s1'])
#使用DataFrame存储了5家水果店(名字为s1 ~ s5)在10天中的销售情况,完成如下代码填空,打印出第一天销量最高的水果店10天的平均销量。
print(arr[arr.loc['05-21'].idxmax()].mean())
#每天所有水果店的平均销量
print(arr.mean(axis=1))
#获取所有数据的均值
print(arr.values.mean())