Pandas Time Series Analysis Part 2: date_range

Time series analysis is crucial in financial data analysis space. Pandas has in built support of time series functionality that makes analyzing time series extremely efficient. In this tutorial, we will see how date_range function allows to generate datetimeindex with specific start and end dates. It can also generate periods with different frequencies such as hourly,daily,monthly, weekly etc. We will then cover how asfreq function can be used to resample dataframe to a different frequency.

Topics that are covered in this Python Pandas Video:
0:00 Introduction
0:15 Download apple stock prices
2:09 Call date_range() function with arguments
3:24 Use set_index() function of dataframe
4:12 Plot a chart using matplotlib inline
4:56 How to get partial dataframe
5:36 Use asfreq() function
8:03 List of frequencies in date_range() function
10:36 Use randint() function

Code used in this tutorial:

Next Video:

Popular Playlist:

[Ninja-iqxt]

Wow, i was looking for this kind of series, as nobody on YouTube is going that deep in time series data, thanks a lot, and i request you to please make this pandas series as longer as possible.

[VIGILANTORX]

I like your phrase
"Learning coding is equal learning swimming u cant learn by watching someone swimming"

[abc_cba]

Your explanation is simplistic and easy to grab, I wish your amazing course content also features of EdX so that more and more people can get to get such an amazing tutoring. Thank you very much !

[jackrunner]

rang_e = pd.date_range(start="6/1/2022", end="6/30/2022", freq="B")
df1 = df.head(rang_e.shape[0])
df1.set_index(rang_e, inplace=True)
df1

[akashpateriya]

Thank you, Now i have enough reasons to say i am confident in pandas

[lltaha]

Great information. Great presentation. Great delivery. You deserve a lot more views! Good luck on future videos/playlist/series.

[arunjayabal]

Thank you very much sir. This tutorial was extremely useful for my course.

[murifedontrun]

Creating a dateTimeIndex in reverse order
rng = pd.date_range(start="01/03/2019", end="04/03/2019", freq=rnf)[::-1]

[geethapriya]

HI Sir,
Your Videos are very much useful to understand each topic . Thank you so much for your valuable work.
One more suggestion. I would like to know about Time series prediction using various time series algorithms. I saw your time series analysis video. But i didn't see anything wrt time series alogorithms. Please explain those as well as sir.

[SoumilShah]

How to i get the corresponding Data once i apply Date Range drange = pd.date_range(start='2005-10-01', end='2007-10-01', freq='B')
drange. how i fetch columns ?

[digipak]

Thank you for great video but How to do time series analysis on categorical data?

[sameer-verma]

I did an exercise as per below:

import pandas as pd
df=pd.read_excel("D:\Sameer Verma\Python\Apple_Data.xlsx", "Sheet1") #Importing the complete AAPL Stock Data
#filtering the observations for Jan17 only
df3=df2[['Open', 'High', 'Low', 'Close', 'Volume']] #keeping all the columns except date
dateRange=pd.date_range(start="2017-01-03", end="2017-01-31", freq='B')#creating date range
df3.set_index(dateRange, inplace=True)#adding the date range to dataframe
df3

do you think I could have shorten the code, if yes, please help

[massefromla]

Date_range doesn’t work for month of July/2022, July 4th is on Monday .

[pratimadesai]

We can use ffill in the place of pad right !

[bernsbuenaobra]

If one is interested in say only specific months of the year say only at peak month of every December from 12 years of time series of trade data? How does mask it in time series?

[MrPrudhvisai]

can we make all data time formats to common. because pd.date_range and datetime index format is different

[muditbinwal]

Getting an error in set_index

Length mismatch. Expected axis has 22 elements, new value have 23 elements...

Help...

[dhruvinsuthar]

hello, I did not find a same data file of apple stock market so, I started with another data file but it is also same from apple stock market. I am getting error. which is: "Expected axis has 64 elements and new values have 66 elements". How can I solve that?

[imaansarwar]

How to get data of specific timestamp in one dataframe and another range timestamp in another dataframe and plot a graph for comparison

[balipavankalyan]

I'm getting error like
'DatetimeIndex' object has no attribute 'set_index'