#########################Series import pandas as pd #一维数据 Series s1 = pd.Series([1,2,3,4,5], index=['a', 'b', 'c' , 'd', 'e' ]) s2 = pd.Series({2:3 , 3:4}) #Series的属性 print(s2.values, s2.index) for i in s2.values: print(i) #########################DataFrame import pandas as pd #创建dataframe第一种方式，使用相等长度列表的字典创建 df = pd.DataFrame({'x1':[1,2,3], 'x2':[4,5,6]}) df2 = pd.read_excel('yyy.xlsx') # print(df2.index, df2.columns, df2.values) df2.at[0, '空气质量等级'] = '优' fiter_ = df2['空气质量指数' ] == 80 print(df2[fiter_]) # print(df2.head(3), df2.tail(3))