Скачать с ютуб Automate SAP Spreadsheets Export with Python and Analysis with Pandas in a single Python script в хорошем качестве

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

Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity! https://joelting.com/sap-ebook 📚 RESOURCES IN THIS VIDEO: Python Script Template: https://drive.google.com/drive/folder... Anaconda Download Link: https://www.anaconda.com/ 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 - https://amzn.to/3nZrn1I ✈️ My Travel Companion, Macbook Air M1 - https://amzn.to/43jLLuE 📷 My Camera Gear, Sony ZV-E10 - https://amzn.to/40T7uIj 🤝 BE MY FRIEND: 🐦 Twitter -   / joelting92   🏢 Linkedin -   / joel-ting   🙎🏻‍♂️ 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 [email protected] would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.