demo.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 🎲 Testing the **DataGrid** module"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Import the class:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys\n",
    "sys.path.append('src/')\n",
    "\n",
    "from datagrid import DataGrid"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Instantiate the class:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid = DataGrid()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### `.read_csv(file, sep = ',', encoding = 'utf-8')`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can read a `.csv` file into the datagrid object."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.read_csv(\"data/fake_data100.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### `.show(start = 0, end = 100)`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can also show the range of rows you'd like. By default, the method returns the first 100 rows. If you'd like, you can ask it to print by setting the `prints` parameter to `True`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849ead0>,\n",
       " <datagrid.Event at 0x7fc83849ea70>,\n",
       " <datagrid.Event at 0x7fc83849d0c0>,\n",
       " <datagrid.Event at 0x7fc83849d210>,\n",
       " <datagrid.Event at 0x7fc83849e5c0>,\n",
       " <datagrid.Event at 0x7fc83849d030>,\n",
       " <datagrid.Event at 0x7fc83849e9b0>,\n",
       " <datagrid.Event at 0x7fc83849d2a0>,\n",
       " <datagrid.Event at 0x7fc83849ed40>,\n",
       " <datagrid.Event at 0x7fc83849ed70>,\n",
       " <datagrid.Event at 0x7fc83849ec20>]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid.show(0, 10, prints = False, returns=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 Y2U70 2006/05/01 04:19:15 52 ZAEMTRF WXJKOKBNZY70N3TLVGI1ARLDBC8NKKPDDVUX9C1CH72UUHEJN9N14I1ACC384PINKQYGDDAJ3SG7OMEJOPJ1T9GOVME2W4T8O1RFYPRXAQAR\n",
      "1 8DGBJ 2003/05/26 12:45:40 50 YXETLEYPSHN VP582U9GFJY02CJZU2Z6RYK3H7A8Q24MIDZGU2ACM1L91GY5FW35OOVMW6NJA53XGVI2U0QJE7HSUGBABKWFRCY61BHMPIGTL6Z\n",
      "2 0P7BW 2014/02/19 20:05:48 25 CXTYEIS LOBUZPFGTEFN1ULIMRJGIWC1DCYQRIUWHSJT2WDEKOD44WAA5L9JAG3GKITPLRPCQRYAU4YI66T4Y6DMYGJNCEGADJMFZ1UR0SDWRX2LMEFXVXCUBT\n",
      "3 Y43QY 2006/09/21 15:23:47 18 KQOBPGSRKVX MA1JTFN0WMCJTSHZ60Y27N2Y9OJZ8RPAYO7Z5P9RUNF6AV6II73KWMKALXWW8MRZRGUE4NSRWVWF2CPHBS87FLRTB8OUCSER0IC9O33A084VUOU9XULIJH05K5LAO1YZD6RSCF6FHD7LQGC76GA5TS2V42V6TWYB53LADVQOIZXM8PDREDAA6XM2ROPNY42YVFWF73OX04HA4UG70XCXQ981M5RHPPFNBV3Y5DEM66IXL0IQCR3QN8YU56KZ5RPVACO7WNA5S433BNB9YWDN6W\n",
      "4 FFBE7 2006/12/09 03:53:15 11 LOQFTSPJVYCJQEU KJXNZ5ZABEYIM43BBCW6ECQ21ZL950WK5GYLD3YTG4KMUUBJENZAPFTRSIKEGVXSN2HCL9V3JNWVB4DQ6F282O3HK5A51R9GPQ0ARW6OFPSONSSQUU8E4EIT71BQCYT5WLSBASMCQVATE59F2EKKAZNFL2BMFIFPL9F5GG395N6QJLBACT0IYIWK4ZNV91K82TX9KPUAFQF4KYUL381CEA0FIFILR1YQZLI8FF5RS4EDYXPB8679IIPOMYIBIBCPWWTH66O532RJPA0HYQI7O6W66LDAK40X8AB4VU9AG4SX\n",
      "5 X7P9D 2005/04/18 06:02:26 78 D FT2J8G97PP76E2BWXYHUYMBHUPQZZF9R1UFTBSI3E6WHJUAFEY3DF5KXJ1Q1TZR39EEZ2ZKIPK10NVAGM2JK3WEWFZ3SM78Q6J0EFHIRKYEIL62I3RERUBZX4L1TMWNQGUPZTBRFC7NXU0X44A03VZF09F7WJ680RLYFPFIUKGKXC9F2N\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n",
      "7 D9WY9 2007/08/29 16:38:41 67 WZXGOO E5A7YC18L1D2E2JKXQK2P0HQIR8FEVC2X7125TKUG2R9NWVY4J52C8IXABILTLJ83YZ8HOQFLVDX5ON7TIJIXM7E6PCKIC3A8E52HXASJQ34HEJMH3GZ90V0YU3UK9GKZ9JTNJ2KGGPUBIE53O7IP162UXOAKT48EPKN8YZPA4EU1NG4P643XMTGCSUL9G6UW3QWWTLYBYMJ\n",
      "8 0PLHU 2010/11/08 21:26:41 47 PXNXBHWORCXONE 34PIA2AB8LDAR4F8B92Z5MKTMTX4XQ4YTKEVGYSPJ8M1ZZVRP7DHHGKEK4IVCUEYJ3BTW46JJV3THLK11J07UR32FJI3N220JRELWF9220ETQUHHM970HX70TMS76UMD4HSZ57OA52IC92MVMYCMJAM6J2M4EIWKSE9Z95PE8GA26E3M5X8U6FZEXEZQ2K9S0I0VCXXP07J9DWJCWZV39VFV9O5TA5R8T3S00QCKS8DMK91YG3PZT5\n",
      "9 LBK31 2010/09/19 10:31:10 37  HVU44WG8C2ZFMI6SHG4WGHU98DO27HZIT125YFGC9W0VKGYHYOKWZXK4XSUNNX5NZ2CU55L2NRDKD60HM659CLFLBA2T6X7RQKK2KS2E6FZ9J4V87WVUOTY97WYLEDEZ2HGN9PQ71UZLGPEESBI8T1WO5YJLZXY4JAGN6QO8JIVQLL8N570XEEXO2WCWQF0C2R07NHFKYJUK30GKUDTD8OD0LIEY2GVY8L4QAEVS0ZEYYAAYMGBG4KRXGE3TNCBODYN243TXPE169HOBGZ4L64ZKBQXH0NPTQJPYHC2VLHFPGF8\n",
      "10 JFE57 2011/05/02 12:06:47 63 LTMQBIY 0AECEEPM3ICWIE96EYLS5C3HOFW3JEB2JOKE57IZOHPQ1FMJGK9S09ZP2IFI821ODI7AI3R21Z8YIVOAXIZ4ACXPSGHQ7X84WUWYXF5L8LM0M62TZ37H0D9W0SL8KIOE2KLSS22PLIQGT58Y57O6HLGFRZPAVTW4TTWKCSZBU9W8HYTOEM45QRXZZD9Q9PFK3ZXD1CA0R09X43ZJIDQWVMQRS7WW8LXXW92K0R3T78VRS06B082X57ABJHOAL7D19BW5TYCWZJCD1FXYHURE0FZ0D8J8T3C72Y3T0CEVGQR2YSBRHQRJ26CT8WYFH04K88D28Y7GVLJSMSNTM50BTU7EZY1WFW8PSDV2PKFR3YDY0IJ6U09PC5FC22QS219O6C9FM1ONB6QI\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 10, prints = True, returns=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### `.insert_row(row)`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You may want to add rows through a dictionary. In the example below, we add a row if an ID which is already in the datagrid. This will update the row."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_row = {\"id\": 1, \"owner_id\": \"ABC123\", \"creation_date\": \"2023/10/06 12:00:15\", \"count\": 6, \"name\": \"Item 98\", \"content\": \"This is the new content for Item 98\"}\n",
    "datagrid.insert_row(new_row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 Y2U70 2006/05/01 04:19:15 52 ZAEMTRF WXJKOKBNZY70N3TLVGI1ARLDBC8NKKPDDVUX9C1CH72UUHEJN9N14I1ACC384PINKQYGDDAJ3SG7OMEJOPJ1T9GOVME2W4T8O1RFYPRXAQAR\n",
      "1 ABC123 2023/10/06 12:00:15 6 Item 98 This is the new content for Item 98\n",
      "2 0P7BW 2014/02/19 20:05:48 25 CXTYEIS LOBUZPFGTEFN1ULIMRJGIWC1DCYQRIUWHSJT2WDEKOD44WAA5L9JAG3GKITPLRPCQRYAU4YI66T4Y6DMYGJNCEGADJMFZ1UR0SDWRX2LMEFXVXCUBT\n",
      "3 Y43QY 2006/09/21 15:23:47 18 KQOBPGSRKVX MA1JTFN0WMCJTSHZ60Y27N2Y9OJZ8RPAYO7Z5P9RUNF6AV6II73KWMKALXWW8MRZRGUE4NSRWVWF2CPHBS87FLRTB8OUCSER0IC9O33A084VUOU9XULIJH05K5LAO1YZD6RSCF6FHD7LQGC76GA5TS2V42V6TWYB53LADVQOIZXM8PDREDAA6XM2ROPNY42YVFWF73OX04HA4UG70XCXQ981M5RHPPFNBV3Y5DEM66IXL0IQCR3QN8YU56KZ5RPVACO7WNA5S433BNB9YWDN6W\n",
      "4 FFBE7 2006/12/09 03:53:15 11 LOQFTSPJVYCJQEU KJXNZ5ZABEYIM43BBCW6ECQ21ZL950WK5GYLD3YTG4KMUUBJENZAPFTRSIKEGVXSN2HCL9V3JNWVB4DQ6F282O3HK5A51R9GPQ0ARW6OFPSONSSQUU8E4EIT71BQCYT5WLSBASMCQVATE59F2EKKAZNFL2BMFIFPL9F5GG395N6QJLBACT0IYIWK4ZNV91K82TX9KPUAFQF4KYUL381CEA0FIFILR1YQZLI8FF5RS4EDYXPB8679IIPOMYIBIBCPWWTH66O532RJPA0HYQI7O6W66LDAK40X8AB4VU9AG4SX\n",
      "5 X7P9D 2005/04/18 06:02:26 78 D FT2J8G97PP76E2BWXYHUYMBHUPQZZF9R1UFTBSI3E6WHJUAFEY3DF5KXJ1Q1TZR39EEZ2ZKIPK10NVAGM2JK3WEWFZ3SM78Q6J0EFHIRKYEIL62I3RERUBZX4L1TMWNQGUPZTBRFC7NXU0X44A03VZF09F7WJ680RLYFPFIUKGKXC9F2N\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 6, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### `.delete_row(column, value)`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can delete rows based on the value of the columns:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.delete_row(column=\"id\", value=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 Y2U70 2006/05/01 04:19:15 52 ZAEMTRF WXJKOKBNZY70N3TLVGI1ARLDBC8NKKPDDVUX9C1CH72UUHEJN9N14I1ACC384PINKQYGDDAJ3SG7OMEJOPJ1T9GOVME2W4T8O1RFYPRXAQAR\n",
      "1 ABC123 2023/10/06 12:00:15 6 Item 98 This is the new content for Item 98\n",
      "2 0P7BW 2014/02/19 20:05:48 25 CXTYEIS LOBUZPFGTEFN1ULIMRJGIWC1DCYQRIUWHSJT2WDEKOD44WAA5L9JAG3GKITPLRPCQRYAU4YI66T4Y6DMYGJNCEGADJMFZ1UR0SDWRX2LMEFXVXCUBT\n",
      "3 Y43QY 2006/09/21 15:23:47 18 KQOBPGSRKVX MA1JTFN0WMCJTSHZ60Y27N2Y9OJZ8RPAYO7Z5P9RUNF6AV6II73KWMKALXWW8MRZRGUE4NSRWVWF2CPHBS87FLRTB8OUCSER0IC9O33A084VUOU9XULIJH05K5LAO1YZD6RSCF6FHD7LQGC76GA5TS2V42V6TWYB53LADVQOIZXM8PDREDAA6XM2ROPNY42YVFWF73OX04HA4UG70XCXQ981M5RHPPFNBV3Y5DEM66IXL0IQCR3QN8YU56KZ5RPVACO7WNA5S433BNB9YWDN6W\n",
      "4 FFBE7 2006/12/09 03:53:15 11 LOQFTSPJVYCJQEU KJXNZ5ZABEYIM43BBCW6ECQ21ZL950WK5GYLD3YTG4KMUUBJENZAPFTRSIKEGVXSN2HCL9V3JNWVB4DQ6F282O3HK5A51R9GPQ0ARW6OFPSONSSQUU8E4EIT71BQCYT5WLSBASMCQVATE59F2EKKAZNFL2BMFIFPL9F5GG395N6QJLBACT0IYIWK4ZNV91K82TX9KPUAFQF4KYUL381CEA0FIFILR1YQZLI8FF5RS4EDYXPB8679IIPOMYIBIBCPWWTH66O532RJPA0HYQI7O6W66LDAK40X8AB4VU9AG4SX\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n",
      "7 D9WY9 2007/08/29 16:38:41 67 WZXGOO E5A7YC18L1D2E2JKXQK2P0HQIR8FEVC2X7125TKUG2R9NWVY4J52C8IXABILTLJ83YZ8HOQFLVDX5ON7TIJIXM7E6PCKIC3A8E52HXASJQ34HEJMH3GZ90V0YU3UK9GKZ9JTNJ2KGGPUBIE53O7IP162UXOAKT48EPKN8YZPA4EU1NG4P643XMTGCSUL9G6UW3QWWTLYBYMJ\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 6, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Deleting according to position:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.delete_row(column=\"position\", value=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 Y2U70 2006/05/01 04:19:15 52 ZAEMTRF WXJKOKBNZY70N3TLVGI1ARLDBC8NKKPDDVUX9C1CH72UUHEJN9N14I1ACC384PINKQYGDDAJ3SG7OMEJOPJ1T9GOVME2W4T8O1RFYPRXAQAR\n",
      "2 0P7BW 2014/02/19 20:05:48 25 CXTYEIS LOBUZPFGTEFN1ULIMRJGIWC1DCYQRIUWHSJT2WDEKOD44WAA5L9JAG3GKITPLRPCQRYAU4YI66T4Y6DMYGJNCEGADJMFZ1UR0SDWRX2LMEFXVXCUBT\n",
      "3 Y43QY 2006/09/21 15:23:47 18 KQOBPGSRKVX MA1JTFN0WMCJTSHZ60Y27N2Y9OJZ8RPAYO7Z5P9RUNF6AV6II73KWMKALXWW8MRZRGUE4NSRWVWF2CPHBS87FLRTB8OUCSER0IC9O33A084VUOU9XULIJH05K5LAO1YZD6RSCF6FHD7LQGC76GA5TS2V42V6TWYB53LADVQOIZXM8PDREDAA6XM2ROPNY42YVFWF73OX04HA4UG70XCXQ981M5RHPPFNBV3Y5DEM66IXL0IQCR3QN8YU56KZ5RPVACO7WNA5S433BNB9YWDN6W\n",
      "4 FFBE7 2006/12/09 03:53:15 11 LOQFTSPJVYCJQEU KJXNZ5ZABEYIM43BBCW6ECQ21ZL950WK5GYLD3YTG4KMUUBJENZAPFTRSIKEGVXSN2HCL9V3JNWVB4DQ6F282O3HK5A51R9GPQ0ARW6OFPSONSSQUU8E4EIT71BQCYT5WLSBASMCQVATE59F2EKKAZNFL2BMFIFPL9F5GG395N6QJLBACT0IYIWK4ZNV91K82TX9KPUAFQF4KYUL381CEA0FIFILR1YQZLI8FF5RS4EDYXPB8679IIPOMYIBIBCPWWTH66O532RJPA0HYQI7O6W66LDAK40X8AB4VU9AG4SX\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n",
      "7 D9WY9 2007/08/29 16:38:41 67 WZXGOO E5A7YC18L1D2E2JKXQK2P0HQIR8FEVC2X7125TKUG2R9NWVY4J52C8IXABILTLJ83YZ8HOQFLVDX5ON7TIJIXM7E6PCKIC3A8E52HXASJQ34HEJMH3GZ90V0YU3UK9GKZ9JTNJ2KGGPUBIE53O7IP162UXOAKT48EPKN8YZPA4EU1NG4P643XMTGCSUL9G6UW3QWWTLYBYMJ\n",
      "8 0PLHU 2010/11/08 21:26:41 47 PXNXBHWORCXONE 34PIA2AB8LDAR4F8B92Z5MKTMTX4XQ4YTKEVGYSPJ8M1ZZVRP7DHHGKEK4IVCUEYJ3BTW46JJV3THLK11J07UR32FJI3N220JRELWF9220ETQUHHM970HX70TMS76UMD4HSZ57OA52IC92MVMYCMJAM6J2M4EIWKSE9Z95PE8GA26E3M5X8U6FZEXEZQ2K9S0I0VCXXP07J9DWJCWZV39VFV9O5TA5R8T3S00QCKS8DMK91YG3PZT5\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 6, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.delete_row(column=\"position\", value=(0, 2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4 FFBE7 2006/12/09 03:53:15 11 LOQFTSPJVYCJQEU KJXNZ5ZABEYIM43BBCW6ECQ21ZL950WK5GYLD3YTG4KMUUBJENZAPFTRSIKEGVXSN2HCL9V3JNWVB4DQ6F282O3HK5A51R9GPQ0ARW6OFPSONSSQUU8E4EIT71BQCYT5WLSBASMCQVATE59F2EKKAZNFL2BMFIFPL9F5GG395N6QJLBACT0IYIWK4ZNV91K82TX9KPUAFQF4KYUL381CEA0FIFILR1YQZLI8FF5RS4EDYXPB8679IIPOMYIBIBCPWWTH66O532RJPA0HYQI7O6W66LDAK40X8AB4VU9AG4SX\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n",
      "7 D9WY9 2007/08/29 16:38:41 67 WZXGOO E5A7YC18L1D2E2JKXQK2P0HQIR8FEVC2X7125TKUG2R9NWVY4J52C8IXABILTLJ83YZ8HOQFLVDX5ON7TIJIXM7E6PCKIC3A8E52HXASJQ34HEJMH3GZ90V0YU3UK9GKZ9JTNJ2KGGPUBIE53O7IP162UXOAKT48EPKN8YZPA4EU1NG4P643XMTGCSUL9G6UW3QWWTLYBYMJ\n",
      "8 0PLHU 2010/11/08 21:26:41 47 PXNXBHWORCXONE 34PIA2AB8LDAR4F8B92Z5MKTMTX4XQ4YTKEVGYSPJ8M1ZZVRP7DHHGKEK4IVCUEYJ3BTW46JJV3THLK11J07UR32FJI3N220JRELWF9220ETQUHHM970HX70TMS76UMD4HSZ57OA52IC92MVMYCMJAM6J2M4EIWKSE9Z95PE8GA26E3M5X8U6FZEXEZQ2K9S0I0VCXXP07J9DWJCWZV39VFV9O5TA5R8T3S00QCKS8DMK91YG3PZT5\n",
      "9 LBK31 2010/09/19 10:31:10 37  HVU44WG8C2ZFMI6SHG4WGHU98DO27HZIT125YFGC9W0VKGYHYOKWZXK4XSUNNX5NZ2CU55L2NRDKD60HM659CLFLBA2T6X7RQKK2KS2E6FZ9J4V87WVUOTY97WYLEDEZ2HGN9PQ71UZLGPEESBI8T1WO5YJLZXY4JAGN6QO8JIVQLL8N570XEEXO2WCWQF0C2R07NHFKYJUK30GKUDTD8OD0LIEY2GVY8L4QAEVS0ZEYYAAYMGBG4KRXGE3TNCBODYN243TXPE169HOBGZ4L64ZKBQXH0NPTQJPYHC2VLHFPGF8\n",
      "10 JFE57 2011/05/02 12:06:47 63 LTMQBIY 0AECEEPM3ICWIE96EYLS5C3HOFW3JEB2JOKE57IZOHPQ1FMJGK9S09ZP2IFI821ODI7AI3R21Z8YIVOAXIZ4ACXPSGHQ7X84WUWYXF5L8LM0M62TZ37H0D9W0SL8KIOE2KLSS22PLIQGT58Y57O6HLGFRZPAVTW4TTWKCSZBU9W8HYTOEM45QRXZZD9Q9PFK3ZXD1CA0R09X43ZJIDQWVMQRS7WW8LXXW92K0R3T78VRS06B082X57ABJHOAL7D19BW5TYCWZJCD1FXYHURE0FZ0D8J8T3C72Y3T0CEVGQR2YSBRHQRJ26CT8WYFH04K88D28Y7GVLJSMSNTM50BTU7EZY1WFW8PSDV2PKFR3YDY0IJ6U09PC5FC22QS219O6C9FM1ONB6QI\n",
      "11 CC0I9 2008/05/12 20:48:59 21 B FVH2LA98687JFS2OT7LU2F3DR4Q\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 6, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Searching and deleting a range of count values:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849ea10>,\n",
       " <datagrid.Event at 0x7fc83849d450>,\n",
       " <datagrid.Event at 0x7fc83849dc90>,\n",
       " <datagrid.Event at 0x7fc83849d360>]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid.search(column=\"count\", value=(20, 21))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.delete_row(column=\"count\", value=(20, 21))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.search(column=\"count\", value=(20, 21))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Searching and deleting a range of name values:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849dd80>,\n",
       " <datagrid.Event at 0x7fc83849e5f0>,\n",
       " <datagrid.Event at 0x7fc83849ee00>,\n",
       " <datagrid.Event at 0x7fc83849e680>,\n",
       " <datagrid.Event at 0x7fc83849e7d0>,\n",
       " <datagrid.Event at 0x7fc83849eda0>,\n",
       " <datagrid.Event at 0x7fc83849d1b0>,\n",
       " <datagrid.Event at 0x7fc83849e7a0>,\n",
       " <datagrid.Event at 0x7fc83849d420>,\n",
       " <datagrid.Event at 0x7fc83849ea40>,\n",
       " <datagrid.Event at 0x7fc83849ee30>,\n",
       " <datagrid.Event at 0x7fc83849d1e0>,\n",
       " <datagrid.Event at 0x7fc83849e3b0>,\n",
       " <datagrid.Event at 0x7fc83849e950>,\n",
       " <datagrid.Event at 0x7fc83849d780>,\n",
       " <datagrid.Event at 0x7fc83849d0f0>,\n",
       " <datagrid.Event at 0x7fc83849cdf0>,\n",
       " <datagrid.Event at 0x7fc83849d390>,\n",
       " <datagrid.Event at 0x7fc83849e740>,\n",
       " <datagrid.Event at 0x7fc83849ee90>,\n",
       " <datagrid.Event at 0x7fc83849ef80>,\n",
       " <datagrid.Event at 0x7fc83849d120>,\n",
       " <datagrid.Event at 0x7fc83849ec50>,\n",
       " <datagrid.Event at 0x7fc83849ed10>,\n",
       " <datagrid.Event at 0x7fc83849ebc0>,\n",
       " <datagrid.Event at 0x7fc83849e890>,\n",
       " <datagrid.Event at 0x7fc83849e980>,\n",
       " <datagrid.Event at 0x7fc83849e8c0>,\n",
       " <datagrid.Event at 0x7fc83849dcc0>,\n",
       " <datagrid.Event at 0x7fc83849e9e0>,\n",
       " <datagrid.Event at 0x7fc83849d180>,\n",
       " <datagrid.Event at 0x7fc83849eb60>]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid.search(\"name\", \"A\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.delete_row(\"name\", \"A\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.search(\"name\", \"A\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Searching and deleting a range of content values:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849e5c0>,\n",
       " <datagrid.Event at 0x7fc83849ed70>,\n",
       " <datagrid.Event at 0x7fc83849ef50>,\n",
       " <datagrid.Event at 0x7fc83849d7b0>,\n",
       " <datagrid.Event at 0x7fc83849dc00>,\n",
       " <datagrid.Event at 0x7fc83849cd60>,\n",
       " <datagrid.Event at 0x7fc83849e710>,\n",
       " <datagrid.Event at 0x7fc83849ee60>,\n",
       " <datagrid.Event at 0x7fc83849dd20>]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid.search(\"content\", \"XS\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.delete_row(\"content\", \"XS\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.search(\"content\", \"XS\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### `.search(column, value)`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.search(column=\"id\", value=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.search(column=\"owner_id\", value=\"ZXR2E\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.search(\"creation_date\", (\"2007/03/22 00:00:00\", \"2007/06/23 00:00:00\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849ecb0>]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid.search(column=\"count\", value=(18, 19))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.search(\"name\", \"AL\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849e3e0>,\n",
       " <datagrid.Event at 0x7fc83849e620>,\n",
       " <datagrid.Event at 0x7fc83849d2d0>,\n",
       " <datagrid.Event at 0x7fc83849d750>,\n",
       " <datagrid.Event at 0x7fc83849d720>,\n",
       " <datagrid.Event at 0x7fc83849eec0>]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid.search(\"content\", \"XC\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### `.sort(column, direction = 'asc')`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.sort(column=\"id\", direction=\"desc\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now the `show()` method will show the sorted datagrid:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "97 Q6QIV 2005/08/27 11:10:15 44 BEKWHEDU 9WBOBVP13KLY6QXADERS7PZXML4OJHSCFSTA7LOFQLQNKPK26UXLUSP3OMAR2PFL1GMDVTV3C1LTIINE0UQ40W87TRXPHMM8SVKLA1V080BI9M4EAI2XUAEL2GC12QEVJ43Z60MOH5WS27HPS3OB2R7VNJ8T4N6GOT24IAEP36MJSM56O7BFC776LYO7XUR69T1O2AGE3T7T9ITECRFQXPV0IFSAO8CB0V0EOJM49PB8\n",
      "95 WQOPA 2005/08/07 01:04:22 60 KGBN XVYVQAPG8BAW08UXUB3MHYSMEFF3N77C24K8NZ8YA670YF2NE5N5PU3MDZ91DB45DCL4LSPKZ90UVBK3SYTSI4B5GYCBNRZ6ODHUSFLP2EINHYLAJ4W098HT6RHXXGGR7ADB3S824EWZC2MHEYX1WDEPKC5GK1MN6XJO9BA712U9QCP3NHW347GCC6Q4W0OCOPLUM7G9VAOXY7LE3UP9RY0UEUPMMCBE8YKBE1S2R2ATDQUL44IWDWP15ZSRCZ3N3GRHYMLRZABL95LO51J9Q1ATZFKE50TKT61EIOYH6BGQ598EVJKPYIA17NXX183VK59W5LHLOIY8A38EDCZXFYBM5YJ2OHW9X0U47G7QBLJEBTBK5SC6ZAO6QV1X7ZLQNC\n",
      "91 5TGG2 2001/05/19 22:57:08 37 LJ 7RKHPOOZ98AIV7OTSUD4N68II12AP42RQQQE3P6YU0IPGBIFPOB6E3ZIA0QRLV164GML8GJVC6SL478HS6JORVAZZDDHRRAV870W6VVNNG0HN5CAF5J919Z9YKD534ITS4JWU2E57GQLYWISG7ZST391B5NC8OENRQKZP8CBAOT3EV01KOAZXM3PTPTZ8K0K2SMLO05QYANK9ZJO3MSJ41YI8P3Y43UA7CJ5OK1108EEIQDECVMFCPEQPAOY4OFFQED9OCL2VR5MIW193VK17G0ZMBWP6GF3J3YJ06UJW1U7JU9W5Y0LTQATISBX4\n",
      "90 1ULFO 2005/02/30 06:22:44 3  0VKYRT5R2742DXU3S3QZPAR7A4XJL6J6PTJP21GLMQ7OZM8VTHRNMARB8E4L87D7JK1BHECY64ZB11CG8FT5QGB2XA007G55NNB6YBBCZ7Y43SYDHGE7JHHKTXYYIT7C5WN2HI9M9F3WOCP6VCYVZFFBQYX8BQ05KP4JIHJ96ZH0034UAG7QJAJRL24B9N6P9L6F9V\n",
      "89 H5JPW 2002/10/29 03:59:07 54 JZDOOTKBZCD LHW7A96N7EK9KF8JUYL9QI7BBSUYFKIS42P0W7MZL5HUXC4F52D9P5EYANVXFVCZB4UEOPDMPUDMQ0U2Y93KDDB441PPNQCYDIIU7H63KILNF89THJJIKWGIGUCOBVYLT1MZLBCFPY24F8YFADECV6L0CA0PBA7E1TN4L2ASU1XU0MY24LTOWRCA5ZWB1ES8P7JV71KDR34PPLTQNJRO7LHX6UWG3F2VR3R7QDLOB057N98BLY3QXZHHAE3D73JVDFABZ9CX0EMSHQOMCOLWH4JN\n",
      "87 AQGCI 2003/04/07 04:23:58 67 OL PPID6DEG9XBVSR1YAZCEFT697I8V3ZKLFMDJSJIO7QFOZ73R4T2NUW2GWRIBCY0EU3GGFHW9MOS9ZIZJ5S5T65BT5I75ESCVE8UQGRYPZULG1NCPTIR6JXUYP0PECJ9FJV5EID2OT4BLN51WYBLQJ\n",
      "86 489VJ 2002/02/30 20:20:36 26 XJHPLIB L6HVU0L3PVKXL\n",
      "85 KAYLB 2014/02/13 10:13:12 16 IHDEWWXCCUJTSB 2A5BRFICV9C3TOSDQB18IDQDWBV9O7XBJUPW3VDQJSKZTPYQR1W7A9M8I9NC1ADKFNX55B7HD5BWD80FTMHPCA8L6UX5M507NIBU0XRJ2JAUZP9AK1P8MJG7IGY02WABOOV7RS1C4EDEU7EFIA\n",
      "84 QQ8JV 2011/02/11 04:04:41 32 WPBERCHVQY MNCQ29O6X8CZC9XYQSYAVQ1P6DWAT8L0SME4G3S7XRTLFV7UDYAZ73HVX32HSN9VZ2WOD443WEHTMTK0X4L9POA5TIZNOHGT9TSF8NUJVHZC9TFU1WC4LKMHH7HFTDRWJ16MPTBN7NZVDHYOFDM75ZDBNXO32ABSE6HZ8HEA4ER0BCNJHGQTZEAJO5PJ95NPV3IO314WF0JIV45MOTR1PIXGQI4JPQOHYKXWKILQXE0AO5TINRCVIS9F4D5H7YSIBZ112ARI2B1Y49FI5B1YUG5V282WB\n",
      "82 4VZ15 2007/02/08 13:22:59 30 BDR UPML1OPQN6JSNUQYC8K01J145TP8ERKDUFLKIGMFSZ1X0GKCZ0MHY8OUQQWVXJISFVTKEDG63RMNK2R6CTDAC3FAC584DSJLXEATFKEABKEIA95DUME2OLBFI8ODVJDGYTV01IFKYAVOQHSE4T40W655D5ETT\n",
      "81 QMBSH 2018/06/10 00:08:00 5 FVVD 507FLGTO3EPW9CE48TRS6DDJIAPNUBAZJFJU0GD2HE4W1ZZOMAAGVJNK1CBGD4OF3FSDQ3313QQOMS9QKQHN129GJAIZ6M84PT1DBEH6TSEI28CDB6Y34QCKZ19LLMNPTM63F2BPZQX4HN9UG1TLVTDQV39WW1G7VADNAK9EUHI1BFJTRSUVDMWYHNJLYK2F1MDFJ3X8TMVQOMP8NMV6JB71NORJN77P8STQVKMVR2AFAMHGMNNNAFEI4ELIZUJAMH49SA9LZDRX4I9LEJ6L0CH4\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 10, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can sort the data by whatever column you'd like."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.sort(column=\"count\", direction=\"desc\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "66 BE3E8 2015/10/23 13:29:31 97 RSELTCOIOFSKXQKYW 3F0Z617X5Y75WK72S8DB1PDQPGTUBVBROQAYS0V5PFIBMRB87K9NZLGKQDLAIEEDBBPKVQB0K7QOB9TRZMGDJSIZS8P79GHW6DU8QS68JT\n",
      "76 ODE8H 2007/10/10 16:10:44 96 XTYDT TN2UOZ9BMXERXFJEXG8C7ARHY7ATP5V63PDCCJLDVVKNWWI0BJXX3FIAHFEU3XOYUD3HYY2ICGHREFYGQF9YU9CF4RUSJR74L8DOJ79ZSR3ATO8JXBLWKWPS1TPXJ238RNEI8ZM3C12V1BJCLWASWCAF2SLDVQS7HEURVW1U6BP4U9Z82OMPOL2JAL2G5B38EORQOR9D5XASOE4Q2G5MQE4VW9GDAVMLNPVMSTEU276EX4YT0YDDK1R6O8BGJMWP483LGIWLAX8RP54S3ZGJ3285K36X8CW5R9A4IE3Z4Q1L1UPKWBJXQYXWA9\n",
      "17 SMZFF 2015/04/03 06:38:54 92 SNYMBW YMFD07XJD6XDIK4IXIUF6XEKJRC56K8T7JJCCFEAG5FEFK5FZ8M7VRV7ZFNII64UV50WQEL3U0GH8AKGYP045COZ1ZHA2ZSOEHC5X0Z6E6BZ9NETQXKRN1WG5Z5VP2C0I7XUC3FRSBGYWY7DFQJUO60APLM30UFZI1NEWTSF7LI1HZOB0D6XUQFAUYPQPWCHW59UL1LM26UXG9DE471PWTLEUC51VAYN9XJII9Q5C84VAHE0SATN563KWYQ72AHOTCLGVCLOAQZ9YTWECA7W244ZKJOJIXQVT9VFJDEJRQ46ZDCF2YV1END8BZ09JUT3WGGNKZZ534CWR0A0M625XOUTXC8W65NST1X69\n",
      "55 RTWJF 2010/02/07 00:00:44 92 WPLV ZZINXCUTEL8JD9FMFWQ2H6SU9XPTLUEWYGJA2LWWC41R93BEFEHBR49W815TVHWAB1KRFBN0JE3AY50VPOTOAET7M8X8FZ0QQFED2Y8LE1WHH5TCD0PD921ZN4KPRJL1ISFAQ5V5414YVK0DVOUNGM0O08FGD6ZWEI9Z3XGO2NJJFKZVPPPUWDIJHTPK4VTHZL34CTG2Q44\n",
      "48 SZALH 2003/08/05 20:22:57 87 X T0RVIOY7DNG9N0GET7PJP1CM22DCKCWQJ9QKBKZ4G240LG1J8FDI4TYAJ9INSVRTESAIPT257744LHVWYKXMNFUSNSIRTVXXNQUNM1JP698YR330M6HPGVBQIX9I8BSXXZ4SED5V6F58ON8GIU05H5TU6XKYEUSPYI3P3OYY2IM8DIOAZXVD42NXEABXZ2O48N4CWT0T94HGJMN6Z0W4U3CTZVKVM7T769T60MNNRRYDLKOZ19ONQV028IGPDNBADJEYASMTUY3WX51DK078KHFTA98UAYHQFM54NMJ1SPYJ2QLH2D9H2P0MZZNNIN53RG1Y2TYGPQ\n",
      "31 FSM4V 2002/08/13 12:37:02 79 PWEZLLSEFHE WBRGYCMIQ7CZEOF62NCWYZ70RAC839V0N3M2SQX1G0FX0EB42AOGLIIDGPPSCHQ3R5OXGZWITYN8C9ESYW34TK6N9RJWN429AXJ21Y65INIO6LUBP9J6OPFXBDYYSVPZBB1PYJE76OGNXDVVD2C0V2YJV0G5VECT145Y14JDGNI8PUC5TVFO2I4LKBU1A2M7LU9XHIO9KNI24EV4Q9K56JL3K8HN336X07J2N0T1BC59CJRY3EG1D2RSG5ONN4TUF53GLXOV8NX8V4SYZIPM8U7JZQAO24Y6K43QQ973FISAQYJS4XO9C1OL3TARN67DKS3I14CYKZXCGLGZ93FFEP3KA52KEFOWM2QC2SJ3ZFPAN1FFMO8HWYGSN64G5MHEHHCTHWPE\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n",
      "35 W228J 2004/08/28 03:28:24 75 YJKTZELQSOBGKH TYV9Q9R2MRT04WRBG08BPCZ544CO7TP43WFE2NQU4RICM8F7PY09L004Q2MSJHJEAQ3RDIZFMWBAHGUCOMDCWRIRGTUOBBPMCBXJNMTF8MI1CA6K0LXKYALXM6WI9YRC0Z0UKS2NJXLQGBU4MK3ZXPRX2BWPG0TSAAQB4COJOEJWT6WY982ETP2GRI91DAUD7UPPTDAJ1K6M00AR3YU6EKE5LG1U6Z1LHM4E544LYSPRM4QAQE1VF2W2FCPDTS4CJUWOITVIBEA7BAPJEKHLTLCMQRVBK5XDEDA5MI5HC5M0YU4MCMGOK0F6V1ZC\n",
      "59 4PG52 2009/02/27 23:21:29 75 MTYXCX Y4JSQCD9L0GQZ1VXHT81NKZDT5GJADBMBIF3F7V8PYXVL1CUWZ9WC59MBUT0TWRXF89I8MQXN84P2GC020HMOMMWS5TVPP4R0JI5VEMDPR\n",
      "80 O2WTL 2011/06/24 06:45:51 71 NNROFHKJXM ID8SH1OKNVRWIACJ6QZ9YQLC8NAHKEWT557MMBOPBB5FLHRXUWW03RYWSORPLYZKZ0DQWV69M28WUIV9TM2JGPNTJAMLC4Q4EJ064WM1EZ5FZDEQOGYOP46JU1J8V63E7LW2VBHJ3X6O5IAGXYB8L5PX92N4XCO4WBPIGYS0JI2CXGLRK3HL7PWU27ACKL4BGAGSUHN2NIPBQB7L9CFAQAJHPNG5DOKZ4TMA5LZTHQMCAT3TZHJU5HHBF8UT2OCV273PCK6F7C71QY7BBSNKXULUALRYO6O6S9E45A48POD6IAR2YZXY7YO7XB6O8RWGMPSGFF4XOP3YRQT\n",
      "7 D9WY9 2007/08/29 16:38:41 67 WZXGOO E5A7YC18L1D2E2JKXQK2P0HQIR8FEVC2X7125TKUG2R9NWVY4J52C8IXABILTLJ83YZ8HOQFLVDX5ON7TIJIXM7E6PCKIC3A8E52HXASJQ34HEJMH3GZ90V0YU3UK9GKZ9JTNJ2KGGPUBIE53O7IP162UXOAKT48EPKN8YZPA4EU1NG4P643XMTGCSUL9G6UW3QWWTLYBYMJ\n",
      "87 AQGCI 2003/04/07 04:23:58 67 OL PPID6DEG9XBVSR1YAZCEFT697I8V3ZKLFMDJSJIO7QFOZ73R4T2NUW2GWRIBCY0EU3GGFHW9MOS9ZIZJ5S5T65BT5I75ESCVE8UQGRYPZULG1NCPTIR6JXUYP0PECJ9FJV5EID2OT4BLN51WYBLQJ\n",
      "38 S7S85 2009/10/18 16:44:01 66 YFSECFTXULGJYSJW YNXXO0RFL0VUCCXX6OPPZV8Q5CJG7E0G6KZB64XILPO5GWPCHJVN786K9XLYBUWLYVBPX4OAWI865MANS306BHQXAHIGNAM03H6127EGM4RRM5UOF7\n",
      "67 SP9B7 2015/01/08 18:52:13 65 KZD 27QKDT9GIY47GDEY3HCWFAQIOKF4VKOFR98FTMUK8EVR52UDDAD01H6LKF21569ROJHH2641I07D7SOHQZVU1TG3OWFJWRPQQC1DMMFV1JSQ0X3MKANWD94Y40EWGEY667SADN7LCARFEVP1D4R7WHHWU69QNTC3Q8HY8VU7S18UVN38NVVBOBJ04E84JQ5JV88VSEQ0RG9AOQ14Y393F3G7VJW3SAH5IJCL8J542SKNIVDBA75CDLJ\n",
      "10 JFE57 2011/05/02 12:06:47 63 LTMQBIY 0AECEEPM3ICWIE96EYLS5C3HOFW3JEB2JOKE57IZOHPQ1FMJGK9S09ZP2IFI821ODI7AI3R21Z8YIVOAXIZ4ACXPSGHQ7X84WUWYXF5L8LM0M62TZ37H0D9W0SL8KIOE2KLSS22PLIQGT58Y57O6HLGFRZPAVTW4TTWKCSZBU9W8HYTOEM45QRXZZD9Q9PFK3ZXD1CA0R09X43ZJIDQWVMQRS7WW8LXXW92K0R3T78VRS06B082X57ABJHOAL7D19BW5TYCWZJCD1FXYHURE0FZ0D8J8T3C72Y3T0CEVGQR2YSBRHQRJ26CT8WYFH04K88D28Y7GVLJSMSNTM50BTU7EZY1WFW8PSDV2PKFR3YDY0IJ6U09PC5FC22QS219O6C9FM1ONB6QI\n",
      "34 JICD3 2001/04/26 08:22:34 63  8SX88CPDO5TXH4LYJG174GR5V8F58TQCR6VGXEPNWHGS86EF4B9WV3EKW3TSUOG5UI7S42ZO2KA8WMOJL1GDTLMCS8MXFQSVBBZV1NVRL5RFY0HSPAVVR7094G2L8CV76MZSHHLDE31CNR95D597L1FRSIX6OWZ74T5C05Q8INZBXOZWAAYLCX2BV9OXVYG5Z\n",
      "95 WQOPA 2005/08/07 01:04:22 60 KGBN XVYVQAPG8BAW08UXUB3MHYSMEFF3N77C24K8NZ8YA670YF2NE5N5PU3MDZ91DB45DCL4LSPKZ90UVBK3SYTSI4B5GYCBNRZ6ODHUSFLP2EINHYLAJ4W098HT6RHXXGGR7ADB3S824EWZC2MHEYX1WDEPKC5GK1MN6XJO9BA712U9QCP3NHW347GCC6Q4W0OCOPLUM7G9VAOXY7LE3UP9RY0UEUPMMCBE8YKBE1S2R2ATDQUL44IWDWP15ZSRCZ3N3GRHYMLRZABL95LO51J9Q1ATZFKE50TKT61EIOYH6BGQ598EVJKPYIA17NXX183VK59W5LHLOIY8A38EDCZXFYBM5YJ2OHW9X0U47G7QBLJEBTBK5SC6ZAO6QV1X7ZLQNC\n",
      "71 BKP3V 2010/03/31 11:04:14 58 ITIU GDMFX3YTJBW7PUBVDLW0LTKWS8HGJCLNV2QZCUU3JYY9CQGXH18IWEH25QN5995T8Z0ZMPSGTAD3YNGKDH2SAOPAJ9P6AZT51ZQ6WCQNUX65HLY\n",
      "23 LK6SQ 2001/02/27 05:21:13 56 GHTTTVZX 5T1BJDS7M6OR0VBD86A4FTEYSXKVTXBEU\n",
      "74 8JD5N 2009/05/27 16:51:18 54 D FRR4NXB0EZO7OAD7EGFK0HJ3HFNN83LQGEV883QUHL6FYW1LLNYV0JYSRBGZ9L41XTFUBFOBQ05RQHRTHMTGR4XBV7VILYBZ07MQDPZ2LHAKQC8QVSJRILTV0RKG3UYEG2VHP7BIMJZN6U197ER40U1NCBWYIIPMFOKTUOJWEV3NY6UJUYMJOPVEXOA1F4L37NLPB1NPHQ3ABAO5OJBUX36TCW2KOY3EP88BR6UBGBRN6VZRGO4T06DNDFD3265LSZ7WBTJXHZBR7WBH1RLS8B6BWY7HVLK9KCAE6C3CFOF1YN4BPDG9H7JD\n",
      "89 H5JPW 2002/10/29 03:59:07 54 JZDOOTKBZCD LHW7A96N7EK9KF8JUYL9QI7BBSUYFKIS42P0W7MZL5HUXC4F52D9P5EYANVXFVCZB4UEOPDMPUDMQ0U2Y93KDDB441PPNQCYDIIU7H63KILNF89THJJIKWGIGUCOBVYLT1MZLBCFPY24F8YFADECV6L0CA0PBA7E1TN4L2ASU1XU0MY24LTOWRCA5ZWB1ES8P7JV71KDR34PPLTQNJRO7LHX6UWG3F2VR3R7QDLOB057N98BLY3QXZHHAE3D73JVDFABZ9CX0EMSHQOMCOLWH4JN\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 20, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If you want to delete according to the position in the sorted dataframe, you can use the `delete_row()` method:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid.delete_row(column=\"position\", value=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "66 BE3E8 2015/10/23 13:29:31 97 RSELTCOIOFSKXQKYW 3F0Z617X5Y75WK72S8DB1PDQPGTUBVBROQAYS0V5PFIBMRB87K9NZLGKQDLAIEEDBBPKVQB0K7QOB9TRZMGDJSIZS8P79GHW6DU8QS68JT\n",
      "17 SMZFF 2015/04/03 06:38:54 92 SNYMBW YMFD07XJD6XDIK4IXIUF6XEKJRC56K8T7JJCCFEAG5FEFK5FZ8M7VRV7ZFNII64UV50WQEL3U0GH8AKGYP045COZ1ZHA2ZSOEHC5X0Z6E6BZ9NETQXKRN1WG5Z5VP2C0I7XUC3FRSBGYWY7DFQJUO60APLM30UFZI1NEWTSF7LI1HZOB0D6XUQFAUYPQPWCHW59UL1LM26UXG9DE471PWTLEUC51VAYN9XJII9Q5C84VAHE0SATN563KWYQ72AHOTCLGVCLOAQZ9YTWECA7W244ZKJOJIXQVT9VFJDEJRQ46ZDCF2YV1END8BZ09JUT3WGGNKZZ534CWR0A0M625XOUTXC8W65NST1X69\n",
      "55 RTWJF 2010/02/07 00:00:44 92 WPLV ZZINXCUTEL8JD9FMFWQ2H6SU9XPTLUEWYGJA2LWWC41R93BEFEHBR49W815TVHWAB1KRFBN0JE3AY50VPOTOAET7M8X8FZ0QQFED2Y8LE1WHH5TCD0PD921ZN4KPRJL1ISFAQ5V5414YVK0DVOUNGM0O08FGD6ZWEI9Z3XGO2NJJFKZVPPPUWDIJHTPK4VTHZL34CTG2Q44\n",
      "48 SZALH 2003/08/05 20:22:57 87 X T0RVIOY7DNG9N0GET7PJP1CM22DCKCWQJ9QKBKZ4G240LG1J8FDI4TYAJ9INSVRTESAIPT257744LHVWYKXMNFUSNSIRTVXXNQUNM1JP698YR330M6HPGVBQIX9I8BSXXZ4SED5V6F58ON8GIU05H5TU6XKYEUSPYI3P3OYY2IM8DIOAZXVD42NXEABXZ2O48N4CWT0T94HGJMN6Z0W4U3CTZVKVM7T769T60MNNRRYDLKOZ19ONQV028IGPDNBADJEYASMTUY3WX51DK078KHFTA98UAYHQFM54NMJ1SPYJ2QLH2D9H2P0MZZNNIN53RG1Y2TYGPQ\n",
      "31 FSM4V 2002/08/13 12:37:02 79 PWEZLLSEFHE WBRGYCMIQ7CZEOF62NCWYZ70RAC839V0N3M2SQX1G0FX0EB42AOGLIIDGPPSCHQ3R5OXGZWITYN8C9ESYW34TK6N9RJWN429AXJ21Y65INIO6LUBP9J6OPFXBDYYSVPZBB1PYJE76OGNXDVVD2C0V2YJV0G5VECT145Y14JDGNI8PUC5TVFO2I4LKBU1A2M7LU9XHIO9KNI24EV4Q9K56JL3K8HN336X07J2N0T1BC59CJRY3EG1D2RSG5ONN4TUF53GLXOV8NX8V4SYZIPM8U7JZQAO24Y6K43QQ973FISAQYJS4XO9C1OL3TARN67DKS3I14CYKZXCGLGZ93FFEP3KA52KEFOWM2QC2SJ3ZFPAN1FFMO8HWYGSN64G5MHEHHCTHWPE\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 5, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849e590>,\n",
       " <datagrid.Event at 0x7fc83849e3e0>,\n",
       " <datagrid.Event at 0x7fc83849d2d0>,\n",
       " <datagrid.Event at 0x7fc83849e6e0>,\n",
       " <datagrid.Event at 0x7fc83849e620>,\n",
       " <datagrid.Event at 0x7fc83849e9b0>]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid.show(0, 5, prints=False, returns=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### `.select_count(i, j)`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This method returns the entries between $i$ and $j$, $[i, j]$, considering the `count` feature sorted in ascending order."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849ce20>,\n",
       " <datagrid.Event at 0x7fc83849e650>,\n",
       " <datagrid.Event at 0x7fc83849e920>,\n",
       " <datagrid.Event at 0x7fc83849d000>,\n",
       " <datagrid.Event at 0x7fc83849eb00>,\n",
       " <datagrid.Event at 0x7fc83849e830>,\n",
       " <datagrid.Event at 0x7fc83849dd50>,\n",
       " <datagrid.Event at 0x7fc83849d300>,\n",
       " <datagrid.Event at 0x7fc83849eb90>,\n",
       " <datagrid.Event at 0x7fc83849d750>,\n",
       " <datagrid.Event at 0x7fc83849e800>]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# to use median-of-medians\n",
    "datagrid.select_count(0, 10, how=\"median-of-medians\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849ce20>,\n",
       " <datagrid.Event at 0x7fc83849e650>,\n",
       " <datagrid.Event at 0x7fc83849d000>,\n",
       " <datagrid.Event at 0x7fc83849e920>,\n",
       " <datagrid.Event at 0x7fc83849eb00>,\n",
       " <datagrid.Event at 0x7fc83849e830>,\n",
       " <datagrid.Event at 0x7fc83849d300>,\n",
       " <datagrid.Event at 0x7fc83849dd50>,\n",
       " <datagrid.Event at 0x7fc83849eb90>,\n",
       " <datagrid.Event at 0x7fc83849d750>,\n",
       " <datagrid.Event at 0x7fc83849e800>]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# to use quickselect\n",
    "datagrid.select_count(0, 10, how = \"quickselect\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849ce20>,\n",
       " <datagrid.Event at 0x7fc83849e650>,\n",
       " <datagrid.Event at 0x7fc83849e920>,\n",
       " <datagrid.Event at 0x7fc83849d000>,\n",
       " <datagrid.Event at 0x7fc83849eb00>,\n",
       " <datagrid.Event at 0x7fc83849e830>,\n",
       " <datagrid.Event at 0x7fc83849d300>,\n",
       " <datagrid.Event at 0x7fc83849dd50>,\n",
       " <datagrid.Event at 0x7fc83849eb90>,\n",
       " <datagrid.Event at 0x7fc83849d750>,\n",
       " <datagrid.Event at 0x7fc83849e800>]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# to use heapsort\n",
    "datagrid.select_count(0, 10, how=\"heapsort\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Also, the `select_count()` method does not change the internal state of the data structure, which can be confirmed by the `.show()` method. It shows the result of the last-applied sorting, before the `select_count()`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "66 BE3E8 2015/10/23 13:29:31 97 RSELTCOIOFSKXQKYW 3F0Z617X5Y75WK72S8DB1PDQPGTUBVBROQAYS0V5PFIBMRB87K9NZLGKQDLAIEEDBBPKVQB0K7QOB9TRZMGDJSIZS8P79GHW6DU8QS68JT\n",
      "17 SMZFF 2015/04/03 06:38:54 92 SNYMBW YMFD07XJD6XDIK4IXIUF6XEKJRC56K8T7JJCCFEAG5FEFK5FZ8M7VRV7ZFNII64UV50WQEL3U0GH8AKGYP045COZ1ZHA2ZSOEHC5X0Z6E6BZ9NETQXKRN1WG5Z5VP2C0I7XUC3FRSBGYWY7DFQJUO60APLM30UFZI1NEWTSF7LI1HZOB0D6XUQFAUYPQPWCHW59UL1LM26UXG9DE471PWTLEUC51VAYN9XJII9Q5C84VAHE0SATN563KWYQ72AHOTCLGVCLOAQZ9YTWECA7W244ZKJOJIXQVT9VFJDEJRQ46ZDCF2YV1END8BZ09JUT3WGGNKZZ534CWR0A0M625XOUTXC8W65NST1X69\n",
      "55 RTWJF 2010/02/07 00:00:44 92 WPLV ZZINXCUTEL8JD9FMFWQ2H6SU9XPTLUEWYGJA2LWWC41R93BEFEHBR49W815TVHWAB1KRFBN0JE3AY50VPOTOAET7M8X8FZ0QQFED2Y8LE1WHH5TCD0PD921ZN4KPRJL1ISFAQ5V5414YVK0DVOUNGM0O08FGD6ZWEI9Z3XGO2NJJFKZVPPPUWDIJHTPK4VTHZL34CTG2Q44\n",
      "48 SZALH 2003/08/05 20:22:57 87 X T0RVIOY7DNG9N0GET7PJP1CM22DCKCWQJ9QKBKZ4G240LG1J8FDI4TYAJ9INSVRTESAIPT257744LHVWYKXMNFUSNSIRTVXXNQUNM1JP698YR330M6HPGVBQIX9I8BSXXZ4SED5V6F58ON8GIU05H5TU6XKYEUSPYI3P3OYY2IM8DIOAZXVD42NXEABXZ2O48N4CWT0T94HGJMN6Z0W4U3CTZVKVM7T769T60MNNRRYDLKOZ19ONQV028IGPDNBADJEYASMTUY3WX51DK078KHFTA98UAYHQFM54NMJ1SPYJ2QLH2D9H2P0MZZNNIN53RG1Y2TYGPQ\n",
      "31 FSM4V 2002/08/13 12:37:02 79 PWEZLLSEFHE WBRGYCMIQ7CZEOF62NCWYZ70RAC839V0N3M2SQX1G0FX0EB42AOGLIIDGPPSCHQ3R5OXGZWITYN8C9ESYW34TK6N9RJWN429AXJ21Y65INIO6LUBP9J6OPFXBDYYSVPZBB1PYJE76OGNXDVVD2C0V2YJV0G5VECT145Y14JDGNI8PUC5TVFO2I4LKBU1A2M7LU9XHIO9KNI24EV4Q9K56JL3K8HN336X07J2N0T1BC59CJRY3EG1D2RSG5ONN4TUF53GLXOV8NX8V4SYZIPM8U7JZQAO24Y6K43QQ973FISAQYJS4XO9C1OL3TARN67DKS3I14CYKZXCGLGZ93FFEP3KA52KEFOWM2QC2SJ3ZFPAN1FFMO8HWYGSN64G5MHEHHCTHWPE\n",
      "6 O4SL3 2013/08/31 11:59:40 77 PNJZVFDQJUXPEVEL 8V05E484KGCFAF7RQR0PAZ8WDD1PUQJVPVPMCDETJ6R3AYETY4\n",
      "35 W228J 2004/08/28 03:28:24 75 YJKTZELQSOBGKH TYV9Q9R2MRT04WRBG08BPCZ544CO7TP43WFE2NQU4RICM8F7PY09L004Q2MSJHJEAQ3RDIZFMWBAHGUCOMDCWRIRGTUOBBPMCBXJNMTF8MI1CA6K0LXKYALXM6WI9YRC0Z0UKS2NJXLQGBU4MK3ZXPRX2BWPG0TSAAQB4COJOEJWT6WY982ETP2GRI91DAUD7UPPTDAJ1K6M00AR3YU6EKE5LG1U6Z1LHM4E544LYSPRM4QAQE1VF2W2FCPDTS4CJUWOITVIBEA7BAPJEKHLTLCMQRVBK5XDEDA5MI5HC5M0YU4MCMGOK0F6V1ZC\n",
      "59 4PG52 2009/02/27 23:21:29 75 MTYXCX Y4JSQCD9L0GQZ1VXHT81NKZDT5GJADBMBIF3F7V8PYXVL1CUWZ9WC59MBUT0TWRXF89I8MQXN84P2GC020HMOMMWS5TVPP4R0JI5VEMDPR\n",
      "80 O2WTL 2011/06/24 06:45:51 71 NNROFHKJXM ID8SH1OKNVRWIACJ6QZ9YQLC8NAHKEWT557MMBOPBB5FLHRXUWW03RYWSORPLYZKZ0DQWV69M28WUIV9TM2JGPNTJAMLC4Q4EJ064WM1EZ5FZDEQOGYOP46JU1J8V63E7LW2VBHJ3X6O5IAGXYB8L5PX92N4XCO4WBPIGYS0JI2CXGLRK3HL7PWU27ACKL4BGAGSUHN2NIPBQB7L9CFAQAJHPNG5DOKZ4TMA5LZTHQMCAT3TZHJU5HHBF8UT2OCV273PCK6F7C71QY7BBSNKXULUALRYO6O6S9E45A48POD6IAR2YZXY7YO7XB6O8RWGMPSGFF4XOP3YRQT\n",
      "7 D9WY9 2007/08/29 16:38:41 67 WZXGOO E5A7YC18L1D2E2JKXQK2P0HQIR8FEVC2X7125TKUG2R9NWVY4J52C8IXABILTLJ83YZ8HOQFLVDX5ON7TIJIXM7E6PCKIC3A8E52HXASJQ34HEJMH3GZ90V0YU3UK9GKZ9JTNJ2KGGPUBIE53O7IP162UXOAKT48EPKN8YZPA4EU1NG4P643XMTGCSUL9G6UW3QWWTLYBYMJ\n",
      "87 AQGCI 2003/04/07 04:23:58 67 OL PPID6DEG9XBVSR1YAZCEFT697I8V3ZKLFMDJSJIO7QFOZ73R4T2NUW2GWRIBCY0EU3GGFHW9MOS9ZIZJ5S5T65BT5I75ESCVE8UQGRYPZULG1NCPTIR6JXUYP0PECJ9FJV5EID2OT4BLN51WYBLQJ\n",
      "38 S7S85 2009/10/18 16:44:01 66 YFSECFTXULGJYSJW YNXXO0RFL0VUCCXX6OPPZV8Q5CJG7E0G6KZB64XILPO5GWPCHJVN786K9XLYBUWLYVBPX4OAWI865MANS306BHQXAHIGNAM03H6127EGM4RRM5UOF7\n",
      "67 SP9B7 2015/01/08 18:52:13 65 KZD 27QKDT9GIY47GDEY3HCWFAQIOKF4VKOFR98FTMUK8EVR52UDDAD01H6LKF21569ROJHH2641I07D7SOHQZVU1TG3OWFJWRPQQC1DMMFV1JSQ0X3MKANWD94Y40EWGEY667SADN7LCARFEVP1D4R7WHHWU69QNTC3Q8HY8VU7S18UVN38NVVBOBJ04E84JQ5JV88VSEQ0RG9AOQ14Y393F3G7VJW3SAH5IJCL8J542SKNIVDBA75CDLJ\n",
      "10 JFE57 2011/05/02 12:06:47 63 LTMQBIY 0AECEEPM3ICWIE96EYLS5C3HOFW3JEB2JOKE57IZOHPQ1FMJGK9S09ZP2IFI821ODI7AI3R21Z8YIVOAXIZ4ACXPSGHQ7X84WUWYXF5L8LM0M62TZ37H0D9W0SL8KIOE2KLSS22PLIQGT58Y57O6HLGFRZPAVTW4TTWKCSZBU9W8HYTOEM45QRXZZD9Q9PFK3ZXD1CA0R09X43ZJIDQWVMQRS7WW8LXXW92K0R3T78VRS06B082X57ABJHOAL7D19BW5TYCWZJCD1FXYHURE0FZ0D8J8T3C72Y3T0CEVGQR2YSBRHQRJ26CT8WYFH04K88D28Y7GVLJSMSNTM50BTU7EZY1WFW8PSDV2PKFR3YDY0IJ6U09PC5FC22QS219O6C9FM1ONB6QI\n",
      "34 JICD3 2001/04/26 08:22:34 63  8SX88CPDO5TXH4LYJG174GR5V8F58TQCR6VGXEPNWHGS86EF4B9WV3EKW3TSUOG5UI7S42ZO2KA8WMOJL1GDTLMCS8MXFQSVBBZV1NVRL5RFY0HSPAVVR7094G2L8CV76MZSHHLDE31CNR95D597L1FRSIX6OWZ74T5C05Q8INZBXOZWAAYLCX2BV9OXVYG5Z\n",
      "95 WQOPA 2005/08/07 01:04:22 60 KGBN XVYVQAPG8BAW08UXUB3MHYSMEFF3N77C24K8NZ8YA670YF2NE5N5PU3MDZ91DB45DCL4LSPKZ90UVBK3SYTSI4B5GYCBNRZ6ODHUSFLP2EINHYLAJ4W098HT6RHXXGGR7ADB3S824EWZC2MHEYX1WDEPKC5GK1MN6XJO9BA712U9QCP3NHW347GCC6Q4W0OCOPLUM7G9VAOXY7LE3UP9RY0UEUPMMCBE8YKBE1S2R2ATDQUL44IWDWP15ZSRCZ3N3GRHYMLRZABL95LO51J9Q1ATZFKE50TKT61EIOYH6BGQ598EVJKPYIA17NXX183VK59W5LHLOIY8A38EDCZXFYBM5YJ2OHW9X0U47G7QBLJEBTBK5SC6ZAO6QV1X7ZLQNC\n",
      "71 BKP3V 2010/03/31 11:04:14 58 ITIU GDMFX3YTJBW7PUBVDLW0LTKWS8HGJCLNV2QZCUU3JYY9CQGXH18IWEH25QN5995T8Z0ZMPSGTAD3YNGKDH2SAOPAJ9P6AZT51ZQ6WCQNUX65HLY\n",
      "23 LK6SQ 2001/02/27 05:21:13 56 GHTTTVZX 5T1BJDS7M6OR0VBD86A4FTEYSXKVTXBEU\n",
      "74 8JD5N 2009/05/27 16:51:18 54 D FRR4NXB0EZO7OAD7EGFK0HJ3HFNN83LQGEV883QUHL6FYW1LLNYV0JYSRBGZ9L41XTFUBFOBQ05RQHRTHMTGR4XBV7VILYBZ07MQDPZ2LHAKQC8QVSJRILTV0RKG3UYEG2VHP7BIMJZN6U197ER40U1NCBWYIIPMFOKTUOJWEV3NY6UJUYMJOPVEXOA1F4L37NLPB1NPHQ3ABAO5OJBUX36TCW2KOY3EP88BR6UBGBRN6VZRGO4T06DNDFD3265LSZ7WBTJXHZBR7WBH1RLS8B6BWY7HVLK9KCAE6C3CFOF1YN4BPDG9H7JD\n",
      "89 H5JPW 2002/10/29 03:59:07 54 JZDOOTKBZCD LHW7A96N7EK9KF8JUYL9QI7BBSUYFKIS42P0W7MZL5HUXC4F52D9P5EYANVXFVCZB4UEOPDMPUDMQ0U2Y93KDDB441PPNQCYDIIU7H63KILNF89THJJIKWGIGUCOBVYLT1MZLBCFPY24F8YFADECV6L0CA0PBA7E1TN4L2ASU1XU0MY24LTOWRCA5ZWB1ES8P7JV71KDR34PPLTQNJRO7LHX6UWG3F2VR3R7QDLOB057N98BLY3QXZHHAE3D73JVDFABZ9CX0EMSHQOMCOLWH4JN\n",
      "75 GMHFG 2004/09/14 11:07:04 51 UPKPHREEHKGTTRFCG TETCY6N9EV99BEL463QI3N6M1801TD41FYYFLJZPYN0SMNYJA8VN2VGOWEEKSO2LCTCYGXXNHWAA5D0VGX1JJKMEL08ZWLXETS52EEGGPBS9JMX8MLWIO3GTBAUK9PTWG3U1YGC68EDBMUR6YICHOU6VGHLK0GT749KOPLWWOEH8Y4CSRS4CJL3ATL2QLAYNLZWV8IEVB8PA6OFXVF0FIGX8VSEAD8VZS2J3AW4NXWJUGZYTSF3GZDK9UG9R1DGQ3E3Z3V3NB9LG7FZJNAAWCEL7DTB7X9X78HACEK4MUFUH5EU5Z8RY9C5ZY2VPBPIO8QX59LM51NVKH1ICMMQ7608XI3ZOCJE82QL1CERZD74Y\n"
     ]
    }
   ],
   "source": [
    "datagrid.show(0, 20, prints=True, returns=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 🔎 Testing the **Open Addressing** nature of our **HashTable**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid2 = DataGrid()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's insert some values into the hashtable:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "ids = [1, 2, 3, 4, 5, 11, 21]\n",
    "\n",
    "for id in ids:\n",
    "    row = {}\n",
    "    row[\"id\"] = id\n",
    "    row[\"owner_id\"] = \"ABC123\"\n",
    "    row[\"creation_date\"] = \"2023/10/06 12:00:15\"\n",
    "    row[\"count\"] = id\n",
    "    row[\"name\"] = \"Item \" + str(id)\n",
    "    row[\"content\"] = \"This is the content for Item \" + str(id)\n",
    "    datagrid2.insert_row(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/felipe/Área de Trabalho/datagrid/src/datagrid.py:81: UserWarning: `end` is greater than the size of the datagrid, setting `end` to the datagrid size\n",
      "  warnings.warn(\"`end` is greater than the size of the datagrid, setting `end` to the datagrid size\")\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849fe80>,\n",
       " <datagrid.Event at 0x7fc83849f730>,\n",
       " <datagrid.Event at 0x7fc83849fdf0>,\n",
       " <datagrid.Event at 0x7fc83849fa90>,\n",
       " <datagrid.Event at 0x7fc83849fcd0>,\n",
       " <datagrid.Event at 0x7fc838300250>,\n",
       " <datagrid.Event at 0x7fc838300280>]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid2.show(0, 10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If we search for the `id = 1`, we will see:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<datagrid.Event at 0x7fc83849fe80>"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid2.search(column=\"id\", value=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Same for `id = 11`. Remember that our hash function is `h(x) = x % 10`, so they are both mapped to the same position."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<datagrid.Event at 0x7fc838300250>"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid2.search(column=\"id\", value=11)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's delete the entry with `id = 1`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid2.delete_row(column=\"id\", value=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid2.search(column=\"id\", value=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If our implementation is right, we should still be able to find the entry with `id = 11`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<datagrid.Event at 0x7fc838300250>"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid2.search(column=\"id\", value=11)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It seems to work just fine. Let's try to delete the entry with `id = 11`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid2.delete_row(column=\"id\", value=11)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If we search for it again, we should receive nothing:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "datagrid2.search(column=\"id\", value=11)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Also note that our `.show()` method shows us each row, removing the deleted entries."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<datagrid.Event at 0x7fc83849f730>,\n",
       " <datagrid.Event at 0x7fc83849fdf0>,\n",
       " <datagrid.Event at 0x7fc83849fa90>,\n",
       " <datagrid.Event at 0x7fc83849fcd0>,\n",
       " <datagrid.Event at 0x7fc838300280>]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid2.show(0, 10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Note that we also have the entry with `id = 21`, which is mapped to the same position as `id = 1` and `id = 11`. Let's try to find it:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<datagrid.Event at 0x7fc838300280>"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datagrid2.search(column=\"id\", value=21)"
   ]
  }
 ],
 "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.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}