For Loop抛给我一个Loop[重复]

Question

我有一个循环，循环一个数据帧的长度，并遍历一个团队列表。我的循环应该经过41行，但它只做了2行，然后停止，我不知道为什么它停止了。在我看来，我应该循环通过整个41个队名单，但它停止后索引两个队。

import pandas as pd

excel_data_df = pd.read_excel('New_Schedule.xlsx', sheet_name='Sheet1', engine='openpyxl')

print(excel_data_df)
print('Data Frame Above')
yahoot = len(excel_data_df)
print('Length Of Dataframe Below')
print(yahoot)

for games in excel_data_df:
    yahoot -= 1
    print(yahoot)
    searching = excel_data_df.iloc[yahoot, 0]
    print(searching)
    excel_data_df2 = pd.read_excel('allstats.xlsx', sheet_name='Sheet1', engine='openpyxl')
    print(excel_data_df2)
    finding = excel_data_df2[excel_data_df2['TEAM:'] == searching].index
    print(finding)

这是运行日志

HOME TEAM:            AWAY TEAM:
0         Portland St.             Weber St.
1               Nevada             Air Force
2                 Utah                 Idaho
3         San Jose St.           Santa Clara
4        Southern Utah  SAGU American Indian
5        West Virginia              Iowa St.
6             Missouri          Prairie View
7    Southeast Mo. St.             UT Martin
8          Little Rock       Champion Chris.
9        Tennessee St.               Belmont
10         Wichita St.           Emporia St.
11           Tennessee        Tennessee Tech
12                FGCU          Webber Int'l
13    Jacksonville St.      Ga. Southwestern
14       Northern Ill.           Chicago St.
15  Col. of Charleston         Western Caro.
16        Georgia Tech           Florida A&M
17               Rider                  Iona
18               Tulsa      Northwestern St.
19        Rhode Island              Davidson
20      Washington St.           Montana St.
21             Montana         Dickinson St.
22       Robert Morris         Bowling Green
23        South Dakota                 Drake
24            Richmond        Loyola Chicago
25    Coastal Carolina           Alice Lloyd
26        Presbyterian    South Carolina St.
27        Morehead St.                  SIUE
28       San Diego St.                   BYU
29               Siena              Canisius
30            Monmouth         Saint Peter's
31              Howard               Hampton
32           App State        Columbia Int'l
33       Southern Ill.          North Dakota
34         Norfolk St.                  UNCW
35             Niagara             Fairfield
36            N.C. A&T            Greensboro
37       Western Mich.         Central Mich.
38              DePaul                Xavier
39         Georgia St.                Carver
40      Northern Ariz.         Eastern Wash.
41        Gardner-Webb                   VMI
Data Frame Above
Length Of Dataframe Below
42
41
Gardner-Webb
                TEAM:  TOTAL POINTS:  ...  TURNOVER RATIO:  ASSIST TO TURNOVER RANK
0     Mount St. Marys            307  ...               65                    239.0
1       Saint Josephs            163  ...               28                     81.0
2    Saint Marys (CA)            518  ...               78                    114.0
3        Saint Peters            399  ...               86                    145.0
4     St. John's (NY)            656  ...              115                     73.0
..                ...            ...  ...              ...                      ...
314           Wofford            327  ...               54                    113.0
315        Wright St.            220  ...               47                    206.0
316           Wyoming            517  ...               64                     27.0
317            Xavier            582  ...               84                     12.0
318    Youngstown St.            231  ...               30                     79.0

[319 rows x 18 columns]
Int64Index([85], dtype='int64')
40
Northern Ariz.
                TEAM:  TOTAL POINTS:  ...  TURNOVER RATIO:  ASSIST TO TURNOVER RANK
0     Mount St. Marys            307  ...               65                    239.0
1       Saint Josephs            163  ...               28                     81.0
2    Saint Marys (CA)            518  ...               78                    114.0
3        Saint Peters            399  ...               86                    145.0
4     St. John's (NY)            656  ...              115                     73.0
..                ...            ...  ...              ...                      ...
314           Wofford            327  ...               54                    113.0
315        Wright St.            220  ...               47                    206.0
316           Wyoming            517  ...               64                     27.0
317            Xavier            582  ...               84                     12.0
318    Youngstown St.            231  ...               30                     79.0

[319 rows x 18 columns]
Int64Index([180], dtype='int64')

Answer 1

对于index中的i使用，而对于Excel_data_df.iterrrows()使用data。

DataFrame.iterrows（）作为（索引,系列）对迭代数据帧行。