我有一個非常簡單的程序,我需要在多組檔案中重復多次,但不知道如何使它成為一個 for 回圈。從本質上講,我只是加載一個 CSV 并每次添加一個名為“sample_year”的列。然后用年份填充整個列(可以在每個檔案名的相同位置找到)。
請看下面我想變成for回圈的程序。
pff_grade2021 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2021.csv")
pff_grade2021['sample_year'] = [2021]
pff_grade2020 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2020.csv")
pff_grade2020['sample_year'] = [2020]
pff_grade2019 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2019.csv")
pff_grade2019['sample_year'] = [2019]
pff_grade2018 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2018.csv")
pff_grade2018['sample_year'] = [2018]
pff_grade2017 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2017.csv")
pff_grade2017['sample_year'] = [2017]
pff_grade2016 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2016.csv")
pff_grade2016['sample_year'] = [2016]
pff_grade2015 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2015.csv")
pff_grade2015['sample_year'] = [2015]
pff_grade2014 = pd.read_csv(r"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade 2014.csv")
pff_grade2014['sample_year'] = [2014]
uj5u.com熱心網友回復:
多年來回圈并將其插入到路徑中。
grades = {}
for year in range(2014, 2022):
grades[year] = pd.read_csv(fr"C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade\Pass Grade {year}.csv")
grades[year]['sample_year'] = [year]
uj5u.com熱心網友回復:
您可以從路徑中提取檔案串列,然后使用 for 回圈,如下所示:
import os
path = r'C:\Users\yanke\OneDrive - Stetson University, Inc\Personal\final_projects\nfl_prospect_model\prospect_data\qb\pff\passing_grade'
files = os.listdir(path)
for f in files:
pff_grade = pd.read_csv(r'{}\{}'.format(path,f)
pff_grade['sample_year'] = f[-8:-4]
轉載請註明出處,本文鏈接:https://www.uj5u.com/caozuo/456886.html
上一篇:用流替換通常的for回圈
