Skip to main content

:warning: This repo has outdated tokens in its travisci config To make new releases for this project it needs to be moved to circleci

sheetwhat

PyPI version FOSSA Status

sheetwhat enables you to write Submission Correctness Tests (SCTs) for interactive Spreadsheet exercises on DataCamp.

Installing

pip install sheetwhat

Demo

Sheetwhat is typically used in a web application, but you can also experiment with its functions on your local machine. SCT functions that fail will throw a TestFail error.

# Setup: make all checking functions available
from sheetwhat.sct_syntax import SCT_CTX
globals().update(SCT_CTX)

# Setup: set up state with student data, solution data and SCT range
from sheetwhat.State import State
from protowhat.Reporter import Reporter
Ex.root_state = State(
    {'values': [["a", "a"]], "formulas": [["=B1"]]},
    {'values': [["b", "b"]], "formulas": [["=B1"]]},
    "A1",
    Reporter()
)

# Experiment interactively with SCTs
# Passes, as formulas at A1 match
Ex().has_equal_formula()

# Fails, as values at A1 do not match
Ex().has_equal_value()

Testing

pip install -r requirements.txt
pip install -e .
pytest

License

FOSSA Status

Metadata

Release files for sheetwhat 0.6.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sheetwhat 0.6.0
File Size Uploaded
sheetwhat-0.6.0.tar.gz 34.2 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for sheetwhat 0.6.0
File Interpreter ABI Platform
sheetwhat-0.6.0-py3-none-any.whl Python 3 none any Details

Total release size: 62.2 kB

Release files / sheetwhat-0.6.0.tar.gz

Download URL sheetwhat-0.6.0.tar.gz
Size 34.2 kB
Tags Source
SHA-256 checksum
How to use checksums
bb800cd4dd0806ba9ae170d8351bd1512a46f469bceca28de6724066cbf81b73
BLAKE2b-256 checksum
How to use checksums
e14727d6dc3a08b1b86ac253d3cde3552ba5e204281a4fa6facd216f56fe7ff1
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.12.11

Release files / sheetwhat-0.6.0-py3-none-any.whl

Download URL sheetwhat-0.6.0-py3-none-any.whl
Size 28.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
35037f0b4353200cf2ec648b68390a7f522dc0a8aacc4a70767f5317bc6f9170
BLAKE2b-256 checksum
How to use checksums
12bc01198f0c9c94e1b8dc29965cee8566239d9231bd49cacc2a8e484ddcbbe4
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.12.11

Release history Release notifications | RSS feed

This release

0.6.0 This release

2 release files

0.5.3

1 release file

0.5.2

1 release file

0.5.1

1 release file

0.5.0

1 release file

0.4.0

1 release file

0.3.0

1 release file

0.2.0

1 release file

0.1.9

1 release file

0.1.8

1 release file

0.1.6

1 release file

0.1.5

1 release file

0.1.4

1 release file

0.1.3

1 release file

0.1.2

1 release file

0.1.1

1 release file

0.1.0

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page