Скачать с ютуб Turn Your Excel Worksheet Into An Exploratory Data Analysis Report In Just 3 Lines Of Python Code 🔥 в хорошем качестве

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

👉 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