Practical Data Analysis with Pandas in Python | Exploratory Data Analysis & Data Wrangling / Munging

Published: 12 September 2022
on channel: DataQueen
362
11

Practical, real world data analysis made possible by pandas!
Link to the pandas cheat sheet: https://pandas.pydata.org
Link to the dataset and code : https://github.com/vijita/pandas

Summary
Series looks like a one-dimensional Numpy array & DataFrame looks like a 2-dimensional array, but there are key differences.
Unlike Numpy array, the axes can be labeled in the Dataframe, and the data type of each column can be different in the Dataframe

Data Analysis using pandas (5 steps)
1. Define requirement
2. Data Collection
3. Exploratory Data analysis,
4. Data Wrangling and
5. Report results

Chapters
00:00 Pandas Introduction
01:46 Exploratory Data Analysis using Pandas
07:55 Data Wrangling using Pandas

Requirement: Find out the top 10 companies that increased in Marketcap from March to August.
Data collection : Two datasets from the companiesmarketcap.com at two different dates.
Exploratory Data analysis, also known as EDA. The goal of EDA is to understand the data and document the findings.
There are several methods to run EDA. Let’s follow these 5 steps
1. Observe data
2. Understand Columns
3. Find missing values
4. Data distribution
5. Identify the relationship and locate outliers
And then summarize the key findings.

Data Wrangling or Data Munging is the process of converting the raw data into a more useful form.
There are three steps here.
1. Data Cleaning
2. Data Merging and
3. Data Manipulation

Data cleaning is about fixing the anomalies in the data
Data manipulation is about applying logic and calculation to generate a completely different set of data.

With pandas, Data Wrangling or Data Munging is this easy!
Learning is fun


#pandas #pandaspython #exploratorydataanalysis #eda #datawrangling #pandasfordataanalysis #pandasdataanalysis #datacleaning #datamanipulation #pandastutorial #pandasdataframe #dataanalysis #ndarray #python3 #pythontutorial #pythoncourse #pythonforbeginners #pythonfordatascience #pythonformachinelearning #pythonforai #pythonforiot #anaconda #dataqueen


On this page of the site you can watch the video online Practical Data Analysis with Pandas in Python | Exploratory Data Analysis & Data Wrangling / Munging with a duration of hours minute second in good quality, which was uploaded by the user DataQueen 12 September 2022, share the link with friends and acquaintances, this video has already been watched 362 times on youtube and it was liked by 11 viewers. Enjoy your viewing!