Data-Analysis-Report

1. What is this app?

Upload an excel/csv file and produce a summary report of the data.

2. Where to upload? How to produce results?

- Click on Browse Files and upload.
- Make sure the csv file has the correct delimiter chosen in the text box.
- Once uploaded, check the Analyse box.

(Note : By default, a sample .csv file is used for demonstration at the start).

3. What is covered in this page?

1. Overview - Column info, Sample data and Numerical description.
2. Column Information - Column info, Distribution of numerical data, Descriptive stats of categorical data
3. Missing Data - Summary, Correlation Heatmap, Column vs Column comparison

4. Why did I create this app?

- I follow these basic steps during EDA on Notebooks and BI tools. Hence, I decided to implement them directly 
  before taking further visualization steps.
- The idea was inspired from pandas-profiling tool --> https://pandas-profiling.github.io/pandas-profiling/docs/master/index.html.

Upload an Excel/CSV file ( < 200 MB) and produce a short summary of the data.

Related tags

Overview

Data-Analysis-Report

Owner

Easwaran T H

Python Module for Tabular Datasets in XLS, CSV, JSON, YAML, &c.

xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS.

Library to create spreadsheet files compatible with MS Excel 97/2000/XP/2003 XLS files, on any platform.

ObjTables: Tools for creating and reusing high-quality spreadsheets

A python tool for batch importing excel/csv files into mysql database.

A Python module for creating Excel XLSX files.

BoobSnail allows generating Excel 4.0 XLM macro.

Excel-report-evaluator - A simple Python GUI application to aid with bulk evaluation of Microsoft Excel reports.

Please use openpyxl where you can...

PyExcelerate - Accelerated Excel XLSX Writing Library for Python 2/3

Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

Universal Office Converter - Convert between any document format supported by LibreOffice/OpenOffice.

A set of Python scripts for finding threats in Office365

xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and macOS. Sign up for the newsletter or follow us on twitter via

Use a docx as a jinja2 template

Transpiler for Excel formula like language to Python. Support script and module mode

According to the received excel file (.xlsx,.xlsm,.xltx,.xltm), it converts to word format with a given table structure and formatting

Create Open XML PowerPoint documents in Python

PowerShell module to import/export Excel spreadsheets, without Excel

A wrapper library to read, manipulate and write data in xlsx and xlsm format using openpyxl