Skip to main content

A package for analyzing CSV files and generating summary reports in HTML

Project description

Davis Summary VAC 📊✨

A comprehensive tool for CSV analysis with automated HTML reporting.

PyPI version License: MIT Python version

Overview

  • davis-summary-vac is a light weight Python package that analyzes CSV files and generates a detailed HTML report.
  • It offers a summary of both numeric and non-numeric columns, detecting potential outliers and providing insights into your data. Whether you're a data scientist, analyst, or just someone exploring data, this tool simplifies the analysis process and presents it in a visually appealing format.

Features 🌟

  • 📊 Detailed summary of numeric columns:
    • Count, Minimum, Maximum, Mean, Median, Standard Deviation
    • Variance, Quartiles, Interquartile Range (IQR)
    • Detection of potential outliers
  • 🛠️ Analysis of non-numeric columns:
    • Unique values
    • Value counts of the top items
  • 🖥️ Automatically generates a structured HTML report with tables and highlights.
  • 📝 User-friendly interface for quick and easy CSV file analysis.

Installation 🚀

Ensure you have Python 3.6 or higher installed. Then, use pip to install the package:

pip install davis-summary-vac

Usage 🖥️

To analyze a CSV file and generate an HTML report, run the following command:

davis-summary-vac <path_to_your_csv_file> --output <output_html_file>
Arguments:
<path_to_your_csv_file>: The path to the CSV file you want to analyze.
--output (optional): The path to save the generated HTML report. Default is analysis_report.html.

Example:

davis-summary-vac data.csv --output my_report.html

Output Example 📄 After running the command, an HTML report will be generated containing:

Numeric Columns Summary: Statistical metrics like mean, median, standard deviation, and outlier detection. Non-Numeric Columns Summary: Unique value counts and the top frequent items. Here's a sample snapshot of what the generated report looks like:

API Usage (In Python Scripts) If you'd like to use this package programmatically within a Python script:

from davis_summary_vac import analyze_csv, generate_summary, generate_html_report,generate_correlation_matrix_image

data = analyze_csv('data.csv')
summary = generate_summary(data)
html_report = generate_html_report(data, summary)
corr_img_base64 = generate_correlation_matrix_image(data)


with open('output.html', 'w', encoding='utf-8') as file:
    file.write(html_report)
    

Dependencies 📦

  • Python 3.6+
  • csv
  • statistics
  • math
  • base64
  • argparse
  • All dependencies are included with Python's standard library, making it lightweight and easy to use.

Contributing 🤝

We welcome contributions to improve this package! If you find a bug or have suggestions for new features:

Fork the repository.

  • Create a new branch (feature/my-feature).
  • Commit your changes.
  • Push to the branch.
  • Open a Pull Request.

License 📄

This project is licensed under the MIT License - see the LICENSE file for details.

Author ✍️

  • Developed by the Visionary Arts Company (VAC).
  • Stay connected and explore more at wearevac.github.io.
    If you enjoyed this package, please give it a ⭐ on GitHub!

Support 💬

If you have any questions, issues, or suggestions, please feel free to reach out by opening an issue on the GitHub repository or by contacting us directly via the website.

Happy Analyzing! 📊🎉

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

davis_summary_vac-0.2.0.tar.gz (6.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

davis_summary_vac-0.2.0-py3-none-any.whl (7.3 kB view details)

Uploaded Python 3

File details

Details for the file davis_summary_vac-0.2.0.tar.gz.

File metadata

  • Download URL: davis_summary_vac-0.2.0.tar.gz
  • Upload date:
  • Size: 6.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.12.3

File hashes

Hashes for davis_summary_vac-0.2.0.tar.gz
Algorithm Hash digest
SHA256 1cb854ee37ae1b79a8f14482455fffe321545c9f2ba7d90e5df578ebafdbb186
MD5 2e494769d0896bd2de7f2ce4bc735627
BLAKE2b-256 ee243438203fd2b620e70694c47e96f82998b6c9f7d96602137ad7fd74526e62

See more details on using hashes here.

File details

Details for the file davis_summary_vac-0.2.0-py3-none-any.whl.

File metadata

File hashes

Hashes for davis_summary_vac-0.2.0-py3-none-any.whl
Algorithm Hash digest
SHA256 56f5fb1dc47069febd762b1c8576e9a38d9ab07ccb24cbc8e33437759fd530b5
MD5 2f3168b621e84ffa96fab7817d63ae42
BLAKE2b-256 03fc995d2f163d8d08ba7788a9924362b8904cdb3b21ca9914104932bbb29738

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page