Merge Data using Python
Budget: $10 – $30 USD
This project is about merging data from 3 excel spreadsheets. The common identifier across all 3 spreadsheets is the account number.
The customer sheet has information about many customers
Each customer belongs to 1 of 4 Business Units (L1, L2, L3, L4)
Some customers may belong to 2 L1 business units; example: Marketing and Sales.
Each customer can have 1 or more cases. (1 to many relationship)
Each case could be of 1 severity (from a list of 5 severities)
Each customer has an associated revenue (1 to 1 relationship).
So, when I am presented with a customer sheet, a revenue sheet and a case sheet, I need to have a way to automate a merge where the new sheet contains all contact information, associated case categories (low, medium, high, urgent, critical) and the sum of all cases.
The new sheet should also contain revenue information for each account
So, attached please find a graphic representation of this.
This project is to use Python to query and merge the 3 CSV files and create a new one.
Please ask any questions before bidding.
Thank you.
CL
The customer sheet has information about many customers
Each customer belongs to 1 of 4 Business Units (L1, L2, L3, L4)
Some customers may belong to 2 L1 business units; example: Marketing and Sales.
Each customer can have 1 or more cases. (1 to many relationship)
Each case could be of 1 severity (from a list of 5 severities)
Each customer has an associated revenue (1 to 1 relationship).
So, when I am presented with a customer sheet, a revenue sheet and a case sheet, I need to have a way to automate a merge where the new sheet contains all contact information, associated case categories (low, medium, high, urgent, critical) and the sum of all cases.
The new sheet should also contain revenue information for each account
So, attached please find a graphic representation of this.
This project is to use Python to query and merge the 3 CSV files and create a new one.
Please ask any questions before bidding.
Thank you.
CL