# Preprocessing systematic review data of Brouwer et al. (2019) for use in ASReview This repository contains steps and scripts to produce one single dataset of records that were screened in subsets as part of the systematic review conducted by Brouwer et al. (2019). The raw files used to produce the dataset are stored in `/raw`. The dataset is spread out in different subsets: - Behaviour - Cognitive - Diathesis - Personality - Psychodynamic - Additional search (update of searches at the end of the review process) We went through the following steps to build the dataset: ## Retrieve abstracts Some records in the raw data did not contain an abstract. We imported the `bib` files into an EndNote library to retrieve missing abstracts. The following steps were taken for each `bib` file: 1. Import `bib` file to Endnote. 2. Sort records on abstract field and select records without abstracts 3. Update references without abstracts (update empty fields only) 4. Export as a .ris file to the folder `raw/1 - retrieve abstracts/ris-with-abstracts`. See also `raw/1 - retrieve abstracts/datasets bockting.xlsx` for a log. ## Search and label inclusions. The raw files do not contain information whether a record is relevant or not. Therefore, the data had to be manually inspected to identify the relevant records. We then imported the `RIS` files in Zotero. For each of the subsets, it was necessary to check which of the which of the relevant records are present in the respective subset. The appendix from the original systematic review contained the reference list of relevant records. If a relevant record was found in a subset, the 'Tag' functionality of Zotero was used to assign a label "Included" to the record. A log of the process can be found in the folder `raw/2 - detect inclusions/zotero-labeling` Three relevant records in the reference list were missing (see `missing_records.docx`, marked yellow). After consulting Marlies Brouwer, these were manually added to the Zotero library. The Zotero libraries were exported as separate `.csv` files, to be found in the `raw/2 - detect inclusions/zotero-export/csv-included-tag` folder. The Zotero library as is can be found in `raw/2 - detect inclusions/zotero-export/rdf-included-tag`. ## Combining the subsets into one dataset The R-script `scripts/Detect_inclusions2.R` combines all subsets into one dataset and subsequently adds a column `included` to indicate the relevant records in the dataset, and a column `search` to indicate the subset from which the record originates. The output is [`brouwer_2019.csv`][1], which can be found in the main directory of the OSF repository. ## Second round of DOI-retrieval and de-duplication To retrieve missing DOIs, we used the script `scripts/crossref_doi_retrieval.ipynb` from [van den Brand et al. (2021)][2]. The output is stored in the file [` brouwer_2019_doi_retrieved.xlsx`][3]. To remove duplicates we ran the script `scripts/master_script_deduplication.R` from [van den Brand et al. (2021)][4]. The output is stored in the file [`brouwer_2019_deduplicated.xlsx`][5]. The number of records in the de-duplicated datafile is: |search | n_inclusions| n before/after duplication| |:--------------------|------------:|-------------------------:| |additional | 7| 4.259 / 3.766 | |behavior | 5| 10.245 / 9.472 | |cognitive | 25| 8.369 / 7.266 | |cognitive_additional | 3| 5.461 / 4.962 | |diathesis | 3| 5.336 / 4.823 | |missing | 3| 3 / 3| |personality | 16| 6.624 / 5.944 | |psychodynamic | 1| 10.639 / 10.140 | |grand total | 63| 50.936 / 46.376 | The final file is [`brouwer_2019_deduplicated.csv`][6]. #Reference to the original study Brouwer, M. E., Williams, A. D., Kennis, M., Fu, Z., Klein, N. S., Cuijpers, P., & Bockting, C. L. H. (2019). Psychological theories of depressive relapse and recurrence: A systematic review and meta-analysis of prospective studies. Clinical Psychology Review, 74, 101773. https://doi.org/10.1016/j.cpr.2019.101773 # License This dataset has a CC-By 4.0 license. # Funding This project is funded by a grant from the Centre for Urban Mental Health, University of Amsterdam, The Netherlands # Contact For any questions or remarks, please send an email to [Marlies Brouwer](https://orcid.org/0000-0002-9972-9058). [1]: https://osf.io/py7ek/ [2]: https://github.com/asreview/paper-megameta-postprocessing-screeningresultsrouwer](https://orcid.org/0000-0002-9972-9058). [3]: https://osf.io/kdqu8/ [4]: https://github.com/asreview/paper-megameta-postprocessing-screeningresultsrouwer](https://orcid.org/0000-0002-9972-9058). [5]: https://osf.io/2mwkd/ [6]: https://osf.io/2mwkd/