急求大神指点,以下是一个含3列的数据框(取自TCGA临床数据),第1行是列名,想要将这3列数据合并在第4列(新建1列,列名为Outcome),规则如下:1.认为Unknown与Not Available同义,并且级别最低,如果某一行数据在三列中不同,取Unknown或Not Available以外的某列数据放在第4列。2.如果Unknown或Not Available与Complete Remission/Response、Partial Remission/Response、Stable Disease、Progressive Disease等值在某一个格子内同时出现,认为是原始记录错误,忽略Unknown或Not Available。3.如果Complete Remission/Response、Partial Remission/Response、Stable Disease、Progressive Disease这4种结果同时出现,无论是某一列内(记录错误)还是3列间,按照Complete Remission/Response > Partial Remission/Response > Stable Disease > Progressive Disease的优先级保留唯一的值。敬请大神指点,多谢!
follow_ups.follow_up.followup_treatment_success | follow_ups.follow_up.primary_therapy_outcome_success | primary_therapy_outcome_success |
Complete Remission/Response | Complete Remission/Response | Complete Remission/Response |
Complete Remission/Response;Complete Remission/Response | Complete Remission/Response;Complete Remission/Response | Not Available |
Not Available | ||
Complete Remission/Response;Complete Remission/Response | Complete Remission/Response;Complete Remission/Response | Not Applicable |
Progressive Disease | Progressive Disease | Not Available |
Complete Remission/Response | Complete Remission/Response | Unknown |
Unknown | Unknown | Not Available |
Complete Remission/Response | Complete Remission/Response | Complete Remission/Response |
Unknown | ||
Not Available;Complete Remission/Response | Complete Remission/Response;Complete Remission/Response | Not Available |
Stable Disease | Stable Disease | Not Available |
Not Available | Progressive Disease | Not Available |
Complete Remission/Response;Complete Remission/Response | Complete Remission/Response;Complete Remission/Response | Not Available |
Complete Remission/Response | Complete Remission/Response | Complete Remission/Response |
Not Applicable | Not Available | Not Available |
Not Available | Complete Remission/Response | Not Available |
Complete Remission/Response | Not Applicable | Not Available |
Not Available | Not Available | Not Available |
Complete Remission/Response;Complete Remission/Response;Progressive Disease | Complete Remission/Response;Not Available;Complete Remission/Response | Not Available |
Progressive Disease | Complete Remission/Response | Complete Remission/Response |
Complete Remission/Response | Complete Remission/Response | Complete Remission/Response |
Not Available | Progressive Disease | Not Available |
Complete Remission/Response | ||
Complete Remission/Response | Complete Remission/Response | Not Available |
Complete Remission/Response;Complete Remission/Response | Complete Remission/Response;Complete Remission/Response | Not Available |
Not Available | Not Available | Not Available |
Not Available;Unknown | Not Available;Complete Remission/Response | Not Available |
Not Available | Not Available | Not Available |
Stable Disease | Stable Disease | Stable Disease |