Skip to main content
Ace Skills Consulting
BeginnerPopular

Python for Data Science

Go from your first line of Python to a complete, presentable data analysis in five days.

  • 40 hours of live, trainer-led sessions
  • Hands-on Jupyter notebooks every day
  • pandas for cleaning, joining and reshaping data
  • Charts with Matplotlib and seaborn
  • Capstone analysis project on a real dataset
Duration
5 Days | 40 Hrs
Next batch
Batches on request
Delivery
Live Online · Onsite · Corporate
Level
Beginner
Language
English

Why learn this course with Ace Skills

  • Learn by doing

    Write code from the first hour and solve a new data problem in every session.

  • Real-world data

    Work with messy CSVs, spreadsheets and databases rather than tidy textbook samples.

  • Statistics that matter

    Learn the handful of statistical tools analysts actually use and when to apply them.

  • Portfolio project

    Finish with a complete analysis notebook you can show to employers or managers.

Course overview

Python has become the everyday tool for working with data, from quick spreadsheet replacements to the foundations of machine learning. This five-day course is designed for professionals who want to analyse data confidently in Python, even if they have never programmed before.

Days one and two teach the language itself in a data-first way: variables, data types, strings, lists, dictionaries, control flow, functions, modules, files and error handling, followed by NumPy arrays and vectorised calculations. Every concept is practised immediately in Jupyter notebooks with realistic examples such as sales records and service tickets.

Day three is dedicated to pandas: reading CSV, Excel and database data, selecting and filtering, handling missing values and duplicates, working with dates, grouping and aggregating, merging and reshaping. Day four covers visualisation with Matplotlib and seaborn and the descriptive and inferential statistics analysts use most, including correlation and simple hypothesis tests.

Day five is a capstone project. You take a messy public dataset, clean it, explore it, answer business questions and present your findings in a well-structured notebook that you can add to your portfolio.

This is an original Ace Skills course with no vendor exam. On completion you receive an Ace Skills Consulting course completion certificate, and the course prepares you directly for our Machine Learning with Python programme.

Key features

  • Designed for beginners with no coding background
  • Daily hands-on notebooks with realistic business data
  • pandas data cleaning and transformation in depth
  • Visualisation and storytelling with charts
  • Practical statistics for analysts
  • Capstone project for your portfolio
  • Course completion certificate from Ace Skills Consulting
  • Post-training doubt support

Who should attend

  • Analysts who work mainly in Excel
  • Business and finance professionals handling data
  • Engineers and graduates moving into data roles
  • Managers who want to understand their data teams’ work
  • Anyone planning to learn machine learning

Prerequisites

  • Comfort with spreadsheets and basic arithmetic
  • No programming experience required
  • A laptop capable of running Python (setup guidance provided)

Curriculum

5 Days · 40 Hours · 14 Modules · 10 Labs

  1. Getting started

    • Python and the data ecosystem
    • Jupyter notebooks
    • Variables and data types
    • Numbers, strings and formatting
    • Lab: First notebook: calculations on sales figures · 30 min

    Collections

    • Lists and tuples
    • Dictionaries and sets
    • Slicing and indexing
    • List and dictionary comprehensions
    • Lab: Summarise a list of customer orders · 40 min

    Control flow

    • Conditionals
    • for and while loops
    • Iterating over collections
    • Lab: Classify support tickets with rules · 35 min

  2. Functions and modules

    • Defining functions
    • Arguments and return values
    • Lambda functions
    • Importing modules and packages
    • Virtual environments

    Files and errors

    • Reading and writing text and CSV files
    • Working with JSON
    • Exceptions and try/except
    • Lab: Parse and clean a CSV file with plain Python · 45 min

    NumPy

    • Arrays and shapes
    • Vectorised operations
    • Indexing and boolean masks
    • Aggregations and broadcasting
    • Lab: Analyse sensor readings with NumPy · 40 min

  3. pandas basics

    • Series and DataFrames
    • Reading CSV, Excel and SQL
    • Selecting with loc and iloc
    • Filtering and sorting

    Cleaning data

    • Missing values
    • Duplicates
    • Data types and conversions
    • String methods
    • Dates and times
    • Lab: Clean a messy HR dataset · 55 min

    Transforming data

    • groupby and aggregation
    • Pivot tables
    • Merging and joining
    • Reshaping with melt and pivot
    • Lab: Build a monthly sales report from three tables · 50 min

  4. Visualisation

    • Matplotlib fundamentals
    • seaborn for statistical charts
    • Choosing the right chart
    • Styling and annotating for presentation
    • Lab: Create a visual story from retail data · 50 min

    Descriptive statistics

    • Central tendency and spread
    • Distributions and outliers
    • Correlation

    Inferential statistics

    • Sampling and confidence intervals
    • t-tests and chi-square
    • Interpreting p-values responsibly
    • Lab: Test whether a campaign changed conversion · 45 min

  5. Project work

    • Framing business questions
    • Cleaning and exploring the dataset
    • Analysis and visualisation
    • Writing up findings
    • Lab: End-to-end analysis of a public dataset · 210 min

    Presentation and next steps

    • Presenting results
    • Sharing notebooks
    • Where to go next: machine learning and SQL
Download full syllabus (PDF)

Skills you will gain

  • Python
  • Jupyter
  • NumPy
  • pandas
  • Data cleaning
  • Data transformation
  • Matplotlib
  • seaborn
  • Descriptive statistics
  • Hypothesis testing
  • Data storytelling

Tools & technologies

  • Python
  • Jupyter Notebook
  • VS Code
  • NumPy
  • pandas
  • Matplotlib
  • seaborn
  • SciPy

Schedule & Pricing

Live Online

Individual

Price on request

  • 40 hours of live, trainer-led sessions
  • 10 hands-on labs
  • Ace Skills course completion certificate

Onsite

At your office or our centre

Pricing depends on location, group size and dates.

  • Delivered at your premises or an Ace centre
  • Same curriculum and labs as live online
  • Dates planned around your team

Corporate / Team

Private batch for your organisation

A private batch with content adapted to your environment and goals.

  • Customised curriculum
  • Private batch, online or onsite
  • Progress and assessment reports
  • GST invoice and PO-based billing

No public batches scheduled — Talk to an Advisor for a private batch.

Projects & labs you will build

  • Day 3 · 55 min

    Clean a messy HR dataset

  • Day 5 · 210 min

    End-to-end analysis of a public dataset

Your certificate

Certificate of Completion — Ace Skills Consulting

Awarded on completing the course. It records the course title and training hours, and you can share it on your LinkedIn profile.

Frequently asked questions

Is there an exam?

No. This is an original Ace Skills course with no vendor exam; you receive an Ace Skills course completion certificate.

I have never coded. Can I join?

Yes. The course starts from the very basics and is designed for professionals without a programming background.

What software do I need?

A laptop with Python and Jupyter. We send setup instructions before the course and offer a cloud notebook option if installation is restricted.

What should I take next?

Machine Learning with Python is the natural next step and builds directly on this course.

Can we use our own company data?

For private corporate batches, yes — we can tailor exercises and the capstone to anonymised internal data.

Related courses

Explore more

All Data & AI courses

Train your team on Python for Data Science

Private batches online or at your office in India and the GCC, with a curriculum adapted to your environment.