Data Analysis & Processing with Pandas

Description

In this course, you will learn :

• How to use Pandas to process and analyse data.
• About the fundamental data structures in Pandas: series and dataframes.
• How to perform operations on various data structures, as well as how to optimise performance for file uploads, data filtering, and other tasks.

Syllabus :

1. Introduction

• Fundamental Data Structures in pandas
• Creating a Series Object
• Create a Series From a Numpy ndarray and a Scalar Value
• Manipulating Series Objects
• Creating a DataFrame From Arrays and Lists
• Creating a DataFrame From a Series
• Creating a DataFrame From a File

 

2. Basic Operations on DataFrames

• Indexing and Slicing
• Description
• Concatenation
• Grouping Data
• Deletion in a DataFrame
• Select Data From DataFrame
• Merging in a DataFrame
• Challenge - Group by a Single Column and Analyze
• Challenge Solution Review
• Sorting a DataFrame
• Apply Function to a DataFrame
• Iteration Data in DataFrame

 

3. Other topics

• Deal with Missing Value
• Export Data to File
• Convert DataFrame to a List
• String Type
• Deal With datetime
• Type Conversion
• Rename Columns
• Drop Duplicate Row

 

4. Improve performance

• Speed up File Loading
• Reduce Memory Usage
• Speed up Column Operations
• Optimized Data Filtering

Show more