数据集获取

git clone https://github.com/wadefagen/college-covid19-dataset.git

curl -L -o repo.zip https://github.com/wadefagen/college-covid19-dataset/archive/refs/heads/master.zip
unzip repo.zip

源站 README 摘录（使用方式）

College COVID-19 Dataset

A dataset of COVID-19 cases and testing among college campuses.

• data/raw.csv contains the raw values gathered from the college COVID-19 dashboards.
• data/daily.csv “fills-forward” data to ensure every college has a daily data point, even when daily data is not provided.

Data Sources

Big Ten Conference Schools

• University of Illinois, https://go.illinois.edu/COVIDTestingData
• Indiana University, https://fall2020.iu.edu/dashboards/
• Maryland, https://umd.edu/covid-19-dashboard
• Michigan, https://campusblueprint.umich.edu/dashboard/
• Michigan State, https://msu.edu/together-we-will/testing-reporting/
• Ohio State, https://safeandhealthy.osu.edu/dashboard
• Penn State, https://virusinfo.psu.edu/covid-19-dashboard
• Rutgers, https://coronavirus.rutgers.edu/health-and-safety/testing-program-dashboard/
• Nebraska, https://covid19.unl.edu/unl-covid-19-dashboard
• Minnesota, https://safe-campus.umn.edu/return-campus/covid-19-dashboard
• Iowa, https://coronavirus.uiowa.edu/covid-19-numbers
• Northwestern, https://www.northwestern.edu/coronavirus-covid-19-updates/developments/confirmed-cases.html
• Purdue, https://protect.purdue.edu/dashboard/
• UW-Madison, https://smartrestart.wisc.edu/dashboard/

数据加载示例（表格/文本类）

import pandas as pd, glob, os

files = (glob.glob(os.path.join(path, "**", "*.csv"), recursive=True)
       + glob.glob(os.path.join(path, "**", "*.tsv"), recursive=True)
       + glob.glob(os.path.join(path, "**", "*.xlsx"), recursive=True))
print("数据文件:", files)
df = pd.read_csv(files[0])
print(df.shape); print(df.columns.tolist()); print(df.head(3))

完整仓库：github.com/wadefagen/college-covid19-dataset