Pandas Best Practices

---
name: pandas-best-practices
description: Best practices for Pandas data manipulation, analysis, and DataFrame operations in Python
---

# Pandas Best Practices

Expert guidelines for Pandas development, focusing on data manipulation, analysis, and efficient DataFrame operations.

## Code Style and Structure

- Write concise, technical responses with accurate Python examples
- Prioritize reproducibility in data analysis workflows
- Use functional programming; avoid unnecessary classes
- Prefer vectorized operations over explicit loops
- Use descriptive variable names reflecting data content
- Follow PEP 8 style guidelines

## DataFrame Creation and I/O

- Use `pd.read_csv()`, `pd.read_excel()`, `pd.read_json()` with appropriate parameters
- Specify `dtype` parameter to ensure correct data types on load
- Use `parse_dates` for automatic datetime parsing
- Set `index_col` when the data has a natural index column
- Use `chunksize` for reading large files incrementally

## Data Selection

- Use `.loc[]` for label-based indexing
- Use `.iloc[]` for integer position-based indexing
- Avoid chained indexing (e.g., `df['col'][0]`) - use `.loc` or `.iloc` instead
- Use boolean indexing for conditional selection: `df[df['col'] > value]`
- Use `.query()` method for complex filtering conditions

## Method Chaining

- Prefer method chaining for data transformations when possible
- Use `.pipe()` for applying custom functions in a chain
- Chain operations like `.assign()`, `.query()`, `.groupby()`, `.agg()`
- Keep chains readable by breaking across multiple lines

## Data Cleaning and Validation

### Missing Data

- Check for missing data with `.isna()` and `.info()`
- Handle missing data appropriately: `.fillna()`, `.dropna()`, or imputation
- Use `pd.NA` for nullable integer and boolean types
- Document decisions about missing data handling

### Data Quality Checks

- Implement data quality checks at the beginning of analysis
- Validate data types with `.dtypes` and convert as needed
- Check for duplicates with `.duplicated()` and handle appropriately
- Use `.describe()` for quick statistical overview

### Type Conversion

- Use `.astype()` for explicit type conversion
- Use `pd.to_datetime()` for date parsing
- Use `pd.to_numeric()` with `errors='coerce'` for safe numeric conversion
- Utilize categorical data types for low-cardinality string columns

## Grouping and Aggregation

### GroupBy Operations

- Use `.groupby()` for efficient aggregation operations
- Specify aggregation functions with `.agg()` for multiple operations
- Use named aggregation for clearer output column names
- Consider `.transform()` for broadcasting results back to original shape

### Pivot Tables and Reshaping

- Use `.pivot_table()` for multi-dimensional aggregation
- Use `.melt()` to convert wide to long format
- Use `.pivot()` to convert long to wide format
- Use `.stack()` and `.unstack()` for hierarchical index manipulation

## Performance Optimization

### Memory Efficiency

- Use categorical data types for low-cardinality strings
- Downcast numeric types when appropriate
- Use `pd.eval()` and `.eval()` for large expression evaluation

### Computation Speed

- Use vectorized operations instead of `.apply()` with row-wise functions
- Prefer built-in aggregation functions over custom ones
- Use `.values` or `.to_numpy()` for NumPy operations when faster

### Avoiding Common Pitfalls

- Avoid iterating with `.iterrows()` - use vectorized operations
- Don't modify DataFrames while iterating
- Be aware of SettingWithCopyWarning - use `.copy()` when needed
- Avoid growing DataFrames row by row - collect in list and create once

## Time Series Operations

- Use `DatetimeIndex` for time series data
- Leverage `.resample()` for time-based aggregation
- Use `.shift()` and `.diff()` for lag operations
- Use `.rolling()` and `.expanding()` for window calculations

## Merging and Joining

- Use `.merge()` for SQL-style joins
- Specify `how` parameter: 'inner', 'outer', 'left', 'right'
- Use `validate` parameter to check join cardinality
- Use `.concat()` for stacking DataFrames

## Key Conventions

- Import as `import pandas as pd`
- Use `snake_case` for column names when possible
- Document data sources and transformations
- Keep notebooks reproducible with clear cell execution order