strip-spreadsheet
This tool is for working with spreadsheets. It cleans the spreadsheet off of any rows that have blank data in them and removes extra-spaces.
Installation
This is OS independent, meaning it won't need a specific Os to run on.
You can install the strip-spreadsheet package simply by running:
pip install strip-spreadsheet
Sample Code
from strip_spreadsheet import clean_sheet
# open the dirty sheet as a readable file
with open('x.csv', 'r') as dirty_sheet:
# put all the rows in the sheet in a list
unclean_sheet = dirty_sheet.readlines()
# open the file wanna save the cleaned sheet to
with open('x_cleaned.csv', 'w') as cleaned_up_sheet:
# clean the unclean sheet and write the output to the new file we created
cleaned_up_sheet.writelines(clean_sheet(unclean_sheet))
Metadata
Release files for strip-spreadsheet 1.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| strip-spreadsheet-1.0.0.tar.gz | 1.8 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| strip_spreadsheet-1.0.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 4.6 kB
Release files / strip-spreadsheet-1.0.0.tar.gz
| Download URL | strip-spreadsheet-1.0.0.tar.gz |
|---|---|
| Size | 1.8 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
9724e5aa4b7047014912799b42201ff13baa1cb28ffb5f433ccd799d17c3dc75
|
|
BLAKE2b-256 checksum How to use checksums |
79d88687fd0c66ddccc6108ae8e73b237adcf9fb82c14175c5e1f66cd68344fe
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.22.0 requests-toolbelt/0.9.1 tqdm/4.61.1 CPython/3.8.5
|
Release files / strip_spreadsheet-1.0.0-py3-none-any.whl
| Download URL | strip_spreadsheet-1.0.0-py3-none-any.whl |
|---|---|
| Size | 2.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
4196010921059faf4dd780e43990f9445fe7d245c740c00efbeae2ba0f313be1
|
|
BLAKE2b-256 checksum How to use checksums |
652b93d3c9812119e4af80aaa0a1259a39841b74b55bb14c8ce1c53d22355504
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.22.0 requests-toolbelt/0.9.1 tqdm/4.61.1 CPython/3.8.5
|
Security for strip-spreadsheet 1.0.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.