# <a name="top"></a>SheetBuddy
SheetBuddy is a Python library for performing exploratory data analysis (EDA) , Data sunmmary and generating comprehensive reports in Excel format. It supports reading data from CSV files, JSON files, and APIs.
[](https://pypi.org/project/sheetbuddy/)
[](https://pypi.org/project/sheetbuddy/)
[](https://pypi.org/project/sheetbuddy/)
[](https://pypi.org/project/sheetbuddy/)
[](https://github.com/AshishRogannagari/sheetbuddy/issues)
[](https://github.com/AshishRogannagari/sheetbuddy/pulls)
[](https://github.com/AshishRogannagari/sheetbuddy/graphs/contributors)
[](https://github.com/AshishRogannagari/sheetbuddy/network/members)
[](https://github.com/AshishRogannagari/sheetbuddy/stargazers)
[](https://github.com/AshishRogannagari/sheetbuddy/blob/main/LICENSE)
[](https://github.com/login?return_to=%2FAshishRogannagari%2FSheetBuddy)
[](https://github.com/AshishRogannagari/sheetbuddy.git)
## Features
- Data Cleaning and Preprocessing
- Load data from CSV, JSON, and APIs
- Generate EDA reports in Excel format
- Summary statistics, null values, standard deviation, and more
- Column information including descriptions ('May not be available for all columns')
- Conditional formatting and styling for Excel sheets
- Summary Statistics
- Visualization (Correlation Matrix, Basic Mathematics)
- Data Export (Excel)
## Installation
You can install SheetBuddy using `pip`:
```bash
pip install sheetbuddy
```
# or
```bash
pip install sheetbuddy==1.0.0
```
## Check for the lastest version
```bash
pip install sheetbuddy --upgrade
```
### Usage
Example 1: Generating an EDA and Datasummary Report from a CSV File.
```python
from sheetbuddy import SheetBuddy
file_path_or_url = 'https://people.sc.fsu.edu/~jburkardt/data/csv/airtravel.csv'
output_file_name = 'datasummary_report.xlsx'
sb = SheetBuddy(file_path_or_url)
sb.generate_eda_report(output_file_name)
```
Example 2: Generating an Datasummary & EDA Report from a Local JSON File.
```python
from sheetbuddy import SheetBuddy
file_path = 'path/to/your/data.json'
output_file_name = 'enter_your_desired_name.xlsx'
sb = SheetBuddy(file_path)
sb.generate_eda_report(output_file_name)
```
Example 3: Generating an Datasummary & EDA Report from a Local CSV File.
```python
from sheetbuddy import SheetBuddy
filename = 'your_local_path.csv'
outputfile = 'enter_your_desired_name.xlsx'
sb = SheetBuddy(filename)
sb.generate_eda_report(outputfile)
```
# How It Works:
1.Data Loading: SheetBuddy loads data from the specified source (CSV, JSON, or API).
2.Data Analysis: It performs various data analyses, including summary statistics, null values analysis, and column descriptions.
3.Report Generation: The results are compiled into an Excel file with conditional formatting and styling for easy interpretation.
# Contributing:
Contributions are welcome! If you have any suggestions, bug reports, or feature requests, please open an issue or submit a pull request on GitHub.
# License:
SheetBuddy is licensed under the MIT License. See the LICENSE file for more details.
<a href="#top" style="position:fixed;bottom:20px;right:20px;background-color:#007bff;color:white;padding:15px 20px;border-radius:25px;text-align:center;text-decoration:none;font-size:18px;box-shadow:2px 2px 5px rgba(0,0,0,0.3);"> Back to Top ↑ </a>
Raw data
{
"_id": null,
"home_page": "https://github.com/AshishRogannagari/sheetbuddy",
"name": "SheetBuddy",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.0",
"maintainer_email": null,
"keywords": null,
"author": "Ashish Rogannagari",
"author_email": "Ashishrogannagari98@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/17/2a/c69fb429a73476f22726ba199db94b65d6af9b487c44d07e46432d0a0ca7/sheetbuddy-1.1.6.tar.gz",
"platform": null,
"description": "# <a name=\"top\"></a>SheetBuddy\n\nSheetBuddy is a Python library for performing exploratory data analysis (EDA) , Data sunmmary and generating comprehensive reports in Excel format. It supports reading data from CSV files, JSON files, and APIs.\n\n[](https://pypi.org/project/sheetbuddy/)\n[](https://pypi.org/project/sheetbuddy/)\n[](https://pypi.org/project/sheetbuddy/)\n[](https://pypi.org/project/sheetbuddy/)\n\n\n\n[](https://github.com/AshishRogannagari/sheetbuddy/issues)\n[](https://github.com/AshishRogannagari/sheetbuddy/pulls)\n[](https://github.com/AshishRogannagari/sheetbuddy/graphs/contributors)\n[](https://github.com/AshishRogannagari/sheetbuddy/network/members)\n[](https://github.com/AshishRogannagari/sheetbuddy/stargazers)\n[](https://github.com/AshishRogannagari/sheetbuddy/blob/main/LICENSE)\n[](https://github.com/login?return_to=%2FAshishRogannagari%2FSheetBuddy)\n[](https://github.com/AshishRogannagari/sheetbuddy.git)\n\n\n\n\n## Features\n- Data Cleaning and Preprocessing\n- Load data from CSV, JSON, and APIs\n- Generate EDA reports in Excel format\n- Summary statistics, null values, standard deviation, and more\n- Column information including descriptions ('May not be available for all columns')\n- Conditional formatting and styling for Excel sheets\n- Summary Statistics\n- Visualization (Correlation Matrix, Basic Mathematics)\n- Data Export (Excel)\n\n## Installation\n\nYou can install SheetBuddy using `pip`:\n\n```bash\npip install sheetbuddy\n```\n# or\n```bash\npip install sheetbuddy==1.0.0\n```\n\n## Check for the lastest version\n\n\n```bash\npip install sheetbuddy --upgrade\n```\n### Usage\n\nExample 1: Generating an EDA and Datasummary Report from a CSV File.\n\n\n```python\n\nfrom sheetbuddy import SheetBuddy \n\nfile_path_or_url = 'https://people.sc.fsu.edu/~jburkardt/data/csv/airtravel.csv'\noutput_file_name = 'datasummary_report.xlsx'\n\nsb = SheetBuddy(file_path_or_url)\nsb.generate_eda_report(output_file_name)\n```\n\n\n\nExample 2: Generating an Datasummary & EDA Report from a Local JSON File.\n\n```python\n\nfrom sheetbuddy import SheetBuddy\n\nfile_path = 'path/to/your/data.json'\noutput_file_name = 'enter_your_desired_name.xlsx'\n\nsb = SheetBuddy(file_path)\nsb.generate_eda_report(output_file_name)\n\n```\nExample 3: Generating an Datasummary & EDA Report from a Local CSV File.\n\n```python\n\nfrom sheetbuddy import SheetBuddy\n\nfilename = 'your_local_path.csv'\noutputfile = 'enter_your_desired_name.xlsx'\n\nsb = SheetBuddy(filename)\nsb.generate_eda_report(outputfile)\n\n```\n# How It Works:\n\n1.Data Loading: SheetBuddy loads data from the specified source (CSV, JSON, or API).\n\n2.Data Analysis: It performs various data analyses, including summary statistics, null values analysis, and column descriptions.\n\n3.Report Generation: The results are compiled into an Excel file with conditional formatting and styling for easy interpretation.\n\n# Contributing:\n\nContributions are welcome! If you have any suggestions, bug reports, or feature requests, please open an issue or submit a pull request on GitHub.\n\n# License:\n\nSheetBuddy is licensed under the MIT License. See the LICENSE file for more details.\n\n\n\n\n<a href=\"#top\" style=\"position:fixed;bottom:20px;right:20px;background-color:#007bff;color:white;padding:15px 20px;border-radius:25px;text-align:center;text-decoration:none;font-size:18px;box-shadow:2px 2px 5px rgba(0,0,0,0.3);\"> Back to Top \u2191 </a>\n\n\n\n\n\n\n\n\n\n\n",
"bugtrack_url": null,
"license": null,
"summary": "A library for data summary and analysis from various formats such as CSV, API, URL, etc.",
"version": "1.1.6",
"project_urls": {
"Homepage": "https://github.com/AshishRogannagari/sheetbuddy"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "da41ee17d39fd93d883ff8ccd1dfa6fbf5e735c8304b8c0eb2472894e7e63d44",
"md5": "d1b1a004b97e0fce7e683802decf6f0e",
"sha256": "29648d8c8d5b721c0186b6b47bb0f192da849adc0e58e4753ec780991ddeca75"
},
"downloads": -1,
"filename": "SheetBuddy-1.1.6-py3-none-any.whl",
"has_sig": false,
"md5_digest": "d1b1a004b97e0fce7e683802decf6f0e",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.0",
"size": 3506,
"upload_time": "2024-06-26T19:05:35",
"upload_time_iso_8601": "2024-06-26T19:05:35.026755Z",
"url": "https://files.pythonhosted.org/packages/da/41/ee17d39fd93d883ff8ccd1dfa6fbf5e735c8304b8c0eb2472894e7e63d44/SheetBuddy-1.1.6-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "172ac69fb429a73476f22726ba199db94b65d6af9b487c44d07e46432d0a0ca7",
"md5": "5cfeedaf72cc10d9a3681c0a32165fb0",
"sha256": "f7e110d0b0c9313ede9d4a904469389e82354bf965370d5abbf77a1fa3cf358e"
},
"downloads": -1,
"filename": "sheetbuddy-1.1.6.tar.gz",
"has_sig": false,
"md5_digest": "5cfeedaf72cc10d9a3681c0a32165fb0",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.0",
"size": 7225,
"upload_time": "2024-06-26T19:05:36",
"upload_time_iso_8601": "2024-06-26T19:05:36.769081Z",
"url": "https://files.pythonhosted.org/packages/17/2a/c69fb429a73476f22726ba199db94b65d6af9b487c44d07e46432d0a0ca7/sheetbuddy-1.1.6.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-26 19:05:36",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "AshishRogannagari",
"github_project": "sheetbuddy",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"requirements": [],
"lcname": "sheetbuddy"
}
JSON
