You have chosen to sponsor your bid up to a maximum amount of .
We require some code to be written that will convert raw data contained with the attached CHR/CSV file into a standard report format in excel. Reporting is required weekly from raw data extracted. .
The report that we need to develop is Call Statistics Reporting for the calls made by a call centre.
The attached CHR/CSV file shows raw data that is directly exported from our phone system. Essentially we need to report on a few key statistics for each person making calls.
A person is identified in the phone system by an 'extension'. In the example CSV file, there are two extensions - 8511 (cell Q1) and 8514 (Cell Q16). The key columns of data that we need are Q (date), R (time of call). Y (duration).
The format I require the data to be transformed into is shown in the attachment - REPORT FORMAT. This is an example of the old report we used to use. There was an excel macro that would pull in the data to row 51 and 329.
I am making an assumption that Python is going to be the option to do, however, based on your expertise, their may be some other way around it.
Please let me know if more information is required.