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]:

columns(description="age")

columns(description="age")

Out[3]:

Loading ITables v2.4.0 from the init_notebook_mode cell... (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]:

50*365

50*365

Out[4]:

18250

then run my search:

In [5]:

fetch_rows(table="subject", match_all=["age_at_diagnosis > 18250"])

fetch_rows(table="subject", match_all=["age_at_diagnosis > 18250"])

Out[5]:

Loading ITables v2.4.0 from the init_notebook_mode cell... (need help?)

There's quite a lot of data, I'm going to try some age brackets, and link to the researchsubject table so I can see their diagnoses:

In [6]:

fetch_rows(table="subject", match_all=["age_at_diagnosis > 18250", "age_at_diagnosis < 21900"], link_to_table = "researchsubject")

fetch_rows(table="subject", match_all=["age_at_diagnosis > 18250", "age_at_diagnosis < 21900"], link_to_table = "researchsubject")

Out[6]:

Loading ITables v2.4.0 from the init_notebook_mode cell... (need help?)