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.
1 view
862
240
5 months ago 00:00:09 1
Manager: How did you solve the bug?Me:
1 year ago 01:02:51 1
HEAVY DUTY EQUIPMENTS. Explore The Incredibly Hypnotic Production Processes All Around Us.
1 year ago 00:10:01 1
Automate SAP Spreadsheets Export with Python and Analysis with Pandas in a single Python script
1 year ago 00:05:25 1
EP.1: What is Warehouse 15? | Cleverence Warehouse 15 Explained
1 year ago 00:01:44 1
SAP tutorial checking receiving with barcodes and Cleverence app
1 year ago 00:02:24 1
Гарри Поттер и оперативно-календарное планирование.
1 year ago 00:02:17 1
Revolutionizing Retail Efficiency: Introducing Cleverence Retail 15 for Streamlined Operations
1 year ago 10:18:07 1
1C-RarusTechDay 2023 — VI открытая техническая конференция для специалистов 1С
3 years ago 00:00:37 1
IT Online Training by H2kinfosys - 100% Job Oriented with Real-time Projects
3 years ago 00:21:59 1
ChefConf 2018 - How SAp Leverages Chef Automation by Juan Carlos Martinez & Martin Schygulla
4 years ago 00:10:36 1
software QA testing certification training | QA Testing Training online | QA Tutorials for Beginners
4 years ago 00:09:09 1
Day 1 - Software Testing Training | QA Training | Software Testing Course | SDLC
8 years ago 00:02:04 3
What Is SAP BusinessObjects Predictive Analytics? Part 2: Automation
9 years ago 00:20:15 5
Test Automation for non-Web or Mobile apps with LeanFT (Alex Kogon, Switzerland)