现排名

Preparing analysis template

I'm looking to create a concise template for analyzing metrics. It should include a metrics table, a trend chart, and focus on four key factors like lineup adjustments and schedule strength. I want to keep it direct, so I'll provide a couple of options right away:

  1. A brief Chinese news title with a summary (120-200 characters).
  2. An outline for a longer article.
  3. Variants of social media posts.
  4. ![RBFTR](/assets/images/32246E5D.PNG)
  5. An analytical breakdown with KPIs, including formulas.

Additionally, I’ll include a Python code snippet for computing ORtg/DRtg/net ratings based on game logs. I can also suggest some visualization ideas. I should check: which team are we focusing on?

这是在做战报/稿件吗,还是想要数据分析/可视化?告知联赛、球队、时间范围和是否有原始数据(比赛日志/技术统计),我可以定制。先给你几种可直接用的选项:

  1. 标题与导语(新闻风)
  1. 社媒短文文案(可选其一)
  1. 分析要点清单(教练/数据回顾会用)
  1. 指标计算公式(无跟踪数据时的简化版)
  1. Python 计算小脚本(有逐场箱线表即可用)
import pandas as pd

# df: 每场一行,需列: FGA, ORB, TOV, FTA, PTS, OPP_FGA, OPP_ORB, OPP_TOV, OPP_FTA, OPP_PTS, date/team 可选
def ratings(df):
    poss = df.FGA - df.ORB + df.TOV + 0.44 * df.FTA
    opp_poss = df.OPP_FGA - df.OPP_ORB + df.OPP_TOV + 0.44 * df.OPP_FTA
    df = df.assign(
        poss=poss,
        opp_poss=opp_poss,
        ORtg=100 * df.PTS / poss,
        DRtg=100 * df.OPP_PTS / opp_poss,
    )
    df["NetRtg"] = df["ORtg"] - df["DRtg"]
    return df

![ts](/assets/images/E46B6321.jpg)

# 示例滚动窗口趋势
# ratings(df).sort_values("date").rolling(5, min_periods=3)[["ORtg","DRtg","NetRtg"]].mean()

需要我:

  1. 直接产出一版完整战报/新闻稿;
  2. 给你的数据跑一版指标和趋势图;
  3. 做一页赛后复盘要点和改进建议;
  4. 定制化社媒海报文案与标题; 选一个编号,或把球队/赛段/数据源发我。