queries.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>document</th>\n",
       "      <th>document_value</th>\n",
       "      <th>projid</th>\n",
       "      <th>tstamp</th>\n",
       "      <th>filename</th>\n",
       "      <th>img_ocr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>IMG_7385.jpeg</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>maddowmaddow V 2h\\nlol\\nmac_ryan 4h\\nwant to k...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   document document_value           projid              tstamp      filename  \\\n",
       "0         6  IMG_7385.jpeg  document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "\n",
       "                                             img_ocr  \n",
       "0  maddowmaddow V 2h\\nlol\\nmac_ryan 4h\\nwant to k...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import flor\n",
    "\n",
    "flor.dataframe(\"img_ocr\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>document</th>\n",
       "      <th>document_value</th>\n",
       "      <th>page</th>\n",
       "      <th>page_value</th>\n",
       "      <th>projid</th>\n",
       "      <th>tstamp</th>\n",
       "      <th>filename</th>\n",
       "      <th>page_ocr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:18-cv-01352-GLR Document 1 Filed 05/07/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>echonll Çont Rs.2\\nCase 1:18-CV-01352-GLR Docu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Secticn TU Cent Pgt\\nCase 1:18-CV-01352-GLR Do...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>19</td>\n",
       "      <td>18</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>20</td>\n",
       "      <td>19</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>21</td>\n",
       "      <td>20</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>22</td>\n",
       "      <td>21</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:08-CV-00270-AMD Document 2 Filed 01/31/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>23</td>\n",
       "      <td>22</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>Case 1:08-cv-00270-AMD Document 2. Filed 01/31...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    document                               document_value  page page_value  \\\n",
       "0          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf     1          0   \n",
       "1          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf     2          1   \n",
       "2          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf     3          2   \n",
       "3          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf     4          3   \n",
       "4          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf     5          4   \n",
       "..       ...                                          ...   ...        ...   \n",
       "63         5                143-Sparrow_v_Creed_et_al.pdf    19         18   \n",
       "64         5                143-Sparrow_v_Creed_et_al.pdf    20         19   \n",
       "65         5                143-Sparrow_v_Creed_et_al.pdf    21         20   \n",
       "66         5                143-Sparrow_v_Creed_et_al.pdf    22         21   \n",
       "67         5                143-Sparrow_v_Creed_et_al.pdf    23         22   \n",
       "\n",
       "             projid              tstamp      filename  \\\n",
       "0   document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "1   document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "2   document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "3   document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "4   document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "..              ...                 ...           ...   \n",
       "63  document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "64  document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "65  document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "66  document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "67  document_parser 2024-10-22 10:10:39  doc_demux.py   \n",
       "\n",
       "                                             page_ocr  \n",
       "0   Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...  \n",
       "1   Case 1:18-cv-01352-GLR Document 1 Filed 05/07/...  \n",
       "2   echonll Çont Rs.2\\nCase 1:18-CV-01352-GLR Docu...  \n",
       "3   Secticn TU Cent Pgt\\nCase 1:18-CV-01352-GLR Do...  \n",
       "4   Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...  \n",
       "..                                                ...  \n",
       "63  Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...  \n",
       "64  Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...  \n",
       "65  Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...  \n",
       "66  Case 1:08-CV-00270-AMD Document 2 Filed 01/31/...  \n",
       "67  Case 1:08-cv-00270-AMD Document 2. Filed 01/31...  \n",
       "\n",
       "[68 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flor.dataframe(\"page_ocr\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>document</th>\n",
       "      <th>document_value</th>\n",
       "      <th>projid</th>\n",
       "      <th>tstamp</th>\n",
       "      <th>filename</th>\n",
       "      <th>page</th>\n",
       "      <th>page_value</th>\n",
       "      <th>img_ocr</th>\n",
       "      <th>page_ocr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Case 1:18-cv-01352-GLR Document 1 Filed 05/07/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>echonll Çont Rs.2\\nCase 1:18-CV-01352-GLR Docu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Secticn TU Cent Pgt\\nCase 1:18-CV-01352-GLR Do...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>20.0</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>21.0</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>22.0</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Case 1:08-CV-00270-AMD Document 2 Filed 01/31/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>5</td>\n",
       "      <td>143-Sparrow_v_Creed_et_al.pdf</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>23.0</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Case 1:08-cv-00270-AMD Document 2. Filed 01/31...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>6</td>\n",
       "      <td>IMG_7385.jpeg</td>\n",
       "      <td>document_parser</td>\n",
       "      <td>2024-10-22 10:10:39</td>\n",
       "      <td>doc_demux.py</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>maddowmaddow V 2h\\nlol\\nmac_ryan 4h\\nwant to k...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>69 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    document                               document_value           projid  \\\n",
       "0          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf  document_parser   \n",
       "1          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf  document_parser   \n",
       "2          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf  document_parser   \n",
       "3          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf  document_parser   \n",
       "4          1  160-Marlon_Maynor_v_Jamal_Brunson_et_al.pdf  document_parser   \n",
       "..       ...                                          ...              ...   \n",
       "64         5                143-Sparrow_v_Creed_et_al.pdf  document_parser   \n",
       "65         5                143-Sparrow_v_Creed_et_al.pdf  document_parser   \n",
       "66         5                143-Sparrow_v_Creed_et_al.pdf  document_parser   \n",
       "67         5                143-Sparrow_v_Creed_et_al.pdf  document_parser   \n",
       "68         6                                IMG_7385.jpeg  document_parser   \n",
       "\n",
       "                tstamp      filename  page page_value  \\\n",
       "0  2024-10-22 10:10:39  doc_demux.py   1.0          0   \n",
       "1  2024-10-22 10:10:39  doc_demux.py   2.0          1   \n",
       "2  2024-10-22 10:10:39  doc_demux.py   3.0          2   \n",
       "3  2024-10-22 10:10:39  doc_demux.py   4.0          3   \n",
       "4  2024-10-22 10:10:39  doc_demux.py   5.0          4   \n",
       "..                 ...           ...   ...        ...   \n",
       "64 2024-10-22 10:10:39  doc_demux.py  20.0         19   \n",
       "65 2024-10-22 10:10:39  doc_demux.py  21.0         20   \n",
       "66 2024-10-22 10:10:39  doc_demux.py  22.0         21   \n",
       "67 2024-10-22 10:10:39  doc_demux.py  23.0         22   \n",
       "68 2024-10-22 10:10:39  doc_demux.py   NaN        NaN   \n",
       "\n",
       "                                              img_ocr  \\\n",
       "0                                                 NaN   \n",
       "1                                                 NaN   \n",
       "2                                                 NaN   \n",
       "3                                                 NaN   \n",
       "4                                                 NaN   \n",
       "..                                                ...   \n",
       "64                                                NaN   \n",
       "65                                                NaN   \n",
       "66                                                NaN   \n",
       "67                                                NaN   \n",
       "68  maddowmaddow V 2h\\nlol\\nmac_ryan 4h\\nwant to k...   \n",
       "\n",
       "                                             page_ocr  \n",
       "0   Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...  \n",
       "1   Case 1:18-cv-01352-GLR Document 1 Filed 05/07/...  \n",
       "2   echonll Çont Rs.2\\nCase 1:18-CV-01352-GLR Docu...  \n",
       "3   Secticn TU Cent Pgt\\nCase 1:18-CV-01352-GLR Do...  \n",
       "4   Case 1:18-CV-01352-GLR Document 1 Filed 05/07/...  \n",
       "..                                                ...  \n",
       "64  Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...  \n",
       "65  Case 1:08-cv-00270-AMD Document 2 Filed 01/31/...  \n",
       "66  Case 1:08-CV-00270-AMD Document 2 Filed 01/31/...  \n",
       "67  Case 1:08-cv-00270-AMD Document 2. Filed 01/31...  \n",
       "68                                                NaN  \n",
       "\n",
       "[69 rows x 9 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flor.dataframe(\"img_ocr\", \"page_ocr\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}