读取DataFrame的数据单元

取某行

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())