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