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