My Python Projects

What Is Python?

Python is a versatile and powerful programming language that I utilize in my projects! It allows me to create create interactive user-friendly websites using web frameworks like Flask or Django, analyze and extract valuable insights from data and develop programs to automate repetitive tasks.

Python Tools And FrameWorks I've Used

Projects Using Python

University Student Database RESTful API

Designed and implemented a system for a university’s database in Python, the system enables efficient CRUD (Create, Read, Update, Delete) operations on student, classes, and teacher data. This program also facilitates querying of individual students' class data based on their unique IDs as well as a sub menu to retrieve data for all teachers, allowing for teachers and students to have quick access to their data. HTML and Bootstrap was utilized to create a user-friendly front-end integrated with a Python Flask powered backend with MySQL for data storage and management, this simplifies back-end complexities with an easy to operate front-end interface.

Python
Flask
Django
HTML
CSS
MySQL
https://github.com/Richard-Zhao132/Python-Flask-Web-Server

Yelp Reviews Sentimetal Analysis

Developed a program that employs NLTK(Natural Language ToolKit) and Yelp reviews' star ratings to compute sentiment levels of words extracted from user reviews within a Yelp dataset. The outcomes include a collection of words accompanied by their respective sentiment ratings on a scale of 1 to 5, this is all organized and stored within a CSV file for easy accessibility and querying needs. This project demonstrates my skills in sentiment analysis and data handling.

Python
Json
NLTK
CSV Reader
Anaconda
https://github.com/Richard-Zhao132/Yelp-Reviews-Sentimental-Analysis-Program

Notables on Wiki

Created a web scraping algorithm using Python and Beautiful Soup designed to extract crucial details such as individuals' names, birth and passing years from Wikipedia webpages. The application applies this process to prominent personalities cited within the articles, and then efficiently compiles and stores the gathered data into a structured CSV file, allowing for easy access and reference. This project showcases my proficiency in leveraging technology to gather and organize information accurately.

Python
BeautifulSoup
CSV Reader
Anaconda
https://github.com/Richard-Zhao132/Python-BeautifulSoup-Project-NotablesOnWiki

PDF Splitter/Merger

Developed a Python utility using PyPDF2 for seamless merging of two PDF files or efficient splitting of a single PDF into two documents. Utilized direct file paths for a user-friendly experience, showcasing problem-solving and Python proficiency.

Python
PyPDF2
VS Code
https://github.com/Richard-Zhao132/Python-PDF-Splitter-And-PDF-Merger

Student Database GUI

Developed a graphical user interface using the Tkinter library in Python. This program allows users to make CRUD (Create, Read, Update, Delete) manipulations inside a student database. This system allows for data storage in both notepad files and CSV formats, streamlining the administration and manipulation of records with efficiency and simplicity.

Python
Tkiner
Anaconda
Notepad
https://github.com/Richard-Zhao132/Python-Student-Database-GUI

Richard Zhao 2023