| import streamlit as st |
| import pandas as pd |
| import plotly.express as px |
| import os |
|
|
| |
| st.set_page_config( |
| page_title="Cricket Performance Analytics", |
| layout="wide", |
| initial_sidebar_state="expanded" |
| ) |
|
|
| |
| st.markdown(""" |
| <style> |
| .main-title { |
| color: #2E86C1; |
| font-size: 36px; |
| font-weight: bold; |
| text-align: center; |
| padding: 20px 0; |
| } |
| .section-header { |
| color: #1A5276; |
| font-size: 24px; |
| padding: 10px 0; |
| } |
| .metric-card { |
| background-color: #EAF2F8; |
| padding: 15px; |
| border-radius: 10px; |
| text-align: center; |
| box-shadow: 0 2px 5px rgba(0,0,0,0.1); |
| margin: 5px; |
| } |
| .metric-card h3 { |
| color: #1A5276; |
| font-size: 18px; |
| margin-bottom: 5px; |
| } |
| .metric-card p { |
| color: #2E86C1; |
| font-size: 24px; |
| font-weight: bold; |
| margin: 0; |
| } |
| </style> |
| """, unsafe_allow_html=True) |
|
|
| |
| batting_path = "Teams_batting.csv" |
| bowling_path = "team_bowling.csv" |
|
|
| if not os.path.exists(batting_path) or not os.path.exists(bowling_path): |
| st.error("CSV files not found. Please check file paths.") |
| st.stop() |
|
|
| batting_df = pd.read_csv(batting_path) |
| bowling_df = pd.read_csv(bowling_path) |
|
|
| |
| st.write("Batting DataFrame Columns:", batting_df.columns.tolist()) |
| st.write("Bowling DataFrame Columns:", bowling_df.columns.tolist()) |
|
|
| |
| if "player_name" not in batting_df.columns: |
| st.error("Column 'player_name' not found! Available columns: " + ", ".join(batting_df.columns)) |
| st.stop() |
|
|
| |
| teams = sorted(set(batting_df['Country'].unique()).union(bowling_df['Country'].unique())) |
| selected_team = st.selectbox("Choose a Team", teams, format_func=lambda x: x.upper()) |
|
|
| |
| batting_players = batting_df[batting_df['Country'] == selected_team]['player_name'].unique() |
| bowling_players = bowling_df[bowling_df['Country'] == selected_team]['player_name'].unique() |
| players = sorted(set(batting_players).union(bowling_players)) |
|
|
| selected_player = st.selectbox("Choose a Player", players) |
|
|
| st.success("Code successfully executed!") |
| |
| player_batting = batting_df[(batting_df['player_name'] == selected_player) & |
| (batting_df[team_column] == selected_team)] |
| player_bowling = bowling_df[(bowling_df['player_name'] == selected_player) & |
| (bowling_df[team_column] == selected_team)] |
|
|
| |
| st.markdown(f'<div class="main-title">{selected_player}\'s Cricket Analytics</div>', unsafe_allow_html=True) |
|
|
| |
| st.markdown('<div class="section-header">Key Performance Metrics</div>', unsafe_allow_html=True) |
| if not player_batting.empty: |
| col1, col2, col3 = st.columns(3) |
| with col1: |
| total_runs = player_batting['runs'].sum() |
| st.markdown(f'<div class="metric-card"><h3>Total Runs</h3><p>{total_runs}</p></div>', unsafe_allow_html=True) |
| with col2: |
| avg_sr = player_batting['sr'].mean().round(2) |
| st.markdown(f'<div class="metric-card"><h3>Avg Strike Rate</h3><p>{avg_sr}</p></div>', unsafe_allow_html=True) |
| with col3: |
| matches = len(player_batting) |
| st.markdown(f'<div class="metric-card"><h3>Matches</h3><p>{matches}</p></div>', unsafe_allow_html=True) |
| else: |
| st.warning("No batting data available to display key metrics.") |
|
|
| |
| tab1, tab2 = st.tabs(["Batting Analysis", "Bowling Analysis"]) |
|
|
| with tab1: |
| if not player_batting.empty: |
| st.markdown('<div class="section-header">Batting Performance</div>', unsafe_allow_html=True) |
| col1, col2 = st.columns(2) |
| |
| with col1: |
| fig_runs = px.pie(player_batting, values='runs', names='format', |
| title='Runs Distribution by Format', |
| color_discrete_sequence=px.colors.sequential.Blues) |
| fig_runs.update_layout(title_x=0.5) |
| st.plotly_chart(fig_runs, use_container_width=True) |
| |
| with col2: |
| fig_sr = px.scatter(player_batting, x='format', y='sr', |
| size='runs', color='format', |
| title='Strike Rate Analysis', |
| hover_data=['runs']) |
| fig_sr.update_layout(title_x=0.5) |
| st.plotly_chart(fig_sr, use_container_width=True) |
| else: |
| st.info("No batting statistics available for this player.") |
|
|
| with tab2: |
| if not player_bowling.empty: |
| st.markdown('<div class="section-header">Bowling Performance</div>', unsafe_allow_html=True) |
| col3, col4 = st.columns(2) |
| |
| with col3: |
| fig_wickets = px.bar(player_bowling, x='format', y='wickets', |
| color='format', |
| title='Wickets by Format', |
| color_discrete_sequence=px.colors.sequential.Reds) |
| fig_wickets.update_layout(title_x=0.5) |
| st.plotly_chart(fig_wickets, use_container_width=True) |
| |
| with col4: |
| fig_eco = px.area(player_bowling, x='format', y='eco', |
| title='Economy Rate Trend', |
| color_discrete_sequence=['#2ECC71']) |
| fig_eco.update_layout(title_x=0.5) |
| st.plotly_chart(fig_eco, use_container_width=True) |
| else: |
| st.info("No bowling statistics available for this player.") |
|
|
| |
| with st.expander("View Raw Data"): |
| if not player_batting.empty: |
| st.write("### Batting Statistics") |
| st.dataframe(player_batting.iloc[:, :17].style.set_properties(**{'background-color': '#F8F9F9'})) |
| if not player_bowling.empty: |
| st.write("### Bowling Statistics") |
| st.dataframe(player_bowling.iloc[:, :15].style.set_properties(**{'background-color': '#F8F9F9'})) |
|
|
