Keyword Counter

😫 The Pain Point

You have 50 product reviews and want to know how often “quality”, “price”, “delivery” are mentioned. Reading and counting manually is tedious.

🚀 Agentic Solution

A Keyword Frequency Analyzer for text data.

Key Features:

• Multi-File Support: Scan multiple documents.
• Case Insensitive: Count “Quality” and “quality” together.
• Export Stats: CSV with file, keyword, count.

⚔️ Phase 1: Commander (Quick Fix)

For quick counting.

Prompt:

“I have an Excel reviews.xlsx with column ‘Review_Text’. Write a Python script to:

1. Keywords: Count occurrences of ‘quality’, ‘price’, ‘delivery’, ‘service’.
2. Case Insensitive: Treat all variations equally.
3. Output: Summary table with keyword counts.

Print total counts and per-row breakdown.”

Result: Quantified feedback insights.

🏗️ Phase 2: Architect (Permanent Tool)

Engineering Prompt:

**Role:** Python Tool Developer
**Task:** Create a "Keyword Analyzer".

**Requirements:**
1.  **GUI:**
    *   Select Excel/text files.
    *   Keyword input (comma-separated).
    *   Options: Case sensitive, Whole word.
    *   Results table with counts.
    *   Export button.

2.  **Logic:**
    *   Handle multiple columns.
    *   Support regex patterns.
    *   Calculate percentages.

3.  **Deliverables:**
    *   `keyword_counter.py`
    *   `run.bat`, `run.sh`
    *   `requirements.txt`

🧠 Prompt Decoding

• Whole Word: Match “price” but not “prices” or “priced”.

🛠️ Instructions

1. Copy Prompt → Add keywords → Run.