TDM 10100: Project 6 Question 4 examples

Now we can load the Zillow data into Pandas using pd.read_csv but we need to first load Pandas with import pandas as pd

There is a column called Date:

and we can extract the months from these dates. For instance, the first six values are all from April, the fourth month:

We can also see how many entries occurred per year:

The Iowa Liquor Sales data is too large to read the entire data set. If you try to read it all, your kernel will crash. (If you try, and you crash your kernel, then you need to re-load the data.table library again, from the start of the examples.)

So we can load just a few of the columns, for instance, the Date, Store Number, and Store Name:

and you can see the first few entries:

This time, if we try to extract the months or years with pd.to_datetime, it works in a straightforward way in Pandas.

We can even extract the months and the years together,

by using dt.to_period("M")

In the year 2021, there were 2622712 rows of data:

and the store called HY-VEE #3 / BDI / DES MOINES had 19168 lines of data corresponding to 2021:

If we focus only on June 2021:

we can plot the number of rows of data per day: