Challenge 28 - Can You Trust Your Office Equipment Data_​PV SOLUTION

<p><strong>Challenge 28: Can You Trust Your Office Equipment Data?</strong></p><p><strong>Level:</strong> Hard<br><br><strong>Description:</strong> Your company is planning to upgrade its office setup with new chairs, desks, monitors, and other essentials. To help with the decision, someone scraped product details and reviews, but before trusting this data you have been asked to assess its quality. Your task is to evaluate two datasets (product details and product reviews) and create a <strong>data quality profile</strong> for each, focusing on three key factors: <strong>completeness</strong>, <strong>uniqueness</strong>, and <strong>conformity</strong>. Identify missing, duplicate, or inconsistent information to determine how reliable the data truly is. You can optionally explore further insights, but the main goal is to uncover whether this scraped data is good enough to guide the company’s purchasing decisions. <strong>Hint:</strong> Need help with data quality assessment? Check out <strong>Lesson 3</strong> of our free self-paced <strong>[L4-DA] Data Analytics and Visualization: Specialization</strong> for guidance on measuring and visualizing data quality.<br><br><em>Beginner-friendly objective(s):</em> 1. Load and preprocess the product data from Excel files. 2. Perform basic data exploration to understand the structure and key attributes of the dataset.<br><br><em>Intermediate-friendly objective(s):</em> 1. Calculate key metrics like completeness, uniqueness, and conformity to assess data quality.<br><br><em>Advanced objective(s):</em> 1. Create a comprehensive quality profile for the datasets.</p>