Others · OTC-14

Practical Data Science with Jupyter

Practical Data Science with Jupyter is a course in hands-on data work with Python in JupyterLab, from a Python refresher and NumPy calculations to loading, cleaning and summarising data with pandas, building charts with Matplotlib and seaborn, and carrying out exploratory data analysis. It suits data analysts and aspiring data scientists who have already completed Python Basic.

Updated
From 8,550 THB / person 9,500 −10% excl. VAT 7% · group rates available
PDFDownload the course outline
  • Duration18 hours · 3 days
  • FormatOnsite / live online
  • Next roundOn request
  • CertificateIncluded

Course overview

Most data science work does not start with building models. It starts with loading scattered data, cleaning it, reshaping it, summarising it and charting it so the picture becomes clear. Python with Jupyter notebooks is the standard toolset for this work, because code, results and explanations of what you found live in one file that is easy to rerun and share with the team.

This course takes learners who have completed basic Python through structured data work in JupyterLab. They review the Python used with data, calculate with NumPy, manage data with pandas 3, read CSV, Excel and JSON files, clean data including missing values, duplicates, text and dates, combine and summarise data, and build charts with Matplotlib and seaborn. The course closes with exploratory data analysis of a real data set, ending in a report inside a notebook. (3 days, 6 hours per day, 18 hours in total, Beginner level.)

What you’ll gain

  • Install and use JupyterLab for data analysis
  • Use Python data structures, functions and lambdas for data work
  • Carry out vectorised calculations and basic statistics with NumPy
  • Manage data with pandas 3 Series and DataFrames
  • Read and write data files such as CSV, Excel and JSON
  • Clean and prepare data following the data science process
  • Summarise data and build charts with Matplotlib and seaborn
  • Carry out exploratory data analysis and communicate results in a notebook

Who this course is for

  • Data analysts who want to move from Excel to Python
  • People who want to start a career as a data scientist
  • Students, teachers, lecturers and researchers who handle large amounts of data
  • IT staff and employees who prepare data and reports regularly

Prerequisites

  • Completed Python Basic, or able to write basic Python
  • Basic use of Excel or another spreadsheet
  • Basic statistics such as mean, median and standard deviation
  • A laptop with permission to install software

Curriculum

Course Details

This course is the 2026 edition of Practical Data Science with Jupyter. It runs for 3 days, 6 hours per day (18 hours in total, 09:00-16:00), as lectures with labs. Beginner level. It keeps the original core of Jupyter, a Python refresher covering lambdas and CSV handling, NumPy, pandas, data cleaning and Matplotlib charts, but installs JupyterLab with uv instead of Anaconda, moves to pandas 3 and NumPy 2, drops XML parsing with lxml.objectify and adds merge, groupby, seaborn and an EDA workshop. The course focuses on preparing and exploring data; learners who want to build predictive models can continue with Data Science with Python. All tools are open source and free. Learners take home a lab guide, notebooks and sample data sets for further practice.

Day 1 JupyterLab, Python for Data and NumPy

Section 1: Lab: Setting Up JupyterLab

  • The data science process and the role of notebooks
  • Install Python and JupyterLab with uv and start it with jupyter lab
  • Code and Markdown cells, kernels and common shortcuts
  • Magic commands and opening notebooks in VS Code
  • Lab: a first notebook with code, results and explanations

Section 2: Lab: Python for Data Work

  • Indentation, objects, variables and dynamic typing
  • Numeric types, strings, booleans, None and type conversion
  • Dates and times with datetime
  • if, for, while and f-strings
  • Lab: calculate and format daily sales data

Section 3: Lab: Data Structures and Functions

  • Tuples, lists, sets and dictionaries, with slicing and sorting
  • enumerate, zip, sorted and comprehensions
  • Functions, returning several values and lambdas
  • Generators and error handling with try and except
  • Lab: transform raw data from a .csv file with plain Python

Section 4: Lab: The NumPy ndarray

  • Create ndarrays and array data types
  • Vectorised calculations instead of loops
  • Indexing, slicing, boolean indexing and fancy indexing
  • Reshape arrays and swap axes with reshape and transpose
  • Lab: analyse a score table with multi-dimensional arrays

Section 5: Calculations and Statistics with NumPy

  • Universal functions and conditions with np.where
  • Mathematical and statistical methods such as mean, std and sum along an axis
  • unique and set logic
  • Random numbers with default_rng and basic linear algebra
  • Lab: simulate data and save it as an .npy file
Day 2 pandas 3 and Data Cleaning

Section 6: Lab: Getting Started with pandas 3

  • Series, DataFrame and Index
  • The str data type, now the default in pandas 3
  • Copy-on-Write and why chained assignment no longer works
  • Select data with loc and iloc
  • Lab: explore a customer table with head, info and describe

Section 7: Lab: Selecting, Filtering and Calculating

  • Filter data by conditions and with query
  • Sort and rank data
  • Calculate between columns and align data by index
  • apply, map and value_counts
  • Lab: find best-selling products and frequent customers

Section 8: Lab: Reading and Writing Data Files

  • Read and write CSV, including Thai text and other delimiters
  • Read Excel files with several sheets using openpyxl
  • JSON data and tables from web pages with read_html
  • Read large files in chunks and save as Parquet
  • Lab: combine sales from several files into one table

Section 9: Lab: Data Cleaning, Part 1

  • Find and handle missing values with isna, dropna and fillna
  • Remove duplicates and replace wrong values
  • Convert data types and rename columns
  • Detect and handle outliers
  • Lab: clean survey data

Section 10: Lab: Data Cleaning, Part 2

  • Work with text using .str and regular expressions
  • Parse dates with to_datetime and extract year, month and day
  • Categorical data and reducing memory use
  • Bin data with cut and create dummy variables
  • Lab: prepare customer data for analysis
Day 3 Summarising, Visualisation and EDA

Section 11: Lab: Combining and Summarising Data

  • Combine tables with merge, join and concat
  • Group and summarise with groupby and agg
  • Summary tables with pivot_table and crosstab
  • Reshape tables with melt and pivot
  • Lab: a sales report by region and month

Section 12: Lab: Charts with Matplotlib

  • Figures and axes, and displaying Thai fonts
  • Bar charts, line charts and stacked plots
  • Histograms, scatter plots and box plots
  • Customise colours and labels, and save charts as images
  • Lab: a set of charts for a monthly report

Section 13: Lab: Charts with seaborn and pandas

  • Quick charts from a DataFrame with .plot
  • Data distributions with seaborn
  • Relationships between variables and a correlation heatmap
  • Split charts by group with facets
  • Lab: compare the behaviour of customer groups

Section 14: Exploratory Data Analysis (EDA)

  • Set business questions before starting the analysis
  • Descriptive statistics, correlation and covariance
  • Choose charts that answer the question and tell a story with data
  • Use an AI assistant to help write pandas code, and always check the result yourself
  • Lab: an EDA of sales data with conclusions

Section 15: Workshop: A Real Data Project

  • Load raw data from several sources and clean it
  • Summarise the data and build charts that answer the questions set
  • Organise the notebook for readability and export it to HTML
  • Keep the environment with uv and share work through Git
  • Next steps towards machine learning and dashboards

Schedule & training options

For individuals — public rounds

No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770

For organisations — in-house / private

  • Tailor the content to your team’s tools and projects
  • Your dates, at your office or live online
  • Quotation with tax ID for procurement
Corporate training quote

Instructors

Frequently asked questions

What is Jupyter Notebook, and how do I install it?

A Jupyter notebook is a file that combines code, results, charts and explanations in cells, so you can experiment and present your analysis in one place. JupyterLab is the current application for opening and editing notebooks. In the course we install it with uv by creating a project, adding jupyterlab, pandas and matplotlib, then running uv run jupyter lab. If you already use Anaconda you can keep using it, or open notebooks in VS Code.

How do I handle missing data in pandas?

First check which columns have missing values and how many with isna().sum(). Then choose a method that fits the data: if few rows are affected and they do not matter, remove them with dropna; if you need to keep them, fill the gaps with fillna using the mean, median, most common value or, for time series, the previous value. Record the reason for each decision in the notebook. In pandas 3, text columns use NaN for missing values like other column types.

How is a NumPy array different from a Python list?

A Python list can hold any mix of types, and calculations need a loop over each item. A NumPy array stores values of one type contiguously in memory, so a whole set can be calculated in one vectorised statement, which is much faster on large data. Arrays also support many dimensions and come with ready-made mathematical and statistical functions. pandas itself is built on the same idea.

Who is the Practical Data Science with Jupyter course for, and what should I know beforehand?

It suits data analysts who want to move from Excel to Python, people starting a data science career, students and researchers who handle large data sets and employees who produce regular reports. You should have completed Python Basic or be able to write basic Python, use Excel at a basic level and understand basic statistics such as the mean and standard deviation.

What will I be able to do after the Practical Data Science with Jupyter course?

You will be able to work with data confidently in JupyterLab, calculate with NumPy, manage tables with pandas 3, read CSV, Excel and JSON files, clean data including missing values, duplicates, text and dates, combine and summarise data, build charts with Matplotlib and seaborn, and carry out EDA to reach conclusions from real data. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.

What software do I need for Practical Data Science with Jupyter?

Bring a laptop with permission to install software. Install uv and let it install Python 3.13 or later, JupyterLab, NumPy, pandas, Matplotlib and seaborn, or open notebooks in VS Code if you prefer. All tools are open source and free. The instructor provides sample data sets and notebooks for every lab.

Related articles

Articles are published in Thai.