RPA

AI Bots - AI bots and robotic process automation using Python and Julia language scripts to automate routine tasks that are performed on a daily basis.

Video Tutorials - ChatGPT RPA Automation

Video Tutorials - Llama 2 use cases

This is a work in progress repository and updated frequently, please follow me at Twitter, Subscribe to YouTube channel to see latest updates.. Please give a star * to this repository.

Author: Amit Shukla

Connect

Welcome to my latest RPA series notebooks. In this series, we will write snippets of Python code used in Automation tasks and later, will put it all altogether to deliver an RPA project.

RPA with help of Open AI ChatGPT, Llama2

I'm Amit Shukla, and I have been working on automating RPA tasks for over a decade now. Since the recent launch of ChatGPT, I am exploring ways to use its coding skills to automate small daily routines.

In this RPA series, we will use ChatGPT/Llama's code writing skills to build a trading bot from scratch. I do not view ChatGPT or Llama as a threat to my job, at least not yet. Instead, I believe it can assist me in writing smarter solutions to solve more significant problems.

The emphasis of this tutorial series is not centered on exclusively using LLM (large language models) or discussing the advantages and disadvantages of AI coding. Rather, our main focus lies in RPA tasks and utilizing LLMs's assistance where suitable.

In this GitHub repository, you will find code snippets that are suitable for novice programmers to automate minor tasks, with every single line of source code provided.

Table of Contents

working with os and files

• Splitting big file and combining it back
• Splitting CSV file by rows and combining it back
• File Encrypt and Decrypt
• Data Masking and Unmasking
• Search and replace over a large number of text files
• Rename and rearrange files using os and shutil module

web scrapping

• Screenshot of a web page
• Read text from Images
• Scrape text from web page
• Scrape emails, phone number, URL from given text
• Download a file from a URL
• Download all files from a web page
• Scrape and download CSV PDF image files from web page
• Keep moving mouse to avoid os sleep mode
• Boost Your YouTube Views Legitimately

miscellaneous

• Generate and Read QR Code
• Generate Image Watermark
• Tic Tac Toe
• Mass calculation
• Basic Scientific calculator
• Count down timer
• Timer
• World clock
• Alarm clock
• Boxing match timer for 10 rounds 3 mins each with 2 min break
• Jump rope counter
• EMOM Timer
• TABADA Timer
• Reading a cookie file
• Create fake test data using ChatGPT
• Tree Flattening

conversions

• Convert Images to PDF
• Convert PDF to CSV
• Convert CSV to DSV
• Convert Text to CSV
• Convert Images to Text
• Compress and Decompress CSV file
• Compress and Decompress Image file
• Compress and Decompress Audio file
• Compress and Decompress Video file

CRON jobs

• Creating a CRON job in Linux
• Creating a CRON job in windows
• Watching file drop to trigger script
• Memory use on windows MAC OS or Linux

HTTP

• Jupyter notebook access from local network
• run vscode from browser
• Python HTTP server
• Node JS HTTP server
• Node JS CORS
• Node JS HTTP API
• Node JS sql injection prevention
• JWT code Authentication token
• Validate JWT token
• Firebase hosting code

working with APIs

• News API
• Grammar Correction API
• Fetch Recipe API
• Fetch Movies API
• NASA API
• YT Video Download
• InstaDpViewer
• Tiny URL - Making URLs short
• Open AI API
• DropBox API
• Harry Potter API
• Email Sending API
• Open AI ChatGPT, BARD, Llama2

Llama Use cases

• Llama 2 Installation Windows/Linux
• Efficient Time and Expense Monitoring with Llama 2
• Using Llama 2 as OCR Vision AI
• Llama 2 as Supply Chain Assistant

working with Polars

• The Ultimate Guide to Data Wrangling with Python | Rust Polars Data Frame
• PDF version - The Ultimate Guide to Data Wrangling with Python | Rust Polars Data Frame

Python - know how

• Python - data types, structure, assignments, operators and control flow
• Python - understanding functions
• Python - shallow and deep copy
• Python - getters and setters
• Python - pass by assignments
• Python - decorators
• Python - create synthetic data using DSPy Synthesizer
• Python - double dunders, magic functions
• Python Regular Expression
• Python, everything you need to about dates
• Python Scripts, Module, Packages and Virtual Environment
• Python - OOPs | Duck Typing

Machine Learning

• build a recommendation engine to suggest a recipe and ingredients
• predicting ETA by traffic

Deep Learning

• predicting ETA by traffic

WIP

** all notebooks below this section is work in progress.

Building ETL Datawarehouse and ELT Data Lake using Polars DataFrame

• World's Fastest ETL Datawarehouse & ELT Data Lake using Polars DataFrame

• Architecture
• Extract
• Load
• Transformation
• ETL Datawarehouse
• ETL Data lake

working with Pandas Dataframe

• EDA for Pro Analysts
• PDF version - EDA for Pro Analysts

SQL

• writing SQL, tuning SQL, SQL Explain plan, SQL Stored Procedure
• convert Oracle PL SQL to HIVE SQL
• Explain SQL
• what is wrong in this SQL
• Create SQL table from text
• updating database from a table with 1 million rows

Latex, SVG and Regex - how to

• [Write latex]
• [Write SVG icons]
• [Write regex code]

Live RPA (Robotic Process Automation) Projects --work in progress

• Monitoring live web content
• RPA to build Open Reconciliation system
• RPA to build a Trading BOT
• RPA to build Auto Replenishment Inventory Order system
• Document scanner - Match Exception Digital Invoice generator
• Python network scanner
• Stock prices Exploratory data analysis
• Python Time Series Forecasting
• Mermaid.js with ChatGPT
• Python Graphs

• duplicate score using ChatGPT Classifier
• duplicate score using ChatGPT Stylometric analysis
• duplicate score using ChatGPT Sentimental analysis
• finding cheater using ChatGPT
• Text to Speech
• Plagiarism Checker

Hacker Series --work in progress

• read Text, QR code in images stored in an external drive, query those urls through curl and send response to Firebase HTTP
• read key board sound
• download all emails, quotes, products, phone number, QR Codes, Finance Transactions, URLs from pics
• where have you been
• reading your emails | sending automated email based on dynamic content
• reading your insta
• reading your meta
• reading your tweets
• reading your cookies
• reading your favorites
• browsing history
• docubot
• chill pill
• Fetch Movies
• Reading eMail in transit hack
• Twitter, FB, LinkedIn auto publish bot

License Agreement

License Information

Privacy Policy

Privacy Policy