Why Pandas for data analysis

Introduction

Pandas helps you work with data easily. It makes handling tables and numbers simple and fast.

You want to clean messy data from a spreadsheet.

You need to explore and understand data quickly.

You want to combine data from different sources.

You need to calculate statistics like averages or sums.

You want to prepare data for charts or reports.

Syntax

Pandas

import pandas as pd

df = pd.DataFrame(data)

Use pd.DataFrame to create a table-like structure.

Pandas works well with CSV, Excel, and many data formats.

Examples

Create a simple table with names and ages.

Pandas

import pandas as pd

data = {'Name': ['Anna', 'Bob'], 'Age': [25, 30]}
df = pd.DataFrame(data)
print(df)

Load data from a CSV file and show the first 5 rows.

Pandas

df = pd.read_csv('data.csv')
print(df.head())

Sample Program

This program creates a table of cities and their temperatures, then prints it.

Pandas

import pandas as pd

# Create a small dataset
data = {'City': ['Paris', 'London', 'Berlin'], 'Temperature': [20, 15, 18]}

# Make a DataFrame
df = pd.DataFrame(data)

# Show the data
print(df)

Important Notes

Pandas is built on top of NumPy, so it is fast for numbers.

It handles missing data smoothly.

Learning Pandas helps you work with real-world data easily.

Summary

Pandas makes data tables easy to create and use.

It helps clean, explore, and analyze data quickly.

It works well with many data formats like CSV and Excel.