top of page

Day-to-day Python for beginners worksheet

This worksheet aims to give practice in core skills used for day-to-day data analysis in Python. It uses markup, example code, and in-code comments to guide and prompt the user to write code that reads data into Pandas, selects interesting and important bits of data using Pandas, perform calculations on that data, and then plot that data to make useful and insightful visualisations. The worksheet uses publicly available data from the Department for Education so the worksheet can be shared freely. Below is an image of the kind of plot you'll be able to make in relatively few lines of code by the end of the worksheet.

Unlike the other Python tools, the instructions for this worksheet are intentionally sparse. The instructions needed can be found on the worksheet itself. There are two version of the worksheet available on the Github: the worksheet, and the answers version. The worksheets can both be found here. The worksheet provides a Jupyter Notebook of uncompleted code. By using examples, guidance, and prompts, found in the worksheet, and by reading and understanding the code written in the worksheet, users will be able to complete the code. This helps them practice both writing their own code, but also reading and understanding pre-written code, a vital skill for any budding Pythonista. If users get stuck, they can look at the Answers version of the code to see how to complete lines they cannot finish. If you need help getting the worksheets from Github and into your Jupyter Notebooks environment, follow our How to use Jupyter Notebooks guide.

bottom of page