Overview

Embark on a comprehensive 5-hour tutorial series covering Python Pandas for data analysis. Learn essential operations such as importing CSV, Excel, HTML, and JSON data, generating data frame summaries, sorting, filtering, and manipulating data frames. Master techniques for handling missing values, creating pivot tables, working with dates, and reshaping data frames. Explore advanced topics like hierarchical indexing, iterating over columns, and applying custom functions. Gain practical skills in data visualization using Matplotlib and Plotly Dash. Perfect for beginners and intermediate learners looking to enhance their Python data analysis capabilities.

Syllabus

Python Pandas Tutorial 1 | How to import CSV data in Python and Configuring options for custom Loads.
Python Pandas Tutorial 2 | How to Generate Data Frame Summary Statistic | Summarizing data in python.
Python Pandas Tutorial 3 | How to Sort Data Frame in Python | Sorting In Python.
Python Pandas Tutorial 4 | Filtering Data Frame Values | Reducing Pandas Data Frame Values.
Python Pandas Tutorial 5 | How to delete Rows and Columns from a data frame.
Python Pandas Tutorial 6 | How to manipulate pandas DataFrame | Working with DataFrames.
Python Pandas Tutorial 7 | How to Manipulate Series in Python | Working with Data Frame Series.
Python Pandas Tutorial 8 | How to import HTML data in Python | Importing HTML data in Python.
Python Pandas Tutorial 9 | How to Import Excel data in Python | Getting Excel Data in Python.
Python Pandas Tutorial 10 | Answering business questions with pandas| Exploratory data analysis.
Pandas Python Tutorial 11 | How to Aggregate data in Python | Group By Python Pandas Clause.
Python Pandas Tutorial 12 | How to manipulate Strings of Python Pandas Series.
Python Pandas Tutorial 13 | How to Create Pivot Table in Python Pandas | Pivot Tables in Python.
Python Pandas Tutorial 14 | How to Change Rows and Columns Display Options in Pandas.
Python Pandas Tutorial 15 | How to Identify and Drop Null Values | Handling Missing Values in Python.
Python Pandas Tutorial 16 | How to Fill Up NA Values | Various ways to fill missing values in python.
Pandas Python Tutorial 17 | How to Create Dummy Variable | Creating Dummy Variables in Pandas Python.
Python Pandas Tutoral 18 | How to Manipulated Dates in Python | Python Pandas Date Properties.
Python Pandas Tutorial 19 | How to Identify and Drop Duplicate Values | Removing duplicate values.
Python Pandas Tutorial 20 | How to align two different series or DataFrames.
Python Pandas Tutorial 21 | How to Rank a DataFrame in Python | Ranking Data in Python.
Python Pandas Tutorial 22 | How to Process Hierarchical Index.
Python Pandas Tutorial 23 | How to iterate over columns of python pandas data frame.
Python Pandas Tutorial 24 | How to loop in all the pandas dataframe columns and modify.
Python Pandas Tutorial 25 | How to import JSON data in Python | Importing JSON data in Python.
Python Pandas Tutorial 26 | How to Filter Pandas data frame for specific multiple values in a column.
Python Pandas Tutorial 27 | How to reshape pandas data frame.
Python Pandas Tutorial 28 | How to create dataframe from a dictionary.
Python Pandas Tutorial 29 | How to format dates in Python | Pandas to_datetime function.
Python Pandas Tutorial 30 | Adjusting Date Ranges in Python as per the WeekDays or Holidays.
Python Pandas Tutorial 31 | Python Data Visualization | How to Create Scatter Matrix.
Python Pandas Tutorial 32 | How to convert Python Machine Learning Toy data sets into a Data Frame.
Creating Real time chart form Pandas Dataframe in Plotly Dash | Plotly Dash Tutorial Part -8.
Python Data Analysis Tutorial | Pandas Tutorial | How to Create Time Series Date Ranges Manually.
Python Data Analysis / Visualization Matplotlib Tutorial | Configuring Matplotlib Plots | Pandas.
Python Data Analysis / Visualization Matplotlib Tutorial | How to Save Plots | Pandas Tutorial.
How to Install Pandas and then Import it in Windows Python IDLE and Jupyter Notebook.
Applying Custom Function on Python Pandas DataFrame Columns using Lambda expressions.
How to convert String Currency Values to Numeric Values in Python Pandas.
How to Create Excel Pivot Table on Python Pandas DataFrame.
How to find the mean or max or min of all the Python pandas columns.
How to use vlookup or mapping in python Pandas | Applymap function.
Finding Missing Values in Python Pandas Dataset each row or column or cell.
How to get count of columns in pandas dataset that are not having missing values or null values.