Graph Databases for Perovskite Solar Cell Manufacturing Website GitHub Repo

Language/Framework: Python, Neo4j (database), pandas (data processing)

Description: Designed and built a graph database for a solar cell research lab, allowing analysis of large data volumes across batches to optimize solar cell efficiency. Collaborate with a groupmate to implement a data pipeline to transform the lab's raw JSON output to database's input.

SpotiTube Demo Video GitHub Repo

Language/Framework: Python, Flask (web framework), OAuth 2.0, REST API

Description: Full stack web appplication to transfer and continuously update a playlist from Spotify to YouTube Music. The app follows standard OAuth 2.0 flow to securely log in the users from both Spotify and Google. Everyday, the app's scheduler periodically scans the selected playlist and updates newly added songs to YouTube Music.

Vietnam War Veterans Visualization Python Notebook Database

Language/Framework: Python, pandas (analysis), JavaScript (visualization), D3.js (visualization), BeautifulSoup4 (web scraping), Flask (database backend), SQLite3 (database)

Description (Analysis): Web scraped using BeautifulSoup to obtain the data. Performed exploratory data analysis and feature engineering to extract geological patterns in casualties. Utilized D3.js to visualize and plot different maps and charts on the website.

Description (Database): Designed schema table and imported the raw data to SQLite3 database. Built a website using Flask framework to query for multiple keywords search in SQLite.

PDF Merger Website Download

Language/Framework: Python, PyPDF2 (Python library), Tkinter (GUI)

Description: A light Python application to combine multiple PDF files into a single file. The app offers batch processing, customizable file order, and a user-friendly interface.