data = pd.DataFrame(dict)
print(data)
test = []
for indexs in data.index:
print(data.loc[indexs].values[0])
if data.loc[indexs].values[0] == 1 or data.loc[indexs].values[0] == 2 or data.loc[indexs].values[0] == 3:
print(data.loc[indexs].values[0:6])
test.append(list(data.loc[indexs].values[0:6]))
print(test)
test=pd.DataFrame(test)
print(test)
可以用index和values表示DataFrame的行和列,这样可以对单独的数据进行操作。
此外还可以和array和list互转。
a = [[32.6, 2.28, 30.32, 93.0, 28.0, 26.0, 1.7, 48.0, 31.0, 0.31, 0.51, 0.32, 0.53, 3.75, 596.25, 87.9, 3.88, 28.18, 58.0, 423.0, 0.0362, 0.7293, 3.1269, 21.2129, 57.0, 878.09, 3.0, 5.0, 55.12, 59.31, 26.67, 24.67, 413], [20.9, 1.48, 19.42, 92.9, 23.0, 22.0, 1.75, 55.0, 36.0, 0.32, 0.45, 0.32, 0.44, 2.8, 801.71, 92.58, 1.68, 20.96, 50.0, 624.0, 0.0509, 0.6072, 3.2063, 22.0271, 44.0, 878.09, 3.0, 5.0, 32.84, 69.77, 21.6, 20.53, 413]]
a=pd.DataFrame(a)
b=[]
c=[]
b.append(a.mean())
print(b)
b=np.array(b)
b=b.tolist()
print(b)