DataAnalysisBioCreativeMutationResults.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "input_file=\"/Users/aeg/Downloads/biocreativepredictions/predicted.json\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import logging"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "logging.basicConfig(level=logging.INFO)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_colwidth', 10000)\n",
    "pd.set_option('display.max_rows', 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_json(input_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>participant2</th>\n",
       "      <th>id</th>\n",
       "      <th>abstract</th>\n",
       "      <th>participant1</th>\n",
       "      <th>docid</th>\n",
       "      <th>isValid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>29216</td>\n",
       "      <td>21325834#24784#29216</td>\n",
       "      <td>59114 (59114) PDZ scaffold binds an internal binding site in the scavenger receptor 29216.. The scavenger receptor 29216 binds to albumin in the microvilli of the renal proximal tubule, and transports the ligand to the intravillar cleft for processing by endocytosis. . Albumin endocytosis in the proximal tubule is regulated by protein\\n        complexes containing a number of transmembrane and accessory proteins including PDZ scaffolds such as 59114 and 116501. . PDZ scaffold proteins bind to class I PDZ binding motifs (S/T-X- ) in the extreme C-terminus of targets. . 29216 contains a\\n        functional PDZ binding motif (SDV) in its distal terminus, however a potential interaction with the NHERF proteins has not been investigated. . As 29216 associates with 24784 in the microvilli and 24784 is tethered to the intravillar cleft via its\\n        interaction with 59114, we investigated if there is a direct interaction between 29216 and 59114 in renal proximal tubule cells. . Using confocal microscopy we determined that 29216 and 59114 co-localise in the apical region in proximal tubule\\n        cells. . Immunoprecipitation experiments performed using rat kidney lysate indicated that 29216 bound 59114 in vivo. . Using fusion proteins and peptides, we determined that PDZ2 of 59114 bound to 29216 and that this interaction was via the\\n        C-terminus of 29216 directly and in the absence of any accessory protein. . We next investigated which domain in 29216 was regulating this interaction. . Using GST fusion proteins we determined that the loss of the most distal C-terminus of 29216\\n        containing the PDZ binding motif (SDV) did not alter its ability to bind to 59114. . Significantly, we then identified an internal NHERF binding domain in the C-terminus of 29216. . Using peptide studies we were able to demonstrate that 59114 bound\\n        to an internal PDZ binding motif in 29216 and that a loss of a single threonine residue abolished the interaction between 29216 and 59114. . Finally, in proximal tubule cells, silencing 59114 increased 29216 expression. . Therefore, we have\\n        identified a novel protein interaction in proximal tubule cells and specifically identified a new internal PDZ binding motif in the C-terminus of 29216.</td>\n",
       "      <td>24784</td>\n",
       "      <td>21325834</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000</th>\n",
       "      <td>7157</td>\n",
       "      <td>28049826#4627#7157</td>\n",
       "      <td>4627 binds to lncRNA gene 101928337 and regulates 2304 in the 9q22 thyroid cancer risk locus.. A locus on chromosome 9q22 harbors a SNP (rs965513) firmly associated with risk of papillary thyroid carcinoma (PTC). . The locus also comprises the 2304 (2304) gene, which is implicated in thyroid development, and a long noncoding\\n        RNA (lncRNA) gene, 101928337 (101928337). . How these might interact is not known. . Here we report that 101928337 binds 4627 (4627). . In a bidirectional promoter shared by 2304 and 101928337, 4627 inhibits the\\n        promoter activity in both directions. . This inhibition can be reversed by 101928337, which acts as a suppressor. . RNA knockdown of 2304 in primary thyroid cells profoundly interferes with the 7157 pathway. . We propose that the interaction between the\\n        lncRNA, its binding protein 4627, and the coding gene 2304 underlies the predisposition to PTC triggered by rs965513.</td>\n",
       "      <td>4627</td>\n",
       "      <td>28049826</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10000</th>\n",
       "      <td>12983</td>\n",
       "      <td>16007196#5879#12983</td>\n",
       "      <td>The interaction between 3791 and 3562 receptor (3563) beta common modulates tumor neovascularization.. As 7422 (7422), 3562 (3562), released into the tumor microenvironment stimulates motogenic and mitogenic activity of normal and transformed cells. . In the present study, we investigate the effects of 3562\\n        and 7422 on neoplastic vascular growth. . Engagement of 3562 receptor beta common (12983 c) contributes to both 3562- and 7422-induced 5879 activation, cell migration and in vitro tube-like structure formation as shown by the expression of the\\n        dominant-negative 12983 c construct (Delta455). . In normal and transformed endothelial cells (EC) as well as in HEK 293 cells expressing 3791 and 3563, 7422 and 3562 treatment induces the formation of a 3791/12983 c complex. . Moreover, as\\n        shown by the 3563 Delta455 mutant or by the kinase dead 3791, functional receptors are required for this interaction. . Consistent with the contribution of 12983 c in both 3562- and 7422-mediated angiogenic signal, a reduced number of vessels\\n        inside tumors are found in mice injected with cells expressing the 3563 Delta455 mutant. . Thus, these findings provide a novel mechanism through which 3562 and 7422 support cell survival and tumor neovascularization.</td>\n",
       "      <td>5879</td>\n",
       "      <td>16007196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10001</th>\n",
       "      <td>3562</td>\n",
       "      <td>16007196#5879#3562</td>\n",
       "      <td>The interaction between 3791 and 3562 receptor (3563) beta common modulates tumor neovascularization.. As 7422 (7422), 3562 (3562), released into the tumor microenvironment stimulates motogenic and mitogenic activity of normal and transformed cells. . In the present study, we investigate the effects of 3562\\n        and 7422 on neoplastic vascular growth. . Engagement of 3562 receptor beta common (12983 c) contributes to both 3562- and 7422-induced 5879 activation, cell migration and in vitro tube-like structure formation as shown by the expression of the\\n        dominant-negative 12983 c construct (Delta455). . In normal and transformed endothelial cells (EC) as well as in HEK 293 cells expressing 3791 and 3563, 7422 and 3562 treatment induces the formation of a 3791/12983 c complex. . Moreover, as\\n        shown by the 3563 Delta455 mutant or by the kinase dead 3791, functional receptors are required for this interaction. . Consistent with the contribution of 12983 c in both 3562- and 7422-mediated angiogenic signal, a reduced number of vessels\\n        inside tumors are found in mice injected with cells expressing the 3563 Delta455 mutant. . Thus, these findings provide a novel mechanism through which 3562 and 7422 support cell survival and tumor neovascularization.</td>\n",
       "      <td>5879</td>\n",
       "      <td>16007196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10003</th>\n",
       "      <td>3562</td>\n",
       "      <td>16007196#12983#3562</td>\n",
       "      <td>The interaction between 3791 and 3562 receptor (3563) beta common modulates tumor neovascularization.. As 7422 (7422), 3562 (3562), released into the tumor microenvironment stimulates motogenic and mitogenic activity of normal and transformed cells. . In the present study, we investigate the effects of 3562\\n        and 7422 on neoplastic vascular growth. . Engagement of 3562 receptor beta common (12983 c) contributes to both 3562- and 7422-induced 5879 activation, cell migration and in vitro tube-like structure formation as shown by the expression of the\\n        dominant-negative 12983 c construct (Delta455). . In normal and transformed endothelial cells (EC) as well as in HEK 293 cells expressing 3791 and 3563, 7422 and 3562 treatment induces the formation of a 3791/12983 c complex. . Moreover, as\\n        shown by the 3563 Delta455 mutant or by the kinase dead 3791, functional receptors are required for this interaction. . Consistent with the contribution of 12983 c in both 3562- and 7422-mediated angiogenic signal, a reduced number of vessels\\n        inside tumors are found in mice injected with cells expressing the 3563 Delta455 mutant. . Thus, these findings provide a novel mechanism through which 3562 and 7422 support cell survival and tumor neovascularization.</td>\n",
       "      <td>12983</td>\n",
       "      <td>16007196</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10007</th>\n",
       "      <td>5524</td>\n",
       "      <td>26393783#57650#5524</td>\n",
       "      <td>3D model for 57650 armadillo domain unveils highly conserved protein-protein interaction characteristics.. 57650 (57650) is a human oncoprotein, which exerts its cancer-promoting function through interaction with other proteins, for example Protein Phosphatase 2A (5524) and MYC. . The lack of structural\\n        information for 57650 significantly prevents the design of anti-cancer therapeutics targeting this protein. . In an attempt to counteract this fact, we modeled the three-dimensional structure of the N-terminal domain (57650-ArmRP), analyzed key areas\\n        and amino acids, and coupled the results to the existing literature. . The model reliably shows a stable armadillo repeat fold with a positively charged groove. . The fact that this conserved groove highly likely binds peptides is corroborated by the\\n        presence of a conserved polar ladder, which is essential for the proper peptide-binding mode of armadillo repeat proteins and, according to our results, several known 57650 interaction partners appropriately possess an ArmRP-binding consensus motif.\\n        . Moreover, we show that Arg229Gln, which has been linked to the development of cancer, causes a significant change in charge and surface properties of 57650-ArmRP. . In conclusion, our results reveal that 57650-ArmRP shares the typical fold,\\n        protein-protein interaction site and interaction patterns with other natural armadillo proteins and that, presumably, several interaction partners bind into the central groove of the modeled 57650-ArmRP. . By providing essential structural\\n        characteristics of 57650, the present study significantly increases our knowledge on how 57650 interacts with other proteins in cancer progression and how to develop new therapeutics targeting 57650.</td>\n",
       "      <td>57650</td>\n",
       "      <td>26393783</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>2304</td>\n",
       "      <td>28049826#4627#2304</td>\n",
       "      <td>4627 binds to lncRNA gene 101928337 and regulates 2304 in the 9q22 thyroid cancer risk locus.. A locus on chromosome 9q22 harbors a SNP (rs965513) firmly associated with risk of papillary thyroid carcinoma (PTC). . The locus also comprises the 2304 (2304) gene, which is implicated in thyroid development, and a long noncoding\\n        RNA (lncRNA) gene, 101928337 (101928337). . How these might interact is not known. . Here we report that 101928337 binds 4627 (4627). . In a bidirectional promoter shared by 2304 and 101928337, 4627 inhibits the\\n        promoter activity in both directions. . This inhibition can be reversed by 101928337, which acts as a suppressor. . RNA knockdown of 2304 in primary thyroid cells profoundly interferes with the 7157 pathway. . We propose that the interaction between the\\n        lncRNA, its binding protein 4627, and the coding gene 2304 underlies the predisposition to PTC triggered by rs965513.</td>\n",
       "      <td>4627</td>\n",
       "      <td>28049826</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10010</th>\n",
       "      <td>6261</td>\n",
       "      <td>18201104#801#6261</td>\n",
       "      <td>Different conformational switches underlie the 801-dependent modulation of calcium pumps and channels.. We have used fluorescence spectroscopy to investigate the structure of 801 (801) bound with 801-binding sequences of either the plasma membrane Ca-ATPase or the 6261 (6261) calcium release channel. . Following\\n        derivatization with N-(1-pyrene)maleimide at engineered sites (T34C and T110C) within the N- and C-domains of 801, contact interactions between these opposing domains of 801 resulted in excimer fluorescence that permits us to monitor conformational\\n        states of bound 801. . Complementary measurements take advantage of the unique conserved Trp within 801-binding sequences that functions as a hydrophobic anchor in 801 binding and permits measurements of both a local and global peptide structure. . We\\n        find that 801 binds with high affinity in a collapsed structure to the 801-binding sequences of both the Ca-ATPase and 6261, resulting in excimer formation that is indicative of contact interactions between the N- and the C-domains of 801 in complex\\n        with these 801-binding peptides. . There is a 4-fold larger amount of excimer formation for 801 bound to the 801-binding sequence of the Ca-ATPase in comparison to 6261, indicating a closer structural coupling between 801 domains in this complex. . Prior\\n        to 801 association, the 801-binding sequences of the Ca-ATPase and 6261 are conformationally disordered. . Upon 801 association, the 801-binding sequence of the Ca-ATPase assumes a highly ordered structure. . In comparison, the 801-binding sequence of\\n        6261 remains conformationally disordered irrespective of 801 binding. . These results suggest an important role for interdomain contact interactions between the opposing domains of 801 in stabilizing the structure of the peptide complex. . The\\n        substantially different structural responses associated with 801 binding to Ca-ATPase and 6261 indicates a plasticity in their respective binding mechanisms that accomplishes different physical mechanisms of allosteric regulation, involving either\\n        the dissociation of a C-terminal regulatory domain necessary for pump activation or the modulation of intersubunit interactions to diminish 6261 channel activity.</td>\n",
       "      <td>801</td>\n",
       "      <td>18201104</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10013</th>\n",
       "      <td>6622</td>\n",
       "      <td>16365047#5300#6622</td>\n",
       "      <td>Prolyl-isomerase 5300 accumulates in lewy bodies of parkinson disease and facilitates formation of 6622 inclusions.. Parkinson disease (PD) is a relatively common neurodegenerative disorder that is characterized by the loss of dopaminergic neurons and by the formation of Lewy bodies (LBs), which are cytoplasmic inclusions containing aggregates of\\n        6622. . Although certain post-translational modifications of 6622 and its related proteins are implicated in the genesis of LBs, the specific molecular mechanisms that both regulate these processes and initiate subsequent\\n        inclusion body formation are not yet well understood. . We demonstrate in our current study, however, that the prolyl-isomerase 5300 localizes to the LBs in PD brain tissue and thereby enhances the formation of 6622 immunoreactive\\n        inclusions. . Immunohistochemical analysis of brain tissue from PD patients revealed that 5300 localizes to 50-60% of the LBs that show an intense halo pattern resembling that of 6622. . By utilizing a cellular model of 6622\\n        aggregation, we also demonstrate that, whereas 5300 overexpression facilitates the formation of 6622 inclusions, dominant-negative 5300 expression significantly suppresses this process. . Consistent with these observations, 5300\\n        overexpression enhances the protein half-life and insolubility of 6622. . Finally, we show that 5300 binds 9627, an 6622 partner, via its Ser-211-Pro and Ser-215-Pro motifs, and enhances its interaction with\\n        6622, thus likely facilitating the formation of 6622 inclusions. . These results indicate that 5300-mediated prolyl-isomerization plays a pivotal role in a post-translational modification pathway for 6622 aggregation\\n        and in the resultant Lewy body formations in PD.</td>\n",
       "      <td>5300</td>\n",
       "      <td>16365047</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10014</th>\n",
       "      <td>9627</td>\n",
       "      <td>16365047#5300#9627</td>\n",
       "      <td>Prolyl-isomerase 5300 accumulates in lewy bodies of parkinson disease and facilitates formation of 6622 inclusions.. Parkinson disease (PD) is a relatively common neurodegenerative disorder that is characterized by the loss of dopaminergic neurons and by the formation of Lewy bodies (LBs), which are cytoplasmic inclusions containing aggregates of\\n        6622. . Although certain post-translational modifications of 6622 and its related proteins are implicated in the genesis of LBs, the specific molecular mechanisms that both regulate these processes and initiate subsequent\\n        inclusion body formation are not yet well understood. . We demonstrate in our current study, however, that the prolyl-isomerase 5300 localizes to the LBs in PD brain tissue and thereby enhances the formation of 6622 immunoreactive\\n        inclusions. . Immunohistochemical analysis of brain tissue from PD patients revealed that 5300 localizes to 50-60% of the LBs that show an intense halo pattern resembling that of 6622. . By utilizing a cellular model of 6622\\n        aggregation, we also demonstrate that, whereas 5300 overexpression facilitates the formation of 6622 inclusions, dominant-negative 5300 expression significantly suppresses this process. . Consistent with these observations, 5300\\n        overexpression enhances the protein half-life and insolubility of 6622. . Finally, we show that 5300 binds 9627, an 6622 partner, via its Ser-211-Pro and Ser-215-Pro motifs, and enhances its interaction with\\n        6622, thus likely facilitating the formation of 6622 inclusions. . These results indicate that 5300-mediated prolyl-isomerization plays a pivotal role in a post-translational modification pathway for 6622 aggregation\\n        and in the resultant Lewy body formations in PD.</td>\n",
       "      <td>5300</td>\n",
       "      <td>16365047</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      participant2                    id  \\\n",
       "1            29216  21325834#24784#29216   \n",
       "1000          7157    28049826#4627#7157   \n",
       "10000        12983   16007196#5879#12983   \n",
       "10001         3562    16007196#5879#3562   \n",
       "10003         3562   16007196#12983#3562   \n",
       "10007         5524   26393783#57650#5524   \n",
       "1001          2304    28049826#4627#2304   \n",
       "10010         6261     18201104#801#6261   \n",
       "10013         6622    16365047#5300#6622   \n",
       "10014         9627    16365047#5300#9627   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         abstract  \\\n",
       "1                           59114 (59114) PDZ scaffold binds an internal binding site in the scavenger receptor 29216.. The scavenger receptor 29216 binds to albumin in the microvilli of the renal proximal tubule, and transports the ligand to the intravillar cleft for processing by endocytosis. . Albumin endocytosis in the proximal tubule is regulated by protein\\n        complexes containing a number of transmembrane and accessory proteins including PDZ scaffolds such as 59114 and 116501. . PDZ scaffold proteins bind to class I PDZ binding motifs (S/T-X- ) in the extreme C-terminus of targets. . 29216 contains a\\n        functional PDZ binding motif (SDV) in its distal terminus, however a potential interaction with the NHERF proteins has not been investigated. . As 29216 associates with 24784 in the microvilli and 24784 is tethered to the intravillar cleft via its\\n        interaction with 59114, we investigated if there is a direct interaction between 29216 and 59114 in renal proximal tubule cells. . Using confocal microscopy we determined that 29216 and 59114 co-localise in the apical region in proximal tubule\\n        cells. . Immunoprecipitation experiments performed using rat kidney lysate indicated that 29216 bound 59114 in vivo. . Using fusion proteins and peptides, we determined that PDZ2 of 59114 bound to 29216 and that this interaction was via the\\n        C-terminus of 29216 directly and in the absence of any accessory protein. . We next investigated which domain in 29216 was regulating this interaction. . Using GST fusion proteins we determined that the loss of the most distal C-terminus of 29216\\n        containing the PDZ binding motif (SDV) did not alter its ability to bind to 59114. . Significantly, we then identified an internal NHERF binding domain in the C-terminus of 29216. . Using peptide studies we were able to demonstrate that 59114 bound\\n        to an internal PDZ binding motif in 29216 and that a loss of a single threonine residue abolished the interaction between 29216 and 59114. . Finally, in proximal tubule cells, silencing 59114 increased 29216 expression. . Therefore, we have\\n        identified a novel protein interaction in proximal tubule cells and specifically identified a new internal PDZ binding motif in the C-terminus of 29216.   \n",
       "1000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    4627 binds to lncRNA gene 101928337 and regulates 2304 in the 9q22 thyroid cancer risk locus.. A locus on chromosome 9q22 harbors a SNP (rs965513) firmly associated with risk of papillary thyroid carcinoma (PTC). . The locus also comprises the 2304 (2304) gene, which is implicated in thyroid development, and a long noncoding\\n        RNA (lncRNA) gene, 101928337 (101928337). . How these might interact is not known. . Here we report that 101928337 binds 4627 (4627). . In a bidirectional promoter shared by 2304 and 101928337, 4627 inhibits the\\n        promoter activity in both directions. . This inhibition can be reversed by 101928337, which acts as a suppressor. . RNA knockdown of 2304 in primary thyroid cells profoundly interferes with the 7157 pathway. . We propose that the interaction between the\\n        lncRNA, its binding protein 4627, and the coding gene 2304 underlies the predisposition to PTC triggered by rs965513.   \n",
       "10000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  The interaction between 3791 and 3562 receptor (3563) beta common modulates tumor neovascularization.. As 7422 (7422), 3562 (3562), released into the tumor microenvironment stimulates motogenic and mitogenic activity of normal and transformed cells. . In the present study, we investigate the effects of 3562\\n        and 7422 on neoplastic vascular growth. . Engagement of 3562 receptor beta common (12983 c) contributes to both 3562- and 7422-induced 5879 activation, cell migration and in vitro tube-like structure formation as shown by the expression of the\\n        dominant-negative 12983 c construct (Delta455). . In normal and transformed endothelial cells (EC) as well as in HEK 293 cells expressing 3791 and 3563, 7422 and 3562 treatment induces the formation of a 3791/12983 c complex. . Moreover, as\\n        shown by the 3563 Delta455 mutant or by the kinase dead 3791, functional receptors are required for this interaction. . Consistent with the contribution of 12983 c in both 3562- and 7422-mediated angiogenic signal, a reduced number of vessels\\n        inside tumors are found in mice injected with cells expressing the 3563 Delta455 mutant. . Thus, these findings provide a novel mechanism through which 3562 and 7422 support cell survival and tumor neovascularization.   \n",
       "10001                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  The interaction between 3791 and 3562 receptor (3563) beta common modulates tumor neovascularization.. As 7422 (7422), 3562 (3562), released into the tumor microenvironment stimulates motogenic and mitogenic activity of normal and transformed cells. . In the present study, we investigate the effects of 3562\\n        and 7422 on neoplastic vascular growth. . Engagement of 3562 receptor beta common (12983 c) contributes to both 3562- and 7422-induced 5879 activation, cell migration and in vitro tube-like structure formation as shown by the expression of the\\n        dominant-negative 12983 c construct (Delta455). . In normal and transformed endothelial cells (EC) as well as in HEK 293 cells expressing 3791 and 3563, 7422 and 3562 treatment induces the formation of a 3791/12983 c complex. . Moreover, as\\n        shown by the 3563 Delta455 mutant or by the kinase dead 3791, functional receptors are required for this interaction. . Consistent with the contribution of 12983 c in both 3562- and 7422-mediated angiogenic signal, a reduced number of vessels\\n        inside tumors are found in mice injected with cells expressing the 3563 Delta455 mutant. . Thus, these findings provide a novel mechanism through which 3562 and 7422 support cell survival and tumor neovascularization.   \n",
       "10003                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  The interaction between 3791 and 3562 receptor (3563) beta common modulates tumor neovascularization.. As 7422 (7422), 3562 (3562), released into the tumor microenvironment stimulates motogenic and mitogenic activity of normal and transformed cells. . In the present study, we investigate the effects of 3562\\n        and 7422 on neoplastic vascular growth. . Engagement of 3562 receptor beta common (12983 c) contributes to both 3562- and 7422-induced 5879 activation, cell migration and in vitro tube-like structure formation as shown by the expression of the\\n        dominant-negative 12983 c construct (Delta455). . In normal and transformed endothelial cells (EC) as well as in HEK 293 cells expressing 3791 and 3563, 7422 and 3562 treatment induces the formation of a 3791/12983 c complex. . Moreover, as\\n        shown by the 3563 Delta455 mutant or by the kinase dead 3791, functional receptors are required for this interaction. . Consistent with the contribution of 12983 c in both 3562- and 7422-mediated angiogenic signal, a reduced number of vessels\\n        inside tumors are found in mice injected with cells expressing the 3563 Delta455 mutant. . Thus, these findings provide a novel mechanism through which 3562 and 7422 support cell survival and tumor neovascularization.   \n",
       "10007                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           3D model for 57650 armadillo domain unveils highly conserved protein-protein interaction characteristics.. 57650 (57650) is a human oncoprotein, which exerts its cancer-promoting function through interaction with other proteins, for example Protein Phosphatase 2A (5524) and MYC. . The lack of structural\\n        information for 57650 significantly prevents the design of anti-cancer therapeutics targeting this protein. . In an attempt to counteract this fact, we modeled the three-dimensional structure of the N-terminal domain (57650-ArmRP), analyzed key areas\\n        and amino acids, and coupled the results to the existing literature. . The model reliably shows a stable armadillo repeat fold with a positively charged groove. . The fact that this conserved groove highly likely binds peptides is corroborated by the\\n        presence of a conserved polar ladder, which is essential for the proper peptide-binding mode of armadillo repeat proteins and, according to our results, several known 57650 interaction partners appropriately possess an ArmRP-binding consensus motif.\\n        . Moreover, we show that Arg229Gln, which has been linked to the development of cancer, causes a significant change in charge and surface properties of 57650-ArmRP. . In conclusion, our results reveal that 57650-ArmRP shares the typical fold,\\n        protein-protein interaction site and interaction patterns with other natural armadillo proteins and that, presumably, several interaction partners bind into the central groove of the modeled 57650-ArmRP. . By providing essential structural\\n        characteristics of 57650, the present study significantly increases our knowledge on how 57650 interacts with other proteins in cancer progression and how to develop new therapeutics targeting 57650.   \n",
       "1001                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    4627 binds to lncRNA gene 101928337 and regulates 2304 in the 9q22 thyroid cancer risk locus.. A locus on chromosome 9q22 harbors a SNP (rs965513) firmly associated with risk of papillary thyroid carcinoma (PTC). . The locus also comprises the 2304 (2304) gene, which is implicated in thyroid development, and a long noncoding\\n        RNA (lncRNA) gene, 101928337 (101928337). . How these might interact is not known. . Here we report that 101928337 binds 4627 (4627). . In a bidirectional promoter shared by 2304 and 101928337, 4627 inhibits the\\n        promoter activity in both directions. . This inhibition can be reversed by 101928337, which acts as a suppressor. . RNA knockdown of 2304 in primary thyroid cells profoundly interferes with the 7157 pathway. . We propose that the interaction between the\\n        lncRNA, its binding protein 4627, and the coding gene 2304 underlies the predisposition to PTC triggered by rs965513.   \n",
       "10010  Different conformational switches underlie the 801-dependent modulation of calcium pumps and channels.. We have used fluorescence spectroscopy to investigate the structure of 801 (801) bound with 801-binding sequences of either the plasma membrane Ca-ATPase or the 6261 (6261) calcium release channel. . Following\\n        derivatization with N-(1-pyrene)maleimide at engineered sites (T34C and T110C) within the N- and C-domains of 801, contact interactions between these opposing domains of 801 resulted in excimer fluorescence that permits us to monitor conformational\\n        states of bound 801. . Complementary measurements take advantage of the unique conserved Trp within 801-binding sequences that functions as a hydrophobic anchor in 801 binding and permits measurements of both a local and global peptide structure. . We\\n        find that 801 binds with high affinity in a collapsed structure to the 801-binding sequences of both the Ca-ATPase and 6261, resulting in excimer formation that is indicative of contact interactions between the N- and the C-domains of 801 in complex\\n        with these 801-binding peptides. . There is a 4-fold larger amount of excimer formation for 801 bound to the 801-binding sequence of the Ca-ATPase in comparison to 6261, indicating a closer structural coupling between 801 domains in this complex. . Prior\\n        to 801 association, the 801-binding sequences of the Ca-ATPase and 6261 are conformationally disordered. . Upon 801 association, the 801-binding sequence of the Ca-ATPase assumes a highly ordered structure. . In comparison, the 801-binding sequence of\\n        6261 remains conformationally disordered irrespective of 801 binding. . These results suggest an important role for interdomain contact interactions between the opposing domains of 801 in stabilizing the structure of the peptide complex. . The\\n        substantially different structural responses associated with 801 binding to Ca-ATPase and 6261 indicates a plasticity in their respective binding mechanisms that accomplishes different physical mechanisms of allosteric regulation, involving either\\n        the dissociation of a C-terminal regulatory domain necessary for pump activation or the modulation of intersubunit interactions to diminish 6261 channel activity.   \n",
       "10013                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Prolyl-isomerase 5300 accumulates in lewy bodies of parkinson disease and facilitates formation of 6622 inclusions.. Parkinson disease (PD) is a relatively common neurodegenerative disorder that is characterized by the loss of dopaminergic neurons and by the formation of Lewy bodies (LBs), which are cytoplasmic inclusions containing aggregates of\\n        6622. . Although certain post-translational modifications of 6622 and its related proteins are implicated in the genesis of LBs, the specific molecular mechanisms that both regulate these processes and initiate subsequent\\n        inclusion body formation are not yet well understood. . We demonstrate in our current study, however, that the prolyl-isomerase 5300 localizes to the LBs in PD brain tissue and thereby enhances the formation of 6622 immunoreactive\\n        inclusions. . Immunohistochemical analysis of brain tissue from PD patients revealed that 5300 localizes to 50-60% of the LBs that show an intense halo pattern resembling that of 6622. . By utilizing a cellular model of 6622\\n        aggregation, we also demonstrate that, whereas 5300 overexpression facilitates the formation of 6622 inclusions, dominant-negative 5300 expression significantly suppresses this process. . Consistent with these observations, 5300\\n        overexpression enhances the protein half-life and insolubility of 6622. . Finally, we show that 5300 binds 9627, an 6622 partner, via its Ser-211-Pro and Ser-215-Pro motifs, and enhances its interaction with\\n        6622, thus likely facilitating the formation of 6622 inclusions. . These results indicate that 5300-mediated prolyl-isomerization plays a pivotal role in a post-translational modification pathway for 6622 aggregation\\n        and in the resultant Lewy body formations in PD.   \n",
       "10014                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Prolyl-isomerase 5300 accumulates in lewy bodies of parkinson disease and facilitates formation of 6622 inclusions.. Parkinson disease (PD) is a relatively common neurodegenerative disorder that is characterized by the loss of dopaminergic neurons and by the formation of Lewy bodies (LBs), which are cytoplasmic inclusions containing aggregates of\\n        6622. . Although certain post-translational modifications of 6622 and its related proteins are implicated in the genesis of LBs, the specific molecular mechanisms that both regulate these processes and initiate subsequent\\n        inclusion body formation are not yet well understood. . We demonstrate in our current study, however, that the prolyl-isomerase 5300 localizes to the LBs in PD brain tissue and thereby enhances the formation of 6622 immunoreactive\\n        inclusions. . Immunohistochemical analysis of brain tissue from PD patients revealed that 5300 localizes to 50-60% of the LBs that show an intense halo pattern resembling that of 6622. . By utilizing a cellular model of 6622\\n        aggregation, we also demonstrate that, whereas 5300 overexpression facilitates the formation of 6622 inclusions, dominant-negative 5300 expression significantly suppresses this process. . Consistent with these observations, 5300\\n        overexpression enhances the protein half-life and insolubility of 6622. . Finally, we show that 5300 binds 9627, an 6622 partner, via its Ser-211-Pro and Ser-215-Pro motifs, and enhances its interaction with\\n        6622, thus likely facilitating the formation of 6622 inclusions. . These results indicate that 5300-mediated prolyl-isomerization plays a pivotal role in a post-translational modification pathway for 6622 aggregation\\n        and in the resultant Lewy body formations in PD.   \n",
       "\n",
       "      participant1     docid  isValid  \n",
       "1            24784  21325834        1  \n",
       "1000          4627  28049826        1  \n",
       "10000         5879  16007196        1  \n",
       "10001         5879  16007196        1  \n",
       "10003        12983  16007196        1  \n",
       "10007        57650  26393783        1  \n",
       "1001          4627  28049826        1  \n",
       "10010          801  18201104        1  \n",
       "10013         5300  16365047        1  \n",
       "10014         5300  16365047        1  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(n=10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data Exploration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10211, 6)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAPkAAAD7CAYAAACohzKbAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4wLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvqOYd8AAAHSdJREFUeJzt3XecVOW9x/HPb2cXlt4REOQgYAPBgsaOCoo4em2x9+5NQHOj8Y5JrpLE6InmqrmxJHaDopgiqKMRgyhiKGLD3uCoNOlL2WXrc/84B12WLbO7M/PMOfN7v177Yndm9pzvwn55TpvniDEGpVR0FdgOoJTKLC25UhGnJVcq4rTkSkWcllypiNOSKxVxWvIMEZFJIvK47Ry1iciLInJhmpZ1uIh8WutrT0TGpmPZwfI+FJEj07W8fKYlbwUROUdEForIZhFZEZToMEtZjIhsCbKsFZGZInJm7dcYY8YbYx5LcVlDGnuNMeZ1Y8zurc0drO9REbm5zvKHGWNeTcfy852WvIVE5KfAXcAtwE7ALsC9wEkWY400xnQEdgceBe4WkZvSvRIRKUz3MlUGGWP0o5kfQBdgM3B6I6+ZBDxe6+u/AiuBEmA2MKzWc8cDHwGbgGXAdcHjPYHngQ3AOuB1oKCB9RlgSJ3HfghsBXoEX78KXBZ8PgR4LcizBpgaPD47WNaW4Gc8EzgSWAr8d/AzTN72WK11ecANwc+xHngEKA6euwiYU19e4AqgEqgI1vdcreWNDT5vi/8f6vLg4y6gbfDctmzXAquAFcDFtn9HculDR/KWORgoBp5pxve8CAwFegNvA0/Ueu4h4EpjTCdgOPBK8Pi1+L/AvfC3Fn6OX45UTQcKgQPree43wAygG9Af+COAMeaI4PmRxpiOxpipwdd9gO7AQPxi1udcYBwwGNgN+GVTAY0x9+P/XdwWrO/Eel72C+AgYB9gZPDz1F52H/z/eHcGLgXuEZFuTa07X2jJW6YHsMYYU5XqNxhjHjbGbDLGlOOP8iNFpEvwdCWwl4h0NsasN8a8XevxvsBAY0yl8feDUy65MaYSf5TuXs/TlfiF7WeM2WqMmdPE4mqAm4wx5caYsgZec7cx5htjzDrgt8DZqWZtwrnAr40xq4wxq4FfAefXer4yeL7SGPMC/hZBWo4XRIGWvGXWAj1T3TcVkZiIuCLypYhsxN8UBX9zHOA0/E32r0TkNRE5OHj8duALYIaILBaRRHNCikgR/lbAunqevh4QYEFwJPuSJha32hiztYnXfFPr86+AfimHbVy/YHkNLXttnf9wS4GOaVp36GnJW2YuUA6cnOLrz8E/IDcWf7PSCR4XAGPMm8aYk/A35acBTwePbzLGXGuM2RX4D+CnIjKmGTlPAqqABXWfMMasNMZcbozpB1wJ3NvEEfVUtiAG1Pp8F/z9Z/D379tve0JE+jRz2cvxtzrqW7Zqgpa8BYwxJcCN+Pt+J4tIexEpEpHxInJbPd/SCf8/hbX4v+y3bHtCRNqIyLki0iXYvN6Iv2mMiJwgIkNERPAPkFVve64xItJdRM4F7gF+Z4xZW89rTheR/sGX6/GLtm3Z3wK7pvBXUdePRaS/iHTH34/etj//HjBMRPYRkWL83ZXamlrfk8AvRaSXiPTE/7vPqWsQcpmWvIWMMf8L/BT/ANBq/E3VCfgjcV1/wd/EXIZ/9HlenefPB7xgU/4q/H1Q8A/U/Qt/H3MucK8xZlYjsd4Tkc34m/iXAf9ljLmxgdceAMwPXv8scI0xZnHw3CTgMRHZICJnNLK+uqbgH8xbDHwJ3AxgjPkM+HXws3wO1N3/fwj/mMQGEanv7+9mYCGwCHgf/8DlzfW8TtVDmnEcRykVQjqSKxVxWnKlIk5LrlTEacmVijgtuVIRpyVXKuK05EpFnJZcqYjTkisVcVpypSJOS65UxGnJlYo4LblSEaclVyritORKRZyWXKmI05IrFXFacqUiTkuuVMRpyZWKOC25UhGnJVcq4rTkSkWcllypiNOSKxVxWnKlIi6lW++q8HMSyWJgZ/xb/nbB/w8+VuvP2p9X4N8EcV3w52rPjZdYiK3SQO+FFhFOIhkD9gD2A3bHL/POtf7s1spVlAErgo8l+DceXAS877nxZa1ctsogLXkIBYXeC9gfv9T7A/tQ6x7gWbaO70u/CJjnufEPLGVRdWjJQ8JJJPcGjgPGAYcA7ewmatIK/NsYzwBe9tz4ast58paWPEc5iWQRcDRwMnAi/iZ3WBngHeCl4GOO58ar7UbKH1ryHOIkkgKMAS4CTsA/QBZFy4HJwCOeG//Udpio05LnACeR7A1cDFwGDLEcJ9vmAY8AT3lufKPtMFGkJbckGLWPAq7E3yRvYzeRdWXAP4AHPTf+quUskaIlzzInkWwLXA5cDQy1HCdXLQB+BzzjuXH9BW0lLXmWOIlkIXAJ8EtggOU4YfEJcAswRQ/UtZyWPMOCc9rnATcCu1qOE1afAL8GpnpuvMZ2mLDRkmdIsM99BjAJ/0o01XofAFd7bnyW7SBhoiXPACeR3Be4HxhlO0tETQGu9dz4SttBwkBLnkZOItkO+BXwX+ibfzKtBPgf4F7dX2+cljxNnERyLPBndL87294G/tNz4wtsB8lVWvJWchLJ7sAdwIW2s+SxGuBPwHWeGy+zHSbXaMlbwUkkT8H/5eptO4sC4EPgdM+Nf2w7SC7RkreAk0i2AW7Hv6BF5ZZS4MeeG3/UdpBcoSVvJieRdICngQMsR1GNewy/7FtsB7FNS94MwcG1qUB321lUSj4Gzsj3CSx0IscUOYnkdcA/0YKHyZ7AAieRPMN2EJt0JG9CMHnDw/iXpqpwqgF+4rnxP9oOYoOWvBHBxS1/A463nUWlxa2eG/+57RDZpiVvgJNIdgaeA46wnUWl1aPA5Z4br7IdJFu05PVwEske+HOR7W87i8qIJP4BuVLbQbJBS16Hk0j2A17Gn/JYRdc8IO658XW2g2SalrwWJ5HcFfgXMMh2FpUVbwJjPDe+yXaQTNKSB5xEsi8wFxhoO4vKqtnAcVG+5l3PkwNOItkJeAEteD46AngmOFUaSXlf8uAf9+/4txlS+Wkc8Egwm0/k5H3JgQeAY2yHUNadiz9DbOTkdcmdRPI36PvA1fd+5iSSE22HSLe8PfDmJJKX48/DplRtVcDRnht/3XaQdMnLkjuJ5MH4R1V1HjZVn+XAvp4bX2U7SDrk3ea6k0h2BZ5EC64a1g+Y4iSSkehHJH6IZnoAPVWmmjYGuMl2iHTIq811J5G8An9GVaVSUQOM99z4DNtBWiNvSu4kksPwL2NsZzuLCpU1+PvnS20Haam82FwP3hf+FFpw1Xw98d+eGlp5UXL8mVWH2w6hQmuMk0iebztES0V+cz04XfYGEMlLFlXWrAb2CONbUyM9kgf3BP8TWnDVer2A22yHaIlIlxz4CTDCdggVGZc4ieThtkM0V2Q314P3h38GdLSdRUXKx8A+nhuvsB0kVVEeyW9FC67Sb0/gZ7ZDNEckR3InkTwAmI/ui6vMKAUGheXa9qiO5HeiBVeZ0x643naIVEVuJHcSyTH4kzEqlUmlwK6eG//WdpCmRHEkv8F2AJUXQjOaR2okdxLJA/H3xZXKhlCM5lEbyfPuPlfKqvbAf9sO0ZTIjOTBu8zeRw+4qewqwx/NV9oO0pAojeQ3oAVX2dcOuMZ2iMZEYiR3EslBwOdAzHYWlZdWA/1z9Sq4qIzkl6MFV/b0Ak6zHaIhoS95cNeL82znUHnvKtsBGhL6kgNHAQNsh1B57wgnkRxqO0R9olDyC2wHUCqQk3fjCfWBNyeRbA98i77bTOWGbwDHc+M1toPUFvaR/FS04Cp3DMDffcwpYS+5bqqrXHOS7QB1hbbkTiLZG/8uF0rlkvG2A9QV2pIDYwl3fhVNQ5xEcojtELWFuSQ6iqtclVOjeZhLPtZ2AKUacLztALWF8hRacNHBZ7ZzKNWArUB3z42X2Q4C4R3JdRRXuawYONJ2iG2slVxEHhaRVSLyQQu+XUuuct042wG2sTmSPwoc19xvchLJAnLwggOl6hhlO8A21kpujJkNtOTmccOBbmmOo1S6jQjeIWldGPfJR9oOoFQKOgGDbYcALblSmbSP7QCgJVcqk/a1HQDCWfLhtgMolaKcGMkLG3tSRE5t7HljzD9aumIReRL/XGJPEVkK3GSMeaix73ESyS5An5auszEbF05n83svgYGOI8fR+YDv30y0ccE/WD/rYfpPfIJY+y7bfd/Wrxax7pUHvvu6cu1Sev3H9bTf7WBWP3c7FSu/QApitOm7Gz3GTUBijf6Vq2jJ/ZIDJwZ/9gYOAV4Jvj4K+DfQ4pIbY85uwbft1tL1NaZitcfm916izwV3ILEiVj19I+2GHEBRt35UbVxN2ZJ3iHXuVe/3Fg8cQb+L/whAddkmlt9/OcWD/K20jnsdSfEJ1wGw5rnb2bxoBp32zakrHlVm9XMSye6eG2/JWaS0aXRz3RhzsTHmYqAI2MsYc5ox5jRgWPBYtu2eiYVWrl1Km767U1BUjBTEaDtgOKWf/RuA9TMfoNtRF5PKlO6ln75B8a77U1BUDEC7wQcgIogIbfvuRtWmNZmIr3LbzrYDpLpPPsAYs6LW198Cu2QgT1OcTCy0Tc+BlC/9kOqyjdRUbqVs8UKqN66h9PN5xDr1oE3vXVNazpaPZ9Nhz9E7PG6qq9jy4SzaDdov3dFV7svI7mVzpLqDOFNEXgKeDL4+Ezu3B+6ZiYUW9RxA5x/8kFVT/wcpKqZN710x1ZWUzH2anc78TUrLqNq8jsrVXr1FXjfjXtr2H0bxAD1mmIfCUXJjzITgINzhwUP3G2OeyVysBvXI1II7jTyWTiOPBWD9a48R69CV0s/nsfzhiQBUb1rDikd/Qt8L7iDWcccL7ko/eZ32ux28w4G1DXOmUF22kV7HTchUdJXbdrIdIOVDvcGR9BYfaEuT7placPWWDcQ6dKVq4ypKP5tL3/N/T+dR3x9hX3rfJfS98M4djq5vs+Wj2XQbvf2MvJvee4mtS96m91m/RSSMZytVGuT2SC4ic4wxh4nIJqD2G88FMMaYzhlNt6OMjeSrp91CTdkmKIjR/ZirKChueBLY8hWfs/ndF+kx/moAqkq+pXrTatrusv3m+LqX7qGwS29WPu4fYW+/2yF0PbQlJxVUiFkveagmjXASyc+BnJo/S6kmzPTcuNW3Rjc1kje6eWyMyfb5v4yN5EplSP0XWGRRU/vkb+Fvptd3ktgAqZ1bSoPgfeT17xArlbva2g7QaMmNMYOyFSQFHQjntfYqv1m/jjnlACLSDRiKP38V8N3ED9lSlcV1KZUu4Si5iFwGXAP0B94FDgLmAkdnLtoOKrO4rrwzSj79+LjYm6u3P4miWquK2AaIW82Q0tF1EXkfOACYZ4zZR0T2AG4xxjT6LrV0cxLJGlK5iFy1yEBZufTHselfnhCb16e9lGfkfQJ56GsmlQy0GSDVfdytxpitACLS1hjzCRl6s0gTdDTPoK9Mn/7XV105eq/yR3YfV+4ueb76B6+Wm8LFtnOFXLXtAKnuLywVka7ANOBlEVkPfJW5WA2qBNpYWG/e+dTsMmhC5TWDAPaVzz+bWPjMisML3h9cJNX9bWcLGevHkpp9MYyIjMY/lfVPY0xFRlI1wEkk1wNds7lOtb1DCz74cELsmTUHFnyyR0yM9euyQ2ARk0qsTlnW1MUwLwBTgGnGmM0AxpjXshGsAbq5btkbNcOHvVEzHKGm5piCt9/9UeH0TSNk8bACMRl7X0Ftzl2b6NRWiAkUFsDCK7a//PiJRZX87o1yDNCpjXBfvJiRfWIA3Dm3nAffqUSAvXcq4JGT2lFcmPFDPKszvYKmNLW5/mfgLOBOEZmF/1bTZLZH8Fq2kANXECkwFBTMqBm1z4yKUcSorjqxYO7CqwqfK99dvtlbhIy+p2HWhe3p2b7+w0mDugmvXdSBbu2EFz+v5Irny5h/WUeWbazh/xZU8NGPOtKuSDjjr6U89UElF+2T8b2/3C65MWY6MF1E2uNPBXUBcJ+IvAhMMca8nIWMtS0jQxNHqJarJlY4reawUdMqDqMtFVt/GJs9/7LYCzWOrNxHhHbZzHLIgO9/pQ/qX8jSjVu/+7qqBsqqoChmKK2Efp2ycm1Vbpd8G2NMKTAVmCoiI4DH8Asfy2C2+nyT5fWpZiqnTfET1WN/8ET1WDpQtvnc2Mw3Lip8qU1f1o4Uaf1BUxE4dnIpInDl/m24Yv+GF/nQOxWMH+L/iu/cuYDrDm7DLnduol2RcOzgGMcOzsp1KquysZLGpHoxzE7AGfib7n2Bp4GLMherQVryENlCu473V59w6P3VJ9CFzRsuKXxxwTmxV9r3pGSkSMsGiDkXd2DnzgWs2lLDMZNL2aNnAUcM3PHXeNaSKh56p5I5F7cHYH2ZYfqnVSy5piNdi4XT/1rG44sqOG9E9DfXG91eEZHLReQV4G38S1p/ZozZ1RiTMMa8l5WE29OSh1QJHbveWXX6YQeU37ffD8rvWfdg1fjZJabD+8Y07xK7nTv7v7K9OxRwyh6FLFi242noRd9Wc9lzZUw/qx09gn33fy2uYlDXAnp1KKAoJpy6ZyH//iYrp7Bzu+TAwcCt+BM5Xm2M+XcWMjVGSx4Bq+jW6+aq848YWf7A3odX/GHFlKqjX9tsij9u6vu2VBg2lZvvPp/xZTXDe2+/QfB1SQ2nTi1l8int2K3H98/t0kWYt6ya0kqDMYaZS6rZs2dW9jZXNP2SzEr1stZDgXeNMVtE5DxgP+APxpisXhDjJJL7AwuzuU6VPYNl2VdXFz6zZFzBmwOKpXKHmwUuXl/DKVNLAf8g2jnDi/jFEW3500L/ZM9Vo9pw2bNl/P3jSgZ28cev2qfZbpq1lakfVlFYAPv2jfHgicW0zfwptJ5MKlnb1ItE5DjgD/jHuR40xrjpCpBqyRfh34NsBP59xR8EzjDG7Dj/cAY5iWRv/OmgVcSNkC8/n1g4bfmRBe86RVJt9drvVljLpJImZxgWkRjwGXAMsBR4EzjbGPNROkKkeg6hyvj/G5wE3G2MuQf/1qzZthr/XLmKuEVm8NDLK68dPbR88sAzy3/50RvVw16rNgXWN32b6ZMUX3cg8IUxZnFwDcpT+F1Li1RLvklEbgDOA5LiTz2a9TuoeG7cAIuyvV5l13yz117nVv5i9ODyyX0uqbhu0Vs1Q2fXGAnD7Wg+TPF1O7P98aalpPHOK6meKDwTOAe41BizUkR2AW5PV4hmehv/gKDKOyKv1Ow34pWK/Sigpvr4gvlv/Wfhs2V7yVd7i+Tk1GA5MSClejHMSuCOWl9/DfwlU6Ga8I6l9aocUkNB7Pmag/d/vuJg2lBZfkrs9QWXx5JVg2XFSBE62M4XSPU08zJgQK2v+wePpUXY5l0HPbqu6qigqO3U6qMPnFp9NO3ZWnp27JW5Fxf+M7Yza0aKWJtIsYbUR/I3gaEiMgi/3GfhbzmnRajmXQdwEskYsAFo+O4HSgGd2FJyUeylD84r/FdxbzaMFMnqfGtvMalkVKovFpHjgbvwT6E9bIz5bbqChK7kAE4iOZPszi+nQq47JWuvKEx+eGbs1S5d2by3SMZn/v09k0p+luF1pCSsUxzPtR1Ahcs6uvRwq845Yt/y+0ceWv5/306uGvvaJtMu1aPfLTErg8tulrCO5McAM2znUOE3SJZ/PbFw2pLxBQv6tZOKoWlabBXQnUklm9K0vFYJa8nb4F8YY+PAn4qovcT7cmLhM0vHFLwzsI1UOa1Y1HwmlRyUrlytFcqSAziJ5FP45++VSrtR8unHEwufWXVowQdDCqWmuRemuEwquSEjwVrA+t0dWmE6WnKVIQvN7nteWJnYE4w5omDR+xMKp63fXz7bMyYmlenHZmY8YDOEueQv4E/smPXLa1U+EZldM3Lv2RUjKaCmelzBm+/8qPDZLcNkyfACqXfm4HXAq1kO2ajQbq4DOInky4DVez+r/FRIVeXJsTfevSL2fOVQWTZC5LvrNh5hUsklVsPVEeaRHPxNdi25yroqCov+Vj36gL9Vj6aY8rIzYq/OvTT2ovSSDVPb2w5XR9hH8l2wcycXpeqzBujruXHrd02pLawXwwDgufGvgddt51Aq8FSuFRxCXvLAfbYDKBWYbDtAfaJQ8r+TA3Nbq7z3qefGF9gOUZ/Ql9xz4xXAQ7ZzqLz3R9sBGhL6kgf+hP/+XaVsWAs8YjtEQyJR8uAAXNJ2DpW37vPceKntEA2JRMkD99oOoPJSOXC37RCNiVLJX8Kfu1qpbHrcc+M5fS+AyJQ8mK75Jts5VF4xwP/aDtGUyJQ8MBV413YIlTde8Nx4k/dwsy1SJQ9G81/YzqHyggF+ZTtEKiJVcgDPjb8AzLGdQ0Xe454bf9N2iFREruSBnJmVQ0VSKSH6HYtkyT03Pgd/UgmlMuE2z42n7Q4nmRbJkgd+jl4Fp9LvG+A22yGaI7Il99z4e8A9tnOoyLnBc+NltkM0R2RLHvg5298SVqnWmA9MsR2iuSJdcs+NbwYm2M6hIqECuCo4TRsqkS45gOfGn8W/SEap1rjRc+OhvNAq8iUP/BjI6euLVU6bDdxuO0RL5UXJPTe+FrjSdg4VShuBCzw3HtozNXlRcgDPjU8nh9/Yr3LWBM+Nh3pG4LwpeeBHwNu2Q6jQ+KvnxnNycsbmyKuSe258K3Aq/vzYSjVmGXCV7RDpkFclBwg2vc4Cqm1nUTmrDDjZc+PrbAdJh7wrOYDnxmcCCds5VM661HPjC22HSJe8LDmA58Z/DzxlO4fKObd6bvxJ2yHSKW9LHrgUeM92CJUzniaCk46E+oaH6eAkkn3wL3YYajuLsmoOMNZz4+W2g6Rb3pccwEkkB+DfOHGg7SzKik+BQ6JyoK2ufN9cB8Bz498AY4DltrOorPsMGBPVgoOW/DueG/8SGAustp1FZc3HwOgwzfLSElryWoLpdY8F1tvOojLufeBIz42vtB0k07TkdQRvJxwPbLCdRWXMO8BRnhvPi1tea8nr4bnx+cAhgGc5ikq/hfj74GttB8kWLXkDgk33g4CcvLG8apHX8U+T5dXumJa8EcGN7I4EplmOolrvz/gjeIntINmm58lT4CSSBfg3tvuJ7Syq2SqBiZ4b/7PtILZoyZvBSSQnAHcBMdtZVEpWAacFN9vIW1ryZnISydH40/L2s51FNeot4JTgQqe8pvvkzeS58deAkehtmHLZX4DDteA+HclbyEkkBX8f/VagreU4yvct/tzoeqC0Fi15KzmJ5DBgMrCv7Sx5bgr+AbbIXoPeUlryNHASySLgRuB6oI3lOPlGR+8maMnTyEkkhwJ3AnHbWfLEk/ijd95cvdYSWvIMcBLJ8fhl3912loj6CLjOc+Mv2g4SBnp0PQOCX769gevw78Ch0mMV/jTJI7TgqdORPMOcRHIn4LfAhUCh5ThhtRG4A7jDc+ObbIcJGy15ljiJ5C7AT4HLgA6W44RFGXA38Dvd7245LXmWOYlkd/x7pk8EelqOk6u+Bu4DHvTcuN7tppW05JY4iWR74BLgWsCxmyZnzMIfuad7blzvcJMmWnLLnESyEBgHnAucBLS3myjrSvEvJrrbc+Mf2A4TRVryHOIkkh2Bk4Hz8CeVjOq73bYCM4B/4I/aOtVWBmnJc1RwVP5M4GzgQMJ/unMjkMQv9oueG99iOU/e0JKHQHCwbgxwTPDhWA2Umhr8i1bmAM8CMz03XmE3Un7SkodQcMeXw4DD8Sec3AP774RbA8wH5gLzgAV6Tjs3aMkjIJieahB+2bd97Bn82SONqzL4bwhZDHwJfIF/B5KFnhv/Io3rUWmkJY84J5Hsil/0rg18dMKfB21r8FFe5/NSYCWwFFjuufHKLP8IqpW05EpFXNiP2CqlmqAlVyritORKRZyWXKmI05IrFXFacqUiTkuuVMRpyZWKOC25UhGnJVcq4rTkSkWcllypiNOSKxVxWnKlIk5LrlTEacmVijgtuVIRpyVXKuK05EpFnJZcqYjTkisVcVpypSJOS65UxGnJlYo4LblSEaclVyritORKRZyWXKmI05IrFXFacqUiTkuuVMT9P7vN9RqvejL1AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "data[\"isValid\"].value_counts().plot.pie(autopct='%.2f')\n",
    "plt.title('Class Distribution')\n",
    "plt.show()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAPkAAAD7CAYAAACohzKbAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4wLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvqOYd8AAAGMNJREFUeJzt3Xu8HeO9x/HPTxK5ChKXCJURFE1aXuiJg6q6VJmiRWmL1qWE49Ce0x5GOaqqOrRepVpV2oPWoS6tWweNutWlcYnjEnWPUSQhEiQ7IslOnvPH8+xmZdlr7bV31trPzLN+79drvbL3WrNmvnsy3zWzZtaaEWMMSqlwreY7gFKqtbTkSgVOS65U4LTkSgVOS65U4LTkSgVOS16HiBgR2cz9PFREbhWR90Tk+iaMO3LjH9jH539XRH69qjkamM5KOUXkdhH5epPG/SkReb7i91xE9mjGuN34nhGRXZs1vrLq0wJWJiKyM3AeMAFYBjwLfMsY82gvR3UQsD4w2hjT2dyU9bkF9SpjzEZd9xljzunPDBXT3buR4UTEAJsbY16qM677gS2akUtErgBeN8acXjH+Cc0Yd9kFXXIRGQn8CTgeuA5YHfgUsLgPoxsHvNBowUVkYH+/GJSJzp9+ZIwJ9gZsD7zbwzBHYdfu7wB/BsZVPGaAzYDvA0uApUAHcHQ34zkTuAG4CpgPfAP7digBXgbmYl9oRrnhIzf+ge73I12OBcAMYLK7fziwCFjupt0BjHXTu6pi+vsBzwDvAvcCW1U8lgPfAZ4C3gOuBYbUmB8DgJ8Ab7scJ1TlvBf4hvt5M+A+N863gWvd/X91z1no8h4C7Aq8DpwCzAZ+13VfVc5Tgb+7/4/Lu3ICRwAPVGXt+v851v3fLHHTu7VifHu4nwcDFwAz3e0CYLB7rCvbt4G3gFnAkb6X36b1wHeAlv5xMNKV60pgb2Dtqsf3B14CtsJu1ZwOPFS9ELmfVypVN9M60y1oX8CWeyjwTWAqsJFbyH4FXOOGj6rKEwObAgJ8Gngf2LZyIexmele5nz/qCrUnMAg42f1dq1cs7I9gXxxGYV9MjqvxdxwHPAd8xA17D7VLfg1wmvt7hwA7dzfvKv6GTuBcNy+GVv9dLuf0imk/CJztHjuCGiV3P1/RNWzV+LpKfpb7v1gPWBd4CPhBVbaz3Pzbx83/tbubR2W7Bb3jzRgzH9gZuzBcBswRkVtEZH03yHHAj4wxzxq76XgOsI2IjOvjJP9mjLnJGLPcGLPIjf80Y8zrxpjF2GIe1N3ONmNMZox52Vj3AVOwby0acQiQGWPuNMYsxa6JhwI7VgzzM2PMTGPMPOBWYJsa4zoYuMAY85ob9kd1prsU+zZmrDHmA2PMAz3kXA58zxiz2M2f7vy8Yto/BL7SwzgbdShwljHmLWPMHOzW2eEVjy91jy81xtyG3SJoyv4C34IuOYAr8BHG7rSaiF2bXeAeHgdcKCLvisi7wDzsmnTDPk7utarfxwE3Voz/WezOv/Wrnygie4vIVBGZ54bdB1inwemOBV7t+sUYs9xlqfw7Zlf8/D4wos64Kv+OV2sMB3aLQYBH3J7so3rIOccY80EPw1RPe2wPwzdqpXnUzbjnmpX3EdSbR6USfMkrGWOew27WTXR3vYZ977tWxW2oMeahvk6i6vfXgL2rxj/EGPNG5UAiMhj4A3YNvL4xZi3gNmyBuhtvtZnYF5Su8Ql2k/eNms+obZZ7bpeNaw1ojJltjDnGGDMWmAxc3HXIsdZTGph+9bRnup8XAsO6HhCRMb0c90rzqGrcQQu65CKypYh8W0Q2cr9/BLv5N9UNcglwqohMcI+vKSJfamKES4Afdm3+i8i6IrJ/N8Otjn2fOgfoFJG9gc9WPP4mMFpE1qwxneuAWER2F5FB2B1Ii7HvO3vrOuAkEdlIRNbG7jjsloh8qWveYneUGewmeVfm8X2Y/glu2qOw7/evdfc/CUwQkW1EZAj2rU+lnqZ3DXC6+z9YBzgDu5M0eEGXHLunehLwsIgsxJZ7OrYEGGNuxO4I+r2IzHePNXQcuEEXArcAU0RkgZv+pOqBjDELgJOwBXsH+Kp7Xtfjz2EX0hlu039s1fOfBw4DLsLu5d4X2NcYs6QPmS/DHmV4Engc+GOdYT+JnbcdLu83jTEz3GNnAle6vAf3YvpXY/dHzMAelTgbwBjzAnbH2F+AF4Hq9/+/AT7mpndTN+M9G3gMe4Thafe3nd2LXKUlbu+iUipQoa/JlWp7WnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAqclVypwWnKlAveh62SrMEVJNggYA2zg/h2K/f/vugF0uttS7FVEZ7nbW3kaL+vvzKo59FpogYiSbDVgC2A7YCvstbc3qPh3NCsuhdxby7BXXJ2FvdzvLOxlkacD0/I0fmWVwquW0pKXkCv0lthCd922AUZ4ijQPe5XQaV23PI1n1H+K6i9a8pKIkmw8sB/weWAHYLjfRD16B/grcCvwpzyN3/Scp21pyQvKra0nYYu9LzDBb6JVYoBHsNcwvzVP46c952krWvICiZJsAPA54EAgBtbzm6hlXsGu4a/P0/gB32FCpyUvgCjJIuBo4EhgQ79p+t1zwGXAb/M0ftt3mBBpyT2JkkyAvYCT3L/t/pmFJcANwIV5Gj/iO0xItOT9LEqy4cARwInYQ17qwx4GLsRuznf6DlN2WvJ+EiXZ6sBxwOnAup7jlMVL2Pl1XZ7GuqD2kZa8xdxe8q8CZwGbeI5TVo8Dp+ZpPMV3kDLSkrdQlGT7AOcAW/vOEoi7gCRP48d8BykTLXkLREm2A3AusIvvLAEywB+A0/I0fsF3mDLQkjdRlGQjgB8Dk+n758RVY5YAPwBS3TlXn5a8SaIk2x34DTDOd5Y2Mw04Ik/j6b6DFJWWfBXp2rsQlmB3bJ6ra/UP05KvgijJdsOuvSPPUZQ1Dfh6nsbP+A5SJFryPoiSbAhwPnA8uvYumiXAmdj36rpwoyXvtSjJNgRuArb3nUXVdRNweJ7GHb6D+KYl74UoySYBN2LPtKKKbzqwX7ufuabdvxTRsCjJvgbchxa8TCYCj0ZJtqvvID7pmrwH7mOp5wHf9p1F9VkncFKexr/0HcQHLXkdUZKtCVwD7O07i2qKS7BlX+o7SH/SktcQJdn6wF+wm3wqHHcAB+RpvMh3kP6iJe+G24N+F/p971DdA+ybp/FC30H6g5a8SpRk44C7gfG+s6iWehDYJ0/j+b6DtJqWvEKUZBtj96BHnqOo/jEV2DP0Y+l6CM2JkmwsdhM98hxF9Z8dgCxKsmG+g7SSlhyIkmw97E62zXxnUf1uF+Bm91HlILV9yd2r+O3Y64ep9rQHcJU7g25w2r7kwOXAtr5DKO8OBL7nO0QrtHXJoyQ7HTjYdw5VGGdESXag7xDN1rZ716Mk+wLwR/SromplC4Gd8jR+0neQZmnLkkdJNhH4G/4u9auK7VXgk3kaz/EdpBnabnM9SrLR2KtrasFVLeOAP0RJNsh3kGZoq5K7q4begF7kQPXsU8DPfYdohrYqOXAysKvvEKo0jo2SbH/fIVZV27wnj5JsAvZyO6v7zqJKZTYwIU/jeb6D9FVbrMmjJBsIXIEWXPXeGOAi3yFWRVuUHLuZrideVH31VXfItZSC31x3h8umoWtxtWrexG62z/UdpLeCXpPrZrpqovUp6WZ70CXHbqZv5zuECsZXoiT7ou8QvRXs5nqUZBsALwFBf1dY9bsc2CJP4yW+gzQq5DX599CCq+aLgON8h+iNINfkUZJ9FHgGGOg7iwrSHGDTPI0X+A7SiFDX5GejBVetsy4luthGcGvyKMm2Bx5Bv0KqWqsDuzZ/y3eQnoS4Jk/RgqvWGwGc7jtEI4Jak0dJticwxXcO1TaWAFsW/aqpoa3Jz/YdQLWV1YEzfIfoSTBr8ijJdsReFUOp/rQE2DhP4zd9B6klpDX5Sb4DqLa0OjDZd4h6gliTR0m2EfAKethM+TEbGFfUT8GFsiafjBZc+TMGOMh3iFpKX3J33rajfOdQbe8Y3wFqKX3JgRgY6zuEanu7Rkm2ue8Q3Qmh5IV9BVVt5xu+A3Sn1Dve3NVIZwIDfGdRCrsDbmyexoUqVdnX5DFacFUcY4B/8R2iWtlLvp/vAEpVKdwyWdqSR0k2GNjTdw6lquzrO0C10pYc2B0Y7juEUlU+HiVZ5DtEpTKXvHCbRUo5hVo2y1zyz/sOoFQNhdpkL+UhtCjJtgMe851DqRqWAuvkaTzfdxAo75p8b98BlKpjELCH7xBdylrywh2LVKpKYZbRspZcr4qiiq4wy2jpSh4l2Rj0Cymq+Lb1HaBL6UpOgV4hlapjVJRkm/gOAVpypVqpEMuqllyp1inEsqolV6p1CrGslqrk7vvjG/rOoVSDCrHzrVQlB8b7DqBUL4yOkmyk7xBlK/kGvgMo1Uvel9mGSy4iO4vIke7ndUXEx+EB7zNMqV7yvsw2VHIR+R5wCnCqu2sQcFWrQtXhfYYp1Uvel9lG1+RfxH5HdiGAMWYmsEarQtXhfYYp1Uvel9lGS77E2O+kGgAR8XVGFv04qyob78tsoyW/TkR+BawlIscAfwEua12smry/KirVS96X2YauH2aM+YmI7AnMB7YAzjDG3NnSZN3zPsOU6iXvy2xDJReRZcDTFXf9vM6wEfAnY8zEVUrWvdHNGtHbt13AopcfZcCwNRl79MUALFu0gLdvPpfO+W8ycOT6rPOFhAFDRmCM4Z27LmXRy48hgwYzep9vMXjMZh8a5+LZLzE3+ymmcwlDN92etXc/FhGpOV7VFtbxHaDh9+TYM6Nugv1AytMi0q+ntomSTGjilUtHfHwP1vvS91e6b/7U6xkSbc2Gx17GkGhr5k+9HoAPZjzG0nkzGXvspYze69+ZN+Xibsc5b8ovGP25Exl77KUsnTeTD2ZMqzte1RYG+Q7QaMkHA/sZY9Y0xow0xqwBfEJE7heRx91tx+onicgEEXlERJ4QkadEZHN3/2EV9/9KRBq5CkpTZ9aQj0xkwNCVDxC8/9LDDJ+4OwDDJ+7O+y9Otfe/+DAjJu6GiDB4wy1ZvnghnR3zVnpuZ8c8li9exOANt0REGDFxtxXPrzFe1RZKU3IBrnGlvNHd9xawpzFmW+AQ4GfdPO844EJjzDbA9sDrIrKVG34nd/8y4NAGMrT8+uPLFr7LwBGjABgwfG2WLXzX3t8xlwEjV2x1DVxjNMsWzF35uQvmMnCNFe8mBqwxmmUdc+uOV7WFli+3zQqwFHgeuAlYLCIHAMOAvUSkq6gf7eZ5fwNOE5GNgD8aY14Ukd2x3855VEQAhmJfMHrSr9c8ExGkRONVheX9Wn2NllyA94HPVty3DXAXsDV2i+CD6icZY64WkYexFya8TUQmu3FdaYw5tXr4Hizv5fC9NmD4WnR2zGPgiFF0dsxjteFr2ftHjGbZ/Lf/OVzngrkMWGPlfYAD1hhNZ8XafdmCuQwYMbrueFVbaPly25NGN9cXG2OOrLwB9wKzjDHLgcPp5hVLRMYDM4wxPwNuBj6BfWE4SETWc8OMEpFxDWRY2mDWPhu22SQWTr8LgIXT72LYZpMAGLr5JDqm340xhsVvPMdqg4f9c/O7y8ARo1ht8FAWv/Ecxhg6pt/NsM0n1R2vagstX2570vCa3L0X38n9fj/wU+BiEfkacAfuI69VDgYOF5Gl2Gs3n2OMmScipwNTRGQ17Ew4AXi1hwydDWZtyJxbzmPxP55m2aL5vP6Lr7PmzocycoeDePvmlI6npjBw5Hqss38CwNDx27Po5ceYeekxyEB7CK3LzMtPZOyRFwEwas9/Y+5t7hDa+O0YMn57gJrjVW2hqcttXzR0BRURuRO4Gvidu+sw4FBjTL9eVTRKsmWU7+uxqr09k6dxKz4z0rBGC7OuMeZyY0ynu10BrNvCXLW842GaSq2KeT0P0lqNlnyuO7Y9wN0OA+b2+Kzmm+VhmkqtCu/LbKMlPwr7/no2NvRBwJGtClWH9xmmVC95X2Yb/YLKqxTjmsszfQdQqpe8L7N1Sy4iZ9R52BhjftDkPD3x/qqoVC95X2Z7WpN3d1hsOHA09hthWnKl6vO+zNYtuTHm/K6fRWQN4JvY9+K/B86v9bwW8j7DlOol78tsj+/JRWQU8J/YL5FcCWxrjPF1KMv7DFOql7wvsz29J/8xcABwKfBxY0xHv6SqradPxSlVJB15Gns/Tl73E28ishxYjP1oXuWAgt3x1u9Xh4iS7G2aeIYYpVro/jyNd/Edoqf35EX8COk0Vv42nFJFNc13ACjn58ALMeOUakAhllUtuVKtU4hlVUuuVGt0YM+m5F3pSp6ncU4BvtmjVA+eyNPY+1lhoIQld3RtroquMMtoWUv+mO8ASvWgMMtoWUv+Z98BlKrDAD4uI9atspb8QfR9uSquR/I0ftN3iC6lLHmexp3A7b5zKFXDLb4DVCplyZ1bfQdQqoZCLZtlLvntFOCc1kpVeSVP46d7Hqz/lLbkeRrPB+7znUOpKoVai0OJS+4Uboaqtle4ZbLsJS/UDg7V9t6jgFuXpS65+4jrg75zKOVcl6dx4fYTlbrkzqW+AyjlFHJZDKHk1wPv+g6h2t4TeRoX5qOslUpf8jyNFwFX+c6h2t5lvgPUUvqSOxf7DqDa2nxWXPG3cIIoeZ7Gz1KgLwSotnN5nsYLfIeoJYiSOxf6DqDa0nLgIt8h6gmp5LcBL/oOodpOlqfxy75D1BNMyfM0NsD3fedQbcUAZ/oO0ZNgSu5cDTzpO4RqG9flafy47xA9Carkbm1+qu8cqi0sBU73HaIRQZUcIE/j2yng54dVcH6dp/FLvkM0IriSO6f4DqCCthA4y3eIRgVZ8jyNHwZu9J1DBeuCPI1n+w7RqCBL7nwXWOY7hArOXOA83yF6I9iS52n8HHCJ7xwqOGe4sxKVRrAldxIg9x1CBeNe4Je+Q/RW0CXP07gDOAr7oQWlVsVC4Ch3mLZUgi45QJ7G91DCV19VOKfkafyK7xB9EXzJnZOBUv4HqUK4hxJ/nbktSp6n8UJ0s131zULg6DJupndpi5ID5Gl8LyV+NVbenFzWzfQubVNy5xTgWd8hVGncQQD7c8SY0m6F9EmUZJsDDwNr+86iCu0FYFKexqU/SWi7rcnJ0/hF4BD003CqtveA/UIoOLRhyQHyNL4T+I7vHKqQlgNfztP4ed9BmqUtSw6Qp/EFwP/4zqEK5+Q8je/wHaKZ2rbkzvHoZZbUClfmaXy+7xDN1tYlz9N4CXAA8JrvLMq7qcBk3yFaoa1LDpCn8VvAXsAc31mUN3/H7mhb7DtIK7R9yeGfF2fYA5jnO4vqdy8Cu+dpHOyLvJbcydP4Kewa/T3fWVS/eQXYrUxneekLLXkFd1XKz6JXSW0HM4DP5Gn8uu8graYlr5Kn8SPAbtjT/KgwPQ/skqfxq76D9ActeTfyNP4/YFfgTc9RVPNNBz6dp/EbvoP0Fy15DXkaTwd2BJ7xnUU1zV3YNXhbvXhryevI03gG8K/Arb6zqFV2EfC5PI3f8R2kv7Xdt9D6Ikqy1YCz0UswldES4IQ8jX/tO4gvWvJeiJLsy9jPuw/1nUU15C3gwDyNH/AdxCcteS9FSbYdcBOwke8sqq4ngP3zNP6H7yC+6XvyXsrTeBrwSeBu31lUTb8FdtKCW7om76MoyQQ4DnvJnBGe4yhrFjA5T2PdUVpBS76KoiSLsO/TP+M5Sru7CjipHfee90RL3gRurX48dq0+3HOcdjMbu/a+xXeQotKSN1GUZJsAv0HX6v3lf7Frb/32YB1a8iZza/WvYS9Sv7HnOKF6CnvZoqBO09QqWvIWiZJsMHAC9jrpoz3HCUUO/DdwdZ7Gyz1nKQ0teYtFSbYm8F/AfwDDPMcpqznYTxxe4k7ZpXpBS95PoiQbA5wBHAMM9BynLDqA84GfuMtQqz7QkvezKMk2Bb4FHIEeX6/lLeAS4BfuHHxqFWjJPYmSbCT2SqsnAuM9xymKx4ELgWtDPamiD1pyz9ze+D2xm/H7A4P8Jup3HcA1wGV5Gj/qO0yItOQFEiXZetjDbwcAkwj3uwVLgHuBG4Br9P12a2nJC8oVPgb2w67py/5JurnAbdgTcNyRp/ECz3nahpa8BKIkG4I9ueR+wOeBDf0matgLwC3u9lCexnolWQ+05CUUJdk4YLuq2zpeQ8HrwLTKW7udS62otOSBiJJsY1YU/mPABhW31Zs0mfexX+ecBcwEnmZFofVQV0FpydtAlGSjWbn0Y7CnsBroboMAA3S621JgISsKPQuYlaexXl2mhLTkSgUu1EM0SilHS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgVOS65U4LTkSgXu/wGRt9DxQuFeCQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "((data['participant1'] == data['participant2'])).value_counts().plot.pie(autopct='%.2f')\n",
    "plt.title('Self relation distribution ')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAPkAAAD7CAYAAACohzKbAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4wLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvqOYd8AAAGSNJREFUeJzt3XmYHFW9xvHvj+wrkLAmSIoAAhKFB/CGK4tIQIQSUMQdF3a4COpVoRAuimu5cNkUEfQqiqCAslmAIBrEhS1clnDZoRDIAmSAZIaQZJJz/zhnTKeZmV7SPafq9O/zPP0k00v12131VlVXL0eMMSilwrWO7wBKqfbSkisVOC25UoHTkisVOC25UoHTkisVuCBLLiJGRLZy/x8jIteLyKsicmULph256Q9v8vZfFpGfrG2OdhGRPUTk0UEuX6vHP9QaySsie4nIc03eT9O3bbfCllxEdheRv7tydonI30Tk7U1M6lBgY2CyMeaDLY45qP5mvDHmW8aYo4YyRyOMMbcbY7bp+1tEchHZp1XTF5HZIlLYxx+iQq6NRWQi8HvgeOAKYCSwB7CsiclNAx4zxvTWed/D672uaj19/tvAGFO4E7AL8EqN6xwBPAy8DPwBmFZxmQG2As4ElgMrgG7gyH6m81XgKuBSYDFwFHYPJwGeBBZhVzST3PUjN/3h7u/DXY4lwFPAse78ccBSYJW7725giru/Syvu/yDgIeAVYDawXcVlOfBF4AHgVeA3wOgmn9NLgC+4/091j+EE9/eWQJd73HsBz7nzf+nyL3X5T654/J8C/gm8BJxWZ4ZvAiuB1930flAxv04AHgeern6O3XVmA0fVM/+r7rOu+eUu2wt4Dviye1w58PGKy0cB33ePeyFwITCm8rYV1z0FeN7dz6PALG998l3oAWbMRGy5LgH2B9avuvxg4AlgO+zeyOnA36tLXlHiSwe5r69iVwLvcwv5GOCzwB3AZm7G/hi4fICFJnYlEeCdwGvATv3N+Oo8wJuBHmBfYIQr0RPASHd5DtyFXTlMcgvncU0+p0cA17v/fwy7AvtNxWXXDrCw5sA+/ZTmYvdc7YDdw9quzhyzqShrxfy6xT3GMdXPcfXtas3/qmk3Or96gf928/2dbv5s4y4/G7jO5ZwAXA98u/p5A7YBngWmVGTY0lefCvma3BizGNid1QvTiyJynYhs7K5yHPbJfdjYXbtvATuKyLQm7/IfxphrjDGrjDFL3fRPM8Y8Z4xZhi3mof0dvDHGZMaYJ411G3Az9qVFPT4MZMaYW4wxK7BbiTHAOyquc54xZp4xpgu7UO3Y5GO8DdhdRNYB9gS+C+zmLnunu7wRZxpjlhpj7gfux5Z9bXzbGNPlnv9amp7/dc6v/zLGLHOXZ8CHRESAY4DPu5xL3P1+pJ+7WYldSbxFREYYY3JjzJN1PK62KGTJAdwM/LQxZjNgBnZrdo67eBpwroi8IiKvYHc1Bbsb2oxnq/6eBlxdMf2HsTNu4+obisj+InKHOzj4CnAAsEGd9zsFeKbvD2PMKpel8nEsqPj/a8D4/iYkIg+JSLc7vWEl4xayHuxKYg/sMY95IrINzZW8rlwNqJ4Hg2l6/tcxv142xvRU/P0Mdj5tCIwF5lTc703u/DUYY54APofdOLwgIr8WkSkNPL6WKmzJKxljHgF+ji072AXiWGPMehWnMcaYvzd7F1V/PwvsXzX90caY5yuvJCKjgN9it8AbG2PWA27ALnD9TbfaPOwC2zc9Ad6EfS3X2AMwZntjzHh3un2Aq92GfbdhpHsst2FfW68P3DfQpBvNUitqHef3lWxsxXmbVPy/qflfx/wCWF9ExlX8vTl2Pr2EPTaxfcV9rmuM6XflZoy5zBizO3b+GuA7g2Vrp0KWXES2FZEviMhm7u83AR/Fvk4Ge8DjVBHZ3l2+roi08u2xC4Fv9u3+iciGInJwP9cbid0texHoFZH9gXdXXL4QmCwi6w5wP1cAsYjMEpERwBewr2+bXVnVchvwGeAv7u/Z7u+/GmNWDnCbhcD0FmaoOT1jzIvYFd1hIjJMRI7Avo7u0+z8rzW/+pwpIiPdHtF7gSvdXtbFwNkispG736kisl/1jUVkGxHZ261UXmf1AVgvClly7BHJmcCdItKDLfdcbAkwxlyNXTP+WkQWu8v2b+H9n4s9wHKziCxx9z+z+kruddlJ2LK+jD2gdV3F5Y8AlwNPuV28KVW3fxQ4DDgfu6U4EDjQGLO8hY+l0m3YA0Z9Jf8rdmv5lwFvAd8GTnf5v9iCDOdij2+8LCLnDXK9o4EvYQ/Abk/Fiq/Z+V9rfjkL3GXzgF9hD3Q+4i47BXvA7w53v3/EHmSrNgpIsfN0AbARcGqtfO0i7uifUipQRd2SK6VaREuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVOC05EoFTkuuVODeMN62ClOUZCOwI4Nu6v4dg53/fSeAXndagR1ZdL47vZCn8UADIqqC07HQAhEl2TrYwfd2BrbDjqm9acW/k1lziN5GrMSOBDofOxDgfOyoo3OBOXkaP71W4VVbaclLyBV6W2yh+047Av2OlT0EuoB7gTl9pzyNn/KURVXRkpdElGTTgYOw42XvCozzm6iml7FDIl8P/D5P44We83QsLXlBua31TGyxD8SO0V1WBrgLOxb49XkaP+g5T0fRkhdIlGTDgPcAHwBi7OD1IXoau4W/Mk/jv/oOEzoteQFESRYBRwKHA1P9phlyjwAXA7/I0/gl32FCpCX3JEoyAfYDTnL/dvpnFpYDVwHn5ml8l+8wIdGSD7EoycYBnwZOxL7lpd7oTuBc7O58r+8wZaclHyJRko0EjgNOBzb0HKcsnsA+X1fkaawLapO05G3mjpJ/DPgasIXnOGV1L3BqnsY3+w5SRlryNoqS7ADgW8AOvrME4lYgydP4Ht9BykRL3gZRku0KfAfY03eWABngt8BpeRo/5jtMGWjJWyhKsvHA94Bjaf5z4qo+y4GvA6kenBuclrxFoiSbBfwUmOY7S4eZA3w6T+O5voMUlZZ8LenWuxCWYw9sfke36m+kJV8LUZLtjd16R56jKGsO8Kk8jR/yHaRItORNiJJsNHAWcDy69S6a5cBXsa/VdeFGS96wKMmmAtcAu/jOogZ1DfCJPI27fQfxTUvegCjJZgJXY39pRRXfXOCgTv/lmk7/UkTdoiT7JHAbWvAymQHcHSXZXr6D+KRb8hrcx1K/C3zBdxbVtF7gpDyNf+Q7iA9a8kFESbYucDmwv+8sqiUuxJZ9he8gQ0lLPoAoyTYG/ojd5VPhuAk4JE/jpb6DDBUteT/cEfRb0e97h+rPwIF5Gvf4DjIUtORVoiSbBvwJmO47i2qrvwEH5Gm82HeQdtOSV4iSbHPsEfTIcxQ1NO4A9g39vXR9C82JkmwKdhc98hxFDZ1dgSxKsrG+g7STlhyIkmwj7EG2rXxnUUNuT+Ba91HlIHV8yd1a/Ebs+GGqM+0DXOp+QTc4HV9y4GfATr5DKO8+AHzFd4h26OiSR0l2OvAh3zlUYZwRJdkHfIdotY49uh4l2fuA36FfFVVr6gF2y9P4ft9BWqUjSx4l2QzgH/gb6lcV2zPA2/M0ftF3kFbouN31KMkmY0fX1IKrgUwDfhsl2QjfQVqho0ruRg29Ch3kQNW2B/AD3yFaoaNKDpwM7OU7hCqNY6IkO9h3iLXVMa/JoyTbHjvczkjfWVSpLAC2z9O4y3eQZnXEljxKsuHAz9GCq8ZtApzvO8Ta6IiSY3fT9YcXVbM+5t5yLaXgd9fd22Vz0K24WjsLsbvti3wHaVTQW3LdTVcttDEl3W0PuuTY3fSdfYdQwfholGTv9x2iUcHurkdJtinwBBD0d4XVkMuBbfI0Xu47SL1C3pJ/BS24ar0IOM53iEYEuSWPkuzNwEPAcN9ZVJBeBLbM03iJ7yD1CHVL/g204Kp9NqREg20EtyWPkmwX4C70K6SqvbqxW/MXfAepJcQteYoWXLXfeOB03yHqEdSWPEqyfYGbfedQHWM5sG3RR00NbUv+Dd8BVEcZCZzhO0QtwWzJoyR7B3ZUDKWG0nJg8zyNF/oOMpCQtuQn+Q6gOtJI4FjfIQYTxJY8SrLNgKfRt82UHwuAaUX9FFwoW/Jj0YIrfzYBDvUdYiClL7n73bYjfOdQHe9o3wEGUvqSAzEwxXcI1fH2ipJsa98h+hNCyQu7BlUd5yjfAfpT6gNvbjTSecAw31mUwh6Am5KncaFKVfYteYwWXBXHJsC/+Q5RrewlP8h3AKWqFG6ZLG3JoyQbBezrO4dSVQ70HaBaaUsOzALG+Q6hVJW3RkkW+Q5RqcwlL9xukVJOoZbNMpf8vb4DKDWAQu2yl/IttCjJdgbu8Z1DqQGsADbI03ix7yBQ3i35/r4DKDWIEcA+vkP0KWvJC/depFJVCrOMlrXkOiqKKrrCLKOlK3mUZJugX0hRxbeT7wB9SldyCrSGVGoQk6Ik28J3CNCSK9VOhVhWteRKtU8hllUtuVLtU4hltVQld98fn+o7h1J1KsTBt1KVHJjuO4BSDZgcJdlE3yHKVvJNfQdQqkHel9m6Sy4iu4vI4e7/G4qIj7cHvD9hSjXI+zJbV8lF5CvAKcCp7qwRwKXtCjUI70+YUg3yvszWuyV/P/Y7sj0Axph5wIR2hRqE9ydMqQZ5X2brLflyY7+TagBExNcvsujHWVXZeF9m6y35FSLyY2A9ETka+CNwcftiDcj7WlGpBnlfZusaP8wY830R2RdYDGwDnGGMuaWtyfrn/QlTqkHel9m6Si4iK4EHK876wSDXjYDfG2NmrFWy/k1u1YReuuEclj55N8PGrsuUIy8AYOXSJbx07XfoXbyQ4RM3ZoP3JQwbPR5jDC/fehFLn7wHGTGKyQd8jlGbbPWGaS5b8ASLsrMxvcsZs+UurD/rGERkwOmqjrCB7wB1vybH/jLqFtgPpDwoIkP60zZRkgktHLl0/Fv3YaMPnrnGeYvvuJLR0Q5MPeZiRkc7sPiOKwF4/al7WNE1jynHXMTk/T5D180X9DvNrpt/yOT3nMiUYy5iRdc8Xn9qzqDTVR1hhO8A9ZZ8FHCQMWZdY8xEY8wE4G0icruI3OtO76i+kYhsLyJ3ich9IvKAiGztzj+s4vwfi0g9o6C09Mka/aYZDBuz5hsErz1xJ+NmzAJg3IxZvPb4Hfb8x+9k/Iy9ERFGTd2WVct66O3uWuO2vd1drFq2lFFTt0VEGD9j79W3H2C6qiOUpuQCXO5KebU77wVgX2PMTsCHgfP6ud1xwLnGmB2BXYDnRGQ7d/3d3PkrgY/XkaHt44+v7HmF4eMnATBs3Pqs7HnFnt+9iGETV+91DZ8wmZVLFq152yWLGD5h9auJYRMms7J70aDTVR2h7cttqwKsAB4FrgGWicghwFhgPxHpK+qb+7ndP4DTRGQz4HfGmMdFZBb22zl3iwjAGOwKo5YhHfNMRJASTVcVlvex+uotuQCvAe+uOG9H4FZgB+wewevVNzLGXCYid2IHJrxBRI5107rEGHNq9fVrWNXg9Rs2bNx69HZ3MXz8JHq7u1hn3Hr2/PGTWbn4pX9dr3fJIoZNWPMY4LAJk+mt2LqvXLKIYeMnDzpd1RHavtzWUu/u+jJjzOGVJ2A2MN8Yswr4BP2ssURkOvCUMeY84FrgbdgVw6EispG7ziQRmVZHhhV1Zm3a2K1m0jP3VgB65t7K2K1mAjBm65l0z/0TxhiWPf8I64wa+6/d7z7Dx09inVFjWPb8Ixhj6J77J8ZuPXPQ6aqO0Pbltpa6t+Tutfhu7u/bgbOBC0Tkk8BNuI+8VvkQ8AkRWYEdu/lbxpguETkduFlE1sE+CScAz9TI0Ftn1rq8eN13WfbPB1m5dDHP/fBTrLv7x5m466G8dG1K9wM3M3ziRmxwcALAmOm7sPTJe5h30dHIcPsWWp95PzuRKYefD8Ckff+DRTe4t9Cm78zo6bsADDhd1RFautw2o64RVETkFuAy4JfurMOAjxtjhnRU0SjJVlK+r8eqzvZQnsbt+MxI3eotzIbGmJ8ZY3rd6efAhm3MNZCXPdynUmujq/ZV2qveki9y720Pc6fDgEU1b9V68z3cp1Jrw/syW2/Jj8C+vl6ADX0ocHi7Qg3C+xOmVIO8L7P1fkHlGYox5vI83wGUapD3ZXbQkovIGYNcbIwxX29xnlq8rxWVapD3ZbbWlry/t8XGAUdivxGmJVdqcN6X2UFLbow5q+//IjIB+Cz2tfivgbMGul0beX/ClGqQ92W25mtyEZkE/Cf2SySXADsZY3y9leX9CVOqQd6X2Vqvyb8HHAJcBLzVGNM9JKkGVutTcUoVSXeext7fJx/0E28isgpYhv1oXuUVBXvgbchHh4iS7CVa+AsxSrXR7Xka7+k7RK3X5EX8COkc1vw2nFJFNcd3ACjn58AL8cQpVYdCLKtacqXapxDLqpZcqfboxv6aknelK3mexjkF+GaPUjXcl6ex91+FgRKW3NGtuSq6wiyjZS35Pb4DKFVDYZbRspb8D74DKDUIA/gYRqxfZS3539DX5aq47srTeKHvEH1KWfI8jXuBG33nUGoA1/kOUKmUJXeu9x1AqQEUatksc8lvpAC/aa1UlafzNH6w9tWGTmlLnqfxYuA23zmUqlKorTiUuORO4Z5Q1fEKt0yWveSFOsChOt6rFHDvstQldx9x/ZvvHEo5V+RpXLjjRKUuuXOR7wBKOYVcFkMo+ZXAK75DqI53X57Ghfkoa6XSlzxP46XApb5zqI53se8AAyl9yZ0LfAdQHW0xq0f8LZwgSp6n8cMU6AsBquP8LE/jJb5DDCSIkjvn+g6gOtIq4HzfIQYTUslvAB73HUJ1nCxP4yd9hxhMMCXP09gAZ/rOoTqKAb7qO0QtwZTcuQy433cI1TGuyNP4Xt8hagmq5G5rfqrvHKojrABO9x2iHkGVHCBP4xsp4OeHVXB+kqfxE75D1CO4kjun+A6ggtYDfM13iHoFWfI8je8ErvadQwXrnDyNF/gOUa8gS+58GVjpO4QKziLgu75DNCLYkudp/Ahwoe8cKjhnuF8lKo1gS+4kQO47hArGbOBHvkM0KuiS52ncDRyB/dCCUmujBzjCvU1bKkGXHCBP4z9TwrWvKpxT8jR+2neIZgRfcudkoJQzSBXCnynx15k7ouR5Gvegu+2qOT3AkWXcTe/TESUHyNN4NiVeGytvTi7rbnqfjim5cwrwsO8QqjRuIoDjOWJMafdCmhIl2dbAncD6vrOoQnsMmJmncel/JLTTtuTkafw48GH003BqYK8CB4VQcOjAkgPkaXwL8EXfOVQhrQI+kqfxo76DtEpHlhwgT+NzgP/xnUMVzsl5Gt/kO0QrdWzJnePRYZbUapfkaXyW7xCt1tElz9N4OXAI8KzvLMq7O4BjfYdoh44uOUCexi8A+wEv+s6ivPk/7IG2Zb6DtEPHlxz+NTjDPkCX7yxqyD0OzMrTONiVvJbcydP4AewW/VXfWdSQeRrYu0y/8tIMLXkFNyrlu9FRUjvBU8C78jR+zneQdtOSV8nT+C5gb+zP/KgwPQrsmafxM76DDAUteT/yNP5fYC9goecoqvXmAu/M0/h530GGipZ8AHkazwXeATzkO4tqmVuxW/COWnlryQeRp/FTwL8D1/vOotba+cB78jR+2XeQodZx30JrRpRk6wDfQIdgKqPlwAl5Gv/EdxBftOQNiJLsI9jPu4/xnUXV5QXgA3ka/9V3EJ+05A2Kkmxn4BpgM99Z1KDuAw7O0/ifvoP4pq/JG5Sn8Rzg7cCffGdRA/oFsJsW3NIteZOiJBPgOOyQOeM9x1HWfODYPI31QGkFLflaipIswr5Of5fnKJ3uUuCkTjx6XouWvAXcVv147FZ9nOc4nWYBdut9ne8gRaUlb6EoybYAfopu1YfKr7Bbb/324CC05C3mtuqfxA5Sv7nnOKF6ADtsUVA/09QuWvI2iZJsFHACdpz0yZ7jhCIH/gu4LE/jVZ6zlIaWvM2iJFsX+BLweWCs5zhl9SL2E4cXup/sUg3Qkg+RKMk2Ac4AjgaGe45TFt3AWcD33TDUqgla8iEWJdmWwOeAT6Pvrw/kBeBC4IfuN/jUWtCSexIl2UTsSKsnAtM9xymKe4Fzgd+E+qOKPmjJPXNH4/fF7sYfDIzwm2jIdQOXAxfnaXy37zAh0pIXSJRkG2HffjsEmEm43y1YDswGrgIu19fb7aUlLyhX+Bg4CLulL/sn6RYBN2B/gOOmPI2XeM7TMbTkJRAl2Wjsj0seBLwXmOo3Ud0eA65zp7/naawjyXqgJS+hKMmmATtXnTbwGgqeA+ZUnjrtt9SKSkseiCjJNmd14d8CbFpxGtmiu3kN+3XO+cA84EFWF1rf6iooLXkHiJJsMmuWfhPsT1gNd6cRgAF63WkF0MPqQs8H5udprKPLlJCWXKnAhfoWjVLK0ZIrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB05IrFTgtuVKB+39L0/HyP27PSgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "((data['participant1'] == data['participant2']) &  data['isValid']).value_counts().plot.pie(autopct='%.2f')\n",
    "plt.title('Self relation - with  true labels ')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "((data['participant1'] != data['participant2']) &  data['isValid']).value_counts().plot.pie(autopct='%.2f')\n",
    "plt.title('Non Self relation - with  true labels ')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.query('isValid == True')[\"docid\"].value_counts().plot.hist(bins=100)\n",
    "plt.title('Number of true labels per docId')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.query('participant1 != participant2')[\"docid\"].value_counts().plot.hist(bins=100)\n",
    "plt.title('Number non-self-related interactions per docid')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEICAYAAABF82P+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4wLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvqOYd8AAAG6lJREFUeJzt3XuYXVWZ5/HvLwnhFiAJKWJIAkHNoNgKxBJjCzQStUloSXoGERshMsFyerDVVkaD7dOgjc8DM8pttBmioUmQqwgmrdhjiGC30xIoIIZ7p4SEpMilDOTCRRB454+9ymyOu6pOVWrXrtT5fZ7nPGfttfblXWdXzpu99uUoIjAzM6s1rOoAzMxscHKCMDOzQk4QZmZWyAnCzMwKOUGYmVkhJwgzMyvkBGGlknStpItKXP9PJc0ta/1lkvSIpBOqjqMskk6QtH4X13GIpOclDe+i/UJJ39+VbVjXnCAajKQ1kjZL2jdXd46kuysMq88iYmZELKpnXkl3Szqn7Ji62PYfJcqIeEdE3F1FPLuLiHg6IkZFxGtVx9KInCAa03Dgc1UH0Vtd/S+yUbY/mEgaUXUMVj4niMb0v4DzJI2ubZA0RVLkvwDy//OW9ElJ/0/SZZK2SnpS0p+m+nXp6KR2yGecpGWSdkj6haRDc+t+W2p7VtITkk7LtV0r6SpJd0h6AfhAQby1sf1S0jclPSfpKUkzU9s3gOOAb6chi2/3ZfuSTpb0oKTtqb8X1sRzrKR/T5/NuhRTC3AG8KW07X9O866R9MFU3lPS5ZKeSa/LJe2Z2k6QtF7SF9Pnu0HS2bltzpL0aPp82yWdV7TTc/vu25K2SXpc0oxc+wGSFqb1t0u6qDMp1uz3LcCFBevfO31mz0l6FHhPTfvb0/7amobXTqlZ9luS1qbYfpnq3vD3KOmw9De0Q9IyYFxRX62fRIRfDfQC1gAfBG4DLkp15wB3p/IUIIARuWXuBs5J5U8CrwJnkx2JXAQ8DXwH2BP4MLADGJXmvzZNH5/arwB+mdr2BdaldY0AjgZ+CxyRW3Yb8H6y/8zsVdCf2th+D3wqxfbXwDOAauft6/aBE4B3pul3AZuAOWn+Q1NfPw7sARwIHJVb10VF+yKVvw7cAxwENAH/DvxDajshfeZfT+udBbwIjEntG4DjUnkMMK2Lfd+57/42redjqX9jU/vtwNXpczkIuBf4dM2yf5M+q70L1n8x8G/AWGAy8DCwPrXtAbQBXwFGAiemz+rw1P6dtH8mpn33p2R/L1PI/T0CvwIuTW3Hp3V8v+p/V0P1VXkAfg3wDt+ZIP4kfTk00fsEsTrX9s40//hc3ZaaL8abcm2jgNfSF8jHgH+rie9q4ILcsot76E9tbG25tn1SbG+qnTdN98f2LwcuS+Xzgdu7mO9auk8QvwFm5dr+HFiTyicAL9Xsk83A9FR+Gvg0sH8PsX6SXMJMdfcCZwLjgZfJffGTJbq7css+3cP6nwROyk23sDNBHAdsBIbl2m8kOxIZlvp3ZME6p6R9OAI4hCxJ7ZtrvwEniNJeHmJqUBHxMPBjYH4fFt+UK7+U1ldbNyo3vS633eeBZ4GDyf7H/d405LBV0layoZg3FS1bp425bb2YiqO6mLfX25f0Xkl3SeqQtA34b+wc5phM9kXfFwcDa3PTa1Ndpy0R8Wpu+kV29uu/kB1VrE3DL+/rZjvtkb5Za7ZzKNn/8jfkPouryY4kOvW0Lw6umWdtbVtEvF7TPpHs89uLnj+7g4HnIuKFLrZh/cwJorFdQDYcMzFX1/mPb59cXf4Lsy8mdxYkjSIbgniG7MvkFxExOvcaFRF/nVu2Px83XLuuvmz/BmApMDkiDgD+D6Dc+t5S57ZrPUP2Jd3pkFTXo4i4LyJmk32Z/wi4pZvZJ0pSbrpzO+vIjiDG5T6L/SPiHb3owwZy+zqtu9MzwGRJw2ra28mG9X5H159dfv1jlLsCr2Yb1s+cIBpYRLQBNwOfzdV1kP2j/YSk4ZL+Kz3/w+3JrHTydiTwD8A9EbGO7AjmP0k6U9Ie6fUeSW/fxe11ZRPw5tx0X7a/H/BsRPxO0jHAX+Xargc+KOk0SSMkHSjpqC62XetG4KuSmiSNA/4e6PH6fkkjJZ0h6YCI+D2wHXi9m0UOAj6b+vpR4O3AHRGxAfgZ8C1J+0saJuktkv6spxhybgHOlzRG0iSy8xWdVpAd9XwpbfsE4CNkw4+vA9cAl0o6OP3dva/zJH2niFgLtAJfS/0+Nq3DSuIEYV8nOymZ9yngf5CdS3gH2QnTXXED2dHKs8C7gU8ARMQOspPap5P9D3MjcAnZCcgyXAGcmq6yubKP2//vwNcl7SD7Ev/D/9Yj4mmyoZ4vkvV1JXBkal4IHJGGb35UsN6LyL78VgEPAQ+kunqcCayRtJ1syOuMbuZdAUwl+1/7N4BTI2JLajuL7ATyo8BzwK3AhDpjAPga2ZDPU2TJ5rrOhoh4hezLfGba9j8CZ0XE42mW88j6fR/ZZ3cJxd9PfwW8N81zAbC4F/FZL3Ve3WFmQ5ykT5KdpD+26lhs9+AjCDMzK+QEYWZmhTzEZGZmhXwEYWZmhXbrB26NGzcupkyZUnUYZma7lfvvv/+3EdHU03y7dYKYMmUKra2tVYdhZrZbkVTXHeilDjFJ+tv01MaHJd0oaa/0NMYVktok3Zxunup8muXNqX6FpCllxmZmZt0rLUFImkh2h25zRPwJ2RMaTye7AeayiHgr2c0489Ii88ies/JW4LI0n5mZVaTsk9QjgL3Ts9z3IXuWyolkd2gCLALmpPLsNE1qn1HzzBgzMxtApSWIiGgHvkn2KOINZI+Wvh/Ymnsq5Xp2PihuIulJkKl9G9nz9N9AUoukVkmtHR0dZYVvZtbwyhxiGkN2VHAY2WN69wVO2tX1RsSCiGiOiOamph5PwpuZWR+VOcT0QeCpiOhIT5m8jeyXuUZr589ZTiJ7cijpfTL84fduDyB7WJyZmVWgzATxNDBd0j7pXMIMsqdE3gWcmuaZCyxJ5aVpmtT+8/Bt3mZmlSnzHMQKspPND5A9xncYsAD4MvAFSW1k5xgWpkUWAgem+i/Qt186MzOzfrJbP4upubk5fKOcmVnvSLo/Ipp7mm+3vpN6V0yZ/5PC+jUXnzzAkZiZDU5+WJ+ZmRVygjAzs0JOEGZmVsgJwszMCjlBmJlZIScIMzMr5ARhZmaFnCDMzKyQE4SZmRVygjAzs0JOEGZmVsgJwszMCjlBmJlZIScIMzMr5ARhZmaFnCDMzKxQaQlC0uGSVuZe2yV9XtJYScskrU7vY9L8knSlpDZJqyRNKys2MzPrWZm/Sf1ERBwVEUcB7wZeBG4n+63p5RExFVjOzt+englMTa8W4KqyYjMzs54N1BDTDOA3EbEWmA0sSvWLgDmpPBtYHJl7gNGSJgxQfGZmVmOgEsTpwI2pPD4iNqTyRmB8Kk8E1uWWWZ/q3kBSi6RWSa0dHR1lxWtm1vBKTxCSRgKnAD+obYuIAKI364uIBRHRHBHNTU1N/RSlmZnVGogjiJnAAxGxKU1v6hw6Su+bU307MDm33KRUZ2ZmFRiIBPFxdg4vASwF5qbyXGBJrv6sdDXTdGBbbijKzMwG2IgyVy5pX+BDwKdz1RcDt0iaB6wFTkv1dwCzgDayK57OLjM2MzPrXqkJIiJeAA6sqdtCdlVT7bwBnFtmPGZmVj/fSW1mZoWcIMzMrJAThJmZFXKCMDOzQk4QZmZWyAnCzMwKOUGYmVkhJwgzMyvkBGFmZoWcIMzMrJAThJmZFXKCMDOzQk4QZmZWyAnCzMwKOUGYmVkhJwgzMyvkBGFmZoWcIMzMrFCpCULSaEm3Snpc0mOS3idprKRlklan9zFpXkm6UlKbpFWSppUZm5mZda/sI4grgH+JiLcBRwKPAfOB5RExFViepgFmAlPTqwW4quTYzMysG6UlCEkHAMcDCwEi4pWI2ArMBhal2RYBc1J5NrA4MvcAoyVNKCs+MzPrXplHEIcBHcA/SXpQ0vck7QuMj4gNaZ6NwPhUngisyy2/PtW9gaQWSa2SWjs6OkoM38yssZWZIEYA04CrIuJo4AV2DicBEBEBRG9WGhELIqI5Ipqbmpr6LVgzM3ujMhPEemB9RKxI07eSJYxNnUNH6X1zam8HJueWn5TqzMysAqUliIjYCKyTdHiqmgE8CiwF5qa6ucCSVF4KnJWuZpoObMsNRZmZ2QAbUfL6/wa4XtJI4EngbLKkdIukecBa4LQ07x3ALKANeDHNa2ZmFSk1QUTESqC5oGlGwbwBnFtmPGZmVj/fSW1mZoWcIMzMrJAThJmZFXKCMDOzQk4QZmZWyAnCzMwKOUGYmVkhJwgzMyvkBGFmZoWcIMzMrJAThJmZFXKCMDOzQk4QZmZWyAnCzMwKOUGYmVkhJwgzMyvkBGFmZoWcIMzMrFCpCULSGkkPSVopqTXVjZW0TNLq9D4m1UvSlZLaJK2SNK3M2MzMrHsDcQTxgYg4KiI6f5t6PrA8IqYCy9M0wExganq1AFcNQGxmZtaFKoaYZgOLUnkRMCdXvzgy9wCjJU2oID4zM6POBCHpnX1cfwA/k3S/pJZUNz4iNqTyRmB8Kk8E1uWWXZ/qamNpkdQqqbWjo6OPYZmZWU9G1DnfP0raE7gWuD4ittW53LER0S7pIGCZpMfzjRERkqL+cCEiFgALAJqbm3u1rJmZ1a+uI4iIOA44A5gM3C/pBkkfqmO59vS+GbgdOAbY1Dl0lN43p9nb0/o7TUp1ZmZWgbrPQUTEauCrwJeBPwOulPS4pP9cNL+kfSXt11kGPgw8DCwF5qbZ5gJLUnkpcFa6mmk6sC03FGVmZgOsriEmSe8CzgZOBpYBH4mIByQdDPwKuK1gsfHA7ZI6t3NDRPyLpPuAWyTNA9YCp6X57wBmAW3Ai2l7ZmZWkXrPQfxv4HvAVyLipc7KiHhG0leLFoiIJ4EjC+q3ADMK6gM4t854zMysZPUmiJOBlyLiNQBJw4C9IuLFiLiutOjMzKwy9Z6DuBPYOze9T6ozM7Mhqt4EsVdEPN85kcr7lBOSmZkNBvUmiBfyz0aS9G7gpW7mNzOz3Vy95yA+D/xA0jOAgDcBHystKjMzq1xdCSIi7pP0NuDwVPVERPy+vLDMzKxq9R5BALwHmJKWmSaJiFhcSlRmZla5em+Uuw54C7ASeC1VB+AEYWY2RNV7BNEMHJFuZjMzswZQ71VMD5OdmDYzswZR7xHEOOBRSfcCL3dWRsQppURlZmaVqzdBXFhmEGZmNvjUe5nrLyQdCkyNiDsl7QMMLzc0MzOrUr0/Ofop4Fbg6lQ1EfhRWUGZmVn16j1JfS7wfmA7/OHHgw4qKygzM6tevQni5Yh4pXNC0giy+yDMzGyIqjdB/ELSV4C9029R/wD45/LCMjOzqtWbIOYDHcBDwKfJfh608JfkakkaLulBST9O04dJWiGpTdLNkkam+j3TdFtqn9LbzpiZWf+pK0FExOsR8d2I+GhEnJrK9Q4xfQ54LDd9CXBZRLwVeA6Yl+rnAc+l+svSfGZmVpF6r2J6StKTta86lptE9nOl30vTAk4kuyIKYBEwJ5Vnp2lS+4w0v5mZVaA3z2LqtBfwUWBsHctdDnwJ2C9NHwhsjYhX0/R6sktmSe/rACLiVUnb0vy/za9QUgvQAnDIIYfUGb6ZmfVWvUNMW3Kv9oi4nOzIoEuS/gLYHBH390eguVgWRERzRDQ3NTX156rNzCyn3sd9T8tNDiM7ouhp2fcDp0iaRXbUsT9wBTBa0oh0FDEJaE/ztwOTgfXpMtoDgC31dsTMzPpXvUNM38qVXwXWAKd1t0BEnA+cDyDpBOC8iDhD0g+AU4GbgLnAkrTI0jT9q9T+cz9e3MysOvU+i+kD/bjNLwM3SboIeBBYmOoXAtdJagOeBU7vx22amVkv1TvE9IXu2iPi0h7a7wbuTuUngWMK5vkd2clvMzMbBHpzFdN7yIaBAD4C3AusLiMoMzOrXr0JYhIwLSJ2AEi6EPhJRHyirMDMzKxa9T5qYzzwSm76lVRnZmZDVL1HEIuBeyXdnqbnsPOuZzMzG4LqvYrpG5J+ChyXqs6OiAfLC8vMzKpW7xATwD7A9oi4guxmtsNKisnMzAaBeh/WdwHZ/Qvnp6o9gO+XFZSZmVWv3iOIvwROAV4AiIhn2PkAPjMzG4LqTRCvpMdeBICkfcsLyczMBoN6E8Qtkq4me9Dep4A7ge+WF5aZmVWt3quYvpl+i3o7cDjw9xGxrNTIzMysUj0mCEnDgTvTA/ucFMzMGkSPQ0wR8RrwuqQDBiAeMzMbJOq9k/p54CFJy0hXMgFExGdLicrMzCpXb4K4Lb3MzKxBdJsgJB0SEU9HhJ+7ZGbWYHo6B/GjzoKkH5Yci5mZDSI9JQjlym8uMxAzMxtcekoQ0UW5R5L2knSvpF9LekTS11L9YZJWSGqTdLOkkal+zzTdltqn9GZ7ZmbWv3pKEEdK2i5pB/CuVN4uaYek7T0s+zJwYkQcCRwFnCRpOnAJcFlEvBV4DpiX5p8HPJfqL0vzmZlZRbpNEBExPCL2j4j9ImJEKndO79/DshERz6fJPdIrgBOBW1P9IrIfHwKYzc4fIboVmCEpP8RlZmYDqDe/B9FrkoZLWglsJrsL+zfA1oh4Nc2yHpiYyhOBdQCpfRtwYME6WyS1Smrt6OgoM3wzs4ZWaoKIiNci4ihgEnAM8LZ+WOeCiGiOiOampqZdjtHMzIqVmiA6RcRW4C7gfWRPhO28/2IS0J7K7cBkgNR+ALBlIOIzM7M/VlqCkNQkaXQq7w18CHiMLFGcmmabCyxJ5aVpmtT+8/QbFGZmVoF6H7XRFxOARelpsMOAWyLix5IeBW6SdBHwILAwzb8QuE5SG/AscHqJsZmZWQ9KSxARsQo4uqD+SbLzEbX1vwM+WlY8ZmbWOwNyDsLMzHY/ThBmZlbICcLMzAo5QZiZWSEnCDMzK+QEYWZmhZwgzMyskBOEmZkVcoIwM7NCThBmZlbICcLMzAo5QZiZWSEnCDMzK+QEYWZmhZwgzMyskBOEmZkVcoIwM7NCZf4m9WRJd0l6VNIjkj6X6sdKWiZpdXofk+ol6UpJbZJWSZpWVmxmZtazMo8gXgW+GBFHANOBcyUdAcwHlkfEVGB5mgaYCUxNrxbgqhJjMzOzHpSWICJiQ0Q8kMo7gMeAicBsYFGabREwJ5VnA4sjcw8wWtKEsuIzM7PuDcg5CElTgKOBFcD4iNiQmjYC41N5IrAut9j6VGdmZhUoPUFIGgX8EPh8RGzPt0VEANHL9bVIapXU2tHR0Y+RmplZXqkJQtIeZMnh+oi4LVVv6hw6Su+bU307MDm3+KRU9wYRsSAimiOiuampqbzgzcwaXJlXMQlYCDwWEZfmmpYCc1N5LrAkV39WupppOrAtNxRlZmYDbESJ634/cCbwkKSVqe4rwMXALZLmAWuB01LbHcAsoA14ETi7xNjMzKwHpSWIiPgloC6aZxTMH8C5ZcVjZma94zupzcyskBOEmZkVcoIwM7NCThBmZlbICcLMzAo5QZiZWSEnCDMzK+QEYWZmhcq8k3q3NGX+Twrr11x88gBHYmZWLR9BmJlZIScIMzMr5ARhZmaFnCDMzKyQE4SZmRVygjAzs0JOEGZmVsgJwszMCjlBmJlZodIShKRrJG2W9HCubqykZZJWp/cxqV6SrpTUJmmVpGllxWVmZvUp8wjiWuCkmrr5wPKImAosT9MAM4Gp6dUCXFViXGZmVofSEkRE/CvwbE31bGBRKi8C5uTqF0fmHmC0pAllxWZmZj0b6HMQ4yNiQypvBMan8kRgXW6+9anuj0hqkdQqqbWjo6O8SM3MGlxlJ6kjIoDow3ILIqI5IpqbmppKiMzMzGDgH/e9SdKEiNiQhpA2p/p2YHJuvkmpbtDo6jHg4EeBm9nQNNBHEEuBuak8F1iSqz8rXc00HdiWG4oyM7MKlHYEIelG4ARgnKT1wAXAxcAtkuYBa4HT0ux3ALOANuBF4Oyy4jIzs/qUliAi4uNdNM0omDeAc8uKxczMes93UpuZWSEnCDMzKzTQVzENSV1d4eSrm8xsd+YjCDMzK+QEYWZmhZwgzMyskBOEmZkVcoIwM7NCThBmZlbICcLMzAo5QZiZWSEnCDMzK+Q7qSvgO6/NbHfgIwgzMyvkBGFmZoWcIMzMrJAThJmZFfJJ6kHEJ6/NbDAZVAlC0knAFcBw4HsRcXHFIQ1qTihmVqZBkyAkDQe+A3wIWA/cJ2lpRDxabWRDhxOKmfXGoEkQwDFAW0Q8CSDpJmA24ARRkf5MKL1dl5OZWfUUEVXHAICkU4GTIuKcNH0m8N6I+EzNfC1AS5o8HHiiD5sbB/x2F8Ld3TRaf6Hx+txo/YXG63N/9vfQiGjqaabBdARRl4hYACzYlXVIao2I5n4KadBrtP5C4/W50foLjdfnKvo7mC5zbQcm56YnpTozM6vAYEoQ9wFTJR0maSRwOrC04pjMzBrWoBliiohXJX0G+L9kl7leExGPlLS5XRqi2g01Wn+h8frcaP2FxuvzgPd30JykNjOzwWUwDTGZmdkg4gRhZmaFGi5BSDpJ0hOS2iTNrzqeMkhaI+khSSsltaa6sZKWSVqd3sdUHeeukHSNpM2SHs7VFfZRmSvTPl8laVp1kfdNF/29UFJ72s8rJc3KtZ2f+vuEpD+vJuq+kzRZ0l2SHpX0iKTPpfohuY+76W+1+zgiGuZFdvL7N8CbgZHAr4Ejqo6rhH6uAcbV1P1PYH4qzwcuqTrOXezj8cA04OGe+gjMAn4KCJgOrKg6/n7q74XAeQXzHpH+tvcEDkt/88Or7kMv+zsBmJbK+wH/kfo1JPdxN/2tdB832hHEHx7nERGvAJ2P82gEs4FFqbwImFNhLLssIv4VeLamuqs+zgYWR+YeYLSkCQMTaf/oor9dmQ3cFBEvR8RTQBvZ3/5uIyI2RMQDqbwDeAyYyBDdx930tysDso8bLUFMBNblptfT/U7YXQXwM0n3p0eTAIyPiA2pvBEYX01opeqqj0N5v38mDalckxs2HFL9lTQFOBpYQQPs45r+QoX7uNESRKM4NiKmATOBcyUdn2+M7Bh1SF/f3Ah9BK4C3gIcBWwAvlVtOP1P0ijgh8DnI2J7vm0o7uOC/la6jxstQTTE4zwioj29bwZuJzv03NR5yJ3eN1cXYWm66uOQ3O8RsSkiXouI14HvsnOIYUj0V9IeZF+W10fEbal6yO7jov5WvY8bLUEM+cd5SNpX0n6dZeDDwMNk/ZybZpsLLKkmwlJ11celwFnpSpfpwLbcMMVuq2aM/S/J9jNk/T1d0p6SDgOmAvcOdHy7QpKAhcBjEXFprmlI7uOu+lv5Pq767P1Av8iudvgPsrP+f1d1PCX0781kVzf8Gniks4/AgcByYDVwJzC26lh3sZ83kh1y/55s/HVeV30ku7LlO2mfPwQ0Vx1/P/X3utSfVekLY0Ju/r9L/X0CmFl1/H3o77Fkw0ergJXpNWuo7uNu+lvpPvajNszMrFCjDTGZmVmdnCDMzKyQE4SZmRVygjAzs0JOEGZmVsgJwszMCjlBmJlZof8PE8d+9tWxQ/YAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "data[\"docid\"].value_counts().plot.hist(bins=50)\n",
    "plt.title('Number interactions per docid')\n",
    "plt.show()"
   ]
  }
 ],
 "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}