Wexdi - Softskills

Pandas

Pandas is a powerful Python library widely used for data manipulation, analysis, and cleaning. It provides data structures and functions designed to work seamlessly with structured data, such as tables, and is particularly useful for working with data stored in CSV, Excel, SQL databases, and more.

Key Features of Pandas

Data Structures:
- Series: One-dimensional, labeled array capable of holding any data type.
- DataFrame: Two-dimensional, size-mutable, and heterogeneous tabular data structure.
- Panel (deprecated): Three-dimensional data structure.
Data Manipulation:
- Indexing, selecting, and filtering.
- Merging, joining, and concatenating datasets.
- Grouping data with groupby for aggregation and transformation.
- Handling missing data with functions like fillna, dropna.
Input/Output:
- Read and write data from/to various file formats like CSV, Excel, JSON, SQL databases, and more.
Time Series:
- Handling and manipulating time-series data, including date range generation and resampling.
Visualization:
- Works seamlessly with Matplotlib and other visualization libraries for creating insightful charts

import pandas as pd

# Create a DataFrame
data = {
'Name': ['Alice', 'Bob', 'Charlie'],
'Age': [25, 30, 35],
'Salary': [50000, 60000, 70000]
}
df = pd.DataFrame(data)

# View the DataFrame
print(df)

# Basic operations
print(df.describe()) # Summary statistics
print(df['Age'].mean()) # Average age

Nov. 27, 2024, 4:34 p.m.

Pandas

Our Courses

Newsletter

Company

Legal & Accessibility