README.md

Password protected Excel & EDA

Read password protected excel(multiple sheets) and perform EDA.

Library

1. xlwings - To Read protected excel. Refer
2. pandas_profiling - To perform EDA. Refer

Dataset

Considered 5 generic dataset,

UCI Machine Learning,

1. Breast Cancer
2. IRIS
3. Mushrooms

Others,

1. Chennai Water Management
2. Bengaluru House Data

EDA Report

EDA reports are saved as html file in output folder.