Skills Guide

App Review Analyzer

VerifiedSafe

Analyzes app store review CSV data containing id, date, user_name, title, content, rating, and app_version columns. Generates visualizations such as rating distribution, monthly trends, and version ratings, along with keyword analysis for positive and negative reviews. Useful for understanding user satisfaction, tracking app quality over time, and identifying issues in specific versions.

Download and use
Sby Skills Guide Bot
Data & AIIntermediate
6/2/2026
Claude Code
#app-review#csv-analysis#visualization#data-insights

Recommended for

Claude CodeData scientistData & analysis

Automated summary

Analyzes app store review CSV data to generate visualizations and insights such as rating distribution, trends over time, version-wise performance, and keyword extraction.

Strengths

  • Provides comprehensive visualizations (distribution, trend, version) for quick understanding.
  • Identifies keywords from negative and positive reviews.
  • Generates an automated analysis report.
  • Tracks rating evolution over time and by version.

Limitations

  • Requires a strict CSV format with specific columns.
  • Analysis limited to ratings and keywords, no advanced NLP.
  • Depends on Python environment with libraries like matplotlib and pandas.
When to use it

Use this skill to quickly analyze a CSV file of app store reviews to understand user satisfaction, trends, and common issues.

When not to use it

Do not use it for real-time analysis or if the CSV does not follow the required format or if the Python environment lacks necessary dependencies.

Security analysis

Safe
Quality score85/100

The skill instructs running a local Python script for CSV data analysis. There are no network requests, no destructive commands, and no obfuscated payloads. The script operates on user-provided files locally, posing minimal risk.

No concerns found

How this analysis is made

Examples

Analyze reviews CSV
I have a CSV file of app store reviews. Please analyze it using the app review analyzer skill. The file is at /path/to/reviews.csv
Generate review trends
Can you generate a rating distribution and monthly trend graph from my app reviews CSV? File: reviews.csv
Version-wise analysis
Analyze the app reviews CSV and show me average rating per app version and negative keywords.

name: app-review-analyzer description: アプリストア レビュー CSV データを分析して視覚化するスキル。ユーザーがアプリストア レビュー CSV ファイルを提供するか レビュー 分析を要求する時に使用する。CSV は id, date, user_name, title, content, rating, app_version 列を含まなければならない。 doc_contract: review_interval_days: 90

App Review Analyzer

Overview

アプリストア レビュー CSV データを分析してグラフで視覚化するスキル。評点 分布、時間別 トレンド、バージョン別 評点、主要 キーワード 等を分析する。

CSV データ 形式

分析 対象 CSV は 次の 列を含まなければならない:

| 列 | タイプ | 説明 | | ----------- | ------------- | ----------------------------- | | id | integer | レビュー 固有 ID | | date | datetime | 作成 日時 (タイムゾーン 含む) | | user_name | string | ユーザー名 | | title | string | レビュー タイトル | | content | string | レビュー 内容 | | rating | integer (1-5) | 評点 | | app_version | string | アプリ バージョン |

分析 ワークフロー

Step 1: CSV ファイル ロード および 検証

  1. ユーザーが 提供した CSV ファイル パス 確認
  2. scripts/analyze_reviews.py スクリプト 実行
  3. データ 形式 検証 および 基本 統計 出力

Step 2: 分析 実行

スクリプトを 実行して 次の 分析を 実行する:

python3 /path/to/skill/scripts/analyze_reviews.py <csv_path> <output_dir>

Step 3: 結果 解釈

生成された グラフと 統計を 元に インサイトを 提供する:

  • 評点 分布: 全般的な ユーザー 満足度 把握
  • 時間別 トレンド: アプリ 品質 変化 推移
  • バージョン別 評点: 特定 バージョンの 問題点 識別
  • 否定 レビュー 分析: 主要 不満 事項 把握

分析 項目

1. 基本 統計

  • 総 レビュー 数
  • 平均 評点
  • 評点別 分布

2. 視覚化 グラフ

  • 評点 分布 棒 グラフ
  • 月別/週別 レビュー トレンド
  • バージョン別 平均 評点
  • 評点別 レビュー 数 パイ チャート

3. テキスト 分析

  • 否定 レビュー (1-2点) 主要 キーワード
  • 肯定 レビュー (4-5点) 主要 キーワード

Resources

scripts/

analyze_reviews.py - レビュー 分析 および 視覚化 スクリプト

使用法:

python3 scripts/analyze_reviews.py <csv_path> [output_dir]
  • csv_path: 分析する CSV ファイル パス
  • output_dir: グラフ 保存 ディレクトリ (デフォルト値: CSV ファイルと 同じ ディレクトリ)

出力 ファイル:

  • rating_distribution.png: 評点 分布 グラフ
  • monthly_trend.png: 月別 レビュー トレンド
  • version_rating.png: バージョン別 平均 評点
  • analysis_report.txt: 分析 要約 レポート

From the file to a first result

The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.

View the source and supporting files

This download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.

1. Download the file

Download SKILL.md

From the root of a test project, save the file as .skill-downloads/app-review-analyzer-mm5t8acu/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.

Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.

mkdir -p '.skill-downloads/app-review-analyzer-mm5t8acu' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/app-review-analyzer-mm5t8acu/download' --output '.skill-downloads/app-review-analyzer-mm5t8acu/SKILL.md.part' && mv '.skill-downloads/app-review-analyzer-mm5t8acu/SKILL.md.part' '.skill-downloads/app-review-analyzer-mm5t8acu/SKILL.md'

2. Check prerequisites

Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.

No recognized prerequisites section in this file. This does not mean it is self-contained: libraries, tools and access requirements may be mentioned elsewhere in the content or source repository.

The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.

3. Load the skill

After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.

Claude Code
test -f '.skill-downloads/app-review-analyzer-mm5t8acu/SKILL.md' && test -s '.skill-downloads/app-review-analyzer-mm5t8acu/SKILL.md' && mkdir -p '.claude/skills' && test ! -e '.claude/skills/app-review-analyzer' && cp -R '.skill-downloads/app-review-analyzer-mm5t8acu' '.claude/skills/app-review-analyzer'

OpenSkills

OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.

Official OpenSkills installation
openskills install './.skill-downloads/app-review-analyzer-mm5t8acu'

openskills read 'app-review-analyzer-mm5t8acu'

Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.

For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.

openskills sync

Manual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.

4. Try a first task

Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:

Read .skill-downloads/app-review-analyzer-mm5t8acu/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.

Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.

Related skills

Create Interactive Maps with kepler.gl

Data & AI

Create interactive map visualizations and export standalone HTML using the keplergl Python package. Use to plot geospatial data from DataFrames, GeoJSON, or CSV.

Claude CodeCursorCodexintermediateSafe 11,995
Skills Guide Bot

Agent-Driven Parameter Optimization

Data & AI

Guide for optimizing configurable systems with a measurable objective, using bounded trials and evidence-based recommendations.

Claude CodeCursorCodexintermediateSafe 45,609
Skills Guide Bot

ICP Visitor Outreach

Data & AI

Identify signed-up users matching the ideal customer profile but stalled, and draft personalized outreach to re-engage them.

Claude CodeintermediateSafe 6,843
Skills Guide Bot