ASD's ROTE

CSV OR Excel File

Text Column to Analyze

HTML Column (optional)

If provided, embedded links and tweets will be extracted using XPath. Requires lxml.

Filter (optional)

Only rows whose text contains the terms will be analyzed. Separate terms with commas or new lines.

Filter Logic

Treat terms as regular expressions

Group-By Column (optional)

Analysis Options

Enable tokens & term frequencies

Enable entities (spaCy)

If disabled, entity extraction is skipped and spaCy is not loaded.

Enable sentiment

Extract social media profiles

Parses URLs in text to capture Platform:Handle pairs.

Extract key phrases (KeyBERT)

Uses KeyBERT to extract meaningful phrases from text.

Enrich rows only (no summaries)

Adds derived columns and skips summary tables. CSV exports always use the enriched rows.

Lexical/Sentiment Analysis