Pandas training course | JBI Training | Remote | Virtual

Highlights

– Pandas and Python.
- Efficient data modelling
– Deep-dive into pandas data types
– Choosing data types when loading the data
– Data type conversions
– Best practices to improve your memory usage
– Efficient data pipelines
– Understanding immutability
– Method chaining to improve readability
– Best practices data transformation and query pipelines
– Efficient slicing and dicing
– Complex aggregations (groupby) on multiple columns
– Mastering the hierarchical (multi-level) index
– Index stacking and unstacking
– Pivoting and reshaping
– Beyond pandas

A taster video for Python Remote Training

Course Details

Efficient data modelling

– Deep-dive into pandas data types
– Choosing data types when loading the data
– Data type conversions
– Best practices to improve your memory usage when dealing with larger data sets

Efficient data pipelines

– Understanding immutability
– Method chaining to improve readability
– Best practices to develop and maintain complex data transformation and query pipelines

Efficient slicing and dicing

– Complex aggregations (groupby) on multiple columns
– Mastering the hierarchical (multi-level) index
– Index stacking and unstacking
– Pivoting and reshaping

Beyond pandas – Exploring the pandas ecosystem

– Overview and examples of usage of other libraries built on top of pandas to address
specific needs in data preparation, data analysis and data visualisation

Who should attend

Quants, Analysts, BI professionals, Data Scientists, Developers and Researchers who use the pandas library for data analysis, already grasp the basics of pandas and would like to take their knowledge to the next level.

This is a course best suited for “advanced beginners” or intermediate pandas users, who want to master the best practices.

Feedback

4.8 out of 5 average

"I hadn't integrated Pandas with Python before joining my company. So it's very useful to consolidate my understanding of such skill via this course." JL, Data Analyst, Python for Data Analytics, March 2021

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

Short Video: Python Data Analysis Training Course

Certification

Every delegate will be entitled to a certificate of achievement on completion of the course.

If you are missing your certificate - please use the link below to apply - you can also use this link to sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

The pandas (beyond the basics) training course is designed to help analysts, researchers, BI experts and developers becoming fluent in the use of the pandas library for Python, learning the more advanced features of pandas and adopting the best practices, in order to slice and dice complex data.

Using interactive examples and hands-on exercises, the course provides a full immersion in the advanced features of the pandas library. The course focuses on making your pandas code more efficient, so some very basic familiarity with pandas and its core concepts is assumed.

FAQs

JBI Training offers a structured range of Python courses covering every level, from complete beginners through to advanced developers. Available courses include Python for Data Analysts and Quants, Python Introduction, Advanced Python, Python for Financial Traders, Python Machine Learning, AI-Assisted Python, Python Data Wrangling, Clean Code with Python, and Python NLP. All courses are available as instructor-led classroom sessions in London or as live remote online training, with onsite delivery available for corporate teams.

The Python for Data Analysts and Quants course is designed specifically for professionals working with data, including data analysts, financial analysts, quantitative analysts, business intelligence specialists, and data scientists who are new to Python. It covers core Python, data processing with Pandas and NumPy, data visualisation, and applying Python to real-world analytical workflows. No prior Python experience is required.

Yes. All Python courses can be delivered as customised onsite or online programmes for corporate teams. Content can be tailored to match the team's current skill level, industry context, existing tools, and specific objectives — such as automating data workflows, developing internal applications, or integrating Python with AI and machine learning pipelines. JBI has delivered Python training for organisations including the BBC, NHS, RBS, Cisco, and Capita.

Yes. Several Python courses are designed for non-developers or those with limited programming experience, particularly in data and analytics roles. The Python for Data Analysts course requires no prior programming knowledge. Business professionals and analysts can learn Python for automating tasks, processing data from Excel and databases, and creating visualisations — without needing a software development background.

Power BI is a point-and-click business intelligence tool best suited for building interactive dashboards and sharing visual reports quickly. Python is a general-purpose programming language that provides greater flexibility for handling large datasets, automating complex processes, building machine learning models, and performing statistical analysis. Many organisations use both tools together — Power BI for reporting and Python for data preparation, transformation, and modelling.

Yes. JBI offers several Python courses that address AI and machine learning, including Python Machine Learning, Introduction to AI and ML with Python, Data Science and AI/ML with Python, TensorFlow, and AI-Assisted Python — which covers how to use AI coding assistants alongside Python development. These courses are suitable for data scientists and developers who want to build, train, and deploy machine learning models using Python.

Course duration varies by topic and level. Introductory Python courses typically run for three days. Specialist courses such as Python for Financial Traders or Python Machine Learning are generally two to three days. Advanced programmes such as Advanced Python Mastery run for four days. Single-day focused courses are also available, including Pandas Beyond the Basics and AI-Assisted Python. Corporate programmes can be structured flexibly to suit team schedules.

Yes. JBI's Python courses are continuously reviewed and updated to reflect the latest stable Python releases and current best-practice libraries and frameworks. This includes updates to Pandas, NumPy, scikit-learn, TensorFlow, and the latest AI-assisted coding tools. Course content reflects how Python is actively used in professional development, data science, and AI engineering roles today.

Pandas - Beyond the Basics training course

Become fluent and adopt best practices in the use of the pandas library for Python

Public Courses

Customised Courses

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

What Python training courses are available in London and online?

Which Python course is suitable for data analysts?

Can Python training be customised for corporate teams?

Is Python training available for non-developers or business users?

What is the difference between Python and Power BI for data analysis?

Do Python training courses cover AI and machine learning topics?

How long does it take to complete a Python course?

Are Python courses kept up to date with the latest releases and libraries?

Email this page to yourself