Pandas Time Series Analysis 5: Period and PeriodIndex

This tutorial continues pandas time series analysis by introducing period and periodIndex. Periods are time duration used to represent many concepts in finance. Pandas provide rich support for period airthmetic. You can create quarterly, yearly, annual etc. periods and perform airthmetic on them. period_range can be used to create periodIndex between specified start and end.

Topics that are covered in this Python Pandas Video:
0:00 What is time stamp?
0:30 What is time span?
1:09 Use period() function
2:45 Arithmetic operations on period objects
6:02 Create quarterly time period
8:28 Use asfreq() function
10:05 List of all frequency
10:38 Create periodindex
14:40 Convert periodindex to datetimeindex
15:12 Convert datetimeindex to periodindex
17:22 Use set_index() function
18:15 Convert index to periodindex using PeriodIndex()
18:59 Create new columns in dataframe

Next Video:

Popular Playlist:

[tahahusain]

The complete playlist of pandas is very nice. To the point and great explanation. Best way to learn in detail!! Thanks for the effort of making it and making it public. Really appreciate it.

[koraykinik]

very nice material - straight to the point- thanks! I watch them in 1.5 speed - works best for me.

[dimitriskass]

Amazing teacher! The whole Pandas videos where very helpfull and to the point, the Dataset and the code used in the videos are available. Trully one of the best tutorial channels in youtube.

[codebasics]

Machine learning tutorials with exercises:

[codebasics]

Machine learning tutorials with exercises are available at:

[vinayvikram]

Too good to understood...well organised too...

[lutfiyanra]

the video is easy to understand, thanks!

[mananions]

@ 11:27 why in PeriodIndex range there is no '2017Q2', '2017Q3', '2017Q4'.

[spicytuna]

great examples and great graphics. thanks for all of your work. I am one of your big fans. Any suggestions on how i should go about analyzing consumer's buying pattern?

[rajbir_singh]

Hello
I have a Nat value in my dataset in date time column and dtype of this column is date time .
How to deal with this. How can we impute it or delete it.
Please suggest

[amoeba]

Note: 'map' is a method of the 'PeriodIndex' Class. It is different from the 'map' method we generally use that needs a function and iterator as inputs. An alternative is
df['end date'] = pd.Series( map(lambda x : x.end_time, df.index), index = df.index)
which uses the generally use 'map' method

[suyashagrawal]

Hi - At 20:00 I am using df.index.apply(lamba x: x.start_date) but that is not working. Why is 'apply' not working in this case? Can someone please explain.
Also, the Start Date and End Date columns I am getting come with the timestamp (e.g. 2016-04-30 why is this so?

[ad]

Dhaval bhai, thank you for this. Can you please make a complete video to make us understand lambda functions in depth ? Thank you.

[joshuadawson]

How can I isolate a particular month over multiple years? e.g OCT 2018, OCT2017, OCT, 2016? Basically, I want to find out is OCT an up month or a down month. It is really cool if you produced some classes on udemy etc. I have been following alone on Youtube and your teaching style is great.

[pallabsaha]

at 20:50, since my (start date and end date) is at the end of the column, if i want start date to be my 2nd column and end date to be my 3rd column, what will be the code for this? thank you.

[pankajakathaita]

Hi if I have an excel sheet where let's say column a and column b contains date and time and column in C contains I have conditionally formatted data which is from this to this and between data generally and highlighted with colors how can I get the index for years is it possible thanks in advance.

[murifedontrun]

In 17:44, what is the purpose of changing the Line Item to index. I see that changing column into Index and then doing a transpose will result in making the revenue, expenses and Profit to be columns and not 0, 1, 2 as columns. IS this the only reason??

[chadhanson]

I can't find the WMT.csv file. it does not appear to be in the github codesbasics link

[SRAVANAM_KEERTHANAM_SMARANAM]

Can you kindly please give the link to google finance. when i type google finance, google is not showing me the details you are showing in the video

[elyarmason]

Hi guys, in this section when i add my end date it shows times as well . i tried couple of the time and its the same. How can I fix this problem? Many thanks for help.