dots bg

Powerful Pandas

Learn Effective Data Analytics with Pandas Package

₹499.00

dots bg

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

Powerful Pandas

112 Learning Materials

Introduction

Course Introduction

Video
00:05:23

Series

Video
00:07:21

DataFrame using List

Video
00:04:45

DataFrame using Tuple

Video
00:01:52

DataFrame using Dictionary

Video
00:04:47

Paths

Absolute Path

Video
00:05:12

Relative Path

Video
00:02:23

Relative Path One Level Up

Video
00:02:48

Relative Path - Two Level Up

Video
00:01:53

Relatie Path - Sub Directory

Video
00:01:30

Read Data

From Clipboard

Video
00:01:01

From Comma Seperated Values (CSV File)

Video
00:03:31

From Colon Seperated Values (CSV File)

Video
00:03:40

From Excel File

Video
00:08:11

From JSON File

Video
00:01:43

From Pickle File

Video
00:01:31

Write Data

To CSV File

Video
00:06:48

To Excel File

Video
00:04:37

To JSON File

Video
00:03:30

To Pickle File

Video
00:04:52

Access Data

Access Column

Video
00:07:30

Access Columns

Video
00:04:48

Attributes

Row Index and Column Names

Video
00:03:09

Data Type

Video
00:02:44

Information

Video
00:02:31

Values

Video
00:01:27

Axes

Video
00:02:28

Dimensions

Video
00:00:56

Size

Video
00:01:32

Shape

Video
00:01:25

Memory Usage

Video
00:02:27

Type Conversion | Casting

Type Conversion | Casting

Video
00:14:57

Copy Vs Reference

Copy DataFrame

Video
00:02:17

Refer DataFrame

Video
00:01:51

Indexing

Set Index

Video
00:02:16

Reindexing Rows

Video
00:04:59

Reindexing Columns

Video
00:03:13

Reset Index

Video
00:01:41

Iteration

Iterating Items

Video
00:07:20

Iterating Rows

Video
00:04:38

Itertuples

Video
00:02:16

Handling Cell Values

Using At Method

Video
00:03:26

Using Index At (iat) Method

Video
00:02:41

Using Location Method

Video
00:01:49

Using Index Location Method

Video
00:01:37

Using Combinations

Video
00:04:32

Handling Row Values

Get and Set Row Values

Video
00:03:13

Get and Set Range of Row Values

Video
00:03:57

Get and Set Intermittent Row Values

Video
00:03:10

Handling Column Values

Get and Set Column Values

Video
00:03:48

Get and Set Continuous Range of Column Values

Video
00:05:23

Get and Set Intermittent Range of Column Values

Video
00:04:43

Get and Set combinations of Rows & Column Values

Video
00:04:03

Adding Prefix and Suffix to the Column Names

Video
00:02:28

Get Row Index of Minimum or Maximum Value in a Column

Video
00:03:34

Keep or Remove Values

Drop Rows

Video
00:02:25

Drop Columns

Video
00:01:52

Pop Column

Video
00:03:07

Truncate range of rows

Video
00:01:54

Keep range of Columns with Sort Index

Video
00:02:14

Filtering Data

Filtering Rows Based on a Condition

Video
00:05:18

Filtering Rows Based on Index

Video
00:01:15

Filtering Columns By Name

Video
00:01:03

Filter Rows By Like Values

Video
00:05:02

Filter Rows by Range of Values using Between Function

Video
00:01:17

Filtering Rows By Date Values

Video
00:05:32

Filter Rows By Time Values

Video
00:02:43

Filter Rows By List of Values

Video
00:01:49

Logical Operations

Logical AND

Video
00:04:48

Logical OR

Video
00:02:32

Logical NOT

Video
00:01:15

Logical Operations in Combinations - Pitfall and solution

Video
00:07:08

Sorting Data

Sorting Rows By Single Column

Video
00:03:08

Sorting Rows By Multiple Columns

Video
00:03:02

Prioritizing Null Values while Sorting

Video
00:01:48

Math Operations

Arithmetic Operations

Video
00:09:01

Matrix Multiplication

Video
00:02:12

Evalute Method

Video
00:02:49

Functions

Applying custom functions on Series

Video
00:02:56

Applying Custom Functions on DataFrame

Video
00:04:31

Assign Functions on DataFrame

Video
00:06:18

Aggregate Functions on Series

Video
00:05:48

Aggregate Function on DataFrame

Video
00:01:51

Group By Function

Video
00:09:30

Transform Function

Video
00:05:18

Map Functions

Video
00:02:56

Lambda Function

Video
00:01:58

Pipe Function

Video
00:04:01

Align DataFrame

Align DataFrame with Left Join

Video
00:04:52

Align DataFrame with Right Join

Video
00:02:37

Align DataFrame with Inner Join

Video
00:01:48

Align DataFrame with Outer Join

Video
00:02:15

Concate & Join DataFrame

Concate DataFrame with Same Column Names

Video
00:01:43

Concate DataFrame with Various Column Names

Video
00:01:35

Joining DataFrame with Various Column Names

Video
00:01:07

Joining DataFrame with Same Column Names

Video
00:02:22

Merge DataFrame

Merge DataFrame with Left Join

Video
00:06:26

Merge DataFrame with Right Join

Video
00:03:54

Merge DataFrame with Inner Join

Video
00:01:56

Merge DataFrame with Outer Join

Video
00:01:56

Descriptive Analysis

Uniqueness

Video
00:04:36

Duplicates

Video
00:04:54

Central Tendency

Video
00:06:16

Statistical Analysis

Video
00:07:56

Ranking

Video
00:08:59

Relationship Analysis

Video
00:08:22

Trend Analysis - Difference & Percentage Change

Video
00:02:15

Cumulative Operations

Video
00:03:19

Sampling

Undersampling

Video
00:02:17

Oversampling

Video
00:05:04

Missing Value Handling

Find Missing Values

Video
00:02:51

Handle Missing Values

Video
00:03:14

Course Instructor