Learn to code for data analysis
Learn to code for data analysis

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

Free course

Learn to code for data analysis

Week 1: Having a go at it Part 1


Please note: A number of learners have reported issues with the software and quizzes within this course. We will be carrying out a review and updating the material where necessary. Additionally, a link to a supplementary FAQs page will be added here soon.

Welcome to Learn to code for data analysis! This course has been written to show how a little bit of code can go a long way in making sense of the increasingly vast amounts of open data available online.

If you’re used to the manual approach of copying and pasting formulas in spreadsheets, you’ll see that writing a few lines of code to manipulate data can be quicker, less error-prone, and more powerful.

Please note: in the following video, where reference is made to a study ‘week’, this corresponds to Weeks 1 and 2 of this course.

Download this video clip.Video player: lcdab_w1_intro.mp4
Skip transcript



Hello. I'm Ruth Alexander a journalist with the BBC. I work on the Radio 4 programmes 'Money Box' and 'More or Less'. I'll be introducing each week of this course which will show you how you can write code to work with data. Writing computer programmes is a way of learning what sorts of data computers can represent, how they can make decisions about data and what they can do as a result. You'll be using a notebook style of programming that helps you keep track of each data manipulation step as it happens. Each week of this course is organised around a small data analysis project. You'll get a notebook with exercises to work through and test your coding.

The week will end with a quiz to help you consolidate your learning. Programming requires practise so do have a go at all the exercises and quiz questions and get involved in the discussions. We'll also suggest ways for you to extend each week's project if you have the time. As you'll see if we put the data into the right sort of format a single line of code can do a lot of work with it. The few and short lines of code you'll be writing over the coming weeks employ exactly the same principles used in software developed for any purpose be it games or online shopping.

This week you'll learn some of those general programming principles, how to apply them to data analysis and how to use and share notebooks. Enjoy.

End transcript
Interactive feature not available in single page view (see it in standard view).

You will write code in a programming language called Python, named after the comedy group Monty Python. Python is very popular for teaching programming, but is also widely used in professional software development.

The notebooks Ruth mentions in the video use an environment (like a program) called Jupyter, which allows you to write notebooks that include Python code. Jupyter is used by many scientists and data analysts as part of their workflow. Although you will use Python and Jupyter at a basic level, you will be learning tools used by the pros.

Python, Jupyter and other software you will need to take part in the course are included in the Anaconda distribution (like a package). You’ll have an opportunity to download the software in the next step.

For now, think about your goals are for taking this course. Do you have any previous coding or data analysis experience, e.g. with spreadsheets? Perhaps you want to find more efficient ways of working with data, or perhaps you’re intrigued by the idea of what code is and how it can possibly help you work with data.

The Open University would really appreciate a few minutes of your time to tell us about yourself and your expectations for the course before you begin, in our optional start-of-course survey [Tip: hold Ctrl and click a link to open it in a new tab. (Hide tip)] . Participation will be completely confidential and we will not pass on your details to others.

We hope you enjoy the course!

  • Michel Wermelinger
  • Rob Griffiths
  • Tony Hirst

Take your learning further

Making the decision to study can be a big step, which is why you'll want a trusted University. The Open University has 50 years’ experience delivering flexible learning and 170,000 students are studying with us right now. Take a look at all Open University courses.

If you are new to University-level study, we offer two introductory routes to our qualifications. You could either choose to start with an Access module, or a module which allows you to count your previous learning towards an Open University qualification. Read our guide on Where to take your learning next for more information.

Not ready for formal University study? Then browse over 1000 free courses on OpenLearn and sign up to our newsletter to hear about new free courses as they are released.

Every year, thousands of students decide to study with The Open University. With over 120 qualifications, we’ve got the right course for you.

Request an Open University prospectus371