Schedule and Automate Your Excel Data Analytics with Python

    24
    29



    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

    Previous articleday in the life working as a Business Analyst | my business analysis workflow
    Next articleAWS Lambda Python Up and Running with Boto3

    29 COMMENTS

    1. 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.

    2. 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?

    3. 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

    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.