Week 3 Videos

Reading a csv file

How to read data from a csv file and store it as a pandas DataFrame, and some of the first steps you can take to investigate that DataFrame.

Distinct values

Various ways to find all the distinct values in a column of a DataFrame.

Missing values 1

An important concept in data science, especially when dealing with real-world datasets, is the concept of missing data. This video introduces some ways to locate missing data in a DataFrame.

Logic

Introduction to the logical operators not, and, or in Python, and their counterparts ~, &, | which should be used with NumPy or pandas.

Missing values 2

A more sophisticated way to detect missing values, and an introduction to the important axis argument, which can be used to indicate whether the rows or the columns should be searched.