sales forecasting with Prophet (data science deep-dive project part 1)

[@highinstitute2366]

best video i see for prophet, thanks

[@lilcameauxx]

Having started my degree in astrophysics and then deciding about halfway through i wanted to do data science, your channel has been a gold mine! I graduate next spring with my degree in Data Science. You have been a large part of my learning and i thank you!!

[@TheAlmostAstrophysicist]

So glad I can be a part of your journey! Sounds so similar to mine haha

[@evedickson2496]

Fantastic video.. exactly what I've been looking for.. Will be in corporating this into or forecasting workflow.. thank you 😊.. subscribed and will be watching the full 30 days 😊

[@donndonnn]

You stopped uploading??? Nooooo

[@isaiahindigenousaboriginal5261]

I know but get hEr ( side note ) she told everyone to pleAse engage. Did everyone obliGe??? When the youth find her it’s a wrap. Ok I will show everyone how exciting she and this channel is. Y’all have no idea how you’re about to love learning again! Let’s gooooOoOo!

[@jpiantoni-5861]

Woow, amazing class, thank you (from Brazil)

[@michaelwallendjack911]

As a newbie to FB prophet these 2 tutorials rock! Very easy to follow along and digest. Are you planning on releasing the 3rd part of the series any time soon? Excited to watch!

[@zaccanasta27]

Would you consider this logic valuable also for LTV calculation, where instead of categories (such as automotive, babycare, beauty ...) we have cohort months (such as Jan-23, Feb-23 ...)?

[@HenryTechBoy]

I would like to think so.. Did you end up utilizing Prophet for this use case?

[@ianperkins8812]

For me, your timing is absolutely spot on - I am sitting for Microsoft DP-100 in three weeks and starting a machine learning class the week after that, so THANK YOU! I can't wait for the next installment :)

[@TheAlmostAstrophysicist]

Oh awesome! I'm glad you can follow along with classes! 😀

[@malcomharris6642]

I majored in Mathematical Economics in undergrad and graduated in fall of 2020. I'm currently going to grad school for Data Science in healthcare analytics. This channel really helps!!

[@TheAlmostAstrophysicist]

That's awesome - good luck on your journey and glad the channel can be a part of it!

[@makalamabotja4773]

HI Priya, I love the video series idea. I'm currently in sales and looking to propose a sales forecasting pipeline at work as an audition to transition to a full time position. I love the video and still trying to get head around the coding itself. Keep up the good work and I look forward to more in your series

[@makalamabotja4773]

I have a question related to this video series and perhaps a request. As mentioned, I'm trying to make a forecasting proposal for my workplace and would like to cover all the basis that would be applicable from a data science perspective I built an RFM and CLTV customer segmentation Kmeans model based off e-commerce data from Kaggle and wanted to use these clustering to make forecasting prediction based off leads received and classified into the identified clusters. I will be forecasting total sales for the month using regression and wanted to know if this is something you would be doing on a day to day as a data scientist in a sales environment or am I missing a step?

[@edgarromeroherrera2886]

Thank you so much for this amazing video, it's so pretty useful. Not enought words to thank you

[@AlanGaugler]

An excellent introduction to time-series forecasting and FB prophet, very well explained and well writen code. I will be watching many more of your videos :)

[@franciscotrejo8168]

This is great! Just started the video, cool to see another time series forecasting model. I have primarily used the Nixtla forecasting libraries like Neuralforecast and Statsforecast. Excited to see another approach! Keep up the good work!

[@franciscotrejo8168]

Just finished the video - great work! I really enjoyed how you walked through all the aspects of the code and even re-ran some cells to really help explain what is going on. Excited to see the rest of this series, keep it up!

[@TheAlmostAstrophysicist]

Thanks for watching! That’s awesome, I’ll have to check those libraries out! I’ve primarily used Prophet because it felt so easy to use and also explain to stakeholders haha. Appreciate you keeping up with the series!

[@vinayakjadhav5553]

first of all thank u for giving the information of data science and take out us to the real world data science word course

[@MQ2011de]

USE df_cv = cross_validation(m, initial='365 days', period='30 days', horizon = '30 days', parallel='threads') INSTEAD OF df_cv = cross_validation(m, initial='365 days', period='30 days', horizon = '30 days', parallel='processes') IF YOU HAVE A OLD COMPUTER.

[@andyberrios5572]

Middle of doing my Stats 5301 hw.. can’t wait to finish up and get into this vid!

[@TheAlmostAstrophysicist]

Means a lot that you're following along, thank you!! Hope this helps 😀

[@ArmPowerWorkouts]

Fantastic density of the content.

[@DEDE-ix9lg]

this series will be FIRE 🔥🔥🔥

[@TheAlmostAstrophysicist]

Appreciate it!!!

[@billylee5624]

An astrophysicist into data science? Well it does seem like a natural transitition, you can use pdes or matrix algebra you've learnt from physics for data science.

[@miguelgaribay325]

Your videos have made me seriously look into Graduate programs in Data Science. Thank you!

[@TharushaBandaranayake]

Is there a way to deal with having lots of 0s in the time series? I'm currently working on a procurement forecast model. Therefore there are lots of days where procurement doesn't happen, making the y value 0 for most days. This is really affecting the model performance.

[@FelixMüller-y7m]

Many thanks for the super great video! I would like to know why you have loaded holidays, but they are not (or cannot be) used by Prophet later?

[@statisticallylaura]

The timing on this is absolute gold, this is literally the type of project I'm building as a Django app for my work right now! It's an analytics dashboard to monitor sales activity by channel and since we're dealing with a lot of seasonality there, Prophet seems like a spot-on fit for incorporating forecasts. Thank you for doing this, excited for more of the series!

[@TheAlmostAstrophysicist]

Ahhhh this makes me so happy! Incorporating DS to solve business problems for the win!

[@sai251180]

Thank you for this productive video! Learnt a lot!!

[@TheAlmostAstrophysicist]

Great to hear, thanks for watching!

[@Alice8000]

Great video. Is it ok just to leave some troll comments/questions?

[@Jagerman767]

Waiting the 3rd video about prophet =)

[@observer698]

Why 1-MAPE as the accuracy metric?

[@kevinwillard4443]

Please come back online

[@albertowusu-banie154]

@TheAlmostAstrophysicist - Thanks for this. Currently working on a forecasting model and this video came in right on time. Looking forward to the next videos. I also studied Physics, by the way 😄

[@TheAlmostAstrophysicist]

That’s awesome! Glad the video can help, thanks for following along! also so fun that you did physics too!

[@gehnajain549]

If you're given daily sales data and the agency that makes the order per day, what would you do to predict the sales per agency for a particular day? The data I have contains over 1000 agencies.

[@HenryTechBoy]

what data do you have exactly? Is it: agency | sales So just 2 columns?

[@anthonyshea6048]

Can you please do a video on predicting discrete yes or no events in a time series using only categorical data?? That would be immensely helpful. I’m approaching feature selection with mutual information classification, but I’d like to know how you’d pipeline it!

[@andrewchen2590]

Super excited to start this!

[@TheAlmostAstrophysicist]

Hope you enjoy it!!

[@niallwhelan2648]

Great series, thanks. Just on high volume you refer to largest sales by day, but is transaction volume not more important than total daily sales? High transaction volume will give better signal than low transaction volume.

[@TheAlmostAstrophysicist]

Great question! Absolutely - I think what you define as transaction volume is what I'm referring to when I say total daily sales. i.e. the higher the transactions are daily/the higher the volume, the better signal we get. In the video, I use the "np.mean" function across the columns to see what the average daily sales (i.e. avg. transaction volume) is. In general, the lower the volume, (under $1000 usually) leads to higher errors since it's hard to get signal. So I use >=$1000 as a cut-off. Does this make sense? I think we mean the same thing haha

[@BryanCoronel0303]

this is nicely in-depth, thank you! in terms of scaling, would it be best to run this as a Python script instead of notebook and automate it using something like airflow?

[@TheAlmostAstrophysicist]

Thanks for watching! Absolutely! So you'd want to fully automate it as a pipeline, my second video (coming out Saturday this week) is a second full pipeline notebook and you'd want sometime like that pipeline either automated as a script OR you can use a service like Databricks/something similar to schedule regular notebook runs/jobs. :)

[@TheMiguel710]

I am starting out in DS (around a year into it) and I am really inspired by your content. Never used prophet but will make sure to run your notebook and accompany the series! Just curious, how long does it take you to make something like this notebook? I am struggling to execute faster and was wondering if you have any tips on that? Great content as always!

[@TheAlmostAstrophysicist]

Awesome! To make the notebook, took about I'd say 20-30 minutes since I've worked with prophet before! The hardest part was honestly finding good open source data lol. And the whole notebook takes about 20ish minutes to run if you go through the whole hypertuning cross-validation for every category of products! I have that notebook pipeline for video 2 finished!

[@Ana-to3hi]

Please make more content ❤

[@LACERDAJO]

Hello Priya! I am a new follower of yours here and I new fan as well! Congratulations! This explanation is beautiful!

[@aj-hz2yq]

Thank you for making these

[@andracoisbored]

Looking forward to all your videos!

[@brennobreennomongero2587]

Thank you so much for sharing this knowledge with us for free! The video was amazing!

[@HenryTechBoy]

This is so awesome! Your patience, attention to detail and communication style makes it feel like I am chatting with a colleague across the room to learn more about time-series. I'm now subscribed and will probably go watch all the other videos :)

[@simbarashemutyambizi1360]

Still new to ds, but will your videos. I dont really understand eda, its purpose in the end and how to use your findings in eda for the followng processes in ds cycle. If you could make a video on it, in this series with an simple example case study, I would appreciate it.

[@sevilayozt]

i luv you

[@alazaraddis7237]

me struggling to change my major from IS to CS🤣🤣🤣🤣🤣

[@WhaleJetski]

Been waiting for this series from you! Thank you!!

[@TheAlmostAstrophysicist]

Of course! More to come with the series, thanks for following along! 😀

[@PengWang-p6t]

thank you for sharing. This is very informative!

[@madhavilingutla4031]

Good One!

[@mpfiesty]

This is great content, thank you.

[@ahmedelshaarawy-c6c]

Thank you for this series, when i downloaded the dataset from kaggel it didn't downloaded right

[@TheAlmostAstrophysicist]

Hmm that's weird. I download the "train.csv" from www.kaggle.com/c/favorita-grocery-sales-forecasting and I renamed it on my desktop to "store_data.csv" Maybe that's the issue if you can't read in the data?

[@miguelbohorquezgranados1207]

Quality content as always!

[@TheAlmostAstrophysicist]

thank you!!!

[@krishnarao4840]

Useful information

[@TheAlmostAstrophysicist]

Thanks so much Tata! 😄😄

[@gralleg9634]

Thanks a lot from France 👌

[@danymerizalde1942]

It is an amazing video!

[@herculesgixxer]

You’re amazing

[@Derek-yf6pj]

I just found your channel, loved this video and subscribed. But looks like you stoped making content. Please come back, I like the way you give a background on the items discussed, like the Fourier math etc. 🫶