Data Wrangling with Python - Foundation Plus - DAY 2
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 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.
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 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 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 - DAY 1
Data Wrangling with Python - Intermediate - DAY 3