Python Pandas: Data Wrangling & Cleaning Made Simple

Data wrangling and cleaning are essential steps in data analysis and processing. With Python's Pandas library, you can perform these tasks efficiently and effectively. This guide will walk you through the process of data wrangling and cleaning using Pandas.

Table of Contents

  1. Introduction to Pandas
  2. Installing Pandas
  3. Importing Data
  4. Data Wrangling
  5. Data Cleaning
  6. Exporting Data
  7. Conclusion

Introduction to Pandas

Pandas is a powerful Python library for data manipulation and analysis. It offers data structures and functions that make working with structured data, like spreadsheets and time series, easy and efficient.

Installing Pandas

To install Pandas, simply run the following command in your terminal or command prompt:

pip install pandas

Importing Data

Pandas can handle various data formats, such as CSV, Excel, and SQL databases. To import data, use the appropriate function for the file type:

import pandas as pd

# Read CSV file
data_csv = pd.read_csv("data.csv")

# Read Excel file
data_excel = pd.read_excel("data.xlsx")

# Read SQL database
from sqlalchemy import create_engine

engine = create_engine("sqlite:///data.db")
data_sql = pd.read_sql("SELECT * FROM tablename", engine)

Data Wrangling

Data wrangling involves transforming raw data into a more usable format. Some common data wrangling tasks include:

1. Selecting Columns

To select specific columns, use the double bracket notation:

selected_columns = data_csv[["column1", "column2"]]

2. Filtering Rows

Use boolean indexing to filter rows based on certain conditions:

filtered_data = data_csv[data_csv["column1"] > 100]

3. Sorting Data

Sort data by one or more columns using the sort_values() function:

sorted_data = data_csv.sort_values(["column1", "column2"], ascending=[True, False])

4. Renaming Columns

Use the rename() function to change column names:

renamed_data = data_csv.rename(columns={"column1": "new_column1", "column2": "new_column2"})

5. Grouping Data

Group data by one or more columns using the groupby() function:

grouped_data = data_csv.groupby(["column1", "column2"]).sum()

Data Cleaning

Data cleaning involves fixing issues in the data, such as missing or duplicate values. Some common data cleaning tasks include:

1. Handling Missing Values

Use the isna() function to find missing values and dropna() or fillna() to remove or impute missing values, respectively:

# Find missing values
missing_values = data_csv.isna()

# Remove missing values
data_no_missing = data_csv.dropna()

# Impute missing values
data_imputed = data_csv.fillna(value={"column1": 0, "column2": data_csv["column2"].mean()})

2. Removing Duplicates

Use the duplicated() function to find duplicate rows and drop_duplicates() to remove them:

# Find duplicates
duplicates = data_csv.duplicated()

# Remove duplicates
data_no_duplicates = data_csv.drop_duplicates()

3. Changing Data Types

Use the astype() function to change the data type of a column:

data_csv["column1"] = data_csv["column1"].astype("float")

Exporting Data

After wrangling and cleaning your data, you can export it to various formats using Pandas:

# Export to CSV
data_csv.to_csv("clean_data.csv", index=False)

# Export to Excel
data_csv.to_excel("clean_data.xlsx", index=False)

# Export to SQL database
data_csv.to_sql("clean_table", engine, if_exists="replace", index=False)


Python's Pandas library streamlines the data wrangling and cleaning process, making it easier and more efficient. By following this step-by-step guide, you can now confidently import, wrangle, clean, and export data using Pandas. Happy data wrangling!

An AI coworker, not just a copilot

View VelocityAI