{"cells":[{"metadata":{"_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","trusted":true},"cell_type":"code","source":"# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load in \n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n# Input data files are available in the \"../input/\" directory.\n# For example, running this (by clicking run or pressing Shift+Enter) will list the files in the input directory\n\nimport os\nprint(os.listdir(\"../input\"))\n\n# Any results you write to the current directory are saved as output.","execution_count":1,"outputs":[]},{"metadata":{"_cell_guid":"79c7e3d0-c299-4dcb-8224-4455121ee9b0","_uuid":"d629ff2d2480ee46fbb7e2d37f6b5fab8052498a","collapsed":true,"trusted":true},"cell_type":"code","source":"df_train = pd.read_csv(\"../input/train.csv\", low_memory = True,nrows=20000000)\ndf_test=pd.read_csv(\"../input/test.csv\")","execution_count":2,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c4a60476d1a41f577127254561ae51bab60551b3"},"cell_type":"code","source":"df_train.head()","execution_count":5,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"72d319952c95b51046a2b9378282648f680ca3c0"},"cell_type":"code","source":"df_test.head()","execution_count":6,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"a6457d29f9a6f9766a9a5324987fb68856811b54"},"cell_type":"code","source":"df_train=df_train.drop(['attributed_time'],axis=1)","execution_count":7,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"275304ec02c6b250dd428b72bb7b0e51bb0b20fa"},"cell_type":"code","source":"df_train.columns","execution_count":8,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b15c600257c088d9c4c54da1d009db577b2f8c06"},"cell_type":"code","source":"df_train.info()","execution_count":10,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c19398a5f3f95e386c2751f245ce8585eb23efd5"},"cell_type":"code","source":"# Any missing values\ndf_train.isnull().sum()","execution_count":12,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c583988f14bbfd0941b5551977be552462824b99"},"cell_type":"code","source":"df_train['is_attributed'].value_counts()","execution_count":13,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"4cdc544b70e64947cf7f54706ae3b2ec952e9ae4"},"cell_type":"code","source":"df_train=df_train.drop(['click_time'],axis=1)","execution_count":14,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"797a0d01d3abce5630f1cf64b579fccdbee6c1d0"},"cell_type":"code","source":"df_train.columns","execution_count":16,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"46ba55051f2fe5a0fa9c9e54152e613bc3967dc6"},"cell_type":"code","source":"df_train.head()","execution_count":18,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"04b925af4374343750e788236875adb4fb2a1351"},"cell_type":"code","source":"X=df_train.drop(['is_attributed'],axis=1)\ny=df_train['is_attributed']","execution_count":19,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"cb1f0c9a5e44818b357b0685de18dbaa2d414899"},"cell_type":"code","source":"from sklearn.linear_model import LogisticRegression\nmodel=LogisticRegression()\nmodel.fit(X,y)","execution_count":20,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"02f1b0d194cfbacb72f47c26cf53924a56fd0484"},"cell_type":"code","source":"X_test=df_test.drop(['click_id','click_time'],axis=1)","execution_count":21,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"21ed431bb54d4d624c0603dc76567d8ce0ec1b16"},"cell_type":"code","source":"y_pred=model.predict(X_test)","execution_count":22,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"dc7411da6b41164aa59fb3204933e742fb59a4c1"},"cell_type":"code","source":"set(y_pred)","execution_count":25,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"45846478c01bb0d85017908bc40a90416046f43c"},"cell_type":"code","source":"y_predict= pd.DataFrame(y_pred, columns=['is_attributed'])","execution_count":26,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b2d1ced5b6f02b68c5723aedb4709774930173b9"},"cell_type":"code","source":"y_predict.head()","execution_count":27,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"d9d932dc8d98d82359e464c4af864f1f5f2df217"},"cell_type":"code","source":"id=df_test['click_id']","execution_count":28,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b5c15083c5441dbba6124f884a643d5c588b6ae4"},"cell_type":"code","source":"test_submission = pd.read_csv(\"../input/sample_submission.csv\")\ntest_submission.head()","execution_count":31,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"169c95b344959cb8db556576973b598dd65d0f15"},"cell_type":"code","source":"test_submission['is_attributed'] = y_predict","execution_count":32,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"e78a3fdec49d52984e45e0d7f21aa2323c162339"},"cell_type":"code","source":"test_submission.head()","execution_count":33,"outputs":[]},{"metadata":{"collapsed":true,"trusted":true,"_uuid":"22ec0a89fab13f06209c3e95e08709b55da51914"},"cell_type":"code","source":"test_submission.to_csv('submission_logistic_.csv', index=False)","execution_count":34,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.6.4"}},"nbformat":4,"nbformat_minor":1}