Help finalising some python code
Budget: $30 – $250 AUD
I'm looking for someone to iron out some issues with some python code.
1. I am manipulating some data on a Google sheet. Each day additional lines of data are added to the tab 'data'
2. I have created 3 scripts to manipulate the data and create consolidated information.
3. I have a 4th script that causes them to run in sequence
Issues:
1. The 4th script fails to run the 3 scripts successfully
2. The script called generate_agent_summary.py successfully captures "Phone Performance Ratio (%) - Most Recent Date" which you will see if the ratio of calls answered yesterday by the 'Agent'. I'd like a column to capture "Phone Performance Ratio (%) - Last 7 days" which shows how each Agent who was answering phones performed over the last 7 days
I've attached the scripts and the Google Sheet is at https://docs.google.com/spreadsheets/d/1kkMpEhVWZNSf7p34PEdP8JQqm_ficzNfqFnbN6H_3v8/edit?usp=sharing
If you need it, I can provide the JSON file to access the sheet.
1. I am manipulating some data on a Google sheet. Each day additional lines of data are added to the tab 'data'
2. I have created 3 scripts to manipulate the data and create consolidated information.
3. I have a 4th script that causes them to run in sequence
Issues:
1. The 4th script fails to run the 3 scripts successfully
2. The script called generate_agent_summary.py successfully captures "Phone Performance Ratio (%) - Most Recent Date" which you will see if the ratio of calls answered yesterday by the 'Agent'. I'd like a column to capture "Phone Performance Ratio (%) - Last 7 days" which shows how each Agent who was answering phones performed over the last 7 days
I've attached the scripts and the Google Sheet is at https://docs.google.com/spreadsheets/d/1kkMpEhVWZNSf7p34PEdP8JQqm_ficzNfqFnbN6H_3v8/edit?usp=sharing
If you need it, I can provide the JSON file to access the sheet.