Python pandas—Time Series Exercises—Apple Stock

Sometimes we learn best by doing. Unlike my other videos, I’ll be going through these exercises cold. Sometimes we’ll encounter ambiguous questions, and sometimes I'll be wrong. Learning from our mistakes can be a powerful teacher. So, it’s OK to be wrong now, because we’ll know how to avoid it next time when it counts. My hope is that you will learn by doing. Why don’t you proceed through the linked exercises before we walk through them together? This series can be viewed in tandem with my “An Opinionated Guide to pandas“ video series (links below), but it’s not required. This series is beginner-friendly but aimed most directly at intermediate users.

This Learning by Doing is part of the pandas Opinionated Guide series:

The jupyter notebooks can be found here:

[arhataria]

It's nice to see you every week with your valuable lecture! :D Thanks as always

Things I learned from this lecture:
apple.index[0] - apple.index[-1]
resample -> BM: Business days of each Month
plt.set_size_inches()

[kiscode]

I really enjoyed this kind of learning by doing way. It really helps you build the thought process of solving the questions. Thanks for the nice lecture!

[stevedevney]

At 7:15 in the the video I was screaming ' is month end... Is month end' you were so close to seeing it:)

[jordanhensiek]

Hello! could you possibly go over pivot tables? The only video about pivots you have helped me a lot but there wasn't anything on pivot tables

[StefanoVerugi]

I think the resample method might give you unexpected results, to work with the actual dataset index (keeping the same info of the resulting record) I found the .tail(1) method more accurate.
The dataset in the video was already filtered listing working days only, to find the last of the dates in the index by month:
df.groupby([df.index.year, df.index.month]).tail(1)

[ahmadKha]

very nice, BUT, regarding the last business day of the month, only yours was correct, the solutions approach used ( mean) in the end, which is wrong, they didn't present the days, you did.

[pursueweazmarecoverall]

Hi, thanks a lot for this discussion. I think I need help. I have three sets of csv files of measurements which include the dates and times of the day at which they were taken. I am supposed to combined them, compare the data entries taken on the same time and date, are you able to advise how?

[sofianesofiane]

Hi thanks for information
Can you use neural network model to predict price stock?!?😉😉😉