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

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

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.