When we search for ordinary written documents, we send words into a search engine and get pages of words back.
What if we could search for spreadsheets by sending spreadsheets into a search engine and getting spreadsheets back? The order of the results would be determined by various specialized statistics; just as we use PageRank to find relevant hypertext documents, we can develop other statistics that help us find relevant spreadsheets. Read more here
Indexing
To index a new spreadsheet, run this.
, --index [csv file]
For example,
, --index /home/tlevine/Math Scores 2009 Copy (1).csv \ http://opendata.comune.bari.it/storage/f/2013-09-02T163858/2012_comune_assessori.csv
Caches from the indexing process are stored in the ~/., directory.
By default, CSV files that have already been indexed will be skipped; to index the same CSV file again, run with the --force or -f option.
, --index --force [csv file]
Once you have indexed a bunch of CSV files, you can search.
, [csv file]
You’ll see a bunch of data tables as results.
$ , 'Math Scores 2009.csv' /home/tlevine/math-scores-2010-gender.csv /home/tlevine/Math Scores 2009.csv /home/tlevine/Math Scores 2009 Copy (1).csv /home/tlevine/math-scores-2009-ethnicity.csv http://opendata.comune.bari.it/storage/f/2013-09-02T163858/2012_comune_assessori.csv mysql://bob:password@localhost/schools
To do
Add non-exact column matches so that there can be more matches.
Store distributions of values (collections.Counter objects) instead of just distinct values (set objects) so that I can run more interesting comparisons.
Store a preview of the table in the db or load it from the cache so that the web interface can show the preview.
Metadata
Release files for commasearch 0.0.3
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 | Actions |
|---|---|---|---|---|
| commasearch-0.0.3.tar.gz | 5.2 kB | Without provenance | Details for commasearch-0.0.3.tar.gz |
Release files / commasearch-0.0.3.tar.gz
| Download URL | commasearch-0.0.3.tar.gz |
|---|---|
| Size | 5.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
0acbb776bce8a31c5dd55c3f8b79aadff76336778710cf34c3f248872134e4d1
|
|
BLAKE2b-256 checksum How to use checksums |
f9a705e44ce79a21031234fc3aff18e2ffcfa62fe996378abe1694c8f9bdbd1c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Security for commasearch 0.0.3
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.
To learn more about protecting yourself from malicious actors, visit our package security documentation.