Andreja Ho's Projects
In this project, I am performing A/B testing for the companyβs new website. I performed hypothesis testing with Python and NumPy to determine p-value and used regression models to advise if the company should launch a new website. The result is robust statistical analysis and interpretation of results to ensure the right decision for the company.
Analysis using Pyspak, Google Colab, and AWS.
My Personal Repository
City Bike Analysis with Tableau
training in progress...
prework
For this project I am utilizing several models of supervised machine learning on credit loan data in order to predict credit risk. I used Python Scikit-learn library and several machine learning models (Supervised Machine Learning Models - Logistic Regression, Random Forest, AdaBoost Classifier, Cluster Centroids, Oversampling & Undersampling) to compare the strengths and weaknesses of ML models and determine how well a model classifies and predicts data.
Supervised ML
Udacity Data Analyst Nanodegree
Udacity Data Analyst Nanodegree (DAND) Projects Portfolio. This repository is dedicated to Udacityβs Data Analyst Nanodegree Program (DAND). It contains all major projects, completed in the program.
Extensive EDA
In this analysis, I wrote a Python script that generates a vote count per candidate and per county and creates a report for U.S. congressional race in a Colorado precinct.
Data Visualization with Python, Pandas, Matplotlib and Seaborn
πβ¨ Help beginners to contribute to open source projects
A robot powered training repository :robot:
My first repo
For this data analysis, I am using MS Excel, including interactive pivot tables and charts, conditional formatting, advanced filters, VLOOKUPs, Box and Whiskers Charts, and other advanced Excel formulas.
An interactive earthquake maps with JavaScript and Leaflet
Statistical Analysis with R - Summary Statistics, T-Tests, ANOVA
Web-scraping with HTML and CSS
For this project I am creating an ETL (Extract, Transform, and Load) pipeline using Python, RegEx, and SQL Database. The goal is to retrieve data from different sources, clean and transform it into a useful format and finally load the data into an SQL database where the data is ready for further analysis. The result is an established automated pipeline and a clean data set stored in an SQL database.
My Personal Page
ML Neural Network Analysis
In this project, I am using ERDs and Schemas to design databases and writing intermediate-level SQL queries to answer important business questions for the companyβs HR department. The result is a well-structured database with implemented constraints, foreign and primary keys.
For this project, I am using JavaScript and Plotly.js to create an interactive dashboard for a biotechnology company. The result is a well-designed dashboard with several different charts that clearly communicate findings. The dashboard is deployed via GitHub pages where users can interact with the dashboard.
Child Mortality Analysis
Ride Share Analysis with Matplotlib
Pandas school grades analysis
VBA stock-market analysis. For this data analysis I am using Microsoft Visual Basic for Applications as a tool, including conditional statements, for loops, static and conditional formatting, and nevertheless code refactoring in order to improve its efficiency and clarity.