Explore All My Excel Solutions: https://pythonandvba.com/solutions


▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Ready to learn pandas, the most powerful data analysis library in Python? In this tutorial, we will analyse a realworld dataset my YouTube data. We start by reading and inspecting the data before doing exploratory data analysis (EDA). Once we understand the data well, I will show you advanced techniques to clean up the dataframe. To do so, we will take advantage of chaining pandas methods to keep the code clean and organised. With our clean dataframe, we will then perform a timeseries analysis and plot our findings in interactive charts.

:
▶ Source Code: https://github.com/SvenBo/pandastut...

⭐ :
00:00 – Intro
00:48 – Install the dependencies
01:34 – Get and inspect the data
02:43 – Check for missing values
03:54 – Check data distribution
06:14 – Check for correlation
08:49 – Clean the data
14:54 – Time Series Analysis
16:45 – Visually analyse the data
18:23 – Create a word cloud
18:44 – Outro



▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
【】Excel Addin (): https://pythonandvba.com/mytoolbelt
Dashboard Excel AddIn (): https://pythonandvba.com/grafly
Cartoon Charts Excel AddIn (): https://pythonandvba.com/cuteplots
Fun Emoji Excel AddIn (): https://pythonandvba.com/emojify
Excel Templates: https://pythonandvba.com/go/exceltem...
My Courses: https://pythonandvba.com/go/courses
Books, Tools, and More: https://pythonandvba.com/resources



▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
LinkedIn:   / svenbosau  
Instagram:   / codingisfun_official  
GitHub: https://github.com/SvenBo
Discord: https://pythonandvba.com/discord
Contact: https://pythonandvba.com/contact


☕ ?
If you want to support this channel, you can buy me a coffee here:
▶ https://pythonandvba.com/coffeedonation