About Me
This is Yuhua Cai. Education Duke University Master of Engineering in Electrical and Computer Engineering Data Analyst and Machine Learning Engineer Hobby Basketball Contact Me Email: yuhua.cai@duke.edu »
Build My Personal Blog with Hugo and Github Pages
Introduction Hugo is one of the most popular open-source static generator and is written in GO. It is simple and easy to deploy. And Github Pages is a static web hosting service provided by Github which provides convenient deployment directly through Github repository. In this brief post I’ll walk you through how I created this website in 5 simple steps using Hugo and GitHub Pages. Step 1: Install Hugo and get a GitHub account As I’m a mac user, I’ll provide instructions here for installing Hugo on macOS. »
Three Euler Project Problems
Project Euler is a series of challenging mathematical/computer programming problems that will require more than just mathematical insights to solve. In this post, three problems solved from the Euler Project using Python. Every function was annotated with nuympy-styple docstrings. 1001st prime Problem 7 (420680 Solved) By listing the first six prime numbers: 2, 3, 5, 7, 11, and 13, we can see that the 6th prime is 13. What is the 10, 001st prime number? »
Malaria Data Visualization
Three informative visualizations about malaria are created using Python, starting with the data sets at https://github.com/rfordatascience/tidytuesday/tree/master/data/2018/2018-11-13. Malaria Dataset Malaria Dataset includes 3 informative datasets. 3 Datasets malaria_inc.csv - Malaria incidence by country for all ages across the world across time. malaria_deaths.csv - Malaria deaths by country for all ages across the world and time. malaria_deaths_age.csv - Malaria deaths by age across the world and time. »
SQLite3 schema for Spotify dataset in 3NF
Description: Download the Spotify songs data set. Create a SQLite3 schema to store this data in at least 3rd normal form (3NF), and populate the tables. Use an SQL query to find the names of all playlists that contain instrumentals. Spotify Songs Dataset First, let’s download and see the dataset we gonna use. It is a dataset of Spotify songs. df = pd.read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2020/2020-01-21/spotify_songs.csv')` df track_id track_name track_artist track_popularity track_album_id track_album_name track_album_release_date playlist_name playlist_id playlist_genre … key loudness mode speechiness acousticness instrumentalness liveness valence tempo duration_ms 0 6f807x0ima9a1j3VPbc7VN I Don’t Care (with Justin Bieber) - Loud Luxur… Ed Sheeran 66 2oCs0DGTsRO98Gh5ZSl2Cx I Don’t Care (with Justin Bieber) [Loud Luxury… 2019-06-14 Pop Remix 37i9dQZF1DXcZDD7cfEKhW pop … 6 -2. »