pjleimbigler

patient_id|gender|age|visit_date|treatment_start_date|days_on_placebex|adherence|height_cm|baseline_weight_kg|final_weight_kg|baseline_systolic_bp|final_systolic_bp
1001|M|58|2020-08-16|2020-08-10|6|3 - Good|166.3|96.1|96|126.6|126.7
1002|F|26|2024-02-17|2023-07-23|209|3 - Good|153.9|48.1|41.1|113|106.6
1003|F|23|2023-04-24|2020-12-11|864|1 - Poor|157.5|64.5||114.9|114.9
1004|F|32|2022-10-31|2022-09-07|54|3 - Good|156.2|56.2|54.4|114.8|113.2
1005|M|62|2023-01-21|2020-09-14|859|2 - Partial|175.1|119.6|108.2|135.5|141.7
1006|F|69|2024-11-15|2024-11-02|13|2 - Partial|140.7|82.1|82|141.9|141.6
1007|F|45|2021-11-27|2021-02-16|284|2 - Partial|143.9|68.6|63.5|128.7|123.7
1008|M|39|2020-07-28|2020-07-05|23|1 - Poor|170.9|98.5|98.5|135.2|135.2
1009|F|40|2023-05-21|2021-11-26|541|1 - Poor|162.3|86.9|87.1|111.5|111.5

pjleimbigler

visit_id	patient_id	gender	visit_date	age	hematocrit	nail_darkening	tbd_diagnosis
0	1	F	2022-07-11	47	38.58	5	FALSE
1	1	F	2022-10-23	47	39.89	0	FALSE
2	1	F	2023-11-12	48	35.04	1	FALSE
3	1	F	2024-01-03	48	39.25	1	FALSE
4	2	M	2021-02-18	54	52.3	2	FALSE
5	2	M	2024-07-09	57	44.55	0	FALSE
6	2	M	2024-09-05	57	46.32	3	FALSE
7	2	M	2024-10-22	57	47.83	0	FALSE
8	3	M	2021-10-06	46	47.02	3	TRUE

pjleimbigler

import requests
from bs4 import BeautifulSoup
import pandas as pd
import time

baseurl = 'http://publicreporting.ltchomes.net/en-ca/'
url = baseurl + 'Search_Selection.aspx'

response = requests.get(url)
soup = BeautifulSoup(response.text, "html.parser")