I'm a market researcher working on a competitive pricing study. I have 2,400 product listings scraped from 8 competitor websites (raw JSON files, one per competitor, stored in a folder). Each JSON record contains: product_name, product_url, price_usd, currency, discount_percentage, product_description (500–1500 characters), category, sku, last_updated_timestamp. I need to parse and consolidate into a single CSV, normalize prices to USD (convert from GBP/EUR where applicable), deduplicate products (same SKU sold across multiple competitors), classify products into standardized categories, and create a summary showing price ranges and discount patterns by competitor and product category. Budget: $200, deadline: 6 days.
78