Python CSV Automation Specialist
Budget: $250 – $750 USD
I need a seasoned Python programmer who can step into an in-progress data-processing pipeline and finish the execution work without altering the architecture already in place. The core logic—written in Python and heavily reliant on pandas—will be provided once we have an NDA in place.
Your tasks are straightforward but must be carried out with precision:
• Ingest several CSV files on a Linux environment, run them through our existing custom business-rule validations, and flag any exceptions exactly as the current specification dictates.
• Attach pre-generated assets (primarily images) to each validated record. The mapping logic is already written; you will ensure it runs reliably across all edge cases.
• Output a clean, well-formatted Excel workbook that mirrors our template structure, ready for immediate internal use.
To succeed you should be fully comfortable with pandas, pathlib, and openpyxl (or a comparable Excel writer), know your way around Unix shell basics, and be disciplined about following an established process line-by-line.
Deliverables:
• Updated Python script(s) ready to run from the command line
• One sample processed Excel file demonstrating correct validation and asset attachment
• A concise README with setup and execution steps
No need to redesign, re-architect, or experiment—just execute the plan, hit the milestones, and keep the code clean and well-commented. An NDA signature will be required before any repository access is granted.
Your tasks are straightforward but must be carried out with precision:
• Ingest several CSV files on a Linux environment, run them through our existing custom business-rule validations, and flag any exceptions exactly as the current specification dictates.
• Attach pre-generated assets (primarily images) to each validated record. The mapping logic is already written; you will ensure it runs reliably across all edge cases.
• Output a clean, well-formatted Excel workbook that mirrors our template structure, ready for immediate internal use.
To succeed you should be fully comfortable with pandas, pathlib, and openpyxl (or a comparable Excel writer), know your way around Unix shell basics, and be disciplined about following an established process line-by-line.
Deliverables:
• Updated Python script(s) ready to run from the command line
• One sample processed Excel file demonstrating correct validation and asset attachment
• A concise README with setup and execution steps
No need to redesign, re-architect, or experiment—just execute the plan, hit the milestones, and keep the code clean and well-commented. An NDA signature will be required before any repository access is granted.
Related categories:
Python
Linux
Data Processing
Software Architecture
Software Development
Scripting
Documentation
Data Analysis