{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.11.11","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":96164,"databundleVersionId":11418275,"sourceType":"competition"},{"sourceId":12222425,"sourceType":"datasetVersion","datasetId":7610337}],"dockerImageVersionId":31040,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"&nbsp; **Top 5** public notebooks - 07.06.2025 - LB = **0.10727**\n\n- 0.10490 - v.21 - [DRW_LightGBM_Fold](https://www.kaggle.com/code/yangq369/drw-lightgbm-fold) - [Yallon](https://www.kaggle.com/yangq369)\n- 0.10001 - v.03 - [DRW Remix V - MWDH](https://www.kaggle.com/code/migrantworkerdatahub/drw-remix-v-mwdh) - [Migrant Worker Data Hub](https://www.kaggle.com/migrantworkerdatahub)\n- 0.10274 - v.02 - [DRW Remix V - MWDH - Feature Addition](https://www.kaggle.com/code/jasongou/drw-remix-v-mwdh-feature-addition) - [Jason Gou](https://www.kaggle.com/jasongou)\n- 0.10273 - v.16 - [20250531_DRW](https://www.kaggle.com/code/elainedazzio/20250531-drw) - [L. Elaine Dazzio](https://www.kaggle.com/elainedazzio)\n- 0.10192 - v.01 - [DRW Remix V](https://www.kaggle.com/code/taylorsamarel/drw-remix-v) - [Taylor S. Amarel](https://www.kaggle.com/taylorsamarel)\n\n&nbsp; **Top 5** public notebooks - 11.06.2025 - LB = **0.11026**\n\n- 0.11239 - v.01 - [DRW Remix VI](https://www.kaggle.com/code/bakuer30/drw-remix-vi) - [Bakuer30](https://www.kaggle.com/bakuer30/code)\n- 0.11032 - v.01 - [xgb+lgbm ensemble](https://www.kaggle.com/code/yehqysns/xgb-lgbm-ensemble) - [yehqysns](https://www.kaggle.com/yehqysns/code)\n- 0.10838 - v.17 - [20250602_DRW](https://www.kaggle.com/code/elainedazzio/20250602-drw/notebook) - [L. Elaine Dazzio](https://www.kaggle.com/elainedazzio/code)\n- 0.10739 - v.04 - [DRW: XGBoost + LGBM + Regimes + Added Features](https://www.kaggle.com/code/digantabhattacharya/drw-xgboost-lgbm-regimes-added-features) - [Diganta](https://www.kaggle.com/digantabhattacharya/code)\n- 0.10727 - v.02 - [DRW - Crypto](https://www.kaggle.com/code/nina2025/drw-crypto) - [Lion-li-li](https://www.kaggle.com/nina2025/code)\n\n&nbsp; **Top 4** public notebooks - 12.06.2025 - LB = **0.11471**\n\n- 0.11365 - v.01 - [DRW|Data Standardization](https://www.kaggle.com/code/yich723/drw-data-standardization) - [yich](https://www.kaggle.com/yich723)\n- 0.11356 - v.01 - [DRW_ver2](https://www.kaggle.com/code/seowoohyeon/drw-ver2/notebook) - [seowoohyeon](https://www.kaggle.com/seowoohyeon)\n- 0.11239 - v.01 - [DRW Remix VI](https://www.kaggle.com/code/bakuer30/drw-remix-vi) - [Bakuer30](https://www.kaggle.com/bakuer30/code)\n- 0.11032 - v.01 - [xgb+lgbm ensemble](https://www.kaggle.com/code/yehqysns/xgb-lgbm-ensemble) - [yehqysns](https://www.kaggle.com/yehqysns/code)\n\n&nbsp; **Top 3** public notebooks - 14.06.2025 - LB = **0.11758**\n- 0.11756 - v.14 - [DRW Competition Submission](https://www.kaggle.com/code/rosswade/drw-competition-submission/notebook?scriptVersionId=245352571) - [Ross Wade](https://www.kaggle.com/rosswade)\n- 0.11730 - v.02 - [DRW Remix VI](https://www.kaggle.com/code/bakuer30/drw-remix-vi) - [Bakuer30](https://www.kaggle.com/bakuer30/code)\n- 0.11365 - v.01 - [DRW|Data Standardization](https://www.kaggle.com/code/yich723/drw-data-standardization) - [yich](https://www.kaggle.com/yich723)\n\n&nbsp; **Top 4** public notebooks - 15.06.2025 - LB = **0.11759**\n- 0.11756 - v.14 - [DRW Competition Submission](https://www.kaggle.com/code/rosswade/drw-competition-submission/notebook?scriptVersionId=245352571) - [Ross Wade](https://www.kaggle.com/rosswade)\n- 0.11730 - v.02 - [DRW Remix VI](https://www.kaggle.com/code/bakuer30/drw-remix-vi) - [Bakuer30](https://www.kaggle.com/bakuer30/code)\n- 0.11416 - v.05 - [New Feature Discovery](https://www.kaggle.com/code/taylorsamarel/new-feature-discovery) - [Taylor S. Amarel](https://www.kaggle.com/taylorsamarel)\n- 0.11365 - v.01 - [DRW|Data Standardization](https://www.kaggle.com/code/yich723/drw-data-standardization) - [yich](https://www.kaggle.com/yich723)\n\n&nbsp; **Top 3** public notebooks - 16.06.2025 - LB = **0.11883**\n- 0.11884 - v.01 - [DRW_2](https://www.kaggle.com/code/rozzzz/drw-2/output?scriptVersionId=245591154) - [ROZZZZ](https://www.kaggle.com/rozzzz)\n- 0.11756 - v.14 - [DRW Competition Submission](https://www.kaggle.com/code/rosswade/drw-competition-submission/notebook?scriptVersionId=245352571) - [Ross Wade](https://www.kaggle.com/rosswade)\n- 0.11730 - v.02 - [DRW Remix VI](https://www.kaggle.com/code/bakuer30/drw-remix-vi) - [Bakuer30](https://www.kaggle.com/bakuer30/code)\n\n&nbsp; **2** public notebooks - 17.06.2025 - LB = **0.11883**\n- 0.11884 - v.01 - [DRW_2](https://www.kaggle.com/code/rozzzz/drw-2/output?scriptVersionId=245591154) - [ROZZZZ](https://www.kaggle.com/rozzzz)\n- 0.08861 - v.05 - [DRW Crypto Market Prediction | AutoGluon](https://www.kaggle.com/code/ravaghi/drw-crypto-market-prediction-autogluon) - [Mahdi Ravaghi](https://www.kaggle.com/ravaghi)\n\n&nbsp; **Top 3** + AutoGluon public notebooks - 18.06.2025 - LB = ?\n- 0.11884 - v.01 - [DRW_2](https://www.kaggle.com/code/rozzzz/drw-2/output?scriptVersionId=245591154) - [ROZZZZ](https://www.kaggle.com/rozzzz)\n- 0.11756 - v.14 - [DRW Competition Submission](https://www.kaggle.com/code/rosswade/drw-competition-submission/notebook?scriptVersionId=245352571) - [Ross Wade](https://www.kaggle.com/rosswade)\n- 0.11730 - v.02 - [DRW Remix VI](https://www.kaggle.com/code/bakuer30/drw-remix-vi) - [Bakuer30](https://www.kaggle.com/bakuer30/code)\n- 0.08861 - v.05 - [DRW Crypto Market Prediction | AutoGluon](https://www.kaggle.com/code/ravaghi/drw-crypto-market-prediction-autogluon) - [Mahdi Ravaghi](https://www.kaggle.com/ravaghi)\n\n&nbsp; **Top 2** + AutoGluon public notebooks - 19.06.2025 - LB = ?\n- 0.11914 - v.06 - [DRW - Crypto d75cea](https://www.kaggle.com/code/jasonzhang2022/drw-crypto-d75cea/notebook) - [jason](https://www.kaggle.com/jasonzhang2022)\n- 0.11893 - v.03 - [DRW_2](https://www.kaggle.com/code/rozzzz/drw-2/output?scriptVersionId=245591154) - [ROZZZZ](https://www.kaggle.com/rozzzz)\n- 0.08861 - v.05 - [DRW Crypto Market Prediction | AutoGluon](https://www.kaggle.com/code/ravaghi/drw-crypto-market-prediction-autogluon) - [Mahdi Ravaghi](https://www.kaggle.com/ravaghi)","metadata":{}},{"cell_type":"code","source":"import pandas as pd\n\n\npath = '/kaggle/input/drw-quatro-2/'\n\n#df1  = pd.read_csv(path+ 'Means_5_files - 07-06-2025.csv' ) # Lb=0.10727\n#df2  = pd.read_csv(path+ 'Means_5_files - 11-06-2025.csv' ) # Lb=0.11026\n#df3  = pd.read_csv(path+ 'Means_4_files (40-30-20-10).csv') # Lb=0.11427\n#df4  = pd.read_csv(path+ 'Means_4_files (25-25-25-25).csv') # Lb=0.11471\n\np = '14-06-2025--3_Top_public_subm__schema_weights_'\n\n#df5  = pd.read_csv(path+p+          '(34-33-33).csv'      ) # Lb=?\n#df6  = pd.read_csv(path+p+          '(40-40-20).csv'      ) # Lb=0.11747    v.17\n#df7  = pd.read_csv(path+p+          '(45-45-10).csv'      ) # Lb=0.11754    v.16\n#df8  = pd.read_csv(path+p+          '(50-45-05).csv'      ) # Lb=0.11755    v.15\n#df9  = pd.read_csv(path+p+          '(54-45-01).csv'      ) # Lb=0.11754    v.14\n#df10 = pd.read_csv(path+p+          '(74-21-05).csv'      ) # Lb=0.11758    v.18\n\np = '15-06-2025--4_Top_public_subm__schema_weights_'\n\n#df11 = pd.read_csv(path+p+       '(25-25-25-25).csv'      ) # Lb=?\n#df12 = pd.read_csv(path+p+       '(79-15-00-06).csv'      ) # Lb=0.11759    v.23\n#df13 = pd.read_csv(path+p+       '(82-13-00-05).csv'      ) # Lb=0.11759    v.22\n#df14 = pd.read_csv(path+p+       '(85-09-04-02).csv'      ) # Lb=0.11754    v.21\n#df15 = pd.read_csv(path+p+       '(90-07-02-01).csv'      ) # Lb=0.11756    v.19\n#df16 = pd.read_csv(path+p+       '(77-17-004-056).csv'    ) # Lb=0.11758    v.24\n\np = '16-06-2025--3_Top_public_subm__schema_weights_'\n\n#df17 = pd.read_csv(path+p+       '(34-33-33).csv'         ) # Lb=0.11805\n#df18 = pd.read_csv(path+p+       '(995-004-001).csv'      ) # Lb=0.11883\n#df19 = pd.read_csv(path+p+       '(80-15-05).csv'         ) # Lb=0.11864\n#df20 = pd.read_csv(path+p+       '(90-07-03).csv'         ) # Lb=0.11874\n#df21 = pd.read_csv(path+p+       '(95-04-01).csv'         ) # Lb=0.11879\n\np = '17-06-2025--2_public_subm__schema_weights_'\n\n#df22 = pd.read_csv(path+p+       '(95-05).csv'            ) # Lb=0.11865\n#df23 = pd.read_csv(path+p+       '(98-02).csv'            ) # Lb=0.11877\n#df24 = pd.read_csv(path+p+       '(99-01).csv'            ) # Lb=0.11880\n#df25 = pd.read_csv(path+p+       '(995-005).csv'          ) # Lb=0.11882\n#df26 = pd.read_csv(path+p+       '(998-002).csv'          ) # Lb=0.11883\n\np = '18-06-2025--3_Top+AutoGluon_public_subm__schema_weights_'\n\n#df27 = pd.read_csv(path+p+       '(9930-0040-0010-0020).csv'  ) # Lb=\n#df28 = pd.read_csv(path+p+       '(9955-0030-0005-0010).csv'  ) # Lb=\n#df29 = pd.read_csv(path+p+       '(9955-0025-0005-0015).csv'  ) # Lb=\n#df30 = pd.read_csv(path+p+       '(9970-0010-0010-0010).csv'  ) # Lb=\n#df31 = pd.read_csv(path+p+       '(9985-0005-0005-0005).csv'  ) # Lb=\n\np = '19-06-2025--3_public_subm__schema_weights_'\n\n#df32 = pd.read_csv(path+p+       '(998-0015-0005).csv'        ) # Lb=0.11914\n#df33 = pd.read_csv(path+p+       '(998-0015-0005)e.csv'       ) # Lb=0.11914 < df32\n#df34 = pd.read_csv(path+p+       '(998-0015-0005)o.csv'       ) # Lb=0.11914 < df32, > df33\n#df35 = pd.read_csv(path+p+       '(9974-0021-0004).csv'       ) # Lb=0.11914 > df32\n#df37 = pd.read_csv(path+p+       '(9800-0126-0074).csv'       ) # Lb=0.11911\n\ndf36 = pd.read_csv(path+p+       '(9921-0074-0005).csv'       ) # Lb=0,11914 > df35 - Best\n\ndf = df36\ndf.to_csv(\"submission.csv\", index=False)\ndf","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-06-20T00:58:05.986884Z","iopub.execute_input":"2025-06-20T00:58:05.987573Z","iopub.status.idle":"2025-06-20T00:58:07.702257Z","shell.execute_reply.started":"2025-06-20T00:58:05.987540Z","shell.execute_reply":"2025-06-20T00:58:07.701393Z"}},"outputs":[],"execution_count":null}]}