Seeking Volunteers: Help Create and Manage Tracking Spreadsheet
Hey everyone,
We are seeking volunteers to assist in converting the OHDSI_2025_GuidelineDrivenEvidencePhenotypeNeeds_28Jan2025.xlsx dataset from its current wide format to a long format. This restructuring is crucial for our ongoing efforts in the OHDSI 2025 Guideline-driven Evidence Phenotype initiative.
Objective:
Transform the dataset so that each row represents a single phenotype, with specific attributes detailed in separate columns.
Target Long-Form Structure something like:
Each row should include the following columns
- phenotypeName – The name of the phenotype.
- phenotypeType – Classification such as indication, target, comparator, or outcome.
- needPhenotypeDevEval – Indicates whether phenotype development and evaluation are needed (e.g., drug cohorts).
- similarCohortsInOhdsiPl – References to any similar cohorts in the OHDSI Phenotype Library.
- canReuseCohortsInOhdsiPl – Specifies if existing cohorts in the OHDSI Phenotype Library can be reused.
- linkToLiteratureSearch – URLs or references to literature supporting the phenotype
- studyLeadsNeedPhenotype – Names of study leads who require this phenotype.
- targetClinicalDescription – A detailed clinical description of the phenotype.
- candidateCohortDefinitions – Any candidate cohort definitions; track contributions from the community. Use atlas-demo.ohdsi.org