Skip to main content

Tests

codecov

PyPI

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

Excel-ngrams-usage

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)

Source distribution for excel-ngrams 0.2.0
File Size Uploaded
excel-ngrams-0.2.0.tar.gz 6.9 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for excel-ngrams 0.2.0
File Interpreter ABI Platform
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

Release history Release notifications | RSS feed

This release

0.2.0 This release

2 release files

0.1.2

2 release files

0.1.1

2 release files

0.1.0

2 release files

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