Clean the data by delete certain rows, add 2 additional columns, push data by creating additional columns and save data based on column headers.
Budget: ₹1,500 – ₹12,500 INR
We have 50 stocks data in separate folders, this is juts sample for you to make python code. But in reality there will be 2500 stocks.
I am looking for expert python coder who can code to perform these tasks.
TASK 1 = DELETE FEW ROWS FROM SIMILAR MULTIPLE EXCEL FILES LOCATED IN MULTIPLE FOLDERS, FOR YOUR UNDERSTANDING I HAVE COLOR CODE ONE OF THE FOLDER FILES, SO YOU KNOW WHICH ROWS TO BE DELETED FROM WHICH FILES.
TASK 2 = CREATE 2 ADDITIONAL COLUMNS FOR SECTOR AND INDUSTRY, FOR THIS YOU CAN USE SECTOR EXCEL FILE.
TASK 3 = PREPARE MASTER TEMPLATE BASED ON MAXIMUM COLUMNS FROM QUARTERLY RESULTS STANDALONE OR QUARTERLY RESULTS CONSOLIDATED FILES AND MIRROR THE COLUMNS SO THAT THE LATEST DATA IS SHOWN IN LAST COLUMN.
TASK 4 = RE-ARRANGE DATA BY COPYING DATA TO MASTER TEMPLATE BASED ON COLUMN HEADER AND SAVE THEM TO PROCESSED FOLDER.
If you need further clarification please message me.
I am looking for expert python coder who can code to perform these tasks.
TASK 1 = DELETE FEW ROWS FROM SIMILAR MULTIPLE EXCEL FILES LOCATED IN MULTIPLE FOLDERS, FOR YOUR UNDERSTANDING I HAVE COLOR CODE ONE OF THE FOLDER FILES, SO YOU KNOW WHICH ROWS TO BE DELETED FROM WHICH FILES.
TASK 2 = CREATE 2 ADDITIONAL COLUMNS FOR SECTOR AND INDUSTRY, FOR THIS YOU CAN USE SECTOR EXCEL FILE.
TASK 3 = PREPARE MASTER TEMPLATE BASED ON MAXIMUM COLUMNS FROM QUARTERLY RESULTS STANDALONE OR QUARTERLY RESULTS CONSOLIDATED FILES AND MIRROR THE COLUMNS SO THAT THE LATEST DATA IS SHOWN IN LAST COLUMN.
TASK 4 = RE-ARRANGE DATA BY COPYING DATA TO MASTER TEMPLATE BASED ON COLUMN HEADER AND SAVE THEM TO PROCESSED FOLDER.
If you need further clarification please message me.