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

Basic to Advance Python for Data Analysis Part2 (11 hrs), available at $59.99, has an average rating of 4.83, with 37 lectures, based on 3 reviews, and has 47 subscribers.

You will learn about You shall learn how to use Pandas library in python using pycharm IDLE to do data analysis Using the excel sheets and text files or CSV files You shall learn functions like insert, merge, conctx to lookup the inforamtion like a vlookup in excel does How to insert new data, append the data, do the updates, do the changes in your data etc How to filter the data, use the loops in your data, use the previously learnt lists and dictionaries on real time data Practical projects also shared for you to monitor your progress This course is ideal for individuals who are Python developers, excel data analysts, those who work on data day and night and look for creating automation in reports It is particularly useful for Python developers, excel data analysts, those who work on data day and night and look for creating automation in reports.

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

Summary

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

Price: $59.99

Average Rating: 4.83

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

You shall learn how to use Pandas library in python using pycharm IDLE to do data analysis

Using the excel sheets and text files or CSV files

You shall learn functions like insert, merge, conctx to lookup the inforamtion like a vlookup in excel does

How to insert new data, append the data, do the updates, do the changes in your data etc

How to filter the data, use the loops in your data, use the previously learnt lists and dictionaries on real time data

Practical projects also shared for you to monitor your progress

Who Should Attend

Python developers, excel data analysts, those who work on data day and night and look for creating automation in reports

Target Audiences

Python developers, excel data analysts, those who work on data day and night and look for creating automation in reports

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

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

Instructors

ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 1 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!