Explore the oldest creature in starwars
This blog explores the starwars dataset and shows how to (1) use request package to download json files; (2) use pandas to search the oldest creature; (3) find the nested structure of a json file.
Construct a SQLite3 Database of Spotify Songs in 3rd normal form (3NF)
This blog introduces the definition of 3NF, and shows the steps of constructing a SQLite3 database of spotify songs. An example SQL query to retrieve the names of all playlists that contain intrumentals is shown.
Informative Visualizations of Worldwide Malaria Data
This blog includes 3 functions that could be used for 3 problems from the Euler Project and the mathematical approach to solve these problems.