Moving Average (Rolling Average) in Pandas and Python - Set Window Size, Change Center of Data

Learn how to create a simple moving average (rolling average) in Pandas with Python! You'll learn how to change your window size, set minimum number of records, and center your moving average.
0:00 Introduction
0:20 What is a moving average?
0:30 Loading Libraries and dataset
1:03 Exploring and Visualizing the data
1:58 Pandas Rolling Function
2:50 Pandas Rolling Function Window Argument
5:10 Pandas Rolling Function Center Argument
6:40 Pandas Rolling Function Min_periods Argument
9:02 Conclusion
Learn Python programming the right way!
----------------------------------------------------------
✅ Check out my eBook to get started with Python for Data Science: gumroad.com/l/introtopythonfo...
✅ Follow me on other platforms:
Website: datagy.io
Twitter: / datagyio
Mailing List: mailchi.mp/f6a58f2d73d0/datag... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)

[@claudio1417]

Hi Nick, I'm from Brazil and I'm following you, you can explain like no one else. Very cool your techniques and methods. Top. Congratulations.

[@datagy]

Thanks Claudio! That made my day 😊

[@reiskleiton]

Hi Nick. Thank you very much for you explanation. It did help me to understand more about moving average. Keep up the good work.

[@datagy]

Thanks so much Kleiton!

[@mogith9648]

you're a lifesaver Nick. Keep going !

[@datagy]

Thanks so much, Mogith!

[@nadavnesher8641]

Hi Nick. Great video, great explanation!! Thanks :)

[@datagy]

Thanks Nadav! I'm glad it was helpful!

[@haxmal9065]

dude thank you so much!

[@datagy]

I’m glad it was helpful!

[@pjakobsen]

Excellent video, super clear

[@datagy]

Thank you so much!

[@Earths_Accountant]

Thanks for the video!!

[@datagy]

I’m glad you liked it!

[@vijaykumarahamadabade9563]

your videos are very informative and easily explained. Just a request, please keep adding the dataframe generating codes in the description to follow along with you. Thank you :)

[@datagy]

Thanks so much!

[@mays7n]

thank you, very good video :)

[@datagy]

Thank you!

[@nakshatragarg]

Thanks for an amazing explanation

[@datagy]

Thanks so much!

[@tuandino6990]

clear explanation

[@datagy]

Thanks!

[@user-wc7em8kf9d]

Thank you!

[@datagy]

You’re welcome! I hope it was helpful!

[@RNSS0]

thank you, you helped me a lot

[@datagy]

Thank you for your comment! I really appreciate it.

[@tomaspapantos1071]

👏👏

[@karanpk1651]

Very much useful. Thank you Bro... ❤️.

[@datagy]

Thanks Karan!

[@user-to8jk4gv5i]

hello, can we use timeperiods as a window?For example the average value of price per hour?

[@AK-ss2de]

Good morning, Please, could you tell me how can I use the rolling regression with a granger causality test ? And to do this granger causality month by month? Thanks in advance :)

[@sekiro_19]

thank you for your help

[@datagy]

Thanks Sekiro!

[@swarnachoppella388]

Thank you

[@datagy]

Thanks for your comment!

[@uploadvoice]

Very good video.

[@datagy]

Thanks so much! I’m glad you liked it!

[@shannatheragamuffin..743]

What would be the matlab equivalent of "movmean(x,3)" in python?

[@kamaleshbarai2759]

Nice explanation bro

[@datagy]

Thanks Kamalesh!

[@LucaSpinello]

Thank you! If I wanted to do a rolling but exclude the most recent value from the calculation how would I do? Apply a shift to the data frame and then rolling? Thank you

[@datagy]

Thanks for your comment, Luca! Exactly! You could slice the dataframe you're creating the rolling average first. If your most recent value is either the first or last value, I'd recommend using iloc. I've covered that here: kzbin.info/www/bejne/jHrEYniKjtN5q8U Let me know if you have any questions!

[@LucaSpinello]

@@datagy Thank you for the quick response and the content, I find it really helpful! Back to the original question, I think if I use iloc I would need a for loop, while the rolling function would to it automatically, so if I want a rolling mean of the 5 previous elements for example (not considering the current value) I would do something like df.shift(1).rolling(5).mean() I think... is there a video coming up about shift?

[@datagy]

@@LucaSpinello Hi Luca! Sorry, perhaps I misunderstood your original question. Are you looking to just drop the most recent value from your entire dataframe?

[@LucaSpinello]

datagy, drop the most recent value only for the purpose of the mean calculation

[@datagy]

@@LucaSpinello In that case, I'd drop the first (or last) rolling average calculation in your dataframe. In that case, I'd recommend iloc to set the value to missing. As your most recent value will sit at either the front or end, it will only be included in a single rolling calculation. It'll accomplish what you're hoping to do with pd.shift, but without as much work.

[@RenanBrito000]

how can i change the size of graph?

[@datagy]

Hi Renan, You can use df.plot(figsize=(3,3)) Hope this helps!

[@RenanBrito000]

@@datagy thanks

[@jazzbezz9394]

How to determine the window size as 5?

[@datagy]

Hi Jazz, You can use .rolling(5) or .rolling(window=5) Hope this helps!

[@meghanachippada8051]

Hello! Can u please help in our code which is completely based on rolling average

[@meghanachippada8051]

And thankyou Nick ! For this video

[@datagy]

Hey Meghana, thanks for your comment! What part of your code is causing you trouble?

[@vactum0]

code link?