PERSONAL PROJECTS
Project 1: University Funds Tracker
A program for tracking university income and expenses.
Code Display
This Python program uses Pandas to manage expenses across three categories (Germany1, Germany2, New Zealand) by loading and saving data from Excel.
It allows users to add and remove entries, convert currencies (NZD to SGD), calculate totals, and track the total money lost and remaining.
User Interaction Interface
The output is generated through user interactions, enabling seamless addition, review, and removal of expenses.
Totals are calculated, the remaining balance is displayed, and data is saved to an Excel file, with the final DataFrame shown for a clear summary.
Project 2: Excel-to-Word Data Merging
Automates Word document creation using data from Excel files.
Code Display
The code analyzes Excel data to replace placeholders in a Word document with corresponding values, generating personalized content.
Each new file is exported and saved with the individual’s name, ensuring standardized date formatting for consistency.
User Interaction Interface
This Python project automates filling placeholders in a Word document with data from an Excel sheet, allowing users to input information like First Name, Last Name, and Event Time.
It generates personalized letters or reports, reducing repetitive work and streamlining document creation based on varying data inputs.
Project 3: Automated Report Generator
Automatically generates customizable report or essay templates for school and work
Code Display
The code generates a Word document, applying Times New Roman, size 14, and adjusting colors. It organizes content into sections with customizable headers based on user input.
It creates a title page, allows adding multiple sections, and ensures the document is indented and justified before saving it in `.docx` format.
User Interaction Interface
The program prompts the user for the report title, author, and date, then asks for main, sub, and smaller section headers with customizable sizes (big, medium, small).
Users can generate the table of contents and add automatic page numbers themselves, resulting in a clean, professional Word document layout.
Project 4: Shopping List Manager
Manages and organizes a shopping list efficiently using Excel.
Code Display
The code organizes segments into functions for managing a shopping list, allowing users to open and clean shopping data and exit the program when desired.
It handles actions like adding, amending, or deleting items and saves the updated list to a new Excel sheet, preserving all modifications.
User Interaction Interface
This Python code manages a personal purchase record using the Pandas library, enabling users to load, modify, and save data in an Excel file.
Users can add or delete rows and columns, amend entries, and display data, with changes saved back to the file or a new one created if it doesn’t exist.
Contact me
If you have any questions or need more information, please feel free to reach out! I’m here to help and look forward to hearing from you soon!