👉 Explore All My Excel 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:
# [ Ссылка ]
# Pandas-Profiling GitHub Link:
# [ Ссылка ]
# 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]:
👉 [ Ссылка ]
Pandas Profiling GitHub Page:
👉 [ Ссылка ]
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): [ Ссылка ]
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): [ Ссылка ]
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): [ Ссылка ]
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): [ Ссылка ]
📑 Excel Templates: [ Ссылка ]
🎓 My Courses: [ Ссылка ]
📚 Books, Tools, and More: [ Ссылка ]
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: [ Ссылка ]
📸 Instagram: [ Ссылка ]
💻 GitHub: [ Ссылка ]
💬 Discord: [ Ссылка ]
📬 Contact: [ Ссылка ]
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: [ Ссылка ]
