Dataset Explorer & Quality Checker

I have a dataset with the following columns: [list your columns and data types, or paste a sample of your data].

Perform an initial data quality assessment:

1. Summary Statistics: For each numeric column, provide mean, median, std dev, min, max, and count of nulls. For categorical columns, show top 5 values and their frequencies.

2. Data Quality Issues: Flag:

   • Columns with >5% missing values
   • Potential duplicate rows (based on key columns)
   • Outliers (values > 3 standard deviations from mean)
   • Inconsistent formatting (mixed case, trailing spaces, date format mismatches)

3. Cleaning Recommendations: For each issue found, provide a specific Python/pandas code snippet to fix it.

4. Initial Insights: Based on the data distributions, suggest 3 questions worth investigating further.

Provide all code in Python using pandas.