NEB_Primer_Sequence_Analysis_18_05_2022.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Owaiskhan9654/Gene-Sequence-Primer-/blob/main/NEB_Primer_Sequence_Analysis_18_05_2022.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "id": "41fe32ca",
      "metadata": {
        "id": "41fe32ca"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import requests\n",
        "import pandas as pd\n",
        "from tqdm import tqdm\n",
        "import json\n",
        "from functools import reduce"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import requests\n",
        "import pandas as pd\n",
        "\n",
        "url=\"https://github.com/Owaiskhan9654/Gene-Sequence-Primer-/blob/main/NEB%20Primer%20Sequence.xlsx?raw=true\"\n",
        "\n",
        "response = requests.get(url)\n",
        "\n",
        "dest = 'NEB Primer Sequence.xlsx'\n",
        "\n",
        "with open(dest, 'wb') as file:\n",
        "    file.write(response.content)"
      ],
      "metadata": {
        "id": "oH0LeCLlPvBR"
      },
      "id": "oH0LeCLlPvBR",
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "id": "84d526f5",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "84d526f5",
        "outputId": "6862536f-579b-441b-bd78-3db3544a82e1"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['Primer name', 'Sequence', 'Synthesis scale'], dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ],
      "source": [
        "NEB_df = pd.read_excel(\"NEB Primer Sequence.xlsx\", sheet_name=2,header=1).dropna()\n",
        "NEB_df.reset_index(drop=True,inplace=True)\n",
        "NEB_df.columns"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "id": "d002fd75",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "d002fd75",
        "outputId": "45c5ae3f-4de6-431d-ea55-7f88a17144a1"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG': 'Gene-E1-FIP',\n",
              " 'ACCAGGAACTAATCAGACAAG': 'N2-F3',\n",
              " 'AGCCTGGATAGCAACGTACA': 'ACTB-B3',\n",
              " 'AGTACCCCATCGAGCACG': 'ACTB-F3',\n",
              " 'CGAGAAGATGACCCAGATCATGT': 'ACTB-LB',\n",
              " 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA': 'N2-BIP',\n",
              " 'CGCTATTAACTATTAACG': 'Gene-E1-LF',\n",
              " 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC': 'ACTB-BIP',\n",
              " 'CTTCGGGAACGTGGTTGACC': 'N2-LB',\n",
              " 'GACTTGATCTTTGAAATTTGGATCT': 'N2-B3',\n",
              " 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA': 'ACTB-FIP',\n",
              " 'GCGCTTCGATTGTGTGCGT': 'Gene-E1-LB',\n",
              " 'GGGGGCAAATTGTGCAATTTG': 'N2-LF',\n",
              " 'TGAGTACGAACTTATGTACTCAT': 'Gene-E1-F3',\n",
              " 'TGTGGTGCCAGATTTTCTCCA': 'ACTB-LF',\n",
              " 'TTCAGATTTTTAACACGAGAGT': 'Gene-E1-B3',\n",
              " 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC': 'N2-FIP',\n",
              " 'TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT': 'Gene-E1-BIP'}"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ],
      "source": [
        "Sequence_dict = {}\n",
        "\n",
        "for i in NEB_df.index:\n",
        "    Sequence_dict[NEB_df['Sequence'][i]] = NEB_df['Primer name'][i]\n",
        "\n",
        "Sequence_dict"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "id": "b04e974c",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "b04e974c",
        "outputId": "4f3d2542-f71a-49a6-ee67-a71997fbbfcd"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'ACTB-B3': 'AGCCTGGATAGCAACGTACA',\n",
              " 'ACTB-BIP': 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC',\n",
              " 'ACTB-F3': 'AGTACCCCATCGAGCACG',\n",
              " 'ACTB-FIP': 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA',\n",
              " 'ACTB-LB': 'CGAGAAGATGACCCAGATCATGT',\n",
              " 'ACTB-LF': 'TGTGGTGCCAGATTTTCTCCA',\n",
              " 'Gene-E1-B3': 'TTCAGATTTTTAACACGAGAGT',\n",
              " 'Gene-E1-BIP': 'TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT',\n",
              " 'Gene-E1-F3': 'TGAGTACGAACTTATGTACTCAT',\n",
              " 'Gene-E1-FIP': 'ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG',\n",
              " 'Gene-E1-LB': 'GCGCTTCGATTGTGTGCGT',\n",
              " 'Gene-E1-LF': 'CGCTATTAACTATTAACG',\n",
              " 'N2-B3': 'GACTTGATCTTTGAAATTTGGATCT',\n",
              " 'N2-BIP': 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA',\n",
              " 'N2-F3': 'ACCAGGAACTAATCAGACAAG',\n",
              " 'N2-FIP': 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC',\n",
              " 'N2-LB': 'CTTCGGGAACGTGGTTGACC',\n",
              " 'N2-LF': 'GGGGGCAAATTGTGCAATTTG'}"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ],
      "source": [
        "Primer_dict = {}\n",
        "\n",
        "for i in NEB_df.index:\n",
        "    Primer_dict[NEB_df['Primer name'][i]] = NEB_df['Sequence'][i]\n",
        "\n",
        "Primer_dict"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "62b13189",
      "metadata": {
        "id": "62b13189"
      },
      "source": [
        "## POST /v1/OligoAnalyzer/Analyze"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "id": "206a9054",
      "metadata": {
        "scrolled": true,
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "206a9054",
        "outputId": "7cce2c5c-12ab-49b2-c386-16bbb3fe6736"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "100%|██████████| 18/18 [00:09<00:00,  1.99it/s]"
          ]
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "CPU times: user 588 ms, sys: 40.5 ms, total: 629 ms\n",
            "Wall time: 9.07 s\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "\n"
          ]
        }
      ],
      "source": [
        "%%time\n",
        "\n",
        "headers = {\n",
        "    'Content-Type': 'application/json',\n",
        "    'Accept': 'application/json',\n",
        "    'Authorization': 'Bearer ea47c6eec999b5daa1c4e49f3307dab7',\n",
        "}\n",
        "\n",
        "Primer_Name = []\n",
        "Sequence = []\n",
        "Complement = []\n",
        "length = []\n",
        "GCContent = []\n",
        "MeltTemp = []\n",
        "NmoleOD = []\n",
        "OligoConc_list = []\n",
        "MgConc_list = []\n",
        "NaConc_list = []\n",
        "dNTPsConc_list = []\n",
        "NucleotideType_list=[]\n",
        "count = 0\n",
        "for i in tqdm(NEB_df.index):\n",
        "    Primer_Name1=NEB_df.iloc[i]['Primer name']\n",
        "#     print(Primer_Name1)\n",
        "    oligo_Conc_dict={'F3':0.2,'B3':0.2,'Fip':1.6,'Bip':1.6,'Lf':0.4,'Bf':0.4} \n",
        "    dntp_Conc_dict={'F3':1.4,'B3':1.4,'Fip':1.4,'Bip':1.4,'Lf':1.4,'Bf':1.4} \n",
        "    mg_Conc_dict={'F3':8,'B3':8,'Fip':8,'Bip':8,'Lf':8,'Bf':8} \n",
        "    Na_Conc_dict={'F3':50,'B3':50,'Fip':50,'Bip':50,'Lf':50,'Bf':50}\n",
        "    if 'F3' in Primer_Name1:\n",
        "        oligo_Conc,dntp_Conc,mg_Conc,Na_Conc=oligo_Conc_dict['F3'],dntp_Conc_dict['F3'],mg_Conc_dict['F3'],Na_Conc_dict['F3']\n",
        "    elif 'B3' in Primer_Name1:\n",
        "        oligo_Conc,dntp_Conc,mg_Conc,Na_Conc=oligo_Conc_dict['B3'],dntp_Conc_dict['B3'],mg_Conc_dict['B3'],Na_Conc_dict['B3']\n",
        "    elif 'FIP' in Primer_Name1:\n",
        "        oligo_Conc,dntp_Conc,mg_Conc,Na_Conc=oligo_Conc_dict['Fip'],dntp_Conc_dict['Fip'],mg_Conc_dict['Fip'],Na_Conc_dict['Fip']\n",
        "    elif 'BIP' in Primer_Name1:\n",
        "        oligo_Conc,dntp_Conc,mg_Conc,Na_Conc=oligo_Conc_dict['Bip'],dntp_Conc_dict['Bip'],mg_Conc_dict['Bip'],Na_Conc_dict['Bip']\n",
        "    elif 'LF' in Primer_Name1:\n",
        "        oligo_Conc,dntp_Conc,mg_Conc,Na_Conc=oligo_Conc_dict['Lf'],dntp_Conc_dict['Lf'],mg_Conc_dict['Lf'],Na_Conc_dict['Lf']\n",
        "    elif 'BF' in Primer_Name1:\n",
        "        oligo_Conc,dntp_Conc,mg_Conc,Na_Conc=oligo_Conc_dict['Bf'],dntp_Conc_dict['Bf'],mg_Conc_dict['Bf'],Na_Conc_dict['Bf']\n",
        "    \n",
        "    #print(oligo_Conc)\n",
        "    NucleotideType=\"DNA\"\n",
        "    data = '{  \"Sequence\": \"' + NEB_df.iloc[i]['Sequence'] + '\",  \"NaConc\": '+  str(Na_Conc)+\\\n",
        "    ',  \"MgConc\": '+  str(mg_Conc)+',   \"dNTPsConc\": '+  str(dntp_Conc)+',  \"OligoConc\": '+  str(oligo_Conc)+\\\n",
        "    ',   \"NucleotideType\": \"DNA\" }'\n",
        "    response = requests.post(\n",
        "        'https://www.idtdna.com/Restapi/v1/OligoAnalyzer/Analyze',\n",
        "        headers=headers,\n",
        "        data=data)\n",
        "    json_data = json.loads(response.text)\n",
        "    Primer_Name.append(Sequence_dict[json_data['Sequence'].replace(\" \", '')])\n",
        "    Sequence.append(json_data['Sequence'])\n",
        "    Complement.append(json_data['Complement'])\n",
        "    length.append(json_data['Length'])\n",
        "    GCContent.append(json_data['GCContent'])\n",
        "    MeltTemp.append(json_data['MeltTemp'])\n",
        "    NmoleOD.append(json_data['NmoleOD'])\n",
        "    OligoConc_list.append(json_data['OligoConc'])\n",
        "    MgConc_list.append(mg_Conc)\n",
        "    NaConc_list.append(Na_Conc)\n",
        "    dNTPsConc_list.append(dntp_Conc)\n",
        "    NucleotideType_list.append(NucleotideType)\n",
        "\n",
        "    \n",
        "    \n",
        "    \n",
        "#     if count==2:\n",
        "#         break\n",
        "#     count=count+1\n",
        "\n",
        "\n",
        "df1=pd.DataFrame({\"Primer Name\":Primer_Name, \"Sequence\":Sequence,\"Complement\":Complement,\"OligoConc\":OligoConc_list,\"Na+ Conc\":NaConc_list,\\\n",
        "                  \"Mg++ Conc\":MgConc_list,\"dNTPs Conc\":dNTPsConc_list,\"Nucleotide Type\":NucleotideType_list,\"length\":length,\"GCContent\":GCContent,\"MeltTemp\":MeltTemp,\"NmoleOD\":NmoleOD,})\n",
        "\n",
        "df1"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!mkdir \"Output Data NEB Analysis\""
      ],
      "metadata": {
        "id": "By2pxijbRVQR"
      },
      "id": "By2pxijbRVQR",
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "id": "0d57d191",
      "metadata": {
        "id": "0d57d191"
      },
      "outputs": [],
      "source": [
        "df1.to_excel('Output Data NEB Analysis/Neb_Analysis.xlsx', index=False)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "78f23fc5",
      "metadata": {
        "id": "78f23fc5"
      },
      "source": [
        "## POST /v1/OligoAnalyzer/Hairpin"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 9,
      "id": "ee97a73a",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 631
        },
        "id": "ee97a73a",
        "outputId": "c6036a3f-8967-40ae-e0c2-98a50fe1dd55"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "100%|██████████| 18/18 [00:11<00:00,  1.60it/s]\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Primer Name                                      Sequence  Thermo  DeltaG  \\\n",
              "0    Gene-E1-F3                       TGAGTACGAACTTATGTACTCAT    45.9   -3.59   \n",
              "1    Gene-E1-B3                        TTCAGATTTTTAACACGAGAGT    30.9   -0.23   \n",
              "2   Gene-E1-FIP    ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG    42.6   -1.77   \n",
              "3   Gene-E1-BIP  TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT    49.1   -3.46   \n",
              "4    Gene-E1-LF                            CGCTATTAACTATTAACG    15.7    0.67   \n",
              "5    Gene-E1-LB                           GCGCTTCGATTGTGTGCGT    39.4   -1.62   \n",
              "6         N2-F3                         ACCAGGAACTAATCAGACAAG    40.8   -0.39   \n",
              "7         N2-B3                     GACTTGATCTTTGAAATTTGGATCT    29.8   -0.63   \n",
              "8        N2-FIP    TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC    41.5   -3.16   \n",
              "9        N2-BIP      CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA    34.1   -1.08   \n",
              "10        N2-LF                         GGGGGCAAATTGTGCAATTTG    43.1   -2.88   \n",
              "11        N2-LB                          CTTCGGGAACGTGGTTGACC    44.2   -1.46   \n",
              "12      ACTB-F3                            AGTACCCCATCGAGCACG    26.0   -0.07   \n",
              "13      ACTB-B3                          AGCCTGGATAGCAACGTACA    23.6    0.10   \n",
              "14     ACTB-FIP      GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA    41.4   -2.79   \n",
              "15     ACTB-BIP        CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC    63.8   -6.65   \n",
              "16      ACTB-LF                         TGTGGTGCCAGATTTTCTCCA    17.2    0.67   \n",
              "17      ACTB-LB                       CGAGAAGATGACCCAGATCATGT    34.4   -0.82   \n",
              "\n",
              "    DeltaS  DeltaH  \n",
              "0  -172.08   -54.9  \n",
              "1   -38.81   -11.8  \n",
              "2  -100.40   -31.7  \n",
              "3  -143.67   -46.3  \n",
              "4   -72.02   -20.8  \n",
              "5  -112.64   -35.2  \n",
              "6   -24.52    -7.7  \n",
              "7  -130.72   -39.6  \n",
              "8  -191.67   -60.3  \n",
              "9  -118.45   -36.4  \n",
              "10 -159.70   -50.5  \n",
              "11  -75.94   -24.1  \n",
              "12  -68.86   -20.6  \n",
              "13  -73.46   -21.8  \n",
              "14 -170.07   -53.5  \n",
              "15 -171.22   -57.7  \n",
              "16  -85.77   -24.9  \n",
              "17  -86.48   -26.6  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-267c41c6-a89d-4ca2-8b03-3f50fffb2d20\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Primer Name</th>\n",
              "      <th>Sequence</th>\n",
              "      <th>Thermo</th>\n",
              "      <th>DeltaG</th>\n",
              "      <th>DeltaS</th>\n",
              "      <th>DeltaH</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Gene-E1-F3</td>\n",
              "      <td>TGAGTACGAACTTATGTACTCAT</td>\n",
              "      <td>45.9</td>\n",
              "      <td>-3.59</td>\n",
              "      <td>-172.08</td>\n",
              "      <td>-54.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Gene-E1-B3</td>\n",
              "      <td>TTCAGATTTTTAACACGAGAGT</td>\n",
              "      <td>30.9</td>\n",
              "      <td>-0.23</td>\n",
              "      <td>-38.81</td>\n",
              "      <td>-11.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Gene-E1-FIP</td>\n",
              "      <td>ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG</td>\n",
              "      <td>42.6</td>\n",
              "      <td>-1.77</td>\n",
              "      <td>-100.40</td>\n",
              "      <td>-31.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Gene-E1-BIP</td>\n",
              "      <td>TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT</td>\n",
              "      <td>49.1</td>\n",
              "      <td>-3.46</td>\n",
              "      <td>-143.67</td>\n",
              "      <td>-46.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Gene-E1-LF</td>\n",
              "      <td>CGCTATTAACTATTAACG</td>\n",
              "      <td>15.7</td>\n",
              "      <td>0.67</td>\n",
              "      <td>-72.02</td>\n",
              "      <td>-20.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Gene-E1-LB</td>\n",
              "      <td>GCGCTTCGATTGTGTGCGT</td>\n",
              "      <td>39.4</td>\n",
              "      <td>-1.62</td>\n",
              "      <td>-112.64</td>\n",
              "      <td>-35.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>N2-F3</td>\n",
              "      <td>ACCAGGAACTAATCAGACAAG</td>\n",
              "      <td>40.8</td>\n",
              "      <td>-0.39</td>\n",
              "      <td>-24.52</td>\n",
              "      <td>-7.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>N2-B3</td>\n",
              "      <td>GACTTGATCTTTGAAATTTGGATCT</td>\n",
              "      <td>29.8</td>\n",
              "      <td>-0.63</td>\n",
              "      <td>-130.72</td>\n",
              "      <td>-39.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>N2-FIP</td>\n",
              "      <td>TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC</td>\n",
              "      <td>41.5</td>\n",
              "      <td>-3.16</td>\n",
              "      <td>-191.67</td>\n",
              "      <td>-60.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>N2-BIP</td>\n",
              "      <td>CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA</td>\n",
              "      <td>34.1</td>\n",
              "      <td>-1.08</td>\n",
              "      <td>-118.45</td>\n",
              "      <td>-36.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>N2-LF</td>\n",
              "      <td>GGGGGCAAATTGTGCAATTTG</td>\n",
              "      <td>43.1</td>\n",
              "      <td>-2.88</td>\n",
              "      <td>-159.70</td>\n",
              "      <td>-50.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>N2-LB</td>\n",
              "      <td>CTTCGGGAACGTGGTTGACC</td>\n",
              "      <td>44.2</td>\n",
              "      <td>-1.46</td>\n",
              "      <td>-75.94</td>\n",
              "      <td>-24.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>ACTB-F3</td>\n",
              "      <td>AGTACCCCATCGAGCACG</td>\n",
              "      <td>26.0</td>\n",
              "      <td>-0.07</td>\n",
              "      <td>-68.86</td>\n",
              "      <td>-20.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>ACTB-B3</td>\n",
              "      <td>AGCCTGGATAGCAACGTACA</td>\n",
              "      <td>23.6</td>\n",
              "      <td>0.10</td>\n",
              "      <td>-73.46</td>\n",
              "      <td>-21.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>ACTB-FIP</td>\n",
              "      <td>GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA</td>\n",
              "      <td>41.4</td>\n",
              "      <td>-2.79</td>\n",
              "      <td>-170.07</td>\n",
              "      <td>-53.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>ACTB-BIP</td>\n",
              "      <td>CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC</td>\n",
              "      <td>63.8</td>\n",
              "      <td>-6.65</td>\n",
              "      <td>-171.22</td>\n",
              "      <td>-57.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>ACTB-LF</td>\n",
              "      <td>TGTGGTGCCAGATTTTCTCCA</td>\n",
              "      <td>17.2</td>\n",
              "      <td>0.67</td>\n",
              "      <td>-85.77</td>\n",
              "      <td>-24.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>ACTB-LB</td>\n",
              "      <td>CGAGAAGATGACCCAGATCATGT</td>\n",
              "      <td>34.4</td>\n",
              "      <td>-0.82</td>\n",
              "      <td>-86.48</td>\n",
              "      <td>-26.6</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-267c41c6-a89d-4ca2-8b03-3f50fffb2d20')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-267c41c6-a89d-4ca2-8b03-3f50fffb2d20 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-267c41c6-a89d-4ca2-8b03-3f50fffb2d20');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ],
      "source": [
        "headers = {\n",
        "    'Content-Type': 'application/json',\n",
        "    'Accept': 'application/json',\n",
        "    'Authorization': 'Bearer ea47c6eec999b5daa1c4e49f3307dab7',\n",
        "}\n",
        "\n",
        "Primer_Name = []\n",
        "Sequence = []\n",
        "Thermo = []\n",
        "DeltaS = []\n",
        "DeltaG = []\n",
        "DeltaH = []\n",
        "\n",
        "count = 0\n",
        "\n",
        "for i in tqdm(list(NEB_df.Sequence)):\n",
        "    data = '{  \"Sequence\": \"' + i + '\",  \"NaConc\": 50,  \"FoldingTemp\": 37,\\\n",
        "    \"MgConc\": 8, \"NucleotideType\": \"DNA\" }'\n",
        "    response = requests.post(\n",
        "        'https://www.idtdna.com/Restapi/v1/OligoAnalyzer/Hairpin',\n",
        "        headers=headers,\n",
        "        data=data)\n",
        "    json_data = json.loads(response.text)\n",
        "    Primer_Name.append(Sequence_dict[json_data[0]['sequence']])\n",
        "    Sequence.append(json_data[0]['sequence'])\n",
        "    Thermo.append(json_data[0]['thermo'])\n",
        "    DeltaS.append(json_data[0]['deltaS'])\n",
        "    DeltaG.append(json_data[0]['deltaG'])\n",
        "    DeltaH.append(json_data[0]['deltaH'])\n",
        "#     if count==10:\n",
        "#         break\n",
        "#     count=count+1\n",
        "\n",
        "df2 = pd.DataFrame({\n",
        "    \"Primer Name\": Primer_Name,\n",
        "    \"Sequence\": Sequence,\n",
        "    \"Thermo\": Thermo,\n",
        "    \"DeltaG\": DeltaG,\n",
        "    \"DeltaS\": DeltaS,\n",
        "    \"DeltaH\": DeltaH,\n",
        "})\n",
        "\n",
        "df2"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 10,
      "id": "6b9a63ca",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6b9a63ca",
        "outputId": "875c67a8-8736-4a12-9b7e-ef3369136662"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[{'RNA': False,\n",
              "  'deltaG': -0.82,\n",
              "  'deltaH': -26.6,\n",
              "  'deltaS': -86.48,\n",
              "  'errorMessages': [],\n",
              "  'id': 'af563d16-d485-4165-9b27-8fb2dad89c04',\n",
              "  'sequence': 'CGAGAAGATGACCCAGATCATGT',\n",
              "  'success': True,\n",
              "  'thermo': 34.4}]"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ],
      "source": [
        "json_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "id": "13b2b5d1",
      "metadata": {
        "id": "13b2b5d1"
      },
      "outputs": [],
      "source": [
        "df2.to_excel('Output Data NEB Analysis/Neb_HairPins.xlsx', index=False)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "1feb65c4",
      "metadata": {
        "id": "1feb65c4"
      },
      "source": [
        "## POST /v1/OligoAnalyzer/SelfDimer"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "id": "a5911d2f",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "a5911d2f",
        "outputId": "1910bd6e-86d4-42fc-f3cc-4e5d6824bd12"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "100%|██████████| 18/18 [00:10<00:00,  1.73it/s]"
          ]
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "CPU times: user 442 ms, sys: 34.9 ms, total: 477 ms\n",
            "Wall time: 10.4 s\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "\n"
          ]
        }
      ],
      "source": [
        "%%time\n",
        "headers = {\n",
        "    'Accept': 'application/json',\n",
        "    'Authorization': 'Bearer ' + 'ea47c6eec999b5daa1c4e49f3307dab7',\n",
        "}\n",
        "Primer_Name = []\n",
        "Sequence_Bonds = []\n",
        "Sequence_Sequences = []\n",
        "Sequence_DeltaG = []\n",
        "Sequence_BasePairs = []\n",
        "Sequence_Dimer = []\n",
        "Sequence_SequencePair = []\n",
        "count = 1\n",
        "for i in tqdm(list(NEB_df.Sequence)):\n",
        "    #     print(str(i))\n",
        "    params = {\n",
        "        'primary': str(i),\n",
        "    }\n",
        "    temp = 1\n",
        "    response = requests.post(\n",
        "        'https://www.idtdna.com/Restapi/v1/OligoAnalyzer/SelfDimer',\n",
        "        params=params,\n",
        "        headers=headers)\n",
        "    json_data_Sequence = json.loads(response.text)\n",
        "    Primer_Name.append(Sequence_dict[i])\n",
        "    Sequence_Sequences.append(i)\n",
        "    Sequence_DeltaG.append(json_data_Sequence[0]['DeltaG'])\n",
        "    Sequence_BasePairs.append(json_data_Sequence[0]['BasePairs'])\n",
        "    Sequence_Dimer.append(json_data_Sequence[0]['Dimer'])\n",
        "    Sequence_Bonds.append(json_data_Sequence[0]['Bonds'])\n",
        "    Sequence_SequencePair.append(temp)\n",
        "    temp = temp + 1\n",
        "    Sequence_Sequences.append(i)\n",
        "    Primer_Name.append(Sequence_dict[i])\n",
        "    Sequence_DeltaG.append(json_data_Sequence[1]['DeltaG'])\n",
        "    Sequence_BasePairs.append(json_data_Sequence[1]['BasePairs'])\n",
        "    Sequence_Dimer.append(json_data_Sequence[1]['Dimer'])\n",
        "    Sequence_Bonds.append(json_data_Sequence[1]['Bonds'])\n",
        "    Sequence_SequencePair.append(temp)\n",
        "    temp = 1\n",
        "#     if count==10:\n",
        "#         break\n",
        "#     count=count+1\n",
        "\n",
        "\n",
        "\n",
        "df3=pd.DataFrame({\"Primer Name\":Primer_Name,'Sequence Pair Number':Sequence_SequencePair,'Sequence':Sequence_Sequences,'DeltaG':Sequence_DeltaG,\\\n",
        "                  'BasePairs':Sequence_BasePairs,'Dimer':Sequence_Dimer,'Bonds':Sequence_Bonds,})\n",
        "df3"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 13,
      "id": "432504f1",
      "metadata": {
        "id": "432504f1"
      },
      "outputs": [],
      "source": [
        "df3.to_excel('Output Data NEB Analysis/Neb_SelfDimers.xlsx', index=False)"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "6cf37005",
      "metadata": {
        "id": "6cf37005"
      },
      "source": [
        "## POST /v1/OligoAnalyzer/HeteroDimer"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "id": "4c4481bf",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 614
        },
        "id": "4c4481bf",
        "outputId": "ae97e474-a3ad-4c25-c23a-56e40e4f4ab2"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Primer name                                      Sequence Synthesis scale\n",
              "0    Gene-E1-F3                       TGAGTACGAACTTATGTACTCAT           10 nm\n",
              "1    Gene-E1-B3                        TTCAGATTTTTAACACGAGAGT           10 nm\n",
              "2   Gene-E1-FIP    ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG           10 nm\n",
              "3   Gene-E1-BIP  TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT           10 nm\n",
              "4    Gene-E1-LF                            CGCTATTAACTATTAACG           10 nm\n",
              "5    Gene-E1-LB                           GCGCTTCGATTGTGTGCGT           10 nm\n",
              "6         N2-F3                         ACCAGGAACTAATCAGACAAG           10 nm\n",
              "7         N2-B3                     GACTTGATCTTTGAAATTTGGATCT           10 nm\n",
              "8        N2-FIP    TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC           10 nm\n",
              "9        N2-BIP      CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA           10 nm\n",
              "10        N2-LF                         GGGGGCAAATTGTGCAATTTG           10 nm\n",
              "11        N2-LB                          CTTCGGGAACGTGGTTGACC           10 nm\n",
              "12      ACTB-F3                            AGTACCCCATCGAGCACG           10 nm\n",
              "13      ACTB-B3                          AGCCTGGATAGCAACGTACA           10 nm\n",
              "14     ACTB-FIP      GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA           10 nm\n",
              "15     ACTB-BIP        CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC           10 nm\n",
              "16      ACTB-LF                         TGTGGTGCCAGATTTTCTCCA           10 nm\n",
              "17      ACTB-LB                       CGAGAAGATGACCCAGATCATGT           10 nm"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-13df2b77-da39-46ab-aef5-f5cb85220ad0\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Primer name</th>\n",
              "      <th>Sequence</th>\n",
              "      <th>Synthesis scale</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Gene-E1-F3</td>\n",
              "      <td>TGAGTACGAACTTATGTACTCAT</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Gene-E1-B3</td>\n",
              "      <td>TTCAGATTTTTAACACGAGAGT</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Gene-E1-FIP</td>\n",
              "      <td>ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Gene-E1-BIP</td>\n",
              "      <td>TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Gene-E1-LF</td>\n",
              "      <td>CGCTATTAACTATTAACG</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Gene-E1-LB</td>\n",
              "      <td>GCGCTTCGATTGTGTGCGT</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>N2-F3</td>\n",
              "      <td>ACCAGGAACTAATCAGACAAG</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>N2-B3</td>\n",
              "      <td>GACTTGATCTTTGAAATTTGGATCT</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>N2-FIP</td>\n",
              "      <td>TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>N2-BIP</td>\n",
              "      <td>CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>N2-LF</td>\n",
              "      <td>GGGGGCAAATTGTGCAATTTG</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>N2-LB</td>\n",
              "      <td>CTTCGGGAACGTGGTTGACC</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>ACTB-F3</td>\n",
              "      <td>AGTACCCCATCGAGCACG</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>ACTB-B3</td>\n",
              "      <td>AGCCTGGATAGCAACGTACA</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>ACTB-FIP</td>\n",
              "      <td>GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>ACTB-BIP</td>\n",
              "      <td>CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>ACTB-LF</td>\n",
              "      <td>TGTGGTGCCAGATTTTCTCCA</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>ACTB-LB</td>\n",
              "      <td>CGAGAAGATGACCCAGATCATGT</td>\n",
              "      <td>10 nm</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-13df2b77-da39-46ab-aef5-f5cb85220ad0')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-13df2b77-da39-46ab-aef5-f5cb85220ad0 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-13df2b77-da39-46ab-aef5-f5cb85220ad0');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ],
      "source": [
        "NEB_df"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 15,
      "id": "0f6cd926",
      "metadata": {
        "id": "0f6cd926"
      },
      "outputs": [],
      "source": [
        "import requests\n",
        "\n",
        "headers = {\n",
        "    'Accept': 'application/json',\n",
        "    'Authorization': 'Bearer ea47c6eec999b5daa1c4e49f3307dab7',\n",
        "}\n",
        "\n",
        "params = {\n",
        "    'primary': 'ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG',\n",
        "    'secondary': 'TTCAGATTTTTAACACGAGAGT',\n",
        "}\n",
        "\n",
        "response = requests.post('https://www.idtdna.com/Restapi/v1/OligoAnalyzer/HeteroDimer', params=params, headers=headers)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 16,
      "id": "54b248df",
      "metadata": {
        "scrolled": true,
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "54b248df",
        "outputId": "94452268-7d11-4e9f-a6f6-e309bfe61e08"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[('TGAGTACGAACTTATGTACTCAT', 'TTCAGATTTTTAACACGAGAGT'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'CGCTATTAACTATTAACG'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'GCGCTTCGATTGTGTGCGT'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'ACCAGGAACTAATCAGACAAG'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'GACTTGATCTTTGAAATTTGGATCT'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'AGTACCCCATCGAGCACG'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('TGAGTACGAACTTATGTACTCAT', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'CGCTATTAACTATTAACG'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'GCGCTTCGATTGTGTGCGT'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'ACCAGGAACTAATCAGACAAG'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'GACTTGATCTTTGAAATTTGGATCT'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'AGTACCCCATCGAGCACG'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('TTCAGATTTTTAACACGAGAGT', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG',\n",
              "  'TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'CGCTATTAACTATTAACG'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'GCGCTTCGATTGTGTGCGT'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'ACCAGGAACTAATCAGACAAG'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'GACTTGATCTTTGAAATTTGGATCT'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG',\n",
              "  'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG',\n",
              "  'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'AGTACCCCATCGAGCACG'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG',\n",
              "  'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG',\n",
              "  'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'CGCTATTAACTATTAACG'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'GCGCTTCGATTGTGTGCGT'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'ACCAGGAACTAATCAGACAAG'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'GACTTGATCTTTGAAATTTGGATCT'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT',\n",
              "  'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT',\n",
              "  'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'AGTACCCCATCGAGCACG'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT',\n",
              "  'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT',\n",
              "  'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('CGCTATTAACTATTAACG', 'GCGCTTCGATTGTGTGCGT'),\n",
              " ('CGCTATTAACTATTAACG', 'ACCAGGAACTAATCAGACAAG'),\n",
              " ('CGCTATTAACTATTAACG', 'GACTTGATCTTTGAAATTTGGATCT'),\n",
              " ('CGCTATTAACTATTAACG', 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('CGCTATTAACTATTAACG', 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('CGCTATTAACTATTAACG', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('CGCTATTAACTATTAACG', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('CGCTATTAACTATTAACG', 'AGTACCCCATCGAGCACG'),\n",
              " ('CGCTATTAACTATTAACG', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('CGCTATTAACTATTAACG', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('CGCTATTAACTATTAACG', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('CGCTATTAACTATTAACG', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('CGCTATTAACTATTAACG', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'ACCAGGAACTAATCAGACAAG'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'GACTTGATCTTTGAAATTTGGATCT'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'AGTACCCCATCGAGCACG'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('GCGCTTCGATTGTGTGCGT', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'GACTTGATCTTTGAAATTTGGATCT'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'AGTACCCCATCGAGCACG'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('ACCAGGAACTAATCAGACAAG', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'AGTACCCCATCGAGCACG'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('GACTTGATCTTTGAAATTTGGATCT', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC',\n",
              "  'CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC', 'AGTACCCCATCGAGCACG'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC',\n",
              "  'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC',\n",
              "  'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('TTCCGAAGAACGCTGAAGCGGAACTGATTACAAACATTGGCC', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA', 'GGGGGCAAATTGTGCAATTTG'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA', 'AGTACCCCATCGAGCACG'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA',\n",
              "  'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA',\n",
              "  'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('CGCATTGGCATGGAAGTCACAATTTGATGGCACCTGTGTA', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('GGGGGCAAATTGTGCAATTTG', 'CTTCGGGAACGTGGTTGACC'),\n",
              " ('GGGGGCAAATTGTGCAATTTG', 'AGTACCCCATCGAGCACG'),\n",
              " ('GGGGGCAAATTGTGCAATTTG', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('GGGGGCAAATTGTGCAATTTG', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('GGGGGCAAATTGTGCAATTTG', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('GGGGGCAAATTGTGCAATTTG', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('GGGGGCAAATTGTGCAATTTG', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('CTTCGGGAACGTGGTTGACC', 'AGTACCCCATCGAGCACG'),\n",
              " ('CTTCGGGAACGTGGTTGACC', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('CTTCGGGAACGTGGTTGACC', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('CTTCGGGAACGTGGTTGACC', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('CTTCGGGAACGTGGTTGACC', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('CTTCGGGAACGTGGTTGACC', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('AGTACCCCATCGAGCACG', 'AGCCTGGATAGCAACGTACA'),\n",
              " ('AGTACCCCATCGAGCACG', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('AGTACCCCATCGAGCACG', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('AGTACCCCATCGAGCACG', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('AGTACCCCATCGAGCACG', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('AGCCTGGATAGCAACGTACA', 'GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA'),\n",
              " ('AGCCTGGATAGCAACGTACA', 'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('AGCCTGGATAGCAACGTACA', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('AGCCTGGATAGCAACGTACA', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA',\n",
              "  'CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC'),\n",
              " ('GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('GAGCCACACGCAGCTCATTGTATCACCAACTGGGACGACA', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC', 'TGTGGTGCCAGATTTTCTCCA'),\n",
              " ('CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC', 'CGAGAAGATGACCCAGATCATGT'),\n",
              " ('TGTGGTGCCAGATTTTCTCCA', 'CGAGAAGATGACCCAGATCATGT')]"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ],
      "source": [
        "def SequencePairs(arr, n):\n",
        "    a=[]\n",
        "    for i in range(n):\n",
        "        for j in range(n):\n",
        "            #print(\"(\",arr[i],\",\",arr[j],\")\",end=\"\\n\\n\")\n",
        "            a.append((arr[i],arr[j]))    \n",
        "    return a\n",
        " \n",
        "list_NEB_SEQUENCE=NEB_df.Sequence\n",
        "n = len(list_NEB_SEQUENCE)\n",
        " \n",
        "SequencePairs_list = SequencePairs(list_NEB_SEQUENCE, n)\n",
        "\n",
        "\n",
        "for i in SequencePairs_list:\n",
        "    if i[0]==i[1]:\n",
        "        SequencePairs_list.remove(i)\n",
        "        \n",
        "        \n",
        "for i in SequencePairs_list:\n",
        "    if (i[0],i[1]) in SequencePairs_list and (i[1],i[0]) in SequencePairs_list:\n",
        "        SequencePairs_list.remove((i[1],i[0]))\n",
        "        \n",
        "SequencePairs_list"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 17,
      "id": "e327b9d1",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "e327b9d1",
        "outputId": "53e2d766-8c3a-4015-d0b7-28bad6b2c767"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'BasePairs': 5,\n",
              " 'BondLinePadding': 3,\n",
              " 'Bonds': [1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 2, 2, 2, 2, 2, 0, 0, 0, 1, 0, 0],\n",
              " 'BottomLinePadding': 3,\n",
              " 'DeltaG': -7.78,\n",
              " 'Dimer': None,\n",
              " 'StartPosition': 0,\n",
              " 'TopLinePadding': 0}"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ],
      "source": [
        "json_data_Sequence = json.loads(response.text)\n",
        "json_data_Sequence[0]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 18,
      "id": "230641ad",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "230641ad",
        "outputId": "6362ce77-e9a3-42d9-e488-038346ed85e8"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "100%|██████████| 153/153 [01:20<00:00,  1.91it/s]\n"
          ]
        }
      ],
      "source": [
        "headers = {\n",
        "    'Accept': 'application/json',\n",
        "    'Authorization': 'Bearer ea47c6eec999b5daa1c4e49f3307dab7',\n",
        "}\n",
        "\n",
        "Sequence_Name1 = []\n",
        "Sequence_Name2 = []\n",
        "Sequence_Bonds = []\n",
        "Sequence_Sequences1 = []\n",
        "Sequence_Sequences2 = []\n",
        "Sequence_DeltaG = []\n",
        "Sequence_BasePairs = []\n",
        "Sequence_Dimer = []\n",
        "Sequence_SequencePair = []\n",
        "count = 1\n",
        "for i in tqdm(SequencePairs_list):\n",
        "    temp=0\n",
        "    params = {\n",
        "        'primary': i[0],\n",
        "        'secondary': i[1],}\n",
        "    response = requests.post('https://www.idtdna.com/Restapi/v1/OligoAnalyzer/HeteroDimer', params=params, headers=headers)\n",
        "\n",
        "    json_data_Sequence = json.loads(response.text)\n",
        "    \n",
        "    Sequence_Name1.append(Sequence_dict[i[0]])\n",
        "    Sequence_Name2.append(Sequence_dict[i[1]])\n",
        "    Sequence_Sequences1.append(i[0])\n",
        "    Sequence_Sequences2.append(i[1])\n",
        "    Sequence_DeltaG.append(json_data_Sequence[0]['DeltaG'])\n",
        "    Sequence_BasePairs.append(json_data_Sequence[0]['BasePairs'])\n",
        "    Sequence_Dimer.append(json_data_Sequence[0]['Dimer'])\n",
        "    Sequence_Bonds.append(json_data_Sequence[0]['Bonds'])\n",
        "    Sequence_SequencePair.append(temp)\n",
        "    temp = temp + 1\n",
        "    Sequence_Name1.append(Sequence_dict[i[0]])\n",
        "    Sequence_Name2.append(Sequence_dict[i[1]])\n",
        "    Sequence_Sequences1.append(i[0])\n",
        "    Sequence_Sequences2.append(i[1])\n",
        "    Sequence_DeltaG.append(json_data_Sequence[1]['DeltaG'])\n",
        "    Sequence_BasePairs.append(json_data_Sequence[1]['BasePairs'])\n",
        "    Sequence_Dimer.append(json_data_Sequence[1]['Dimer'])\n",
        "    Sequence_Bonds.append(json_data_Sequence[1]['Bonds'])\n",
        "    Sequence_SequencePair.append(temp)\n",
        "    temp = 1\n",
        "#     if count==10:\n",
        "#         break\n",
        "#     count=count+1\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 19,
      "id": "424bbf37",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 850
        },
        "id": "424bbf37",
        "outputId": "cd9a7bbf-45ca-4c18-e629-bb8e67b125e0"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Primary Sequence name Secondary Sequence name  Sequence Pair Number  \\\n",
              "0              Gene-E1-F3              Gene-E1-B3                     0   \n",
              "1              Gene-E1-F3              Gene-E1-B3                     1   \n",
              "2              Gene-E1-F3             Gene-E1-FIP                     0   \n",
              "3              Gene-E1-F3             Gene-E1-FIP                     1   \n",
              "4              Gene-E1-F3             Gene-E1-BIP                     0   \n",
              "..                    ...                     ...                   ...   \n",
              "301              ACTB-BIP                 ACTB-LF                     1   \n",
              "302              ACTB-BIP                 ACTB-LB                     0   \n",
              "303              ACTB-BIP                 ACTB-LB                     1   \n",
              "304               ACTB-LF                 ACTB-LB                     0   \n",
              "305               ACTB-LF                 ACTB-LB                     1   \n",
              "\n",
              "                           Primary Sequence  \\\n",
              "0                   TGAGTACGAACTTATGTACTCAT   \n",
              "1                   TGAGTACGAACTTATGTACTCAT   \n",
              "2                   TGAGTACGAACTTATGTACTCAT   \n",
              "3                   TGAGTACGAACTTATGTACTCAT   \n",
              "4                   TGAGTACGAACTTATGTACTCAT   \n",
              "..                                      ...   \n",
              "301  CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC   \n",
              "302  CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC   \n",
              "303  CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC   \n",
              "304                   TGTGGTGCCAGATTTTCTCCA   \n",
              "305                   TGTGGTGCCAGATTTTCTCCA   \n",
              "\n",
              "                               Secondary Sequence  DeltaG  BasePairs Dimer  \\\n",
              "0                          TTCAGATTTTTAACACGAGAGT   -4.52          4  None   \n",
              "1                          TTCAGATTTTTAACACGAGAGT   -3.61          2  None   \n",
              "2      ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG  -13.36          8  None   \n",
              "3      ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG   -7.13          4  None   \n",
              "4    TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT   -6.47          5  None   \n",
              "..                                            ...     ...        ...   ...   \n",
              "301                         TGTGGTGCCAGATTTTCTCCA   -6.21          3  None   \n",
              "302                       CGAGAAGATGACCCAGATCATGT   -9.69          5  None   \n",
              "303                       CGAGAAGATGACCCAGATCATGT   -7.48          4  None   \n",
              "304                       CGAGAAGATGACCCAGATCATGT   -6.69          5  None   \n",
              "305                       CGAGAAGATGACCCAGATCATGT   -5.02          3  None   \n",
              "\n",
              "                                                 Bonds  \n",
              "0    [2, 2, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...  \n",
              "1    [0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 1, 0, 1, 0, 0, ...  \n",
              "2    [0, 0, 0, 0, 0, 2, 2, 2, 2, 2, 2, 2, 2, 0, 1, ...  \n",
              "3    [0, 0, 0, 0, 1, 0, 2, 2, 2, 2, 0, 0, 0, 1, 0, ...  \n",
              "4    [2, 2, 2, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, ...  \n",
              "..                                                 ...  \n",
              "301  [0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 2, 2, 0, ...  \n",
              "302  [0, 0, 1, 0, 0, 0, 0, 2, 2, 2, 2, 2, 0, 0, 0, ...  \n",
              "303  [1, 0, 0, 0, 1, 0, 0, 0, 0, 2, 2, 2, 2, 0, 0, ...  \n",
              "304  [1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 2, ...  \n",
              "305  [1, 0, 2, 2, 2, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1, ...  \n",
              "\n",
              "[306 rows x 9 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0273a94d-24db-4627-8ef7-de430308be9d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Primary Sequence name</th>\n",
              "      <th>Secondary Sequence name</th>\n",
              "      <th>Sequence Pair Number</th>\n",
              "      <th>Primary Sequence</th>\n",
              "      <th>Secondary Sequence</th>\n",
              "      <th>DeltaG</th>\n",
              "      <th>BasePairs</th>\n",
              "      <th>Dimer</th>\n",
              "      <th>Bonds</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Gene-E1-F3</td>\n",
              "      <td>Gene-E1-B3</td>\n",
              "      <td>0</td>\n",
              "      <td>TGAGTACGAACTTATGTACTCAT</td>\n",
              "      <td>TTCAGATTTTTAACACGAGAGT</td>\n",
              "      <td>-4.52</td>\n",
              "      <td>4</td>\n",
              "      <td>None</td>\n",
              "      <td>[2, 2, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Gene-E1-F3</td>\n",
              "      <td>Gene-E1-B3</td>\n",
              "      <td>1</td>\n",
              "      <td>TGAGTACGAACTTATGTACTCAT</td>\n",
              "      <td>TTCAGATTTTTAACACGAGAGT</td>\n",
              "      <td>-3.61</td>\n",
              "      <td>2</td>\n",
              "      <td>None</td>\n",
              "      <td>[0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 1, 0, 1, 0, 0, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Gene-E1-F3</td>\n",
              "      <td>Gene-E1-FIP</td>\n",
              "      <td>0</td>\n",
              "      <td>TGAGTACGAACTTATGTACTCAT</td>\n",
              "      <td>ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG</td>\n",
              "      <td>-13.36</td>\n",
              "      <td>8</td>\n",
              "      <td>None</td>\n",
              "      <td>[0, 0, 0, 0, 0, 2, 2, 2, 2, 2, 2, 2, 2, 0, 1, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Gene-E1-F3</td>\n",
              "      <td>Gene-E1-FIP</td>\n",
              "      <td>1</td>\n",
              "      <td>TGAGTACGAACTTATGTACTCAT</td>\n",
              "      <td>ACCACGAAAGCAAGAAAAAGAAGTTCGTTTCGGAAGAGACAG</td>\n",
              "      <td>-7.13</td>\n",
              "      <td>4</td>\n",
              "      <td>None</td>\n",
              "      <td>[0, 0, 0, 0, 1, 0, 2, 2, 2, 2, 0, 0, 0, 1, 0, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Gene-E1-F3</td>\n",
              "      <td>Gene-E1-BIP</td>\n",
              "      <td>0</td>\n",
              "      <td>TGAGTACGAACTTATGTACTCAT</td>\n",
              "      <td>TTGCTAGTTACACTAGCCATCCTTAGGTTTTACAAGACTCACGT</td>\n",
              "      <td>-6.47</td>\n",
              "      <td>5</td>\n",
              "      <td>None</td>\n",
              "      <td>[2, 2, 2, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>301</th>\n",
              "      <td>ACTB-BIP</td>\n",
              "      <td>ACTB-LF</td>\n",
              "      <td>1</td>\n",
              "      <td>CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC</td>\n",
              "      <td>TGTGGTGCCAGATTTTCTCCA</td>\n",
              "      <td>-6.21</td>\n",
              "      <td>3</td>\n",
              "      <td>None</td>\n",
              "      <td>[0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 2, 2, 0, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>302</th>\n",
              "      <td>ACTB-BIP</td>\n",
              "      <td>ACTB-LB</td>\n",
              "      <td>0</td>\n",
              "      <td>CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC</td>\n",
              "      <td>CGAGAAGATGACCCAGATCATGT</td>\n",
              "      <td>-9.69</td>\n",
              "      <td>5</td>\n",
              "      <td>None</td>\n",
              "      <td>[0, 0, 1, 0, 0, 0, 0, 2, 2, 2, 2, 2, 0, 0, 0, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>303</th>\n",
              "      <td>ACTB-BIP</td>\n",
              "      <td>ACTB-LB</td>\n",
              "      <td>1</td>\n",
              "      <td>CTGAACCCCAAGGCCAACCGGCTGGGGTGTTGAAGGTC</td>\n",
              "      <td>CGAGAAGATGACCCAGATCATGT</td>\n",
              "      <td>-7.48</td>\n",
              "      <td>4</td>\n",
              "      <td>None</td>\n",
              "      <td>[1, 0, 0, 0, 1, 0, 0, 0, 0, 2, 2, 2, 2, 0, 0, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>304</th>\n",
              "      <td>ACTB-LF</td>\n",
              "      <td>ACTB-LB</td>\n",
              "      <td>0</td>\n",
              "      <td>TGTGGTGCCAGATTTTCTCCA</td>\n",
              "      <td>CGAGAAGATGACCCAGATCATGT</td>\n",
              "      <td>-6.69</td>\n",
              "      <td>5</td>\n",
              "      <td>None</td>\n",
              "      <td>[1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 1, 0, 2, ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>305</th>\n",
              "      <td>ACTB-LF</td>\n",
              "      <td>ACTB-LB</td>\n",
              "      <td>1</td>\n",
              "      <td>TGTGGTGCCAGATTTTCTCCA</td>\n",
              "      <td>CGAGAAGATGACCCAGATCATGT</td>\n",
              "      <td>-5.02</td>\n",
              "      <td>3</td>\n",
              "      <td>None</td>\n",
              "      <td>[1, 0, 2, 2, 2, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1, ...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>306 rows × 9 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0273a94d-24db-4627-8ef7-de430308be9d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-0273a94d-24db-4627-8ef7-de430308be9d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-0273a94d-24db-4627-8ef7-de430308be9d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ],
      "source": [
        "\n",
        "df4=pd.DataFrame({'Primary Sequence name':Sequence_Name1,'Secondary Sequence name':Sequence_Name2,\\\n",
        "                  'Sequence Pair Number':Sequence_SequencePair,'Primary Sequence':Sequence_Sequences1,\\\n",
        "                  'Secondary Sequence':Sequence_Sequences2,'DeltaG':Sequence_DeltaG,\\\n",
        "                  'BasePairs':Sequence_BasePairs,'Dimer':Sequence_Dimer,'Bonds':Sequence_Bonds,})\n",
        "df4"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 20,
      "id": "871ab1ae",
      "metadata": {
        "id": "871ab1ae"
      },
      "outputs": [],
      "source": [
        "df4.to_excel('Output Data NEB Analysis/Neb_HETRO_Dimers.xlsx', index=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 20,
      "id": "22e2c332",
      "metadata": {
        "id": "22e2c332"
      },
      "outputs": [],
      "source": [
        ""
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "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.8.8"
    },
    "colab": {
      "name": "NEB Primer Sequence Analysis 18-05-2022.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}