# Matching clinical data

nationwidechildrens.org_clinical_drug_ov <- read.delim("C:/Users/Samaresh/Desktop/Siddik/R results/TCGA/GDC_OV/nationwidechildrens.org_clinical_drug_ov.txt")
nationwidechildrens.org_clinical_patient_ov <- read.delim("C:/Users/Samaresh/Desktop/Siddik/R results/TCGA/GDC_OV/nationwidechildrens.org_clinical_patient_ov.txt")
nationwidechildrens.org_clinical_follow_up_v1.0_ov <- read.delim("C:/Users/Samaresh/Desktop/Siddik/R results/TCGA/GDC_OV/nationwidechildrens.org_clinical_follow_up_v1.0_ov.txt")
y_CP <- nationwidechildrens.org_clinical_patient_ov
y_DF <- nationwidechildrens.org_clinical_follow_up_v1.0_ov
y_D <- nationwidechildrens.org_clinical_drug_ov
 
M1<- merge.data.frame(y_CP, y_DF, by= "bcr_patient_barcode", no.dups = T)
colnames(M1)
##  [1] "bcr_patient_barcode"                 
##  [2] "bcr_patient_uuid.x"                  
##  [3] "form_completion_date.x"              
##  [4] "prospective_collection"              
##  [5] "retrospective_collection"            
##  [6] "gender"                              
##  [7] "birth_days_to"                       
##  [8] "race"                                
##  [9] "ethnicity"                           
## [10] "jewish_religion_heritage_indicator"  
## [11] "history_other_malignancy"            
## [12] "history_neoadjuvant_treatment"       
## [13] "initial_pathologic_dx_year"          
## [14] "method_initial_path_dx"              
## [15] "method_initial_path_dx_other"        
## [16] "vital_status.x"                      
## [17] "last_contact_days_to.x"              
## [18] "death_days_to.x"                     
## [19] "tumor_status.x"                      
## [20] "tumor_grade"                         
## [21] "residual_tumor"                      
## [22] "residual_disease_largest_nodule"     
## [23] "vascular_invasion_indicator"         
## [24] "lymphovascular_invasion_indicator"   
## [25] "karnofsky_score.x"                   
## [26] "ecog_score.x"                        
## [27] "performance_status_timing.x"         
## [28] "radiation_treatment_adjuvant.x"      
## [29] "pharmaceutical_tx_adjuvant.x"        
## [30] "treatment_outcome_first_course.x"    
## [31] "days_to_tumor_progression"           
## [32] "new_tumor_event_dx_indicator.x"      
## [33] "age_at_initial_pathologic_diagnosis" 
## [34] "anatomic_neoplasm_subdivision"       
## [35] "clinical_M"                          
## [36] "clinical_N"                          
## [37] "clinical_T"                          
## [38] "clinical_stage"                      
## [39] "days_to_initial_pathologic_diagnosis"
## [40] "days_to_patient_progression_free"    
## [41] "disease_code"                        
## [42] "extranodal_involvement"              
## [43] "histological_type"                   
## [44] "icd_10"                              
## [45] "icd_o_3_histology"                   
## [46] "icd_o_3_site"                        
## [47] "informed_consent_verified"           
## [48] "pathologic_M"                        
## [49] "pathologic_N"                        
## [50] "pathologic_T"                        
## [51] "pathologic_stage"                    
## [52] "patient_id"                          
## [53] "project_code"                        
## [54] "stage_other"                         
## [55] "system_version"                      
## [56] "tissue_source_site"                  
## [57] "tumor_tissue_site"                   
## [58] "bcr_patient_uuid.y"                  
## [59] "bcr_followup_barcode"                
## [60] "bcr_followup_uuid"                   
## [61] "form_completion_date.y"              
## [62] "followup_reason"                     
## [63] "followup_lost_to"                    
## [64] "radiation_treatment_adjuvant.y"      
## [65] "pharmaceutical_tx_adjuvant.y"        
## [66] "treatment_outcome_first_course.y"    
## [67] "vital_status.y"                      
## [68] "last_contact_days_to.y"              
## [69] "death_days_to.y"                     
## [70] "tumor_status.y"                      
## [71] "new_tumor_event_dx_indicator.y"      
## [72] "treatment_outcome_at_tcga_followup"  
## [73] "ecog_score.y"                        
## [74] "karnofsky_score.y"                   
## [75] "performance_status_timing.y"
dim(M1)
## [1] 672  75
M1 <- M1[,-grep("*.x$", colnames(M1))]
dim(M1)
## [1] 672  61
colnames(M1)
##  [1] "bcr_patient_barcode"                 
##  [2] "prospective_collection"              
##  [3] "retrospective_collection"            
##  [4] "gender"                              
##  [5] "birth_days_to"                       
##  [6] "race"                                
##  [7] "ethnicity"                           
##  [8] "jewish_religion_heritage_indicator"  
##  [9] "history_other_malignancy"            
## [10] "history_neoadjuvant_treatment"       
## [11] "initial_pathologic_dx_year"          
## [12] "method_initial_path_dx_other"        
## [13] "tumor_grade"                         
## [14] "residual_tumor"                      
## [15] "residual_disease_largest_nodule"     
## [16] "vascular_invasion_indicator"         
## [17] "lymphovascular_invasion_indicator"   
## [18] "days_to_tumor_progression"           
## [19] "age_at_initial_pathologic_diagnosis" 
## [20] "anatomic_neoplasm_subdivision"       
## [21] "clinical_M"                          
## [22] "clinical_N"                          
## [23] "clinical_T"                          
## [24] "clinical_stage"                      
## [25] "days_to_initial_pathologic_diagnosis"
## [26] "days_to_patient_progression_free"    
## [27] "disease_code"                        
## [28] "extranodal_involvement"              
## [29] "histological_type"                   
## [30] "icd_10"                              
## [31] "icd_o_3_histology"                   
## [32] "icd_o_3_site"                        
## [33] "informed_consent_verified"           
## [34] "pathologic_M"                        
## [35] "pathologic_N"                        
## [36] "pathologic_T"                        
## [37] "pathologic_stage"                    
## [38] "patient_id"                          
## [39] "project_code"                        
## [40] "stage_other"                         
## [41] "system_version"                      
## [42] "tissue_source_site"                  
## [43] "tumor_tissue_site"                   
## [44] "bcr_patient_uuid.y"                  
## [45] "bcr_followup_barcode"                
## [46] "bcr_followup_uuid"                   
## [47] "form_completion_date.y"              
## [48] "followup_reason"                     
## [49] "followup_lost_to"                    
## [50] "radiation_treatment_adjuvant.y"      
## [51] "pharmaceutical_tx_adjuvant.y"        
## [52] "treatment_outcome_first_course.y"    
## [53] "vital_status.y"                      
## [54] "last_contact_days_to.y"              
## [55] "death_days_to.y"                     
## [56] "tumor_status.y"                      
## [57] "new_tumor_event_dx_indicator.y"      
## [58] "treatment_outcome_at_tcga_followup"  
## [59] "ecog_score.y"                        
## [60] "karnofsky_score.y"                   
## [61] "performance_status_timing.y"
(colnames(M1)<- gsub("*.y$", "",colnames(M1)))
##  [1] "bcr_patient_barcode"                 
##  [2] "prospective_collection"              
##  [3] "retrospective_collection"            
##  [4] "gender"                              
##  [5] "birth_days_to"                       
##  [6] "race"                                
##  [7] "ethnici"                             
##  [8] "jewish_religion_heritage_indicator"  
##  [9] "history_other_malignan"              
## [10] "history_neoadjuvant_treatment"       
## [11] "initial_pathologic_dx_year"          
## [12] "method_initial_path_dx_other"        
## [13] "tumor_grade"                         
## [14] "residual_tumor"                      
## [15] "residual_disease_largest_nodule"     
## [16] "vascular_invasion_indicator"         
## [17] "lymphovascular_invasion_indicator"   
## [18] "days_to_tumor_progression"           
## [19] "age_at_initial_pathologic_diagnosis" 
## [20] "anatomic_neoplasm_subdivision"       
## [21] "clinical_M"                          
## [22] "clinical_N"                          
## [23] "clinical_T"                          
## [24] "clinical_stage"                      
## [25] "days_to_initial_pathologic_diagnosis"
## [26] "days_to_patient_progression_free"    
## [27] "disease_code"                        
## [28] "extranodal_involvement"              
## [29] "histological_type"                   
## [30] "icd_10"                              
## [31] "icd_o_3_histolo"                     
## [32] "icd_o_3_site"                        
## [33] "informed_consent_verified"           
## [34] "pathologic_M"                        
## [35] "pathologic_N"                        
## [36] "pathologic_T"                        
## [37] "pathologic_stage"                    
## [38] "patient_id"                          
## [39] "project_code"                        
## [40] "stage_other"                         
## [41] "system_version"                      
## [42] "tissue_source_site"                  
## [43] "tumor_tissue_site"                   
## [44] "bcr_patient_uuid"                    
## [45] "bcr_followup_barcode"                
## [46] "bcr_followup_uuid"                   
## [47] "form_completion_date"                
## [48] "followup_reason"                     
## [49] "followup_lost_to"                    
## [50] "radiation_treatment_adjuvant"        
## [51] "pharmaceutical_tx_adjuvant"          
## [52] "treatment_outcome_first_course"      
## [53] "vital_status"                        
## [54] "last_contact_days_to"                
## [55] "death_days_to"                       
## [56] "tumor_status"                        
## [57] "new_tumor_event_dx_indicator"        
## [58] "treatment_outcome_at_tcga_followup"  
## [59] "ecog_score"                          
## [60] "karnofsky_score"                     
## [61] "performance_status_timing"
M2<- merge.data.frame(M1, y_D, by= "bcr_patient_barcode", no.dups = T)

M2 <- M2[,-grep("*.x$", colnames(M2))]

colnames(M2)<- gsub("*.y$", "",colnames(M2))
colnames(M2)
##  [1] "bcr_patient_barcode"                 
##  [2] "prospective_collection"              
##  [3] "retrospective_collection"            
##  [4] "gender"                              
##  [5] "birth_days_to"                       
##  [6] "race"                                
##  [7] "ethnici"                             
##  [8] "jewish_religion_heritage_indicator"  
##  [9] "history_other_malignan"              
## [10] "history_neoadjuvant_treatment"       
## [11] "initial_pathologic_dx_year"          
## [12] "method_initial_path_dx_other"        
## [13] "tumor_grade"                         
## [14] "residual_tumor"                      
## [15] "residual_disease_largest_nodule"     
## [16] "vascular_invasion_indicator"         
## [17] "lymphovascular_invasion_indicator"   
## [18] "days_to_tumor_progression"           
## [19] "age_at_initial_pathologic_diagnosis" 
## [20] "anatomic_neoplasm_subdivision"       
## [21] "clinical_M"                          
## [22] "clinical_N"                          
## [23] "clinical_T"                          
## [24] "clinical_stage"                      
## [25] "days_to_initial_pathologic_diagnosis"
## [26] "days_to_patient_progression_free"    
## [27] "disease_code"                        
## [28] "extranodal_involvement"              
## [29] "histological_type"                   
## [30] "icd_10"                              
## [31] "icd_o_3_histolo"                     
## [32] "icd_o_3_site"                        
## [33] "informed_consent_verified"           
## [34] "pathologic_M"                        
## [35] "pathologic_N"                        
## [36] "pathologic_T"                        
## [37] "pathologic_stage"                    
## [38] "patient_id"                          
## [39] "project_code"                        
## [40] "stage_other"                         
## [41] "system_version"                      
## [42] "tissue_source_site"                  
## [43] "tumor_tissue_site"                   
## [44] "bcr_followup_barcode"                
## [45] "bcr_followup_uuid"                   
## [46] "followup_reason"                     
## [47] "followup_lost_to"                    
## [48] "radiation_treatment_adjuvant"        
## [49] "pharmaceutical_tx_adjuvant"          
## [50] "treatment_outcome_first_course"      
## [51] "vital_status"                        
## [52] "last_contact_days_to"                
## [53] "death_days_to"                       
## [54] "tumor_status"                        
## [55] "new_tumor_event_dx_indicator"        
## [56] "treatment_outcome_at_tcga_followup"  
## [57] "ecog_score"                          
## [58] "karnofsky_score"                     
## [59] "performance_status_timing"           
## [60] "bcr_patient_uuid"                    
## [61] "bcr_drug_barcode"                    
## [62] "bcr_drug_uuid"                       
## [63] "form_completion_date"                
## [64] "pharmaceutical_therapy_drug_name"    
## [65] "clinical_trial_drug_classification"  
## [66] "pharmaceutical_therapy_type"         
## [67] "pharmaceutical_tx_started_days_to"   
## [68] "pharmaceutical_tx_ongoing_indicator" 
## [69] "pharmaceutical_tx_ended_days_to"     
## [70] "treatment_best_response"             
## [71] "days_to_stem_cell_transplantation"   
## [72] "pharm_regimen"                       
## [73] "pharm_regimen_other"                 
## [74] "pharma_adjuvant_cycles_count"        
## [75] "pharma_type_other"                   
## [76] "pharmaceutical_tx_dose_units"        
## [77] "pharmaceutical_tx_total_dose_units"  
## [78] "prescribed_dose"                     
## [79] "regimen_number"                      
## [80] "route_of_administration"             
## [81] "stem_cell_transplantation"           
## [82] "stem_cell_transplantation_type"      
## [83] "therapy_regimen"                     
## [84] "therapy_regimen_other"               
## [85] "total_dose"                          
## [86] "tx_on_clinical_trial"
summary(M2)
##    bcr_patient_barcode                             prospective_collection
##  TCGA-42-2582:  28     [Not Available]                        :2808      
##  TCGA-42-2588:  26     CDE_ID:3088492                         :   1      
##  TCGA-09-1662:  23     NO                                     :  10      
##  TCGA-42-2589:  20     tissue_prospective_collection_indicator:   1      
##  TCGA-24-1467:  19     YES                                    :   9      
##  TCGA-29-A5NZ:  18                                                       
##  (Other)     :2695                                                       
##                               retrospective_collection
##  [Not Available]                          :2808       
##  CDE_ID:3088528                           :   1       
##  NO                                       :   9       
##  tissue_retrospective_collection_indicator:   1       
##  YES                                      :  10       
##                                                       
##                                                       
##             gender     birth_days_to 
##  CDE_ID:2200604:   1   -17961 :  28  
##  FEMALE        :2827   -22377 :  26  
##  gender        :   1   -21246 :  23  
##                        -19852 :  20  
##                        -21635 :  20  
##                        -18652 :  19  
##                        (Other):2693  
##                                         race     
##  WHITE                                    :2516  
##  BLACK OR AFRICAN AMERICAN                : 162  
##  [Not Available]                          :  70  
##  ASIAN                                    :  64  
##  AMERICAN INDIAN OR ALASKA NATIVE         :  12  
##  NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER:   3  
##  (Other)                                  :   2  
##                    ethnici     jewish_religion_heritage_indicator
##  [Not Available]       :1220   [Not Available]:2670              
##  [Not Evaluated]       :   7   [Not Evaluated]:   3              
##  CDE_ID:2192217        :   1   [Unknown]      :   0              
##  ethnicity             :   1   ASHKENAZI      : 154              
##  HISPANIC OR LATINO    :  57   CDE_ID:2200537 :   1              
##  NOT HISPANIC OR LATINO:1543   jewish_origin  :   1              
##                                                                  
##                                       history_other_malignan
##  [Not Available]                                 :2794      
##  CDE_ID:3382736                                  :   1      
##  No                                              :  28      
##  other_dx                                        :   1      
##  Yes, History of Synchronous/Bilateral Malignancy:   5      
##                                                             
##                                                             
##                   history_neoadjuvant_treatment initial_pathologic_dx_year
##  CDE_ID:3382737                  :   1          2008   : 325              
##  history_of_neoadjuvant_treatment:   1          2004   : 285              
##  No                              :2823          2005   : 247              
##  Yes                             :   4          2009   : 224              
##                                                 2003   : 219              
##                                                 2006   : 212              
##                                                 (Other):1317              
##                         method_initial_path_dx_other
##  [Not Applicable]                     :2823         
##  CDE_ID:2757948                       :   1         
##  Colonoscopy and biopsy               :   2         
##  Dilatation and Curettage, Polypectomy:   2         
##  init_pathology_dx_method_other       :   1         
##                                                     
##                                                     
##           tumor_grade           residual_tumor
##  G3             :2333   [Not Available]:2559  
##  G2             : 399   CDE_ID:2608702 :   1  
##  GX             :  45   R0             :  86  
##  G1             :  25   R1             : 146  
##  G4             :  14   R2             :  28  
##  [Not Available]:   8   residual_tumor :   1  
##  (Other)        :   5   RX             :   8  
##        residual_disease_largest_nodule  vascular_invasion_indicator
##  [Not Available]       : 275           [Not Available]:2112        
##  >20 mm                : 510           [Unknown]      :   6        
##  1-10 mm               :1315           CDE_ID:64358   :   1        
##  11-20 mm              : 170           NO             : 272        
##  CDE_ID:2785858        :   1           venous_invasion:   1        
##  No Macroscopic disease: 557           YES            : 437        
##  tumor_residual_disease:   1                                       
##   lymphovascular_invasion_indicator             days_to_tumor_progression
##  [Not Available]   :1767            [Not Available]          :2827       
##  [Unknown]         :   6            CDE_ID:3165480           :   1       
##  CDE_ID:64171      :   1            days_to_tumor_progression:   1       
##  lymphatic_invasion:   1                                                 
##  NO                : 365                                                 
##  YES               : 689                                                 
##                                                                          
##  age_at_initial_pathologic_diagnosis
##  58     : 168                       
##  56     : 133                       
##  50     : 122                       
##  51     : 117                       
##  53     : 117                       
##  61     : 117                       
##  (Other):2055                       
##                anatomic_neoplasm_subdivision            clinical_M  
##  [Not Available]              : 133          [Not Applicable]:2827  
##  anatomic_neoplasm_subdivision:   1          CDE_ID:3440331  :   1  
##  Bilateral                    :2010          clinical_M      :   1  
##  CDE_ID:3108203               :   1                                 
##  Left                         : 400                                 
##  Right                        : 284                                 
##                                                                     
##             clinical_N              clinical_T      clinical_stage
##  [Not Applicable]:2827   [Not Applicable]:2827   Stage IIIC:2057  
##  CDE_ID:3440330  :   1   CDE_ID:3440328  :   1   Stage IV  : 424  
##  clinical_N      :   1   clinical_T      :   1   Stage IIIB: 132  
##                                                  Stage IIC :  77  
##                                                  Stage IIIA:  42  
##                                                  Stage IC  :  30  
##                                                  (Other)   :  67  
##                    days_to_initial_pathologic_diagnosis
##  0                                   :2827             
##  CDE_ID:3008275                      :   1             
##  days_to_initial_pathologic_diagnosis:   1             
##                                                        
##                                                        
##                                                        
##                                                        
##                  days_to_patient_progression_free          disease_code 
##  [Not Available]                 :2827            [Not Available]:2827  
##  CDE_ID:4887491                  :   1            CDE_ID:        :   1  
##  days_to_patient_progression_free:   1            disease_code   :   1  
##                                                                         
##                                                                         
##                                                                         
##                                                                         
##             extranodal_involvement                 histological_type
##  [Not Applicable]      :2827       CDE_ID:3081934           :   1   
##  CDE_ID:3364582        :   1       histological_type        :   1   
##  extranodal_involvement:   1       Serous Cystadenocarcinoma:2827   
##                                                                     
##                                                                     
##                                                                     
##                                                                     
##             icd_10              icd_o_3_histolo         icd_o_3_site 
##  C48.0         :   0   8440/3           :   2   C48.0         :   0  
##  C48.1         :  39   8441/3           :2790   C48.1         :  39  
##  C48.2         :  13   8460/3           :  23   C48.2         :  13  
##  C56.9         :2775   8461/3           :  12   C56.9         :2775  
##  CDE_ID:3226287:   1   CDE_ID:3226275   :   1   CDE_ID:3226281:   1  
##  icd_10        :   1   icd_o_3_histology:   1   icd_o_3_site  :   1  
##                                                                      
##              informed_consent_verified           pathologic_M 
##  CDE_ID:3288361           :   1        [Not Applicable]:2827  
##  informed_consent_verified:   1        CDE_ID:3045439  :   1  
##  YES                      :2827        pathologic_M    :   1  
##                                                               
##                                                               
##                                                               
##                                                               
##            pathologic_N            pathologic_T          pathologic_stage
##  [Not Applicable]:2827   [Not Applicable]:2827   [Not Applicable]:2827   
##  CDE_ID:3203106  :   1   CDE_ID:3045435  :   1   CDE_ID:3203222  :   1   
##  pathologic_N    :   1   pathologic_T    :   1   pathologic_stage:   1   
##                                                                          
##                                                                          
##                                                                          
##                                                                          
##    patient_id            project_code           stage_other  
##  2582   :  28   [Not Available]:2827   [Not Available]:2827  
##  2588   :  26   CDE_ID:        :   1   CDE_ID:2007104 :   1  
##  1662   :  23   project_code   :   1   stage_other    :   1  
##  2589   :  20                                                
##  1467   :  19                                                
##  A5NZ   :  18                                                
##  (Other):2695                                                
##          system_version tissue_source_site         tumor_tissue_site
##  [Not Available]:2827   24     :592        CDE_ID:3427536   :   1   
##  CDE_ID:2722309 :   1   13     :554        Omentum          :  36   
##  system_version :   1   29     :312        Ovary            :2778   
##                         61     :251        Peritoneum ovary :  13   
##                         04     :208        tumor_tissue_site:   1   
##                         23     :183                                 
##                         (Other):729                                 
##           bcr_followup_barcode
##  TCGA-09-1662-F24243:  23     
##  TCGA-24-1467-F26039:  19     
##  TCGA-04-1542-F24118:  16     
##  TCGA-24-1557-F26194:  16     
##  TCGA-24-1930-F26410:  16     
##  TCGA-23-1023-F25587:  15     
##  (Other)            :2724     
##                             bcr_followup_uuid
##  0b2f4ddb-fa9e-45ec-97ab-a8fc3d0f4be8:  23   
##  0b7db63c-a9e8-47c4-8459-b34e4260d092:  19   
##  300786cc-f4e9-45c3-8987-c78cb62f21ea:  16   
##  4e109663-798b-40df-a011-0527bb6151ff:  16   
##  6c66cb68-4c55-4a8a-9241-99a2f36bc6fd:  16   
##  12658bed-f067-4263-b749-1e9839821a25:  15   
##  (Other)                             :2724   
##                                     followup_reason
##  [Not Available]                            :2761  
##  Additional New Tumor Event                 :  40  
##  CDE_ID:3233305                             :   1  
##  followup_case_report_form_submission_reason:   1  
##  Scheduled Follow-up Submission             :  26  
##                                                    
##                                                    
##         followup_lost_to    radiation_treatment_adjuvant
##  [Not Available]:2761    [Not Available]  : 245         
##  CDE_ID:61333   :   1    [Unknown]        :   2         
##  lost_follow_up :   1    CDE_ID:2005312   :   1         
##  NO             :  64    NO               :2561         
##  YES            :   2    radiation_therapy:   1         
##                          YES              :  19         
##                                                         
##        pharmaceutical_tx_adjuvant
##  [Not Available]    : 238        
##  CDE_ID:3397567     :   1        
##  NO                 :  39        
##  postoperative_rx_tx:   1        
##  YES                :2550        
##                                  
##                                  
##              treatment_outcome_first_course       vital_status 
##  Complete Remission/Response:1648           Alive       :1135  
##  [Not Available]            : 474           CDE_ID:5    :   1  
##  Partial Remission/Response : 316           Dead        :1692  
##  Progressive Disease        : 210           vital_status:   1  
##  Stable Disease             : 168                              
##  [Not Applicable]           :   6                              
##  (Other)                    :   7                              
##       last_contact_days_to          death_days_to 
##  [Not Available]: 514      [Not Applicable]:1135  
##  3224           :  19      1024            :  25  
##  1446           :  18      2717            :  23  
##  1484           :  17      3224            :  19  
##  1579           :  17      1102            :  18  
##  1213           :  16      1446            :  18  
##  (Other)        :2228      (Other)         :1591  
##                         tumor_status 
##  [Not Available]              : 134  
##  [Unknown]                    :  17  
##  CDE_ID:2759550               :   1  
##  person_neoplasm_cancer_status:   1  
##  TUMOR FREE                   : 495  
##  WITH TUMOR                   :2181  
##                                      
##                           new_tumor_event_dx_indicator
##  [Not Available]                        :2531         
##  [Unknown]                              :   7         
##  CDE_ID:3121376                         :   1         
##  new_tumor_event_after_initial_treatment:   1         
##  NO                                     :  53         
##  YES                                    : 236         
##                                                       
##            treatment_outcome_at_tcga_followup
##  [Not Available]            :2529            
##  Progressive Disease        : 169            
##  Complete Remission/Response:  67            
##  Stable Disease             :  31            
##  [Unknown]                  :  17            
##  [Not Applicable]           :   8            
##  (Other)                    :   8            
##                          ecog_score                      karnofsky_score
##  [Not Available]              :2134   [Not Available]            :2568  
##  0                            : 453   100                        :  43  
##  1                            : 190   40                         :   3  
##  2                            :  41   60                         :  54  
##  3                            :   9   80                         : 159  
##  CDE_ID:88                    :   1   CDE_ID:2003853             :   1  
##  eastern_cancer_oncology_group:   1   karnofsky_performance_score:   1  
##                    performance_status_timing
##  [Not Available]                :1939       
##  CDE_ID:2792763                 :   1       
##  Other                          : 141       
##  performance_status_scale_timing:   1       
##  Post-Adjuvant Therapy          : 292       
##  Pre-Adjuvant Therapy           : 292       
##  Preoperative                   : 163       
##                              bcr_patient_uuid            bcr_drug_barcode
##  7922df77-f09a-488c-a1be-58646ceb9b3e:  28    TCGA-42-2582-D28028:   4   
##  654d02ab-05b4-4863-99d9-04d087ff91b4:  26    TCGA-42-2582-D28029:   4   
##  867f9563-16c9-45a8-b519-6df61ba1b6b7:  23    TCGA-42-2582-D28030:   4   
##  dfb7dc5d-92f4-4a3a-9667-db38efcc9fdb:  20    TCGA-42-2582-D28031:   4   
##  34f545ab-d420-4dd2-8db4-3159896efd23:  19    TCGA-42-2582-D28818:   4   
##  F1CB3D48-1415-408D-89D1-DFDCC5924963:  18    TCGA-42-2582-D28819:   4   
##  (Other)                             :2695    (Other)            :2805   
##                               bcr_drug_uuid  form_completion_date
##  180D0212-9DF5-42F7-928C-EB0455BB8FAE:   4   2009-4-16: 143      
##  1a6c0376-6bc1-4d52-ad00-2a5d128b8232:   4   2009-3-27: 138      
##  44CFCC79-0825-468C-84A0-5E1288307CF4:   4   2009-4-15: 120      
##  495ec0d8-ca4e-4ef2-af6c-2f5ee7b212fc:   4   2009-5-13: 116      
##  55f15f39-17c5-4aa3-9a39-bab6794e69f5:   4   2009-6-30: 113      
##  6a1466ac-1f06-4617-a34e-604e6945dac0:   4   2009-12-4:  88      
##  (Other)                             :2805   (Other)  :2111      
##  pharmaceutical_therapy_drug_name
##  Carboplatin:769                 
##  Taxol      :407                 
##  Paclitaxel :366                 
##  Cisplatin  :219                 
##  Doxil      :134                 
##  Topotecan  :123                 
##  (Other)    :811                 
##                   clinical_trial_drug_classification
##  [Not Available]                   :2827            
##  CDE_ID:3378323                    :   1            
##  clinical_trail_drug_classification:   1            
##                                                     
##                                                     
##                                                     
##                                                     
##              pharmaceutical_therapy_type pharmaceutical_tx_started_days_to
##  [Not Available]           :  18         [Not Available]: 156             
##  CDE_ID:2793530            :   1         35             :  52             
##  Chemotherapy              :2663         31             :  49             
##  Hormone Therapy           :  56         17             :  46             
##  Immunotherapy             :  18         21             :  44             
##  Targeted Molecular therapy:  72         22             :  39             
##  therapy_type              :   1         (Other)        :2443             
##  pharmaceutical_tx_ongoing_indicator pharmaceutical_tx_ended_days_to
##  [Not Available]: 182                [Not Available]: 352           
##  CDE_ID:3103479 :   1                161            :  30           
##  NO             :2573                147            :  29           
##  therapy_ongoing:   1                151            :  29           
##  YES            :  72                141            :  26           
##                                      143            :  25           
##                                      (Other)        :2338           
##                  treatment_best_response
##  [Not Available]             :2790      
##  Complete Response           :  19      
##  Partial Response            :   6      
##  Clinical Progressive Disease:   5      
##  Stable Disease              :   4      
##  [Not Applicable]            :   3      
##  (Other)                     :   2      
##                  days_to_stem_cell_transplantation         pharm_regimen 
##  [Not Available]                  :2827            [Not Available]:2827  
##  CDE_ID:3414613                   :   1            CDE_ID:3366758 :   1  
##  days_to_stem_cell_transplantation:   1            pharm_regimen  :   1  
##                                                                          
##                                                                          
##                                                                          
##                                                                          
##           pharm_regimen_other  pharma_adjuvant_cycles_count
##  [Not Available]    :2827     06             : 514         
##  CDE_ID:3366930     :   1     [Not Available]: 448         
##  pharm_regimen_other:   1     6              : 434         
##                               03             : 145         
##                               08             : 145         
##                               04             : 114         
##                               (Other)        :1029         
##           pharma_type_other  pharmaceutical_tx_dose_units
##  [Not Available]   :2827    mg             :1329         
##  CDE_ID:2001762    :   1    [Not Available]: 814         
##  therapy_type_notes:   1    mg/m2          : 557         
##                             AUC            : 103         
##                             mg/kg          :  16         
##                             mg/day         :   6         
##                             (Other)        :   4         
##  pharmaceutical_tx_total_dose_units        prescribed_dose
##  mg             :1329               [Not Available]:2601  
##  [Not Available]: 814               135            :  14  
##  mg/m2          : 557               60             :  10  
##  AUC            : 103               180            :   8  
##  mg/kg          :  16               175            :   7  
##  mg/day         :   6               800            :   7  
##  (Other)        :   4               (Other)        : 182  
##          regimen_number          route_of_administration
##  [Not Available]:2782   IV                   :2148      
##  02             :  21   [Not Available]      : 289      
##  03             :  10   IP                   : 169      
##  04             :   6   IP|IV                : 159      
##  05             :   4   PO                   :  57      
##  06             :   4   Other (specify below):   5      
##  (Other)        :   2   (Other)              :   2      
##              stem_cell_transplantation
##  [Not Available]          :2827       
##  CDE_ID:3090688           :   1       
##  stem_cell_transplantation:   1       
##                                       
##                                       
##                                       
##                                       
##                 stem_cell_transplantation_type
##  [Not Available]               :2827          
##  CDE_ID:2730901                :   1          
##  stem_cell_transplantation_type:   1          
##                                               
##                                               
##                                               
##                                               
##                 therapy_regimen                therapy_regimen_other
##  ADJUVANT               :1568   [Not Applicable]          :2760     
##  PROGRESSION            : 581   [Not Available]           :  10     
##  RECURRENCE             : 573   Persistent                :   8     
##  OTHER, SPECIFY IN NOTES:  67   Adjuvant and Progression  :   6     
##  [Not Available]        :  37   Persistence               :   6     
##  CDE_ID:2793511         :   1   Progression and Recurrence:   6     
##  (Other)                :   2   (Other)                   :  33     
##            total_dose             tx_on_clinical_trial
##  [Not Available]: 869   [Not Available]     :2790     
##  175            : 129   CDE_ID:3925111      :   1     
##  5              : 102   NO                  :  28     
##  6              :  70   tx_on_clinical_trial:   1     
##  75             :  59   YES                 :   9     
##  135            :  48                                 
##  (Other)        :1552