Turn Your Excel Worksheet Into An Exploratory Data Analysis Report In Just 3 Lines Of Python Code
Language:
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.
📝 Resources:
Download the files of the tutorial here:
Download Here
Pandas Profiling GitHub Page: https://github.com/pandas-profiling/pandas-profiling
👩💻 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/melbourne-housing-snapshot/home
# Pandas-Profiling GitHub Link:
# https://github.com/pandas-profiling/pandas-profiling
# 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')