Skip to main content

Automate cleaning NBA projection sheets.

Project description

NBA Sheet Cleaner

Utility for cleaning NBA projection spreadsheets.

Usage

Default behavior

nba-sheet-clean
  • If sheets/ exists alongside main.py, every Excel file from that folder (recursively) is processed.
  • Otherwise, it falls back to the current directory.
  • Cleaned files are written to <source>/sheets_cleaned/ using the <name>_cleaned.<ext> naming convention.

Custom folder

nba-sheet-clean path/to/folder

Processes only the Excel files found inside path/to/folder and writes results to path/to/folder/sheets_cleaned.

Single file

nba-sheet-clean path/to/file.xlsx

Processes only that Excel file and writes the cleaned version to path/to/sheets_cleaned/file_cleaned.xlsx.

Notes

  • Files ending with _cleaned are automatically skipped.
  • The script requires the columns Name, Team, p, 3, r, a, s, b. Missing columns cause the file to be skipped with a log message.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

nba_sheet_cleaner-0.1.0.tar.gz (3.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

nba_sheet_cleaner-0.1.0-py3-none-any.whl (4.0 kB view details)

Uploaded Python 3

File details

Details for the file nba_sheet_cleaner-0.1.0.tar.gz.

File metadata

  • Download URL: nba_sheet_cleaner-0.1.0.tar.gz
  • Upload date:
  • Size: 3.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.13.7

File hashes

Hashes for nba_sheet_cleaner-0.1.0.tar.gz
Algorithm Hash digest
SHA256 033777b870dc8fa100dc7fb9634e598de69d7df76420b70f5d25cc5c44973c58
MD5 1815a6ae0a808d494ccc277a8dacc207
BLAKE2b-256 da9d09ca69bba57efb907235e1756eda01d7daed8143d498aef400e2e9b6e7eb

See more details on using hashes here.

File details

Details for the file nba_sheet_cleaner-0.1.0-py3-none-any.whl.

File metadata

File hashes

Hashes for nba_sheet_cleaner-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 891045068bbf7f8a2464abe4a8480871cc99d4559ee716d7c5bb182e930c7eaf
MD5 2a264b027d3d3273d9f2dfd3e53a6d3e
BLAKE2b-256 df0e54c048089337f0fc7c4475ca6fadcae17dbca9b023eb3efd494881cffcf1

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page