Cancer diagnoses after 50 years old¶
I'm a cancer researcher, and I'm interested in profiling cancer occurance as a function of age. I don't have a specific plan yet, but I'd like to see what data is out there for diagnosis ages for various cancers.
First, decide what column to search. I'm looking for columns that have to do with age:
In [3]:
Copied!
columns(description="age")
columns(description="age")
Out[3]:
table | column | data_type | nullable | description |
---|---|---|---|---|
Loading... (need help?) |
age_at_diagnosis is exactly what I need, and the description tells me that ages are in days, so I'm going to start by looking for data for subjects who are over 50, first I'll calculate how many days that is:
In [4]:
Copied!
50*365
50*365
Out[4]:
18250
then run my search:
In [5]:
Copied!
fetch_rows(table="subject", match_all=["age_at_diagnosis > 18250"])
fetch_rows(table="subject", match_all=["age_at_diagnosis > 18250"])
Out[5]:
subject_id | cause_of_death | days_to_birth | days_to_death | ethnicity | race | sex | species | vital_status |
---|---|---|---|---|---|---|---|---|
Loading... (need help?) |
There's quite a lot of data, I'm going to try some age brackets, and switch to calling the researchsubject table so I can see their diagnoses:
In [6]:
Copied!
60*365
60*365
Out[6]:
21900
In [7]:
Copied!
fetch_rows(table="researchsubject", match_all=["age_at_diagnosis > 18250", "age_at_diagnosis < 21900"])
fetch_rows(table="researchsubject", match_all=["age_at_diagnosis > 18250", "age_at_diagnosis < 21900"])
Out[7]:
researchsubject_id | member_of_research_project | primary_diagnosis_condition | primary_diagnosis_site |
---|---|---|---|
Loading... (need help?) |