Time for action – summarizing data
The data we will summarize will be for a whole business week, running from Monday to Friday. During the period covered by the data, there was one holiday on February 21, President's Day. This happened to be a Monday and the US stock exchanges were closed on this day. As a consequence, there is no entry for this day, in the sample. The first day in the sample is a Friday, which is inconvenient. Use the following instructions to summarize data:
To simplify, just have a look at the first three weeks in the sample— later, you can have a go at improving this:
close = close[:16] dates = dates[:16]
We will be building on the code from the previous Time for action section.
Commencing, we will find the first Monday in our sample data. Recall that Mondays have the code
0
in Python. This is what we will put in the condition of thewhere()
function. Then, we will need to extract the first element that has index0
. The result will be a multidimensional array. Flatten this...