A package for generating EDA reports
Project description
EDAExcelReport
EDAExcelReport is a Python package for generating detailed exploratory data analysis (EDA) reports specifically for datasets with binary target variables. The package creates comprehensive EDA reports in Excel format, which include statistics and visualizations in the form of table that help in understanding the distribution and relationship of various features with the target variable.
Features
- Calculates frequency and distribution of feature values.
- Computes target rate, percentage of total target, and lift for each feature value.
- Automatically handles numeric and categorical data.
- Generates Excel reports with well-formatted tables and conditional formatting.
- Removes gridlines and adds borders for better readability.
Installation
You can install the package via pip:
pip install EDAExcelReport
# How to import?
from EDAR.excel_report import EDAExcelReport
# Import necessary libraries
import pandas as pd
import numpy as np
import os
from EDAR.excel_report import EDAExcelReport
# Loading the credit dataset
df = pd.read_csv(r"tests\credit_data.csv")
df.columns
Index(['ID', 'CODE_GENDER', 'FLAG_OWN_CAR', 'FLAG_OWN_REALTY', 'CNT_CHILDREN',
'AMT_INCOME_TOTAL', 'NAME_INCOME_TYPE', 'NAME_EDUCATION_TYPE',
'NAME_FAMILY_STATUS', 'NAME_HOUSING_TYPE', 'DAYS_BIRTH',
'DAYS_EMPLOYED', 'FLAG_MOBIL', 'FLAG_WORK_PHONE', 'FLAG_PHONE',
'FLAG_EMAIL', 'OCCUPATION_TYPE', 'CNT_FAM_MEMBERS', 'target'],
dtype='object')
df.isna().sum()
ID 0
CODE_GENDER 0
FLAG_OWN_CAR 0
FLAG_OWN_REALTY 0
CNT_CHILDREN 0
AMT_INCOME_TOTAL 0
NAME_INCOME_TYPE 0
NAME_EDUCATION_TYPE 0
NAME_FAMILY_STATUS 0
NAME_HOUSING_TYPE 0
DAYS_BIRTH 0
DAYS_EMPLOYED 0
FLAG_MOBIL 0
FLAG_WORK_PHONE 0
FLAG_PHONE 0
FLAG_EMAIL 0
OCCUPATION_TYPE 11323
CNT_FAM_MEMBERS 0
target 0
dtype: int64
ignore_feats = ["ID", "OCCUPATION_TYPE", "DAYS_BIRTH", "DAYS_EMPLOYED", "FLAG_MOBIL"]
EDAExcelReport(df, 'target',r'tests\test_eda_report.xlsx', ignore_cols= ignore_feats)
Your EDA report is ready at tests\test_eda_report_20240610_153828.xlsx
<ed_report.excel_report.EDAExcelReport at 0x188c09ee9f0>
Exploratory Data Analysis Excel File for above Credit Data you can download from here:
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
EDAExcelReport-0.1.2.tar.gz
(8.4 kB
view hashes)
Built Distribution
Close
Hashes for EDAExcelReport-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e7b210e64d6400201164ec98d90a40cb99ea0749f1df21e907278a434fa8db6e |
|
MD5 | ac10c24ae714dff5b6c9baf5dd5ce365 |
|
BLAKE2b-256 | f0f97d3ef63d5228a0f5e232d54b840c0716ca7ba37f278f6d6651ea0adfa506 |