Stata
Interface, do-files, loading and saving datasets
2 Data Cleaning and Variable Management
generate, replace, rename, drop, keep, order, label
3
Sorting and Group-wise Operations
sort, gsort, bysort, egen, duplicates
4
Combining and Reshaping Datasets
merge, append, reshape, data validation
5
Macros and Loops I
local, global, foreach, forvalues
6
Macros and Loops II
Conditional processing, nested loops, automated tasks
7
Advanced Data Management
Dates, strings, missing values, assert, isid
8
Data Aggregation and Panel Data Management
collapse, contract, panel structure, xtset
9
Reproducible Data Management
tempfile, log-files, automated cleaning, complete data pipelines
Python
10
Introduction to Python and Google Colab
Variables, lists, dictionaries, conditions, loops
11
Data Management Using pandas
DataFrames, CSV/Excel, filtering, merging, exporting data
12
Introduction to Web Scraping
HTML, requests, BeautifulSoup
13
Practical Web Scraping
Extracting tables, text, links, multiple pages
14
APIs and Automated Web Data Collection
JSON, APIs, pagination, error handling, responsible scraping
15
Final Project: Building a Research Dataset
Web data collection, cleaning with pandas, exporting to Stata