迭代DataFrame行处理NFL赛程 按比赛周生成独立新DataFrame
目标
我需要为每个NFL比赛周生成一个单独的DataFrame,格式如下:
Week 1 Home Away Arizona Cardinals Tennessee Titans Los Angeles Chargers Washington Football Team . . . Week 2 Home Away . . .
现有数据
网格格式的赛程DataFrame df_sched,内容如下:
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
实现思路
- 创建列名为
['Away', 'Home']的空临时DataFramedf_temp,使用iterrows遍历原DataFrame行填充数据。 - 判断单元格值是否包含
@:若包含则单元格中@后的球队为Home(主队),列头对应球队为Away(客队);反之列头对应球队为主队,单元格值为客队。 - 最终输出18个按周拆分的DataFrame,分别命名为
df_week1、df_week2、……、df_week18。
内容的提问来源于stack exchange,提问作者Daniel
相关产品推荐
相关产品推荐

