ScaDS.AI - Center for scalable data analytics and artificial intelligence

The focus of the training will be on teaching basic skills in using the Pandas library on a continuous business data example.

Details

Title: Data Analysis – Pandas vs. Excel
Next Session: New dates will be announced soon.
Target group: Python beginners with Pandas
Language: German
Format: Tutorial, hybrid

Agenda

Introduction to Data Analysis (10%)
Participants will work through the basic language elements of the Pandas library (Dictionary, Series, Dataframe, etc.) with Jupyter Notebook (Python tool for data processing), (share 30%).
Data example Excel (share 10%): the trainer shows selected research methods with Excel (descriptive statistics, matrix formula, pivot table) on the sales data of an example web store
Data example Pandas (share 30%): The participants work out practically the data investigation shown with Excel now under guidance with Python and Pandas functions with a Jupyter notebook.
Outlook Pandas for advanced users, the trainer shows selected methods (share 10%)
Summary and discussion (share 10%)

Handouts

The following documents (slides, sample applications) will be provided to the participants:

PDF for “Introduction Data Analysis”
CSV file (business data)
Jupyter notebook for working with Pandas

Prerequisites

Basic knowledge of Python 3.x (not mandatory)
This is a beginner training! Previous knowledge is not mandatory!

Learning Outcomes

After the training, participants will not only know the theoretical and practical language concepts of Python and Pandas selected by the trainees, but they will also be able to compare them with equivalent functions in Excel.