NorthStar Databases and Analytics Coursework

Module: CP60056E — Databases and Analytics
Student: Abdul Aaqib Ali Abdul Aasik Ali
Supervisor: Dr Shidrokh Goudarzi

Files

• analysis.py — Python data cleaning, SQL, stats, plots
• analysis.R — R analytics and SQL within R using sqldf
• mongo_load.py — loads documents into MongoDB Atlas
• mongo_demo.py — CRUD, indexes and explain plans
• notebooks/ — Colab notebook
• northstar_data/ — the 9 raw CSV files
• images/ — all generated charts
• output/ — CSV outputs

How to run

pip install pandas numpy matplotlib seaborn scipy scikit-learn pymongo
python analysis.py

install.packages(c("DBI","RSQLite","sqldf","dplyr","readr","ggplot2","tidyr","broom","scales"))
Rscript analysis.R

For MongoDB set the MONGO_URI environment variable then run mongo_load.py followed by mongo_demo.py.

Open the notebook in Colab using the badge above.