A utility package for analysts with Pandas, Excel, CSV helpers and more.
Project description
python-analyst-utility
A Python package providing streamlined tools for analysts, including Pandas wrappers, Excel and CSV helpers, and file management utilities. Simplify common tasks and boost productivity with this all-in-one utility package.
Features
- 📊 Enhanced Pandas functionality with intuitive wrappers
- 📑 Simplified Excel and CSV file handling
- 🗂️ File management utilities for common analyst tasks
- ⚡ Performance-optimized data operations
- 🔧 Easy-to-use API for common data analysis tasks
Installation
Install using pip:
pip install python-analyst-utility
Quick Start
from analyst_utility import excel, pandas_helper
# Example: Reading an Excel file with enhanced features
df = excel.read_excel("data.xlsx", sheet_name="Sheet1")
# Example: Using pandas helper functions
cleaned_df = pandas_helper.clean_column_names(df)
Documentation
Excel Module
# Read Excel files with additional options
excel.read_excel(filename, sheet_name="Sheet1", headers=True)
# Write to Excel with formatting
excel.write_excel(df, filename, sheet_name="Output")
Pandas Helper Module
# Clean column names
pandas_helper.clean_column_names(df)
# Quick data quality check
pandas_helper.check_data_quality(df)
Building The Package
Build the package using:
python setup.py sdist bdist_wheel
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
- Fork the repository
- Create your feature branch (
git checkout -b feature/AmazingFeature) - Commit your changes (
git commit -m 'Add some AmazingFeature') - Push to the branch (
git push origin feature/AmazingFeature) - Open a Pull Request
License
This project is licensed under the MIT License - see the LICENSE file for details.
Support
For support, please open an issue in the GitHub repository.
Changelog
Version 1.0.0
- Initial release
- Basic Excel and CSV functionality
- Pandas helper functions
- File management utilities
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file python_analyst_utility-0.1.6.tar.gz.
File metadata
- Download URL: python_analyst_utility-0.1.6.tar.gz
- Upload date:
- Size: 18.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.0.1 CPython/3.12.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
45aa0bf5d872440831bec23aabc597b5876ac136b9c5cc0f9a70f588854ff8db
|
|
| MD5 |
3d69fbc542b9e09e71a970ad685c0f02
|
|
| BLAKE2b-256 |
805f9462fdcd8d3a1f6f71b530a2e992d96a0891673f8026b2bca9d40a504dc6
|
Provenance
The following attestation bundles were made for python_analyst_utility-0.1.6.tar.gz:
Publisher:
release.yml on AroshaJ/python-analyst-utility
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
python_analyst_utility-0.1.6.tar.gz -
Subject digest:
45aa0bf5d872440831bec23aabc597b5876ac136b9c5cc0f9a70f588854ff8db - Sigstore transparency entry: 157508919
- Sigstore integration time:
-
Permalink:
AroshaJ/python-analyst-utility@ce3f388de886a12a8d2a914b61fbb2bf6c76462c -
Branch / Tag:
refs/tags/0.1.6 - Owner: https://github.com/AroshaJ
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@ce3f388de886a12a8d2a914b61fbb2bf6c76462c -
Trigger Event:
push
-
Statement type:
File details
Details for the file python_analyst_utility-0.1.6-py3-none-any.whl.
File metadata
- Download URL: python_analyst_utility-0.1.6-py3-none-any.whl
- Upload date:
- Size: 25.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.0.1 CPython/3.12.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
78db2b32ea8d1ec2554d37fc26899335b7a051c3d916c6375feee997a420751c
|
|
| MD5 |
a1b0a0e307e2188063f80d9f102901c1
|
|
| BLAKE2b-256 |
5500f952e80227c92f6d3603b642afffc720436b8361742ff153c37938d9bf7c
|
Provenance
The following attestation bundles were made for python_analyst_utility-0.1.6-py3-none-any.whl:
Publisher:
release.yml on AroshaJ/python-analyst-utility
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
python_analyst_utility-0.1.6-py3-none-any.whl -
Subject digest:
78db2b32ea8d1ec2554d37fc26899335b7a051c3d916c6375feee997a420751c - Sigstore transparency entry: 157508920
- Sigstore integration time:
-
Permalink:
AroshaJ/python-analyst-utility@ce3f388de886a12a8d2a914b61fbb2bf6c76462c -
Branch / Tag:
refs/tags/0.1.6 - Owner: https://github.com/AroshaJ
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@ce3f388de886a12a8d2a914b61fbb2bf6c76462c -
Trigger Event:
push
-
Statement type: