Chapter 4 The Power of Dataframes

From [xkcd](

Figure 4.1: From xkcd.

In this day and age of ‘big data,’ it almost an oxymoron to claim that ‘data analysis skills are important, relevant and useful.’ In this section, we will start using Pandas which is Python’s de-facto module for data analysis. In addition to using Pandas you will see how immensely efficient it is to have your data in a dataframe than in a spreadsheet.


Pandas offer several ways (i.e. different syntaxes) to achieve a specific goal. We will not cover all of these. Instead, we will only highlight a minimally sufficient set of syntax and instructions.

All Files

Filename Download link
test01.xlsx Link
test02.xlsx Link
class.xlsx Link
spsClass.xlsx Link
iris.csv Link