Back to Skills

Skill focus

Pandas

pandas is a practical tool for reshaping, checking, joining, and preparing messy datasets before they become reports or dashboards.

pandasPythonCSVExcelParquet

How it helps in an office

For office reporting, pandas is especially useful when exports arrive with inconsistent columns, duplicate records, missing values, or multiple files that need to become one clean dataset.

Practical examples

  • Combine monthly exports into one clean reporting table.
  • Standardize categories and date fields.
  • Flag duplicates, missing values, and outliers.
  • Prepare repeatable datasets for SQL, Power BI, or Excel.

What I focus on

data cleaning
joins
reshaping
quality control