maxinexiong Goto Github PK

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.

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.

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.

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.

automatetableofcontentsinexcel

The VBA program automatically generates table of contents for Excel workbooks. By eliminating manual effort, it saves time and ensures a comprehensive table with clickable sheet links. The repository provides the necessary code, a sample workbook, and clear instructions for easy integration and usage, enhancing productivity for Excel users.

booksearchengine

A powerful book search engine built in SQLite and Python with Tkinter was made for book query purpose. Users can look up information about a book such as ISBN, rating, title and author with ease. In the meanwhile, it also allows users to administer the database by adding, deleting and updating any record. The code has been converted to a standalone final product, which is the donwloadable exe application.

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

chatgpt-3.5-desktop-app

This app is an unofficial desktop application that enables natural language conversations with OpenAI's ChatGPT directly from your local computer. With its user-friendly interface and message audio playback, this app aims to provides an enjoyable and immersive experience akin to talking to a real person.

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.

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.

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.

dictapp

A user-friendly interactive English dictionary built with Python that suggests maximum 5 closest matches to a word query. Users can access the app by simply downloading and opening the .exe file.

geocodingwebservice

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.

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.

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.

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.

input-forms-rpa-challenge-modern

About This repository contains a RPA workflow developed with UiPath Modern Design that's capable of transferring data from a spreadsheet onto dynamic form fields on the screen. This RPA solution successfully passed the automation challenge (www.theautomationchallenge.com), achieving an impeccable 100% accuracy in a mere 262.282 seconds

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.

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.

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.

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.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.

my-leetcode-sql-exercises

My solutions to LeetCode SQL questions.

mypythoncodeexercises

My documentation of Python code exercises.

openai-api-web-apps

This repository hosts a collection of custom web applications powered by OpenAI's Whisper model and gpt-3.5-turbo model. These apps include an interactive chatbot ("Talk to GPT-3.5") for text or voice communication, and a coding assistant ("CodeMaxGPT") that supports various coding tasks.

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.

roulette-bot-rpa

An automation solution that employs the Martingale roulette strategy in online roulette gameplay.

salesregionalreportingtool

The Sales Regional Reporting Tool is an Excel template with VBA program that automates monthly reporting for Sales Controllers. It consolidates data, generates interactive regional reports, creates a regional overview report for top management, and exports data as a CSV file for the ERP system.