Automation Bot for Data Extraction and Processing
Authors:-Assistant Professor Ms. Shristy Goswami, Aditya Singh, Anant Shukla, Anurag, Divanshu
Abstract-This paper presents the development and implementation of an automation bot designed for efficient data extraction and processing tasks. The bot automates the process of accessing a website, downloading an input Excel file, and extracting account numbers from the file. It then compares the last four digits of each account number with the digits in the names of zip files available on the website. Upon finding a match, the bot downloads the corresponding zip file, extracts its contents, and processes the required data from the unzipped text file, subsequently loading this data into the specific account number’s field. This automation bot significantly enhances data handling efficiency, reduces manual errors, and streamlines the data management process.
