Schedule and Automate Your Excel Data Analytics with Python

Подписаться 19 тыс.

Просмотров 32 тыс.

50% 1

In this video I’m going to show you how to schedule your excel automations to certain days, times and also automate data capture, folder management and more in this light weight utility.
I've also made a small utility that anybody can use. github.com/sat...
Join my mailing list at www.satssehgal.com
Netfirms (Affiliate) - bit.ly/2KdJ4Dp
👉 Patreon: patreon.com/SATSifaction
👉 Facebook Group: / theaiwarriors
👉 Instagram: @theaiwarriors
👉 Corporate Training and Up skilling: levers.ai
Bluehost (Affiliate) - bit.ly/2GxxBh1
PythonAnywhere (Affiliate) - bit.ly/2kWORVe
Heroku - www.heroku.co
NordVPN 👉 bit.ly/2W87je0
✅ Here is a link to my python for beginners, master python course: bit.ly/2HIZS42
What Does a Data Science Executive Carry Around in 2019?
Bag - ebay.to/2lKEDXT
Laptop - 2018 MacBook Pro with Touch Bar
Tablet - 2017 9.7” iPad or
Tablet - Amazon Fire HD 10 - amzn.to/2HjeLec
Folding Keyboard - ebay.to/2k6F4vr
Power Bank - ebay.to/2lKFJ5X
Bose QC35 - ebay.to/2kpfthz
Home Setup for more intense analysis and editing:
AMD MSI Vega 56 Graphics Card - amzn.to/2HkiJU1
Razor X Core egpu with thunderbolt 3 - amzn.to/2Hix579
Two LG 29” Ultrawide Monitors - amzn.to/2YtZfSi
Other options to run Python on a budget
Raspberry Pi Starters kit - ebay.to/2kbvOpW
Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)
Minimalist Keyboard and Mouse - ebay.to/2k6F4vr
Favourite Mobile Apps to Run Python and Code
iOS - Pythonista (paid) - apple.co/2HjRVTJ
Android - Dcoder (free) - bit.ly/2Vrjb6N

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 47

@waynenewcomb1283 4 года назад

Do you have a tutorial that would show the same concept but for scheduling VBA/macros to run with certain workbooks?

@shawnjones163 4 года назад

Hi, I tired this on my own and it only seems to work if there is ONLY one file in the drop folder. If there are multiple files in the drop folder then the drop_path creates a string that is not valid for pd.read_excel. Any ideas? Am I missing something?

@anumathew_bigdream_canvas 4 года назад

Wonderful tutorial,Thanks. I have a question, I have doing vba automation for a couple of months. Whatever I am automating, the end user doesn't have to know the Macro or VBA. We just do the coding and set a button or shortcut key to run the specific VBA code. But here in python how do I make such a set up that my user doesn't have to bother about python or what ever technology running behind the scene. I mean just a click and use it.

@SATSifaction 4 года назад

Yes you can actually run python scripts with a vba macro. So essentially you button once pressed will execute the python script in the background. I may do a video to show that to you guys.

@ibrahimezz4317 4 года назад

SATSifaction pleas e we need a vba link to our python codes its gonna be amazing

@rileyclements5139 3 года назад

you know when that soft music plays in the background this tutorial about to be fire

@kinioskowalski5217 3 года назад

Hey, add automatic refresh in excel to that using python....

@SATSifaction 3 года назад

Will try

@sayyadsalman9132 4 года назад

Bro, you are just an amazing guy! Love you sooooo much. Please keep posting more videos like this one.

@joyceonyeri4678 3 года назад

Thank you. You are a life saver

@YuyinSports 3 года назад

This is awesome! I'm just not sure on how to have a script that is scheduled like this running, (lol I would keep my laptop turned on 24/7)

@SATSifaction 3 года назад

Not at all. You can get a light weight device like a raspberry pi and leave it running locally or put it on a server like digital ocean to run it for you

@JoseLopez-vr5wt 4 года назад

Have you think about create a full course with automate reports getting data from SQL, process in Python and get an output in Excel? that will be really awesome!!

@SATSifaction 4 года назад

haven't but i can put it on my list.

@JoseLopez-vr5wt 4 года назад

@@SATSifaction I think there are a huge amount of Finance Analyst that will something like that, I'm the first one to take the course.

@AlexMar-r 4 года назад

Let's say I'm a finance director , how useful is data analyst is to me ? Would I need one everyday on my team ?

@SATSifaction 4 года назад

That depends on what you’re doing. I would say finance departments are less used to leveraging automation and more engrained in the excel world. Technically, you can automate a large chunk of their work in which case you may not need them daily. Depends on the ask

@vrino223 4 года назад

Thank you kindly...appreciate your hard work in putting this material out to youtubers!

@heriethalexander5145 10 месяцев назад

Thank you so much. Finished learning excel, now onto python

@pontz5978 3 года назад

like this, short, clear and concise explanation.

@SATSifaction 3 года назад

Thanks!

@rulesyou4902 4 года назад

Thank you. Great tutorial. Work with Pandas version 1.0 but seems to have error running on Pandas 1.1.3

@brydenbarbee4528 4 года назад

I am a major noobie. To execute this would I just copy the .py utility file into the directory with the drop folder, processed folder, etc. I'm not sure how to execute the code.

@sa2144 3 года назад

Can we automatically load In SQL server

@gopi5734 3 года назад

Bro u did a great job and I respect for your work

@SATSifaction 3 года назад

Thank you

@kdausu90 3 года назад

Nice work! very helpful

@SATSifaction 3 года назад

You’re welcome

@immanuelsuleiman7550 3 года назад

Does the python file continuously run on a server

@luisilabaca5356 3 года назад

ty soo much for this!!

@SATSifaction 3 года назад

You are most welcome

@tpz1474 4 года назад

So this Python script will be running in the background whenever the computer is left on? Could you have a tutorial on which we could incorporate PythonAnywhere (or others) to have these tasks run even if the device is off? Thanks!

@SATSifaction 4 года назад

Yes of course. It’s on my release list already

@mouabr7239 4 года назад

can you do a tutorial refreshing pivot tables automatically? im trying to find scripts or a video and i cant find one... please... i would appreciate it

@SATSifaction 4 года назад

Sure I’ll put it on my list