
Closed
Posted
I need a clean, well-documented Python script that can pick up CSV files from a watched folder, process them according to my business rules, and then push the results to a designated output location. The workflow breaks down into three core parts. 1. File I/O handling • Automatically read incoming CSV files. • After processing, write the transformed data to a separate folder. • Rename each source file to a timestamped archive name and move it to an “_archive” sub-directory so nothing is re-processed by mistake. 2. Data processing & algorithmic checks The CSVs include a fixed header row followed by transactional records. For every row the script must: • Run field-level validation (type, range, mandatory columns). • Apply record-level business rules that I will supply as a Python dictionary of lambdas. • Flag or correct detectable data errors—e.g. wrong date formats or out-of-range numeric values—while logging any changes so I have an audit trail. 3. Reporting • Create a concise log (plain text or JSON) listing files handled, rows processed, rows corrected, and any unrecoverable errors. • Exit with a non-zero status if unrecoverable errors are found so my scheduler can react. Deliverables • A single runnable .py file (Python 3.10+), built on standard libraries plus pandas if you find it useful. • A README that explains setup, config variables (input/output paths, rule dictionary), and example command-line usage. • Sample unit tests (pytest preferred) covering at least the validation and renaming routines. Acceptance criteria ✔ Processes a test batch of CSVs without manual intervention. ✔ Produces the expected transformed output and audit log. ✔ Renames and moves originals exactly once per run. ✔ Returns correct exit codes for success vs unrecoverable error cases. If you have questions about the rule dictionary format or edge cases, let me know early so we can lock requirements before you code.
Project ID: 40685743
52 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
52 freelancers are bidding on average ₹593 INR/hour for this job

I have 8+ years of experience in web development and am familiar with modern web technologies, frameworks like Python, pandas, pytest and other tools. This job is about a Python script that watches a folder for CSV files. I will build the script to read each file, check the rows using your business rules, fix small errors, and log every change. It will move processed files to an archive folder and write a clean report. I will also add unit tests and a simple README. I can start right away.
₹700 INR in 25 days
7.7
7.7

Hi there! Building a robust, production-ready Python 3.10+ script using Pandas and standard libraries to automatically poll a watched folder, process CSV transactional records using lambda-based business rules, handle data corrections with an audit trail, move archived files with timestamps, and generate JSON logs with correct exit codes is right in my wheelhouse. I regularly build advanced file automation pipelines, data processing scripts, and custom verification tools, so feel free to check my profile portfolio. Before we get started, could you share a small sample CSV file and your preferred rule dictionary structure so I can tailor the validation checks? Once you share the details, I can map out everything cleanly and deliver the runnable script, requirements file, and pytest suite step-by-step. Looking forward to working together! Best regards, Ahmad Hassan
₹444 INR in 40 days
6.6
6.6

Hi, I can build this Python CSV automation with folder processing, configurable validation/business rules, error correction, audit logging, timestamped archiving, and proper exit codes. I’m experienced with Python automation, pandas, data processing, file workflows, and testing, and will keep the script modular and easy to maintain. I’ll include pytest coverage and a clear README with configuration and CLI examples. Thanks Anshuman
₹750 INR in 25 days
6.4
6.4

Hi, Glane here. I can build this Python automation for you and keep it clean and straightforward to use. I’ll set up the CSV workflow so files are picked up automatically, validated and processed according to your business rules, saved to the output folder, and then safely moved to a timestamped archive so they don’t get processed again. I’ll also include proper error handling and an audit log showing what was processed, corrected, or couldn’t be fixed, along with the correct exit codes for your scheduler. You’ll get the runnable Python script, a simple README explaining the setup and rule dictionary, and pytest tests covering the key functions like validation and file archiving. I’m happy to clarify the rule format and edge cases with you upfront so we can get everything working smoothly within the requirements.
₹750 INR in 40 days
6.2
6.2

Hello, I am a Full Stack Developer with 15 years of working experience and I can build a CSV processing script on Python as per your requirements that you have mentioned in the project description and complete the work quickly and with best quality. Looking forward to hear from you.
₹500 INR in 40 days
4.9
4.9

As an experienced full-stack developer with a specific expertise in automation and data processing, I believe I am the perfect fit for your project. My 14+ years in the industry have given me an intricate understanding of how to effectively process, validate and transform data with Python in a variety of projects for different industries - such as yours. You can trust me to deliver a clean, well-documented and efficient script that fits your unique business rules and streamlines your CSV automation process within a competitive timeframe. One distinct advantage I bring to the table for this project is my knowledge of PHP alongside my expertise in Python. In instances where we may want to leverage any existing PHP codebase or integrate new features slanted towards PHP, my capabilities in both languages will prove invaluable. Moreover, my track record of delivering successful projects like yours (over 416 in number) underscores my competence and dedication to producing high-quality results on time. With a comprehensive testing approach and thorough documentation, I ensure not just smooth implementation but also effective maintenance after completion. In a nutshell, choosing me for this project guarantees a solid solution delivered on time and tailored specifically to meet your needs.
₹750 INR in 40 days
5.0
5.0

I can build the CSV pipeline with validation, your trusted rule dictionary, audit logs and scheduler-friendly exit codes. I would avoid reading half-written files, write output atomically, and archive only after successful processing, with a restart-safe record to prevent accidental repeats. Rate: ₹750/hour; estimate 10–15 hours over 4 days once the sample files and rules are available. The .py file, README and pytest cases will cover invalid rows, duplicate runs and archive-name collisions. Should a file with any invalid row be rejected as a whole, or should valid rows be exported while errors are reported separately?
₹750 INR in 15 days
4.9
4.9

Hi, I can build the Python 3.10+ CSV automation script to watch/process incoming files, apply validation rules, archive originals, generate logs and return proper exit codes. My approach will be to first confirm the folder structure, fixed headers, validation rules, lambda dictionary format and expected output format. Then I’ll create a clean, configurable script with audit logging and tests. I can help with: * CSV file pickup from input folder * Output file generation * Timestamped archive handling * Duplicate re-processing prevention * Field-level validation * Business-rule checks * Date/number correction logic * Error and correction logging * JSON/plain-text report generation * Non-zero exit codes for failures * pytest unit tests Deliverables: * Single runnable .py script * Configurable input/output/archive paths * Validation and processing logic * Audit log/report output * README with setup and usage * Sample pytest tests * Example command-line run I’ll focus on a reliable, scheduler-friendly automation flow that processes each CSV once, logs every important action, and is easy to maintain or extend. Best regards Ankit
₹500 INR in 40 days
4.0
4.0

Hi, I'm a Software Architect with 11+ years building production Python data-processing scripts and automation pipelines. I understand the real challenge here: this isn't just a CSV parser, it's a safe file-state machine - reading, validating against a caller-supplied rule dictionary, writing transformed output, then archiving originals exactly once so nothing gets reprocessed or lost on a crash mid-run. On the rule dictionary format: I'd define it as {column_name: lambda(value) -> (status, corrected_value_or_None)} where status is one of 'valid'/'corrected'/'unrecoverable', so your business rules stay declarative and the engine just applies them uniformly and logs the outcome per field. What I'll deliver: - Single Python 3.10+ script (pandas-based) with watched-folder polling, timestamped archive-and-move logic - Field and record-level validation against your rule dictionary, with a full audit log (JSON) of every correction - Correct exit codes (0 success, non-zero unrecoverable errors) for your scheduler - README covering setup, config variables, and CLI usage - Pytest suite covering validation and the rename/archive routine I've built exactly this kind of watched-folder ETL/validation script before. I work fast, ask minimal questions mid-project, and deliver exactly what's scoped. Let's build this right.
₹600 INR in 40 days
3.8
3.8

Hello I'll do my job as you send me the area to scrape and processing
₹750 INR in 8 days
3.3
3.3

Hi, I am interested in the Python CSV Processing & Automation project. With 10+ years of experience in full-stack development, I have strong experience building database-driven applications, automation workflows, APIs, data processing solutions, and business-rule-based systems. I have hands-on experience with Python, PHP/Laravel, Node.js, MySQL, PostgreSQL, JavaScript, and React.js. I am comfortable implementing CSV/file processing, field and record-level validation, configurable business rules, error handling, audit logging, file archiving, and scheduler-friendly exit codes. I will ensure files are processed exactly once, corrected records are properly audited, unrecoverable errors are clearly reported, and the required output is generated reliably. I am confident I can deliver a robust and maintainable solution meeting your acceptance criteria. Thank you for considering my application. Best regards, Palwinder Kaur
₹400 INR in 40 days
2.5
2.5

As a seasoned AI and Cloud Data Engineering specialist, I offer a unique value proposition that extends beyond conventional Python-CVS automation. Drawing on my extensive experience in sectors such as finance, healthcare, insurance, and enterprise business, I've honed my skills in automating processes—enabling organizations to leverage data for smarter decision-making, improved efficiency, and reduced costs. Hence, your project aligns perfectly with what I excel at. With skills cutting across AI/ML Development, Cloud Data Engineering & Architecture, Real-Time Analytics & Business Intelligence and AI-Driven Automation & Intelligent Workflows—deploying my expertise in this project won't mean creating just another code. Instead, it means building an automated solution that subtlety draws out every necessary detail from the CSV files and does more than just processing them: actively detecting and flagging errors while leaving an easily navigable audit trail. Moreover, having worked extensively with AWS and Azure-based systems—delivering scalable solutions built on standard libraries—I believe my proficiency will be crucial for the successful execution of your project. Additionally my detailed-oriented nature ensures meticulous documentation and setup instructions so you can start benefiting from the deliverables even after our engagement is over.
₹900 INR in 40 days
2.6
2.6

Hi,I can build this **CSV processing and automation pipeline in Python 3.10+** with a clean, maintainable structure. I’ll implement the watched-folder workflow, validation and business-rule engine, automatic corrections with an audit trail, timestamped archiving, structured logging, and proper exit codes for scheduler integration. Deliverables will include: * Runnable `.py` script * Configurable input/output/archive paths * Support for your Python lambda rule dictionary * Validation and error handling * Audit log with processing statistics * `pytest` unit tests for validation and file-renaming logic * Clear README with setup and usage examples I can start immediately and deliver a **working first version within 1–2 days**.
₹400 INR in 40 days
1.8
1.8

Hi, I can build a clean Python 3.10+ CSV processing script with automated file handling, validation, configurable lambda-based business rules, error correction/audit logging, timestamped archiving, JSON/text reporting, proper exit codes, README documentation, and pytest coverage. I’ll keep the workflow reliable and scheduler-friendly with no manual intervention. 1. Can you share the expected CSV header/sample file and your rule-dictionary format? 2. Should corrected records be written to output while the original CSV is always preserved in `_archive`? if looking for expert then lets connect (having UK , UAE and Country Experience) chat will start soon and provide 100% (result)
₹600 INR in 40 days
1.8
1.8

Hello, ➤ I understand you’re looking for a reliable professional who can handle your Python CSV automation project with precision and expertise. ✦ PROFESSIONAL QUALITY | FAST COMMUNICATION | UNLIMITED REVISIONS ✦ ❇️ WHAT I CAN OFFER: ▪ A clean, well-documented Python script that efficiently manages CSV file processing according to your requirements. ▪ Implementation of robust file I/O handling, including automatic reading, transformation, and archiving of files. ▪ Comprehensive data processing with validation checks and error logging to ensure data integrity. ▪ Clear reporting that meets your criteria, including handling of exit codes for error management. ▪ Regular updates and a collaborative approach to ensure all specifications are met. ❇️ MY APPROACH: I will begin by thoroughly understanding your business rules and requirements, then develop a solution that aligns perfectly with your needs. My experience with Python and data processing allows me to deliver a functional, error-free script tailored to your specifications. ✨ I’m ready to get started and can begin immediately. Send me the details and I’ll ensure the project is handled professionally from start to finish. Regards, Shaun Kelly
₹400 INR in 7 days
1.4
1.4

Hello, I understand you need a clean Python 3.10+ automation script that watches an input folder, validates and transforms CSV transaction data, archives processed files safely, and generates an audit-ready report. The goal is a reliable unattended workflow with accurate processing, clear logging, and correct scheduler exit codes. Here’s what I can provide: Automated CSV file handling with safe processing, timestamped renaming, archive movement, and protection against duplicate processing. Field-level validation plus configurable record-level business rules using Python/pandas, with automatic corrections and detailed change tracking. Structured TXT/JSON reporting, robust exception handling, non-zero exit codes for unrecoverable errors, and pytest coverage for validation and file-renaming routines. I bring over 4+ years of experience in Python, data processing, scripting, automation, Pandas, JSON, and software development, focusing on clean, maintainable, and reliable automation solutions. Just to clarify a few things: Will the rule dictionary contain only synchronous Python lambdas? Should corrected values be written to a separate error/audit report as well? Please come to the chat box to discuss more about your project. Best regards Indresh Kushwaha
₹600 INR in 40 days
1.9
1.9

Hello, I’m Ankur Hardiya, a friendly freelance developer with an awesome team. I read your requirement for Python CSV automation verification and I’m super excited to Develop and Design a fantastic website for you As an experienced developer with expertise in PHP (Laravel), React.js, Node.js, and WordPress, I have developed a number of websites like HRMS, CRM, eLearning platform, and eCommerce website I can help you create a robust and user-friendly solution that meets your specific needs. My approach involves: * In-depth understanding of your requirements * User-centred design and development * Secure and scalable architecture * Ongoing maintenance and support I’ve successfully delivered projects for clients in various industries, and I’m confident I can exceed your expectations. Thanks a bunch for thinking of me for your project. I’m all set to turn your ideas into something amazing in today’s competitive world. Regards, Ankur Hardiya
₹475 INR in 20 days
0.2
0.2

Hi, I can build this as a clean Python 3.10+ CSV automation utility with reliable validation, file handling, audit logging, and tests. My approach would include: - Automatic processing of incoming CSV files - Header and field validation for required values, types, ranges, and formats - Business-rule checks using your supplied dictionary of callables - Safe correction of detectable errors while flagging unrecoverable cases - Transformed CSV output to the designated folder - Timestamped archival so files are processed exactly once - Clear audit logs covering files, rows, corrections, and errors - Meaningful exit codes for scheduler integration - Pytest coverage for validation and archive/rename behavior - A concise README with configuration and usage examples I’ll structure the code so validation, transformation, file handling, and reporting remain easy to maintain and extend. My rate is ₹650/hour, and I estimate approximately 5–8 hours for the scope described after reviewing the CSV schema and rule dictionary. One question: if a file contains unrecoverable rows, should valid rows still be exported with a non-zero exit status, or should the entire file be rejected?
₹650 INR in 10 days
0.3
0.3

Hello, I have reviewed your Python CSV Automation & Verification requirements and can build a clean, reliable automation script for the complete workflow. The script will automatically monitor and process CSV files from the input folder, validate mandatory fields, data types, ranges, and apply your business rules through the provided Python dictionary of lambdas. Detectable issues such as incorrect date formats or invalid numeric values can be corrected where possible, with every change recorded in an audit log. After processing, the transformed CSV will be saved to the output location, while the original file will be renamed with a timestamp and moved safely to the _archive folder to prevent duplicate processing. I will also implement clear error handling, JSON or text reporting, and proper exit codes so your scheduler can identify successful and failed runs. The delivery will include a documented Python 3.10+ script, README with configuration and usage instructions, and pytest unit tests for validation and file renaming. With 7+ years of development experience, I can deliver clean, maintainable, and well-documented automation. Please message me or come for a chat to discuss the rule dictionary format and edge cases. Best Regards Aman
₹575 INR in 40 days
0.0
0.0

Hello, I can build this as a clean, reliable Python 3.10+ automation with a strong focus on validation, auditability, and safe file handling. My Approach 1. File Processing – Watch/read incoming CSVs, validate headers, process them, and write results to the configured output folder. 2. Validation Engine – Implement field-level type, range, and mandatory checks with clear error handling. 3. Business Rules – Support your Python dictionary of lambdas for flexible record-level rules without hardcoding business logic. 4. Error Correction – Detect and correct recoverable issues such as date/numeric formats while recording every change in an audit log. 5. Archive & Safety – Timestamp source filenames and move them to `_archive` exactly once after successful handling to prevent duplicate processing. 6. Reporting & Tests – Generate concise JSON/text reports, return proper exit codes, and provide pytest coverage for validation and file-renaming logic. I’ll also provide a clear README covering configuration, rule definitions, setup, execution, and scheduler integration. GitHub:mukeshcodyy I’ll keep the implementation modular, documented, and easy to extend when your business rules evolve. Let’s have a quick chat to confirm the rule-dictionary format and edge cases before development.
₹600 INR in 45 days
0.0
0.0

Bhubaneswar, India
Member since Oct 16, 2025
₹12500-37500 INR
₹400-750 INR / hour
₹400-750 INR / hour
$250-750 USD
$8-15 USD / hour
₹12500-37500 INR
$250-750 USD
$250-750 USD
₹2000-4000 INR
$250-750 USD
€8-10 EUR
₹1500-12500 INR
$30-250 USD
$15-25 USD / hour
$250-750 USD
$30-250 USD
$250-750 USD
$15-25 USD / hour
$10-50 USD
$15-25 USD / hour
₹12500-37500 INR
$250-750 USD