Menu

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')