Turn Your Excel Worksheet Into An Exploratory Data Analysis Report In Just 3 Lines Of Python Code 🔥

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, I will show you, how you can turn your Excel Worksheet into an interactive Exploratory Data Analysis Report in just 3 lines of code.

We can achieve this by using the python library “Pandas Profiling”. This very useful library will help you to speed up your data analysis.

✅ Chapters:
0:00 Demo
0:45 Introduction
2:19 Python Code
7:24 Outro

_____________________________________________________________________
📝 SOURCE CODE:
import pandas as pd # pip install pandas openpyxl
from pandas_profiling import ProfileReport # pip install pandas-profiling

# LINK TO DATASET:

# Pandas-Profiling GitHub Link:

# Read CSV File

# Read Excel File

# Create Pandas Profiling Report
profile = ProfileReport(df, title="Pandas Profiling Report")
_____________________________________________________________________

Files of the tutorial [Google Drive]:

Pandas Profiling GitHub Page:

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[ricky]

can't thank you enough for this. you have no idea how much THIS helped me

[nambuiphuong]

In 2:16, when i rename my text file just like you, the logo didnt transfer to the "atom" logo, can you please help me describe specifically how you do that

[augustadeclan]

Thank you so much. I can't even to begin to explain how much this has helped me!

[M_le-nr]

Is there something similar we can execute inside of a jupyter notebook to give us the same stats?

[fatimahalshahrani]

if i want to build my own function to print the columns names from csv file
not using exist libraries
How can I do that

[chrisk.]

Moin Sven, wirklich geile tutorials, Danke Dir sehr!!!! Ich habe folgendes Problem, ich kann Pandas-Profiling nicht installieren, nach einer Weile kommt "ERROR: Could not build wheels for phik, which is required to install pyproject.toml-based projects". Bei stackoverflow gibt es noch keine Lösungen…Vielen Dank, freue mich auf weitere Videos!!!! LG Chris

[turalnagi]

thanks a lot. But you should use pip install ydata-profiling rather than pip install pandas-profiling

[flyeagle]

that's really surprising to see this way of Eda . thank you

[omardonia]

what is the program you use to run code on?

[fatimahalshahrani]

Can you help me how can I do the exploratory data analysis by create my own function 🙏

[TheJonas]

I can't get "pip install pandas" to work in CMD. Is there anyone how knows what im doing wrong? Error message: 'pip' is not recognized as an internal or external command, operable program or batch file.

[fatimahalshahrani]

can you help me, how can i print columns headers without using own function??

[sigfigronath]

Hey whats the atom extension you are using ?

[ariewidya]

why i got error for 'from pandas_profiling import ProfileReport' ?

[jesterr]

Update: Pandas Profiling syntax has now been changed to ydata_profiling

So your code would look like this

import pandas as pd
from ydata_profiling import ProfileReport