"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. The Jupyter notebooks provided will be a valuable resource for revising the materials and are really well laid out."
JL, Data Analyst, Python for Data Analytics, March 2021
Short Video: Python Data Analysis Training Course
– 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
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
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.
"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. The Jupyter notebooks provided will be a valuable resource for revising the materials and are really well laid out."
JL, Data Analyst, Python for Data Analytics, March 2021
Short Video: Python Data Analysis Training Course
“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
Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...
All 20 points are in our latest Newsletter - Delivered directly to your inbox
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.
CONTACT
+44 (0)20 8446 7555
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS
