我有一個數(shù)據(jù)框：行索引都是人名。列索引是對 7 個不同問題的所有評分 1-10。因此，數(shù)據(jù)框由 1-10 的所有數(shù)字組成：每個人（行）的每個問題（列）的數(shù)字。它看起來像這樣： Q1. Q2. Q3. Q4. Q5. Q6. Q7. Lotte 4 6 4 5 8 6 5Lara 5 7 8 7 9 7 6Linda 7 7 8 8 7 8 6Tom 9 8 7 9 6 9 7Jantje 9 9 9 10 7 10 8然后我想創(chuàng)建一個 for 循環(huán)來遍歷這些數(shù)據(jù)（稱為“分數(shù)”），檢查每個數(shù)字。如果數(shù)字<5，我想打?。骸皩τ凇癚UESTION”的“NAME”，它低于5”。所以，fe：對于樂天來說，第一季度它低于 5。我現(xiàn)在有以下代碼：for i in range(len(Score.columns)): for j in range(len(Score)): if Score.iloc[j,i] < 5: print ("Lower for %d" %i)這僅打印列號，但我想打印列和行，但由索引命名。誰能幫忙打印這個嗎？
1 回答
RISEBY
TA貢獻1856條經(jīng)驗 獲得超5個贊
這是相當(dāng)簡單的
您可以使用數(shù)據(jù)框方法iterrows來迭代您的行，然后處理單行以提取您的知識。為了完整起見，我生成了一個示例數(shù)據(jù)框來演示該行為：
import pandas as pd
import random
# here I am generating my dataframe similiar to yours
list_of_dicts = [{'Q'+str(i)+'.':random.randrange(10) for i in range(1, 8)} for j in range(5)]
index = ['Lotte', 'Lara', 'Linda', 'Tom', 'jantje']
df = pd.DataFrame(list_of_dicts)
df.index = index
# here you can see the df structure
print(df)
# here the algorithm
for row in df.iterrows():
name = row[0]
print("For " + name)
for key in row[1].keys():
if row[1][key] < 5:
print("for {} it is Lower than 5".format(key))
我的數(shù)據(jù)框：
Q1. Q2. Q3. Q4. Q5. Q6. Q7.
Lotte 6 8 5 8 8 1 6
Lara 1 7 0 7 5 5 1
Linda 6 6 0 3 9 7 4
Tom 5 8 2 5 3 8 3
jantje 5 5 9 9 5 0 3
我的輸出：
For Lotte
for Q6. it is Lower than 5
For Lara
for Q1. it is Lower than 5
for Q3. it is Lower than 5
for Q7. it is Lower than 5
For Linda
for Q3. it is Lower than 5
for Q4. it is Lower than 5
for Q7. it is Lower than 5
For Tom
for Q3. it is Lower than 5
for Q5. it is Lower than 5
for Q7. it is Lower than 5
For jantje
for Q6. it is Lower than 5
for Q7. it is Lower than 5
添加回答
舉報
0/150
提交
取消