Data Wrangling with Python Online - Introduction 2 x 1/2 Days
Learn how scripted data wrangling can deliver reproducible, provable results. This course will show you how repeatable data wrangling pipelines increase speed, efficiency and accuracy and how simple scripting techniques can expand an analyst’s skill portfolio.
Description
This course will teach attendees how scripted data wrangling delivers reproducible, provable results. It will demonstrate how repeatable data wrangling pipelines increase speed, efficiency and accuracy and teach simple scripting techniques to expand the analyst’s skill portfolio.
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 communicators of complex models, ideas and solutions and must work within the NCSC (National Cyber Security Centre) guidance from a Cyber Essentials accredited provider.
2023 Topics
Part I – Why Excel is Not Enough
When data goes rogue
Python: Hello World!
Exercises: Data manipulation with Python
Part II – Tame that data
Practical data constructs and expressions
Managing unexpected data values
Exercises: Explore data aggregate structures
Part III – Structure and reuse
Functions, classes and objects
Organising code for flexibility
Exercises: Create reusable, flexible code
Part IV – Scripts and parameters
Store code in re-runnable files
Adding parameters for extensibility
Exercises: Extend code to handle new data
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. Also
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 Online - Foundation Plus
Data Wrangling with Python Online - Intermediate
2023 Prior knowledge
There are no pre-requisites for this course. No prior Python programming knowledge is required, as the course is structured so that even non-programmers can follow and interact with the material. A little prior experience of programming generally may be beneficial.
2023 Learning objectives
This course will ensure those working with data are consistent, an effective communicator of complex models, ideas and solutions and work within the NCSC (National Cyber Security Centre) guidance from a Cyber Essentials accredited provider.
2023 Course goals and outcomes
Attendees will learn how to start working with Python and why Python is so well suited to data analysis tasks. The course will provide introductory Python language skills and teach scripted Python techniques through interactive sessions. Delegates will leave with an understanding of where to get more resources and to continue to grow their Python skills in the future.
2023 Audience
This course is suitable for OR practitioners, analysts, SAS, SPSS and R users who want to add introductory Python skills to their arsenal of data wrangling and analysis tools.