How gowthamr1225/google_reviews-analyzing works
Purpose
This repository is a business-review analytics prototype that turns Google Maps-style customer reviews into sentiment, themes, trends, reputation signals, and operational recommendations. It is oriented around an interactive dashboard and an exploratory notebook workflow.
Entry Points
• app.py is the likely application/dashboard entry point for serving the analyzer experience.
• BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb is the primary exploratory or development workflow for data preparation, analysis, and model experimentation.
• README.md defines the intended six-stage review-analysis product behavior.
Review Data Layer
The system works from locally stored review datasets rather than a live ingestion service in this repository:
• reviews.xlsx
• reviews.pkl
• reviews_clean.parquet
The parallel cleaned exports (reviews_clean.parquet, reviews_clean.xlsx) form the likely boundary between raw/extracted reviews and downstream NLP/dashboard consumption.
NLP and Insight Pipeline
The intended analysis flow is: review text → preprocessing → sentiment classification → thematic categorization → trend/reputation aggregation → LLM-generated recommendations. The notebook is the most likely location for implementing or validating these stages:
• BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb
• reviews_clean.parquet
Outputs are business-facing insights rather than only per-review labels: recurring complaints, strengths, service/pricing/staff themes, temporal trends, and reputation scoring.
LLM Recommendation Boundary
Recommendation generation is designed to be separated from deterministic review processing. The README identifies Langflow, Groq API, Hugging Face models, prompt engineering, and transformer-based NLP as the AI stack. This creates an external-service boundary: cleaned/aggregated review evidence is passed into model workflows, which return summaries and tailored business actions.
• README.md
• app.py
Dashboard and Presentation
The presentation layer is intended to provide interactive decision support, with Streamlit or Gradio named as the frontend runtime. It should consume analyzed review data and generated insights to expose sentiment, themes, trends, reputation scores, and recommendations.
• app.py
• reviews_clean.xlsx
External Data and Infrastructure
SerpAPI is the stated upstream source for Google Maps review extraction, but no dedicated ingestion module is present in the repository tree. The current checked-in datasets therefore act as the operational data source. Groq and Hugging Face represent external model dependencies; Langflow is the stated workflow/orchestration environment.
Main entry points: BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb Review preprocessing · app.py Interactive dashboard · reviews_clean.parquet Clean review data · README.md Six-stage product behavior
Components 15
Review Data
Local datasets are the operational input boundary.
- SerpAPI / Google Maps · Stated upstream extraction source; no ingestion module is present.
- Raw reviews workbook
reviews.xlsx - Raw reviews pickle
reviews.pkl - Clean review data · Primary machine-readable boundary for downstream NLP.
reviews_clean.parquet - Clean review workbook · Dashboard-friendly cleaned export.
reviews_clean.xlsx
Analysis Pipeline
Notebook-driven deterministic review analysis.
- Analysis notebook · Primary development and model-experiment workflow.
BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb - Review preprocessing
BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb - Sentiment classification
BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb - Theme categorization · Identifies service, pricing, staff, strengths, and complaints.
BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb - Trends & reputation · Builds temporal trends, recurring signals, and reputation scores.
BUSINESS REPUTATION & INSIGHTS ANALYZER.ipynb
AI Recommendations
External model workflow produces business actions.
- Langflow model workflow · Separates recommendation generation from deterministic analysis.
README.md - Groq & Hugging Face
- Business recommendations · Tailored summaries and operational actions.
app.py
Decision Support
Interactive dashboard exposes findings.
- Interactive dashboard · Presents sentiment, themes, trends, scores, and recommendations.
app.py
Other components
- Six-stage product behavior
README.md
Connections 18
- SerpAPI / Google Maps → Raw reviews workbook: intended extraction
- Raw reviews workbook → Review preprocessing: review text
- Raw reviews pickle → Review preprocessing: alternate source
- Review preprocessing → Clean review data: cleaned export
- Review preprocessing → Sentiment classification: normalized reviews
- Clean review data → Sentiment classification: downstream input
- Sentiment classification → Theme categorization: labeled reviews
- Theme categorization → Trends & reputation: theme evidence
- Trends & reputation → Langflow model workflow: aggregated evidence
- Langflow model workflow → Groq & Hugging Face: model calls
- Groq & Hugging Face → Business recommendations: generated actions
- Trends & reputation → Interactive dashboard: scores and trends
- Business recommendations → Interactive dashboard: business actions
- Clean review workbook → Interactive dashboard: cleaned review data
- Clean review data → Clean review workbook: parallel export
- Six-stage product behavior → Analysis notebook: defines intended flow
- Analysis notebook → Review preprocessing: implements and validates
- Six-stage product behavior → Interactive dashboard: defines experience