Dashboard with Web Scraping Customer Reviews
Budget: $10 – $30 USD
I have a collection of customer reviews that sit inside regular HTML pages on a public-facing website. Each review contains the text itself, the date it was posted. The page also includes the serving city, state, and ZIP code. I need all these elements pulled out, cleaned (no stray markup or line breaks), and placed into a single, well-structured Excel workbook that’s ready for immediate analysis and this data is used to create a dashboard analyzing negative and positive reviews.
You are free to choose the scraping approach—Python with BeautifulSoup or Scrapy, a headless browser like Playwright, or any tool you trust—as long as the end result is an accurate Excel file with clear columns for Review_Text, Review_Date (YYYY-MM-DD), and Zip_Code.
Deliverable:
• One .xlsx file containing every review currently live on the site, fully deduplicated and formatted.
* One dashboard for easy analysis.
*sentiment analysis for negative reviews and positive reviews.
I’ll validate by spot-checking 5% of the rows against the live pages, so consistency and completeness are key. If that sounds straightforward, let’s get moving.
You are free to choose the scraping approach—Python with BeautifulSoup or Scrapy, a headless browser like Playwright, or any tool you trust—as long as the end result is an accurate Excel file with clear columns for Review_Text, Review_Date (YYYY-MM-DD), and Zip_Code.
Deliverable:
• One .xlsx file containing every review currently live on the site, fully deduplicated and formatted.
* One dashboard for easy analysis.
*sentiment analysis for negative reviews and positive reviews.
I’ll validate by spot-checking 5% of the rows against the live pages, so consistency and completeness are key. If that sounds straightforward, let’s get moving.