๐Ÿ“Š

Keyword Counter

Analyze a large text file or thousands of customer reviews to find the most frequent keywords/topics.

Excel โญ Beginner โฑ๏ธ 3 minutes

๐Ÿ˜ซ The Pain Point

You have 1,000 feedback comments. You want to know what customers are talking about most? โ€œGoodโ€, โ€œExpensiveโ€, โ€œBrokenโ€, or โ€œSlowโ€? Reading 1,000 comments manually is impossible.

๐Ÿš€ Agentic Solution

Text Miner: Breaks down sentences into words, counts them, and visualizes the data.

Key Features:

  • Stopwords: Automatically removes filler words like โ€œtheโ€, โ€œisโ€, โ€œandโ€.
  • Word Cloud: Generates a visual cloud where bigger words = more frequent.

โš”๏ธ Phase 1: Commander (Quick Fix)

For a quick pulse check.

Prompt:

โ€œI have reviews.txt. Count the frequency of each word, ignoring common English stopwords. Print the top 10 most used words.โ€

Result: Top 10 buzzwords.

๐Ÿ—๏ธ Phase 2: Architect (Permanent Tool)

For Content/SEO Strategists.

Engineering Prompt:

**Role:** Python NLP Processor
**Task:** Create a "Keyword Frequency Analyzer".
**Requirements:**
1.  **GUI:**
    *   Input Text box OR Upload .txt file.
    *   "Analyze" button.
2.  **Logic:**
    *   Tokenize text.
    *   Remove English Stopwords (use `nltk` or a hardcoded list).
    *   Count frequency using `collections.Counter`.
    *   Display Top 20 keywords in a Table.
    *   *Bonus:* Generate a WordCloud image.
3.  **Deliverables:** `keyword_tool.py`, `run.bat` (Windows), `run.sh` (Mac).

๐Ÿง  Prompt Decoding

  • Stopwords: Without removing โ€œstopwordsโ€ (the, is, at), your top 10 list would be useless. The prompt ensures meaningful analysis by filtering the noise.

๐Ÿ› ๏ธ Instructions

  1. Copy Prompt -> Paste -> Run.
  2. Paste Text -> Analyze.

Related Workflows

Explore other categories

๐Ÿ“ฌ

Get Started with Agentic Working

Subscribe to receive updates from AgenticWorking.io

๐Ÿ“– Free eBook Guide ๐Ÿ“ฆ 7 Ready-to-use Scripts ๐Ÿ”” Weekly Tips

No spam, unsubscribe anytime. Join 1,000+ subscribers.