Automating Excel Variables Estimation with Python
Budget: $120 – $180 NZD
We're searching for an experienced python coder who could use their expertise in automating estimates of different numerical, text and date variables in numerous cells across a single Excel file. Our expectation is for the numerical variables to be calculated based on average and sum, as well as dummy variables.
The output of these estimates should then be automatically generated in another Excel file, presented in a clear column-by-column summary layout.
Key Skills and Experience:
- Highly adept with Python language, particularly in working with Excel-based datasets.
- Demonstrated experience utilizing averages, sums, and dummy variables.
- Ability to automate processes and generate organized, easily digestible output.
- Strong attention to detail and a solid understanding of data variables.
The output of these estimates should then be automatically generated in another Excel file, presented in a clear column-by-column summary layout.
Key Skills and Experience:
- Highly adept with Python language, particularly in working with Excel-based datasets.
- Demonstrated experience utilizing averages, sums, and dummy variables.
- Ability to automate processes and generate organized, easily digestible output.
- Strong attention to detail and a solid understanding of data variables.