Python Excel File Automation Script
Budget: ₹1,500 – ₹12,500 INR
I need a clean, well-documented Python script that fully automates my file-management workflow for Excel files. The job is focused on two operations only: moving selected .xlsx/.xls files to the correct destination folders and deleting those that meet specific criteria I will provide (age, naming pattern, or both). All processing is limited to Excel files—no other formats are involved.
Please write modular code that I can run from the command line on Windows and macOS. Native libraries such as os and shutil are fine; if you prefer pathlib or pandas for pattern checks, that’s acceptable too. Clear logging to console and/or a simple log file is essential so I can review exactly which files were moved or deleted after each run.
Deliverables
• A single .py file with inline comments explaining each function
• A brief README outlining any required third-party modules and usage examples
• Confirmation that the script works on the two operating systems mentioned above, handling both file moving and deletion scenarios without manual intervention
Please write modular code that I can run from the command line on Windows and macOS. Native libraries such as os and shutil are fine; if you prefer pathlib or pandas for pattern checks, that’s acceptable too. Clear logging to console and/or a simple log file is essential so I can review exactly which files were moved or deleted after each run.
Deliverables
• A single .py file with inline comments explaining each function
• A brief README outlining any required third-party modules and usage examples
• Confirmation that the script works on the two operating systems mentioned above, handling both file moving and deletion scenarios without manual intervention
Related categories:
C Programming
Data Processing
Excel
Software Architecture
Scripting
Documentation