Getting started with data
What data science is, how tables, types and variables work, and how to read CSV and JSON data with plain Python.
About 5 hours of study
Learning objectives
- Describe the steps of a data science project
- Recognise the type of each variable
- Read CSV and JSON data into Python
Lessons
- 1
What data science is Intermediate
The data science process from a question to an answer: asking a precise question, collecting and cleaning data, exploring it, modelling it and communicating what was found, with a first analysis in plain Python.
- 2
Data types and tables Intermediate
The kinds of variables a dataset holds (numeric, categorical, ordinal, yes/no, text and dates), how a table is organised in rows and columns, and how to inspect a table's shape, types and missing values.
- 3
Reading CSV and JSON data Intermediate
Loading the two most common data formats with the standard library: CSV with csv.reader and csv.DictReader, including quoted fields, JSON with json.loads and json.dumps, and converting text values to the right types.
Module practice
- Data science: Which group did better?Easy
- Data science: Summarise survey answersMedium
- Data science: Did the training help?Hard
- Data science: Name each column's typeEasy
- Data science: Count an ordered categoryMedium
- Data science: Profile a tableHard
- Data science: Read one column from CSVEasy
- Data science: Totals from JSON ordersMedium
- Data science: Convert CSV to JSON linesHard