{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.10.13","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":67356,"databundleVersionId":8006601,"sourceType":"competition"}],"dockerImageVersionId":30698,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import duckdb\nimport pandas as pd\nfrom sklearn.preprocessing import LabelEncoder\nfrom sklearn.ensemble import RandomForestClassifier\nfrom sklearn.model_selection import train_test_split\nfrom sklearn.metrics import average_precision_score, accuracy_score, precision_score, recall_score, f1_score, roc_auc_score\n\n# Eğitim ve test verisi yolları (PARQUET)\ntrain_path = '/kaggle/input/leash-BELKA/train.parquet'\ntest_path = '/kaggle/input/leash-BELKA/test.parquet'\n\n# DuckDB kullanarak veriyi küçültme\ncon = duckdb.connect()\n\n# Eğitim verisini küçültme\ndf = con.query(f\"\"\"\n    (SELECT *\n     FROM parquet_scan('{train_path}')\n     WHERE binds = 0\n     ORDER BY random()\n     LIMIT 200000)\n     UNION ALL\n    (SELECT *\n     FROM parquet_scan('{train_path}')\n     WHERE binds = 1\n     ORDER BY random()\n     LIMIT 200000)\n\"\"\").df()","metadata":{"execution":{"iopub.status.busy":"2024-05-30T02:23:53.51216Z","iopub.execute_input":"2024-05-30T02:23:53.512598Z","iopub.status.idle":"2024-05-30T02:23:53.541078Z","shell.execute_reply.started":"2024-05-30T02:23:53.512566Z","shell.execute_reply":"2024-05-30T02:23:53.539373Z"},"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"pip install duckdb","metadata":{"execution":{"iopub.status.busy":"2024-05-30T02:24:03.253359Z","iopub.execute_input":"2024-05-30T02:24:03.25496Z","iopub.status.idle":"2024-05-30T02:24:18.418008Z","shell.execute_reply.started":"2024-05-30T02:24:03.254906Z","shell.execute_reply":"2024-05-30T02:24:18.416364Z"},"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"import pandas as pd\n# Test verisini yükleme\ntest_df = pd.read_parquet(test_path)\n\ncon.close()\n\n# Verileri string türüne dönüştürmek\nfor col in ['protein_name', 'buildingblock1_smiles', 'buildingblock2_smiles', 'buildingblock3_smiles', 'molecule_smiles']:\n    df[col] = df[col].astype(str)\n    test_df[col] = test_df[col].astype(str)\n\n# LabelEncoder'ı uygulayalım\nle = LabelEncoder()\nfor col in ['protein_name', 'buildingblock1_smiles', 'buildingblock2_smiles', 'buildingblock3_smiles', 'molecule_smiles']:\n    combined = pd.concat([df[col], test_df[col]], axis=0)\n    le.fit(combined)\n    df[col] = le.transform(df[col])\n    test_df[col] = le.transform(test_df[col])","metadata":{"execution":{"iopub.status.busy":"2024-05-30T02:23:32.563562Z","iopub.execute_input":"2024-05-30T02:23:32.564122Z","iopub.status.idle":"2024-05-30T02:23:32.598108Z","shell.execute_reply.started":"2024-05-30T02:23:32.564084Z","shell.execute_reply":"2024-05-30T02:23:32.596247Z"},"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"\n","metadata":{"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"\n","metadata":{"execution":{"iopub.status.busy":"2024-05-30T02:02:25.001248Z","iopub.execute_input":"2024-05-30T02:02:25.001749Z","iopub.status.idle":"2024-05-30T02:02:25.015302Z","shell.execute_reply.started":"2024-05-30T02:02:25.001721Z","shell.execute_reply":"2024-05-30T02:02:25.014062Z"},"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"\n","metadata":{"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"","metadata":{"execution":{"iopub.status.busy":"2024-05-30T02:08:08.599953Z","iopub.execute_input":"2024-05-30T02:08:08.600732Z","iopub.status.idle":"2024-05-30T02:08:18.595622Z","shell.execute_reply.started":"2024-05-30T02:08:08.600698Z","shell.execute_reply":"2024-05-30T02:08:18.594421Z"},"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"\n","metadata":{"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"","metadata":{"execution":{"iopub.status.busy":"2024-05-30T02:05:50.168848Z","iopub.execute_input":"2024-05-30T02:05:50.169212Z","iopub.status.idle":"2024-05-30T02:05:50.173756Z","shell.execute_reply.started":"2024-05-30T02:05:50.169186Z","shell.execute_reply":"2024-05-30T02:05:50.172771Z"},"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"","metadata":{"trusted":true},"outputs":[],"execution_count":null},{"cell_type":"code","source":"","metadata":{},"outputs":[],"execution_count":null}]}