This course is an introductory course for experienced data analysts with little prior background in programming. The focus is on automation of day-to-day analysis tasks.
Some familiarity with programming concepts (in any language) will be beneficial, but prior programming experience is not required.
By the end of the course, you will have all the knowledge you need to start using Python competently for automating various processes involving analysis, modelling, visualisation of various kinds of data. You will have had experience with using Python for various practical data-manipulation tasks with data in a variety of formats, including CSV, Excel spreadsheets, and SQL databases. You will have applied powerful tools for clustering, classification, regression, and optimisation, in useful practical settings on small and large data sets. You will understand the elegance and power of the Python language and its powerful ecosystem of packages for data analysis, and you will be well- placed to continue learning more as you use it day-to-day.
Day 1 covers how to use Python for basic scripting and automation tasks, including tips and tricks for making this easy. The syllabus is as follows:
Day 2 introduces further important concepts for real-world scripting in Python. The syllabus is as follows:
We will supply you with printed course notes and a USB stick containing a complete Python environment based on VirtualBox. This saves time in the course and allows us to focus on using Python rather than installing it. The USB stick also contains kitchen-sink Python installers for multiple platforms, solutions to the programming exercises, several written tutorials, and reference documentation on Python and the third-party packages covered in the course.