Dataset: Taxi trip data NYC
- 20 mins intro
- 30 mins no code practical
- 30 mins code practical
- 10 mins wrap
With both examples we will carry out like for like tasks in Excel and with python.
-
Filling in missing values
-
Removing incorrect values
-
Formatting dates
-
Filtering data
-
Producing summary statistics
-
Transformation of data
-
(Resampling etc monthly totals)
-
Introduction to tabular data
-
No code tools for handling data
- Excel/Google Sheets
- PowerBi
-
Code options for handling tabular data
- Python
- R
- Other
Session 1 Files link https://tinyurl.com/to-code-one https://1drv.ms/f/s!Aih6bFtYB2QLaxYmXdOemKXsUHk?e=BfctY6
Session 2 Files Link https://tinyurl.com/to-code-two https://1drv.ms/f/s!Aih6bFtYB2QLbNB697KGg68HkFA?e=X9C87V
Tasks
- Create spreadsheets containing initial data
- Littlest jupyter hub setup - 1 VM
- Things to do if people complete the main task