The Excel Ngrams Project
A project to analyse a column of text in an Excel document and return a CSV file with the most common ngrams from that text. Output file is returned to the same directory as the input file.
You can choose the maximum n-gram length, and maximum number of results (rows) returned. The app defaults to looking for a column named'Keyword' but any column name can be passed in as an argument.
The column of terms to analyse must be the longest (or only) column in the document to prevent the addition of NaN as a placeholder in final cells, which will cause errors.
Words are tokenised with Spacy and ngrams are generated with NLTK.
Installation
To install the Excel Ngrams Project, run this command in your terminal:
$ pip install excel-ngrams
Metadata
Release files for excel-ngrams 0.2.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 | |
|---|---|---|---|
| excel-ngrams-0.2.0.tar.gz | 6.9 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| excel_ngrams-0.2.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 14.2 kB
Release files / excel-ngrams-0.2.0.tar.gz
| Download URL | excel-ngrams-0.2.0.tar.gz |
|---|---|
| Size | 6.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e63257f8b938b62c296f87c7b1896c32d0a8d2d4793dd318a0d12930ab5942a8
|
|
BLAKE2b-256 checksum How to use checksums |
42bf48062a143dbce53dc9ccc4d17a0135d0e10bd9f93de71d0dc3e521a3e6b8
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.4 CPython/3.9.1 Linux/5.4.0-1039-azure
|
Release files / excel_ngrams-0.2.0-py3-none-any.whl
| Download URL | excel_ngrams-0.2.0-py3-none-any.whl |
|---|---|
| Size | 7.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
6e9e0f5c62bc75739c2f0bd621dbd3d081fb6ab7867cc8495e73ae1347a6cd2b
|
|
BLAKE2b-256 checksum How to use checksums |
305c28f0437cb0dc1c60fba5031cca7a04aab62f7596dbc682929efd423630cb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.4 CPython/3.9.1 Linux/5.4.0-1039-azure
|