{ "cells": [ { "cell_type": "markdown", "id": "651a4cba", "metadata": {}, "source": [ "# Subqueries\n", "\n", "## Using value from a subquery\n", "\n", "```SQL\n", "SELECT p.*, m.max_stay\n", "FROM PatientCorePopulatedTable p\n", "INNER JOIN \n", "(SELECT PatientID, ROUND(MAX(julianday(AdmissionEndDate)-julianday(AdmissionStartDate))) MAX_STAY\n", "FROM AdmissionsCorePopulatedTable \n", "GROUP BY PatientID\n", "HAVING MAX_STAY >= 15\n", ") m\n", "ON p.PatientID = m.PatientID\n", "```" ] }, { "cell_type": "code", "execution_count": 1, "id": "cc1aedd8", "metadata": { "tags": [ "hide-input", "output_scroll" ] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
 PatientIDPatientGenderPatientDateOfBirthPatientRacePatientMaritalStatusPatientLanguagePatientPopulationPercentageBelowPovertyMAX_STAY
0FB2ABB23-C9D0-4D09-8464-49BF0B982F0FMale1947-12-28 02:45:40.547UnknownMarriedIcelandic18.08000017.000000
164182B95-EB72-4E2B-BE77-8050B71498CEMale1952-01-18 19:51:12.917African AmericanSeparatedEnglish13.03000015.000000
2DB22A4D9-7E4D-485C-916A-9CD1386507FBFemale1970-07-25 13:04:20.717AsianMarriedEnglish6.67000017.000000
36E70D84D-C75F-477C-BC37-9177C3698C66Male1979-01-04 05:45:29.580WhiteMarriedEnglish16.09000019.000000
47FD13988-E58A-4A5C-8680-89AC200950FAMale1965-07-12 15:41:20.523WhiteMarriedSpanish12.41000019.000000
5C60FE675-CA52-4C55-A233-F4B27E94987FMale1957-10-30 23:26:15.303AsianMarriedSpanish12.80000016.000000
6B39DC5AC-E003-4E6A-91B6-FC07625A1285Female1935-11-03 21:07:09.040WhiteMarriedEnglish15.31000018.000000
7FA157FA5-F488-4884-BF87-E144630D595CFemale1932-11-01 06:19:56.577WhiteSingleEnglish16.32000019.000000
81A40AF35-C6D4-4D46-B475-A15D84E8A9D5Male1949-01-10 15:37:35.543WhiteMarriedEnglish11.25000020.000000
9DA6CECFF-DE13-4C4C-919F-64E1A2B76C9DMale1924-06-27 19:37:58.823AsianDivorcedEnglish83.75000017.000000
100A9BA3E4-CF3C-49C4-9774-5EEA2EE7D123Male1980-04-04 07:59:15.820WhiteSingleSpanish14.28000017.000000
117C788499-7798-484B-A027-9FCDC4C0DADBMale1926-08-13 10:22:16.247WhiteMarriedEnglish11.89000019.000000
12D8B53AA2-7953-4477-9EA4-68400EBAAC5CMale1951-06-11 20:11:10.003African AmericanUnknownEnglish16.89000019.000000
1325B786AF-0F99-478C-9CFA-0EA607E45834Male1926-08-20 00:21:38.870WhiteMarriedEnglish93.60000019.000000
14F00C64F8-2033-4640-80FE-F1F62CBE26A5Female1957-06-04 18:31:01.177African AmericanSingleEnglish15.72000018.000000
15B70E5A76-F2BC-41E4-B037-CD4D9ABA0967Male1962-12-15 01:59:01.737WhiteSingleIcelandic13.10000019.000000
16F0B53A2C-98CA-415D-B928-E3FD0E52B22AMale1950-06-20 10:31:18.337African AmericanMarriedEnglish14.87000017.000000
1781C5B13B-F6B2-4E57-9593-6E7E4C13B2CEFemale1930-05-28 02:59:42.857WhiteMarriedIcelandic19.22000019.000000
180BC491C5-5A45-4067-BD11-A78BEA00D3BEFemale1921-04-18 01:56:01.807UnknownMarriedEnglish18.05000019.000000
19FFCDECD6-4048-4DCB-B910-1218160005B3Male1941-05-06 14:56:42.687WhiteSingleEnglish14.49000018.000000
20CD2ADB1B-97F7-4EF6-BC5C-3E0EC562A06FFemale1963-04-16 08:54:08.647WhiteSingleIcelandic11.16000019.000000
2169CC25ED-A54A-4BAF-97E3-774BB3C9DED1Female1974-10-13 14:51:28.997UnknownMarriedEnglish17.72000017.000000
2269B5D2A0-12FD-46EF-A5FF-B29C4BAFBE49Male1954-05-02 16:38:15.957WhiteMarriedEnglish18.65000016.000000
238D389A8C-A6D8-4447-9DDE-1A28AB4EC667Female1964-07-10 08:50:13.707AsianMarriedEnglish4.34000019.000000
24967987B9-FFEF-4776-85CF-AE05CA81F583Male1947-02-13 10:26:55.520WhiteWidowedEnglish88.66000020.000000
259BBF3A51-443D-438B-9289-B98B8E0577C0Male1944-11-25 06:12:56.860WhiteMarriedEnglish16.76000016.000000
266D8008ED-D623-4BE4-B93B-335F9797C170Female1978-03-14 13:41:28.337WhiteMarriedIcelandic14.81000018.000000
27B3892204-880B-40EF-B3BB-B824B50E99E5Male1978-08-06 08:38:27.330WhiteSingleSpanish16.86000020.000000
2849DADA25-F2C2-42BB-8210-D78E6C7B0D48Male1962-04-08 10:18:26.263African AmericanMarriedEnglish19.50000019.000000
297548B6CF-79D9-461D-A0C5-20B861406FACMale1956-11-13 14:08:00.253WhiteMarriedIcelandic14.03000015.000000
3080D356B4-F974-441F-A5F2-F95986D119A2Female1938-03-06 18:24:18.297WhiteSingleEnglish18.88000020.000000
31A0A976C8-9B30-4492-B8C4-5B25095B9192Male1931-05-26 14:54:15.847AsianSingleEnglish19.52000017.000000
323B11D6B3-A36A-4B69-A437-C29BF425A941Female1954-05-18 10:19:19.110AsianSeparatedEnglish10.80000018.000000
33E483DE6E-D4E6-47FD-905B-22EE86EC7ACEMale1945-11-18 04:14:31.573African AmericanSingleEnglish16.88000020.000000
3453B9FFDD-F80B-43BE-93CF-C34A023EE7E9Male1921-08-22 19:17:09.227WhiteDivorcedIcelandic18.17000018.000000
35C5D09468-574F-4802-B56F-DB38F4EB1687Male1939-07-07 19:39:49.753African AmericanMarriedIcelandic10.87000016.000000
36EA7C2F0F-DA1C-4CE8-9700-4BB1FC7AF3FBMale1969-01-05 00:15:09.627UnknownMarriedEnglish3.30000020.000000
3735FE7491-1A1D-48CB-810C-8DC2599AB3DDMale1969-11-02 06:34:34.527WhiteMarriedEnglish4.51000019.000000
3856A35E74-90BE-44A0-B7BA-7743BB152133Female1968-11-09 15:29:19.557WhiteMarriedEnglish8.81000017.000000
39CC12B481-B516-455B-884F-4CA900B29F2EFemale1985-10-21 07:59:04.777UnknownDivorcedEnglish14.58000018.000000
403231F930-2978-4F50-8234-755449851E7BMale1979-05-26 04:58:10.627WhiteSingleEnglish18.36000020.000000
411311FEE4-2FDC-46E4-83D3-1550A3E51D2CFemale1988-03-28 03:09:22.807WhiteSingleEnglish14.99000015.000000
42EEAFC0B3-B835-4D99-AB33-2F9428E54E5FFemale1961-01-08 15:19:15.490AsianUnknownEnglish18.95000017.000000
4336775002-9EC3-4889-AD4F-80DC6855C8D8Female1963-07-16 22:16:48.477AsianSingleSpanish15.56000018.000000
444C201C71-CCED-40D1-9642-F9C8C485B854Male1926-09-22 09:17:14.713African AmericanMarriedEnglish10.30000019.000000
452A8772FE-61DB-483E-B6BF-6C0A74BA9C2AFemale1966-10-14 15:31:48.427AsianSingleEnglish11.15000018.000000
46C65A4ADE-112E-49E4-B72A-0DED22C242EDMale1955-04-07 18:55:17.077WhiteMarriedEnglish19.66000015.000000
4780AC01B2-BD55-4BE0-A59A-4024104CF4E9Female1965-05-14 15:25:09.740African AmericanMarriedEnglish19.74000020.000000
486A57AC0C-57F3-4C19-98A1-51135EFBC4FFFemale1958-07-07 16:00:19.383UnknownMarriedEnglish94.06000017.000000
497A025E77-7832-4F53-B9A7-09A3F98AC17EFemale1951-07-12 08:23:45.520AsianSingleEnglish16.69000020.000000
50886B5885-1EE2-49F3-98D5-A2F02EB8A9D4Female1970-04-27 09:15:11.080UnknownMarriedEnglish10.35000017.000000
510681FA35-A794-4684-97BD-00B88370DB41Female1978-10-02 21:46:05.300AsianUnknownSpanish19.16000018.000000
52E250799D-F6DE-4914-ADB4-B08A6E5029B9Female1945-08-04 19:03:00.757WhiteSingleUnknown12.86000019.000000
53A19A0B00-4C9A-4206-B1FE-17E6DA3CEB0BFemale1967-07-01 01:44:24.907UnknownMarriedEnglish17.84000015.000000
54E5478913-6819-4977-BB11-4C8B61175B56Female1980-03-21 13:08:56.867WhiteSingleEnglish12.92000020.000000
5566154E24-D3EE-4311-89DB-6195278F9B3CFemale1944-08-26 13:03:24.297WhiteDivorcedEnglish19.49000018.000000
56BC44CE19-9FC5-4AC9-A296-9EBC5E3D03AEFemale1953-06-04 03:16:17.843African AmericanMarriedEnglish15.04000016.000000
57CC9CDA72-B37A-4F8F-AFE4-B08F56A183BEFemale1942-04-14 14:01:01.130AsianMarriedSpanish14.15000016.000000
58EA9B67E2-15F0-450B-A8A6-14F6E4AE3D12Female1930-04-08 20:59:31.057AsianSeparatedIcelandic98.40000016.000000
593E462A8F-7B90-43A1-A8B6-AD82CB5002C9Female1986-12-20 16:41:34.793WhiteMarriedSpanish18.33000015.000000
609E18822E-7D13-45C7-B50E-F95CFF92BC3EMale1954-10-16 06:45:56.257UnknownSingleEnglish15.24000018.000000
61A7142B71-A144-4D56-BD14-3E966B01DB37Male1960-03-28 13:40:52.270WhiteDivorcedSpanish19.52000017.000000
6298F593D2-8894-49BB-93B9-5A0E2CF85E2EFemale1944-07-15 19:04:11.487African AmericanMarriedEnglish9.10000016.000000
631A220558-5996-43E1-AE5D-7B96180FED35Male1937-09-07 22:23:53.143AsianMarriedEnglish15.11000020.000000
647A7332AD-88B1-4848-9356-E5260E477C59Female1944-12-01 06:30:01.543UnknownMarriedEnglish19.46000019.000000
6536E2F89E-777A-4D77-9D95-0D70A8AB416FMale1980-05-30 13:23:50.703African AmericanSeparatedEnglish19.36000019.000000
6603A481F5-B32A-4A91-BD42-43EB78FEBA77Female1968-02-07 23:02:38.017AsianSingleUnknown93.23000015.000000
672A5251B1-0945-47FA-A65C-7A6381562591Female1942-01-07 16:45:33.060UnknownMarriedSpanish18.05000016.000000
688AF47463-8534-4203-B210-C2290F6CE689Female1952-06-27 17:29:04.187WhiteDivorcedEnglish11.88000016.000000
696623F5D6-D581-4268-9F9B-21612FBBF7B5Female1943-02-17 15:36:13.787AsianSingleSpanish14.49000018.000000
7065A7FBE0-EA9F-49E9-9824-D8F3AD98DAC0Female1962-11-30 06:28:33.110WhiteSeparatedSpanish17.98000019.000000
71FB909FAE-72DD-4F6F-9828-D92183DF185FMale1940-07-15 12:18:41.080WhiteSingleSpanish14.90000015.000000
\n" ], "text/plain": [ "" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import sqlite3\n", "import pandas as pd\n", "\n", "conn = sqlite3.connect('100_patients.db')\n", "\n", "sql_statement = \"\"\"\n", "SELECT p.*, m.max_stay\n", "FROM PatientCorePopulatedTable p\n", "INNER JOIN \n", "(SELECT PatientID, ROUND(MAX(julianday(AdmissionEndDate)-julianday(AdmissionStartDate))) MAX_STAY\n", "FROM AdmissionsCorePopulatedTable \n", "GROUP BY PatientID\n", "HAVING MAX_STAY >= 15\n", ") m\n", "ON p.PatientID = m.PatientID\n", "\"\"\"\n", "df = pd.read_sql_query(sql_statement, conn)\n", "df.style.set_table_attributes('style=\"font-size: 12px\"')" ] }, { "cell_type": "markdown", "id": "0927b7e1", "metadata": {}, "source": [ "## `IN` and `NOT IN` examples\n", "\n", "```SQL\n", "SELECT *\n", "FROM LabsCorePopulatedTable \n", "WHERE PatientID IN (\n", " SELECT PatientID \n", " FROM PatientCorePopulatedTable \n", " WHERE PatientLanguage IN ('Icelandic', 'Spanish')\n", ")\n", "LIMIT 100;\n", "```" ] }, { "cell_type": "code", "execution_count": 2, "id": "125d7c3b", "metadata": { "tags": [ "hide-input", "output_scroll" ] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
 PatientIDAdmissionIDLabNameLabValueLabUnitsLabDateTime
081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: HEMOGLOBIN10.900000gm/dl1953-11-28 14:09:29.363
181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: AST/SGOT29.300000U/L1953-11-28 21:02:51.897
281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: GLUCOSE132.900000mg/dL1953-11-28 00:21:31.683
381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1URINALYSIS: RED BLOOD CELLS2.300000rbc/hpf1953-11-28 11:19:18.283
481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: ALK PHOS74.600000U/L1953-11-28 00:20:01.843
581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: MCHC33.500000g/dl1953-11-28 01:27:39.687
681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: CARBON DIOXIDE21.700000mmol/L1953-11-28 08:17:31.660
781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: EOSINOPHILS0.500000k/cumm1953-11-28 10:35:41.860
881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: CALCIUM9.700000mg/dL1953-11-28 08:30:06.620
981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: NEUTROPHILS9.000000k/cumm1953-11-28 09:45:44.733
1081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1URINALYSIS: PH6.700000no unit1953-11-28 17:40:09.690
1181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: ABSOLUTE NEUTROPHILS62.800000%1953-11-28 03:35:04.810
1281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: BILI TOTAL0.400000mg/dL1953-11-28 15:22:31.230
1381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: CREATININE0.600000mg/dL1953-12-01 22:15:51.590
1481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1URINALYSIS: PH6.300000no unit1953-12-01 06:33:26.870
1581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: GLUCOSE137.400000mg/dL1953-12-01 13:30:53.080
1681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: RED BLOOD CELL COUNT6.900000m/cumm1953-12-01 13:50:57.487
1781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: WHITE BLOOD CELL COUNT10.500000k/cumm1953-12-01 06:16:18.957
1881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: MCH30.000000pg1953-12-02 08:57:13.550
1981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: BASOPHILS0.000000k/cumm1953-12-02 12:52:42.280
2081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: CHLORIDE93.900000mmol/L1953-12-02 04:51:06.733
2181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: ABSOLUTE LYMPHOCYTES21.300000%1953-12-02 00:23:14.160
2281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: RED BLOOD CELL COUNT5.500000m/cumm1953-12-02 11:58:56.217
2381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: WHITE BLOOD CELL COUNT10.800000k/cumm1953-12-02 05:00:20.303
2481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: AST/SGOT18.900000U/L1953-12-02 02:09:54.483
2581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: BILI TOTAL1.100000mg/dL1953-12-02 04:09:22.613
2681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: BUN11.900000mg/dL1953-12-02 02:13:19.553
2781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: MCHC34.300000g/dl1953-12-02 08:01:19.600
2881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1URINALYSIS: WHITE BLOOD CELLS3.100000wbc/hpf1953-12-02 13:30:22.977
2981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: TOTAL PROTEIN5.100000gm/dL1953-12-02 01:47:15.153
3081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: SODIUM154.500000mmol/L1953-12-01 23:27:54.847
3181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: MEAN CORPUSCULAR VOLUME70.400000fl1953-12-02 07:18:53.313
3281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: ALBUMIN3.600000gm/dL1953-12-02 13:36:37.693
3381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: EOSINOPHILS0.400000k/cumm1953-12-02 14:01:04.720
3481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: CREATININE0.700000mg/dL1953-12-02 06:51:26.493
3581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: HEMOGLOBIN18.600000gm/dl1953-12-02 05:12:51.010
3681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: ALT/SGPT28.400000U/L1953-12-02 09:02:25.493
3781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: HEMATOCRIT53.400000%1953-12-02 00:56:25.770
3881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: ABSOLUTE NEUTROPHILS69.400000%1953-12-02 07:25:49.810
3981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: ALK PHOS103.900000U/L1953-12-02 07:28:37.630
4081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: CARBON DIOXIDE24.900000mmol/L1953-12-02 13:15:03.360
4181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1URINALYSIS: SPECIFIC GRAVITY1.000000no unit1953-12-02 14:11:51.947
4281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: POTASSIUM3.800000mmol/L1953-12-02 00:13:49.983
4381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1URINALYSIS: RED BLOOD CELLS0.800000rbc/hpf1953-12-02 03:47:57.670
4481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1METABOLIC: GLUCOSE79.000000mg/dL1953-12-01 23:24:50.990
4581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE1CBC: RDW14.600000%1953-12-02 06:39:25.980
4681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: NEUTROPHILS4.400000k/cumm1979-09-15 13:22:34.587
4781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: EOSINOPHILS0.200000k/cumm1979-09-16 02:04:55.270
4881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: CHLORIDE98.100000mmol/L1979-09-15 20:01:51.337
4981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MEAN CORPUSCULAR VOLUME97.000000fl1979-09-15 23:18:05.967
5081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: LYMPHOCYTES0.600000k/cumm1979-09-15 14:08:31.630
5181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: POTASSIUM4.800000mmol/L1979-09-15 11:02:57.917
5281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: ALT/SGPT70.900000U/L1979-09-15 16:44:20.533
5381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: CALCIUM10.400000mg/dL1979-09-15 11:50:22.660
5481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: SODIUM145.100000mmol/L1979-09-16 03:35:13.270
5581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: ABSOLUTE NEUTROPHILS69.200000%1979-09-16 05:43:33.740
5681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MCH32.600000pg1979-09-15 23:21:28.610
5781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2URINALYSIS: SPECIFIC GRAVITY1.000000no unit1979-09-16 09:45:20.950
5881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MONOCYTES0.700000k/cumm1979-09-16 05:27:57.903
5981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2URINALYSIS: RED BLOOD CELLS0.900000rbc/hpf1979-09-15 18:16:03.557
6081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2URINALYSIS: WHITE BLOOD CELLS0.900000wbc/hpf1979-09-16 09:32:38.197
6181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: ALBUMIN2.700000gm/dL1979-09-15 18:23:59.207
6281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: ALK PHOS70.500000U/L1979-09-15 20:15:19.773
6381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2URINALYSIS: PH6.100000no unit1979-09-15 21:34:58.310
6481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: HEMOGLOBIN11.600000gm/dl1979-09-15 22:05:34.613
6581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: WHITE BLOOD CELL COUNT9.300000k/cumm1979-09-16 09:19:19.133
6681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: RDW15.200000%1979-09-16 09:58:40.650
6781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: CREATININE1.000000mg/dL1979-09-15 20:01:09.230
6881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MCHC28.100000g/dl1979-09-16 01:21:46.287
6981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: PLATELET COUNT167.400000k/cumm1979-09-16 08:04:34.420
7081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: TOTAL PROTEIN6.700000gm/dL1979-09-15 11:19:20.393
7181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: BASOPHILS0.100000k/cumm1979-09-15 12:47:07.220
7281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: ANION GAP8.200000mmol/L1979-09-16 05:42:07.383
7381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: BUN24.500000mg/dL1979-09-16 04:58:33.460
7481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: EOSINOPHILS0.200000k/cumm1979-09-17 05:30:39.517
7581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: SODIUM131.400000mmol/L1979-09-17 00:13:16.120
7681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MCH32.900000pg1979-09-16 17:24:55.867
7781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2URINALYSIS: PH6.800000no unit1979-09-17 07:05:11.520
7881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: ALBUMIN4.700000gm/dL1979-09-16 14:12:57.197
7981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MCHC29.800000g/dl1979-09-16 13:43:53.140
8081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: WHITE BLOOD CELL COUNT4.100000k/cumm1979-09-16 12:01:20.027
8181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: HEMOGLOBIN17.700000gm/dl1979-09-17 04:37:36.363
8281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MONOCYTES0.300000k/cumm1979-09-17 07:20:34.527
8381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: NEUTROPHILS1.600000k/cumm1979-09-16 16:55:47.507
8481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: RDW10.600000%1979-09-17 06:39:16.747
8581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: CARBON DIOXIDE32.800000mmol/L1979-09-16 23:43:59.297
8681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: CREATININE0.700000mg/dL1979-09-16 18:50:49.857
8781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2URINALYSIS: WHITE BLOOD CELLS1.000000wbc/hpf1979-09-16 15:54:13.407
8881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: MEAN CORPUSCULAR VOLUME79.000000fl1979-09-17 06:51:33.423
8981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: ALT/SGPT74.900000U/L1979-09-16 12:49:35.207
9081C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: BASOPHILS0.200000k/cumm1979-09-17 04:54:46.347
9181C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: ABSOLUTE NEUTROPHILS77.100000%1979-09-17 02:34:22.067
9281C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: RED BLOOD CELL COUNT6.300000m/cumm1979-09-16 10:15:38.247
9381C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: HEMATOCRIT37.400000%1979-09-16 10:44:27.440
9481C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: POTASSIUM3.600000mmol/L1979-09-16 11:09:37.170
9581C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2URINALYSIS: SPECIFIC GRAVITY1.000000no unit1979-09-19 16:15:16.273
9681C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: GLUCOSE126.200000mg/dL1979-09-20 09:38:32.793
9781C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: AST/SGOT27.800000U/L1979-09-20 11:35:34.000
9881C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2CBC: RED BLOOD CELL COUNT5.700000m/cumm1979-09-20 12:24:18.503
9981C5B13B-F6B2-4E57-9593-6E7E4C13B2CE2METABOLIC: CREATININE1.200000mg/dL1979-09-21 02:31:31.370
\n" ], "text/plain": [ "" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import sqlite3\n", "import pandas as pd\n", "\n", "conn = sqlite3.connect('100_patients.db')\n", "\n", "sql_statement = \"\"\"\n", "SELECT *\n", "FROM LabsCorePopulatedTable \n", "WHERE PatientID IN (\n", " SELECT PatientID \n", " FROM PatientCorePopulatedTable \n", " WHERE PatientLanguage IN ('Icelandic', 'Spanish')\n", ")\n", "LIMIT 100;\n", "\"\"\"\n", "df = pd.read_sql_query(sql_statement, conn)\n", "df.style.set_table_attributes('style=\"font-size: 12px\"')" ] }, { "cell_type": "markdown", "id": "6383fdf4", "metadata": {}, "source": [ "```SQL\n", "SELECT *\n", "FROM LabsCorePopulatedTable \n", "WHERE PatientID IN (\n", " SELECT PatientID \n", " FROM PatientCorePopulatedTable \n", " WHERE PatientLanguage NOT IN ('Icelandic', 'Spanish')\n", ")\n", "LIMIT 100;\n", "```" ] }, { "cell_type": "code", "execution_count": 3, "id": "ba4605e8", "metadata": { "tags": [ "hide-input", "output_scroll" ] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
 PatientIDAdmissionIDLabNameLabValueLabUnitsLabDateTime
01A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: RED BLOOD CELLS1.800000rbc/hpf1992-07-01 01:36:17.910
11A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: GLUCOSE103.300000mg/dL1992-06-30 09:35:52.383
21A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: MCH35.800000pg1992-06-30 03:50:11.777
31A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: CALCIUM8.900000mg/dL1992-06-30 12:09:46.107
41A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: RED BLOOD CELL COUNT4.800000m/cumm1992-07-01 01:31:08.677
51A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: PH4.900000no unit1992-07-01 01:25:54.887
61A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: TOTAL PROTEIN7.500000gm/dL1992-06-30 17:58:08.513
71A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: CHLORIDE111.500000mmol/L1992-06-30 14:03:11.313
81A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: LYMPHOCYTES2.200000k/cumm1992-07-01 02:42:24.957
91A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: ABSOLUTE LYMPHOCYTES33.300000%1992-06-30 09:39:02.830
101A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: SODIUM130.400000mmol/L1992-06-30 14:25:18.260
111A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: SPECIFIC GRAVITY1.000000no unit1992-07-01 02:40:06.887
121A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: BILI TOTAL0.600000mg/dL1992-07-01 01:21:44.597
131A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: WHITE BLOOD CELLS2.000000wbc/hpf1992-06-30 14:34:52.290
141A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: EOSINOPHILS0.600000k/cumm1992-06-30 20:14:36.117
151A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: ALK PHOS63.500000U/L1992-06-30 09:08:51.047
161A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: RDW15.800000%1992-06-30 11:04:44.837
171A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: AST/SGOT35.600000U/L1992-06-30 23:38:15.140
181A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: CREATININE1.000000mg/dL1992-06-30 14:50:30.213
191A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: NEUTROPHILS1.000000k/cumm1992-07-01 17:43:57.380
201A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: BASOPHILS0.100000k/cumm1992-07-01 22:50:15.633
211A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: RDW10.100000%1992-07-01 21:54:46.720
221A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: CALCIUM8.400000mg/dL1992-07-01 21:49:40.153
231A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: BILI TOTAL0.100000mg/dL1992-07-01 21:47:17.043
241A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: RED BLOOD CELL COUNT3.700000m/cumm1992-07-01 19:45:23.057
251A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: MONOCYTES0.800000k/cumm1992-07-01 03:28:46.073
261A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: EOSINOPHILS0.500000k/cumm1992-07-01 03:20:24.070
271A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: MCH24.200000pg1992-07-01 18:02:55.160
281A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: LYMPHOCYTES1.600000k/cumm1992-07-01 09:43:24.983
291A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: BUN20.200000mg/dL1992-07-01 17:56:23.110
301A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: WHITE BLOOD CELL COUNT3.200000k/cumm1992-07-01 23:01:03.837
311A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: PLATELET COUNT163.700000k/cumm1992-07-01 09:16:43.977
321A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: POTASSIUM5.500000mmol/L1992-07-01 07:20:54.017
331A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: ANION GAP11.200000mmol/L1992-07-01 04:25:57.077
341A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: HEMATOCRIT52.400000%1992-07-01 05:35:45.510
351A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: CREATININE0.900000mg/dL1992-07-01 12:04:14.040
361A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: TOTAL PROTEIN6.600000gm/dL1992-07-01 09:10:37.717
371A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: HEMOGLOBIN14.200000gm/dl1992-07-01 14:23:02.633
381A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: CHLORIDE105.300000mmol/L1992-07-01 20:58:22.167
391A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: WHITE BLOOD CELLS2.500000wbc/hpf1992-07-01 22:13:00.610
401A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: ALK PHOS77.700000U/L1992-07-01 18:49:40.103
411A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: ABSOLUTE LYMPHOCYTES26.000000%1992-07-01 03:38:07.080
421A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: CARBON DIOXIDE26.300000mmol/L1992-07-01 05:53:08.337
431A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: AST/SGOT14.800000U/L1992-07-01 22:43:55.487
441A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: SODIUM144.700000mmol/L1992-07-01 05:47:30.580
451A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: ABSOLUTE NEUTROPHILS73.400000%1992-07-01 13:57:21.853
461A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: ALBUMIN3.100000gm/dL1992-07-01 08:10:42.320
471A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: RED BLOOD CELLS2.500000rbc/hpf1992-07-01 10:38:47.503
481A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: SPECIFIC GRAVITY1.000000no unit1992-07-01 19:28:25.110
491A8791E3-A61C-455A-8DEE-763EB90C9B2C1METABOLIC: GLUCOSE69.500000mg/dL1992-07-01 04:13:39.683
501A8791E3-A61C-455A-8DEE-763EB90C9B2C1URINALYSIS: PH5.700000no unit1992-07-01 03:26:14.710
511A8791E3-A61C-455A-8DEE-763EB90C9B2C1CBC: MCHC28.500000g/dl1992-07-01 03:54:13.587
521A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: HEMATOCRIT50.900000%2005-07-26 09:51:14.723
531A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: POTASSIUM4.400000mmol/L2005-07-26 14:03:53.497
541A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: NEUTROPHILS3.100000k/cumm2005-07-26 12:27:06.393
551A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: PLATELET COUNT200.600000k/cumm2005-07-27 02:34:55.977
561A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: BASOPHILS0.000000k/cumm2005-07-26 14:58:28.687
571A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: BILI TOTAL0.200000mg/dL2005-07-26 20:39:49.140
581A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: ALBUMIN5.800000gm/dL2005-07-26 09:51:51.223
591A8791E3-A61C-455A-8DEE-763EB90C9B2C2URINALYSIS: PH5.900000no unit2005-07-26 23:37:48.423
601A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: GLUCOSE73.800000mg/dL2005-07-26 20:05:54.243
611A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: TOTAL PROTEIN9.200000gm/dL2005-07-27 06:44:49.873
621A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: HEMOGLOBIN16.100000gm/dl2005-07-27 02:35:16.290
631A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: RED BLOOD CELL COUNT5.000000m/cumm2005-07-27 04:47:14.633
641A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: CREATININE1.200000mg/dL2005-07-26 19:23:18.550
651A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: MEAN CORPUSCULAR VOLUME86.600000fl2005-07-27 01:16:21.500
661A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: ALT/SGPT29.100000U/L2005-07-27 00:59:44.193
671A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: CHLORIDE103.000000mmol/L2005-07-27 01:21:10.610
681A8791E3-A61C-455A-8DEE-763EB90C9B2C2URINALYSIS: RED BLOOD CELLS2.000000rbc/hpf2005-07-26 18:14:43.880
691A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: CARBON DIOXIDE26.800000mmol/L2005-07-27 12:47:59.227
701A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: SODIUM132.000000mmol/L2005-07-27 12:14:30.773
711A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: CHLORIDE107.600000mmol/L2005-07-27 13:43:55.487
721A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: HEMOGLOBIN17.400000gm/dl2005-07-27 15:51:38.070
731A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: BUN9.400000mg/dL2005-07-27 11:23:02.263
741A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: ABSOLUTE LYMPHOCYTES18.200000%2005-07-27 12:03:25.640
751A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: NEUTROPHILS3.500000k/cumm2005-07-28 01:46:12.800
761A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: ALT/SGPT18.400000U/L2005-07-28 00:04:32.980
771A8791E3-A61C-455A-8DEE-763EB90C9B2C2URINALYSIS: PH4.700000no unit2005-07-27 16:13:23.007
781A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: BASOPHILS0.100000k/cumm2005-07-27 13:30:05.717
791A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: BILI TOTAL0.200000mg/dL2005-07-27 16:14:15.507
801A8791E3-A61C-455A-8DEE-763EB90C9B2C2URINALYSIS: SPECIFIC GRAVITY1.000000no unit2005-07-28 06:54:36.203
811A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: LYMPHOCYTES3.100000k/cumm2005-07-31 03:23:38.850
821A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: EOSINOPHILS0.600000k/cumm2005-07-30 19:34:59.980
831A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: ABSOLUTE LYMPHOCYTES20.400000%2005-07-30 23:13:19.497
841A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: SODIUM146.100000mmol/L2005-07-30 07:58:59.830
851A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: ALK PHOS137.000000U/L2005-07-31 05:09:35.897
861A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: RED BLOOD CELL COUNT3.400000m/cumm2005-08-01 00:41:01.693
871A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: CALCIUM9.700000mg/dL2005-08-01 07:15:57.150
881A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: ALT/SGPT49.800000U/L2005-08-01 06:40:05.217
891A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: MONOCYTES0.800000k/cumm2005-07-31 19:48:08.663
901A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: EOSINOPHILS0.100000k/cumm2005-07-31 11:45:34.767
911A8791E3-A61C-455A-8DEE-763EB90C9B2C2URINALYSIS: SPECIFIC GRAVITY1.000000no unit2005-07-31 23:11:25.867
921A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: WHITE BLOOD CELL COUNT4.800000k/cumm2005-07-31 20:34:27.947
931A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: PLATELET COUNT273.500000k/cumm2005-08-01 01:08:12.140
941A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: CREATININE0.900000mg/dL2005-07-31 14:44:19.543
951A8791E3-A61C-455A-8DEE-763EB90C9B2C2URINALYSIS: RED BLOOD CELLS2.700000rbc/hpf2005-07-31 20:50:27.503
961A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: HEMOGLOBIN12.300000gm/dl2005-07-31 09:49:42.283
971A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: ALK PHOS41.500000U/L2005-07-31 23:13:13.987
981A8791E3-A61C-455A-8DEE-763EB90C9B2C2CBC: BASOPHILS0.200000k/cumm2005-07-31 16:00:29.537
991A8791E3-A61C-455A-8DEE-763EB90C9B2C2METABOLIC: POTASSIUM5.600000mmol/L2005-07-31 11:16:11.607
\n" ], "text/plain": [ "" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import sqlite3\n", "import pandas as pd\n", "\n", "conn = sqlite3.connect('100_patients.db')\n", "\n", "sql_statement = \"\"\"\n", "SELECT *\n", "FROM LabsCorePopulatedTable \n", "WHERE PatientID IN (\n", " SELECT PatientID \n", " FROM PatientCorePopulatedTable \n", " WHERE PatientLanguage NOT IN ('Icelandic', 'Spanish')\n", ")\n", "LIMIT 100;\n", "\"\"\"\n", "df = pd.read_sql_query(sql_statement, conn)\n", "df.style.set_table_attributes('style=\"font-size: 12px\"')" ] } ], "metadata": { "jupytext": { "formats": "md:myst", "text_representation": { "extension": ".md", "format_name": "myst" } }, "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.9.7" }, "source_map": [ 11, 29, 49, 65, 84, 98 ] }, "nbformat": 4, "nbformat_minor": 5 }