Basic to Advance Python for Data Analysis Part2 (11 hrs)

Course Curriculum

Chapter 1: Introduction – Pandas library

Lecture 1: Introduction to Pandas library

Lecture 2: Pip Concept

Lecture 3: Read CSV Files

Lecture 4: Read Excel files data

Lecture 5: Excel table headers Customization

Chapter 2: Retrieve/Insert/Rename Columns

Lecture 1: Extract Columns,Head, tail

Lecture 2: Rename Columns and Inplace parameter importance

Lecture 3: Delete Columns from your data -Drop/Del/Pop methods

Lecture 4: Insert a New Column in your data – Insert method and other ways

Lecture 5: Convert Data types using Astype & to_datetime functions- How and Why?

Lecture 6: Reduce data size techniques

Chapter 3: Loops to use in real data

Lecture 1: For Loops in DataFrame

Lecture 2: Range Loops with series and dataframe concepts

Chapter 4: How to LookUp Fields in Data

Lecture 1: Concatenate function – Combine the Data from multiple sources

Lecture 2: Show every column Header in Pycharm – for too many Columns

Lecture 3: Project – Append data from every excel sheet

Lecture 4: Project for you- Append one data into other but with a condition

Lecture 5: Project continues -Now Get excel sheet names automatically

Lecture 6: How to lookup data – Merge function

Lecture 7: Project for you – Create a single lookup column after output is extracted

Lecture 8: Lookup on Two Columns combination -Explore more Merge function

Lecture 9: Merge – Left index and Right index and what is a Set Index

Chapter 5: Filter/ Vlookup/Remove and Extract Rows & Columns of your Data

Lecture 1: How to Filter a data

Lecture 2: Filter using between and isin methods

Lecture 3: How to solve the dates Filtering – Project for you

Lecture 4: Get rows – loc and iloc methods

Lecture 5: How to Lookup data from one table to another – Awesome project

Lecture 6: Remove or Drop Rows and Columns

Lecture 7: How to remove rows and columns using Drop method

Lecture 8: Get duplicates & Remove duplicates -drop duplicate & duplicated methods

Lecture 9: Surprise Test for you – Let us see how much you have learnt

Lecture 10: Remove or drop Nan values from data – Dropna

Chapter 6: Change Values with Groupby and basic functions like sum count unique etc

Lecture 1: How to change values inside a data

Lecture 2: Basic functions -Sum Count, Unique,nlargest, n smallest & Value Count

Lecture 3: Group by – Powerful and useful to generate reports

Lecture 4: Loops in Groupby – more study on it

Lecture 5: My other Courses details