BiggestSale: 17Courses in 3500Rs (500 Hrs), 10 Courses in 3000Rs

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

Material Includes

  • Supported files are there for you to download

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:31
  • Pip Concept
    14:10
  • Read CSV Files
    10:55
  • Read Excel files data
    06:26
  • Excel table headers Customization
    06:40
  • Extract Columns,Head, tail
    12:11
  • Rename Columns and Inplace parameter importance
    13:54
  • 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:39
  • For Loops in DataFrame
    10:37
  • 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:01
  • Project for you- Append one data into other but with a condition
    27:00
  • Project continues -Now Get excel sheet names automatically
    05:11
  • 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:31
  • How to solve the dates Filtering – Project for you
    05:09
  • Get rows – loc and iloc methods
    37:08
  • 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
899.00
899.00 3,500.00

Python Basic to Advance for Data Analysis Part2 (Pandas)

899.00
899.00 3,500.00

Material Includes

  • Supported files are there for you to download

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:31
  • Pip Concept
    14:10
  • Read CSV Files
    10:55
  • Read Excel files data
    06:26
  • Excel table headers Customization
    06:40
  • Extract Columns,Head, tail
    12:11
  • Rename Columns and Inplace parameter importance
    13:54
  • 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:39
  • For Loops in DataFrame
    10:37
  • 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:01
  • Project for you- Append one data into other but with a condition
    27:00
  • Project continues -Now Get excel sheet names automatically
    05:11
  • 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:31
  • How to solve the dates Filtering – Project for you
    05:09
  • Get rows – loc and iloc methods
    37:08
  • 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