Schedule and Automate Your Excel Data Analytics with Python

30 Comments



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. https://github.com/satssehgal/Excel_Data_Analysis_Scheduler

Join my mailing list at www.satssehgal.com

Netfirms (Affiliate) – https://bit.ly/2KdJ4Dp

👉 Patreon: patreon.com/SATSifaction
👉 Facebook Group: http://facebook.com/groups/theaiwarriors
👉 Instagram: @theaiwarriors
👉 Corporate Training and Up skilling: https://levers.ai

Bluehost (Affiliate) – https://bit.ly/2GxxBh1
PythonAnywhere (Affiliate) – https://bit.ly/2kWORVe
Heroku – https://www.heroku.co
NordVPN 👉 https://bit.ly/2W87je0

✅ Here is a link to my python for beginners, master python course: https://bit.ly/2HIZS42

What Does a Data Science Executive Carry Around in 2019?

Bag – https://ebay.to/2lKEDXT
Laptop – 2018 MacBook Pro with Touch Bar
Tablet – 2017 9.7” iPad or
Tablet – Amazon Fire HD 10 – https://amzn.to/2HjeLec
Folding Keyboard – https://ebay.to/2k6F4vr
Power Bank – https://ebay.to/2lKFJ5X
Bose QC35 – https://ebay.to/2kpfthz

Home Setup for more intense analysis and editing:

AMD MSI Vega 56 Graphics Card – https://amzn.to/2HkiJU1
Razor X Core egpu with thunderbolt 3 – https://amzn.to/2Hix579
Two LG 29” Ultrawide Monitors – https://amzn.to/2YtZfSi

Other options to run Python on a budget

Raspberry Pi Starters kit – https://ebay.to/2kbvOpW
Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)
Minimalist Keyboard and Mouse – https://ebay.to/2k6F4vr

Favourite Mobile Apps to Run Python and Code
iOS – Pythonista (paid) – https://apple.co/2HjRVTJ
Android – Dcoder (free) – https://bit.ly/2Vrjb6N

source

30 Comments
    • blank
      Pon tz
      May 12, 2022 14:44 pm Reply

      like this, short, clear and concise explanation.

    • blank
      Kinios Kowalski
      May 12, 2022 14:44 pm Reply

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

    • blank
      Riley Clements
      May 12, 2022 14:44 pm Reply

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

    • blank
      Nor Priest
      May 12, 2022 14:44 pm Reply

      This is great tutorial.
      Could you suggest how to output in dynamic file name like _20180927.xls and so on?
      I'm new at coding but I guess there should be some function added to it to count new day and then rename the file according to what day that is.

    • blank
      Kaden
      May 12, 2022 14:44 pm Reply

      Nice work! very helpful

    • blank
      Luis Ilabaca
      May 12, 2022 14:44 pm Reply

      ty soo much for this!!

    • blank
      Immanuel Suleiman
      May 12, 2022 14:44 pm Reply

      Does the python file continuously run on a server

    • blank
      Joyce Onyeri
      May 12, 2022 14:44 pm Reply

      Thank you. You are a life saver

    • blank
      Yuyin
      May 12, 2022 14:44 pm Reply

      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)

    • blank
      khan saleem
      May 12, 2022 14:44 pm Reply

      Can we automatically load In SQL server

    • blank
      Gopi 573
      May 12, 2022 14:44 pm Reply

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

    • blank
      Rules You
      May 12, 2022 14:44 pm Reply

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

    • blank
      Sayyad Salman
      May 12, 2022 14:44 pm Reply

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

    • blank
      Stephanie Kreutz
      May 12, 2022 14:44 pm Reply

      Sweet! thanks

    • blank
      José López
      May 12, 2022 14:44 pm Reply

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

    • blank
      Xtango
      May 12, 2022 14:44 pm Reply

      Vba can do that too.

    • blank
      Shawn Jones
      May 12, 2022 14:44 pm Reply

      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?

    • blank
      joshi7405
      May 12, 2022 14:44 pm Reply

      Do you have a Python for Beginners class?

    • blank
      Alex Martinez
      May 12, 2022 14:44 pm Reply

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

    • blank
      Wayne Newcomb
      May 12, 2022 14:44 pm Reply

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

    • blank
      Mohamed Abdelsalam
      May 12, 2022 14:44 pm Reply

      Dear Sats, thank you for this fantastic video. I have a small problem while uploading workbook using openpyxl I'm getting this msg:

      /usr/local/lib/python3.6/dist-packages/openpyxl/reader/drawings.py:28: UserWarning: DrawingML support is incomplete and limited to charts and images only. Shapes and drawings will be lost.

      warn("DrawingML support is incomplete and limited to charts and images only. Shapes and drawings will be lost.")

      /usr/local/lib/python3.6/dist-packages/openpyxl/reader/worksheet.py:322: UserWarning: Conditional Formatting extension is not supported and will be removed

      warn(msg)

      —————————————————————————

      ValueError Traceback (most recent call last)

      <ipython-input-2-6ed4f04bb768> in <module>()

      1 workbook_name = 'Consolidated Feb 2020.xlsx'

      —-> 2 wb = load_workbook(workbook_name,data_only=True,keep_links=False)

      4 frames

      /usr/local/lib/python3.6/dist-packages/openpyxl/utils/datetime.py in from_excel(value, offset)

      95 return days_to_time(diff)

      96 if not jumped:

      —> 97 return datetime.datetime(*parts[:3]) + diff

      98 else:

      99 return datetime.datetime(*parts[:3] + [0])

      ValueError: year 32975 is out of range

    • blank
      Bryden Barbee
      May 12, 2022 14:44 pm Reply

      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.

    • blank
      anavrin
      May 12, 2022 14:44 pm Reply

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

    • blank
      Mou Abr
      May 12, 2022 14:44 pm Reply

      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

    • blank
      Eugene Teo
      May 12, 2022 14:44 pm Reply

      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!

    • blank
      Anish Mathew
      May 12, 2022 14:44 pm Reply

      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.

    • blank
      Rob Riedlinger
      May 12, 2022 14:44 pm Reply

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

    • blank
      Beautiful Moon
      May 12, 2022 14:44 pm Reply

      Great job! Please text me ur e-mail I have questions.

    • blank
      Ibn-Nafis
      May 12, 2022 14:44 pm Reply

      Great.

    • blank
      Suneel Reddy
      May 12, 2022 14:44 pm Reply

      Good informative Video Sir.

Leave us a comment