{"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 necessary libraries\nimport os\nimport numpy as np\nimport pandas as pd\nfrom datetime import datetime\nimport matplotlib.pyplot as plt","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:01:05.871813Z","iopub.execute_input":"2021-11-21T05:01:05.87242Z","iopub.status.idle":"2021-11-21T05:01:05.877027Z","shell.execute_reply.started":"2021-11-21T05:01:05.872378Z","shell.execute_reply":"2021-11-21T05:01:05.876464Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#checking asset details\nasset_details=pd.read_csv(\"../input/g-research-crypto-forecasting/asset_details.csv\")\nprint(asset_details.shape)\nasset_details.head()","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:01:05.878758Z","iopub.execute_input":"2021-11-21T05:01:05.87945Z","iopub.status.idle":"2021-11-21T05:01:05.916282Z","shell.execute_reply.started":"2021-11-21T05:01:05.879413Z","shell.execute_reply":"2021-11-21T05:01:05.915702Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#checking sample submission file\nex_sub=pd.read_csv(\"../input/g-research-crypto-forecasting/example_sample_submission.csv\")\nprint(ex_sub.shape)\nex_sub.head()","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:01:05.917533Z","iopub.execute_input":"2021-11-21T05:01:05.917884Z","iopub.status.idle":"2021-11-21T05:01:05.933352Z","shell.execute_reply.started":"2021-11-21T05:01:05.917857Z","shell.execute_reply":"2021-11-21T05:01:05.932375Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#checking example test file\nex_test=pd.read_csv(\"../input/g-research-crypto-forecasting/example_test.csv\")\nprint(ex_test.shape)\nex_test.head()","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:01:05.934604Z","iopub.execute_input":"2021-11-21T05:01:05.934829Z","iopub.status.idle":"2021-11-21T05:01:05.958381Z","shell.execute_reply.started":"2021-11-21T05:01:05.934804Z","shell.execute_reply":"2021-11-21T05:01:05.957775Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#checking train file\ntrain=pd.read_csv(\"../input/g-research-crypto-forecasting/train.csv\")\nprint(train.shape)\ntrain.head()","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:01:05.960052Z","iopub.execute_input":"2021-11-21T05:01:05.960453Z","iopub.status.idle":"2021-11-21T05:02:06.379778Z","shell.execute_reply.started":"2021-11-21T05:01:05.960423Z","shell.execute_reply":"2021-11-21T05:02:06.378894Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#checking supplemental train file\nsup_train=pd.read_csv(\"../input/g-research-crypto-forecasting/supplemental_train.csv\")\nprint(sup_train.shape)\nsup_train.head()","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:02:06.381153Z","iopub.execute_input":"2021-11-21T05:02:06.381539Z","iopub.status.idle":"2021-11-21T05:02:11.539683Z","shell.execute_reply.started":"2021-11-21T05:02:06.381496Z","shell.execute_reply":"2021-11-21T05:02:11.538771Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"<b>Describing Dataset</b>","metadata":{}},{"cell_type":"markdown","source":"* train.csv - The training set\n    * timestamp - A timestamp for the minute covered by the row.\n    * Asset_ID - An ID code for the cryptoasset.\n    * Count - The number of trades that took place this minute.\n    * Open - The USD price at the beginning of the minute.\n    * High - The highest USD price during the minute.\n    * Low - The lowest USD price during the minute.\n    * Close - The USD price at the end of the minute.\n    * Volume - The number of cryptoasset units traded during the minute.\n    * VWAP - The volume weighted average price for the minute.\n    * Target - 15 minute residualized returns. See the 'Prediction and Evaluation' section of this notebook for details of      how the target is calculated.\n \n \n* example_test.csv - An example of the data that will be delivered by the time series API.\n\n* example_sample_submission.csv - An example of the data that will be delivered by the time series API. The data is just copied from train.csv.\n\n* asset_details.csv - Provides the real name and of the cryptoasset for each Asset_ID and the weight each cryptoasset receives in the metric.\n\n* gresearch_crypto - An unoptimized version of the time series API files for offline work. You may need Python 3.7 and a Linux environment to run it without errors.\n\n* supplemental_train.csv - After the submission period is over this file's data will be replaced with cryptoasset prices from the submission period. In the Evaluation phase, the train, train supplement, and test set will be contiguous in time, apart from any missing data. The current copy, which is just filled approximately the right amount of data from train.csv is provided as a placeholder.","metadata":{}},{"cell_type":"code","source":"#checkinbg the mathematical detail of train dataset\ntrain.describe()","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:02:11.540686Z","iopub.execute_input":"2021-11-21T05:02:11.540918Z","iopub.status.idle":"2021-11-21T05:02:20.258833Z","shell.execute_reply.started":"2021-11-21T05:02:11.540889Z","shell.execute_reply":"2021-11-21T05:02:20.257984Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#checking the count in each column and therew data type\ntrain.info(show_counts =True)","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:02:20.260525Z","iopub.execute_input":"2021-11-21T05:02:20.261423Z","iopub.status.idle":"2021-11-21T05:02:20.848949Z","shell.execute_reply.started":"2021-11-21T05:02:20.261386Z","shell.execute_reply":"2021-11-21T05:02:20.847724Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#checking the null values\ntrain.isna().sum()","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:26:04.612478Z","iopub.execute_input":"2021-11-21T05:26:04.612811Z","iopub.status.idle":"2021-11-21T05:26:05.106772Z","shell.execute_reply.started":"2021-11-21T05:26:04.612775Z","shell.execute_reply":"2021-11-21T05:26:05.105697Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#count of number of cryptocoin\nplt.hist(train['Asset_ID'],bins=np.unique(train['Asset_ID']))","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:32:53.183356Z","iopub.execute_input":"2021-11-21T05:32:53.183995Z","iopub.status.idle":"2021-11-21T05:32:54.947178Z","shell.execute_reply.started":"2021-11-21T05:32:53.183953Z","shell.execute_reply":"2021-11-21T05:32:54.946532Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#assest details\nasset_details","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:35:44.503315Z","iopub.execute_input":"2021-11-21T05:35:44.503687Z","iopub.status.idle":"2021-11-21T05:35:44.516976Z","shell.execute_reply.started":"2021-11-21T05:35:44.50365Z","shell.execute_reply":"2021-11-21T05:35:44.516007Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#bitcoin and there count\nfor i in asset_details.index:\n    print(asset_details['Asset_Name'][i],\": \\t\",list(train['Asset_ID'].values).count(i))","metadata":{"execution":{"iopub.status.busy":"2021-11-21T05:49:37.744999Z","iopub.execute_input":"2021-11-21T05:49:37.745234Z","iopub.status.idle":"2021-11-21T05:53:01.133921Z","shell.execute_reply.started":"2021-11-21T05:49:37.745206Z","shell.execute_reply":"2021-11-21T05:53:01.133047Z"},"trusted":true},"execution_count":null,"outputs":[]}]}