Basic to Advance Python for Data Analysis Part2 (11 hrs)
Data analysis using Pandas in python - Everything you need to know
Basic to Advance Python for Data Analysis Part2 (11 hrs) free download
Data analysis using Pandas in python - Everything you need to know
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
