Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import os\n",
    "from collections import Counter\n",
    "from sklearn.model_selection import train_test_split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.ensemble import RandomForestClassifier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_set  = pd.read_csv('/Users/iknott/Desktop/Kaggle/DrivenData/test_values.csv')\n",
    "train_set = pd.read_csv('/Users/iknott/Desktop/Kaggle/DrivenData/train_values.csv')\n",
    "label_set = pd.read_csv('/Users/iknott/Desktop/Kaggle/DrivenData/train_labels.csv')\n",
    "sub_set   = pd.read_csv('/Users/iknott/Desktop/Kaggle/DrivenData/submission.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "========= train columns ==========\n",
      "['sequence_id', 'sequence', 'bacterial_resistance_ampicillin', 'bacterial_resistance_chloramphenicol', 'bacterial_resistance_kanamycin', 'bacterial_resistance_other', 'bacterial_resistance_spectinomycin', 'copy_number_high_copy', 'copy_number_low_copy', 'copy_number_unknown', 'growth_strain_ccdb_survival', 'growth_strain_dh10b', 'growth_strain_dh5alpha', 'growth_strain_neb_stable', 'growth_strain_other', 'growth_strain_stbl3', 'growth_strain_top10', 'growth_strain_xl1_blue', 'growth_temp_30', 'growth_temp_37', 'growth_temp_other', 'selectable_markers_blasticidin', 'selectable_markers_his3', 'selectable_markers_hygromycin', 'selectable_markers_leu2', 'selectable_markers_neomycin', 'selectable_markers_other', 'selectable_markers_puromycin', 'selectable_markers_trp1', 'selectable_markers_ura3', 'selectable_markers_zeocin', 'species_budding_yeast', 'species_fly', 'species_human', 'species_mouse', 'species_mustard_weed', 'species_nematode', 'species_other', 'species_rat', 'species_synthetic', 'species_zebrafish']\n",
      "========= test columns ==========\n",
      "['sequence_id', 'sequence', 'bacterial_resistance_ampicillin', 'bacterial_resistance_chloramphenicol', 'bacterial_resistance_kanamycin', 'bacterial_resistance_other', 'bacterial_resistance_spectinomycin', 'copy_number_high_copy', 'copy_number_low_copy', 'copy_number_unknown', 'growth_strain_ccdb_survival', 'growth_strain_dh10b', 'growth_strain_dh5alpha', 'growth_strain_neb_stable', 'growth_strain_other', 'growth_strain_stbl3', 'growth_strain_top10', 'growth_strain_xl1_blue', 'growth_temp_30', 'growth_temp_37', 'growth_temp_other', 'selectable_markers_blasticidin', 'selectable_markers_his3', 'selectable_markers_hygromycin', 'selectable_markers_leu2', 'selectable_markers_neomycin', 'selectable_markers_other', 'selectable_markers_puromycin', 'selectable_markers_trp1', 'selectable_markers_ura3', 'selectable_markers_zeocin', 'species_budding_yeast', 'species_fly', 'species_human', 'species_mouse', 'species_mustard_weed', 'species_nematode', 'species_other', 'species_rat', 'species_synthetic', 'species_zebrafish']\n",
      "========= train columns ==========\n",
      "['sequence_id', '00Q4V31T', '012VT4JK', '028IO5W2', '03GRNN7N', '03Y3W51H', '09MQV1TY', '0A4AHRCT', '0A9M05NC', '0B9GCUVV', '0CL7QVG8', '0CML4B5I', '0DTHTJLJ', '0FFBBVE1', '0HWCWFNU', '0L3Y6ZB2', '0M44GDO8', '0MDYJM3H', '0N3V9P9M', '0NP55E93', '0PJ91ZT6', '0R296F9R', '0T2AZBD6', '0URA80CN', '0VRP2DI6', '0W6O08VX', '0WHP4PPK', '0XPTGGLP', '0XS4FHP3', '0Y24J5G2', '10TEBWK2', '11TTDKTM', '131RRHBV', '13LZE1F7', '14PBN8C2', '15D0Z97U', '15S88O4Q', '18C9J8EH', '19CAUKJB', '1AP294AT', '1B9BJ2IP', '1BE35FI1', '1CIHYCE4', '1DJ9L58E', '1DTDCRUO', '1EDZ6CA7', '1HCQTAYT', '1HK4VXP8', '1IXFZ3HO', '1K11RCST', '1KC6XYO6', '1KNFJ6KQ', '1KZHNVYR', '1LBGAU5Z', '1NXRMDN6', '1OQJ21E9', '1OWZDF82', '1PA232PA', '1PIGWQFY', '1Q1IUY3G', '1S515B69', '1TC200QC', '1TI4HS4X', '1UOA7CA1', '1UREJUSJ', '1UU0CHTK', '1VPOX8VI', '1VQS4WNS', '1X0VC0O1', '1XU60MET', '1ZC8RPN1', '20ABQYHS', '20CEB9KE', '216DWMG6', '21ZFBX5E', '24SL2992', '25UVYUID', '26KK8UM5', '27OS3BTP', '28D4D4QM', '298AMR5C', '29D6Q091', '2AQG6I31', '2BAFY4GP', '2CJHRNWD', '2FCX4O0X', '2GGU2QA2', '2GSZMU46', '2GTLIT33', '2H37WPKA', '2HNZZYDB', '2JPNC9X6', '2KDACBQT', '2L336TQL', '2M3CXS8N', '2MCB7LXW', '2MQ2NPMA', '2NEXWXMT', '2PY8K6GU', '2Q33W599', '2SSVM7H9', '2TVMHQTW', '2TXY439E', '2VP4JPB9', '2VTLZHDS', '2VX4F6RC', '2XC1478M', '2XX0N87I', '2Y9L13L4', '2YCH1PUI', '2YLQA8OZ', '303BN0Z0', '318RH8P0', '330L4OIV', '33AR5KVE', '343M819H', '34TE1Q0A', '35MKXPL0', '36W150XW', '36XLYYGZ', '37VO60SB', '384ASNLB', '38MDETY1', '38MEQ4SU', '39LLQ2PB', '39TEZ0C3', '39TPBOL7', '3BGLF8BC', '3C2VZQ2R', '3C952KY7', '3D9CMQ4V', '3EARN0Z7', '3EYBG174', '3EZXYI3U', '3FPH0N6R', '3FW33G68', '3GEXBRC0', '3KCEM7V4', '3L314D8W', '3LSNTL1N', '3MDRJUI2', '3MX1D3LD', '3N169DM2', '3NSJ6N02', '3O1GIAV7', '3QP4D23X', '3RK54JUW', '3TLD81QQ', '3TUFYWQN', '3TXFYNKG', '3X2GGDHW', '3XE0BJDW', '3YAQWNBK', '3YEGUN04', '3YYEC52Y', '40MD0YZ3', '40ZI3TDN', '443NZOSB', '448QVC4C', '44N2CYI9', '459BZKP3', '4648UZGD', '46AZ97U9', '48F0EUVN', '49571DXY', '49YZILWR', '4CKAV3LS', '4DGGCYVE', '4DGMNDIC', '4E7187A9', '4GF31RCS', '4GHCND6Z', '4IADYZ8R', '4IDTMY10', '4J7KEYE2', '4KSHU5M7', '4LCFACE1', '4LQ8L195', '4M3XG8RC', '4O39WLXM', '4O5RQHEF', '4PKCMX7O', '4QK5ZDHA', '4QU07FT7', '4RCA1UZG', '4RHLX089', '4S1LIWGV', '4TIT4L5F', '4U5LAAN5', '4VHMF1RI', '4WAQ4VFB', '4WRI77CU', '4X2RTV2D', '4Y4DT3SL', '4ZYW54M8', '50NBGIOB', '52Y9GFGK', '54C6PEBH', '54ZFOPSF', '558GIQ68', '55HTZ7T0', '579G0TJI', '57FHO8YC', '57NGF1YS', '58BSUZQB', '5ASQZ0OT', '5AUVXXDU', '5BNUT8AW', '5BTY65G6', '5CBNCRST', '5FUDT1QA', '5H71LUBY', '5K2PTY6L', '5KXWXV9G', '5LH9NUMK', '5OBD73W0', '5OF7OYEA', '5OFUVG9U', '5PC2F8NE', '5PR9OSRS', '5Q9ETXJL', '5QLBIUXN', '5QY2HU8J', '5SCOFTY2', '5SGMS705', '5V3Z108E', '5W2PCT95', '5X9VNAN3', '5Z4CMIY5', '5ZB8I3T0', '5ZW05824', '60HBQEP8', '62PKSARW', '638UYIQC', '64FFXH4M', '65CCBIXK', '669R7ER0', '66XSSS3Q', '685KTH3G', '68OY1RK5', '69M351P4', '6AT20D5S', '6DBY872A', '6E28DNQK', '6KT0EAKX', '6LQ0W02R', '6NCTAA30', '6NKNB308', '6NULQ6KP', '6PS2LHCV', '6PXRABDR', '6QBXXYN4', '6QUCW04X', '6SBB6IL2', '6T9SGGS1', '6TT5CXVI', '6TTWEXT3', '6UGWNYCX', '6UI9XACW', '6UXF7L28', '6WD2LIHN', '6WT1F4RJ', '6XVBD39G', '6YSX60MZ', '7039MMH2', '709K4VRB', '7185O9V8', '71R7TM8L', '738FBTIL', '73RKEO3U', '747XMBIJ', '74RXUGS4', '74TS5KG4', '78QGAL01', '78XDAJNS', '7ANCD9AK', '7DMNXU84', '7E63E5RD', '7F905YRZ', '7GWW4637', '7IHPTKFF', '7KG191H8', '7MUAYEHW', '7NGLQ1CA', '7O3PWIL0', '7OV5K86R', '7PWA4ZJN', '7QEORFJN', '7QF2VB5B', '7QWHL2C6', '7SW79VAJ', '7T28F53W', '7TYZHD5J', '7UU8O65I', '7WKS90AG', '7X3RSRT5', '7XPDUYJE', '7XU8ACPI', '7YSTNZME', '7ZV0Z1T9', '81QAZACE', '82NXGO4K', '862RYK1K', '86ET7WW4', '88E6O06E', '8ABA3MWO', '8BF8ANNO', '8C0T09C6', '8C9737JL', '8D4D6M5V', '8ECLELF1', '8EKC599S', '8F0XPAZX', '8FT6HD4D', '8FZMCIFG', '8G29TDOS', '8H6M75LF', '8HI3GY44', '8HW91I4K', '8HZXGARR', '8IPYO6SS', '8JKDTT0Y', '8K0HZBL0', '8MUKKVMF', '8MW998Z0', '8N5EPD5C', '8OBT3FSQ', '8ORZZFA7', '8RIKS696', '8SW7WFE6', '8T12OXHS', '8US76O46', '8VCFY56I', '8VI1RY3M', '8VLB2R3D', '8WAY3T1E', '8Z6SANMH', '8ZB94ICE', '8ZB99KHH', '904V6V2S', '909V5A2H', '91Y7NKBM', '91Z8RRSB', '92WF5WVN', '93R70J1L', '93WIIL7Y', '97FR69TQ', '97PR85CP', '99A19JAD', '9DBCRJYM', '9DKQF2I2', '9DRMDPIZ', '9G5XH4HI', '9GDHC3D0', '9HPM9NFY', '9HRDSOST', '9IVIPDX5', '9JRKFKVC', '9KHXMSMW', '9KV8R3HP', '9LSH625Y', '9MC0DPDJ', '9MC1YKKZ', '9MEFUZQN', '9MG50RM7', '9MZBKXJF', '9PWYZMNS', '9QQZ79I6', '9R765PJF', '9SJCUIKS', '9SSQ1FSY', '9U0DELRD', '9WEGTUIJ', '9WQQKFVK', '9XE0FL8P', '9Y5EWA8O', '9YM3QINZ', '9ZTEQPA4', 'A0ADXLZU', 'A0Z7XCDN', 'A1738D1Z', 'A18S09P2', 'A1A8EROR', 'A1J0YXZX', 'A2A1R52R', 'A2U1AIC1', 'A332O9JW', 'A3FZPLM1', 'A3QUOXIX', 'A44GW57T', 'A4BM0B6A', 'A6RCKKER', 'A768XIWP', 'A78F2YFJ', 'A7CK3WNB', 'A810BWR5', 'A8FZHMOS', 'A9G8OKRG', 'AATDRXYQ', 'AAURK3RG', 'ABMAPCYN', 'ABWCZWFU', 'ACO8WWPF', 'ADB7SAPN', 'AG93GZYN', 'AHMVJ2VP', 'AL7N3DL2', 'AM8AJH2H', 'AMSPTQVJ', 'AMV4U0A0', 'AOCCEP3S', 'AOFJN8HX', 'AOFPYGHC', 'AOKRU4AF', 'AOQQU910', 'AR433PVR', 'AS30HPUK', 'AUCMR8HU', 'AUUSW2YZ', 'AUZNSS79', 'AV7ONIVD', 'AWWC1KIV', 'B131HDBV', 'B17J3JSX', 'B1I4L0XW', 'B25KOPVH', 'B2BULVFH', 'B4L9R8JU', 'B517ID6W', 'B832TQ6U', 'B8FC99WI', 'B8YR9IIK', 'B9H5SLHK', 'BBTA1L43', 'BBZJCYJ0', 'BD9EXLDM', 'BDQOSDFG', 'BDSEVK9M', 'BH7HW7XH', 'BHKOO62U', 'BHNI9DCI', 'BHW9ILRC', 'BJKTDFN4', 'BL2TLVFC', 'BLC9WIIM', 'BLFM4YKK', 'BLNELN02', 'BN8BMXPM', 'BNFZZTKX', 'BP2X9ITX', 'BPT27UPE', 'BQJ79YS3', 'BSEEWS00', 'BSH6LB19', 'BTQL3UFQ', 'BV6PVSO5', 'BV8D4RYV', 'BWFN4ZI7', 'BXMEKONO', 'BY5IEG4O', 'BZBNZDNS', 'C1BIUBL5', 'C35C2C2W', 'C4W63WJ2', 'CA0MBQ9S', 'CAO2H0WE', 'CAQEITX6', 'CB714TAM', 'CBCQST29', 'CBFKYZ9S', 'CBKRHK4I', 'CDM3SRRP', 'CDU1LWN3', 'CEATO4LM', 'CENOJ84D', 'CFDEOSH4', 'CFOET28L', 'CFQ9PAJA', 'CHTQ7QLX', 'CJFLQNE1', 'CK1M5UHL', 'CKDZNQV2', 'CLO7VQ12', 'CNX48K3H', 'COEMYLH1', 'COVE5WRD', 'CRP30ATM', 'CTJGWLX0', 'CTLP20Y9', 'CWZP8AQK', 'CY64689U', 'CYCSYMQ3', 'CZUGPH88', 'D0EKC82X', 'D0NFHXL2', 'D0YWREJ5', 'D10S0UDQ', 'D1BZRMOB', 'D2N5DOSQ', 'D3KJQCYH', 'D4PJE56U', 'D4Q1QMRJ', 'D63K976U', 'D7L6VZNV', 'D8MRQA91', 'D8OQ3YNK', 'DD0JBK3T', 'DE6NAU7D', 'DEFNZK0A', 'DEWKAO5I', 'DGE8LLAJ', 'DGQ2L6KM', 'DJW5U56I', 'DKA65CRR', 'DLSU0QRX', 'DN01XVIU', 'DQGG01WF', 'DRFCUPZO', 'DSE2G8LF', 'DY0KIZZ9', 'DZ2XFGQS', 'E3CE5WE9', 'E3CRPQL7', 'E3FFACSU', 'E4EF2K0A', 'E4T4IQMG', 'E59C5N01', 'E5OB5QF1', 'E6G69ESA', 'E6TPDVWA', 'E7CPRIYW', 'E7EZD62E', 'E8100WU0', 'E8GMEHFW', 'EA2DKNTD', 'EBF1G8Z7', 'ED0OS5OF', 'EEC8D29F', 'EFKGYR79', 'EI8B4WEC', 'EJ3T17DB', 'EJXP2QAW', 'EKHYS325', 'EKXAPD70', 'EL9FN1LB', 'ELF2BN3S', 'ELX1D1DS', 'EMJXDINV', 'EMNH5MYX', 'EN78WKI4', 'EOQAQ9X1', 'EPDX32D3', 'EQPB3YTZ', 'ER1IJR80', 'ETR2SP13', 'EW4ZXWSN', 'EXQZ5V7S', 'EYOJGC9T', 'EZ40BRHE', 'EZL4HNHH', 'EZMV5TKG', 'F0ESSJYM', 'F0MOWJYA', 'F1X6DMDH', 'F3D2JAYU', 'F3S4VUQI', 'F50DBVIK', 'F8I0DT7Z', 'F8LNIZ27', 'FCI1HZ3G', 'FEBWERSN', 'FH8TEJI1', 'FHR8UUYO', 'FHZYKEUV', 'FJTJ4KY0', 'FLHGDG0P', 'FLSWA4NU', 'FLU9ZT18', 'FMJ19E48', 'FN1RKQ2M', 'FN38BX60', 'FNKCHGB7', 'FNM1Z945', 'FPH5H8JT', 'FQ8V2QHL', 'FRFT0H8N', 'FRK40JVP', 'FRX9XJYW', 'FSR0IC6I', 'FVYCRUFK', 'FWOZ05UZ', 'FXBIP7LS', 'FXRWH0M9', 'FZ37IFWH', 'G2P73NZ0', 'G4UJDFPK', 'G57JANUL', 'G6MP6EIN', 'G7MXLRV8', 'G81LO0AZ', 'G8QWQL1C', 'GB45D1XV', 'GBX3MNVS', 'GDV3S3ZG', 'GHG5MDER', 'GJKR73YA', 'GJPI1WIV', 'GKY6ZB15', 'GKY7BZOQ', 'GLOJFBA0', 'GLUZC5HC', 'GM3HKY2J', 'GS8G1IFF', 'GSK9JT39', 'GSNU5TXL', 'GT4RHNUE', 'GTVTUGVY', 'GUCIE6TT', 'GUWYJRRS', 'GWJ0A1IK', 'GWP6E8FA', 'GYCOAVYS', 'GYCY8LCF', 'GZMPRX5J', 'H0WSDLJE', 'H12S8X2Q', 'H1G4FFR7', 'H20JGHP0', 'H3D82ATM', 'H3RWZ7UR', 'H48Y5BOY', 'H5Y73UHQ', 'H9RBDN30', 'HB3OQUA5', 'HCW1Y9QM', 'HGN5HD65', 'HGPS0FQN', 'HHSIC4NY', 'HI7ZNYCK', 'HJNGSDJ5', 'HK78MCH7', 'HNGYSI62', 'HODOBX62', 'HQC2OFGM', 'HRFD8R1G', 'HRWBEBRE', 'HT51BMN1', 'HTXABMRS', 'HV6GZXC3', 'HVAG84XI', 'HVBBJM37', 'HVN93I56', 'HVXSID0M', 'HVZMFFNW', 'HX2XDS73', 'HX5NMCPJ', 'HY9DN23J', 'HZ5C2E4C', 'I0J54PBT', 'I16TS2B4', 'I1RQMFZC', 'I2ATV1DI', 'I2N7C27Y', 'I3UODLOR', 'I5L6E1U2', 'I5RNBXF3', 'I6B3VKYD', 'I7FXTVDP', 'I8U0Q5FP', 'I9MWC6I3', 'IBBLXRDR', 'ICDP084U', 'ICRBJL24', 'ID37U3DA', 'IDXJ25FE', 'IGHBC70Q', 'IH12MVU4', 'IIWFYXGG', 'IJEA3NUI', 'IL47R85Z', 'ILKPIFSA', 'IM2JLO1B', 'IMFV7GM3', 'IMVSI4VW', 'INDCDVP0', 'INELF20P', 'INJ6L6NB', 'IO2FYB6G', 'IO56YRTG', 'IOKPSO7K', 'IOOQONCI', 'IOPR6B78', 'IP9XMFII', 'IPV1W17S', 'IPVYEI8G', 'IQPZXRU2', 'IS75OD95', 'ISMP5LYF', 'IUJPYIRX', 'IYKXT23R', 'IZD0O5Q0', 'IZSQDCWP', 'J0NVCXDJ', 'J1UFMOCR', 'J339EI56', 'J3752QSY', 'J3L1KD1J', 'J3YKGOCX', 'J5WRC3DJ', 'J648LM1S', 'J70NZZIW', 'J7PWRE94', 'J9M11KX1', 'JAEI655A', 'JB8JTFSG', 'JC35D8WT', 'JC6LUZLT', 'JCHNPTSF', 'JDENEZ6I', 'JICWX3AS', 'JJBJFUAT', 'JK9C0VN8', 'JKUCC6UK', 'JL1OZP2G', 'JMJD18BP', 'JN497K3S', 'JNB98WP1', 'JNU5CAOV', 'JO1WTZOB', 'JPI7LZJ3', 'JPO7CTQP', 'JQ4YBT3Z', 'JQ7Z5Q44', 'JQJ499YN', 'JRBK08H6', 'JRDHZ51W', 'JRRTJ3GV', 'JS1KUAD6', 'JS59HL6M', 'JSEGAB8K', 'JT4GYL2P', 'JUC55NLK', 'JUYW4QZ1', 'JVWQ5HEJ', 'JWVCJ3UR', 'JWYYB1L5', 'JXDP2C4M', 'JYZ82A2B', 'JZ1RSLKQ', 'JZ2KQL0P', 'JZS556ZA', 'JZTRRSKQ', 'K1DU5H0C', 'K1K1AESM', 'K212MH7P', 'K25LXPOI', 'K3QD4AHX', 'K4AGNZ3R', 'K57LN37R', 'K83DA8K5', 'KB0YFLBH', 'KD7N9YDF', 'KDW3ZVWJ', 'KDZ388UF', 'KF32BDPB', 'KFWFMIUK', 'KG943QKP', 'KGMINGSB', 'KH4VOX9Q', 'KJJYCUJ7', 'KKG07XA9', 'KKIO1X0Z', 'KM3OV97R', 'KMPCXZUY', 'KMSH5BSO', 'KRS7ST1L', 'KSFFKSV7', 'KU0G64D0', 'KUGU9MQC', 'KUH39TQR', 'KV5TCH8S', 'KVLIE219', 'KWH2Y6KA', 'L0FS3EPM', 'L27ULB0P', 'L2HRYP1A', 'L2UTYYJT', 'L3OPGJO5', 'L3RQSW75', 'L3SSKU27', 'L5AMS3QT', 'L657W1BK', 'L76WWQ74', 'L78GOBQS', 'L905DK46', 'LDCSZOKC', 'LF9AQIHZ', 'LFQ6YRHV', 'LGEAIIK8', 'LGTP4O86', 'LHMKC873', 'LHNLO8Q8', 'LKC4LOOM', 'LKR5NGJZ', 'LKVB0S84', 'LL11R5T6', 'LM6LV3JB', 'LNTF6KP8', 'LPBA27LH', 'LPQY1SEL', 'LQ6K46C8', 'LU684LJ9', 'LUHRMKEB', 'LUI0TOT2', 'LVXSGLT6', 'LWQ8FULT', 'LXBPBCS3', 'LXOZJ3TV', 'LXPTXE5K', 'LYY8P69T', 'M1CZ7MK8', 'M2HPA1EK', 'M2R84KMY', 'M2W28OUV', 'M3B15QGL', 'M3MFQNC7', 'M46L0EBU', 'M4V0NJ97', 'M59DNUXD', 'M9265ASV', 'M9PHW06O', 'MB9HHEPN', 'MBQUJESG', 'MDCIP8E0', 'MEKV5BRI', 'MEVIH0XF', 'MFZHQ165', 'MGQBELNN', 'MH0GC0GY', 'MIUE47ZL', 'MJR1CR7U', 'ML1YCDCG', 'ML5W6LDB', 'MLGLKKI7', 'MMU3QFIP', 'MNV2YSWZ', 'MOCIAZ0D', 'MQKR83SM', 'MQQTIYIC', 'MQRIDTFZ', 'MULMC195', 'MUO5QBB6', 'MV1CMX4O', 'MXV7CSHI', 'MZOM2K35', 'N0CP1NI7', 'N0FDUY5E', 'N5LOOJSR', 'N5X3YG2I', 'N764BFJU', 'N7BY4DKZ', 'N8FNYI0A', 'N8X63KYC', 'N9I581ZL', 'NBCZC85X', 'ND7I48LA', 'ND88CY09', 'NDDT3NOB', 'NDZT8PV3', 'NHNLVWDR', 'NIKHJTWP', 'NIRCF0RK', 'NK0S2WH6', 'NKPC0Z4Q', 'NKRRLD5O', 'NMQKJMH3', 'NNNIMDVI', 'NPWC1BXV', 'NQVW27OC', 'NR26DCAB', 'NRRH4BON', 'NT9Y0D19', 'NTLCS343', 'NUOEY3LD', 'NUSJ1NGL', 'NUYVBFLU', 'NWE84W10', 'NWKWVAIA', 'NX7I9PQG', 'NYI75N90', 'O1LMIA6M', 'O3M287V6', 'O4VJ2EV7', 'O55K40VQ', 'O5PJEO54', 'O69KS0OS', 'O7NEA7KO', 'O8E18PJ4', 'OAEZWMZR', 'OAPTL0AF', 'OB97CO94', 'OCJ3W2EF', 'OEGM98R5', 'OERPDTWW', 'OG01U0FT', 'OJ9HCGTB', 'OKI0Z2UO', 'OKK933IV', 'OKWROFEH', 'OL1HWRRD', 'OL59ZZX5', 'OML0TEF3', 'ON2CU60C', 'ON9AXMKF', 'ONPQ2I44', 'OOKK1JHN', 'OPPRIPN9', 'OUA1CRWO', 'OUJLF506', 'OVPHRVOD', 'OYRI4NVE', 'P361G1OD', 'P3Q11IAK', 'P4H26KKX', 'P8PW7Q1Q', 'PEUBDA2B', 'PFI6E05S', 'PFNRAGJP', 'PGWZZALU', 'PHQEJTNO', 'PIT16TZ9', 'PJYVLL0Z', 'PKC5LJ6W', 'PMCWG8N5', 'PNWFSSF0', 'POKTJVRL', 'PONI61NE', 'POZMOX9T', 'PQZ6Z3YJ', 'PRU3JF6Y', 'PRYT0A2P', 'PS6MZN15', 'PSY58O49', 'PUECZ8ZI', 'PV7QTHJV', 'PW7GT7TE', 'PXT3AJ7C', 'PY8VPVM5', 'PYX7I7X5', 'Q1D88JO2', 'Q1M9RXYR', 'Q21CAL4Z', 'Q2K8NHZY', 'Q2LO2OGN', 'Q35PXLRT', 'Q3O4J4HB', 'Q5V3EKJC', 'QASMCASJ', 'QC3VEU4P', 'QEOKKUF1', 'QJ5LYZHA', 'QJJAG1IV', 'QJMUUPFK', 'QL3AU1NN', 'QNE79S52', 'QNKGHIRB', 'QNQQVRNB', 'QPA31HRW', 'QQFF3LO5', 'QQR3SE8Y', 'QR91QBR2', 'QSLQZQH2', 'QT44Y8VV', 'QTIRUM0G', 'QUFMTUB3', 'QUUKEGL5', 'QV09SDY8', 'QV71AJ91', 'QVAHXT35', 'QVAZPYQ8', 'QYBCIW4J', 'QYZ57QTQ', 'QZ1V5GME', 'QZ8BT14M', 'QZD4I9UW', 'R1BX2NZI', 'R1OFLDKQ', 'R2O5C424', 'R3AAYF7V', 'R3QOGZZF', 'R5B3KVZI', 'R67AMR4P', 'R6QNKUC4', 'R830GQGO', 'RASRCD7I', 'RBL3SN1I', 'RBLPDV4R', 'RBMLZBYW', 'RD5YXSBA', 'RD62G56Y', 'RE7IER1C', 'REKW7MRF', 'RF45YZMF', 'RFUY4U4W', 'RFYO6TO0', 'RGD51NW1', 'RHH1X0A2', 'RHSAJGR1', 'RIEIBCRF', 'RKJHZGDQ', 'RNSK8HLJ', 'RP37N5WN', 'RQUURTUT', 'RRIG3SH3', 'RSMDF425', 'RYUA3GVO', 'RZCRWMTU', 'RZPGGEG4', 'RZPT9APG', 'RZT9JPDV', 'S0Z5J1EW', 'S15Z6XG6', 'S2PFIP6S', 'S2ZYVBUF', 'S5CBU2AX', 'S7345IVO', 'S768X16I', 'S824JJ06', 'SAONBMNO', 'SBQXQOPV', 'SBWHI6Y6', 'SCKCR39J', 'SD7VPKVQ', 'SDNECLRB', 'SEAEY0CN', 'SEH3FI81', 'SEVOI9NR', 'SEX60YJE', 'SFPE2DX4', 'SGAZ5VOA', 'SGIINS2G', 'SHKNA9S1', 'SIUTK5SR', 'SIUXBYDS', 'SLG5DZG2', 'SLVO27W6', 'SM3HAKL8', 'SNNICLKQ', 'SNZP9G8K', 'SOPNMXWX', 'SQB9N47Y', 'SR345GAS', 'SRZSX1LR', 'SSVDNEY9', 'ST2DCNR0', 'SU06AE5D', 'SUUFTUWK', 'SW00LEHT', 'SWHE2RH1', 'SYQSKHN2', 'SZ0MR59K', 'T18CGW8H', 'T3KHULCH', 'T4J4YRDK', 'T5R7YFPH', 'T8R673OI', 'T9LSOTV6', 'T9ZHWQE9', 'TBJE6V15', 'TBUHVONI', 'TCKOTGYJ', 'TD593FIM', 'TE1TWCPZ', 'TFTOGJOD', 'TGPPSF7M', 'THD393NW', 'THW6JGC7', 'TI21BGNU', 'TIAPP57M', 'TJLVHJ87', 'TK932JM1', 'TKLYRWYO', 'TNR495LD', 'TQAA3UHV', 'TRM5SRRW', 'TTU1NVDI', 'TU2W2LCB', 'TUO2TVTX', 'TVQC1R4D', 'TWH1XFPL', 'TWV05PEP', 'TYJN7K7A', 'TYQ2T01H', 'TZ8JAEO6', 'TZL79DYX', 'U0U7F3EW', 'U2C1NG0D', 'U2C2VVY8', 'U2OZU4IY', 'U2VWRM3F', 'U2ZEEFLD', 'U3QRAT06', 'U47IUY9C', 'U49ISLNE', 'U5966IDO', 'U5ZJCLCX', 'U69N21WU', 'U6DS14AT', 'U6TNOS7M', 'U74I1JYB', 'U8FRHWSV', 'U8SWTHB5', 'UAY0HW9A', 'UBO7MS4D', 'UBWK5LJH', 'UBXL2EGE', 'UC094GDG', 'UCC4KYQL', 'UCVUALGM', 'UEZVPK90', 'UFAQZXPY', 'UFEO02VM', 'UFTYVG6Y', 'UH5Z524P', 'UHU62P41', 'UJNF3UO2', 'UJSK2U9A', 'UK4B4I7A', 'UKG1R822', 'ULOHU3PC', 'ULVU086L', 'UMDZG9XM', 'UMM76IOX', 'UMOD7PGG', 'UNAGKRY0', 'UNE947CO', 'UO4MVLJS', 'UP3750KB', 'UQUIUCVA', 'URO46KFW', 'URY1ZVZI', 'US8KF8X3', 'UVXQ3O4K', 'UWWS6RWO', 'UXK3D4GF', 'UYCX4ZJS', 'UYLJZRPN', 'UYPE34HA', 'V04Z48C3', 'V1YVL2DL', 'V3JDHWOB', 'V4A28VLV', 'V4RKPN30', 'V5C3CWTK', 'V6X2Z58S', 'V8MF2IKQ', 'VAGUTU8C', 'VB04AEHZ', 'VDSDXJ71', 'VDYHUCQB', 'VE48SF8D', 'VFCTUL5J', 'VFOEJ2CS', 'VGCXUCRO', 'VGWO9SBA', 'VHPX9GYO', 'VJU9EYFE', 'VKN3L279', 'VKU9G6Y5', 'VMU0L6UM', 'VO0ATBFS', 'VOT8OKU2', 'VRZZPHI4', 'VW6ZY2L1', 'VYW7T8YY', 'VZLS9GCK', 'W184Y53L', 'W1STLS0T', 'W2DYAZID', 'W7WRIFC0', 'W9QZOUW7', 'WAL364PD', 'WB78G3XF', 'WBGCVIO8', 'WD8MHX8N', 'WDNYZZHJ', 'WG42FGWA', 'WG7S6W2T', 'WHLUO40S', 'WK162QYQ', 'WK4NBYSB', 'WKRC8NSD', 'WKYJ6R7D', 'WL3FJI96', 'WL8VMHWG', 'WM3Q8LBC', 'WM9JWC4B', 'WNEX0Y1X', 'WP6H3E2T', 'WQ1DVVYG', 'WQBN4WGH', 'WRDZ1CVS', 'WSHPKJ3H', 'WTFS8JV2', 'WTYMIZ88', 'WUARWGNF', 'WUR2UJYP', 'WWDAZG6C', 'WX0HMR4F', 'WZX61W39', 'WZZLL8O4', 'X0VJJXGQ', 'X2PFPX2S', 'X4WO7LHO', 'X4YNMN9Z', 'X6497O49', 'X6LFEBK7', 'X920R0YN', 'X9RNN0YD', 'XCWSW5T9', 'XD80LQN2', 'XE4D68OI', 'XHQPAVRU', 'XLYFD8RW', 'XOEVMQZT', 'XP1SRNTB', 'XP5B8615', 'XPQ9IYZC', 'XR7GR7UE', 'XRENDLF1', 'XSA3Y2H6', 'XTKRJ8N6', 'XU8GASLQ', 'XV32YHEZ', 'XY9JOM6L', 'XYB5NWR4', 'Y060M6TK', 'Y324NGPN', 'Y3HA6UDE', 'Y4G53L4X', 'Y4X5JU76', 'Y575VUS1', 'Y5YH740Y', 'Y620TYKH', 'Y6EC9YQA', 'Y73L2QKM', 'Y81SHRRC', 'YCD71LRY', 'YCNWCC0Z', 'YCY2FFYZ', 'YDPNP1KR', 'YE9BU3J3', 'YEA0ZZZP', 'YEZ30YUQ', 'YFSGJUTL', 'YGFI5B9G', 'YGFIQ8SA', 'YHUR7HZ6', 'YHX2594T', 'YKXRSB4N', 'YL8AOR9Q', 'YLS2HEMR', 'YMHGXK99', 'YMWK7JKH', 'YP4WCV92', 'YQ3L8TWE', 'YQITW66D', 'YTGT3GEX', 'YTOOMPZ8', 'YW85XPTE', 'YWQZUSA8', 'YWZAEK5A', 'YXKFDH6S', 'YY5Y32CI', 'YZX8R26H', 'Z1C99MVU', 'Z1Y066QU', 'Z6LWLWFZ', 'Z7YFK3I0', 'Z7ZKDLZG', 'Z80NVAXF', 'Z8BWVZZX', 'ZAYLY2YU', 'ZB6DPIG5', 'ZB862XHR', 'ZBQD50GN', 'ZC07UYVV', 'ZCU48L3S', 'ZEAZQ1QQ', 'ZEB7PDQK', 'ZEBTRK7D', 'ZEJOQQJF', 'ZELU1VMX', 'ZFBSIW7Q', 'ZGY1YZ7P', 'ZH6LR5MO', 'ZIGUIE0J', 'ZIJRW95G', 'ZK6YBV02', 'ZLSXM0KN', 'ZMCRIYYJ', 'ZMEZU4BS', 'ZMUIMBDX', 'ZOI7FJEN', 'ZQ5A6IY9', 'ZQNGGY33', 'ZSHS4VJZ', 'ZT1IP3T6', 'ZU6860XU', 'ZU6TVFFU', 'ZU75P59K', 'ZUI6TDWV', 'ZWFD8OHC', 'ZX06ZDZN', 'ZZJVE4HO']\n",
      "========= test columns ==========\n",
      "['sequence_id', '00Q4V31T', '012VT4JK', '028IO5W2', '03GRNN7N', '03Y3W51H', '09MQV1TY', '0A4AHRCT', '0A9M05NC', '0B9GCUVV', '0CL7QVG8', '0CML4B5I', '0DTHTJLJ', '0FFBBVE1', '0HWCWFNU', '0L3Y6ZB2', '0M44GDO8', '0MDYJM3H', '0N3V9P9M', '0NP55E93', '0PJ91ZT6', '0R296F9R', '0T2AZBD6', '0URA80CN', '0VRP2DI6', '0W6O08VX', '0WHP4PPK', '0XPTGGLP', '0XS4FHP3', '0Y24J5G2', '10TEBWK2', '11TTDKTM', '131RRHBV', '13LZE1F7', '14PBN8C2', '15D0Z97U', '15S88O4Q', '18C9J8EH', '19CAUKJB', '1AP294AT', '1B9BJ2IP', '1BE35FI1', '1CIHYCE4', '1DJ9L58E', '1DTDCRUO', '1EDZ6CA7', '1HCQTAYT', '1HK4VXP8', '1IXFZ3HO', '1K11RCST', '1KC6XYO6', '1KNFJ6KQ', '1KZHNVYR', '1LBGAU5Z', '1NXRMDN6', '1OQJ21E9', '1OWZDF82', '1PA232PA', '1PIGWQFY', '1Q1IUY3G', '1S515B69', '1TC200QC', '1TI4HS4X', '1UOA7CA1', '1UREJUSJ', '1UU0CHTK', '1VPOX8VI', '1VQS4WNS', '1X0VC0O1', '1XU60MET', '1ZC8RPN1', '20ABQYHS', '20CEB9KE', '216DWMG6', '21ZFBX5E', '24SL2992', '25UVYUID', '26KK8UM5', '27OS3BTP', '28D4D4QM', '298AMR5C', '29D6Q091', '2AQG6I31', '2BAFY4GP', '2CJHRNWD', '2FCX4O0X', '2GGU2QA2', '2GSZMU46', '2GTLIT33', '2H37WPKA', '2HNZZYDB', '2JPNC9X6', '2KDACBQT', '2L336TQL', '2M3CXS8N', '2MCB7LXW', '2MQ2NPMA', '2NEXWXMT', '2PY8K6GU', '2Q33W599', '2SSVM7H9', '2TVMHQTW', '2TXY439E', '2VP4JPB9', '2VTLZHDS', '2VX4F6RC', '2XC1478M', '2XX0N87I', '2Y9L13L4', '2YCH1PUI', '2YLQA8OZ', '303BN0Z0', '318RH8P0', '330L4OIV', '33AR5KVE', '343M819H', '34TE1Q0A', '35MKXPL0', '36W150XW', '36XLYYGZ', '37VO60SB', '384ASNLB', '38MDETY1', '38MEQ4SU', '39LLQ2PB', '39TEZ0C3', '39TPBOL7', '3BGLF8BC', '3C2VZQ2R', '3C952KY7', '3D9CMQ4V', '3EARN0Z7', '3EYBG174', '3EZXYI3U', '3FPH0N6R', '3FW33G68', '3GEXBRC0', '3KCEM7V4', '3L314D8W', '3LSNTL1N', '3MDRJUI2', '3MX1D3LD', '3N169DM2', '3NSJ6N02', '3O1GIAV7', '3QP4D23X', '3RK54JUW', '3TLD81QQ', '3TUFYWQN', '3TXFYNKG', '3X2GGDHW', '3XE0BJDW', '3YAQWNBK', '3YEGUN04', '3YYEC52Y', '40MD0YZ3', '40ZI3TDN', '443NZOSB', '448QVC4C', '44N2CYI9', '459BZKP3', '4648UZGD', '46AZ97U9', '48F0EUVN', '49571DXY', '49YZILWR', '4CKAV3LS', '4DGGCYVE', '4DGMNDIC', '4E7187A9', '4GF31RCS', '4GHCND6Z', '4IADYZ8R', '4IDTMY10', '4J7KEYE2', '4KSHU5M7', '4LCFACE1', '4LQ8L195', '4M3XG8RC', '4O39WLXM', '4O5RQHEF', '4PKCMX7O', '4QK5ZDHA', '4QU07FT7', '4RCA1UZG', '4RHLX089', '4S1LIWGV', '4TIT4L5F', '4U5LAAN5', '4VHMF1RI', '4WAQ4VFB', '4WRI77CU', '4X2RTV2D', '4Y4DT3SL', '4ZYW54M8', '50NBGIOB', '52Y9GFGK', '54C6PEBH', '54ZFOPSF', '558GIQ68', '55HTZ7T0', '579G0TJI', '57FHO8YC', '57NGF1YS', '58BSUZQB', '5ASQZ0OT', '5AUVXXDU', '5BNUT8AW', '5BTY65G6', '5CBNCRST', '5FUDT1QA', '5H71LUBY', '5K2PTY6L', '5KXWXV9G', '5LH9NUMK', '5OBD73W0', '5OF7OYEA', '5OFUVG9U', '5PC2F8NE', '5PR9OSRS', '5Q9ETXJL', '5QLBIUXN', '5QY2HU8J', '5SCOFTY2', '5SGMS705', '5V3Z108E', '5W2PCT95', '5X9VNAN3', '5Z4CMIY5', '5ZB8I3T0', '5ZW05824', '60HBQEP8', '62PKSARW', '638UYIQC', '64FFXH4M', '65CCBIXK', '669R7ER0', '66XSSS3Q', '685KTH3G', '68OY1RK5', '69M351P4', '6AT20D5S', '6DBY872A', '6E28DNQK', '6KT0EAKX', '6LQ0W02R', '6NCTAA30', '6NKNB308', '6NULQ6KP', '6PS2LHCV', '6PXRABDR', '6QBXXYN4', '6QUCW04X', '6SBB6IL2', '6T9SGGS1', '6TT5CXVI', '6TTWEXT3', '6UGWNYCX', '6UI9XACW', '6UXF7L28', '6WD2LIHN', '6WT1F4RJ', '6XVBD39G', '6YSX60MZ', '7039MMH2', '709K4VRB', '7185O9V8', '71R7TM8L', '738FBTIL', '73RKEO3U', '747XMBIJ', '74RXUGS4', '74TS5KG4', '78QGAL01', '78XDAJNS', '7ANCD9AK', '7DMNXU84', '7E63E5RD', '7F905YRZ', '7GWW4637', '7IHPTKFF', '7KG191H8', '7MUAYEHW', '7NGLQ1CA', '7O3PWIL0', '7OV5K86R', '7PWA4ZJN', '7QEORFJN', '7QF2VB5B', '7QWHL2C6', '7SW79VAJ', '7T28F53W', '7TYZHD5J', '7UU8O65I', '7WKS90AG', '7X3RSRT5', '7XPDUYJE', '7XU8ACPI', '7YSTNZME', '7ZV0Z1T9', '81QAZACE', '82NXGO4K', '862RYK1K', '86ET7WW4', '88E6O06E', '8ABA3MWO', '8BF8ANNO', '8C0T09C6', '8C9737JL', '8D4D6M5V', '8ECLELF1', '8EKC599S', '8F0XPAZX', '8FT6HD4D', '8FZMCIFG', '8G29TDOS', '8H6M75LF', '8HI3GY44', '8HW91I4K', '8HZXGARR', '8IPYO6SS', '8JKDTT0Y', '8K0HZBL0', '8MUKKVMF', '8MW998Z0', '8N5EPD5C', '8OBT3FSQ', '8ORZZFA7', '8RIKS696', '8SW7WFE6', '8T12OXHS', '8US76O46', '8VCFY56I', '8VI1RY3M', '8VLB2R3D', '8WAY3T1E', '8Z6SANMH', '8ZB94ICE', '8ZB99KHH', '904V6V2S', '909V5A2H', '91Y7NKBM', '91Z8RRSB', '92WF5WVN', '93R70J1L', '93WIIL7Y', '97FR69TQ', '97PR85CP', '99A19JAD', '9DBCRJYM', '9DKQF2I2', '9DRMDPIZ', '9G5XH4HI', '9GDHC3D0', '9HPM9NFY', '9HRDSOST', '9IVIPDX5', '9JRKFKVC', '9KHXMSMW', '9KV8R3HP', '9LSH625Y', '9MC0DPDJ', '9MC1YKKZ', '9MEFUZQN', '9MG50RM7', '9MZBKXJF', '9PWYZMNS', '9QQZ79I6', '9R765PJF', '9SJCUIKS', '9SSQ1FSY', '9U0DELRD', '9WEGTUIJ', '9WQQKFVK', '9XE0FL8P', '9Y5EWA8O', '9YM3QINZ', '9ZTEQPA4', 'A0ADXLZU', 'A0Z7XCDN', 'A1738D1Z', 'A18S09P2', 'A1A8EROR', 'A1J0YXZX', 'A2A1R52R', 'A2U1AIC1', 'A332O9JW', 'A3FZPLM1', 'A3QUOXIX', 'A44GW57T', 'A4BM0B6A', 'A6RCKKER', 'A768XIWP', 'A78F2YFJ', 'A7CK3WNB', 'A810BWR5', 'A8FZHMOS', 'A9G8OKRG', 'AATDRXYQ', 'AAURK3RG', 'ABMAPCYN', 'ABWCZWFU', 'ACO8WWPF', 'ADB7SAPN', 'AG93GZYN', 'AHMVJ2VP', 'AL7N3DL2', 'AM8AJH2H', 'AMSPTQVJ', 'AMV4U0A0', 'AOCCEP3S', 'AOFJN8HX', 'AOFPYGHC', 'AOKRU4AF', 'AOQQU910', 'AR433PVR', 'AS30HPUK', 'AUCMR8HU', 'AUUSW2YZ', 'AUZNSS79', 'AV7ONIVD', 'AWWC1KIV', 'B131HDBV', 'B17J3JSX', 'B1I4L0XW', 'B25KOPVH', 'B2BULVFH', 'B4L9R8JU', 'B517ID6W', 'B832TQ6U', 'B8FC99WI', 'B8YR9IIK', 'B9H5SLHK', 'BBTA1L43', 'BBZJCYJ0', 'BD9EXLDM', 'BDQOSDFG', 'BDSEVK9M', 'BH7HW7XH', 'BHKOO62U', 'BHNI9DCI', 'BHW9ILRC', 'BJKTDFN4', 'BL2TLVFC', 'BLC9WIIM', 'BLFM4YKK', 'BLNELN02', 'BN8BMXPM', 'BNFZZTKX', 'BP2X9ITX', 'BPT27UPE', 'BQJ79YS3', 'BSEEWS00', 'BSH6LB19', 'BTQL3UFQ', 'BV6PVSO5', 'BV8D4RYV', 'BWFN4ZI7', 'BXMEKONO', 'BY5IEG4O', 'BZBNZDNS', 'C1BIUBL5', 'C35C2C2W', 'C4W63WJ2', 'CA0MBQ9S', 'CAO2H0WE', 'CAQEITX6', 'CB714TAM', 'CBCQST29', 'CBFKYZ9S', 'CBKRHK4I', 'CDM3SRRP', 'CDU1LWN3', 'CEATO4LM', 'CENOJ84D', 'CFDEOSH4', 'CFOET28L', 'CFQ9PAJA', 'CHTQ7QLX', 'CJFLQNE1', 'CK1M5UHL', 'CKDZNQV2', 'CLO7VQ12', 'CNX48K3H', 'COEMYLH1', 'COVE5WRD', 'CRP30ATM', 'CTJGWLX0', 'CTLP20Y9', 'CWZP8AQK', 'CY64689U', 'CYCSYMQ3', 'CZUGPH88', 'D0EKC82X', 'D0NFHXL2', 'D0YWREJ5', 'D10S0UDQ', 'D1BZRMOB', 'D2N5DOSQ', 'D3KJQCYH', 'D4PJE56U', 'D4Q1QMRJ', 'D63K976U', 'D7L6VZNV', 'D8MRQA91', 'D8OQ3YNK', 'DD0JBK3T', 'DE6NAU7D', 'DEFNZK0A', 'DEWKAO5I', 'DGE8LLAJ', 'DGQ2L6KM', 'DJW5U56I', 'DKA65CRR', 'DLSU0QRX', 'DN01XVIU', 'DQGG01WF', 'DRFCUPZO', 'DSE2G8LF', 'DY0KIZZ9', 'DZ2XFGQS', 'E3CE5WE9', 'E3CRPQL7', 'E3FFACSU', 'E4EF2K0A', 'E4T4IQMG', 'E59C5N01', 'E5OB5QF1', 'E6G69ESA', 'E6TPDVWA', 'E7CPRIYW', 'E7EZD62E', 'E8100WU0', 'E8GMEHFW', 'EA2DKNTD', 'EBF1G8Z7', 'ED0OS5OF', 'EEC8D29F', 'EFKGYR79', 'EI8B4WEC', 'EJ3T17DB', 'EJXP2QAW', 'EKHYS325', 'EKXAPD70', 'EL9FN1LB', 'ELF2BN3S', 'ELX1D1DS', 'EMJXDINV', 'EMNH5MYX', 'EN78WKI4', 'EOQAQ9X1', 'EPDX32D3', 'EQPB3YTZ', 'ER1IJR80', 'ETR2SP13', 'EW4ZXWSN', 'EXQZ5V7S', 'EYOJGC9T', 'EZ40BRHE', 'EZL4HNHH', 'EZMV5TKG', 'F0ESSJYM', 'F0MOWJYA', 'F1X6DMDH', 'F3D2JAYU', 'F3S4VUQI', 'F50DBVIK', 'F8I0DT7Z', 'F8LNIZ27', 'FCI1HZ3G', 'FEBWERSN', 'FH8TEJI1', 'FHR8UUYO', 'FHZYKEUV', 'FJTJ4KY0', 'FLHGDG0P', 'FLSWA4NU', 'FLU9ZT18', 'FMJ19E48', 'FN1RKQ2M', 'FN38BX60', 'FNKCHGB7', 'FNM1Z945', 'FPH5H8JT', 'FQ8V2QHL', 'FRFT0H8N', 'FRK40JVP', 'FRX9XJYW', 'FSR0IC6I', 'FVYCRUFK', 'FWOZ05UZ', 'FXBIP7LS', 'FXRWH0M9', 'FZ37IFWH', 'G2P73NZ0', 'G4UJDFPK', 'G57JANUL', 'G6MP6EIN', 'G7MXLRV8', 'G81LO0AZ', 'G8QWQL1C', 'GB45D1XV', 'GBX3MNVS', 'GDV3S3ZG', 'GHG5MDER', 'GJKR73YA', 'GJPI1WIV', 'GKY6ZB15', 'GKY7BZOQ', 'GLOJFBA0', 'GLUZC5HC', 'GM3HKY2J', 'GS8G1IFF', 'GSK9JT39', 'GSNU5TXL', 'GT4RHNUE', 'GTVTUGVY', 'GUCIE6TT', 'GUWYJRRS', 'GWJ0A1IK', 'GWP6E8FA', 'GYCOAVYS', 'GYCY8LCF', 'GZMPRX5J', 'H0WSDLJE', 'H12S8X2Q', 'H1G4FFR7', 'H20JGHP0', 'H3D82ATM', 'H3RWZ7UR', 'H48Y5BOY', 'H5Y73UHQ', 'H9RBDN30', 'HB3OQUA5', 'HCW1Y9QM', 'HGN5HD65', 'HGPS0FQN', 'HHSIC4NY', 'HI7ZNYCK', 'HJNGSDJ5', 'HK78MCH7', 'HNGYSI62', 'HODOBX62', 'HQC2OFGM', 'HRFD8R1G', 'HRWBEBRE', 'HT51BMN1', 'HTXABMRS', 'HV6GZXC3', 'HVAG84XI', 'HVBBJM37', 'HVN93I56', 'HVXSID0M', 'HVZMFFNW', 'HX2XDS73', 'HX5NMCPJ', 'HY9DN23J', 'HZ5C2E4C', 'I0J54PBT', 'I16TS2B4', 'I1RQMFZC', 'I2ATV1DI', 'I2N7C27Y', 'I3UODLOR', 'I5L6E1U2', 'I5RNBXF3', 'I6B3VKYD', 'I7FXTVDP', 'I8U0Q5FP', 'I9MWC6I3', 'IBBLXRDR', 'ICDP084U', 'ICRBJL24', 'ID37U3DA', 'IDXJ25FE', 'IGHBC70Q', 'IH12MVU4', 'IIWFYXGG', 'IJEA3NUI', 'IL47R85Z', 'ILKPIFSA', 'IM2JLO1B', 'IMFV7GM3', 'IMVSI4VW', 'INDCDVP0', 'INELF20P', 'INJ6L6NB', 'IO2FYB6G', 'IO56YRTG', 'IOKPSO7K', 'IOOQONCI', 'IOPR6B78', 'IP9XMFII', 'IPV1W17S', 'IPVYEI8G', 'IQPZXRU2', 'IS75OD95', 'ISMP5LYF', 'IUJPYIRX', 'IYKXT23R', 'IZD0O5Q0', 'IZSQDCWP', 'J0NVCXDJ', 'J1UFMOCR', 'J339EI56', 'J3752QSY', 'J3L1KD1J', 'J3YKGOCX', 'J5WRC3DJ', 'J648LM1S', 'J70NZZIW', 'J7PWRE94', 'J9M11KX1', 'JAEI655A', 'JB8JTFSG', 'JC35D8WT', 'JC6LUZLT', 'JCHNPTSF', 'JDENEZ6I', 'JICWX3AS', 'JJBJFUAT', 'JK9C0VN8', 'JKUCC6UK', 'JL1OZP2G', 'JMJD18BP', 'JN497K3S', 'JNB98WP1', 'JNU5CAOV', 'JO1WTZOB', 'JPI7LZJ3', 'JPO7CTQP', 'JQ4YBT3Z', 'JQ7Z5Q44', 'JQJ499YN', 'JRBK08H6', 'JRDHZ51W', 'JRRTJ3GV', 'JS1KUAD6', 'JS59HL6M', 'JSEGAB8K', 'JT4GYL2P', 'JUC55NLK', 'JUYW4QZ1', 'JVWQ5HEJ', 'JWVCJ3UR', 'JWYYB1L5', 'JXDP2C4M', 'JYZ82A2B', 'JZ1RSLKQ', 'JZ2KQL0P', 'JZS556ZA', 'JZTRRSKQ', 'K1DU5H0C', 'K1K1AESM', 'K212MH7P', 'K25LXPOI', 'K3QD4AHX', 'K4AGNZ3R', 'K57LN37R', 'K83DA8K5', 'KB0YFLBH', 'KD7N9YDF', 'KDW3ZVWJ', 'KDZ388UF', 'KF32BDPB', 'KFWFMIUK', 'KG943QKP', 'KGMINGSB', 'KH4VOX9Q', 'KJJYCUJ7', 'KKG07XA9', 'KKIO1X0Z', 'KM3OV97R', 'KMPCXZUY', 'KMSH5BSO', 'KRS7ST1L', 'KSFFKSV7', 'KU0G64D0', 'KUGU9MQC', 'KUH39TQR', 'KV5TCH8S', 'KVLIE219', 'KWH2Y6KA', 'L0FS3EPM', 'L27ULB0P', 'L2HRYP1A', 'L2UTYYJT', 'L3OPGJO5', 'L3RQSW75', 'L3SSKU27', 'L5AMS3QT', 'L657W1BK', 'L76WWQ74', 'L78GOBQS', 'L905DK46', 'LDCSZOKC', 'LF9AQIHZ', 'LFQ6YRHV', 'LGEAIIK8', 'LGTP4O86', 'LHMKC873', 'LHNLO8Q8', 'LKC4LOOM', 'LKR5NGJZ', 'LKVB0S84', 'LL11R5T6', 'LM6LV3JB', 'LNTF6KP8', 'LPBA27LH', 'LPQY1SEL', 'LQ6K46C8', 'LU684LJ9', 'LUHRMKEB', 'LUI0TOT2', 'LVXSGLT6', 'LWQ8FULT', 'LXBPBCS3', 'LXOZJ3TV', 'LXPTXE5K', 'LYY8P69T', 'M1CZ7MK8', 'M2HPA1EK', 'M2R84KMY', 'M2W28OUV', 'M3B15QGL', 'M3MFQNC7', 'M46L0EBU', 'M4V0NJ97', 'M59DNUXD', 'M9265ASV', 'M9PHW06O', 'MB9HHEPN', 'MBQUJESG', 'MDCIP8E0', 'MEKV5BRI', 'MEVIH0XF', 'MFZHQ165', 'MGQBELNN', 'MH0GC0GY', 'MIUE47ZL', 'MJR1CR7U', 'ML1YCDCG', 'ML5W6LDB', 'MLGLKKI7', 'MMU3QFIP', 'MNV2YSWZ', 'MOCIAZ0D', 'MQKR83SM', 'MQQTIYIC', 'MQRIDTFZ', 'MULMC195', 'MUO5QBB6', 'MV1CMX4O', 'MXV7CSHI', 'MZOM2K35', 'N0CP1NI7', 'N0FDUY5E', 'N5LOOJSR', 'N5X3YG2I', 'N764BFJU', 'N7BY4DKZ', 'N8FNYI0A', 'N8X63KYC', 'N9I581ZL', 'NBCZC85X', 'ND7I48LA', 'ND88CY09', 'NDDT3NOB', 'NDZT8PV3', 'NHNLVWDR', 'NIKHJTWP', 'NIRCF0RK', 'NK0S2WH6', 'NKPC0Z4Q', 'NKRRLD5O', 'NMQKJMH3', 'NNNIMDVI', 'NPWC1BXV', 'NQVW27OC', 'NR26DCAB', 'NRRH4BON', 'NT9Y0D19', 'NTLCS343', 'NUOEY3LD', 'NUSJ1NGL', 'NUYVBFLU', 'NWE84W10', 'NWKWVAIA', 'NX7I9PQG', 'NYI75N90', 'O1LMIA6M', 'O3M287V6', 'O4VJ2EV7', 'O55K40VQ', 'O5PJEO54', 'O69KS0OS', 'O7NEA7KO', 'O8E18PJ4', 'OAEZWMZR', 'OAPTL0AF', 'OB97CO94', 'OCJ3W2EF', 'OEGM98R5', 'OERPDTWW', 'OG01U0FT', 'OJ9HCGTB', 'OKI0Z2UO', 'OKK933IV', 'OKWROFEH', 'OL1HWRRD', 'OL59ZZX5', 'OML0TEF3', 'ON2CU60C', 'ON9AXMKF', 'ONPQ2I44', 'OOKK1JHN', 'OPPRIPN9', 'OUA1CRWO', 'OUJLF506', 'OVPHRVOD', 'OYRI4NVE', 'P361G1OD', 'P3Q11IAK', 'P4H26KKX', 'P8PW7Q1Q', 'PEUBDA2B', 'PFI6E05S', 'PFNRAGJP', 'PGWZZALU', 'PHQEJTNO', 'PIT16TZ9', 'PJYVLL0Z', 'PKC5LJ6W', 'PMCWG8N5', 'PNWFSSF0', 'POKTJVRL', 'PONI61NE', 'POZMOX9T', 'PQZ6Z3YJ', 'PRU3JF6Y', 'PRYT0A2P', 'PS6MZN15', 'PSY58O49', 'PUECZ8ZI', 'PV7QTHJV', 'PW7GT7TE', 'PXT3AJ7C', 'PY8VPVM5', 'PYX7I7X5', 'Q1D88JO2', 'Q1M9RXYR', 'Q21CAL4Z', 'Q2K8NHZY', 'Q2LO2OGN', 'Q35PXLRT', 'Q3O4J4HB', 'Q5V3EKJC', 'QASMCASJ', 'QC3VEU4P', 'QEOKKUF1', 'QJ5LYZHA', 'QJJAG1IV', 'QJMUUPFK', 'QL3AU1NN', 'QNE79S52', 'QNKGHIRB', 'QNQQVRNB', 'QPA31HRW', 'QQFF3LO5', 'QQR3SE8Y', 'QR91QBR2', 'QSLQZQH2', 'QT44Y8VV', 'QTIRUM0G', 'QUFMTUB3', 'QUUKEGL5', 'QV09SDY8', 'QV71AJ91', 'QVAHXT35', 'QVAZPYQ8', 'QYBCIW4J', 'QYZ57QTQ', 'QZ1V5GME', 'QZ8BT14M', 'QZD4I9UW', 'R1BX2NZI', 'R1OFLDKQ', 'R2O5C424', 'R3AAYF7V', 'R3QOGZZF', 'R5B3KVZI', 'R67AMR4P', 'R6QNKUC4', 'R830GQGO', 'RASRCD7I', 'RBL3SN1I', 'RBLPDV4R', 'RBMLZBYW', 'RD5YXSBA', 'RD62G56Y', 'RE7IER1C', 'REKW7MRF', 'RF45YZMF', 'RFUY4U4W', 'RFYO6TO0', 'RGD51NW1', 'RHH1X0A2', 'RHSAJGR1', 'RIEIBCRF', 'RKJHZGDQ', 'RNSK8HLJ', 'RP37N5WN', 'RQUURTUT', 'RRIG3SH3', 'RSMDF425', 'RYUA3GVO', 'RZCRWMTU', 'RZPGGEG4', 'RZPT9APG', 'RZT9JPDV', 'S0Z5J1EW', 'S15Z6XG6', 'S2PFIP6S', 'S2ZYVBUF', 'S5CBU2AX', 'S7345IVO', 'S768X16I', 'S824JJ06', 'SAONBMNO', 'SBQXQOPV', 'SBWHI6Y6', 'SCKCR39J', 'SD7VPKVQ', 'SDNECLRB', 'SEAEY0CN', 'SEH3FI81', 'SEVOI9NR', 'SEX60YJE', 'SFPE2DX4', 'SGAZ5VOA', 'SGIINS2G', 'SHKNA9S1', 'SIUTK5SR', 'SIUXBYDS', 'SLG5DZG2', 'SLVO27W6', 'SM3HAKL8', 'SNNICLKQ', 'SNZP9G8K', 'SOPNMXWX', 'SQB9N47Y', 'SR345GAS', 'SRZSX1LR', 'SSVDNEY9', 'ST2DCNR0', 'SU06AE5D', 'SUUFTUWK', 'SW00LEHT', 'SWHE2RH1', 'SYQSKHN2', 'SZ0MR59K', 'T18CGW8H', 'T3KHULCH', 'T4J4YRDK', 'T5R7YFPH', 'T8R673OI', 'T9LSOTV6', 'T9ZHWQE9', 'TBJE6V15', 'TBUHVONI', 'TCKOTGYJ', 'TD593FIM', 'TE1TWCPZ', 'TFTOGJOD', 'TGPPSF7M', 'THD393NW', 'THW6JGC7', 'TI21BGNU', 'TIAPP57M', 'TJLVHJ87', 'TK932JM1', 'TKLYRWYO', 'TNR495LD', 'TQAA3UHV', 'TRM5SRRW', 'TTU1NVDI', 'TU2W2LCB', 'TUO2TVTX', 'TVQC1R4D', 'TWH1XFPL', 'TWV05PEP', 'TYJN7K7A', 'TYQ2T01H', 'TZ8JAEO6', 'TZL79DYX', 'U0U7F3EW', 'U2C1NG0D', 'U2C2VVY8', 'U2OZU4IY', 'U2VWRM3F', 'U2ZEEFLD', 'U3QRAT06', 'U47IUY9C', 'U49ISLNE', 'U5966IDO', 'U5ZJCLCX', 'U69N21WU', 'U6DS14AT', 'U6TNOS7M', 'U74I1JYB', 'U8FRHWSV', 'U8SWTHB5', 'UAY0HW9A', 'UBO7MS4D', 'UBWK5LJH', 'UBXL2EGE', 'UC094GDG', 'UCC4KYQL', 'UCVUALGM', 'UEZVPK90', 'UFAQZXPY', 'UFEO02VM', 'UFTYVG6Y', 'UH5Z524P', 'UHU62P41', 'UJNF3UO2', 'UJSK2U9A', 'UK4B4I7A', 'UKG1R822', 'ULOHU3PC', 'ULVU086L', 'UMDZG9XM', 'UMM76IOX', 'UMOD7PGG', 'UNAGKRY0', 'UNE947CO', 'UO4MVLJS', 'UP3750KB', 'UQUIUCVA', 'URO46KFW', 'URY1ZVZI', 'US8KF8X3', 'UVXQ3O4K', 'UWWS6RWO', 'UXK3D4GF', 'UYCX4ZJS', 'UYLJZRPN', 'UYPE34HA', 'V04Z48C3', 'V1YVL2DL', 'V3JDHWOB', 'V4A28VLV', 'V4RKPN30', 'V5C3CWTK', 'V6X2Z58S', 'V8MF2IKQ', 'VAGUTU8C', 'VB04AEHZ', 'VDSDXJ71', 'VDYHUCQB', 'VE48SF8D', 'VFCTUL5J', 'VFOEJ2CS', 'VGCXUCRO', 'VGWO9SBA', 'VHPX9GYO', 'VJU9EYFE', 'VKN3L279', 'VKU9G6Y5', 'VMU0L6UM', 'VO0ATBFS', 'VOT8OKU2', 'VRZZPHI4', 'VW6ZY2L1', 'VYW7T8YY', 'VZLS9GCK', 'W184Y53L', 'W1STLS0T', 'W2DYAZID', 'W7WRIFC0', 'W9QZOUW7', 'WAL364PD', 'WB78G3XF', 'WBGCVIO8', 'WD8MHX8N', 'WDNYZZHJ', 'WG42FGWA', 'WG7S6W2T', 'WHLUO40S', 'WK162QYQ', 'WK4NBYSB', 'WKRC8NSD', 'WKYJ6R7D', 'WL3FJI96', 'WL8VMHWG', 'WM3Q8LBC', 'WM9JWC4B', 'WNEX0Y1X', 'WP6H3E2T', 'WQ1DVVYG', 'WQBN4WGH', 'WRDZ1CVS', 'WSHPKJ3H', 'WTFS8JV2', 'WTYMIZ88', 'WUARWGNF', 'WUR2UJYP', 'WWDAZG6C', 'WX0HMR4F', 'WZX61W39', 'WZZLL8O4', 'X0VJJXGQ', 'X2PFPX2S', 'X4WO7LHO', 'X4YNMN9Z', 'X6497O49', 'X6LFEBK7', 'X920R0YN', 'X9RNN0YD', 'XCWSW5T9', 'XD80LQN2', 'XE4D68OI', 'XHQPAVRU', 'XLYFD8RW', 'XOEVMQZT', 'XP1SRNTB', 'XP5B8615', 'XPQ9IYZC', 'XR7GR7UE', 'XRENDLF1', 'XSA3Y2H6', 'XTKRJ8N6', 'XU8GASLQ', 'XV32YHEZ', 'XY9JOM6L', 'XYB5NWR4', 'Y060M6TK', 'Y324NGPN', 'Y3HA6UDE', 'Y4G53L4X', 'Y4X5JU76', 'Y575VUS1', 'Y5YH740Y', 'Y620TYKH', 'Y6EC9YQA', 'Y73L2QKM', 'Y81SHRRC', 'YCD71LRY', 'YCNWCC0Z', 'YCY2FFYZ', 'YDPNP1KR', 'YE9BU3J3', 'YEA0ZZZP', 'YEZ30YUQ', 'YFSGJUTL', 'YGFI5B9G', 'YGFIQ8SA', 'YHUR7HZ6', 'YHX2594T', 'YKXRSB4N', 'YL8AOR9Q', 'YLS2HEMR', 'YMHGXK99', 'YMWK7JKH', 'YP4WCV92', 'YQ3L8TWE', 'YQITW66D', 'YTGT3GEX', 'YTOOMPZ8', 'YW85XPTE', 'YWQZUSA8', 'YWZAEK5A', 'YXKFDH6S', 'YY5Y32CI', 'YZX8R26H', 'Z1C99MVU', 'Z1Y066QU', 'Z6LWLWFZ', 'Z7YFK3I0', 'Z7ZKDLZG', 'Z80NVAXF', 'Z8BWVZZX', 'ZAYLY2YU', 'ZB6DPIG5', 'ZB862XHR', 'ZBQD50GN', 'ZC07UYVV', 'ZCU48L3S', 'ZEAZQ1QQ', 'ZEB7PDQK', 'ZEBTRK7D', 'ZEJOQQJF', 'ZELU1VMX', 'ZFBSIW7Q', 'ZGY1YZ7P', 'ZH6LR5MO', 'ZIGUIE0J', 'ZIJRW95G', 'ZK6YBV02', 'ZLSXM0KN', 'ZMCRIYYJ', 'ZMEZU4BS', 'ZMUIMBDX', 'ZOI7FJEN', 'ZQ5A6IY9', 'ZQNGGY33', 'ZSHS4VJZ', 'ZT1IP3T6', 'ZU6860XU', 'ZU6TVFFU', 'ZU75P59K', 'ZUI6TDWV', 'ZWFD8OHC', 'ZX06ZDZN', 'ZZJVE4HO']\n"
     ]
    }
   ],
   "source": [
    "print('========= train columns ==========')\n",
    "print([c for c in train_set.columns])\n",
    "\n",
    "print('========= test columns ==========')\n",
    "print([c for c in test_set.columns])\n",
    "\n",
    "print('========= train columns ==========')\n",
    "print([c for c in label_set.columns])\n",
    "\n",
    "print('========= test columns ==========')\n",
    "print([c for c in sub_set.columns])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Counter({'C': 1923, 'A': 1848, 'T': 1586, 'G': 1794})"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Counter(train_set['sequence'].values[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def count(c):\n",
    "    c['A'] = c['sequence'].apply(lambda s: s.count('A'))\n",
    "    c['G'] = c['sequence'].apply(lambda s: s.count('G'))\n",
    "    c['U'] = c['sequence'].apply(lambda s: s.count('U'))\n",
    "    c['C'] = c['sequence'].apply(lambda s: s.count('C'))\n",
    "    c['N'] = c['sequence'].apply(lambda s: s.count('N'))\n",
    "\n",
    "\n",
    "    return c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "count_train = count(train_set)\n",
    "count_test  = count(test_set)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence_id</th>\n",
       "      <th>sequence</th>\n",
       "      <th>bacterial_resistance_ampicillin</th>\n",
       "      <th>bacterial_resistance_chloramphenicol</th>\n",
       "      <th>bacterial_resistance_kanamycin</th>\n",
       "      <th>bacterial_resistance_other</th>\n",
       "      <th>bacterial_resistance_spectinomycin</th>\n",
       "      <th>copy_number_high_copy</th>\n",
       "      <th>copy_number_low_copy</th>\n",
       "      <th>copy_number_unknown</th>\n",
       "      <th>...</th>\n",
       "      <th>species_nematode</th>\n",
       "      <th>species_other</th>\n",
       "      <th>species_rat</th>\n",
       "      <th>species_synthetic</th>\n",
       "      <th>species_zebrafish</th>\n",
       "      <th>A</th>\n",
       "      <th>G</th>\n",
       "      <th>U</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9ZIMC</td>\n",
       "      <td>CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1848</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "      <td>1923</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5SAQC</td>\n",
       "      <td>GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124</td>\n",
       "      <td>107</td>\n",
       "      <td>0</td>\n",
       "      <td>118</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>E7QRO</td>\n",
       "      <td>NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>220</td>\n",
       "      <td>971</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  sequence_id                                           sequence  \\\n",
       "0       9ZIMC  CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...   \n",
       "1       5SAQC  GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...   \n",
       "2       E7QRO  NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...   \n",
       "\n",
       "   bacterial_resistance_ampicillin  bacterial_resistance_chloramphenicol  \\\n",
       "0                              0.0                                   0.0   \n",
       "1                              1.0                                   0.0   \n",
       "2                              1.0                                   0.0   \n",
       "\n",
       "   bacterial_resistance_kanamycin  bacterial_resistance_other  \\\n",
       "0                             1.0                         0.0   \n",
       "1                             0.0                         0.0   \n",
       "2                             0.0                         0.0   \n",
       "\n",
       "   bacterial_resistance_spectinomycin  copy_number_high_copy  \\\n",
       "0                                 0.0                    1.0   \n",
       "1                                 0.0                    1.0   \n",
       "2                                 0.0                    1.0   \n",
       "\n",
       "   copy_number_low_copy  copy_number_unknown  ...  species_nematode  \\\n",
       "0                   0.0                  0.0  ...               0.0   \n",
       "1                   0.0                  0.0  ...               0.0   \n",
       "2                   0.0                  0.0  ...               0.0   \n",
       "\n",
       "   species_other  species_rat  species_synthetic  species_zebrafish     A  \\\n",
       "0            0.0          0.0                0.0                0.0  1848   \n",
       "1            0.0          0.0                0.0                0.0   124   \n",
       "2            0.0          0.0                0.0                0.0   220   \n",
       "\n",
       "      G  U     C   N  \n",
       "0  1794  0  1923   0  \n",
       "1   107  0   118   0  \n",
       "2   971  0    95  92  \n",
       "\n",
       "[3 rows x 46 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_set.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sequence_id     object\n",
       "00Q4V31T       float64\n",
       "012VT4JK       float64\n",
       "028IO5W2       float64\n",
       "03GRNN7N       float64\n",
       "                ...   \n",
       "ZU75P59K       float64\n",
       "ZUI6TDWV       float64\n",
       "ZWFD8OHC       float64\n",
       "ZX06ZDZN       float64\n",
       "ZZJVE4HO       float64\n",
       "Length: 1315, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "label_set.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence_id</th>\n",
       "      <th>00Q4V31T</th>\n",
       "      <th>012VT4JK</th>\n",
       "      <th>028IO5W2</th>\n",
       "      <th>03GRNN7N</th>\n",
       "      <th>03Y3W51H</th>\n",
       "      <th>09MQV1TY</th>\n",
       "      <th>0A4AHRCT</th>\n",
       "      <th>0A9M05NC</th>\n",
       "      <th>0B9GCUVV</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>ZX06ZDZN</th>\n",
       "      <th>ZZJVE4HO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9ZIMC</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5SAQC</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>E7QRO</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 1315 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  sequence_id  00Q4V31T  012VT4JK  028IO5W2  03GRNN7N  03Y3W51H  09MQV1TY  \\\n",
       "0       9ZIMC       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1       5SAQC       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "2       E7QRO       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   0A4AHRCT  0A9M05NC  0B9GCUVV  ...  ZQNGGY33  ZSHS4VJZ  ZT1IP3T6  ZU6860XU  \\\n",
       "0       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "1       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "2       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  ZX06ZDZN  ZZJVE4HO  \n",
       "0       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "1       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "2       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "\n",
       "[3 rows x 1315 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "label_set.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "train_lab = pd.DataFrame(label_set)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence_id</th>\n",
       "      <th>00Q4V31T</th>\n",
       "      <th>012VT4JK</th>\n",
       "      <th>028IO5W2</th>\n",
       "      <th>03GRNN7N</th>\n",
       "      <th>03Y3W51H</th>\n",
       "      <th>09MQV1TY</th>\n",
       "      <th>0A4AHRCT</th>\n",
       "      <th>0A9M05NC</th>\n",
       "      <th>0B9GCUVV</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>ZX06ZDZN</th>\n",
       "      <th>ZZJVE4HO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9ZIMC</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5SAQC</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>E7QRO</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 1315 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  sequence_id  00Q4V31T  012VT4JK  028IO5W2  03GRNN7N  03Y3W51H  09MQV1TY  \\\n",
       "0       9ZIMC       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1       5SAQC       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "2       E7QRO       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   0A4AHRCT  0A9M05NC  0B9GCUVV  ...  ZQNGGY33  ZSHS4VJZ  ZT1IP3T6  ZU6860XU  \\\n",
       "0       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "1       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "2       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  ZX06ZDZN  ZZJVE4HO  \n",
       "0       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "1       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "2       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "\n",
       "[3 rows x 1315 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_lab.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sequence_id    ZZX64\n",
       "00Q4V31T           1\n",
       "012VT4JK           1\n",
       "028IO5W2           1\n",
       "03GRNN7N           1\n",
       "               ...  \n",
       "ZU75P59K           1\n",
       "ZUI6TDWV           1\n",
       "ZWFD8OHC           1\n",
       "ZX06ZDZN           1\n",
       "ZZJVE4HO           1\n",
       "Length: 1315, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_lab.max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "new = train_lab.set_index('sequence_id').select_dtypes('number')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 296,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence</th>\n",
       "      <th>bacterial_resistance_ampicillin</th>\n",
       "      <th>bacterial_resistance_chloramphenicol</th>\n",
       "      <th>bacterial_resistance_kanamycin</th>\n",
       "      <th>bacterial_resistance_other</th>\n",
       "      <th>bacterial_resistance_spectinomycin</th>\n",
       "      <th>copy_number_high_copy</th>\n",
       "      <th>copy_number_low_copy</th>\n",
       "      <th>copy_number_unknown</th>\n",
       "      <th>growth_strain_ccdb_survival</th>\n",
       "      <th>...</th>\n",
       "      <th>species_rat</th>\n",
       "      <th>species_synthetic</th>\n",
       "      <th>species_zebrafish</th>\n",
       "      <th>A</th>\n",
       "      <th>G</th>\n",
       "      <th>U</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "      <th>lab_id</th>\n",
       "      <th>is_train</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sequence_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9ZIMC</th>\n",
       "      <td>CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1848</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "      <td>1923</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5SAQC</th>\n",
       "      <td>GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124</td>\n",
       "      <td>107</td>\n",
       "      <td>0</td>\n",
       "      <td>118</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E7QRO</th>\n",
       "      <td>NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>220</td>\n",
       "      <td>971</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>92</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CT5FP</th>\n",
       "      <td>GCGGAGATGAAGAGCCCTACGAAAGCTGAGCCTGCGACTCCCGCAG...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>230</td>\n",
       "      <td>235</td>\n",
       "      <td>0</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7PTD8</th>\n",
       "      <td>CGCGCATTACTTCACATGGTCCTCAAGGGTAACATGAAAGTGATCC...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>386</td>\n",
       "      <td>415</td>\n",
       "      <td>0</td>\n",
       "      <td>234</td>\n",
       "      <td>72</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BOQSD</th>\n",
       "      <td>AACAAAATATTAACGCTTACAATTTCCATTCGCCATTCAGGCTGCG...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1345</td>\n",
       "      <td>1577</td>\n",
       "      <td>0</td>\n",
       "      <td>1613</td>\n",
       "      <td>2</td>\n",
       "      <td>3EZXYI3U</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5XVVU</th>\n",
       "      <td>AACAAAATATTAACGCTTACAATTTCCATTCGCCATTCAGGCTGCG...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1337</td>\n",
       "      <td>1567</td>\n",
       "      <td>0</td>\n",
       "      <td>1603</td>\n",
       "      <td>0</td>\n",
       "      <td>3EZXYI3U</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVGHF</th>\n",
       "      <td>CCGGTGGTGCATATCGGGGATGAAAGCTGGCGCATGATGACCACCG...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1967</td>\n",
       "      <td>2852</td>\n",
       "      <td>0</td>\n",
       "      <td>2914</td>\n",
       "      <td>0</td>\n",
       "      <td>3EZXYI3U</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZVT1A</th>\n",
       "      <td>CTAGCTAGTCCTGCAGGTTTAAACGAATTCGCCCTTTGCTTTCTCT...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1956</td>\n",
       "      <td>2837</td>\n",
       "      <td>0</td>\n",
       "      <td>2904</td>\n",
       "      <td>0</td>\n",
       "      <td>3EZXYI3U</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>U5MR3</th>\n",
       "      <td>TGGCGAATGGGACGCGCCCTGTAGCGGCGCATTAAGCGCGGCGGGT...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1327</td>\n",
       "      <td>1447</td>\n",
       "      <td>0</td>\n",
       "      <td>1510</td>\n",
       "      <td>0</td>\n",
       "      <td>3EZXYI3U</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63017 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      sequence  \\\n",
       "sequence_id                                                      \n",
       "9ZIMC        CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...   \n",
       "5SAQC        GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...   \n",
       "E7QRO        NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...   \n",
       "CT5FP        GCGGAGATGAAGAGCCCTACGAAAGCTGAGCCTGCGACTCCCGCAG...   \n",
       "7PTD8        CGCGCATTACTTCACATGGTCCTCAAGGGTAACATGAAAGTGATCC...   \n",
       "...                                                        ...   \n",
       "BOQSD        AACAAAATATTAACGCTTACAATTTCCATTCGCCATTCAGGCTGCG...   \n",
       "5XVVU        AACAAAATATTAACGCTTACAATTTCCATTCGCCATTCAGGCTGCG...   \n",
       "CVGHF        CCGGTGGTGCATATCGGGGATGAAAGCTGGCGCATGATGACCACCG...   \n",
       "ZVT1A        CTAGCTAGTCCTGCAGGTTTAAACGAATTCGCCCTTTGCTTTCTCT...   \n",
       "U5MR3        TGGCGAATGGGACGCGCCCTGTAGCGGCGCATTAAGCGCGGCGGGT...   \n",
       "\n",
       "             bacterial_resistance_ampicillin  \\\n",
       "sequence_id                                    \n",
       "9ZIMC                                    0.0   \n",
       "5SAQC                                    1.0   \n",
       "E7QRO                                    1.0   \n",
       "CT5FP                                    1.0   \n",
       "7PTD8                                    1.0   \n",
       "...                                      ...   \n",
       "BOQSD                                    0.0   \n",
       "5XVVU                                    0.0   \n",
       "CVGHF                                    1.0   \n",
       "ZVT1A                                    1.0   \n",
       "U5MR3                                    0.0   \n",
       "\n",
       "             bacterial_resistance_chloramphenicol  \\\n",
       "sequence_id                                         \n",
       "9ZIMC                                         0.0   \n",
       "5SAQC                                         0.0   \n",
       "E7QRO                                         0.0   \n",
       "CT5FP                                         0.0   \n",
       "7PTD8                                         0.0   \n",
       "...                                           ...   \n",
       "BOQSD                                         0.0   \n",
       "5XVVU                                         0.0   \n",
       "CVGHF                                         0.0   \n",
       "ZVT1A                                         0.0   \n",
       "U5MR3                                         0.0   \n",
       "\n",
       "             bacterial_resistance_kanamycin  bacterial_resistance_other  \\\n",
       "sequence_id                                                               \n",
       "9ZIMC                                   1.0                         0.0   \n",
       "5SAQC                                   0.0                         0.0   \n",
       "E7QRO                                   0.0                         0.0   \n",
       "CT5FP                                   0.0                         0.0   \n",
       "7PTD8                                   0.0                         0.0   \n",
       "...                                     ...                         ...   \n",
       "BOQSD                                   1.0                         0.0   \n",
       "5XVVU                                   1.0                         0.0   \n",
       "CVGHF                                   0.0                         0.0   \n",
       "ZVT1A                                   0.0                         0.0   \n",
       "U5MR3                                   1.0                         0.0   \n",
       "\n",
       "             bacterial_resistance_spectinomycin  copy_number_high_copy  \\\n",
       "sequence_id                                                              \n",
       "9ZIMC                                       0.0                    1.0   \n",
       "5SAQC                                       0.0                    1.0   \n",
       "E7QRO                                       0.0                    1.0   \n",
       "CT5FP                                       0.0                    1.0   \n",
       "7PTD8                                       0.0                    1.0   \n",
       "...                                         ...                    ...   \n",
       "BOQSD                                       0.0                    0.0   \n",
       "5XVVU                                       0.0                    0.0   \n",
       "CVGHF                                       0.0                    1.0   \n",
       "ZVT1A                                       0.0                    1.0   \n",
       "U5MR3                                       0.0                    1.0   \n",
       "\n",
       "             copy_number_low_copy  copy_number_unknown  \\\n",
       "sequence_id                                              \n",
       "9ZIMC                         0.0                  0.0   \n",
       "5SAQC                         0.0                  0.0   \n",
       "E7QRO                         0.0                  0.0   \n",
       "CT5FP                         0.0                  0.0   \n",
       "7PTD8                         0.0                  0.0   \n",
       "...                           ...                  ...   \n",
       "BOQSD                         0.0                  1.0   \n",
       "5XVVU                         0.0                  1.0   \n",
       "CVGHF                         0.0                  0.0   \n",
       "ZVT1A                         0.0                  0.0   \n",
       "U5MR3                         0.0                  0.0   \n",
       "\n",
       "             growth_strain_ccdb_survival  ...  species_rat  species_synthetic  \\\n",
       "sequence_id                               ...                                   \n",
       "9ZIMC                                0.0  ...          0.0                0.0   \n",
       "5SAQC                                0.0  ...          0.0                0.0   \n",
       "E7QRO                                0.0  ...          0.0                0.0   \n",
       "CT5FP                                0.0  ...          0.0                0.0   \n",
       "7PTD8                                0.0  ...          0.0                0.0   \n",
       "...                                  ...  ...          ...                ...   \n",
       "BOQSD                                0.0  ...          0.0                0.0   \n",
       "5XVVU                                0.0  ...          0.0                0.0   \n",
       "CVGHF                                0.0  ...          0.0                0.0   \n",
       "ZVT1A                                0.0  ...          0.0                0.0   \n",
       "U5MR3                                0.0  ...          0.0                0.0   \n",
       "\n",
       "             species_zebrafish     A     G  U     C   N    lab_id  is_train  \n",
       "sequence_id                                                                  \n",
       "9ZIMC                      0.0  1848  1794  0  1923   0  RYUA3GVO      True  \n",
       "5SAQC                      0.0   124   107  0   118   0  RYUA3GVO      True  \n",
       "E7QRO                      0.0   220   971  0    95  92  RYUA3GVO      True  \n",
       "CT5FP                      0.0   230   235  0   253   0  RYUA3GVO      True  \n",
       "7PTD8                      0.0   386   415  0   234  72  RYUA3GVO      True  \n",
       "...                        ...   ...   ... ..   ...  ..       ...       ...  \n",
       "BOQSD                      0.0  1345  1577  0  1613   2  3EZXYI3U      True  \n",
       "5XVVU                      0.0  1337  1567  0  1603   0  3EZXYI3U      True  \n",
       "CVGHF                      0.0  1967  2852  0  2914   0  3EZXYI3U     False  \n",
       "ZVT1A                      0.0  1956  2837  0  2904   0  3EZXYI3U      True  \n",
       "U5MR3                      0.0  1327  1447  0  1510   0  3EZXYI3U      True  \n",
       "\n",
       "[63017 rows x 47 columns]"
      ]
     },
     "execution_count": 296,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "lab_ids = pd.DataFrame(new.idxmax(axis=1), columns=['lab_id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>lab_id</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sequence_id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9ZIMC</th>\n",
       "      <td>RYUA3GVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5SAQC</th>\n",
       "      <td>RYUA3GVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E7QRO</th>\n",
       "      <td>RYUA3GVO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               lab_id\n",
       "sequence_id          \n",
       "9ZIMC        RYUA3GVO\n",
       "5SAQC        RYUA3GVO\n",
       "E7QRO        RYUA3GVO"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lab_ids.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "train_set = train_set.set_index('sequence_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    1314.000000\n",
       "mean       47.958143\n",
       "std       262.552258\n",
       "min         1.000000\n",
       "25%         9.000000\n",
       "50%        15.000000\n",
       "75%        34.000000\n",
       "max      8286.000000\n",
       "Name: lab_id, dtype: float64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lab_ids['lab_id'].value_counts().describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "def new(c):\n",
    "    c['lab_id'] = lab_ids['lab_id']\n",
    "    return c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "new = new(train_set)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence</th>\n",
       "      <th>bacterial_resistance_ampicillin</th>\n",
       "      <th>bacterial_resistance_chloramphenicol</th>\n",
       "      <th>bacterial_resistance_kanamycin</th>\n",
       "      <th>bacterial_resistance_other</th>\n",
       "      <th>bacterial_resistance_spectinomycin</th>\n",
       "      <th>copy_number_high_copy</th>\n",
       "      <th>copy_number_low_copy</th>\n",
       "      <th>copy_number_unknown</th>\n",
       "      <th>growth_strain_ccdb_survival</th>\n",
       "      <th>...</th>\n",
       "      <th>species_other</th>\n",
       "      <th>species_rat</th>\n",
       "      <th>species_synthetic</th>\n",
       "      <th>species_zebrafish</th>\n",
       "      <th>A</th>\n",
       "      <th>G</th>\n",
       "      <th>U</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "      <th>lab_id</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sequence_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9ZIMC</th>\n",
       "      <td>CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1848</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "      <td>1923</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5SAQC</th>\n",
       "      <td>GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124</td>\n",
       "      <td>107</td>\n",
       "      <td>0</td>\n",
       "      <td>118</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E7QRO</th>\n",
       "      <td>NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>220</td>\n",
       "      <td>971</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>92</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      sequence  \\\n",
       "sequence_id                                                      \n",
       "9ZIMC        CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...   \n",
       "5SAQC        GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...   \n",
       "E7QRO        NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...   \n",
       "\n",
       "             bacterial_resistance_ampicillin  \\\n",
       "sequence_id                                    \n",
       "9ZIMC                                    0.0   \n",
       "5SAQC                                    1.0   \n",
       "E7QRO                                    1.0   \n",
       "\n",
       "             bacterial_resistance_chloramphenicol  \\\n",
       "sequence_id                                         \n",
       "9ZIMC                                         0.0   \n",
       "5SAQC                                         0.0   \n",
       "E7QRO                                         0.0   \n",
       "\n",
       "             bacterial_resistance_kanamycin  bacterial_resistance_other  \\\n",
       "sequence_id                                                               \n",
       "9ZIMC                                   1.0                         0.0   \n",
       "5SAQC                                   0.0                         0.0   \n",
       "E7QRO                                   0.0                         0.0   \n",
       "\n",
       "             bacterial_resistance_spectinomycin  copy_number_high_copy  \\\n",
       "sequence_id                                                              \n",
       "9ZIMC                                       0.0                    1.0   \n",
       "5SAQC                                       0.0                    1.0   \n",
       "E7QRO                                       0.0                    1.0   \n",
       "\n",
       "             copy_number_low_copy  copy_number_unknown  \\\n",
       "sequence_id                                              \n",
       "9ZIMC                         0.0                  0.0   \n",
       "5SAQC                         0.0                  0.0   \n",
       "E7QRO                         0.0                  0.0   \n",
       "\n",
       "             growth_strain_ccdb_survival  ...  species_other  species_rat  \\\n",
       "sequence_id                               ...                               \n",
       "9ZIMC                                0.0  ...            0.0          0.0   \n",
       "5SAQC                                0.0  ...            0.0          0.0   \n",
       "E7QRO                                0.0  ...            0.0          0.0   \n",
       "\n",
       "             species_synthetic  species_zebrafish     A     G  U     C   N  \\\n",
       "sequence_id                                                                  \n",
       "9ZIMC                      0.0                0.0  1848  1794  0  1923   0   \n",
       "5SAQC                      0.0                0.0   124   107  0   118   0   \n",
       "E7QRO                      0.0                0.0   220   971  0    95  92   \n",
       "\n",
       "               lab_id  \n",
       "sequence_id            \n",
       "9ZIMC        RYUA3GVO  \n",
       "5SAQC        RYUA3GVO  \n",
       "E7QRO        RYUA3GVO  \n",
       "\n",
       "[3 rows x 46 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "new['is_train'] = np.random. uniform(0,1,len(new)) <= .75"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence</th>\n",
       "      <th>bacterial_resistance_ampicillin</th>\n",
       "      <th>bacterial_resistance_chloramphenicol</th>\n",
       "      <th>bacterial_resistance_kanamycin</th>\n",
       "      <th>bacterial_resistance_other</th>\n",
       "      <th>bacterial_resistance_spectinomycin</th>\n",
       "      <th>copy_number_high_copy</th>\n",
       "      <th>copy_number_low_copy</th>\n",
       "      <th>copy_number_unknown</th>\n",
       "      <th>growth_strain_ccdb_survival</th>\n",
       "      <th>...</th>\n",
       "      <th>species_rat</th>\n",
       "      <th>species_synthetic</th>\n",
       "      <th>species_zebrafish</th>\n",
       "      <th>A</th>\n",
       "      <th>G</th>\n",
       "      <th>U</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "      <th>lab_id</th>\n",
       "      <th>is_train</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sequence_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9ZIMC</th>\n",
       "      <td>CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1848</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "      <td>1923</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5SAQC</th>\n",
       "      <td>GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124</td>\n",
       "      <td>107</td>\n",
       "      <td>0</td>\n",
       "      <td>118</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E7QRO</th>\n",
       "      <td>NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>220</td>\n",
       "      <td>971</td>\n",
       "      <td>0</td>\n",
       "      <td>95</td>\n",
       "      <td>92</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CT5FP</th>\n",
       "      <td>GCGGAGATGAAGAGCCCTACGAAAGCTGAGCCTGCGACTCCCGCAG...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>230</td>\n",
       "      <td>235</td>\n",
       "      <td>0</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7PTD8</th>\n",
       "      <td>CGCGCATTACTTCACATGGTCCTCAAGGGTAACATGAAAGTGATCC...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>386</td>\n",
       "      <td>415</td>\n",
       "      <td>0</td>\n",
       "      <td>234</td>\n",
       "      <td>72</td>\n",
       "      <td>RYUA3GVO</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      sequence  \\\n",
       "sequence_id                                                      \n",
       "9ZIMC        CATGCATTAGTTATTAATAGTAATCAATTACGGGGTCATTAGTTCA...   \n",
       "5SAQC        GCTGGATGGTTTGGGACATGTGCAGCCCCGTCTCTGTATGGAGTGA...   \n",
       "E7QRO        NNCCGGGCTGTAGCTACACAGGGCGGAGATGAGAGCCCTACGAAAG...   \n",
       "CT5FP        GCGGAGATGAAGAGCCCTACGAAAGCTGAGCCTGCGACTCCCGCAG...   \n",
       "7PTD8        CGCGCATTACTTCACATGGTCCTCAAGGGTAACATGAAAGTGATCC...   \n",
       "\n",
       "             bacterial_resistance_ampicillin  \\\n",
       "sequence_id                                    \n",
       "9ZIMC                                    0.0   \n",
       "5SAQC                                    1.0   \n",
       "E7QRO                                    1.0   \n",
       "CT5FP                                    1.0   \n",
       "7PTD8                                    1.0   \n",
       "\n",
       "             bacterial_resistance_chloramphenicol  \\\n",
       "sequence_id                                         \n",
       "9ZIMC                                         0.0   \n",
       "5SAQC                                         0.0   \n",
       "E7QRO                                         0.0   \n",
       "CT5FP                                         0.0   \n",
       "7PTD8                                         0.0   \n",
       "\n",
       "             bacterial_resistance_kanamycin  bacterial_resistance_other  \\\n",
       "sequence_id                                                               \n",
       "9ZIMC                                   1.0                         0.0   \n",
       "5SAQC                                   0.0                         0.0   \n",
       "E7QRO                                   0.0                         0.0   \n",
       "CT5FP                                   0.0                         0.0   \n",
       "7PTD8                                   0.0                         0.0   \n",
       "\n",
       "             bacterial_resistance_spectinomycin  copy_number_high_copy  \\\n",
       "sequence_id                                                              \n",
       "9ZIMC                                       0.0                    1.0   \n",
       "5SAQC                                       0.0                    1.0   \n",
       "E7QRO                                       0.0                    1.0   \n",
       "CT5FP                                       0.0                    1.0   \n",
       "7PTD8                                       0.0                    1.0   \n",
       "\n",
       "             copy_number_low_copy  copy_number_unknown  \\\n",
       "sequence_id                                              \n",
       "9ZIMC                         0.0                  0.0   \n",
       "5SAQC                         0.0                  0.0   \n",
       "E7QRO                         0.0                  0.0   \n",
       "CT5FP                         0.0                  0.0   \n",
       "7PTD8                         0.0                  0.0   \n",
       "\n",
       "             growth_strain_ccdb_survival  ...  species_rat  species_synthetic  \\\n",
       "sequence_id                               ...                                   \n",
       "9ZIMC                                0.0  ...          0.0                0.0   \n",
       "5SAQC                                0.0  ...          0.0                0.0   \n",
       "E7QRO                                0.0  ...          0.0                0.0   \n",
       "CT5FP                                0.0  ...          0.0                0.0   \n",
       "7PTD8                                0.0  ...          0.0                0.0   \n",
       "\n",
       "             species_zebrafish     A     G  U     C   N    lab_id  is_train  \n",
       "sequence_id                                                                  \n",
       "9ZIMC                      0.0  1848  1794  0  1923   0  RYUA3GVO      True  \n",
       "5SAQC                      0.0   124   107  0   118   0  RYUA3GVO      True  \n",
       "E7QRO                      0.0   220   971  0    95  92  RYUA3GVO      True  \n",
       "CT5FP                      0.0   230   235  0   253   0  RYUA3GVO      True  \n",
       "7PTD8                      0.0   386   415  0   234  72  RYUA3GVO      True  \n",
       "\n",
       "[5 rows x 47 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "train,test = new[new['is_train']== True], new[new['is_train']== False]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "========= train columns ==========\n",
      "47233\n",
      "========= test columns ==========\n",
      "15784\n"
     ]
    }
   ],
   "source": [
    "print('========= train columns ==========')\n",
    "print(len(train))\n",
    "\n",
    "print('========= test columns ==========')\n",
    "print(len(test))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "47\n"
     ]
    }
   ],
   "source": [
    "print(len(new.columns))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "features = new.columns[1:45]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['bacterial_resistance_ampicillin',\n",
       "       'bacterial_resistance_chloramphenicol',\n",
       "       'bacterial_resistance_kanamycin', 'bacterial_resistance_other',\n",
       "       'bacterial_resistance_spectinomycin', 'copy_number_high_copy',\n",
       "       'copy_number_low_copy', 'copy_number_unknown',\n",
       "       'growth_strain_ccdb_survival', 'growth_strain_dh10b',\n",
       "       'growth_strain_dh5alpha', 'growth_strain_neb_stable',\n",
       "       'growth_strain_other', 'growth_strain_stbl3', 'growth_strain_top10',\n",
       "       'growth_strain_xl1_blue', 'growth_temp_30', 'growth_temp_37',\n",
       "       'growth_temp_other', 'selectable_markers_blasticidin',\n",
       "       'selectable_markers_his3', 'selectable_markers_hygromycin',\n",
       "       'selectable_markers_leu2', 'selectable_markers_neomycin',\n",
       "       'selectable_markers_other', 'selectable_markers_puromycin',\n",
       "       'selectable_markers_trp1', 'selectable_markers_ura3',\n",
       "       'selectable_markers_zeocin', 'species_budding_yeast', 'species_fly',\n",
       "       'species_human', 'species_mouse', 'species_mustard_weed',\n",
       "       'species_nematode', 'species_other', 'species_rat', 'species_synthetic',\n",
       "       'species_zebrafish', 'A', 'G', 'U', 'C', 'N'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "y = pd.factorize(train['lab_id'])[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([   0,    0,    0, ..., 1011, 1011, 1011])"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RandomForestClassifier(bootstrap=True, ccp_alpha=0.0, class_weight=None,\n",
       "                       criterion='gini', max_depth=None, max_features='auto',\n",
       "                       max_leaf_nodes=None, max_samples=None,\n",
       "                       min_impurity_decrease=0.0, min_impurity_split=None,\n",
       "                       min_samples_leaf=1, min_samples_split=2,\n",
       "                       min_weight_fraction_leaf=0.0, n_estimators=100, n_jobs=2,\n",
       "                       oob_score=False, random_state=0, verbose=0,\n",
       "                       warm_start=False)"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "classifier = RandomForestClassifier(n_jobs=2,random_state = 0)\n",
    "classifier.fit(train[features],y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([443, 340, 958, ..., 103,  43,  32])"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "classifier.predict(test_set[features])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "k = len(test_set)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 322,
   "metadata": {},
   "outputs": [],
   "source": [
    "prob = classifier.predict_proba(test_set[features])[:k+1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [],
   "source": [
    "pred = test_set.sequence_id[classifier.predict(test_set[features])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "18816"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "k"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15784"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "i = len(test)\n",
    "i"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence_id</th>\n",
       "      <th>00Q4V31T</th>\n",
       "      <th>012VT4JK</th>\n",
       "      <th>028IO5W2</th>\n",
       "      <th>03GRNN7N</th>\n",
       "      <th>03Y3W51H</th>\n",
       "      <th>09MQV1TY</th>\n",
       "      <th>0A4AHRCT</th>\n",
       "      <th>0A9M05NC</th>\n",
       "      <th>0B9GCUVV</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>ZX06ZDZN</th>\n",
       "      <th>ZZJVE4HO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E0VFT</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TTRK5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2Z7FZ</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 1315 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  sequence_id  00Q4V31T  012VT4JK  028IO5W2  03GRNN7N  03Y3W51H  09MQV1TY  \\\n",
       "0       E0VFT       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1       TTRK5       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "2       2Z7FZ       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   0A4AHRCT  0A9M05NC  0B9GCUVV  ...  ZQNGGY33  ZSHS4VJZ  ZT1IP3T6  ZU6860XU  \\\n",
       "0       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "1       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "2       0.0       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  ZX06ZDZN  ZZJVE4HO  \n",
       "0       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "1       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "2       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "\n",
       "[3 rows x 1315 columns]"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sub_set.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 299,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['00Q4V31T', '012VT4JK', '028IO5W2', '03GRNN7N', '03Y3W51H', '09MQV1TY',\n",
       "       '0A4AHRCT', '0A9M05NC', '0B9GCUVV', '0CL7QVG8',\n",
       "       ...\n",
       "       'ZQNGGY33', 'ZSHS4VJZ', 'ZT1IP3T6', 'ZU6860XU', 'ZU6TVFFU', 'ZU75P59K',\n",
       "       'ZUI6TDWV', 'ZWFD8OHC', 'ZX06ZDZN', 'ZZJVE4HO'],\n",
       "      dtype='object', length=1314)"
      ]
     },
     "execution_count": 299,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "u = sub_set.columns[1:]\n",
    "u"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'03GRNN7N'"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "u[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1314,)"
      ]
     },
     "execution_count": 287,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "u.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence_id</th>\n",
       "      <th>sequence</th>\n",
       "      <th>bacterial_resistance_ampicillin</th>\n",
       "      <th>bacterial_resistance_chloramphenicol</th>\n",
       "      <th>bacterial_resistance_kanamycin</th>\n",
       "      <th>bacterial_resistance_other</th>\n",
       "      <th>bacterial_resistance_spectinomycin</th>\n",
       "      <th>copy_number_high_copy</th>\n",
       "      <th>copy_number_low_copy</th>\n",
       "      <th>copy_number_unknown</th>\n",
       "      <th>...</th>\n",
       "      <th>species_nematode</th>\n",
       "      <th>species_other</th>\n",
       "      <th>species_rat</th>\n",
       "      <th>species_synthetic</th>\n",
       "      <th>species_zebrafish</th>\n",
       "      <th>A</th>\n",
       "      <th>G</th>\n",
       "      <th>U</th>\n",
       "      <th>C</th>\n",
       "      <th>N</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E0VFT</td>\n",
       "      <td>AGATCTATACATTGAATCAATATTGGCAATTAGCCATATTAGTCAT...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2363</td>\n",
       "      <td>2310</td>\n",
       "      <td>0</td>\n",
       "      <td>2348</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TTRK5</td>\n",
       "      <td>GCGCGCGTTGACATTGATTATTGACTAGTTATTAATAGTAATCAAT...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1454</td>\n",
       "      <td>1960</td>\n",
       "      <td>0</td>\n",
       "      <td>1824</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  sequence_id                                           sequence  \\\n",
       "0       E0VFT  AGATCTATACATTGAATCAATATTGGCAATTAGCCATATTAGTCAT...   \n",
       "1       TTRK5  GCGCGCGTTGACATTGATTATTGACTAGTTATTAATAGTAATCAAT...   \n",
       "\n",
       "   bacterial_resistance_ampicillin  bacterial_resistance_chloramphenicol  \\\n",
       "0                              1.0                                   0.0   \n",
       "1                              0.0                                   0.0   \n",
       "\n",
       "   bacterial_resistance_kanamycin  bacterial_resistance_other  \\\n",
       "0                             0.0                         0.0   \n",
       "1                             0.0                         1.0   \n",
       "\n",
       "   bacterial_resistance_spectinomycin  copy_number_high_copy  \\\n",
       "0                                 0.0                    0.0   \n",
       "1                                 0.0                    1.0   \n",
       "\n",
       "   copy_number_low_copy  copy_number_unknown  ...  species_nematode  \\\n",
       "0                   0.0                  1.0  ...               0.0   \n",
       "1                   0.0                  0.0  ...               0.0   \n",
       "\n",
       "   species_other  species_rat  species_synthetic  species_zebrafish     A  \\\n",
       "0            0.0          0.0                0.0                1.0  2363   \n",
       "1            0.0          0.0                0.0                0.0  1454   \n",
       "\n",
       "      G  U     C  N  \n",
       "0  2310  0  2348  0  \n",
       "1  1960  0  1824  0  \n",
       "\n",
       "[2 rows x 46 columns]"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_set.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 325,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(18816, 1313)"
      ]
     },
     "execution_count": 325,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prob.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 324,
   "metadata": {},
   "outputs": [],
   "source": [
    "set = pd.DataFrame(prob)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 303,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>1303</th>\n",
       "      <th>1304</th>\n",
       "      <th>1305</th>\n",
       "      <th>1306</th>\n",
       "      <th>1307</th>\n",
       "      <th>1308</th>\n",
       "      <th>1309</th>\n",
       "      <th>1310</th>\n",
       "      <th>1311</th>\n",
       "      <th>1312</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18811</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18812</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18813</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18814</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18815</th>\n",
       "      <td>0.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18816 rows × 1313 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       0     1     2     3     4     5     6     7     8     9     ...  1303  \\\n",
       "0      0.00  0.00   0.0   0.0  0.00   0.0  0.05   0.0   0.0   0.0  ...   0.0   \n",
       "1      0.00  0.00   0.0   0.0  0.00   0.0  0.00   0.0   0.0   0.0  ...   0.0   \n",
       "2      0.00  0.00   0.0   0.0  0.00   0.0  0.13   0.0   0.0   0.0  ...   0.0   \n",
       "3      0.00  0.00   0.0   0.0  0.00   0.0  0.00   0.0   0.0   0.0  ...   0.0   \n",
       "4      0.00  0.00   0.0   0.0  0.00   0.0  0.13   0.0   0.0   0.0  ...   0.0   \n",
       "...     ...   ...   ...   ...   ...   ...   ...   ...   ...   ...  ...   ...   \n",
       "18811  0.00  0.00   0.0   0.0  0.00   0.0  0.03   0.0   0.0   0.0  ...   0.0   \n",
       "18812  0.00  0.00   0.0   0.0  0.00   0.0  0.17   0.0   0.0   0.0  ...   0.0   \n",
       "18813  0.00  0.01   0.0   0.0  0.01   0.0  0.06   0.0   0.0   0.0  ...   0.0   \n",
       "18814  0.00  0.00   0.0   0.0  0.00   0.0  0.11   0.0   0.0   0.0  ...   0.0   \n",
       "18815  0.02  0.00   0.0   0.0  0.00   0.0  0.01   0.0   0.0   0.0  ...   0.0   \n",
       "\n",
       "       1304  1305  1306  1307  1308  1309  1310  1311  1312  \n",
       "0       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.02  \n",
       "1       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "2       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "3       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "4       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "...     ...   ...   ...   ...   ...   ...   ...   ...   ...  \n",
       "18811   0.0  0.01   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18812   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18813   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18814   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18815   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "\n",
       "[18816 rows x 1313 columns]"
      ]
     },
     "execution_count": 303,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [],
   "source": [
    "set_new = pd.DataFrame(test_set['sequence_id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sequence_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E0VFT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TTRK5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2Z7FZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VJI6E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>721FI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18811</th>\n",
       "      <td>4GGKP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18812</th>\n",
       "      <td>37SHJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18813</th>\n",
       "      <td>JS1MB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18814</th>\n",
       "      <td>N642G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18815</th>\n",
       "      <td>BD9BA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18816 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      sequence_id\n",
       "0           E0VFT\n",
       "1           TTRK5\n",
       "2           2Z7FZ\n",
       "3           VJI6E\n",
       "4           721FI\n",
       "...           ...\n",
       "18811       4GGKP\n",
       "18812       37SHJ\n",
       "18813       JS1MB\n",
       "18814       N642G\n",
       "18815       BD9BA\n",
       "\n",
       "[18816 rows x 1 columns]"
      ]
     },
     "execution_count": 192,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>1303</th>\n",
       "      <th>1304</th>\n",
       "      <th>1305</th>\n",
       "      <th>1306</th>\n",
       "      <th>1307</th>\n",
       "      <th>1308</th>\n",
       "      <th>1309</th>\n",
       "      <th>1310</th>\n",
       "      <th>1311</th>\n",
       "      <th>1312</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18811</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18812</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18813</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18814</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18815</th>\n",
       "      <td>0.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18816 rows × 1313 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       0     1     2     3     4     5     6     7     8     9     ...  1303  \\\n",
       "0      0.00  0.00   0.0   0.0  0.00   0.0  0.05   0.0   0.0   0.0  ...   0.0   \n",
       "1      0.00  0.00   0.0   0.0  0.00   0.0  0.00   0.0   0.0   0.0  ...   0.0   \n",
       "2      0.00  0.00   0.0   0.0  0.00   0.0  0.13   0.0   0.0   0.0  ...   0.0   \n",
       "3      0.00  0.00   0.0   0.0  0.00   0.0  0.00   0.0   0.0   0.0  ...   0.0   \n",
       "4      0.00  0.00   0.0   0.0  0.00   0.0  0.13   0.0   0.0   0.0  ...   0.0   \n",
       "...     ...   ...   ...   ...   ...   ...   ...   ...   ...   ...  ...   ...   \n",
       "18811  0.00  0.00   0.0   0.0  0.00   0.0  0.03   0.0   0.0   0.0  ...   0.0   \n",
       "18812  0.00  0.00   0.0   0.0  0.00   0.0  0.17   0.0   0.0   0.0  ...   0.0   \n",
       "18813  0.00  0.01   0.0   0.0  0.01   0.0  0.06   0.0   0.0   0.0  ...   0.0   \n",
       "18814  0.00  0.00   0.0   0.0  0.00   0.0  0.11   0.0   0.0   0.0  ...   0.0   \n",
       "18815  0.02  0.00   0.0   0.0  0.00   0.0  0.01   0.0   0.0   0.0  ...   0.0   \n",
       "\n",
       "       1304  1305  1306  1307  1308  1309  1310  1311  1312  \n",
       "0       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.02  \n",
       "1       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "2       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "3       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "4       0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "...     ...   ...   ...   ...   ...   ...   ...   ...   ...  \n",
       "18811   0.0  0.01   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18812   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18813   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18814   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "18815   0.0  0.00   0.0   0.0   0.0   0.0   0.0   0.0  0.00  \n",
       "\n",
       "[18816 rows x 1313 columns]"
      ]
     },
     "execution_count": 193,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([            1,    '00Q4V31T',    '012VT4JK',    '028IO5W2',\n",
       "          '03GRNN7N',    '03Y3W51H',    '09MQV1TY',    '0A4AHRCT',\n",
       "          '0A9M05NC',    '0B9GCUVV',\n",
       "       ...\n",
       "          'ZQ5A6IY9',    'ZQNGGY33',    'ZSHS4VJZ',    'ZT1IP3T6',\n",
       "          'ZU6860XU',    'ZU6TVFFU',    'ZU75P59K',    'ZUI6TDWV',\n",
       "          'ZWFD8OHC', 'sequence_id'],\n",
       "      dtype='object', length=1314)"
      ]
     },
     "execution_count": 267,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 304,
   "metadata": {},
   "outputs": [],
   "source": [
    "keyf = set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 305,
   "metadata": {},
   "outputs": [],
   "source": [
    "keyf['sequence_id'] = test_set['sequence_id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 321,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQ5A6IY9</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>ZX06ZDZN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 2627 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     0    1    2    3    4    5     6    7    8    9  ...  ZQ5A6IY9  ZQNGGY33  \\\n",
       "0  0.0  0.0  0.0  0.0  0.0  0.0  0.05  0.0  0.0  0.0  ...       0.0       0.0   \n",
       "1  0.0  0.0  0.0  0.0  0.0  0.0  0.00  0.0  0.0  0.0  ...       0.0       0.0   \n",
       "\n",
       "   ZSHS4VJZ  ZT1IP3T6  ZU6860XU  ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  \\\n",
       "0       0.0       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1       0.0       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   ZX06ZDZN  \n",
       "0      0.02  \n",
       "1      0.00  \n",
       "\n",
       "[2 rows x 2627 columns]"
      ]
     },
     "execution_count": 321,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "keyf.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 315,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'03GRNN7N'"
      ]
     },
     "execution_count": 315,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "u[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 318,
   "metadata": {},
   "outputs": [],
   "source": [
    " for i in range(0,1313):\n",
    "        keyf[u[i]] = keyf[i]\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 320,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(18816, 1313)"
      ]
     },
     "execution_count": 320,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "key.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 319,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQ5A6IY9</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>ZX06ZDZN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 2627 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     0    1    2    3    4    5     6    7    8    9  ...  ZQ5A6IY9  ZQNGGY33  \\\n",
       "0  0.0  0.0  0.0  0.0  0.0  0.0  0.05  0.0  0.0  0.0  ...       0.0       0.0   \n",
       "1  0.0  0.0  0.0  0.0  0.0  0.0  0.00  0.0  0.0  0.0  ...       0.0       0.0   \n",
       "\n",
       "   ZSHS4VJZ  ZT1IP3T6  ZU6860XU  ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  \\\n",
       "0       0.0       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1       0.0       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   ZX06ZDZN  \n",
       "0      0.02  \n",
       "1      0.00  \n",
       "\n",
       "[2 rows x 2627 columns]"
      ]
     },
     "execution_count": 319,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "keyf.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 283,
   "metadata": {},
   "outputs": [],
   "source": [
    "keyf[1] = keyf['sequence_id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 284,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1</th>\n",
       "      <th>00Q4V31T</th>\n",
       "      <th>012VT4JK</th>\n",
       "      <th>028IO5W2</th>\n",
       "      <th>03GRNN7N</th>\n",
       "      <th>03Y3W51H</th>\n",
       "      <th>09MQV1TY</th>\n",
       "      <th>0A4AHRCT</th>\n",
       "      <th>0A9M05NC</th>\n",
       "      <th>0B9GCUVV</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQ5A6IY9</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>sequence_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E0VFT</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>E0VFT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TTRK5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>TTRK5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2Z7FZ</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2Z7FZ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 1314 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       1  00Q4V31T  012VT4JK  028IO5W2  03GRNN7N  03Y3W51H  09MQV1TY  \\\n",
       "0  E0VFT       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1  TTRK5       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "2  2Z7FZ       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   0A4AHRCT  0A9M05NC  0B9GCUVV  ...  ZQ5A6IY9  ZQNGGY33  ZSHS4VJZ  ZT1IP3T6  \\\n",
       "0      0.05       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "1      0.00       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "2      0.13       0.0       0.0  ...       0.0       0.0       0.0       0.0   \n",
       "\n",
       "   ZU6860XU  ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  sequence_id  \n",
       "0       0.0       0.0       0.0       0.0       0.0        E0VFT  \n",
       "1       0.0       0.0       0.0       0.0       0.0        TTRK5  \n",
       "2       0.0       0.0       0.0       0.0       0.0        2Z7FZ  \n",
       "\n",
       "[3 rows x 1314 columns]"
      ]
     },
     "execution_count": 284,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "keyf.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 285,
   "metadata": {},
   "outputs": [],
   "source": [
    "del keyf['sequence_id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1</th>\n",
       "      <th>00Q4V31T</th>\n",
       "      <th>012VT4JK</th>\n",
       "      <th>028IO5W2</th>\n",
       "      <th>03GRNN7N</th>\n",
       "      <th>03Y3W51H</th>\n",
       "      <th>09MQV1TY</th>\n",
       "      <th>0A4AHRCT</th>\n",
       "      <th>0A9M05NC</th>\n",
       "      <th>0B9GCUVV</th>\n",
       "      <th>...</th>\n",
       "      <th>ZOI7FJEN</th>\n",
       "      <th>ZQ5A6IY9</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E0VFT</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TTRK5</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2Z7FZ</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VJI6E</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>721FI</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18811</th>\n",
       "      <td>4GGKP</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18812</th>\n",
       "      <td>37SHJ</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18813</th>\n",
       "      <td>JS1MB</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18814</th>\n",
       "      <td>N642G</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18815</th>\n",
       "      <td>BD9BA</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18816 rows × 1313 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           1  00Q4V31T  012VT4JK  028IO5W2  03GRNN7N  03Y3W51H  09MQV1TY  \\\n",
       "0      E0VFT      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "1      TTRK5      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "2      2Z7FZ      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "3      VJI6E      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "4      721FI      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "...      ...       ...       ...       ...       ...       ...       ...   \n",
       "18811  4GGKP      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "18812  37SHJ      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "18813  JS1MB      0.00      0.01       0.0       0.0      0.01       0.0   \n",
       "18814  N642G      0.00      0.00       0.0       0.0      0.00       0.0   \n",
       "18815  BD9BA      0.02      0.00       0.0       0.0      0.00       0.0   \n",
       "\n",
       "       0A4AHRCT  0A9M05NC  0B9GCUVV  ...  ZOI7FJEN  ZQ5A6IY9  ZQNGGY33  \\\n",
       "0          0.05       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "1          0.00       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "2          0.13       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "3          0.00       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "4          0.13       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "...         ...       ...       ...  ...       ...       ...       ...   \n",
       "18811      0.03       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "18812      0.17       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "18813      0.06       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "18814      0.11       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "18815      0.01       0.0       0.0  ...       0.0       0.0       0.0   \n",
       "\n",
       "       ZSHS4VJZ  ZT1IP3T6  ZU6860XU  ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  \n",
       "0          0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "1          0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "2          0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "3          0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "4          0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "...         ...       ...       ...       ...       ...       ...       ...  \n",
       "18811      0.01       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "18812      0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "18813      0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "18814      0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "18815      0.00       0.0       0.0       0.0       0.0       0.0       0.0  \n",
       "\n",
       "[18816 rows x 1313 columns]"
      ]
     },
     "execution_count": 286,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "keyf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 326,
   "metadata": {},
   "outputs": [],
   "source": [
    "keyf['ZZJVE4HO']= keyf['ZQ5A6IY9']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 344,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>ZX06ZDZN</th>\n",
       "      <th>ZZJVE4HO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18811</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18812</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18813</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18814</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18815</th>\n",
       "      <td>0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18816 rows × 2627 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          0    2    3     4    5     6    7    8    9   10  ...  ZQNGGY33  \\\n",
       "0      0.00  0.0  0.0  0.00  0.0  0.05  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "1      0.00  0.0  0.0  0.00  0.0  0.00  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "2      0.00  0.0  0.0  0.00  0.0  0.13  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "3      0.00  0.0  0.0  0.00  0.0  0.00  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "4      0.00  0.0  0.0  0.00  0.0  0.13  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "...     ...  ...  ...   ...  ...   ...  ...  ...  ...  ...  ...       ...   \n",
       "18811  0.00  0.0  0.0  0.00  0.0  0.03  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18812  0.00  0.0  0.0  0.00  0.0  0.17  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18813  0.00  0.0  0.0  0.01  0.0  0.06  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18814  0.00  0.0  0.0  0.00  0.0  0.11  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18815  0.02  0.0  0.0  0.00  0.0  0.01  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "\n",
       "       ZSHS4VJZ  ZT1IP3T6  ZU6860XU  ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  \\\n",
       "0          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "2          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "3          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "4          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "...         ...       ...       ...       ...       ...       ...       ...   \n",
       "18811      0.01       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18812      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18813      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18814      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18815      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "       ZX06ZDZN  ZZJVE4HO  \n",
       "0          0.02       0.0  \n",
       "1          0.00       0.0  \n",
       "2          0.00       0.0  \n",
       "3          0.00       0.0  \n",
       "4          0.00       0.0  \n",
       "...         ...       ...  \n",
       "18811      0.00       0.0  \n",
       "18812      0.00       0.0  \n",
       "18813      0.00       0.0  \n",
       "18814      0.00       0.0  \n",
       "18815      0.00       0.0  \n",
       "\n",
       "[18816 rows x 2627 columns]"
      ]
     },
     "execution_count": 344,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "keyf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 352,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(18816, 2627)"
      ]
     },
     "execution_count": 352,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "keyf.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 348,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>...</th>\n",
       "      <th>ZQNGGY33</th>\n",
       "      <th>ZSHS4VJZ</th>\n",
       "      <th>ZT1IP3T6</th>\n",
       "      <th>ZU6860XU</th>\n",
       "      <th>ZU6TVFFU</th>\n",
       "      <th>ZU75P59K</th>\n",
       "      <th>ZUI6TDWV</th>\n",
       "      <th>ZWFD8OHC</th>\n",
       "      <th>ZX06ZDZN</th>\n",
       "      <th>ZZJVE4HO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18811</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18812</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18813</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18814</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18815</th>\n",
       "      <td>0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18816 rows × 2627 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          0    2    3     4    5     6    7    8    9   10  ...  ZQNGGY33  \\\n",
       "0      0.00  0.0  0.0  0.00  0.0  0.05  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "1      0.00  0.0  0.0  0.00  0.0  0.00  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "2      0.00  0.0  0.0  0.00  0.0  0.13  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "3      0.00  0.0  0.0  0.00  0.0  0.00  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "4      0.00  0.0  0.0  0.00  0.0  0.13  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "...     ...  ...  ...   ...  ...   ...  ...  ...  ...  ...  ...       ...   \n",
       "18811  0.00  0.0  0.0  0.00  0.0  0.03  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18812  0.00  0.0  0.0  0.00  0.0  0.17  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18813  0.00  0.0  0.0  0.01  0.0  0.06  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18814  0.00  0.0  0.0  0.00  0.0  0.11  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "18815  0.02  0.0  0.0  0.00  0.0  0.01  0.0  0.0  0.0  0.0  ...       0.0   \n",
       "\n",
       "       ZSHS4VJZ  ZT1IP3T6  ZU6860XU  ZU6TVFFU  ZU75P59K  ZUI6TDWV  ZWFD8OHC  \\\n",
       "0          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "1          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "2          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "3          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "4          0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "...         ...       ...       ...       ...       ...       ...       ...   \n",
       "18811      0.01       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18812      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18813      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18814      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "18815      0.00       0.0       0.0       0.0       0.0       0.0       0.0   \n",
       "\n",
       "       ZX06ZDZN  ZZJVE4HO  \n",
       "0          0.02       0.0  \n",
       "1          0.00       0.0  \n",
       "2          0.00       0.0  \n",
       "3          0.00       0.0  \n",
       "4          0.00       0.0  \n",
       "...         ...       ...  \n",
       "18811      0.00       0.0  \n",
       "18812      0.00       0.0  \n",
       "18813      0.00       0.0  \n",
       "18814      0.00       0.0  \n",
       "18815      0.00       0.0  \n",
       "\n",
       "[18816 rows x 2627 columns]"
      ]
     },
     "execution_count": 348,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "keyf "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 354,
   "metadata": {},
   "outputs": [],
   "source": [
    "keyf.to_csv('/Users/iknott/Desktop/Kaggle/DrivenData/set.csv')"
   ]
  }
 ],
 "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}