Session 1: Python language & ecosystem

• Notebooks and programming
• Python and Excel for data analytics
• Intro to variables, lists and data types
• Intro to numpy

pandas DataFrames

• Importing and exporting to and from Excel
• Manipulating rows and columns (adding, dropping, renaming)
• Aggregating and summarizing data sources
• Merging and appending

Data visualization with seaborn

• Information design best practices
• Constructing univariate and bivariate visualizations
• Creating custom visuals and readapting work

Working with time series

• Converting and formatting dates and times
• Aggregating time series data (resampling)
• Window functions: leads, lags, moving averages