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

Easwaran T H

Last update: Feb 26, 2022

Overview

Data-Analysis-Report

Deployed App

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.

ExcelPeek is a tool designed to help investigate potentially malicious Microsoft Excel files.

37 Apr 16, 2022

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

448 Dec 28, 2022

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

Tablib: format-agnostic tabular dataset library _____ ______ ___________ ______ __ /_______ ____ /_ ___ /___(_)___ /_ _ __/_ __ `/__ _

4.2k Dec 30, 2022

ObjTables: Tools for creating and reusing high-quality spreadsheets

ObjTables: Tools for creating and reusing high-quality spreadsheets ObjTables is a toolkit which makes it easy to use spreadsheets (e.g., XLSX workboo

7 Jun 14, 2021

Model summary in PyTorch similar to `model.summary()` in Keras

Keras style model.summary() in PyTorch Keras has a neat API to view the visualization of the model which is very helpful while debugging your network.

3.7k Dec 29, 2022

Produces a summary CSV report of an Amber Electric customer's energy consumption and cost data.

Amber Electric Usage Summary This is a command line tool that produces a summary CSV report of an Amber Electric customer's energy consumption and cos

12 May 26, 2022

A simple program which gets a file(CSV/Excel) with tasks and creates different variants

TestMakerProject A simple program which gets a file(CSV/Excel) with tasks and creates different variants The main program is QTengine.py You only have

3 Nov 18, 2021

Instagram_scrapper - This project allow you to scrape the list of followers, following or both from a public Instagram account, and create a csv or excel file easily.

Instagram_scrapper This project allow you to scrape the list of followers, following or both from a public Instagram account, and create a csv or exce

5 Oct 17, 2022

A fun hangman style game to guess random movie names with a short summary about the movie.

hang-movie-man Hangman but for movies 😉 This is a fun hangman style game to guess random movie names from the local database and show some summary ab

10 Sep 7, 2022

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

xlwings - Make Excel fly with Python! xlwings CE xlwings CE is a BSD-licensed Python library that makes it easy to call Python from Excel and vice ver

2.5k Jan 6, 2023

My sister is a GR of her class. She had to mark attendance of students from screenshots of teams meeting on an excel sheet. I resolved her problem by reading names from screenshots using PyTesseract and marking them present on the excel using Pandas in Python. It took me 1hr to write the code and it is saving half an hour everyday.

auto-team-attandance Don't judge the code, this is not the best way to write code. I was learning tkinter that is why GUI is bad. Here's the Mega link

25 Sep 4, 2022

Fetch data from an excel file and create HTML file

excel-to-html Problem Statement! - Fetch data from excel file and create html file Excel.xlsx file contain the information.in multiple rows that is ne

1 Oct 25, 2021

A flask extension using pyexcel to read, manipulate and write data in different excel formats: csv, ods, xls, xlsx and xlsm.

Flask-Excel - Let you focus on data, instead of file formats Support the project If your company has embedded pyexcel and its components into a revenu

247 Dec 27, 2022

PowerShell module to import/export Excel spreadsheets, without Excel

Pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).

AWS Data Wrangler Pandas on AWS Easy integration with Athena, Glue, Redshift, Timestream, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretMana

3.3k Jan 4, 2023

Pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).

3.3k Dec 31, 2022

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

Related tags

Overview

Data-Analysis-Report

You might also like...

ExcelPeek is a tool designed to help investigate potentially malicious Microsoft Excel files.

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

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

ObjTables: Tools for creating and reusing high-quality spreadsheets

Model summary in PyTorch similar to `model.summary()` in Keras

Produces a summary CSV report of an Amber Electric customer's energy consumption and cost data.

A simple program which gets a file(CSV/Excel) with tasks and creates different variants

Instagram_scrapper - This project allow you to scrape the list of followers, following or both from a public Instagram account, and create a csv or excel file easily.

A fun hangman style game to guess random movie names with a short summary about the movie.

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

Fetch data from an excel file and create HTML file

A flask extension using pyexcel to read, manipulate and write data in different excel formats: csv, ods, xls, xlsx and xlsm.

PowerShell module to import/export Excel spreadsheets, without Excel

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

DB-Drive-CSV - This is app is can be used to access CSV file as JSON from Google Drive.

MM1 and MMC Queue Simulation using python - Results and parameters in excel and csv files

Pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).

Pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).

Owner

Easwaran T H

PowerShell module to import/export Excel spreadsheets, without Excel

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

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

Reads Data from given Excel File and exports Single PDFs and a complete PDF grouped by Gateway

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

A suite of utilities for converting to and working with CSV, the king of tabular file formats.

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

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

A Python module for creating Excel XLSX files.

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