<jupyter_start><jupyter_text>1. In how many cities Summer Olympics is held so far?<jupyter_code>df['City'].unique()
len(df['City'].unique())<jupyter_output><empty_output><jupyter_text>2. Which sport is having most number of Gold Medals so far? (Top 5)<jupyter_code>df[df['Medal']=='Gold'].groupby("Sport").count()['Medal'].sort_values(ascending=False).head().plot.bar(figsize=(5,5))<jupyter_output><empty_output><jupyter_text>3. Which sport is having most number of medals so far? (Top 5)<jupyter_code>df.groupby('Sport').count()['Medal'].sort_values(ascending=False).head().plot.bar(figsize=(5,5))<jupyter_output><empty_output><jupyter_text>4. Which player has won most number of medals? (Top 5)<jupyter_code>df['Athlete'].describe()
df.groupby('Athlete').count()['Medal'].sort_values(ascending=False).head().plot.bar(figsize=(5,5))<jupyter_output><empty_output><jupyter_text>5. Which player has won most number Gold Medals of medals? (Top 5)<jupyter_code>df[df['Medal']=='Gold'].groupby("Athlete").count()['Medal'].sort_values(ascending=False).head().plot.bar(figsize=(5,5))<jupyter_output><empty_output><jupyter_text>6. In which year India won first Gold Medal in Summer Olympics?<jupyter_code>df_pros = df[df['Country'] == 'IND']
df_pros[df_pros['Medal'] == 'Gold']['Year'].min()<jupyter_output><empty_output><jupyter_text>7. Which event is most popular in terms on number of players? (Top 5)<jupyter_code>df.groupby("Event").count()['Athlete'].sort_values(ascending=False).head().plot.bar(figsize=(5,5))<jupyter_output><empty_output><jupyter_text>8. Which sport is having most female Gold Medalists? (Top 5)<jupyter_code>df_pros = df[df['Gender'] == 'Women']
df_pros[df_pros['Medal'] == 'Gold'].groupby("Sport").count()['Medal'].sort_values(ascending=False).head().plot.bar(figsize=(5,5))<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.19089413055403182, 'fraction_numerical': 0.01426220515633571, 'mean_word_length': 10.692307692307692, 'pattern_counts': {'":': 0, '<': 33, '<?xml version=': 0, '>': 33, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '8', 'dir': 'jupyter-structured-clean-dedup', 'id': '44240', 'license': 'Apache-2.0', 'n_tokens_mistral': 695, 'n_tokens_neox': 667, 'n_words': 102, 'path': 'summer.ipynb', 'repo_name': 'nitrooxide/Summer-Olympics-Data-Analysis', 'size': '1823'}