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