Schedule and Automate Your Excel Data Analytics with Python

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.

👉 Instagram: @theaiwarriors

What Does a Data Science Executive Carry Around in 2019?

Laptop - 2018 MacBook Pro with Touch Bar
Tablet - 2017 9.7” iPad or

Home Setup for more intense analysis and editing:

Other options to run Python on a budget

Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)

Favourite Mobile Apps to Run Python and Code

[rileyclements]

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

[pontz]

like this, short, clear and concise explanation.

[heriethalexander]

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

[sayyadsalman]

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

[vrino]

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

[gopi]

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

[waynenewcomb]

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

[JoseLopez-vrwt]

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!!

[shawnjones]

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?

[rulesyou]

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

[robmonkriedlinger]

Thank you so much for sharing this - massively exciting learning experience and really helpful!!

[YuyinSports]

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)

[kinioskowalski]

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

[AlexMar-r]

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

[sa]

Can we automatically load In SQL server

[brydenbarbee]

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.

[immanuelsuleiman]

Does the python file continuously run on a server

[anumathew_bigdream_canvas]

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.

[mouabr]

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

[tpz]

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!