... | ... | @@ -6,13 +6,19 @@ |
|
|
|
|
|
# Part C - Harmonising Your Data for the WP7 Demo Project
|
|
|
|
|
|
In the e-mail you received from WP3, you will find:
|
|
|
1. the harmonisation dictionary for this demo project (also available [here](https://gitlab.inesctec.pt/wp4-recap/wp7-demo/-/blob/master/wp7_demo_harmonization_dictionary.xlsx)). This file is the same for every cohort;
|
|
|
1. a spreadsheet suggesting the variables from your cohort that may be harmonizable to the variables of this demo project.
|
|
|
|
|
|
The first file will be used in the next section, whereas the second file can be used in [section 4](#4-harmonise-each-variable) to help you harmonise your variables.
|
|
|
|
|
|
## 1. Upload the Harmonisation Dictionary
|
|
|
The first step in the harmonisation process is to upload the harmonisation dictionary into your repository. You can download the harmonisation dictionary [here](https://gitlab.inesctec.pt/wp4-recap/wp7-demo/-/blob/master/wp7_demo_harmonization_dictionary.xlsx).
|
|
|
The first step in the harmonisation process is to upload the harmonisation dictionary into your repository.
|
|
|
|
|
|
1. Log into your Data Repository
|
|
|
1. Click on `Projects` on the top bar and then select your project
|
|
|
1. Click on `Projects` on the top bar and then select your cohort's project
|
|
|
1. Click on the `Files` tab on the left panel and then click on `Upload`
|
|
|
1. Browse to the downloaded harmonisation dictionary file, select it and then click `Upload`
|
|
|
1. Browse to the location of the harmonisation dictionary file, select it and then click `Upload`
|
|
|
|
|
|
## 2. Create a View over Your Original Table
|
|
|
The harmonisation process in the Data Repository is based on the concept of `views`.
|
... | ... | @@ -55,11 +61,15 @@ In order to allow the analysis team to also use DataSHIELD to perform analysis, |
|
|
* **3.9.** Type in `wp7-demo` and click `Save`.
|
|
|
|
|
|
## 4. Harmonise Each Variable
|
|
|
>**NOTE**
|
|
|
WP3 have already identified possible variables from your cohort that may be harmonisable to the variables of this demo project. The spreadsheet with the suggested variables was sent to you in an e-mail by WP3.
|
|
|
So in this section, you can make use of that spreadsheet to help you identify which variables from your cohort are relevant to this demo project.
|
|
|
|
|
|
To pull and transform the original variables from the original table, you need to individually harmonise each target variable in the view.
|
|
|
The harmonisation approach for each target variable depends on whether it is a categorical variable or not.
|
|
|
|
|
|
For **categorical target variables**, continue reading [4.1](#41-the-target-variable-is-categorical) below.
|
|
|
For **continuos target variables**, got to [4.2](#42-the-target-variable-is-continuous).
|
|
|
For **continuos target variables**, go to [4.2](#42-the-target-variable-is-continuous).
|
|
|
|
|
|
### **4.1.** The target variable is categorical
|
|
|
For categorical target variables you can use the graphical web interface:
|
... | ... | |