Solve Real-World Data Science Tasks in Python | Data Analysis with Pandas & Plotly (Full Tutoria

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

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, we are going to solve a real-world data science/analysis project with python.

We will be using the following Python Libraries:
• Pandas
• Pandas Profiling Report
• AutoViz
• Plotly

After we have loaded the dataset, we will do some initial exploratory data analysis to get an idea of the dataset.
I am going to show you very useful pandas’ functions which you can apply to any kind of dataset you might deal with.

However, nowadays there are so many cool libraries available, which will make exploratory data analysis so much easier. I will show you my favorite 2 libraries, which will generate automated reports for us in just a few lines of code.
Those reports are a great starting point before we are moving on to answer real-world business type questions.

While answering those questions, we will cover a wide range of various pandas’ functions. Additionally, we will also code our own python helper function, which we are going to use in the deep-dive & visualization section. All the charts we are going to create will be interactive and have a clean design.

We will cover the following chart types:
• Histogram
• Box Plot
• Bar Charts
• Scatter Plot
• Line Chart

Feel free to code along with me. In the project files, you will also find an exercise Notebook that includes all the tasks we are going to solve.

Download the project files here:
👉 https://github.com/Sven-Bo/data-analysis-python

✅ Chapters:
00:00 - Introduction
01:44 - (Setup) Virtual Environment
03:22 - (Setup) Installing Libraries
03:50 - (Settings) Project Files Overview
04:48 - (Settings) Importing Libraries
05:02 - (Settings) Setting Plotly Template
05:30 - (Settings) Load DataFrame
06:37 - (Explore Dataset) Traditionally
08:31 - (Explore Dataset) Pandas Profiling Report
09:53 - (Explore Dataset)AutoViz Report
10:35 - (Data Prep & Analysis) Various Pandas Functions
14:51 - (Deep Dive & Visualization) Overview
15:53 - (Deep Dive & Visualization) Histogram
16:34 - (Deep Dive & Visualization) Box Plot
17:00 - (Deep Dive & Visualization) Various Bar Plots
19:24 - (Deep Dive & Visualization) Various Scatter Plot
19:52 - (Deep Dive & Visualization) Discount Analysis
21:15 - (Deep Dive & Visualization) Line Chart
22:55 - Final Words
23:44 - Outro


𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): https://pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): https://pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): https://pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): https://pythonandvba.com/emojify
📑 Excel Templates: https://pythonandvba.com/go/excel-templates
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources


𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: https://www.linkedin.com/in/sven-bosau/
📸 Instagram: https://instagram.com/codingisfun_official
💻 GitHub: https://github.com/Sven-Bo
💬 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/coffee-donation