综合python案例，俱乐部高层施压有效吗？

wen python案例 2026-08-26 170

我来为你设计一个综合Python案例,分析俱乐部高层施压对球队成绩的影响，这个案例将整合数据分析、统计检验和可视化。

项目：足球俱乐部高层施压效果分析系统

数据生成与模拟

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
from scipy import stats
from datetime import datetime, timedelta
import warnings
warnings.filterwarnings('ignore')
# 设置中文显示
plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False
class FootballClubAnalyzer:
    """足球俱乐部高层施压效果分析系统"""
    def __init__(self, club_name="示例俱乐部"):
        self.club_name = club_name
        self.data = None
        self.pressure_events = []
    def generate_match_data(self, seasons=3, matches_per_season=38):
        """生成模拟比赛数据"""
        np.random.seed(42)
        dates = []
        results = []
        scores_for = []
        scores_against = []
        possession = []
        shots = []
        fans_attendance = []
        coach_pressure = []
        # 生成3个赛季的数据
        base_date = datetime(2021, 8, 1)
        for season in range(seasons):
            for match in range(matches_per_season):
                # 日期
                match_date = base_date + timedelta(days=match*7)
                dates.append(match_date)
                # 模拟比赛结果（考虑主场优势）
                home_advantage = 0.3 if match % 2 == 0 else -0.3
                team_strength = 0.5 + np.random.normal(0, 0.2)
                # 高层施压因素（赛季中后段施压增加）
                pressure_factor = 0
                if match > 25 and season > 0:
                    pressure_factor = 0.2
                # 比赛结果模拟
                score_diff = np.random.normal(team_strength + home_advantage + pressure_factor, 1.5)
                if score_diff > 0.5:
                    results.append('W')
                    scores_for.append(int(np.random.randint(1, 4)))
                    scores_against.append(int(np.random.randint(0, 2)))
                elif score_diff < -0.5:
                    results.append('L')
                    scores_for.append(int(np.random.randint(0, 2)))
                    scores_against.append(int(np.random.randint(1, 4)))
                else:
                    results.append('D')
                    scores_for.append(int(np.random.randint(0, 2)))
                    scores_against.append(int(np.random.randint(0, 2)))
                # 其他统计数据
                possession.append(np.random.normal(50, 8))
                shots.append(np.random.randint(8, 20))
                fans_attendance.append(np.random.randint(30000, 60000))
                # 高层施压指数（0-100）
                if match > 20 and results[-1] == 'L':
                    coach_pressure.append(np.random.randint(60, 90))
                elif match > 20 and results[-1] == 'W':
                    coach_pressure.append(np.random.randint(30, 50))
                else:
                    coach_pressure.append(np.random.randint(20, 70))
        # 创建数据框
        self.data = pd.DataFrame({
            '日期': dates,
            '赛季': [f'赛季{i+1}' for i in range(seasons) for _ in range(matches_per_season)],
            '轮次': list(range(1, matches_per_season+1)) * seasons,
            '结果': results,
            '进球': scores_for,
            '失球': scores_against,
            '控球率': possession,
            '射门数': shots,
            '上座率': fans_attendance,
            '施压指数': coach_pressure
        })
        # 计算积分
        points_map = {'W': 3, 'D': 1, 'L': 0}
        self.data['积分'] = self.data['结果'].map(points_map)
        return self.data
    def add_pressure_event(self, date, description, intensity):
        """添加高层施压事件"""
        self.pressure_events.append({
            'date': date,
            'description': description,
            'intensity': intensity
        })
        print(f"已添加施压事件: {date.strftime('%Y-%m-%d')} - {description}")
    def analyze_pressure_impact(self):
        """分析施压对成绩的影响"""
        if self.data is None:
            raise ValueError("请先生成数据")
        # 1. 整体统计分析
        print("\n=== 总体统计分析 ===")
        print(f"总比赛场次: {len(self.data)}")
        print(f"胜率: {(self.data['结果'] == 'W').mean()*100:.1f}%")
        print(f"平局率: {(self.data['结果'] == 'D').mean()*100:.1f}%")
        print(f"负率: {(self.data['结果'] == 'L').mean()*100:.1f}%")
        # 2. 按施压程度分组分析
        self.data['施压程度'] = pd.cut(self.data['施压指数'], 
                                       bins=[0, 30, 60, 100], 
                                       labels=['低施压', '中施压', '高施压'])
        group_stats = self.data.groupby('施压程度').agg({
            '积分': ['mean', 'sum'],
            '结果': lambda x: (x == 'W').mean(),
            '进球': 'mean',
            '失球': 'mean'
        }).round(2)
        print("\n=== 不同施压程度下的表现 ===")
        print(group_stats)
        # 3. 统计检验
        low_pressure = self.data[self.data['施压程度'] == '低施压']['积分']
        high_pressure = self.data[self.data['施压程度'] == '高施压']['积分']
        if len(low_pressure) > 0 and len(high_pressure) > 0:
            t_stat, p_value = stats.ttest_ind(low_pressure, high_pressure)
            print(f"\n=== 施压效果统计检验 ===")
            print(f"T统计量: {t_stat:.3f}")
            print(f"P值: {p_value:.4f}")
            if p_value < 0.05:
                print(" 高层施压对球队表现有显著影响")
            else:
                print(" 高层施压对球队表现无显著影响")
    def visualize_results(self):
        """可视化分析结果"""
        if self.data is None:
            raise ValueError("请先生成数据")
        fig, axes = plt.subplots(2, 2, figsize=(15, 10))
        fig.suptitle(f'{self.club_name} - 高层施压效果分析', fontsize=16, fontweight='bold')
        # 1. 施压指数与胜负关系
        ax1 = axes[0, 0]
        for result in ['W', 'D', 'L']:
            result_data = self.data[self.data['结果'] == result]['施压指数']
            ax1.hist(result_data, alpha=0.5, label=f'{result} (平均值: {result_data.mean():.1f})', bins=20)
        ax1.set_xlabel('施压指数')
        ax1.set_ylabel('比赛数量')
        ax1.set_title('施压指数与比赛结果关系')
        ax1.legend()
        # 2. 赛季成绩趋势
        ax2 = axes[0, 1]
        seasonal_data = self.data.groupby(['赛季', '轮次'])['积分'].sum().unstack(level=0)
        for season in seasonal_data.columns:
            cumulative_points = seasonal_data[season].cumsum()
            ax2.plot(cumulative_points.index, cumulative_points, marker='o', label=season, linewidth=2)
        ax2.set_xlabel('轮次')
        ax2.set_ylabel('累积积分')
        ax2.set_title('各赛季积分走势')
        ax2.legend()
        ax2.grid(True, alpha=0.3)
        # 3. 施压指数与积分相关性
        ax3 = axes[1, 0]
        scatter = ax3.scatter(self.data['施压指数'], self.data['积分'], 
                             c=self.data['轮次'], cmap='coolwarm', alpha=0.7, s=50)
        plt.colorbar(scatter, ax=ax3, label='比赛轮次')
        ax3.set_xlabel('施压指数')
        ax3.set_ylabel('积分')
        ax3.set_title('施压指数与积分相关性')
        # 添加回归线
        z = np.polyfit(self.data['施压指数'], self.data['积分'], 1)
        p = np.poly1d(z)
        ax3.plot(self.data['施压指数'], p(self.data['施压指数']), 
                'r--', alpha=0.8, label=f'趋势线 (斜率: {z[0]:.3f})')
        ax3.legend()
        # 4. 临场表现指标
        ax4 = axes[1, 1]
        metrics = ['控球率', '射门数', '进球', '失球']
        avg_stats = self.data.groupby('施压程度')[metrics].mean()
        x = np.arange(len(metrics))
        width = 0.25
        for i, level in enumerate(avg_stats.index):
            ax4.bar(x + i*width, avg_stats.loc[level], width, 
                   label=level, alpha=0.8)
        ax4.set_xlabel('比赛指标')
        ax4.set_ylabel('平均值')
        ax4.set_title('不同施压程度的临场表现')
        ax4.set_xticks(x + width)
        ax4.set_xticklabels(metrics)
        ax4.legend()
        plt.tight_layout()
        plt.show()
    def predict_pressure_effect(self):
        """预测施压对未来成绩的影响"""
        from sklearn.linear_model import LinearRegression
        from sklearn.model_selection import train_test_split
        if self.data is None:
            raise ValueError("请先生成数据")
        # 特征准备
        features = ['施压指数', '射门数', '控球率', '轮次']
        X = self.data[features]
        y = self.data['积分']
        # 划分训练集和测试集
        X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)
        # 训练模型
        model = LinearRegression()
        model.fit(X_train, y_train)
        # 预测
        y_pred = model.predict(X_test)
        # 模型评估
        from sklearn.metrics import r2_score, mean_squared_error
        r2 = r2_score(y_test, y_pred)
        mse = mean_squared_error(y_test, y_pred)
        print("\n=== 施压效果预测模型 ===")
        print(f"R²分数: {r2:.3f}")
        print(f"均方误差: {mse:.3f}")
        # 特征重要性
        feature_importance = pd.DataFrame({
            '特征': features,
            '系数': model.coef_
        }).sort_values('系数', key=abs, ascending=False)
        print("\n=== 特征影响系数 ===")
        print(feature_importance)
        # 预测不同施压水平下的积分
        future_pressure_levels = np.arange(20, 101, 10)
        future_predictions = []
        for pressure in future_pressure_levels:
            future_data = pd.DataFrame({
                '施压指数': [pressure],
                '射门数': [self.data['射门数'].mean()],
                '控球率': [self.data['控球率'].mean()],
                '轮次': [30]  # 假设赛季中后期
            })
            pred = model.predict(future_data)[0]
            future_predictions.append(pred)
        plt.figure(figsize=(10, 6))
        plt.plot(future_pressure_levels, future_predictions, 'o-', linewidth=2, markersize=8)
        plt.xlabel('施压指数')
        plt.ylabel('预测积分')
        plt.title('不同施压水平对积分的预测影响')
        plt.grid(True, alpha=0.3)
        plt.axhline(y=self.data['积分'].mean(), color='r', linestyle='--', 
                   label=f'平均积分: {self.data["积分"].mean():.1f}')
        plt.legend()
        plt.show()
        return model
# 使用示例
def main():
    # 创建分析器
    analyzer = FootballClubAnalyzer("皇家马德里")
    # 生成数据
    data = analyzer.generate_match_data(seasons=3)
    print("数据生成完成!")
    print(data.head(10))
    # 添加高层施压事件
    analyzer.add_pressure_event(datetime(2022, 3, 15), "连续失利后主席公开批评", 80)
    analyzer.add_pressure_event(datetime(2023, 4, 10), "球迷抗议要求解雇教练", 70)
    # 执行分析
    analyzer.analyze_pressure_impact()
    analyzer.visualize_results()
    # 预测分析
    model = analyzer.predict_pressure_effect()
    # 额外分析：赛季间比较
    print("\n=== 各赛季表现对比 ===")
    season_summary = data.groupby('赛季').agg({
        '积分': 'sum',
        '结果': lambda x: (x == 'W').sum(),
        '进球': 'sum',
        '失球': 'sum',
        '施压指数': 'mean'
    }).round(2)
    print(season_summary)
    # 关键比赛分析
    print("\n=== 关键比赛分析 ===")
    critical_matches = data[
        (data['轮次'] > 30) & 
        ((data['结果'] == 'W') | (data['结果'] == 'L'))
    ].nlargest(5, '施压指数')[['赛季', '轮次', '结果', '进球', '失球', '施压指数']]
    print("施压最大的决定性比赛:")
    print(critical_matches)
if __name__ == "__main__":
    main()

高级分析功能

class AdvancedPressureAnalysis:
    """高级施压分析功能"""
    def __init__(self, data):
        self.data = data
    def correlation_heatmap(self):
        """相关性热力图"""
        # 选择数值列
        numeric_cols = ['进球', '失球', '控球率', '射门数', '上座率', '施压指数', '积分']
        corr_data = self.data[numeric_cols]
        # 计算相关系数矩阵
        corr_matrix = corr_data.corr()
        plt.figure(figsize=(12, 8))
        sns.heatmap(corr_matrix, annot=True, cmap='coolwarm', center=0,
                   fmt='.2f', linewidths=1, cbar_kws={'label': '相关系数'})
        plt.title('各指标相关性热力图', fontsize=14)
        plt.tight_layout()
        plt.show()
        return corr_matrix
    def pressure_timeline_analysis(self):
        """施压时间线分析"""
        # 按轮次分组计算平均施压指数
        pressure_by_round = self.data.groupby('轮次')['施压指数'].mean()
        # 按轮次计算胜率
        win_rate_by_round = self.data.groupby('轮次')['结果'].apply(lambda x: (x == 'W').mean())
        fig, (ax1, ax2) = plt.subplots(2, 1, figsize=(12, 8))
        # 施压指数走势
        ax1.plot(pressure_by_round.index, pressure_by_round.values, 
                'b-o', linewidth=2, markersize=6)
        ax1.set_xlabel('轮次')
        ax1.set_ylabel('平均施压指数')
        ax1.set_title('赛季各轮次施压指数变化')
        ax1.grid(True, alpha=0.3)
        # 胜率对比
        ax2.bar(win_rate_by_round.index, win_rate_by_round.values * 100, 
               alpha=0.7, color='green')
        ax2.set_xlabel('轮次')
        ax2.set_ylabel('胜率 (%)')
        ax2.set_title('赛季各轮次胜率')
        ax2.grid(True, alpha=0.3)
        # 添加趋势线
        z = np.polyfit(win_rate_by_round.index, win_rate_by_round.values, 2)
        p = np.poly1d(z)
        ax2.plot(win_rate_by_round.index, p(win_rate_by_round.index) * 100, 
                'r--', label='趋势线')
        ax2.legend()
        plt.tight_layout()
        plt.show()
    def extreme_scenarios(self):
        """极端情况分析"""
        print("\n=== 极端情况分析 ===")
        # 高施压下的表现
        high_pressure = self.data[self.data['施压指数'] > 70]
        low_pressure = self.data[self.data['施压指数'] < 30]
        print("高施压比赛 (>70):")
        print(f"场次: {len(high_pressure)}")
        print(f"胜率: {(high_pressure['结果'] == 'W').mean()*100:.1f}%")
        print(f"平均积分: {high_pressure['积分'].mean():.2f}")
        print("\n低施压比赛 (<30):")
        print(f"场次: {len(low_pressure)}")
        print(f"胜率: {(low_pressure['结果'] == 'W').mean()*100:.1f}%")
        print(f"平均积分: {low_pressure['积分'].mean():.2f}")
        # 连续战术分析
        print("\n=== 连续比赛分析 ===")
        for season in self.data['赛季'].unique():
            season_data = self.data[self.data['赛季'] == season]
            # 找到连续不败或连续失利
            results = season_data['结果'].values
            max_win_streak = 0
            max_loss_streak = 0
            current_win = 0
            current_loss = 0
            for result in results:
                if result == 'W':
                    current_win += 1
                    current_loss = 0
                elif result == 'L':
                    current_loss += 1
                    current_win = 0
                else:
                    current_win = 0
                    current_loss = 0
                max_win_streak = max(max_win_streak, current_win)
                max_loss_streak = max(max_loss_streak, current_loss)
            print(f"{season}: 最长连胜 {max_win_streak}场, 最长连败 {max_loss_streak}场")
# 在main函数中使用高级分析
def advanced_analysis_demo():
    analyzer = FootballClubAnalyzer("巴塞罗那")
    data = analyzer.generate_match_data(seasons=3)
    # 基础分析
    analyzer.analyze_pressure_impact()
    # 高级分析
    advanced = AdvancedPressureAnalysis(data)
    # 相关性热力图
    corr_matrix = advanced.correlation_heatmap()
    # 时间线分析
    advanced.pressure_timeline_analysis()
    # 极端情况
    advanced.extreme_scenarios()
    return data
# 运行高级分析
data = advanced_analysis_demo()

决策支持系统

class PressureDecisionSupport:
    """高层决策支持系统"""
    def __init__(self, analyzer):
        self.analyzer = analyzer
        self.data = analyzer.data
    def recommend_pressure_strategy(self):
        """推荐施压策略"""
        print("\n" + "="*60)
        print("高层施压策略建议")
        print("="*60)
        # 分析当前状态
        current_form = self.get_current_form()
        pressure_effectiveness = self.calculate_pressure_effectiveness()
        print(f"\n当前球队状态: {current_form}")
        print(f"施压有效指数: {pressure_effectiveness:.2f}/10")
        if pressure_effectiveness > 7:
            strategy = """
            【建议加强施压】
            1. 在关键比赛前适当增加施压
            2. 公开肯定球员努力，同时明确提出期望
            3. 设定期望成绩目标，明确奖惩措施
            4. 关注球队士气，避免过度施压
            """
        elif pressure_effectiveness > 4:
            strategy = """
            【建议适度施压】
            1. 保持当前施压水平
            2. 重点关注战术调整和轮换
            3. 加强与教练组的沟通
            4. 给予球员必要的支持
            """
        else:
            strategy = """
            【建议减轻施压】
            1. 减少公开批评，多进行内部沟通
            2. 提供心理辅导和支持
            3. 考虑更换教练团队
            4. 专注于长期建设而非短期施压
            """
        print(strategy)
        # 风险警示
        self.risk_warning()
    def get_current_form(self):
        """计算当前状态"""
        last_5 = self.data.tail(5)
        points = last_5['积分'].sum()
        if points >= 10:
            return "优秀"
        elif points >= 8:
            return "良好"
        elif points >= 5:
            return "一般"
        elif points >= 3:
            return "较差"
        else:
            return "危机"
    def calculate_pressure_effectiveness(self):
        """计算施压有效性"""
        # 基于数据计算施压效果指数
        effect_weights = {
            'win_diff': 0.3,
            'goal_diff': 0.2,
            'form_boost': 0.3,
            'consistency': 0.2
        }
        # 计算各指标
        high_pressure = self.data[self.data['施压指数'] > 50]
        low_pressure = self.data[self.data['施压指数'] <= 50]
        if len(high_pressure) == 0 or len(low_pressure) == 0:
            return 5.0  # 默认中等水平
        win_diff = (high_pressure['结果'] == 'W').mean() - (low_pressure['结果'] == 'W').mean()
        goal_diff = (high_pressure['进球'].mean() - high_pressure['失球'].mean()) - \
                   (low_pressure['进球'].mean() - low_pressure['失球'].mean())
        # 标准化到0-10分
        effectiveness = 5 + (win_diff * 10 + goal_diff * 2)
        return max(0, min(10, effectiveness))
    def risk_warning(self):
        """风险警示"""
        print("\n=== 风险预警 ===")
        # 检查球员受伤风险
        avg_shots = self.data['射门数'].mean()
        if avg_shots < 10:
            print("⚠ 警告: 球队进攻创造力不足")
        # 检查防守风险
        avg_goals_against = self.data['失球'].mean()
        if avg_goals_against > 1.5:
            print("⚠ 警告: 防守端存在隐患")
        # 检查压力累积风险
        high_pressure_percentage = (self.data['施压指数'] > 70).mean()
        if high_pressure_percentage > 0.3:
            print("⚠ 警告: 存在过高压迫风险")
            print("   - 建议召开球员心理会议")
            print("   - 安排心理辅导课程")
        # 检查球迷支持度
        avg_attendance = self.data['上座率'].mean()
        if avg_attendance < 40000:
            print("⚠ 警告: 球迷支持度下降")
    def generate_report(self):
        """生成完整报告"""
        report = f"""
        ========================================
        {self.analyzer.club_name} 高层施压效果分析报告
        ========================================
        一、赛季概况
        -------------
        比赛场次: {len(self.data)}
        胜场: {(self.data['结果'] == 'W').sum()}
        平场: {(self.data['结果'] == 'D').sum()}
        负场: {(self.data['结果'] == 'L').sum()}
        总积分: {self.data['积分'].sum()}
        二、施压分析
        -------------
        平均施压指数: {self.data['施压指数'].mean():.2f}
        最高施压指数: {self.data['施压指数'].max()}
        施压有效性: {self.calculate_pressure_effectiveness():.1f}/10
        三、关键指标对比
        ----------------
        {self.data.groupby('施压程度')['积分'].agg(['mean', 'sum']).to_string()}
        四、建议方案
        -------------
        {self.recommend_pressure_strategy()}
        """
        return report
# 运行完整的决策支持
def run_decision_support():
    analyzer = FootballClubAnalyzer("利物浦")
    data = analyzer.generate_match_data(seasons=3)
    support = PressureDecisionSupport(analyzer)
    # 生成建议
    support.recommend_pressure_strategy()
    # 生成完整报告
    report = support.generate_report()
    print(report)
    # 保存报告
    with open('pressure_analysis_report.txt', 'w', encoding='utf-8') as f:
        f.write(report)
    print("报告已保存至 pressure_analysis_report.txt")
# 运行
run_decision_support()