Spreadsheet Update with Review Insights
Budget: ₹12,500 – ₹37,500 INR
I maintain a product spreadsheet and now want to enrich it with insights drawn from our customer reviews. All reviews live in plain .txt files, one file per product. What I need pulled from those files is three-fold: overall sentiment, a concise keyword list that best captures what buyers talk about, and a quick rating summary to drop into the sheet.
You may choose the workflow you’re most comfortable with—Python-pandas, Excel VBA, or another reliable route—as long as the end result is a neatly updated spreadsheet that matches my existing column structure.
Deliverables
• For every product row, fill in: sentiment score/label, 3-5 key keywords, and an averaged rating figure.
• Provide the script or repeatable method you used so I can run it again on future data drops.
• Brief note explaining any assumptions or preprocessing steps.
Accuracy on text parsing and a clean, well-formatted spreadsheet are the main acceptance criteria. If you’ve handled NLP tasks such as sentiment analysis and keyword extraction before, this should be straightforward.
You may choose the workflow you’re most comfortable with—Python-pandas, Excel VBA, or another reliable route—as long as the end result is a neatly updated spreadsheet that matches my existing column structure.
Deliverables
• For every product row, fill in: sentiment score/label, 3-5 key keywords, and an averaged rating figure.
• Provide the script or repeatable method you used so I can run it again on future data drops.
• Brief note explaining any assumptions or preprocessing steps.
Accuracy on text parsing and a clean, well-formatted spreadsheet are the main acceptance criteria. If you’ve handled NLP tasks such as sentiment analysis and keyword extraction before, this should be straightforward.
Related categories:
Python
Data Processing
Data Entry
Excel
Word
Excel VBA
Data Analytics
Data Analysis