filmov
tv
Data Analyst Projects | Cleaning and Exploring Data with Python | Part 3

Показать описание
Build a Data Analyst portfolio with me!
In this video, we go through Python to import data from both Excel and CSV files. We also learned how to clean data and make it ready for analytics. And then last, we explore the imported data with pandas, NumPy, matplotlib, and seaborn for insights.
--LINKS TO THE FIRST TWO PARTS OF THE SERIES
--LINKS TO DATA SOURCE--
Access the Code used in the demo from my GitHub repository with the links below
Cleaning Data:
Exploring Data:
HAPPY WITH THE CONTENT?
Timestamps:
00:00 Intro
00:31 Installing Anaconda
02:21 Cleaning Data with SQL - Importing Libraries
03:40 Getting Data
06:17 Removing Nulls
08:45 Slicing Data from Series
16:28 Replacing Specific Values
19:35 Appending Data to a Dataframe
21:38 Exporting Data to CSV
23:58 Exploring Data with Python
35:26 Categorical Variables - UniVariate
39:40 Categorical Variables - BiVariate
43:30 Numerical Variables - Discrete
45:14 Outliers
48:04 Distribution Plot - Skewness and Kurtosis
48:37 Correlation
52:25 Outro
#DataAnalytics #PythonDataAnalysis #Python
In this video, we go through Python to import data from both Excel and CSV files. We also learned how to clean data and make it ready for analytics. And then last, we explore the imported data with pandas, NumPy, matplotlib, and seaborn for insights.
--LINKS TO THE FIRST TWO PARTS OF THE SERIES
--LINKS TO DATA SOURCE--
Access the Code used in the demo from my GitHub repository with the links below
Cleaning Data:
Exploring Data:
HAPPY WITH THE CONTENT?
Timestamps:
00:00 Intro
00:31 Installing Anaconda
02:21 Cleaning Data with SQL - Importing Libraries
03:40 Getting Data
06:17 Removing Nulls
08:45 Slicing Data from Series
16:28 Replacing Specific Values
19:35 Appending Data to a Dataframe
21:38 Exporting Data to CSV
23:58 Exploring Data with Python
35:26 Categorical Variables - UniVariate
39:40 Categorical Variables - BiVariate
43:30 Numerical Variables - Discrete
45:14 Outliers
48:04 Distribution Plot - Skewness and Kurtosis
48:37 Correlation
52:25 Outro
#DataAnalytics #PythonDataAnalysis #Python
Data Analyst Portfolio Project | Data Cleaning in SQL | Project 3/4
Data Analyst Projects | Cleaning and Exploring Data with SQL | Part 1
Cleaning Data in Excel | Excel Tutorials for Beginners
Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard
A Real-World Data Cleaning Project - 100% Free!
10 PORTFOLIO PROJECTS TO ADD TO YOUR DATA PORTFOLIO
Understanding Data Cleaning | Google Data Analytics Certificate
Economic Data Analysis Project with Python Pandas - Data scraping, cleaning and exploration!
Data Analytics Python Resume Project | Data Cleaning Portfolio Project (Free) - Datasets #guided
Data Analyst Project - Cleaning Data with SQL for Insights | Power BI, SQL & Python
How I use Python as a Data Analyst
Exploratory Data Analysis with Pandas Python
Data Cleaning in SQL | Google Data Analytics Certificate
Netflix Data Cleaning and Analysis Project | End to End Data Engineering Project (SQL + Python)
Data Analyst Projects | Cleaning and Exploring Data with Python | Part 3
Data Cleaning in Pandas | Python Pandas Tutorials
Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4
Full Project in Excel | Excel Tutorials for Beginners
How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)
Real World Data Cleaning in Python Pandas (Step By Step)
Data Analyst Portfolio Project - Clean Data - Power BI & SQL
🤩 Build Awesome Data Analytics Portfolio from Scratch in 2022 // 4 Portfolio project ideas
How to Do Data Cleaning (step-by-step tutorial on real-life dataset)
Python Project for Data Analysis- Exploratory Data Analysis | Data Analyst Project
Комментарии