Automate SAP Spreadsheets Export with Python and Analysis with Pandas in a single Python script

📚 RESOURCES IN THIS VIDEO: Python Script Template: Anaconda Download Link: Most of us analyst understand how powerful Python is when it comes to automation, data analysis and data visualization. I have always been wanting to work on some way to automate the data pipeline in python so that I can leverage the powerful open source python libraries available. I just recently found out about developing SAP GUI Script in Python and can just feed into Pandas dataframe to do further analysis. In this video, I’ll break down exactly how I use Python to automate the process of extracting data from SAP and feed the export into pandas for data analysis. Timestamps 00:00 Introduction 01:00 SAP GUI Scripting Basics & Recording Tool 02:43 Introduction to Anaconda, Python and Jupyter Notebook 03:18 My Typical Workflow for Data Extraction & Analysis from SAP 04:10 Differentiating Methods & Attributes in Python 04:48 Changing VB Script syntax into Python syntax 05:25 Making the script dynamic & accepting user inputs 07:12 Feeding data exported into Pandas dataframe for Analysis 08:43 Completed flow test run & demo #PythonSAPAutomation #SAPDataAnalysis #GUIScriptingwithPython MY FAVOURITE GEAR 💻 My Personal Laptop, Legion 5 Pro - ✈️ My Travel Companion, Macbook Air M1 - 📷 My Camera Gear, Sony ZV-E10 - 🤝 BE MY FRIEND: 🐦 Twitter - 🏢 Linkedin - 🙎🏻‍♂️ WHO AM I: I’m Joel, an analyst working in Singapore. I make videos about technology, automation and productivity. 📧 GET IN TOUCH: If you’d like to talk, I would love to hear from you. Email me directly at joelting92@ would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.