CSVxplore.md

CSV and Excel File Viewer

This is a simple and advanced Streamlit application that allows users to upload, view, and analyze CSV and Excel files. The app provides various data exploration tools, including descriptive statistics, visualizations, and a Pandas Profiling report.

Features

• File Upload: Supports CSV and Excel file formats.
• Data Preview: Displays the first 10 rows of the uploaded dataset.
• Descriptive Statistics: Provides summary statistics of the dataset.
• Data Visualization: Allows users to generate histograms, boxplots, line charts, and scatter plots.
• Correlation Matrix: Displays the correlation matrix of the dataset.
• Missing Values: Shows the count of missing values in each column.
• Pandas Profiling Report: Generates an in-depth profiling report of the dataset.
• Download Options: Users can download the dataset in CSV or Excel format.

Installation

To run this application locally, follow these steps:

1. Install the required packages:

   pip install -r requirements.txt

2. Run the Streamlit application:

   streamlit run app.py

Usage

• Open your web browser and go to http://localhost:8501 to access the app.
• Upload a CSV or Excel file using the file uploader.
• Explore your data with the provided tools and download the modified data if needed.

Screenshots

Home Page

Data Preview

Data Visualization

Acknowledgments

• Streamlit for the awesome framework.
• Pandas for data manipulation and analysis.
• Matplotlib for data visualization.
• Pandas Profiling for generating detailed data reports.