<jupyter_start><jupyter_text>3 KM<jupyter_code>df_3 = pd.read_excel("data/3_km.xls", sheet_name='3 KM')
df_3['Разворот'] = pd.to_timedelta(df_3['Разворот'])
df_3['Чип время'] = pd.to_timedelta(df_3['Чип время'])
df_3.info()
df_3.head()
df_3['Age'].max()<jupyter_output><empty_output><jupyter_text>10 KM<jupyter_code>df_10 = pd.read_excel("data/10_km.xls", sheet_name='10 KM')
df_10['2.27 km Аль-Фараби Достык'] = pd.to_timedelta(df_10['2.27 km Аль-Фараби Достык'])
df_10['Gun Time'] = pd.to_timedelta(df_10['Gun Time'])
df_10.head()
df_10.info()
df_10['Gun Time'].min()
df_10['Gender'].value_counts()<jupyter_output><empty_output><jupyter_text>21 KM<jupyter_code>df_21 = pd.read_excel("data/21_km.xls", sheet_name='21 KM')
df_21['8.0 km ППП'] = pd.to_timedelta(df_21['8.0 km ППП'])
df_21['12.0 km Абая Саина'] = pd.to_timedelta(df_21['12.0 km Абая Саина'])
df_21['Gun Time'] = pd.to_timedelta(df_21['Gun Time'])
df_21.head()
df_21.info()
df_21['Gun Time'].tail()
df_21[df_21['Pos']==3205]
df_21.tail(10)
df_21['tt'] = 30
df_21.head()
df_21['Gender'].value_counts()<jupyter_output><empty_output><jupyter_text>42 KM<jupyter_code>df_42 = pd.read_excel("data/42_km.xls", sheet_name='42 KM')
print(df_42['Gun Time'].tail())
df_42['8.0 km ППП'] = pd.to_timedelta(df_42['8.0 km ППП'])
df_42['12.0 km Абая Саина'] = pd.to_timedelta(df_42['12.0 km Абая Саина'])
df_42['21.0 km Площадь Республики'] = pd.to_timedelta(df_42['21.0 km Площадь Республики'])
df_42['29.0 km ППП'] = pd.to_timedelta(df_42['29.0 km ППП'])
df_42['33.0 km Абая Саина'] = pd.to_timedelta(df_42['33.0 km Абая Саина'])
df_42['Gun Time'] = pd.to_timedelta(df_42['Gun Time'])
df_42.head()
df_42.info()
df_42['Gender'].value_counts()
df_42['age_group']      = df_42['Age'].apply(age_group)
df_42.head()
# df_42['29.0 km ППП'] = df_42['29.0 km ППП'].dt.seconds
df_42['Gun Time'] = df_42['Gun Time'].dt.seconds/60
df_42[df_42['Стартовый'] == 637]
df_42.head()<jupyter_output><empty_output><jupyter_text>NORDIC<jupyter_code>df_nordic = pd.read_excel("data/nordic.xls", sheet_name='NORDIC')
df_nordic.head()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.2032520325203252, 'fraction_numerical': 0.0937350549976088, 'mean_word_length': 7.7899159663865545, 'pattern_counts': {'":': 0, '<': 21, '<?xml version=': 0, '>': 21, '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': '5', 'dir': 'jupyter-structured-clean-dedup', 'id': '261208', 'license': 'MIT', 'n_tokens_mistral': 1128, 'n_tokens_neox': 1050, 'n_words': 135, 'path': 'Main.ipynb', 'repo_name': 'imaganov/almaty-marathon-visualization', 'size': '2091'}