Excel Data Pattern Analysis

I have a collection of Excel and CSV files that need a thorough descriptive analysis aimed specifically at uncovering meaningful patterns and correlations. The raw files are already organised in folders; what is missing is an insightful narrative that tells me how different variables interact and where notable relationships lie.

Scope of work
• Import and clean every Excel/CSV dataset, resolving obvious quality issues (duplicates, empty fields, mismatched formats).
• Run descriptive statistics and correlation checks, using the tool of your choice—Python (pandas, NumPy, seaborn), R, or advanced Excel functions are all fine as long as the process is reproducible.
• Visualise key findings in clear charts or dashboards that quickly highlight the strongest relationships.
• Summarise the results in a concise report (PDF or slide deck) that explains each discovered pattern, its potential business relevance, and any caveats.

Acceptance criteria
• Reproducible script or workbook supplied with comments.
• Visuals must open without missing-font or missing-data errors.
• Report delivers at least three actionable insights supported by metrics (e.g., correlation coefficients, frequency counts).
• All original files remain unaltered; analyses are performed on copies.

Timing is flexible within a week once files are shared, and I will be available for clarifying questions throughout the project.