{"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":"markdown","source":"This notebook has been inspired by work of HENRI UPTON https://www.kaggle.com/code/henriupton/proteinet-pytorch-ems2-t5-protbert-embeddings","metadata":{}},{"cell_type":"code","source":"import pandas as pd\nsub = pd.read_csv(\"/kaggle/input/cafa-5-protein-function-prediction/sample_submission.tsv\", sep= \"\\t\", header = None)\nsub.columns = [\"The Protein ID\", \"The Gene Ontology term (GO) ID\", \"Predicted link probability that GO appear in Protein\"]\nsub.head(5)","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:01.461722Z","iopub.execute_input":"2023-07-24T09:58:01.462232Z","iopub.status.idle":"2023-07-24T09:58:01.719007Z","shell.execute_reply.started":"2023-07-24T09:58:01.462198Z","shell.execute_reply":"2023-07-24T09:58:01.718119Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"MAIN_DIR = \"/kaggle/input/cafa-5-protein-function-prediction\"\n\n# UTILITARIES\nimport numpy as np\nfrom tqdm import tqdm\nimport time\nimport matplotlib.pyplot as plt\nplt.style.use('ggplot')\n\n# TORCH MODULES FOR METRICS COMPUTATION :\nimport torch\nfrom torch.utils.data import Dataset\nfrom torch import nn\nfrom torch.utils.data import random_split\nfrom torch.optim.lr_scheduler import ReduceLROnPlateau\nfrom torchmetrics.classification import MultilabelF1Score\nfrom torchmetrics.classification import MultilabelAccuracy\n\nimport pytorch_lightning as pl\nfrom pytorch_lightning import Trainer\nfrom pytorch_lightning.loggers import WandbLogger\n\n# WANDB FOR LIGHTNING :\nimport wandb\n\n# FILES VISUALIZATION\nimport os\nfor dirname, _, filenames in os.walk('/kaggle/input'):\n    for filename in filenames:\n        print(os.path.join(dirname, filename))","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:01.72096Z","iopub.execute_input":"2023-07-24T09:58:01.721792Z","iopub.status.idle":"2023-07-24T09:58:16.549573Z","shell.execute_reply.started":"2023-07-24T09:58:01.721756Z","shell.execute_reply":"2023-07-24T09:58:16.547863Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"class config:\n    train_sequences_path = MAIN_DIR  + \"/Train/train_sequences.fasta\"\n    train_labels_path = MAIN_DIR + \"/Train/train_terms.tsv\"\n    test_sequences_path = MAIN_DIR + \"/Test (Targets)/testsuperset.fasta\"\n    \n    num_labels = 500\n    n_epochs = 15\n    batch_size = 128\n    lr = 0.001\n    \n    device = torch.device('cuda' if torch.cuda.is_available() else 'cpu')","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.550922Z","iopub.execute_input":"2023-07-24T09:58:16.55152Z","iopub.status.idle":"2023-07-24T09:58:16.566607Z","shell.execute_reply.started":"2023-07-24T09:58:16.551475Z","shell.execute_reply":"2023-07-24T09:58:16.565497Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"print(config.device)","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.56762Z","iopub.execute_input":"2023-07-24T09:58:16.567872Z","iopub.status.idle":"2023-07-24T09:58:16.57276Z","shell.execute_reply.started":"2023-07-24T09:58:16.56785Z","shell.execute_reply":"2023-07-24T09:58:16.571839Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Directories for the different embedding vectors : \nembeds_map = {\n    \"T5\" : \"t5embeds\",\n    \"ProtBERT\" : \"protbert-embeddings-for-cafa5\",\n    \"EMS2\" : \"cafa-5-ems-2-embeddings-numpy\"\n}\n\n# Length of the different embedding vectors :\nembeds_dim = {\n    \"T5\" : 1024,\n    \"ProtBERT\" : 1024,\n    \"EMS2\" : 1280\n}","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.576605Z","iopub.execute_input":"2023-07-24T09:58:16.577366Z","iopub.status.idle":"2023-07-24T09:58:16.584062Z","shell.execute_reply.started":"2023-07-24T09:58:16.577334Z","shell.execute_reply":"2023-07-24T09:58:16.582915Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"class ProteinSequenceDataset(Dataset):\n    \n    def __init__(self, datatype, embeddings_source):\n        super(ProteinSequenceDataset).__init__()\n        self.datatype = datatype\n        \n        if embeddings_source in [\"ProtBERT\", \"EMS2\"]:\n            embeds = np.load(\"/kaggle/input/\"+embeds_map[embeddings_source]+\"/\"+datatype+\"_embeddings.npy\")\n            ids = np.load(\"/kaggle/input/\"+embeds_map[embeddings_source]+\"/\"+datatype+\"_ids.npy\")\n        \n        if embeddings_source == \"T5\":\n            embeds = np.load(\"/kaggle/input/\"+embeds_map[embeddings_source]+\"/\"+datatype+\"_embeds.npy\")\n            ids = np.load(\"/kaggle/input/\"+embeds_map[embeddings_source]+\"/\"+datatype+\"_ids.npy\")\n            \n        embeds_list = []\n        for l in range(embeds.shape[0]):\n            embeds_list.append(embeds[l,:])\n        self.df = pd.DataFrame(data={\"EntryID\": ids, \"embed\" : embeds_list})\n        \n        if datatype==\"train\":\n            np_labels = np.load(\n                \"/kaggle/input/train-targets-top\"+str(config.num_labels)+ \\\n                \"/train_targets_top\"+str(config.num_labels)+\".npy\")\n            df_labels = pd.DataFrame(self.df['EntryID'])\n            df_labels['labels_vect']=[row for row in np_labels]\n            self.df = self.df.merge(df_labels, on=\"EntryID\")\n            \n    def __len__(self):\n        return len(self.df)\n    \n    def __getitem__(self, index):\n        embed = torch.tensor(self.df.iloc[index][\"embed\"] , dtype = torch.float32)\n        if self.datatype==\"train\":\n            targets = torch.tensor(self.df.iloc[index][\"labels_vect\"], dtype = torch.float32)\n            return embed, targets\n        if self.datatype==\"test\":\n            id = self.df.iloc[index][\"EntryID\"]\n            return embed, id\n        ","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.585751Z","iopub.execute_input":"2023-07-24T09:58:16.58644Z","iopub.status.idle":"2023-07-24T09:58:16.599278Z","shell.execute_reply.started":"2023-07-24T09:58:16.586408Z","shell.execute_reply":"2023-07-24T09:58:16.598178Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"## MODEL ARCHITECTURE BUILDING AND TRAINING","metadata":{}},{"cell_type":"code","source":"class MultiLayerPerceptron(torch.nn.Module):\n\n    def __init__(self, input_dim, num_classes):\n        super(MultiLayerPerceptron, self).__init__()\n\n        self.linear1 = torch.nn.Linear(input_dim, 1012)\n        self.activation1 = torch.nn.Tanh()\n        self.linear2 = torch.nn.Linear(1012, 864)\n        self.activation2 = torch.nn.Tanh()\n        self.linear3 = torch.nn.Linear(864, 712)\n        self.activation3 = torch.nn.Tanh()\n        self.linear4 = torch.nn.Linear(712, num_classes)\n      \n\n    def forward(self, x):\n        x = self.linear1(x)\n        x = self.activation1(x)\n        x = self.linear2(x)\n        x = self.activation2(x)\n        x = self.linear3(x)\n        x = self.activation3(x)\n        x = self.linear4(x)\n        return x","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.600322Z","iopub.execute_input":"2023-07-24T09:58:16.600609Z","iopub.status.idle":"2023-07-24T09:58:16.614213Z","shell.execute_reply.started":"2023-07-24T09:58:16.600585Z","shell.execute_reply":"2023-07-24T09:58:16.61337Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"class CNN1D(nn.Module):\n    def __init__(self, input_dim, num_classes):\n        super(CNN1D, self).__init__()\n        # (batch_size, channels, embed_size)\n        self.conv1 = nn.Conv1d(in_channels=1, out_channels=3, kernel_size=3, dilation=1, padding=1, stride=1)\n        # (batch_size, 3, embed_size)\n        self.pool1 = nn.MaxPool1d(kernel_size=2, stride=2)\n        # (batch_size, 3, embed_size/2 = 512)\n        self.conv2 = nn.Conv1d(in_channels=3, out_channels=8, kernel_size=3, dilation=1, padding=1, stride=1)\n        # (batch_size, 8, embed_size/2 = 512)\n        self.pool2 = nn.MaxPool1d(kernel_size=2, stride=2)\n        # (batch_size, 8, embed_size/4 = 256)\n        self.fc1 = nn.Linear(in_features=int(8 * input_dim/4), out_features=128)\n        self.fc2 = nn.Linear(in_features=128, out_features=num_classes)\n\n    def forward(self, x):\n        x = x.reshape(x.shape[0], 1, x.shape[1])\n        x = self.pool1(nn.functional.relu(self.conv1(x)))\n        x = self.pool2(nn.functional.relu(self.conv2(x)))\n        x = torch.flatten(x, 1)\n        x = nn.functional.relu(self.fc1(x))\n        x = self.fc2(x)\n        return x\n","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.615711Z","iopub.execute_input":"2023-07-24T09:58:16.616402Z","iopub.status.idle":"2023-07-24T09:58:16.629862Z","shell.execute_reply.started":"2023-07-24T09:58:16.61637Z","shell.execute_reply":"2023-07-24T09:58:16.628926Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"def train_model(embeddings_source, model_type=\"linear\", train_size=0.9):\n    \n    train_dataset = ProteinSequenceDataset(datatype=\"train\", embeddings_source = embeddings_source)\n    \n    train_set, val_set = random_split(train_dataset, lengths = [int(len(train_dataset)*train_size), len(train_dataset)-int(len(train_dataset)*train_size)])\n    train_dataloader = torch.utils.data.DataLoader(train_set, batch_size=config.batch_size, shuffle=True)\n    val_dataloader = torch.utils.data.DataLoader(val_set, batch_size=config.batch_size, shuffle=True)\n\n    if model_type == \"linear\":\n        model = MultiLayerPerceptron(input_dim=embeds_dim[embeddings_source], num_classes=config.num_labels).to(config.device)\n    if model_type == \"convolutional\":\n        model = CNN1D(input_dim=embeds_dim[embeddings_source], num_classes=config.num_labels).to(config.device)\n\n    optimizer = torch.optim.Adam(model.parameters(), lr = config.lr)\n    scheduler = ReduceLROnPlateau(optimizer, factor=0.1, patience=1)\n    CrossEntropy = torch.nn.CrossEntropyLoss()\n    f1_score = MultilabelF1Score(num_labels=config.num_labels).to(config.device)\n    n_epochs = config.n_epochs\n\n    print(\"BEGIN TRAINING...\")\n    train_loss_history=[]\n    val_loss_history=[]\n    train_f1score_history=[]\n    val_f1score_history=[]\n    \n    best_score = 0.0\n    counter = 0\n    patience = 3  # 设置耐心值\n    \n    for epoch in range(n_epochs):\n        print(\"EPOCH \", epoch+1)\n        ## TRAIN PHASE :\n        losses = []\n        scores = []\n        for embed, targets in tqdm(train_dataloader):\n            embed, targets = embed.to(config.device), targets.to(config.device)\n            optimizer.zero_grad()\n            preds = model(embed)\n            loss= CrossEntropy(preds, targets)\n            score=f1_score(preds, targets)\n            losses.append(loss.item()) \n            scores.append(score.item())\n            loss.backward()\n            optimizer.step()\n            \n        avg_loss = np.mean(losses)\n        avg_score = np.mean(scores)\n        print(\"Running Average TRAIN Loss : \", avg_loss)\n        print(\"Running Average TRAIN F1-Score : \", avg_score)\n        train_loss_history.append(avg_loss)\n        train_f1score_history.append(avg_score)\n        \n        ## VALIDATION PHASE : \n        losses = []\n        scores = []\n        for embed, targets in val_dataloader:\n            embed, targets = embed.to(config.device), targets.to(config.device)\n            preds = model(embed)\n            loss= CrossEntropy(preds, targets)\n            score=f1_score(preds, targets)\n            losses.append(loss.item())\n            scores.append(score.item())\n            \n        avg_loss = np.mean(losses)\n        avg_score = np.mean(scores)\n        print(\"Running Average VAL Loss : \", avg_loss)\n        print(\"Running Average VAL F1-Score : \", avg_score)\n        val_loss_history.append(avg_loss)\n        val_f1score_history.append(avg_score)\n        \n#         scheduler.step(avg_loss)\n#         print(\"\\n\")\n        \n        \n        if avg_score <= best_score:\n            counter += 1\n        else:\n            counter = 0\n\n        best_score = max(avg_score, best_score)\n\n        # 如果连续下降达到指定的耐心值，则停止训练\n        if counter >= patience:\n            print(\"Early stopping triggered!\")\n            break\n\n        scheduler.step(avg_loss)\n        print(\"\\n\")\n        \n        \n    print(\"TRAINING FINISHED\")\n    print(\"FINAL TRAINING SCORE : \", train_f1score_history[-1])\n    print(\"FINAL VALIDATION SCORE : \", val_f1score_history[-1])\n    \n    losses_history = {\"train\" : train_loss_history, \"val\" : val_loss_history}\n    scores_history = {\"train\" : train_f1score_history, \"val\" : val_f1score_history}\n    \n    return model, losses_history, scores_history","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.632835Z","iopub.execute_input":"2023-07-24T09:58:16.633167Z","iopub.status.idle":"2023-07-24T09:58:16.65249Z","shell.execute_reply.started":"2023-07-24T09:58:16.633144Z","shell.execute_reply":"2023-07-24T09:58:16.651523Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#ems2_model, ems2_losses, ems2_scores = train_model(embeddings_source=\"EMS2\",model_type=\"convolutional\")","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.653783Z","iopub.execute_input":"2023-07-24T09:58:16.654358Z","iopub.status.idle":"2023-07-24T09:58:16.666411Z","shell.execute_reply.started":"2023-07-24T09:58:16.654326Z","shell.execute_reply":"2023-07-24T09:58:16.665411Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#t5_model, t5_losses, t5_scores = train_model(embeddings_source=\"T5\",model_type=\"linear\")","metadata":{"execution":{"iopub.status.busy":"2023-07-24T09:58:16.667746Z","iopub.execute_input":"2023-07-24T09:58:16.668349Z","iopub.status.idle":"2023-07-24T09:58:16.67729Z","shell.execute_reply.started":"2023-07-24T09:58:16.668318Z","shell.execute_reply":"2023-07-24T09:58:16.676314Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"protbert_model, protbert_losses, protbert_scores = train_model(embeddings_source=\"ProtBERT\",model_type=\"convolutional\")","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:10:39.798464Z","iopub.execute_input":"2023-07-24T10:10:39.798827Z","iopub.status.idle":"2023-07-24T10:17:07.346195Z","shell.execute_reply.started":"2023-07-24T10:10:39.798797Z","shell.execute_reply":"2023-07-24T10:17:07.345209Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize = (10, 4))\n# plt.plot(ems2_losses[\"val\"], label = \"EMS2\")\n#plt.plot(t5_losses[\"val\"], label = \"T5\")\nplt.plot(protbert_losses[\"val\"], label = \"ProtBERT\") \nplt.title(\"Validation Losses for # Vector Embeddings\")\nplt.xlabel(\"Epochs\")\nplt.ylabel(\"Average Loss\")\nplt.legend()\nplt.show()\n\nplt.figure(figsize = (10, 4))\n# plt.plot(ems2_scores[\"val\"], label = \"EMS2\")\n# plt.plot(t5_scores[\"val\"], label = \"T5\")\nplt.plot(protbert_scores[\"val\"], label = \"ProtBERT\")\nplt.title(\"Validation F1-Scores for # Vector Embeddings\")\nplt.xlabel(\"Epochs\")\nplt.ylabel(\"Average F1-Score\")\nplt.legend()\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:17:12.679917Z","iopub.execute_input":"2023-07-24T10:17:12.680609Z","iopub.status.idle":"2023-07-24T10:17:13.321379Z","shell.execute_reply.started":"2023-07-24T10:17:12.680574Z","shell.execute_reply":"2023-07-24T10:17:13.320476Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"## PREDICTION","metadata":{}},{"cell_type":"code","source":"def predict(embeddings_source):\n    \n    test_dataset = ProteinSequenceDataset(datatype=\"test\", embeddings_source = embeddings_source)\n    test_dataloader = torch.utils.data.DataLoader(test_dataset, batch_size=1, shuffle=False)\n    \n    if embeddings_source == \"T5\":\n        model = t5_model\n    if embeddings_source == \"ProtBERT\":\n        model = protbert_model\n    if embeddings_source == \"EMS2\":\n        model = ems2_model\n        \n    model.eval()\n    \n    labels = pd.read_csv(config.train_labels_path, sep = \"\\t\")\n    top_terms = labels.groupby(\"term\")[\"EntryID\"].count().sort_values(ascending=False)\n    labels_names = top_terms[:config.num_labels].index.values\n    print(\"GENERATE PREDICTION FOR TEST SET...\")\n\n    ids_ = np.empty(shape=(len(test_dataloader)*config.num_labels,), dtype=object)\n    go_terms_ = np.empty(shape=(len(test_dataloader)*config.num_labels,), dtype=object)\n    confs_ = np.empty(shape=(len(test_dataloader)*config.num_labels,), dtype=np.float32)\n\n    for i, (embed, id) in tqdm(enumerate(test_dataloader)):\n        embed = embed.to(config.device)\n        confs_[i*config.num_labels:(i+1)*config.num_labels] = torch.nn.functional.sigmoid(model(embed)).squeeze().detach().cpu().numpy()\n        ids_[i*config.num_labels:(i+1)*config.num_labels] = id[0]\n        go_terms_[i*config.num_labels:(i+1)*config.num_labels] = labels_names\n\n    submission_df = pd.DataFrame(data={\"Id\" : ids_, \"GO term\" : go_terms_, \"Confidence\" : confs_})\n    print(\"PREDICTIONS DONE\")\n    return submission_df","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:17:19.843376Z","iopub.execute_input":"2023-07-24T10:17:19.843738Z","iopub.status.idle":"2023-07-24T10:17:19.856162Z","shell.execute_reply.started":"2023-07-24T10:17:19.843708Z","shell.execute_reply":"2023-07-24T10:17:19.855039Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#submission_df = predict(\"T5\")\n#submission_df = predict(\"EMS2\")\nsubmission_df = predict(\"ProtBERT\")","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:17:49.640928Z","iopub.execute_input":"2023-07-24T10:17:49.641305Z","iopub.status.idle":"2023-07-24T10:20:05.030146Z","shell.execute_reply.started":"2023-07-24T10:17:49.641274Z","shell.execute_reply":"2023-07-24T10:20:05.02839Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"len(submission_df)","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:21:40.044538Z","iopub.execute_input":"2023-07-24T10:21:40.045018Z","iopub.status.idle":"2023-07-24T10:21:40.056661Z","shell.execute_reply.started":"2023-07-24T10:21:40.044961Z","shell.execute_reply":"2023-07-24T10:21:40.055531Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission_df.head()","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:21:44.787965Z","iopub.execute_input":"2023-07-24T10:21:44.78836Z","iopub.status.idle":"2023-07-24T10:21:44.79918Z","shell.execute_reply.started":"2023-07-24T10:21:44.788332Z","shell.execute_reply":"2023-07-24T10:21:44.79819Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"## ENSEMBLING WITH TOP PUBLIC SUBMISSION","metadata":{}},{"cell_type":"code","source":"submission_best_public2 = pd.read_csv('/kaggle/input/cafa-5-053818-pred/submission (3).tsv',\n    sep='\\t', header=None, names=['Id2', 'GO term2', 'Confidence2'])","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:21:56.936778Z","iopub.execute_input":"2023-07-24T10:21:56.937167Z","iopub.status.idle":"2023-07-24T10:22:04.826413Z","shell.execute_reply.started":"2023-07-24T10:21:56.937135Z","shell.execute_reply":"2023-07-24T10:22:04.825397Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# 合并提交文件和数据文件\nsubmissions = submission_best_public2.merge(submission_df, left_on=['Id2', 'GO term2'], right_on=['Id', 'GO term'], how='outer')\nsubmissions.drop(['Id', 'GO term'], axis=1, inplace=True)","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:22:04.828605Z","iopub.execute_input":"2023-07-24T10:22:04.828974Z","iopub.status.idle":"2023-07-24T10:23:13.443508Z","shell.execute_reply.started":"2023-07-24T10:22:04.82894Z","shell.execute_reply":"2023-07-24T10:23:13.44246Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# 生成 confidence_combined 列\nsubmissions['confidence_combined'] = np.where(submissions['Confidence2'].notnull(), submissions['Confidence2'], submissions['Confidence'])\n\n# 保存为 TSV 文件\nsubmissions[['Id2', 'GO term2', 'confidence_combined']].to_csv('submission.tsv', sep='\\t', header=False, index=False)","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:23:13.446831Z","iopub.execute_input":"2023-07-24T10:23:13.447412Z","iopub.status.idle":"2023-07-24T10:27:45.911081Z","shell.execute_reply.started":"2023-07-24T10:23:13.447378Z","shell.execute_reply":"2023-07-24T10:27:45.910039Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#  该列被修改\n# submissions['confidence_combined'] = submissions.apply(lambda row: row['Confidence2'] if not np.isnan(row['Confidence2']) else row['Confidence'], axis=1)","metadata":{"execution":{"iopub.status.busy":"2023-07-24T10:05:10.467513Z","iopub.status.idle":"2023-07-24T10:05:10.468517Z","shell.execute_reply.started":"2023-07-24T10:05:10.468242Z","shell.execute_reply":"2023-07-24T10:05:10.468272Z"},"trusted":true},"execution_count":null,"outputs":[]}]}