Summarize Your Data with Pivot Tables in Python
- Created By raju2006
- Last Updated December 11th, 2023
- Overview
- Prerequisites
- Audience
- Audience
- Curriculum
Description:
Unlock the Power of Python and Pandas: Develop Pivot Tables and Generate Dynamic Reports in this Class. Learn to Create Python Scripts for Data Aggregation and Reusable Reports from Real-Life Examples.
Course Code/Duration:
BDT166 / 6 hours (Two Sessions, 3-3-hours )
Learning Objectives:
The course includes presentations, demonstrations, and hands-on labs.
- Completion of the “Python for Beginners” class, or equivalent Python experience.
- Analyst, programmer, business user or anyone interested using data analysis with some basic coding
- Analyst, programmer, business user or anyone interested using data analysis with some basic coding
Course Outline:
Module 1: Introduction to Google Cloud Platform
- Introduction to Jupyter Notebook
- Learn the Pandas and Numpy modules to read, prepare, and write datasets
- Introduction to the “pivot_table”, “pivot”, “stacked”, and “unstacked” functions
- Splitting, apply, and grouping datasets
- Grouping datasets by multiple columns
- Aggregate data with different statistical functions such as len, sum, min,max, unique, nunique, etc.
- Aggregate data by multiple columns
- Reseting hierarchical indices and columns
- Build aggregation automation and share results
Training material provided: Yes (Digital format)
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]