目標： 我想在每個 NFL 比賽周創建一個資料框，如下所示：
Week 1
Home Away
Arizona Cardinals Tennessee Titans
Los Angeles Chargers Washington Football Team
.
.
.
Week 2
Home Away
.
.
.
我有什么： 時間表的資料框作為網格：
print(df_sched)
0 Week Arizona Cardinals Atlanta Falcons Baltimore Ravens ... San Francisco 49ers Tampa Bay Buccaneers Tennessee Titans Washington Football Team
1 1 @Tennessee Titans Philadelphia Eagles @Las Vegas Raiders ... @Detroit Lions Dallas Cowboys Arizona Cardinals Los Angeles Chargers
2 2 Minnesota Vikings @Tampa Bay Buccaneers Kansas City Chiefs ... @Philadelphia Eagles Atlanta Falcons @Seattle Seahawks New York Giants
3 3 @Jacksonville Jaguars @New York Giants @Detroit Lions ... Green Bay Packers @Los Angeles Rams Indianapolis Colts @Buffalo Bills
4 4 @Los Angeles Rams Washington Football Team @Denver Broncos ... Seattle Seahawks @New England Patriots @New York Jets @Atlanta Falcons
建議的解決方案：
- 我會創建一個空的 df_temp=['Away', 'Home'] 并開始使用 iterrows 填充它。
- 根據行值中是否有“@”，行中的團隊為“Home”-Team，否則列標題中的團隊為“Home”-Team。
- 結果應該是每個游戲周一個 df (df_week1, df_week2, ..., df_week18)
uj5u.com熱心網友回復：
import pandas as pd
cols = ['Week','Arizona Cardinals','Atlanta Falcons','Baltimore Ravens',
'San Francisco 49ers','Tampa Bay Buccaneers','Tennessee Titans',
'Washington Football Team']
data = [[1,'@Tennessee Titans','Philadelphia Eagles','@Las Vegas Raiders','@Detroit Lions','Dallas Cowboys','Arizona Cardinals','Los Angeles Chargers'],
[2,'Minnesota Vikings','@Tampa Bay Buccaneers','Kansas City Chiefs','@Philadelphia Eagles','Atlanta Falcons','@Seattle Seahawks','New York Giants'],
[3,'@Jacksonville Jaguars ','@New York Giants','@Detroit Lions','Green Bay Packers','@Los Angeles Rams','Indianapolis Colts','@Buffalo Bills'],
[4, '@Los Angeles Rams','Washington Football Team','@Denver Broncos','Seattle Seahawks','@New England Patriots','@New York Jets','@Atlanta Falcons']]
df = pd.DataFrame(data, columns=cols)
dfs = {}
for idx, row in df.iterrows():
rows = []
for alpha, beta in row.iteritems():
if alpha == 'Week':
df_name = 'df_week%.2d'
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/333461.html