The Lazy Data Scientist’s Guide to Exploratory Data Analysis

Image by Author

# Introduction

 
Exploratory data analysis (EDA) is a key phase of any data project. It ensures data quality, generates insights, and provides an opportunity to discover defects in the data before you start modeling. But let’s be real: manual EDA is often slow, repetitive, and error-prone. Writing the same plots, checks, or summary functions repeatedly can cause time and attention to leak like a colander.

Fortunately, the current suite of automated EDA tools in the Python ecosystem allows for shortcuts on much of the work. By adopting an efficient approach, you can get 80% of the insight with only 20% of the work, leaving the remaining time and energy to focus on the next steps of generating insight and making decisions.

# What Is Exploratory Data Analysis EDA?

 
At its core, EDA is the process of summarizing and understanding the main characteristics of a dataset. Typical tasks include:

• Checking for missing values and duplicates
• Visualizing distributions of key variables
• Exploring correlations between features
• Assessing data quality and consistency

Skipping EDA can lead to poor models, misleading results, and incorrect business decisions. Without it, you risk building models on incomplete or biased data.

So, now that we know it’s mandatory, how can we make it an easier task?

# The “Lazy” Approach to Automating EDA

 
Being a “lazy” data scientist doesn’t mean being careless; it means being efficient. Instead of reinventing the wheel every time, you can rely on automation for repetitive checks and visualizations.

This approach:

• Saves time by avoiding boilerplate code
• Provides quick wins by generating complete dataset overviews in minutes
• Lets you focus on interpreting results rather than generating them

So how do you achieve this? By using Python libraries and tools that already automate much of the traditional (and often tedious) EDA process. Some of the most useful options include:

// pandas-profiling (Now ydata-profiling)

ydata-profiling generates a full EDA report with one line of code, covering distributions, correlations, and missing values. It automatically flags issues like skewed variables or duplicate columns.

Use case: Quick, automated overview of a new dataset.

// Sweetviz

Sweetviz creates visually rich reports with a focus on dataset comparisons (e.g., train vs. test) and highlights distribution differences across groups or splits.

Use case: Validating consistency between different dataset splits.

// AutoViz

AutoViz automates visualization by generating plots (histograms, scatter plots, boxplots, heatmaps) directly from raw data. It helps uncover trends, outliers, and correlations without manual scripting.

Use case: Fast pattern recognition and data exploration.

// D-Tale and Lux

Tools like D-Tale and Lux turn pandas DataFrames into interactive dashboards for exploration. They offer GUI-like interfaces (D-Tale in a browser, Lux in notebooks) with suggested visualizations.

Use case: Lightweight, GUI-like exploration for analysts.

# When You Still Need Manual EDA

 
Automated reports are powerful, but they’re not a silver bullet. Sometimes, you still need to perform your own EDA to make sure everything is going as planned. Manual EDA is essential for:

• Feature engineering: crafting domain-specific transformations
• Domain context: understanding why certain values appear
• Hypothesis testing: validating assumptions with targeted statistical methods

Remember: being “lazy” means being efficient, not careless. Automation should be your starting point, not your finish line.

# Example Python Workflow

 
To bring everything together, here’s how a “lazy” EDA workflow might look in practice. The goal is to combine automation with just enough manual checks to cover all bases:

import pandas as pd
from ydata_profiling import ProfileReport
import sweetviz as sv

# Load dataset
df = pd.read_csv("data.csv")

# Quick automated report
profile = ProfileReport(df, title="EDA Report")
profile.to_file("report.html")

# Sweetviz comparison example
report = sv.analyze([df, "Dataset"])
report.show_html("sweetviz_report.html")

# Continue with manual refinement if needed
print(df.isnull().sum())
print(df.describe())

How this workflow works:

1. Data Loading: Read your dataset into a pandas DataFrame
2. Automated Profiling: Run ydata-profiling to instantly get an HTML report with distributions, correlations, and missing value checks
3. Visual Comparison: Use Sweetviz to generate an interactive report, useful if you want to compare train/test splits or different versions of the dataset
4. Manual Refinement: Complement automation with a few lines of manual EDA (checking null values, summary stats, or specific anomalies relevant to your domain)

# Best Practices for “Lazy” EDA

 
To make the most of your “lazy” approach, keep these practices in mind:

• Automate first, then refine. Start with automated reports to cover the basics quickly, but don’t stop there. The goal is to investigate, especially if you find areas that warrant deeper analysis.
• Cross-validate with domain knowledge. Always review automated reports within the context of the business problem. Consult with subject matter experts to validate findings and ensure interpretations are correct.
• Use a mix of tools. No single library solves every problem. Combine different tools for visualization and interactive exploration to ensure full coverage.
• Document and share. Store generated reports and share them with teammates to support transparency, collaboration, and reproducibility.

# Wrapping Up

 
Exploratory data analysis is too important to ignore, but it doesn’t need to be a time suck. With modern Python tools, you can automate much of the heavy lifting, delivering speed and scalability without sacrificing insight.

Remember, “lazy” means efficient, not careless. Start with automated tools, refine with manual analysis, and you’ll spend less time writing boilerplate code and more time finding value in your data!
 
 

Josep Ferrer is an analytics engineer from Barcelona. He graduated in physics engineering and is currently working in the data science field applied to human mobility. He is a part-time content creator focused on data science and technology. Josep writes on all things AI, covering the application of the ongoing explosion in the field.