RenfeiZhong

Clean Skill

数据分析v1.1.0
作者:RenfeiZhong更新于 2026-05-17clean-skill@clawhub_zhongrenfei1-hub/clean-skill
数据洞察竞品分析

据 AlphaMoat 统计,截至 2026-09,Clean Skill 累计下载 1,880 次、获 0 个星标,在全部 5,078 个 AI 技能中排名第 4,514 位,在「数据分析」分类(399 个)中排名第 350 位。

累计安装
187
累计下载
1,880
星标
-
全站排名
#4,514
全站前 89% · 「数据分析」前 88%
平台累计安装累计下载星标评论
ClawHub ↗401,389--
SkillHub ↗1871,880-—

各平台的计数口径不同,统计时间不一致。

这个技能是做什么的

它按地点和菜系收集两个平台的内容,并尝试匹配同一家餐厅,再比较评分、互动和情绪信号的一致性。主文说明两平台数据来自网页抓取,且小红书没有公开 API;结果应展示平台差异与需要人工复核的情况。

资料发布于 2026-10-27

可以用来做什么

  • 按地点和菜系整理两个平台的餐厅信息
  • 比较跨平台评分与评价信号并标出差异

什么时候用

  • 需要对照小红书与大众点评的餐厅推荐时
  • 希望在查看推荐时同时了解来源差异或待核实项时

示例提示词

以下是根据技能文档生成的示例,不代表实际运行结果。

按所在区域和菜系整理两个平台的餐厅信息,并列出差异
比较这家餐厅在两个平台上的评价信号,标出需要人工确认的部分

月度数据趋势

累计下载1,880
5811,2791,9762026-03 · 累计下载 6772026-05 · 累计下载 9942026-07 · 累计下载 1,2472026-08 · 累计下载 1,4192026-09 · 累计下载 1,88026-0326-09
星标-
0112026-03 · 星标 -2026-05 · 星标 -2026-07 · 星标 -2026-08 · 星标 -2026-09 · 星标 -26-0326-09

2026-09 起统计方法调整:同名技能按作者分别统计,并覆盖全部技能。图中虚线为调整前的月份,与之后的数据不直接比较,也不计算跨越调整的增长。 该技能有同名的其他版本,调整前的数据归属当前下载量最大的这一个。

月份累计下载环比星标
2026-091,880—-
2026-081,419+13.8%-
2026-071,247—-
2026-05994—-
2026-03677—-

SKILL.md 原文

以下是作者发布的原始文件,按纯文本显示,本站未做修改或审核;其中的链接不可点击,命令请核实后再运行。抓取于 2026-10-23。

5.4 KB · ClawHub v1.1.0
---
name: restaurant-crosscheck-v2
description: Cross-reference restaurant recommendations from Xiaohongshu (小红书) and Dianping (大众点评) to validate restaurant quality and consistency. Use when querying restaurant recommendations by geographic location (city/district) to get validated insights from both platforms. Automatically fetches ratings, review counts, and analyzes consistency across platforms to provide trustworthy recommendations with confidence scores.
---

# Restaurant Review Cross-Check

Cross-reference restaurant data from Xiaohongshu and Dianping to provide validated recommendations.

## Quick Start
展开全部(共 188 行)

Query restaurants by location and cuisine type:

```bash
# Basic query
crosscheck-restaurants "上海静安区" "日式料理"

# With filters
crosscheck-restaurants "北京朝阳区" "火锅" --min-rating 4.5 --min-reviews 100
```

## Workflow

### 1. Data Collection

Query both platforms simultaneously:

**Dianping:**
- Fetch restaurants matching location + cuisine
- Extract: name, rating, review_count, price_range, address, tags

**Xiaohongshu:**
- Search notes/posts matching location + cuisine
- Extract: restaurant_name, engagement_metrics (likes/saves), sentiment_score
- Note: Xiaohongshu data requires scraping as no public API

### 2. Data Matching

Match restaurants across platforms using fuzzy matching:

- Restaurant name similarity (Levenshtein distance)
- Location proximity (address matching)
- Handle name variations (e.g., "银座寿司" vs "银座寿司静安店")

See [scripts/match_restaurants.py](scripts/match_restaurants.py) for matching logic.

### 3. Consistency Analysis

Calculate consistency score based on:

- **Rating correlation** (0-1): Correlation between platform ratings
- **Engagement validation** (0-1): Do high ratings correlate with high engagement?
- **Sentiment alignment** (0-1): Do user sentiments align across platforms?

Formula: `consistency_score = (rating_corr * 0.5) + (engagement_val * 0.3) + (sentiment_align * 0.2)`

### 4. Recommendation Score

Calculate final recommendation score:

```
recommendation_score = (
    (dianping_rating * 0.4) +
    (xhs_engagement_normalized * 0.3) +
    (consistency_score * 0.3)
) * 10
```

Output: 0-10 scale, where >8.0 = high confidence recommendation

## Output Format

```
📍 [Location] [Cuisine Type] 餐厅推荐

1. [Restaurant Name]
   🏆 推荐指数: X.X/10
   ⭐ 大众点评: X.X (Xk评价)
   💬 小红书: X.X⭐ (X笔记)
   📍 地址: [Address]
   💰 人均: ¥[Price]
   ✅ 一致性: [高/中/低] - [Brief explanation]
   
   📊 平台对比:
   - 大众点评标签: [Tags]
   - 小红书热词: [Keywords]
   
   ⚠️ 注意: [Any discrepancies or warnings]

[Continue for top 5-10 restaurants...]
```

## Thresholds

- **Min rating**: 4.0/5.0 (configurable)
- **Min reviews**: 50 on Dianping, 20 notes on Xiaohongshu (configurable)
- **Max results**: Top 10 restaurants by recommendation score
- **High consistency**: Score > 0.7
- **Medium consistency**: Score 0.5-0.7
- **Low consistency**: Score < 0.5 (flag for manual review)

## API & Data Sources

### Dianping
- **Method**: Web scraping (Dianping API requires business partnership)
- **Base URL**: https://www.dianping.com
- **Rate limiting**: 1 request/2 seconds minimum
- **Anti-scraping**: Use residential proxies, rotate user agents

See [scripts/fetch_dianping.py](scripts/fetch_dianping.py) for implementation.

### Xiaohongshu
- **Method**: Web scraping (no public API)
- **Base URL**: https://www.xiaohongshu.com
- **Rate limiting**: 1 request/3 seconds minimum
- **Authentication**: Cookies required for full access

See [scripts/fetch_xiaohongshu.py](scripts/fetch_xiaohongshu.py) for implementation.

## Configuration

Edit `scripts/config.py` to set:

```python
DEFAULT_THRESHOLDS = {
    "min_rating": 4.0,
    "min_dianping_reviews": 50,
    "min_xhs_notes": 20,
    "max_results": 10
}

PROXY_CONFIG = {
    "use_proxy": True,
    "proxy_list": ["http://proxy1:port", "http://proxy2:port"]
}
```

## Error Handling

- **No matches found**: Suggest broader search terms or nearby areas
- **Platform timeout**: Retry with exponential backoff, max 3 attempts
- **Rate limiting detected**: Pause for 60 seconds, rotate proxy
- **Low confidence results**: Flag results with consistency < 0.5 for manual review

## Advanced Features

### Sentiment Analysis
Xiaohongshu posts use NLP to extract:
- Food quality mentions
- Service quality mentions
- Atmosphere mentions
- Price/value mentions

See [references/sentiment_analysis.md](references/sentiment_analysis.md) for methodology.

### Fuzzy Matching
Handle restaurant name variations:
- Chain stores (e.g., "海底捞火锅" vs "海底捞静安店")
- Abbreviations (e.g., "鼎泰丰" vs "鼎泰丰上海店")
- Translation differences

Uses `thefuzz` library for similarity scoring.

## Dependencies

```bash
pip install requests beautifulsoup4 pandas numpy thefuzz selenium lxml
```

See [scripts/requirements.txt](scripts/requirements.txt) for complete list.

## Troubleshooting

**Issue**: Xiaohongshu returns empty results
- **Solution**: Check if cookies expired, re-authenticate

**Issue**: Dianping blocks requests
- **Solution**: Reduce request rate, rotate proxies

**Issue**: Poor matching between platforms
- **Solution**: Adjust similarity threshold in `match_restaurants.py`

## References

- [Data schema documentation](references/data_schema.md)
- [Sentiment analysis guide](references/sentiment_analysis.md)
- [API limitations](references/api_limitations.md)

「数据分析」分类下的热门技能

AdMapix数据分析

AdMapix 的取数层:把广告与应用相关的查询转成接口调用,只回原始 JSON。

↓ 36.6万★ 304fly0pants
Tavily Search数据分析

走 Tavily 检索公开网页,返回带链接与摘要的结构化结果。

↓ 12.2万★ 286Xiaoran Li
Data Analysis数据分析

把数据库、表格与导出的原始数据变成可决策结论的数据分析技能。

↓ 10.1万★ 244Iván
Stock Analysis数据分析

用 Yahoo Finance 数据做股票与加密货币分析、组合跟踪的技能。

↓ 7.5万★ 299udiedrichsen
Stock Watcher数据分析

管理本地自选股清单,并按代码汇总同花顺行情与近期表现的技能。

↓ 6.5万★ 122Robin797860
全国招标中标查询及分析【知了标讯】数据分析

全网招中标数据查询与分析助手。当用户涉及以下任何场景时,必须使用此SKILL:查询招标/中标公告、搜索标讯、查找临期/即将到期项目、商机预测、推荐潜在投标供应商、分析公司主营业务/历史中标、查询公司上下游合作客户与供应商、分析竞争对手/竞对企业、查询Top采购单位/Top中标单位/Top中标品牌、招中标数据统计分析(按月/季/年/省份/品牌等维度)、查询品牌型号历史中标单价/价格趋势、市场分析/行业分析/采购寻源/渠道拓展等采购与投标相关场景。即使用户没有提到「知了标讯」,只要涉及招投标、采购、中标、供应商、竞争对手等关键词,都应使用本SKILL。

↓ 5.6万★ 13user_98035bfb
Blogwatcher数据分析

用命令行监控博客与 RSS/Atom 源的更新。

↓ 5.4万★ 75Peter Steinberger
Model Usage数据分析

汇总 Codex 或 Claude 按模型计费的使用成本。

↓ 5.0万★ 114Peter Steinberger

数据月份:2026-09 · 下载/星标/安装数聚合自公开技能注册库(ClawHub、SkillHub),按月更新。口径说明见数据方法。