Python
Python analytics projects
Clean, explore and analyse real datasets with pandas and NumPy, then submit your notebook and write up what you found.
Where your code runs
Open the lab
Pick a project in the Python lab and its dataset is loaded into data/ for pandas.
Solve the exercises
Each project has graded exercises with hints. Submit a cell and it is marked on the server for points.
Analyse
Clean the data, explore it, and produce a defensible figure for each business question, in the lab or your own notebook.
Submit
Download your notebook as .ipynb, or link your GitHub repository, and write your summary.
What you will practise
Core libraries
- pandas
- NumPy
- Matplotlib
- Seaborn
Analysis
- Data cleaning
- Missing values
- Exploratory data analysis
- Grouping and aggregation
- Joins and merges
- Statistical analysis
- Time series
Working with data
- CSV
- Excel
- JSON
- Parquet
- API extraction
- Writing analysis reports
What you submit
- A Jupyter notebook (.ipynb) or Python script (.py)
- A GitHub repository link, if you use one
- Charts saved as images, or rendered in the notebook
- A written summary of your findings and recommendations
Python projects(4)
- FinanceBeginner
Kenya Employee Salary Analysis
Answer a CEO's pay questions from a 420-person payroll: who earns what, where the money goes, and which departments are over budget.
Your role: People Analyst, Savanna Tech Group
- Filtering and sorting
- Aggregation
- Subqueries
SQLPython- Estimated time
- 6h
- Participants
- 1


- Public SectorIntermediate
Nairobi Air Quality Batch Pipeline with Apache Airflow
Automate Nairobi's OpenAQ air-quality feed into PostgreSQL with an Airflow DAG that can be rerun safely.
Your role: Data Engineer, Nairobi environmental data platform team
- Apache Airflow
- TaskFlow API
- Dynamic task mapping
PythonSQL- Estimated time
- 24h
- Participants
- 0


- FinanceAdvanced
Credit Risk Prediction
Predict which Kenyan digital-loan customers will default, from 68,000 loan records and FRED macro indicators, and ship the model as an API.
Your role: Data Scientist, credit risk team at a Kenyan digital lender
- Binary classification
- Data cleaning
- Exploratory data analysis
PythonSQL- Estimated time
- 30h
- Participants
- 0


- Public SectorAdvanced
Water Pump Functionality Prediction
Classify 59,400 Tanzanian waterpoints as functional, needing repair or broken, and serve the model from a Flask form.
Your role: Data Scientist, Ministry of Water and NGO maintenance partners, Tanzania
- Multiclass classification
- Data merging
- Missing and placeholder values
PythonSQL- Estimated time
- 28h
- Participants
- 0


Current section: /python