Introduction to data analysis and manipulation tools.
Notes and materials from in-class session
- Summary of class discussion: PDF
- Raw dataset used: XLS
- Link to Spreadsheets including commands executed in class
- List of SQL commands used in class: PDF
- Python
- CSV version of NFL used in the sample python codes: CSV
- Simple example of Python code used to aggregate home game statistics of each team (number of games played and total score on home field): PY
- Transformed data (aggregate statistics for each team in home versus away games) used in sample visualization: CSV
- Code used to generate above transformed data: PY
Data manipulation tools / languages
- Spreadsheets
- SQL
- Online applications
- Tutorials
- Python
- Online interpreters
- Tutorials
Data visualization tools