Pivot Table using Python Part 1 – SKILLEXO by Stat Modeller

Course Content

Welcome to the Course

0/3

Welcome to the Course and Recourses!!!

Welcome note and Faculty Introduction

Introduction to Python

0/9

Career Opportunities as a Python Programmer

Introduction to Python

Various IDEs for Python

Installation of Anaconda Distribution

Tour of Anaconda Interface

Important features of Jupyter

Tour to the Google Colab

How to organize data files

Data Types in Python

0/17

Understanding Data Types Part 1

Understanding Data Types Part 2

Practical on List in Python Part 1

Practical on List in Python Part 2

Numeric Data Types Part 1

Numeric Data Types Part 2

Sequence Data Types – List

Sequence Data Types – String

Use of Brackets in Python

Sequence Data Types – Tuple

Boolean Data Types Part 1

Boolean Data Types Part 2

Dictionary Data Type Part 1

Dictionary Data Type Part 2

Basic Operations

0/2

Arithmetic Operations in Python

Custom Function

0/9

Define Custom Function Part 1

Define Custom Function Part 2

Define Custom Function Part 3

Define Custom Function Part 4

Common Syntax Error

Using Array in Python

Exercise – Create a Hotel Bill Calculator

Use Case of Custom Function

Working Directory

0/2

Package Vs. Module Vs. Function in Python

Setting up working Directory in Python

Data Handling

0/11

Import Data from CSV files

Accessing Specific Columns from the DataFrame

Data Slicing using iloc Function

Import Data from Excel File

Import Data from Website

Data Filtering in Python Part 1

Data Filtering in Python Part 2

Data Filtering in Python Part 3

Dealing with String Data

Find UNIQUE values in Python

Find NULL Value from the DataFrame

Pivot Table in Python

0/2

Pivot Table using Python Part 1

Pivot Table using Python Part 2

Scale of Measurement

0/2

Concept of Scale of Measurement

Scale of Measurement and Statistics

Basic Statistics

0/11

Basic Statistics Part 1

Basic Statistics Part 2

Basic Statistics Part 3

Types of Statistics

Measure of Central Tendency

When to use Mean, Median and Mode

Measure of Dispersion: Range, Variance and Standard Deviation

Importance of Standard Deviation

Concept of CV: Coefficient of Variation

Find Descriptive Statistics using Python

Difference between Percentage and Percentile

Groupby Function in Python

0/1

Find summary using GROUPBY Function

Concept of Looping

0/3

Concept of Looping: For Loop and While Loop

Using While Loop in Python

Concept of Looping

Conditional Statements

0/3

Concept of Conditional Statements: IF, ELSEIF, NESTEDIF

Conditional Statements: IF, ELSEIF, NESTEDIF using Python

Use Case of NESTEDIF in Python

Data Visualization

0/14

Data Visualization Understanding

Charts for Qualitative Data

Charts for Quantitative Data: Histogram and Boxplot

Charts for Quantitative Data: Scatter Plot

Overview of Matplotlib and Setup in Python

Bar Chart in Python

Clustered Bar Chart in Python

Pie Chart in Python

Histogram in Python

Boxplot in Python Part 1

Boxplot in Python Part 2

Scatter Plot in Python

Area Plot in Python

How to Export Analysis

Course Wrap-up

0/2

Participants’ Feedback

Python for Data Analytics

0% Complete