Python Basic to Advance for Data Analysis Part2 (Pandas)
Python Basic to Advance for Data Analysis Part2 (Pandas)
For Data Analysis/Reporting using Pandas
Created by Ajay Parmar
Course Description
- This is Part2 and now after learning python core concepts in pycharm,we are heading towards using the excel and csv files data and using pandas library we will learn how to work with real data.
- What is a panada library and how to use it for data analysis.
- Pip – What is it and what is its role
- How to import excel and csv files or text file data and work on it from different locations.
- How to read the data from files especially if its excel. Read any data from any specific excel sheets
- How to do changes in the data headers
- How to extract top or bottom data
- Learn about inplace parameter
- How to insert columns and rename existing columns
- How to remove the blanks or rows /columns from your data
- How to filter the data rows and columns
- How to use set index and how it changes the concept
- How to use loc and iloc methods to pull the no of rows and columns
- How to apply Vlookup in your data using Merge function
- How to join multiple data from excel sheets using Conct function
- How to find out the duplicate rows or remove the duplicate rows based on different criterias
- How to use for loops in your data
- Many practical projects for you with solutions
- How to do data conversions
- How to use Group by
- How to create Pivot reports
Course Curriculum
Pandas Begins
-
Introduction to Pandas library
07:30 -
Pip Concept
14:10 -
Read CSV Files
10:55 -
Read Excel files data
06:27 -
Excel table headers Customization
06:40 -
Extract Columns,Head, tail
12:10 -
Rename Columns and Inplace parameter importance
13:53 -
Delete Columns from your data -Drop/Del/Pop methods
09:52 -
Insert a New Column in your data – Insert method and other ways
19:43 -
Convert Data types using Astype & to_datetime functions- How and Why?
24:09 -
Reduce data size techniques
08:40 -
For Loops in DataFrame
10:36 -
Range Loops with series and dataframe concepts
25:04 -
Concatenate function – Combine the Data from multiple sources
36:44 -
How to see all table headers in pycharm ,if too many
05:15 -
Project – Append data from every excel sheet
12:00 -
Project for you- Append one data into other but with a condition
27:00 -
Project continues -Now Get excel sheet names automatically
05:10 -
How to lookup data – Merge function
19:56 -
Project for you – Create a single lookup column after output is extracted
10:36 -
Lookup on Two Columns combination -Explore more Merge function
06:23 -
Merge – Left index and Right index and what is a Set Index
10:14 -
How to Filter a data
10:34 -
Filter using between and isin methods
04:30 -
How to solve the dates Filtering – Project for you
05:09 -
Get rows – loc and iloc methods
37:07 -
How to Lookup data from one table to another – Awesome project
29:57 -
Remove or Drop Rows and Columns
33:21 -
How to remove rows and columns using Drop method
19:59 -
Get duplicates & Remove duplicates -drop duplicate & duplicated methods
26:52 -
Surprise Test for you – Let us see how much you have learnt
25:11 -
Remove or drop Nan values from data – Dropna
37:19 -
How to change values
17:10 -
Basic functions – sum, count, unique,nlargest,valuecount,nsmalles
28:16 -
Group by – Data summarization
47:25 -
Loops in Group by
18:00 -
Pivots
17:06 -
Pivot Project-Create a new column Zone Contribution
25:19 -
Calculate each Zone Contribution – Next level
21:32
Python Basic to Advance for Data Analysis Part2 (Pandas)
Course Description
- This is Part2 and now after learning python core concepts in pycharm,we are heading towards using the excel and csv files data and using pandas library we will learn how to work with real data.
- What is a panada library and how to use it for data analysis.
- Pip – What is it and what is its role
- How to import excel and csv files or text file data and work on it from different locations.
- How to read the data from files especially if its excel. Read any data from any specific excel sheets
- How to do changes in the data headers
- How to extract top or bottom data
- Learn about inplace parameter
- How to insert columns and rename existing columns
- How to remove the blanks or rows /columns from your data
- How to filter the data rows and columns
- How to use set index and how it changes the concept
- How to use loc and iloc methods to pull the no of rows and columns
- How to apply Vlookup in your data using Merge function
- How to join multiple data from excel sheets using Conct function
- How to find out the duplicate rows or remove the duplicate rows based on different criterias
- How to use for loops in your data
- Many practical projects for you with solutions
- How to do data conversions
- How to use Group by
- How to create Pivot reports
Course Curriculum
Pandas Begins
-
Introduction to Pandas library
07:30 -
Pip Concept
14:10 -
Read CSV Files
10:55 -
Read Excel files data
06:27 -
Excel table headers Customization
06:40 -
Extract Columns,Head, tail
12:10 -
Rename Columns and Inplace parameter importance
13:53 -
Delete Columns from your data -Drop/Del/Pop methods
09:52 -
Insert a New Column in your data – Insert method and other ways
19:43 -
Convert Data types using Astype & to_datetime functions- How and Why?
24:09 -
Reduce data size techniques
08:40 -
For Loops in DataFrame
10:36 -
Range Loops with series and dataframe concepts
25:04 -
Concatenate function – Combine the Data from multiple sources
36:44 -
How to see all table headers in pycharm ,if too many
05:15 -
Project – Append data from every excel sheet
12:00 -
Project for you- Append one data into other but with a condition
27:00 -
Project continues -Now Get excel sheet names automatically
05:10 -
How to lookup data – Merge function
19:56 -
Project for you – Create a single lookup column after output is extracted
10:36 -
Lookup on Two Columns combination -Explore more Merge function
06:23 -
Merge – Left index and Right index and what is a Set Index
10:14 -
How to Filter a data
10:34 -
Filter using between and isin methods
04:30 -
How to solve the dates Filtering – Project for you
05:09 -
Get rows – loc and iloc methods
37:07 -
How to Lookup data from one table to another – Awesome project
29:57 -
Remove or Drop Rows and Columns
33:21 -
How to remove rows and columns using Drop method
19:59 -
Get duplicates & Remove duplicates -drop duplicate & duplicated methods
26:52 -
Surprise Test for you – Let us see how much you have learnt
25:11 -
Remove or drop Nan values from data – Dropna
37:19 -
How to change values
17:10 -
Basic functions – sum, count, unique,nlargest,valuecount,nsmalles
28:16 -
Group by – Data summarization
47:25 -
Loops in Group by
18:00 -
Pivots
17:06 -
Pivot Project-Create a new column Zone Contribution
25:19 -
Calculate each Zone Contribution – Next level
21:32