Data Wrangling with Python Online - Foundation Plus 2 x ½ Days
This Foundation Plus Python course will teach attendees how to deliver scripted data wrangling with provable results. Attendees will be able to demonstrate how repeatable data wrangling pipelines increase speed, efficiency and accuracy and learn more advanced scripting techniques to expand their skill portfolio.
Description
This course was designed in response to the scrutiny through the UK and EU GDPR facing data practitioners. Those working with data must be consistent, an effective communicator of complex models, ideas and solutions and must work within the NCSC (National Cyber Security Centre) guidance from a Cyber Essentials accredited provider. This foundation plus course will teach attendees how to deliver scripted data wrangling with provable results. Attendees will be able to demonstrate how repeatable data wrangling pipelines increase speed, efficiency and accuracy and learn more advanced scripting techniques to expand their skill portfolio.
2023 Topics
This course is structured into four key parts:
Part I – Handling structured data
Offload the heavy lifting
Iterating data sets
Exercises: Simple summary data
Part II – Extracting data
Mapping data structures for analysis
User friendly interfaces
Exercises: Item value tracker
Part III – Analysing data
Count all the things
Create formatted output
Exercises: Data summary table
Part IV – Completing the program
Class reuse and composition
Building and using helper modules
Exercises: Flexible column analyser
2023 Online Platform and Software Requirements
Computer with video camera, speakers and microphone
Stable internet connection
Mains power
Zoom - This course can only be accessed via the desktop version of Zoom, so if necessary please submit a request with your IT team to download Zoom in advance. Alternatively, use a personal computer to attend this course.
A PDF Reader
MS Excel
Modern web browser (latest Chrome or Firefox)
Miniconda (minimal Python data science package)
Thonny (minimal Python script editor and debugger).
2023 Other related courses to continue your development...
Data Wrangling with Python - Introduction
Data Wrangling with Python - Intermediate
2023 Prior knowledge
Attendees will learn how to use Python to do the heavy lifting and a variety of foundational data manipulation and analysis techniques. It will help attendees to understand how real-world data structures can be easily represented in Python, how to build a complete and useful programme, and where to find further resources to continue to grow their Python skills.
2023 Learning objectives
By growing your understanding of how real-world data structures can be represented in Python you will become efficient in building complete and useful programmes.
2023 Course goals and outcomes
Attendees will learn how to use Python to do the heavy lifting and a variety of foundational data manipulation and analysis techniques. It will help attendees to understand how real-world data structures can be easily represented in Python, how to build a complete and useful programme, and where to find further resources to continue to grow their Python skills.
2023 Audience
This course is suitable for OR practitioners, analysts, SAS, SPSS and R users who want to add Python skills to their arsenal of data wrangling and analysis tools.