Excel-to-CSV Filter Script
Budget: ₹600 – ₹1,500 INR
I have an Excel workbook that I need processed automatically. Your job is to build (or tidy up) a short Python script—pandas is fine—that will:
• read the file I supply
• keep only the rows where the value in the “company” column is an exact match to the keyword I pass in
• prune every other field and leave me with just the “company” column
• write the result straight out to UTF-8 CSV, no additional sorting required
That’s the full requirement for this round. Please return the finished .py file plus a quick note on any third-party packages or command-line arguments I should know about so I can run it immediately.
• read the file I supply
• keep only the rows where the value in the “company” column is an exact match to the keyword I pass in
• prune every other field and leave me with just the “company” column
• write the result straight out to UTF-8 CSV, no additional sorting required
That’s the full requirement for this round. Please return the finished .py file plus a quick note on any third-party packages or command-line arguments I should know about so I can run it immediately.
Related categories:
Python
Data Processing
Excel
Software Architecture
Scripting
Data Analysis
Automation
Pandas