Strip a spreadsheet of extra spaces and blank-celled rows
Project description
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))
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
Close
Hashes for strip_spreadsheet-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4196010921059faf4dd780e43990f9445fe7d245c740c00efbeae2ba0f313be1 |
|
MD5 | 19e693d4bc5ac47cee240ab4225282ec |
|
BLAKE2b-256 | 652b93d3c9812119e4af80aaa0a1259a39841b74b55bb14c8ce1c53d22355504 |