{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"#importing libraries\nimport numpy as np\nimport pandas as pd\nimport matplotlib.pyplot as plt\n%matplotlib inline\nimport seaborn as sns\nsns.set(style='darkgrid')","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#import data\nderby=pd.read_csv(r\"D:\\python\\big-data-derby-2022\\nyra_race_table.csv\")\nderby","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#column as index\nderby.set_index('race_number', inplace=True)","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.head()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.tail()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.shape","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# how many null values in a data\nderby.isnull().sum()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.info()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.describe()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# CATEGORICAL DATA","metadata":{}},{"cell_type":"code","source":"derby[\"track_id\"].value_counts()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sns.countplot(derby[\"track_id\"])","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"SAR_perc = len(derby[derby['track_id']==\"SAR\"])/len(derby)\nSAR_perc","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"AQU_perc = len(derby[derby['track_id']==\"AQU\"])/len(derby)\nAQU_perc","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"BEL_perc = len(derby[derby['track_id']==\"BEL\"])/len(derby)\nBEL_perc","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby[\"track_condition\"].unique()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby[\"track_condition\"].value_counts()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby[\"track_condition\"].value_counts().keys()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.pie(derby[\"track_condition\"].value_counts(),labels=derby[\"track_condition\"].value_counts().keys(), autopct='%2.1f%%', \n       shadow=True, radius=2.5, textprops={\"fontsize\":15})\nplt.show()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby[\"course_type\"].value_counts().plot(kind='barh')","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.isna().sum()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby[\"race_type\"].value_counts().plot(kind='bar')","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby[\"race_type\"].value_counts()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# NUMERICAL DATA","metadata":{}},{"cell_type":"code","source":"derby.columns","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['race_date']=pd.to_datetime(derby['race_date'])","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.info()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['year']=derby['race_date'].dt.year\nderby","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['month']=derby['race_date'].dt.month_name()\nderby","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['date']=derby['race_date'].dt.day","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['dow']=derby['race_date'].dt.day_name()\nderby","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['days_of_weekend']= np.where(derby['dow'].isin(['Saturday','Sunday']),0,1)","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['quarter']= derby['race_date'].dt.quarter\nderby","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['race week_of_year']= derby['race_date'].dt.week\nderby","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['month'].value_counts(ascending=True).index","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20,10))\norders=['January','February','March','April','May','June','July','August','September','October','November','December']\nsns.countplot(derby[\"month\"],order=orders)","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20,10))\nsns.countplot(derby[\"dow\"])","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(20,10))\nsns.histplot(derby[\"distance_id\"])","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sns.boxplot(derby[\"distance_id\"])","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby.nunique()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['post_time']","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['post_time']=pd.to_datetime(derby['post_time'],format='%H%M')","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"derby['post_time']","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}