Pandas and Data Visualization Using Matplotlib and Seaborn

New chapter in Learning data analytics and data science. The focus now is on Pandas as a Python library alongside Matplotlib and Seaborn for data visualization.
Am writing this article to guide beginners who are already or beginning the data analytics and data science profession.

Introduction to Python Data Analysis

In modern world Data has become most valuable asset. Business, healthcare institutions, financial and even social media platforms rely heavily on data to make informed decisions.
Raw data is of no use and that where Data Analysis and visualization becomes important.

One of most used programming language is Python for data analysis because of its simplicity and powerful libraries.
Commonly used libraries are Pandas, Matplotlib and Seaborn.
Pandas: Helps in cleaning, organizing and analyzing data.
Matplotlib and Seaborn: are used to create visual representations of data.

This article introduces Pandas and explains how Matplotlib and Seaborn can be used for effective data visualization in a begginer friendly way.

What is Pandas and Why it Matters

Pandas is open source Python Library used for data manipulation and analysis. It provides simple and efficient tools for working with structured data eg CSV, spreadsheets and databases.

Main data structures in Pandas are:

Series: it is a one-dimensional array like structure.

import pandas as pd
age = {"Age":[18, 20, 23, 40, 50, 24]} 

series = pd.DataFrame(age)
series

#Output: 
Age
0   18
1   20
2   23
3   40
4   50
5   24

DataFrame: It is two dimensional table similar to an Excel spreadsheet or SQL table.

students = {"Name":["Mark", "John", "Nancy"],
            "Grade":["A", "B", "C"],
            "Course":["Data Science", "Data Engineering", "Data Analytics"]}

student_grades = pd.DataFrame(students)
student_grades

#Output: 
    Name    Grade   Course
0   Mark    A   Data Science
1   John    B   Data Engineering
2   Nancy   C   Data Analytics

Pandas matters because it simplifies complex tasks such as:

Performing calculations and statistical analysis
Filtering and sorting information
Cleaning missing or incorrect data
Reading datasets from files

Before using Pandas, it must be installed, run the following command:

pip install pandas

Then imported into Python script:

 import pandas as pd

Reading Data Pandas can easily read files such as CSV and Excel Example:

import pandas as pd

df = pd.read_csv("students.csv")
print(df.head())

The head() function displays the first five rows of the dataset.

Checking Data Information When you want to understand the structure of your data:

print(data.info()) 
print(data.describe())

info() shows column names, data types and missing values
describe() provides statistical summaries such as maximum values, averages

Handling Missing Values Missing values can affect the analysis results. Checking missing data

 print(data.isnull().sum())

Removing missing values:

data = data.dropna()

Filling missing values:

data["Age"] = data["Age"].fillna(data["Age"].mean())

This replaces missing age values with the average age.
Filtering allows users to select specific information
Example:

high_scores = data[data["Score"] > 70] 
print(high_scores)

Sorting data:

sorted_data = data.sort_values(by="Score", ascending=False) 

print(sorted_data)

These operations help organize data for better understanding and reporting

Data Visualization Fundamentals

Data Visualization: It is the process of representing data graphically using charts, graphs and plots. Visualization makes it easier to identify patterns, trends and relationship in data.

For Example:

Scatter plots shows relationships between variables
Bar Charts compares category
Pie Chart display proportions
Line Charts show trends over time

Visualizations helps understand large datasets because humans interpret visuals faster than raw numbers.

Python provides powerful visualization libraries, with Matplotlib and Seaborn being among the most widely used.

Using Matplotlib for Charts

Matplotlib is one of the oldest and most flexible visualization libraries in Python. It provides full control over the chart customization

To install Matplotlib

pip install matplotlib

Import it:

import matplotlib.pyplot as plt

Creating a Line Chart
A line chart is used to show trends.
Example:

import pandas as pd
import matplotlib.pyplot as plt 
plt.figure(figsize=(6, 3))

sns.lineplot(data=housing_df, x="bathrooms", y="bedrooms")
plt.title("Bathrooms vs Bedrooms")
plt.xlabel("Bathrooms")
plt.ylabel("Bedrooms")
plt.show()

The chart shows relationship between Bathrooms and bedrooms.

Creating Bar Chart
Bar chart compare categories.
Example:

# Average satisfaction score by property type
avg_satisfaction_by_prop = housing_df.groupby("property_type")["satisfaction_score"].mean().sort_values(ascending = False).reset_index()

#Plot
plt.figure(figsize = (6,3))

sns.barplot(data = avg_satisfaction_by_prop, x = "property_type", y = "satisfaction_score")
plt.title("Average Satisfaction Score by Property type")
plt.xlabel("Property Type")
plt.ylabel("Average Satisfaction Score")
plt.show()

The chart compares Average satisfaction per property type

Creating Pie Chart
Pie charts represents percentages.
Example:

furnishing_counts = housing_df["furnishing"].value_counts()

explode = (0.05, 0.05, 0.05)

plt.figure(figsize = (6, 6))

plt.pie(furnishing_counts, explode = explode, labels = furnishing_counts.index, autopct="%1.1f%%")
plt.title("Distribution Of the furnishing status")
plt.show()

Pie Chart:

Matplotlib is highly customizable and allows users to change colors, labels, chart sizes, and grid styles.

Using Seaborn for Statistical Visualizations

Seaborn: It is Python library built on top of Matplotlib. It provides more attractive and advanced statistical visualizations with less code.

Install Seaborns

pip install seaborn

Import it:

import seaborn as sns

Seaborn works smoothly with Pandas DataFrames.

Example dataset:

import pandas as pd 
data = { "Student": ["John", "Mary", "Peter", "James"], "Score": [85, 90, 78, 88] }
df = pd.DataFrame(data)

Bar Plot

# Average monthly rent by property type
plt.figure(figsize=(6, 3))

sns.barplot(data=housing_df, x = "property_type", y = "monthly_rent_kes", estimator = "mean", palette = "bright")
plt.title("Average monthly rent by property type")
plt.xlabel("Property Type")
plt.ylabel("Average monthly rent")
plt.xticks(rotation=45)
plt.show()

Seaborn automatically applies better styling than in matplotlib.
Example of more styled Bar Plot:

Histogram
Histograms show data distribution.
Example:

# What is the distribution of monthly rent
plt.figure(figsize = (6, 3))

sns.histplot(data=housing_df, x = "monthly_rent_kes")
plt.title("Distribution of monthly rent")
plt.xlabel("Monthly rent")
plt.ylabel("Number of properties")
plt.show()

This helps determine distribution of Monthly Rent.

Scatter Plot
It reveals relationships between variables.
Example:

# Plotting relationship between bedrooms and bathrooms

plt.figure(figsize=(6, 3))

sns.scatterplot(data=housing_df, x="bathrooms", y="bedrooms")
plt.title("Bathrooms vs Bedrooms")
plt.xlabel("Bathrooms")
plt.ylabel("Bedrooms")
plt.show()

This chart helps to show the relationship between bathrooms and bedrooms.

Heatmap
Heatmaps show relationship between numerical values.
Example:

# Correlation analysis

correlation = housing_df[numerical_columns].corr()

plt.figure(figsize=(6,6))

sns.heatmap(correlation, annot=True, fmt=".2f")
plt.title("Correlation Heatmap for Numerical Variables")
plt.show()

They helps identify strong or weak relationships in datasets.

Heatmap Example

Matplotlib is suitable when detailed customization is required, while Seaborn is ideal for creating visually appealing statistical charts quickly.
In real world, most Analysts use both libraries together because seaborn is built on top of Matplotlib.

Best Practices and Common Mistakes.

Best Practices:

Always clean data before analysis
Use of appropriate charts
Add labels and titles to charts
Visualization should be simple and easy to read
Check for missing or duplicate data

Common Mistakes:

Forgetting labels and or legends
Ignoring missing values
Using wrong charts
Overcrowding charts with too much information

Clear visualization communicates datasets information effectively without confusion.

Conclusion

For analyst to created clear and understandable visualizations, they must use Pandas, Matplotlib, and Seaborn.

Pandas simplifies data cleaning, manipulation, and analysis.
Matplotlib and Seaborn transform raw numbers into meaningful visual insights.

For data analyst or data science beginners, learning these libraries is essential because they are widely used in industries like finance, healthcare, marketing and business intelligence.
Mastering these tools is an important step toward becoming a skilled analyst or data scientist.

推荐订阅源

DEV Community