I will clean and analyze your data using python pandas

Kenya

I speak English, Swahili

Data Analyst , Python, SQL, Power BI and Excel Expert

Hello! I’m Kennedy Aineah – based in Nairobi, Kenya, serving clients worldwide. I turn messy data into clear, actionable insights using Python (Pandas, NumPy, Scikit-learn), Machine Learning (regressi...
About this Gig

Your data is messy, Missing values, Wrong formats, Duplicates. I'll fix it.

Before you can visualize or model anything, your data needs to be clean. I use Python and Pandas to transform your raw, frustrating files into:

  • Clean, consistent datasets
  • Summary statistics you can understand
  • Ready-to-use CSV or Excel files
  • Optional: Charts and insights included

Common problems I solve:

  • Merging multiple CSV files into one
  • Removing duplicate rows
  • Fixing dates (e.g., "Jan 1 2023" 2023-01-01)
  • Handling missing values (fill, drop, or flag them)
  • Renaming messy column headers
  • Filtering and sorting exactly how you need

What you send me: CSV, Excel, or JSON file

What you get back: Clean file + Python code (if you want it) + summary of what I changed

Example projects I've done:

  • Cleaned 50,000 rows of sales data in 2 hours
  • Merged 12 monthly reports into a single annual file
  • Prepared student exam data for machine learning prediction

Technology:

Excel

Jupyter Notebook

Power BI

Pandas

MySQL

Analysis type:

Quantitative analysis

Qualitative analysis

Expertise:

Business Insights

Trends

Prediction

Forecasting

Programming language:

Python

SQL

DAX