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

Опубликовано: 02 Октябрь 2024
на канале: Coding Is Fun
30,576
649

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

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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:
https://www.kaggle.com/dansbecker/mel...

Pandas-Profiling GitHub Link:
https://github.com/pandas-profiling/p...

Read CSV File
df = pd.read_csv('melb_data.csv')

Read Excel File
df = pd.read_excel('YOURFILENAME.xlsx', sheet_name='Sheet1')

Create Pandas Profiling Report
profile = ProfileReport(df, title="Pandas Profiling Report")
profile.to_file('EDA_Houseprice_Analysis.html')
_____________________________________________________________________

Files of the tutorial [Google Drive]:
👉 https://bit.ly/2UvgsLw

Pandas Profiling GitHub Page:
👉 https://github.com/pandas-profiling/p...

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】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-tem...
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn:   / sven-bosau  
📸 Instagram:   / 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