s14_01_no_sql.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "857001a9",
   "metadata": {},
   "source": [
    "$~$\n",
    "\n",
    "# IT Academy - Data Science Itinerary\n",
    "\n",
    "\n",
    "\n",
    "$~$"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4bdf91f7",
   "metadata": {},
   "source": [
    "$~$\n",
    "\n",
    "+ Here, we are going to create, as an example, a database in Mongodb, we will call it **\"mydatabase\".**, Once we have the database created in MongoDB, we are going to connect to it using python.\n",
    "\n",
    "+ We will add records. The data is synthetic, we have created it using a [data generator](https://mockaroo.com/)\n",
    "\n",
    "+ finally we will perform some queries and the results will be passed to pandas dataframe\n",
    "\n",
    "$~$"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ad6e86cc",
   "metadata": {},
   "source": [
    "## S14 T01: Create NoSQL database\n",
    "___\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "343f71ef",
   "metadata": {},
   "outputs": [],
   "source": [
    "#importing libraries\n",
    "import pymongo\n",
    "from pymongo import MongoClient\n",
    "import requests\n",
    "import pprint \n",
    "import re\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7557656a",
   "metadata": {},
   "source": [
    "$~$\n",
    "___\n",
    "####  Exercise 1\n",
    "\n",
    "$~$\n",
    "\n",
    "Create a NoSQL database using MongoDB. Add some sample data to help you verify that you are able to process the information in a basic way.\n",
    "\n",
    "$~$\n",
    "___"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a183aa21",
   "metadata": {},
   "source": [
    "$~$\n",
    "\n",
    "let's create a database called \"mydatabase\". To do this, the first thing we have to do is enter our **MongoDb account**. \n",
    "$~$\n",
    "\n",
    "There we are going to create the database, and we are going to create a collection called \"our_clients\"\n",
    "\n",
    "$~$"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1853f057",
   "metadata": {},
   "source": [
    "<p align=\"center\">\n",
    "  <img width=\"80%\" src=./image1.png>\n",
    "</p>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "daf97b90",
   "metadata": {},
   "source": [
    "$~$\n",
    "\n",
    "The next step will be to add a document to our database, as an example we have created a document, as you can see in the following image:"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "35be5d0e",
   "metadata": {},
   "source": [
    "<p align=\"center\">\n",
    "  <img width=\"70%\" src=./image2.png>\n",
    "</p>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "91f42471",
   "metadata": {},
   "source": [
    "$~$\n",
    "___\n",
    "####  Exercise 2\n",
    "\n",
    "$~$\n",
    "\n",
    "Connect the NoSQL database to Python using for example pymongo.\n",
    "\n",
    "$~$\n",
    "___"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "48f6641b",
   "metadata": {},
   "source": [
    "$~$\n",
    "\n",
    "To connect we follow the indications that Mongodb indicates, as you can see in the following image:\n",
    "\n",
    "$~$\n",
    "\n",
    "<p align=\"center\">\n",
    "  <img width=\"50%\" src=./image3.png>\n",
    "</p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f3226efa",
   "metadata": {},
   "outputs": [],
   "source": [
    "#declare a cluster\n",
    "cluster = \"mongodb+srv://*****:********@cluster0.7yfabwb.mongodb.net/?retryWrites=true&w=majority\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "9c68976e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# client conect to our database\n",
    "client = MongoClient(cluster)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "16c20cb2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['mydatabase', 'admin', 'local']\n"
     ]
    }
   ],
   "source": [
    "#print the list of database in my mongodb \n",
    "print(client.list_database_names())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "51105ef3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['our_clients']\n"
     ]
    }
   ],
   "source": [
    "#print colletions \n",
    "db = client.mydatabase\n",
    "print(db.list_collection_names())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a3fd1603",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1\n"
     ]
    }
   ],
   "source": [
    "#how many documents are in our database\n",
    "print(db.our_clients.count_documents({}))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ed7aff4e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'_id': ObjectId('62aa047c41fa7b0a9026aefd'),\n",
      " 'first_name': 'Nicolas',\n",
      " 'last_name': 'Pavelka',\n",
      " 'email': 'npavelka4@oakley.com',\n",
      " 'gender': 'Male',\n",
      " 'conections': 85,\n",
      " 'country': 'Austria'}\n"
     ]
    }
   ],
   "source": [
    "#print the document that is in our database\n",
    "pprint.pp(db.our_clients.find_one({}))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0da758a2",
   "metadata": {},
   "source": [
    "$~$\n",
    "\n",
    "As can be verified, we have connected to the database and we see the document that we had previously created in mongoDB\n",
    "\n",
    "$~$\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "89ba0759",
   "metadata": {},
   "source": [
    "$~$\n",
    "\n",
    "we are going to insert new documents to our database, for this we have generated synthetic data using [this data generator](https://mockaroo.com/)\n",
    "\n",
    "$~$\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "29a18089",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = [{\n",
    "  \"first_name\": \"Libbie\",\n",
    "  \"last_name\": \"Sykes\",\n",
    "  \"email\": \"lsykes0@wufoo.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 18,\n",
    "  \"country\": \"Kenya\"\n",
    "}, {\n",
    "  \"first_name\": \"Jobyna\",\n",
    "  \"last_name\": \"Fontelles\",\n",
    "  \"email\": \"jfontelles1@blog.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 86,\n",
    "  \"country\": \"Brazil\"\n",
    "}, {\n",
    "  \"first_name\": \"Estele\",\n",
    "  \"last_name\": \"Egre\",\n",
    "  \"email\": \"eegre2@goo.gl\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 14,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Yvor\",\n",
    "  \"last_name\": \"Rubinsohn\",\n",
    "  \"email\": \"yrubinsohn3@gnu.org\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 23,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Dur\",\n",
    "  \"last_name\": \"Keppe\",\n",
    "  \"email\": \"dkeppe5@ehow.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 74,\n",
    "  \"country\": \"Nicaragua\"\n",
    "}, {\n",
    "  \"first_name\": \"Natalya\",\n",
    "  \"last_name\": \"Sturney\",\n",
    "  \"email\": \"nsturney6@1und1.de\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 63,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Sande\",\n",
    "  \"last_name\": \"Paszek\",\n",
    "  \"email\": \"spaszek7@sourceforge.net\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 65,\n",
    "  \"country\": \"Benin\"\n",
    "}, {\n",
    "  \"first_name\": \"Gardner\",\n",
    "  \"last_name\": \"Jiggins\",\n",
    "  \"email\": \"gjiggins8@theglobeandmail.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 7,\n",
    "  \"country\": \"Canada\"\n",
    "}, {\n",
    "  \"first_name\": \"Lyell\",\n",
    "  \"last_name\": \"Iuorio\",\n",
    "  \"email\": \"liuorio9@noaa.gov\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 46,\n",
    "  \"country\": \"Czech Republic\"\n",
    "}, {\n",
    "  \"first_name\": \"Baxter\",\n",
    "  \"last_name\": \"Sieghard\",\n",
    "  \"email\": \"bsiegharda@sogou.com\",\n",
    "  \"gender\": \"Polygender\",\n",
    "  \"conections\": 10,\n",
    "  \"country\": \"Colombia\"\n",
    "}, {\n",
    "  \"first_name\": \"Jillian\",\n",
    "  \"last_name\": \"Windle\",\n",
    "  \"email\": \"jwindleb@soup.io\",\n",
    "  \"gender\": \"Polygender\",\n",
    "  \"conections\": 54,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Merola\",\n",
    "  \"last_name\": \"Esbrook\",\n",
    "  \"email\": \"mesbrookc@cbsnews.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 50,\n",
    "  \"country\": \"Brazil\"\n",
    "}, {\n",
    "  \"first_name\": \"Lynna\",\n",
    "  \"last_name\": \"Moatt\",\n",
    "  \"email\": \"lmoattd@pinterest.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 22,\n",
    "  \"country\": \"Myanmar\"\n",
    "}, {\n",
    "  \"first_name\": \"Brander\",\n",
    "  \"last_name\": \"Adamsson\",\n",
    "  \"email\": \"badamssone@devhub.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 71,\n",
    "  \"country\": \"Philippines\"\n",
    "}, {\n",
    "  \"first_name\": \"Tim\",\n",
    "  \"last_name\": \"Harston\",\n",
    "  \"email\": \"tharstonf@kickstarter.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 17,\n",
    "  \"country\": \"Finland\"\n",
    "}, {\n",
    "  \"first_name\": \"Benoite\",\n",
    "  \"last_name\": \"Jaher\",\n",
    "  \"email\": \"bjaherg@wufoo.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 30,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Pamelina\",\n",
    "  \"last_name\": \"Tidcombe\",\n",
    "  \"email\": \"ptidcombeh@kickstarter.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 76,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Marilin\",\n",
    "  \"last_name\": \"Howarth\",\n",
    "  \"email\": \"mhowarthi@technorati.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 79,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Mehetabel\",\n",
    "  \"last_name\": \"Povlsen\",\n",
    "  \"email\": \"mpovlsenj@mapy.cz\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 80,\n",
    "  \"country\": \"Palestinian Territory\"\n",
    "}, {\n",
    "  \"first_name\": \"Joey\",\n",
    "  \"last_name\": \"Mickan\",\n",
    "  \"email\": \"jmickank@seesaa.net\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 75,\n",
    "  \"country\": \"France\"\n",
    "}, {\n",
    "  \"first_name\": \"Tessi\",\n",
    "  \"last_name\": \"Rossant\",\n",
    "  \"email\": \"trossantl@blogs.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 7,\n",
    "  \"country\": \"Iran\"\n",
    "}, {\n",
    "  \"first_name\": \"Adaline\",\n",
    "  \"last_name\": \"Breslane\",\n",
    "  \"email\": \"abreslanem@merriam-webster.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 90,\n",
    "  \"country\": \"France\"\n",
    "}, {\n",
    "  \"first_name\": \"Redd\",\n",
    "  \"last_name\": \"Pachmann\",\n",
    "  \"email\": \"rpachmannn@ebay.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 16,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Georgie\",\n",
    "  \"last_name\": \"Cater\",\n",
    "  \"email\": \"gcatero@nymag.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 71,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Lane\",\n",
    "  \"last_name\": \"McInnery\",\n",
    "  \"email\": \"lmcinneryp@google.com.br\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 43,\n",
    "  \"country\": \"Madagascar\"\n",
    "}, {\n",
    "  \"first_name\": \"Orazio\",\n",
    "  \"last_name\": \"O'Noulane\",\n",
    "  \"email\": \"oonoulaneq@opensource.org\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 50,\n",
    "  \"country\": \"Brazil\"\n",
    "}, {\n",
    "  \"first_name\": \"Whit\",\n",
    "  \"last_name\": \"Castleman\",\n",
    "  \"email\": \"wcastlemanr@seattletimes.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 67,\n",
    "  \"country\": \"Mexico\"\n",
    "}, {\n",
    "  \"first_name\": \"Gareth\",\n",
    "  \"last_name\": \"Mollon\",\n",
    "  \"email\": \"gmollons@nyu.edu\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 98,\n",
    "  \"country\": \"South Africa\"\n",
    "}, {\n",
    "  \"first_name\": \"Garfield\",\n",
    "  \"last_name\": \"Licciardi\",\n",
    "  \"email\": \"glicciardit@theguardian.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 85,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Dicky\",\n",
    "  \"last_name\": \"Peregrine\",\n",
    "  \"email\": \"dperegrineu@privacy.gov.au\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 54,\n",
    "  \"country\": \"Colombia\"\n",
    "}, {\n",
    "  \"first_name\": \"Hobey\",\n",
    "  \"last_name\": \"Raveau\",\n",
    "  \"email\": \"hraveauv@elegantthemes.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 9,\n",
    "  \"country\": \"Russia\"\n",
    "}, {\n",
    "  \"first_name\": \"Dede\",\n",
    "  \"last_name\": \"Tinklin\",\n",
    "  \"email\": \"dtinklinw@joomla.org\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 66,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Starlin\",\n",
    "  \"last_name\": \"De la Yglesias\",\n",
    "  \"email\": \"sdelayglesiasx@oracle.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 73,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Chelsie\",\n",
    "  \"last_name\": \"Creffield\",\n",
    "  \"email\": \"ccreffieldy@google.co.jp\",\n",
    "  \"gender\": \"Genderqueer\",\n",
    "  \"conections\": 37,\n",
    "  \"country\": \"Sweden\"\n",
    "}, {\n",
    "  \"first_name\": \"Jamie\",\n",
    "  \"last_name\": \"Garrand\",\n",
    "  \"email\": \"jgarrandz@macromedia.com\",\n",
    "  \"gender\": \"Bigender\",\n",
    "  \"conections\": 40,\n",
    "  \"country\": \"Ireland\"\n",
    "}, {\n",
    "  \"first_name\": \"Miranda\",\n",
    "  \"last_name\": \"Hoggin\",\n",
    "  \"email\": \"mhoggin10@thetimes.co.uk\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 60,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Ferdie\",\n",
    "  \"last_name\": \"McAlarney\",\n",
    "  \"email\": \"fmcalarney11@wix.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 13,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Petronille\",\n",
    "  \"last_name\": \"Spraggs\",\n",
    "  \"email\": \"pspraggs12@youtu.be\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 79,\n",
    "  \"country\": \"Ecuador\"\n",
    "}, {\n",
    "  \"first_name\": \"Gabie\",\n",
    "  \"last_name\": \"Stilliard\",\n",
    "  \"email\": \"gstilliard13@patch.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 51,\n",
    "  \"country\": \"Ecuador\"\n",
    "}, {\n",
    "  \"first_name\": \"Nisse\",\n",
    "  \"last_name\": \"Ruusa\",\n",
    "  \"email\": \"nruusa14@vk.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 74,\n",
    "  \"country\": \"United States\"\n",
    "}, {\n",
    "  \"first_name\": \"Sheridan\",\n",
    "  \"last_name\": \"Picford\",\n",
    "  \"email\": \"spicford15@google.com\",\n",
    "  \"gender\": \"Agender\",\n",
    "  \"conections\": 89,\n",
    "  \"country\": \"Greece\"\n",
    "}, {\n",
    "  \"first_name\": \"Kayne\",\n",
    "  \"last_name\": \"Paraman\",\n",
    "  \"email\": \"kparaman16@webmd.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 80,\n",
    "  \"country\": \"Russia\"\n",
    "}, {\n",
    "  \"first_name\": \"Ilene\",\n",
    "  \"last_name\": \"Alvarez\",\n",
    "  \"email\": \"ialvarez17@nydailynews.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 2,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Fergus\",\n",
    "  \"last_name\": \"Abrahamsson\",\n",
    "  \"email\": \"fabrahamsson18@odnoklassniki.ru\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 85,\n",
    "  \"country\": \"Gambia\"\n",
    "}, {\n",
    "  \"first_name\": \"Rickie\",\n",
    "  \"last_name\": \"Stannion\",\n",
    "  \"email\": \"rstannion19@sphinn.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 82,\n",
    "  \"country\": \"France\"\n",
    "}, {\n",
    "  \"first_name\": \"Berna\",\n",
    "  \"last_name\": \"Maslen\",\n",
    "  \"email\": \"bmaslen1a@blogtalkradio.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 86,\n",
    "  \"country\": \"Israel\"\n",
    "}, {\n",
    "  \"first_name\": \"Brigitta\",\n",
    "  \"last_name\": \"Stockwell\",\n",
    "  \"email\": \"bstockwell1b@soup.io\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 12,\n",
    "  \"country\": \"Venezuela\"\n",
    "}, {\n",
    "  \"first_name\": \"Sherrie\",\n",
    "  \"last_name\": \"Dumini\",\n",
    "  \"email\": \"sdumini1c@360.cn\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 15,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Nannette\",\n",
    "  \"last_name\": \"Willbraham\",\n",
    "  \"email\": \"nwillbraham1d@github.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 5,\n",
    "  \"country\": \"Czech Republic\"\n",
    "}, {\n",
    "  \"first_name\": \"Madonna\",\n",
    "  \"last_name\": \"Marjanovic\",\n",
    "  \"email\": \"mmarjanovic1e@google.de\",\n",
    "  \"gender\": \"Non-binary\",\n",
    "  \"conections\": 82,\n",
    "  \"country\": \"United States\"\n",
    "}, {\n",
    "  \"first_name\": \"Dominga\",\n",
    "  \"last_name\": \"Beazleigh\",\n",
    "  \"email\": \"dbeazleigh1f@hp.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 9,\n",
    "  \"country\": \"Namibia\"\n",
    "}, {\n",
    "  \"first_name\": \"Paten\",\n",
    "  \"last_name\": \"Hardison\",\n",
    "  \"email\": \"phardison1g@dropbox.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 45,\n",
    "  \"country\": \"Guatemala\"\n",
    "}, {\n",
    "  \"first_name\": \"Jess\",\n",
    "  \"last_name\": \"Mumm\",\n",
    "  \"email\": \"jmumm1h@cargocollective.com\",\n",
    "  \"gender\": \"Genderqueer\",\n",
    "  \"conections\": 2,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Elana\",\n",
    "  \"last_name\": \"Rudgerd\",\n",
    "  \"email\": \"erudgerd1i@4shared.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 75,\n",
    "  \"country\": \"France\"\n",
    "}, {\n",
    "  \"first_name\": \"Sky\",\n",
    "  \"last_name\": \"Fetter\",\n",
    "  \"email\": \"sfetter1j@aol.com\",\n",
    "  \"gender\": \"Genderfluid\",\n",
    "  \"conections\": 59,\n",
    "  \"country\": \"Poland\"\n",
    "}, {\n",
    "  \"first_name\": \"Basile\",\n",
    "  \"last_name\": \"Yearsley\",\n",
    "  \"email\": \"byearsley1k@europa.eu\",\n",
    "  \"gender\": \"Agender\",\n",
    "  \"conections\": 70,\n",
    "  \"country\": \"Philippines\"\n",
    "}, {\n",
    "  \"first_name\": \"Bentlee\",\n",
    "  \"last_name\": \"Sickling\",\n",
    "  \"email\": \"bsickling1l@pen.io\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 98,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Seline\",\n",
    "  \"last_name\": \"Machel\",\n",
    "  \"email\": \"smachel1m@twitter.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 68,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Andrus\",\n",
    "  \"last_name\": \"Banaszkiewicz\",\n",
    "  \"email\": \"abanaszkiewicz1n@shareasale.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 33,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Haily\",\n",
    "  \"last_name\": \"Pulfer\",\n",
    "  \"email\": \"hpulfer1o@vk.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 62,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Cullin\",\n",
    "  \"last_name\": \"Cudihy\",\n",
    "  \"email\": \"ccudihy1p@list-manage.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 17,\n",
    "  \"country\": \"Norway\"\n",
    "}, {\n",
    "  \"first_name\": \"Baillie\",\n",
    "  \"last_name\": \"Alenichev\",\n",
    "  \"email\": \"balenichev1q@angelfire.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 30,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Cletis\",\n",
    "  \"last_name\": \"Upton\",\n",
    "  \"email\": \"cupton1r@discuz.net\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 36,\n",
    "  \"country\": \"Portugal\"\n",
    "}, {\n",
    "  \"first_name\": \"Roobbie\",\n",
    "  \"last_name\": \"Spellman\",\n",
    "  \"email\": \"rspellman1s@wsj.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 38,\n",
    "  \"country\": \"Russia\"\n",
    "}, {\n",
    "  \"first_name\": \"Cody\",\n",
    "  \"last_name\": \"Jacobovitch\",\n",
    "  \"email\": \"cjacobovitch1t@spiegel.de\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 81,\n",
    "  \"country\": \"Armenia\"\n",
    "}, {\n",
    "  \"first_name\": \"Ellery\",\n",
    "  \"last_name\": \"Clutterham\",\n",
    "  \"email\": \"eclutterham1u@ibm.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 64,\n",
    "  \"country\": \"Finland\"\n",
    "}, {\n",
    "  \"first_name\": \"Lauri\",\n",
    "  \"last_name\": \"Aldridge\",\n",
    "  \"email\": \"laldridge1v@netvibes.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 75,\n",
    "  \"country\": \"United States\"\n",
    "}, {\n",
    "  \"first_name\": \"Alessandro\",\n",
    "  \"last_name\": \"Rockhall\",\n",
    "  \"email\": \"arockhall1w@marketwatch.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 16,\n",
    "  \"country\": \"Philippines\"\n",
    "}, {\n",
    "  \"first_name\": \"Dewie\",\n",
    "  \"last_name\": \"Boys\",\n",
    "  \"email\": \"dboys1x@printfriendly.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 23,\n",
    "  \"country\": \"Ukraine\"\n",
    "}, {\n",
    "  \"first_name\": \"Mitchael\",\n",
    "  \"last_name\": \"Hablet\",\n",
    "  \"email\": \"mhablet1y@google.nl\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 15,\n",
    "  \"country\": \"Poland\"\n",
    "}, {\n",
    "  \"first_name\": \"Goddard\",\n",
    "  \"last_name\": \"Inger\",\n",
    "  \"email\": \"ginger1z@etsy.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 38,\n",
    "  \"country\": \"South Africa\"\n",
    "}, {\n",
    "  \"first_name\": \"Carmelia\",\n",
    "  \"last_name\": \"Merrikin\",\n",
    "  \"email\": \"cmerrikin20@hc360.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 10,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Christine\",\n",
    "  \"last_name\": \"De la Eglise\",\n",
    "  \"email\": \"cdelaeglise21@sitemeter.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 93,\n",
    "  \"country\": \"Lithuania\"\n",
    "}, {\n",
    "  \"first_name\": \"Arte\",\n",
    "  \"last_name\": \"Delamaine\",\n",
    "  \"email\": \"adelamaine22@biglobe.ne.jp\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 18,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Annissa\",\n",
    "  \"last_name\": \"Bendix\",\n",
    "  \"email\": \"abendix23@etsy.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 18,\n",
    "  \"country\": \"Poland\"\n",
    "}, {\n",
    "  \"first_name\": \"Barbaraanne\",\n",
    "  \"last_name\": \"Calbrathe\",\n",
    "  \"email\": \"bcalbrathe24@cdbaby.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 84,\n",
    "  \"country\": \"Portugal\"\n",
    "}, {\n",
    "  \"first_name\": \"Antonina\",\n",
    "  \"last_name\": \"Clarkin\",\n",
    "  \"email\": \"aclarkin25@omniture.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 6,\n",
    "  \"country\": \"Czech Republic\"\n",
    "}, {\n",
    "  \"first_name\": \"Norman\",\n",
    "  \"last_name\": \"Ebdin\",\n",
    "  \"email\": \"nebdin26@usatoday.com\",\n",
    "  \"gender\": \"Agender\",\n",
    "  \"conections\": 53,\n",
    "  \"country\": \"Venezuela\"\n",
    "}, {\n",
    "  \"first_name\": \"Caesar\",\n",
    "  \"last_name\": \"Hasling\",\n",
    "  \"email\": \"chasling27@hp.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 2,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Webb\",\n",
    "  \"last_name\": \"Bloss\",\n",
    "  \"email\": \"wbloss28@alexa.com\",\n",
    "  \"gender\": \"Non-binary\",\n",
    "  \"conections\": 68,\n",
    "  \"country\": \"Russia\"\n",
    "}, {\n",
    "  \"first_name\": \"Lucius\",\n",
    "  \"last_name\": \"De Winton\",\n",
    "  \"email\": \"ldewinton29@plala.or.jp\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 97,\n",
    "  \"country\": \"Nepal\"\n",
    "}, {\n",
    "  \"first_name\": \"Parnell\",\n",
    "  \"last_name\": \"MacCosto\",\n",
    "  \"email\": \"pmaccosto2a@about.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 30,\n",
    "  \"country\": \"Ireland\"\n",
    "}, {\n",
    "  \"first_name\": \"Skipper\",\n",
    "  \"last_name\": \"Meggison\",\n",
    "  \"email\": \"smeggison2b@psu.edu\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 48,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Evin\",\n",
    "  \"last_name\": \"Durrett\",\n",
    "  \"email\": \"edurrett2c@reuters.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 8,\n",
    "  \"country\": \"Brazil\"\n",
    "}, {\n",
    "  \"first_name\": \"Evvy\",\n",
    "  \"last_name\": \"Tremouille\",\n",
    "  \"email\": \"etremouille2d@dailymotion.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 97,\n",
    "  \"country\": \"Brazil\"\n",
    "}, {\n",
    "  \"first_name\": \"Bathsheba\",\n",
    "  \"last_name\": \"Delacroux\",\n",
    "  \"email\": \"bdelacroux2e@arizona.edu\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 77,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Gillie\",\n",
    "  \"last_name\": \"Fitzpayn\",\n",
    "  \"email\": \"gfitzpayn2f@tmall.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 5,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Callida\",\n",
    "  \"last_name\": \"Hazeup\",\n",
    "  \"email\": \"chazeup2g@myspace.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 26,\n",
    "  \"country\": \"Brazil\"\n",
    "}, {\n",
    "  \"first_name\": \"Amory\",\n",
    "  \"last_name\": \"Pembridge\",\n",
    "  \"email\": \"apembridge2h@paginegialle.it\",\n",
    "  \"gender\": \"Genderfluid\",\n",
    "  \"conections\": 43,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Ruben\",\n",
    "  \"last_name\": \"Ellicock\",\n",
    "  \"email\": \"rellicock2i@nba.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 50,\n",
    "  \"country\": \"Sweden\"\n",
    "}, {\n",
    "  \"first_name\": \"Mollee\",\n",
    "  \"last_name\": \"Grievson\",\n",
    "  \"email\": \"mgrievson2j@bizjournals.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 14,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Corrina\",\n",
    "  \"last_name\": \"Carvil\",\n",
    "  \"email\": \"ccarvil2k@google.co.uk\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 59,\n",
    "  \"country\": \"Sweden\"\n",
    "}, {\n",
    "  \"first_name\": \"Barbee\",\n",
    "  \"last_name\": \"Itzakovitz\",\n",
    "  \"email\": \"bitzakovitz2l@homestead.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 55,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Julissa\",\n",
    "  \"last_name\": \"Thexton\",\n",
    "  \"email\": \"jthexton2m@ning.com\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 41,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Vassily\",\n",
    "  \"last_name\": \"Koppelmann\",\n",
    "  \"email\": \"vkoppelmann2n@omniture.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 47,\n",
    "  \"country\": \"Bosnia and Herzegovina\"\n",
    "}, {\n",
    "  \"first_name\": \"Wally\",\n",
    "  \"last_name\": \"Conachy\",\n",
    "  \"email\": \"wconachy2o@imageshack.us\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 45,\n",
    "  \"country\": \"Indonesia\"\n",
    "}, {\n",
    "  \"first_name\": \"Conni\",\n",
    "  \"last_name\": \"Butterfill\",\n",
    "  \"email\": \"cbutterfill2p@columbia.edu\",\n",
    "  \"gender\": \"Female\",\n",
    "  \"conections\": 46,\n",
    "  \"country\": \"Vietnam\"\n",
    "}, {\n",
    "  \"first_name\": \"Armstrong\",\n",
    "  \"last_name\": \"Kondratovich\",\n",
    "  \"email\": \"akondratovich2q@microsoft.com\",\n",
    "  \"gender\": \"Male\",\n",
    "  \"conections\": 33,\n",
    "  \"country\": \"China\"\n",
    "}, {\n",
    "  \"first_name\": \"Hieronymus\",\n",
    "  \"last_name\": \"Nicolls\",\n",
    "  \"email\": \"hnicolls2r@fema.gov\",\n",
    "  \"gender\": \"Genderfluid\",\n",
    "  \"conections\": 76,\n",
    "  \"country\": \"Guatemala\"\n",
    "}]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "03c785d5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pymongo.results.InsertManyResult at 0x10f9588b0>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#insert data to our database\n",
    "db.our_clients.insert_many(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "65b3e777",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "100\n"
     ]
    }
   ],
   "source": [
    "#how many documents are in our database\n",
    "print(db.our_clients.count_documents({}))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "214112c9",
   "metadata": {},
   "source": [
    "+ we now have 100 records in our database"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d7caa1ff",
   "metadata": {},
   "source": [
    "$~$\n",
    "___\n",
    "####  Exercise 3\n",
    "\n",
    "$~$\n",
    "\n",
    "Load some simple queries to a Pandas Dataframe.\n",
    "\n",
    "$~$\n",
    "___"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "89e29605",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Agender',\n",
      " 'Bigender',\n",
      " 'Female',\n",
      " 'Genderfluid',\n",
      " 'Genderqueer',\n",
      " 'Male',\n",
      " 'Non-binary',\n",
      " 'Polygender']\n"
     ]
    }
   ],
   "source": [
    "#querie to find distintcs gender \n",
    "our_clientes_gender = db.our_clients.distinct(\"gender\")\n",
    "\n",
    "pprint.pp(our_clientes_gender)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "a897e5e0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a filter for clients with more that 10 conections\n",
    "\n",
    "filter = {\n",
    "    \"conections\": {\n",
    "        \"$gte\": 10\n",
    "    }\n",
    "}\n",
    "# Save the filter of these clients\n",
    "result = db.our_clients.find(filter)\n",
    "\n",
    "\n",
    "df = pd.DataFrame(list(result))\n",
    "df.drop(['_id'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "52bf4fba",
   "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>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "      <th>gender</th>\n",
       "      <th>conections</th>\n",
       "      <th>country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Nicolas</td>\n",
       "      <td>Pavelka</td>\n",
       "      <td>npavelka4@oakley.com</td>\n",
       "      <td>Male</td>\n",
       "      <td>85</td>\n",
       "      <td>Austria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Libbie</td>\n",
       "      <td>Sykes</td>\n",
       "      <td>lsykes0@wufoo.com</td>\n",
       "      <td>Female</td>\n",
       "      <td>18</td>\n",
       "      <td>Kenya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jobyna</td>\n",
       "      <td>Fontelles</td>\n",
       "      <td>jfontelles1@blog.com</td>\n",
       "      <td>Female</td>\n",
       "      <td>86</td>\n",
       "      <td>Brazil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Estele</td>\n",
       "      <td>Egre</td>\n",
       "      <td>eegre2@goo.gl</td>\n",
       "      <td>Female</td>\n",
       "      <td>14</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Yvor</td>\n",
       "      <td>Rubinsohn</td>\n",
       "      <td>yrubinsohn3@gnu.org</td>\n",
       "      <td>Male</td>\n",
       "      <td>23</td>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  first_name  last_name                 email  gender  conections    country\n",
       "0    Nicolas    Pavelka  npavelka4@oakley.com    Male          85    Austria\n",
       "1     Libbie      Sykes     lsykes0@wufoo.com  Female          18      Kenya\n",
       "2     Jobyna  Fontelles  jfontelles1@blog.com  Female          86     Brazil\n",
       "3     Estele       Egre         eegre2@goo.gl  Female          14  Indonesia\n",
       "4       Yvor  Rubinsohn   yrubinsohn3@gnu.org    Male          23      China"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "291770df",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 89 entries, 0 to 88\n",
      "Data columns (total 6 columns):\n",
      " #   Column      Non-Null Count  Dtype \n",
      "---  ------      --------------  ----- \n",
      " 0   first_name  89 non-null     object\n",
      " 1   last_name   89 non-null     object\n",
      " 2   email       89 non-null     object\n",
      " 3   gender      89 non-null     object\n",
      " 4   conections  89 non-null     int64 \n",
      " 5   country     89 non-null     object\n",
      "dtypes: int64(1), object(5)\n",
      "memory usage: 4.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "8b489252",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'_id': ObjectId('62aa3fa24d2062bf1043fb45'),\n",
      " 'first_name': 'Gabie',\n",
      " 'last_name': 'Stilliard',\n",
      " 'email': 'gstilliard13@patch.com',\n",
      " 'gender': 'Female',\n",
      " 'conections': 51,\n",
      " 'country': 'Ecuador'}\n"
     ]
    }
   ],
   "source": [
    "# Find clients whose first name starts with \"G\" and last name starts with \"S\"\n",
    "query1 =  db.our_clients.find(\n",
    "       filter= {\"first_name\" : {\"$regex\" : \"^G\"},\n",
    "                \"last_name\" : {\"$regex\" : \"^S\"}  })\n",
    "# Print the first document \n",
    "for x in query1:\n",
    "       pprint.pp(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "73a68fd5",
   "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>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>email</th>\n",
       "      <th>gender</th>\n",
       "      <th>conections</th>\n",
       "      <th>country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Baxter</td>\n",
       "      <td>Sieghard</td>\n",
       "      <td>bsiegharda@sogou.com</td>\n",
       "      <td>Polygender</td>\n",
       "      <td>10</td>\n",
       "      <td>Colombia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jillian</td>\n",
       "      <td>Windle</td>\n",
       "      <td>jwindleb@soup.io</td>\n",
       "      <td>Polygender</td>\n",
       "      <td>54</td>\n",
       "      <td>Indonesia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chelsie</td>\n",
       "      <td>Creffield</td>\n",
       "      <td>ccreffieldy@google.co.jp</td>\n",
       "      <td>Genderqueer</td>\n",
       "      <td>37</td>\n",
       "      <td>Sweden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jamie</td>\n",
       "      <td>Garrand</td>\n",
       "      <td>jgarrandz@macromedia.com</td>\n",
       "      <td>Bigender</td>\n",
       "      <td>40</td>\n",
       "      <td>Ireland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sheridan</td>\n",
       "      <td>Picford</td>\n",
       "      <td>spicford15@google.com</td>\n",
       "      <td>Agender</td>\n",
       "      <td>89</td>\n",
       "      <td>Greece</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Madonna</td>\n",
       "      <td>Marjanovic</td>\n",
       "      <td>mmarjanovic1e@google.de</td>\n",
       "      <td>Non-binary</td>\n",
       "      <td>82</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Jess</td>\n",
       "      <td>Mumm</td>\n",
       "      <td>jmumm1h@cargocollective.com</td>\n",
       "      <td>Genderqueer</td>\n",
       "      <td>2</td>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sky</td>\n",
       "      <td>Fetter</td>\n",
       "      <td>sfetter1j@aol.com</td>\n",
       "      <td>Genderfluid</td>\n",
       "      <td>59</td>\n",
       "      <td>Poland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Basile</td>\n",
       "      <td>Yearsley</td>\n",
       "      <td>byearsley1k@europa.eu</td>\n",
       "      <td>Agender</td>\n",
       "      <td>70</td>\n",
       "      <td>Philippines</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Norman</td>\n",
       "      <td>Ebdin</td>\n",
       "      <td>nebdin26@usatoday.com</td>\n",
       "      <td>Agender</td>\n",
       "      <td>53</td>\n",
       "      <td>Venezuela</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Webb</td>\n",
       "      <td>Bloss</td>\n",
       "      <td>wbloss28@alexa.com</td>\n",
       "      <td>Non-binary</td>\n",
       "      <td>68</td>\n",
       "      <td>Russia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Amory</td>\n",
       "      <td>Pembridge</td>\n",
       "      <td>apembridge2h@paginegialle.it</td>\n",
       "      <td>Genderfluid</td>\n",
       "      <td>43</td>\n",
       "      <td>China</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Hieronymus</td>\n",
       "      <td>Nicolls</td>\n",
       "      <td>hnicolls2r@fema.gov</td>\n",
       "      <td>Genderfluid</td>\n",
       "      <td>76</td>\n",
       "      <td>Guatemala</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    first_name   last_name                         email       gender  \\\n",
       "0       Baxter    Sieghard          bsiegharda@sogou.com   Polygender   \n",
       "1      Jillian      Windle              jwindleb@soup.io   Polygender   \n",
       "2      Chelsie   Creffield      ccreffieldy@google.co.jp  Genderqueer   \n",
       "3        Jamie     Garrand      jgarrandz@macromedia.com     Bigender   \n",
       "4     Sheridan     Picford         spicford15@google.com      Agender   \n",
       "5      Madonna  Marjanovic       mmarjanovic1e@google.de   Non-binary   \n",
       "6         Jess        Mumm   jmumm1h@cargocollective.com  Genderqueer   \n",
       "7          Sky      Fetter             sfetter1j@aol.com  Genderfluid   \n",
       "8       Basile    Yearsley         byearsley1k@europa.eu      Agender   \n",
       "9       Norman       Ebdin         nebdin26@usatoday.com      Agender   \n",
       "10        Webb       Bloss            wbloss28@alexa.com   Non-binary   \n",
       "11       Amory   Pembridge  apembridge2h@paginegialle.it  Genderfluid   \n",
       "12  Hieronymus     Nicolls           hnicolls2r@fema.gov  Genderfluid   \n",
       "\n",
       "    conections        country  \n",
       "0           10       Colombia  \n",
       "1           54      Indonesia  \n",
       "2           37         Sweden  \n",
       "3           40        Ireland  \n",
       "4           89         Greece  \n",
       "5           82  United States  \n",
       "6            2          China  \n",
       "7           59         Poland  \n",
       "8           70    Philippines  \n",
       "9           53      Venezuela  \n",
       "10          68         Russia  \n",
       "11          43          China  \n",
       "12          76      Guatemala  "
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find clients whose gender is not female or male\n",
    "\n",
    "criteria = { \"gender\": \n",
    "                { \"$nin\": [\"Female\",\"Male\"]}\n",
    "             }\n",
    "\n",
    "query2 =  db.our_clients.find(criteria)\n",
    "\n",
    "df2 = pd.DataFrame(list(query2))\n",
    "df2.drop(['_id'], axis=1, inplace=True)\n",
    "\n",
    "df2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "39123083",
   "metadata": {},
   "source": [
    "$~$\n",
    "___\n",
    "####  Exercise 4\n",
    "\n",
    "$~$\n",
    "\n",
    "Generate a statistical summary of the information contained in the database.\n",
    "\n",
    "$~$\n",
    "___"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "7725bab8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'db': 'mydatabase',\n",
      " 'collections': 1,\n",
      " 'views': 0,\n",
      " 'objects': 100,\n",
      " 'avgObjSize': 158.88,\n",
      " 'dataSize': 15888,\n",
      " 'storageSize': 40960,\n",
      " 'totalFreeStorageSize': 0,\n",
      " 'numExtents': 0,\n",
      " 'indexes': 1,\n",
      " 'indexSize': 36864,\n",
      " 'indexFreeStorageSize': 0,\n",
      " 'fileSize': 0,\n",
      " 'nsSizeMB': 0,\n",
      " 'ok': 1}\n"
     ]
    }
   ],
   "source": [
    "#prints database stats for \"mydatabase\"\n",
    "pprint.pp(db.command(\"dbstats\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "5defaaef",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'ns': 'mydatabase.our_clients',\n",
      " 'size': 15888,\n",
      " 'count': 100,\n",
      " 'avgObjSize': 158,\n",
      " 'storageSize': 40960,\n",
      " 'freeStorageSize': 16384,\n",
      " 'capped': False,\n",
      " 'nindexes': 1,\n",
      " 'indexDetails': {'_id_': {'metadata': {'formatVersion': 8},\n",
      "                           'creationString': 'access_pattern_hint=none,allocation_size=4KB,app_metadata=(formatVersion=8),assert=(commit_timestamp=none,durable_timestamp=none,read_timestamp=none,write_timestamp=off),block_allocation=best,block_compressor=,cache_resident=false,checksum=on,colgroups=,collator=,columns=,dictionary=0,encryption=(keyid=,name=),exclusive=false,extractor=,format=btree,huffman_key=,huffman_value=,ignore_in_memory_cache_size=false,immutable=false,import=(enabled=false,file_metadata=,repair=false),internal_item_max=0,internal_key_max=0,internal_key_truncate=true,internal_page_max=16k,key_format=u,key_gap=10,leaf_item_max=0,leaf_key_max=0,leaf_page_max=16k,leaf_value_max=0,log=(enabled=false),lsm=(auto_throttle=true,bloom=true,bloom_bit_count=16,bloom_config=,bloom_hash_count=8,bloom_oldest=false,chunk_count_limit=0,chunk_max=5GB,chunk_size=10MB,merge_custom=(prefix=,start_generation=0,suffix=),merge_max=15,merge_min=0),memory_page_image_max=0,memory_page_max=5MB,os_cache_dirty_max=0,os_cache_max=0,prefix_compression=true,prefix_compression_min=4,readonly=false,source=,split_deepen_min_child=0,split_deepen_per_child=0,split_pct=90,tiered_object=false,tiered_storage=(auth_token=,bucket=,bucket_prefix=,cache_directory=,local_retention=300,name=),type=file,value_format=u,verbose=[],write_timestamp_usage=none',\n",
      "                           'type': 'file',\n",
      "                           'uri': 'statistics:table:index-6619-5862436200314677224',\n",
      "                           'LSM': {'bloom filter false positives': 0,\n",
      "                                   'bloom filter hits': 0,\n",
      "                                   'bloom filter misses': 0,\n",
      "                                   'bloom filter pages evicted from cache': 0,\n",
      "                                   'bloom filter pages read into cache': 0,\n",
      "                                   'bloom filters in the LSM tree': 0,\n",
      "                                   'chunks in the LSM tree': 0,\n",
      "                                   'highest merge generation in the LSM tree': 0,\n",
      "                                   'queries that could have benefited from a Bloom filter that did not exist': 0,\n",
      "                                   'sleep for LSM checkpoint throttle': 0,\n",
      "                                   'sleep for LSM merge throttle': 0,\n",
      "                                   'total size of bloom filters': 0},\n",
      "                           'block-manager': {'allocations requiring file extension': 0,\n",
      "                                             'blocks allocated': 0,\n",
      "                                             'blocks freed': 0,\n",
      "                                             'checkpoint size': 4096,\n",
      "                                             'file allocation unit size': 4096,\n",
      "                                             'file bytes available for reuse': 16384,\n",
      "                                             'file magic number': 120897,\n",
      "                                             'file major version number': 1,\n",
      "                                             'file size in bytes': 36864,\n",
      "                                             'minor version number': 0},\n",
      "                           'btree': {'btree checkpoint generation': 0,\n",
      "                                     'btree clean tree checkpoint expiration time': 0,\n",
      "                                     'btree compact pages reviewed': 0,\n",
      "                                     'btree compact pages rewritten': 0,\n",
      "                                     'btree compact pages skipped': 0,\n",
      "                                     'btree skipped by compaction as process would not reduce size': 0,\n",
      "                                     'column-store fixed-size leaf pages': 0,\n",
      "                                     'column-store internal pages': 0,\n",
      "                                     'column-store variable-size RLE encoded values': 0,\n",
      "                                     'column-store variable-size deleted values': 0,\n",
      "                                     'column-store variable-size leaf pages': 0,\n",
      "                                     'fixed-record size': 0,\n",
      "                                     'maximum internal page size': 16384,\n",
      "                                     'maximum leaf page key size': 1474,\n",
      "                                     'maximum leaf page size': 16384,\n",
      "                                     'maximum leaf page value size': 7372,\n",
      "                                     'maximum tree depth': 0,\n",
      "                                     'number of key/value pairs': 0,\n",
      "                                     'overflow pages': 0,\n",
      "                                     'row-store empty values': 0,\n",
      "                                     'row-store internal pages': 0,\n",
      "                                     'row-store leaf pages': 0},\n",
      "                           'cache': {'bytes currently in the cache': 243,\n",
      "                                     'bytes dirty in the cache cumulative': 0,\n",
      "                                     'bytes read into cache': 65,\n",
      "                                     'bytes written from cache': 0,\n",
      "                                     'checkpoint blocked page eviction': 0,\n",
      "                                     'checkpoint of history store file blocked non-history store page eviction': 0,\n",
      "                                     'data source pages selected for eviction unable to be evicted': 0,\n",
      "                                     'eviction gave up due to detecting an out of order on disk value behind the last update on the chain': 0,\n",
      "                                     'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update': 0,\n",
      "                                     'eviction gave up due to detecting an out of order tombstone ahead of the selected on disk update after validating the update chain': 0,\n",
      "                                     'eviction gave up due to detecting out of order timestamps on the update chain after the selected on disk update': 0,\n",
      "                                     'eviction walk passes of a file': 0,\n",
      "                                     'eviction walk target pages histogram - 0-9': 0,\n",
      "                                     'eviction walk target pages histogram - 10-31': 0,\n",
      "                                     'eviction walk target pages histogram - 128 and higher': 0,\n",
      "                                     'eviction walk target pages histogram - 32-63': 0,\n",
      "                                     'eviction walk target pages histogram - 64-128': 0,\n",
      "                                     'eviction walk target pages reduced due to history store cache pressure': 0,\n",
      "                                     'eviction walks abandoned': 0,\n",
      "                                     'eviction walks gave up because they restarted their walk twice': 0,\n",
      "                                     'eviction walks gave up because they saw too many pages and found no candidates': 0,\n",
      "                                     'eviction walks gave up because they saw too many pages and found too few candidates': 0,\n",
      "                                     'eviction walks reached end of tree': 0,\n",
      "                                     'eviction walks restarted': 0,\n",
      "                                     'eviction walks started from root of tree': 0,\n",
      "                                     'eviction walks started from saved location in tree': 0,\n",
      "                                     'hazard pointer blocked page eviction': 0,\n",
      "                                     'history store table insert calls': 0,\n",
      "                                     'history store table insert calls that returned restart': 0,\n",
      "                                     'history store table out-of-order resolved updates that lose their durable timestamp': 0,\n",
      "                                     'history store table out-of-order updates that were fixed up by reinserting with the fixed timestamp': 0,\n",
      "                                     'history store table reads': 0,\n",
      "                                     'history store table reads missed': 0,\n",
      "                                     'history store table reads requiring squashed modifies': 0,\n",
      "                                     'history store table truncation by rollback to stable to remove an unstable update': 0,\n",
      "                                     'history store table truncation by rollback to stable to remove an update': 0,\n",
      "                                     'history store table truncation to remove an update': 0,\n",
      "                                     'history store table truncation to remove range of updates due to key being removed from the data page during reconciliation': 0,\n",
      "                                     'history store table truncation to remove range of updates due to out-of-order timestamp update on data page': 0,\n",
      "                                     'history store table writes requiring squashed modifies': 0,\n",
      "                                     'in-memory page passed criteria to be split': 0,\n",
      "                                     'in-memory page splits': 0,\n",
      "                                     'internal pages evicted': 0,\n",
      "                                     'internal pages split during eviction': 0,\n",
      "                                     'leaf pages split during eviction': 0,\n",
      "                                     'modified pages evicted': 0,\n",
      "                                     'overflow pages read into cache': 0,\n",
      "                                     'page split during eviction deepened the tree': 0,\n",
      "                                     'page written requiring history store records': 0,\n",
      "                                     'pages read into cache': 1,\n",
      "                                     'pages read into cache after truncate': 0,\n",
      "                                     'pages read into cache after truncate in prepare state': 0,\n",
      "                                     'pages requested from the cache': 0,\n",
      "                                     'pages seen by eviction walk': 0,\n",
      "                                     'pages written from cache': 0,\n",
      "                                     'pages written requiring in-memory restoration': 0,\n",
      "                                     'the number of times full update inserted to history store': 0,\n",
      "                                     'the number of times reverse modify inserted to history store': 0,\n",
      "                                     'tracked dirty bytes in the cache': 0,\n",
      "                                     'unmodified pages evicted': 0},\n",
      "                           'cache_walk': {'Average difference between current eviction generation when the page was last considered': 0,\n",
      "                                          'Average on-disk page image size seen': 0,\n",
      "                                          'Average time in cache for pages that have been visited by the eviction server': 0,\n",
      "                                          'Average time in cache for pages that have not been visited by the eviction server': 0,\n",
      "                                          'Clean pages currently in cache': 0,\n",
      "                                          'Current eviction generation': 0,\n",
      "                                          'Dirty pages currently in cache': 0,\n",
      "                                          'Entries in the root page': 0,\n",
      "                                          'Internal pages currently in cache': 0,\n",
      "                                          'Leaf pages currently in cache': 0,\n",
      "                                          'Maximum difference between current eviction generation when the page was last considered': 0,\n",
      "                                          'Maximum page size seen': 0,\n",
      "                                          'Minimum on-disk page image size seen': 0,\n",
      "                                          'Number of pages never visited by eviction server': 0,\n",
      "                                          'On-disk page image sizes smaller than a single allocation unit': 0,\n",
      "                                          'Pages created in memory and never written': 0,\n",
      "                                          'Pages currently queued for eviction': 0,\n",
      "                                          'Pages that could not be queued for eviction': 0,\n",
      "                                          'Refs skipped during cache traversal': 0,\n",
      "                                          'Size of the root page': 0,\n",
      "                                          'Total number of pages currently in cache': 0},\n",
      "                           'checkpoint-cleanup': {'pages added for eviction': 0,\n",
      "                                                  'pages removed': 0,\n",
      "                                                  'pages skipped during tree walk': 0,\n",
      "                                                  'pages visited': 0},\n",
      "                           'compression': {'compressed page maximum internal page size prior to compression': 16384,\n",
      "                                           'compressed page maximum leaf page size prior to compression ': 16384,\n",
      "                                           'compressed pages read': 0,\n",
      "                                           'compressed pages written': 0,\n",
      "                                           'number of blocks with compress ratio greater than 64': 0,\n",
      "                                           'number of blocks with compress ratio smaller than 16': 0,\n",
      "                                           'number of blocks with compress ratio smaller than 2': 0,\n",
      "                                           'number of blocks with compress ratio smaller than 32': 0,\n",
      "                                           'number of blocks with compress ratio smaller than 4': 0,\n",
      "                                           'number of blocks with compress ratio smaller than 64': 0,\n",
      "                                           'number of blocks with compress ratio smaller than 8': 0,\n",
      "                                           'page written failed to compress': 0,\n",
      "                                           'page written was too small to compress': 0},\n",
      "                           'cursor': {'Total number of entries skipped by cursor next calls': 0,\n",
      "                                      'Total number of entries skipped by cursor prev calls': 0,\n",
      "                                      'Total number of entries skipped to position the history store cursor': 0,\n",
      "                                      'Total number of times a search near has exited due to prefix config': 0,\n",
      "                                      'bulk loaded cursor insert calls': 0,\n",
      "                                      'cache cursors reuse count': 0,\n",
      "                                      'close calls that result in cache': 0,\n",
      "                                      'create calls': 0,\n",
      "                                      'cursor next calls that skip due to a globally visible history store tombstone': 0,\n",
      "                                      'cursor next calls that skip greater than or equal to 100 entries': 0,\n",
      "                                      'cursor next calls that skip less than 100 entries': 0,\n",
      "                                      'cursor prev calls that skip due to a globally visible history store tombstone': 0,\n",
      "                                      'cursor prev calls that skip greater than or equal to 100 entries': 0,\n",
      "                                      'cursor prev calls that skip less than 100 entries': 0,\n",
      "                                      'insert calls': 0,\n",
      "                                      'insert key and value bytes': 0,\n",
      "                                      'modify': 0,\n",
      "                                      'modify key and value bytes affected': 0,\n",
      "                                      'modify value bytes modified': 0,\n",
      "                                      'next calls': 0,\n",
      "                                      'open cursor count': 0,\n",
      "                                      'operation restarted': 0,\n",
      "                                      'prev calls': 0,\n",
      "                                      'remove calls': 0,\n",
      "                                      'remove key bytes removed': 0,\n",
      "                                      'reserve calls': 0,\n",
      "                                      'reset calls': 0,\n",
      "                                      'search calls': 0,\n",
      "                                      'search history store calls': 0,\n",
      "                                      'search near calls': 0,\n",
      "                                      'truncate calls': 0,\n",
      "                                      'update calls': 0,\n",
      "                                      'update key and value bytes': 0,\n",
      "                                      'update value size change': 0},\n",
      "                           'reconciliation': {'approximate byte size of timestamps in pages written': 0,\n",
      "                                              'approximate byte size of transaction IDs in pages written': 0,\n",
      "                                              'dictionary matches': 0,\n",
      "                                              'fast-path pages deleted': 0,\n",
      "                                              'internal page key bytes discarded using suffix compression': 0,\n",
      "                                              'internal page multi-block writes': 0,\n",
      "                                              'leaf page key bytes discarded using prefix compression': 0,\n",
      "                                              'leaf page multi-block writes': 0,\n",
      "                                              'leaf-page overflow keys': 0,\n",
      "                                              'maximum blocks required for a page': 0,\n",
      "                                              'overflow values written': 0,\n",
      "                                              'page checksum matches': 0,\n",
      "                                              'page reconciliation calls': 0,\n",
      "                                              'page reconciliation calls for eviction': 0,\n",
      "                                              'pages deleted': 0,\n",
      "                                              'pages written including an aggregated newest start durable timestamp ': 0,\n",
      "                                              'pages written including an aggregated newest stop durable timestamp ': 0,\n",
      "                                              'pages written including an aggregated newest stop timestamp ': 0,\n",
      "                                              'pages written including an aggregated newest stop transaction ID': 0,\n",
      "                                              'pages written including an aggregated newest transaction ID ': 0,\n",
      "                                              'pages written including an aggregated oldest start timestamp ': 0,\n",
      "                                              'pages written including an aggregated prepare': 0,\n",
      "                                              'pages written including at least one prepare': 0,\n",
      "                                              'pages written including at least one start durable timestamp': 0,\n",
      "                                              'pages written including at least one start timestamp': 0,\n",
      "                                              'pages written including at least one start transaction ID': 0,\n",
      "                                              'pages written including at least one stop durable timestamp': 0,\n",
      "                                              'pages written including at least one stop timestamp': 0,\n",
      "                                              'pages written including at least one stop transaction ID': 0,\n",
      "                                              'records written including a prepare': 0,\n",
      "                                              'records written including a start durable timestamp': 0,\n",
      "                                              'records written including a start timestamp': 0,\n",
      "                                              'records written including a start transaction ID': 0,\n",
      "                                              'records written including a stop durable timestamp': 0,\n",
      "                                              'records written including a stop timestamp': 0,\n",
      "                                              'records written including a stop transaction ID': 0},\n",
      "                           'session': {'object compaction': 0,\n",
      "                                       'tiered operations dequeued and processed': 0,\n",
      "                                       'tiered operations scheduled': 0,\n",
      "                                       'tiered storage local retention time (secs)': 0},\n",
      "                           'transaction': {'race to read prepared update retry': 0,\n",
      "                                           'rollback to stable history store records with stop timestamps older than newer records': 0,\n",
      "                                           'rollback to stable inconsistent checkpoint': 0,\n",
      "                                           'rollback to stable keys removed': 0,\n",
      "                                           'rollback to stable keys restored': 0,\n",
      "                                           'rollback to stable restored tombstones from history store': 0,\n",
      "                                           'rollback to stable restored updates from history store': 0,\n",
      "                                           'rollback to stable skipping delete rle': 0,\n",
      "                                           'rollback to stable skipping stable rle': 0,\n",
      "                                           'rollback to stable sweeping history store keys': 0,\n",
      "                                           'rollback to stable updates removed from history store': 0,\n",
      "                                           'transaction checkpoints due to obsolete pages': 0,\n",
      "                                           'update conflicts': 0}}},\n",
      " 'indexBuilds': [],\n",
      " 'totalIndexSize': 36864,\n",
      " 'totalSize': 77824,\n",
      " 'indexSizes': {'_id_': 36864},\n",
      " 'scaleFactor': 1,\n",
      " 'ok': 1.0,\n",
      " '$clusterTime': {'clusterTime': Timestamp(1655328997, 11),\n",
      "                  'signature': {'hash': b'&\\x15\\x14\\xa9\\xf2\\x05\\xa7\\xdf'\n",
      "                                        b'U`\\xad\\x06S\\xc8\\xc2\\xa3r9\\x08Q',\n",
      "                                'keyId': 7065361935113388034}},\n",
      " 'operationTime': Timestamp(1655328997, 11)}\n"
     ]
    }
   ],
   "source": [
    "#prints collection-level stats for collection \"our_clients\" under \"mydatabase\"\n",
    "pprint.pp(db.command(\"collstats\", \"our_clients\"))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d0eedf5c",
   "metadata": {},
   "source": [
    "___\n",
    "$~$\n",
    "\n",
    "####  *References*:\n",
    "\n",
    "+ [MongoDB Crash Course With Python 2022](https://www.youtube.com/watch?v=qWYx5neOh2s&t=1638s) \n",
    "\n",
    "$~$\n",
    "___"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.5 64-bit ('3.9.5')",
   "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.9.5"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": false,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  },
  "vscode": {
   "interpreter": {
    "hash": "c196e456b92eeb3a60b06f99b3c60ac6c4763f8bb1169beee1475ccb9dd5a29f"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}