Advanced Data Processing Macro Development

Job ID: 37808928

Budget: $30 – $250 USD

I need an expert well-versed in Python or Access macro to create a solution for processing data from a .csv file and exporting the results to multiple .csv files. It will be employed on a Windows operating system - no specific Python version was mentioned, so either current stable releases of Python 2 or 3 should work.

The responsibilities and requirements are detailed as follows:

- Data aggregation: Your solution should be capable of aggregating the data where necessary.
- Perform Calculations: The platform should calculate averages and sums as part of the data processing task.
- Category-wise CSV Export: Export the resulting data into .csv files, with one file per category of data.

The ideal freelancer for this project should have the following skills:

- An excellent understanding of Python or Macro Access programming.
- Proven experience working with data extraction, transformation and loading (ETL).
- Familiarity with data aggregation and analytical operations.
- A good understanding of CSV files and how to manipulate them in Python or Access.
- Past work with data-based projects is a bonus.

The effectiveness of your solution in addressing these tasks will be a key determinant of its success. Looking forward to working with you!