{"cells":[{"metadata":{"_uuid":"c3ab2320-1b96-4518-a8cf-7c012155604b","_cell_guid":"099865f8-fc38-4e56-a42e-bea83b2a3d6b","trusted":true,"_kg_hide-input":true},"cell_type":"code","source":"import numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\nimport mlcrate as mlc\nimport os\nimport gc\nimport matplotlib.pyplot as plt\nimport seaborn as sns\n%matplotlib inline\n\npal = sns.color_palette()\n\nprint('# File sizes')\nfor f in os.listdir('../input'):\n    if 'zip' not in f:\n        print(f.ljust(30) + str(round(os.path.getsize('../input/' + f) / 1000000, 2)) + 'MB')","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"cb0556cc-3ea0-4d5d-b59c-0dee09741fd1","_cell_guid":"7be5c6b1-96af-4d25-8ccb-c1020f4b661e","trusted":true,"_kg_hide-input":true},"cell_type":"code","source":"import subprocess\nprint('# Line count:')\nfor file in ['train.csv', 'test.csv', 'train_sample.csv']:\n    lines = subprocess.run(['wc', '-l', '../input/{}'.format(file)], stdout=subprocess.PIPE).stdout.decode('utf-8')\n    print(lines, end='', flush=True)","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"87cdab0f-27c1-46f4-bee2-6e88f3a4ed71","_cell_guid":"7c4620e5-a03a-4fa1-8151-83a9f6bb0459","trusted":true},"cell_type":"code","source":"test = pd.read_csv('../input/train.csv')\ntrain = pd.read_csv('../input/test.csv')","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"a1f31953-2d01-4564-a04c-2752c815dc63","_cell_guid":"c5baf4b6-d064-4aee-8585-c5c421045576","trusted":true,"_kg_hide-input":true},"cell_type":"code","source":"new=test[['ip','app','os','channel','click_time','is_attributed']]\nnew2=train[['ip','app','os','channel','click_time']]\nnew=new.sort_values(by=['ip'],ascending=True)\nnew2=new2.sort_values(by=['ip'],ascending=True)","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"07db6cfa-6b50-4cf6-8a81-1109a66825de","_cell_guid":"15c61fb2-7c42-4cd5-8c44-e003e367f75a","trusted":true,"_kg_hide-input":true},"cell_type":"code","source":"import random\nfrom ipaddress import IPv4Address\n\n\ndef ipecg(seed):\n    random.seed(seed)\n    return str(IPv4Address(random.getrandbits(32)))","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"be015fac-982e-4ab2-8083-af0c80b38208","_cell_guid":"ce383f54-b33c-462e-a002-3919cebabc55","trusted":true,"_kg_hide-input":true},"cell_type":"code","source":"import random\nk=[]\nfor i in new['ip']:\n  j=random.randint(2,999)\n  rev=ipecg(i+j)\n  k.append(rev)\nnew['valid_test']=k\nnew","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"import random\nk=[]\nfor i in new['ip']:\n  j=random.randint(2,999)\n  rev=ipecg(i+j)\n  k.append(rev)\nnew2['valid_train']=k\nnew2","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"name":"python","version":"3.6.4","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":1}