<jupyter_start><jupyter_text>Data Analysis - Bike Stats - <NAME> - 12/16/2019<jupyter_code>import pandas as pd
import numpy as np
df_weather = pd.read_csv('weather.csv')
df_station  = pd.read_csv('station.csv')
df_trip = pd.read_csv('trip.csv', skiprows=[50793])
df_trip[['tripduration']].mean()<jupyter_output><empty_output><jupyter_text>average trip duration is 1178.3<jupyter_code>age = df_trip[['birthyear']].mode()
2019-age<jupyter_output><empty_output><jupyter_text>the most popuular age is 32<jupyter_code>df_weather
df_station[['current_dockcount']].mean()<jupyter_output><empty_output><jupyter_text>average number of bikes is 16.5<jupyter_code>df_weather
temp_old = df_station.sort_values('modification_date',  ascending= False)['current_dockcount'].tail(42)
temp_new = df_station.sort_values('modification_date',  ascending= False)['current_dockcount'].head(15)
new = temp_new.mean()
old = temp_old.mean()
new-old<jupyter_output><empty_output><jupyter_text>question 1: what was the max wind speed?<jupyter_code>df_weather[['Mean_Wind_Speed_MPH']].mean()<jupyter_output><empty_output><jupyter_text>question 2: What was the most used station<jupyter_code>df_trip[['from_station_name']].mode()<jupyter_output><empty_output><jupyter_text>question 3: What is the rain event that shows up most often?<jupyter_code>df_weather[['Events']].mode()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1394335511982571, 'fraction_numerical': 0.024691358024691357, 'mean_word_length': 10.777777777777779, 'pattern_counts': {'":': 0, '<': 30, '<?xml version=': 0, '>': 30, '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': '7', 'dir': 'jupyter-structured-clean-dedup', 'id': '660169', 'license': 'MIT', 'n_tokens_mistral': 559, 'n_tokens_neox': 511, 'n_words': 76, 'path': 'bike-stats.ipynb', 'repo_name': 'glasscharlie/data_analysis', 'size': '1384'}