Pandas and Matplotlib

We explored Pandas today and experimented with reading multiple sheets from an Excel file. This included specifying sheet names or indices and handling datasets with multiple sheets.

We also learnt how to merge data frames, join data frames on specific columns and convert series to data frames for merging:

Understanding various operations on data frames was also on the to-do list today, we focused on accessing specific columns, applying functions to columns, and creating new columns based on existing data.

The below example shows how to create a new column in a data frame using an existing column:

Visualising this data is simple when using matplotlib, which is pretty similar to R so I found it easy to understand. In this class we created histograms, scatter plots, and bar graphs to experiment with plots.

Multi line plots are good for visualising 2 or more variables in the same plot: