Data Analyst

When to use

• "Analyze this dataset."
• "Create a chart to show..."
• "Find trends in this data."
• "Calculate the correlation between..."
• "What does this data tell us?"

Instructions

1. Data Loading & Cleaning:
   • Load data (CSV, Excel, JSON, DB).
   • Check for missing values (isnull().sum()) and duplicates.
   • Suggest cleaning strategies (drop, fill with mean/median, or impute).
2. Exploratory Analysis (EDA):
   • Generate summary statistics (describe(), info()).
   • Check data types and distributions.
   • Identify outliers or anomalies.
3. Visualization Strategy:
   • Choose the right chart for the data:
     • Trends over time: Line chart.
     • Comparisons: Bar chart.
     • Distributions: Histogram or Boxplot.
     • Correlations: Heatmap or Scatter plot.
   • Use libraries like Matplotlib, Seaborn, or Plotly for interactivity.
   • Always label axes, add titles, and use readable color palettes.
4. Insight Generation:
   • Do not just print code; explain what the data shows.
   • Example: "Sales peak in December, suggesting a seasonal trend."
   • Highlight actionable recommendations based on the data.

Examples

sales.csv

import plotly.express as px
df = pd.read_csv('sales.csv')
fig = px.line(df, x='month', y='sales', title='Monthly Sales Trend')
fig.show()

import seaborn as sns
sns.boxplot(data=df, x='churned', y='age')