Project Portfolio

Data Visulization and Storytelling

1. Analysis and report titled “From Past to Present: An Analytical Overview of Singapore’s Parliamentary Elections”
   • all report writing and data work and data appendix are done within RMarkdown
   • extract elections data from the Elections Department (ELD) via data.gov.sg API
   • Constuct a range of visually compelling visualization to highlight significant events

Language/Program used: R/R Studio, Packages: tidyverse, ggplot2, dplyr, jsonlite, geojsonsf

Data Wrangling, Analytics & Visualisation

1. Customer Satisfaction Analysis for a New Shopping Mall
   • Create Python scripts to automate the acquisition and processing of web and spreadsheet data;
   • Assemble effective data flows in MySQL, Python & R as part of a reproducible workflow process;
   • Design and implement effective data visualizations in R

Language/Prgram used: Python/Jupyter notebook, MySQL/TablePlus, R/R Studios

1. Data wrangling using MySQL statements
   • CREATE Table, ALTER Table, Modify data type, mapping data;
   • Generate summary tables to explain relationship amongst the variables in the dataset

Language/Program used: MySQL/TablePlus/MySQL Workbench

Hypothesis testing

• this project is to demostrate knowledge of how to conduct a two-sample hypothesis test
• using stats.ttest_ind(a, b, equal_var) function to conduct two-sample t-test

Language/Prgram used: Python/Jupyter notebook, libraries: Pandas, stats.scipy

Back to github