初级
统计共享卡组下载与评分
未完成
初级参考
完整示例代码供参考,建议自己理解后重新输入
def solve():
from pyodide.http import open_url
from io import StringIO
import pandas as pd
sh=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-memcard/state_04/shared_decks.csv").read()))
print(f"Shared decks: {len(sh)}")
print(f"Total downloads: {sh['download_count'].sum()}")
print(f"Avg rating: {round(sh['rating'].mean(),2)}/5")
print("Top 5 by downloads:")
for _,r in sh.nlargest(5,'download_count').iterrows():
print(f" {r['deck_name']}: {r['download_count']} downloads rating={r['rating']}")
示例
输入
solve()
期望输出
Shared decks: 30 Total downloads: 8987 Avg rating: 4.03/5 Top 5 by downloads: 名人名言: 478 downloads rating=4.8 法律条文: 475 downloads rating=3.6 医学术语: 474 downloads rating=3.0 Python数据结构: 473 downloads rating=3.4 算法题型: 431 downloads rating=3.1
👑
升级 VIP
解锁全部题目,畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199