MaxineXiong
Data Analytics | Data Visualization | Business Analytics | Python Programming | Robotic Process Automation (RPA) | Machine Learning | Data Engineering
Sydney
Pinned Repositories
AI-Plays-Flappy-Bird
The project showcases the implementation of the NEAT algorithm in Python to play a Flappy Bird-like game. It orchestrates the evolution and evaluation of a bird population through successive generations until the fitness threshold is met. The ultimate winner genome, demonstrating exceptional gameplay, is saved as a pickle file as the main output.
ChatGPT-Tkinter-Desktop-App
An unofficial tkinter desktop application that enables natural language conversations with OpenAI's ChatGPT directly from your local computer using GPT-3.5 Turbo, GPT-4o mini, GPT-4o, or GPT-4 Turbo model. With its user-friendly interface and message audio playback, this app aims to provides an enjoyable experience akin to talking to a real person.
Google-Maps-Style-Route-Planner
This algorithmic project enables users to find the shortest path between two locations on a map. It leverages graph theory and A* search algorithm, providing a user-friendly solution similar to Google Maps. With comprehensive documentation and testing capabilities, it offers a reliable route planning solution.
ImageAI-Flask-Apps
This project offers two Flask applications that utilize ImageAI's image prediction algorithms and object detection models. These apps enable users to upload images and videos for object recognition, detection and analysis, providing accurate prediction results, confidence scores, raw data of detected objects at frame-level, and object insights.
Input-Forms-RPA-Challenge-Classic
This repository contains a RPA workflow developed with UiPath Classic Design that's capable of transferring data from a spreadsheet onto dynamic form fields on the screen. This RPA solution successfully passed the Input Forms challenge (https://www.rpachallenge.com/), achieving an impeccable 100% accuracy in a mere 16,173 milliseconds.
InvoiceGenerator
The Invoice Generator is a highly customizable, Excel-based tool with VBA programs that automates the process of invoicing, streamlining invoice management and generation, and enhancing efficiency. It offers easy customer data management, one-click invoice creation, email integration, and informative dashboard charts for revenue monitoring.
Item-based-collaborative-filtering
This project utilizes PySpark DataFrames and PySpark RDD to implement item-based collaborative filtering. By calculating cosine similarity scores or identifying movies with the highest number of shared viewers, the system recommends 10 similar movies for a given target movie that aligns users’ preferences.
OpenAI-API-Web-Apps
This repository hosts a collection of custom web applications powered by OpenAI's GPT models (incl. gpt-4-turbo, gpt-4o, gpt-4o-mini and gpt-3.5-turbo), Whisper model, and TTS model. These apps include an interactive chatbot ("Talk to GPT") for text or voice communication, and a coding assistant ("CodeMaxGPT") that supports various coding tasks.
Scraping-PDF-Invoices-with-RPA
This repository houses an UiPath RPA solution that effortlessly scrape data from 1000 invoices issued to different customers, store the data in the invoices_data.xlsx Excel file, and categorizes invoices into separate folders. Remarkably, this RPA robot completes the process in just around 130 minutes, achieving nearly 100% accuracy.
TSA_Claims_Data_Analysis
This repository contains a SAS program that analyses claims data obtained from the Transportation Security Administration (TSA). The program addresses data and report requirements for the case study, providing insights into injuries, property loss, and damage during the airport screening process.
MaxineXiong's Repositories
MaxineXiong/OpenAI-API-Web-Apps
This repository hosts a collection of custom web applications powered by OpenAI's GPT models (incl. gpt-4-turbo, gpt-4o, gpt-4o-mini and gpt-3.5-turbo), Whisper model, and TTS model. These apps include an interactive chatbot ("Talk to GPT") for text or voice communication, and a coding assistant ("CodeMaxGPT") that supports various coding tasks.
MaxineXiong/ImageAI-Flask-Apps
This project offers two Flask applications that utilize ImageAI's image prediction algorithms and object detection models. These apps enable users to upload images and videos for object recognition, detection and analysis, providing accurate prediction results, confidence scores, raw data of detected objects at frame-level, and object insights.
MaxineXiong/ChatGPT-Tkinter-Desktop-App
An unofficial tkinter desktop application that enables natural language conversations with OpenAI's ChatGPT directly from your local computer using GPT-3.5 Turbo, GPT-4o mini, GPT-4o, or GPT-4 Turbo model. With its user-friendly interface and message audio playback, this app aims to provides an enjoyable experience akin to talking to a real person.
MaxineXiong/AI-Plays-Flappy-Bird
The project showcases the implementation of the NEAT algorithm in Python to play a Flappy Bird-like game. It orchestrates the evolution and evaluation of a bird population through successive generations until the fitness threshold is met. The ultimate winner genome, demonstrating exceptional gameplay, is saved as a pickle file as the main output.
MaxineXiong/Scraping-PDF-Invoices-with-RPA
This repository houses an UiPath RPA solution that effortlessly scrape data from 1000 invoices issued to different customers, store the data in the invoices_data.xlsx Excel file, and categorizes invoices into separate folders. Remarkably, this RPA robot completes the process in just around 130 minutes, achieving nearly 100% accuracy.
MaxineXiong/Google-Maps-Style-Route-Planner
This algorithmic project enables users to find the shortest path between two locations on a map. It leverages graph theory and A* search algorithm, providing a user-friendly solution similar to Google Maps. With comprehensive documentation and testing capabilities, it offers a reliable route planning solution.
MaxineXiong/Input-Forms-RPA-Challenge-Classic
This repository contains a RPA workflow developed with UiPath Classic Design that's capable of transferring data from a spreadsheet onto dynamic form fields on the screen. This RPA solution successfully passed the Input Forms challenge (https://www.rpachallenge.com/), achieving an impeccable 100% accuracy in a mere 16,173 milliseconds.
MaxineXiong/Item-based-collaborative-filtering
This project utilizes PySpark DataFrames and PySpark RDD to implement item-based collaborative filtering. By calculating cosine similarity scores or identifying movies with the highest number of shared viewers, the system recommends 10 similar movies for a given target movie that aligns users’ preferences.
MaxineXiong/Roulette-Bot-RPA
An automation solution that employs the Martingale roulette strategy in online roulette gameplay.
MaxineXiong/Degrees-of-Separation-with-Breadth-first-Search
This project utilizes PySpark RDD and the Breadth-first Search (BFS) algorithm to find the shortest path and degrees of separation between two given Marvel superheroes based on based on their appearances together in the same comic books, empowering users to discover connections between their favourite superheroes in the Marvel universe.
MaxineXiong/Gmail-Automation-RPA
This repository hosts a robust automation solution that orchestrates various email operations, including Email Reading, Email Saving, Email Attachments Downloading, Email Forwarding, and Email Deletion. Additionally, it generates and sends an automated email summary report to designated recipient(s) that informs mailing activities.
MaxineXiong/Image-Background-Remover-Bot-RPA
An automation solution that iterates through photos in a folder, removes the background using an online AI tool, and saves the edited photos in a separate folder.
MaxineXiong/Invoice-Extraction-OCR-Challenge-RPA
This repository houses a UiPath automation solution tailored for Invoice Extraction in RPA workflows. Tasked with reading each table row and extracting invoice details from each invoice photo through OCR, the solution outputs a CSV file with the extracted data alongside the table's ID and Due Date, specifically for two invoice suppliers.
MaxineXiong/maxinexiong.github.io
This repository contains the source code and assets for my personal portfolio website, "Maxine's Tech Gallery". It serves as a comprehensive platform showcasing my technical skills, certifications, projects, blog posts, and professional resume. The website offers a user-friendly interface, search functionality, and switch between themes.
MaxineXiong/Outlook-Email-Automation-RPA
The UiPath RPA robot automatically fetches and saves the 10 most recent unread email messages with attachments from Desktop Outlook to your local machine, and sends automation reports to specified recipients, ensuring efficient email management through UiPath.
MaxineXiong/Scraping-Scanned-PDF-Docs-using-OCR-with-RPA
This repository contains automation solutions that efficiently extracts text from scanned PDF documents with consistent layouts. Utilizing Tesseract OCR engine, the UiPath RPA robot achieves nearly 90% accuracy, streamlining the process and significantly reducing manual workload.
MaxineXiong/Calendar-Picker-Bot-RPA
An automation solution that searches for a location on Booking.com and selects the start and end dates using the calendar picker
MaxineXiong/Coronavirus-Stat-Alert-Bot-RPA
An automation solution designed to meet the challenge of creating a Coronavirus stat-alert bot. This bot is capable of scraping Coronavirus statistics from a user-inputted country and sending an email update with the collected data to specified recipients.
MaxineXiong/Geocoding-Web-Service
This repository houses a geocoding web application built in Python with Flask that transforms address data within a file into precise latitude and longitude coordinates. Upon uploading a file, users can preview the output table on the website, download the converted file, and visualise the exact location of each address on a map.
MaxineXiong/IP-Address-to-Location-Converter-Bot-RPA
An automation solution designed to tackle the challenge of creating a bot that converts IP addresses in an Excel spreadsheet into their corresponding physical locations, including Country, Region, and City.
MaxineXiong/MyPythonCodeExercises
My documentation of Python code exercises.
MaxineXiong/WebCam-Monitoring-App-with-Email-Alerts
An application that is built to continuously monitor designated areas and alert users via email when any object enters and remains in the area beyond a specified duration. This application is ideal for settings that require vigilant security measures.
MaxineXiong/ACME-Dispatcher-Performer-Invoice-Check-Bot-RPA
This repository hosts a UiPath automation solution with separate Dispatcher and Performer sub-processes. The Dispatcher bot adds queue items to Orchestrator Queue, while the Performer bot searches invoices, extracts and compares data. Leveraging UiPath REFramework, this workflow provides a robust scalable solution for invoice checking tasks.
MaxineXiong/ACME-Vendor-Check-Bot-RPA
This repository contains a robust UiPath automation solution utilising the REFramework, crafted to fulfill the specified requirements, including extracting data table from acme-test.com, comparing vendor information, handling various business exceptions, and appending the results into an Excel worksheet.
MaxineXiong/ACME-Work-Items-RPA
This repository contains a robust UiPath automation solution that utilises the UiPath REFramework to fulfill the specified requirements, which includes automating data scraping from acme-test.com, filtering specific records, and appending the results into an Excel worksheet.
MaxineXiong/Book-Search-Engine
The Book Search Engine is a desktop application developed in Python using the Tkinter and CustomTkinter library. It enables users to interact with a local SQLite database to manage and query book information effectively, allowing users to look up book information with ease, and add, update, delete book records in the database.
MaxineXiong/Cloud-Data-Warehousing-with-AWS-Redshift
This project builds a cloud-based ETL pipeline for Sparkify to move data to a cloud data warehouse. It extracts song and user activity data from AWS S3, stages it in Redshift, and transforms it into a star-schema data model with fact and dimension tables, enabling efficient querying to answer business questions.
MaxineXiong/Data-Migration-Into-CRM-Apps-RPA
This repository contains RPA solutions that are designed to automate repetitive and time-consuming data entry tasks to streamline customer data entry into both CRM web and desktop applications simultaneously. The robot operates in parallel, ensuring quick and accurate data entry without the need for manual intervention.
MaxineXiong/Data-Modelling-with-Apache-Cassandra
This project implemented Apache Cassandra data modelling to support Sparkify's analysis of user activity and song play data. It involved consolidating partitioned files into a single CSV, designing and creating tables based on specific queries from Sparkify’s analytics team, and inserting the data from the CSV into the tables using CQL commands.
MaxineXiong/Music-Events-Web-Scraper
A web scraping program built to extract attribute data on music events from a popular event ticketing website. The program collects event data based on the specified country and city, which is then exported to a CSV file for marketing emails and stored efficiently in a local PostgreSQL database.