RADAR Cleaning

R cleaning scripts used for network data from Northwestern University's RADAR Project. The primary purpose of this repository is to provide version control for a body of scripts that have previously been managed with filename changes. However, some additional information and context is provided for both potential users of the scripts and individuals curious about the scripts used for this data.

Prerequisites

• R
• Neo4j (select scripts)

Getting started

• Clone this repository to your machine by running git clone <repo-url>.

• If you are involved in the RADAR Project, please request access to the network data, which will give you access to configure_networkscripts.txt, REDCapIDs.txt, and corrections.json.

• If you want to run all three of the core cleaning scripts, run Process_NetworkFiles.R.

• If you want to run an individual processing script, you can find them in the Process/ directory.

• If you want to run any number of the miscellaneous scripts (data pulls, reports, etc.), you can do this by running Misc_NetworkScripts.R.

• If you want to run an individual 'miscellaneous' script, you can find them in the Misc/ directory.

Notes

Clean_NetworkFiles.R

Data corrections are stored in JSON format. You can review the command line interface used to generate this JSON file at https://github.com/mchlltt/inquirer-corrections.

REDCapIDPull.js

This file is the code for a bookmarklet pulls survey dates and participant IDs from REDCap (Research Electronic Data Capture). If you have access to RADAR Survey data in REDCap, you can use this script by taking the following steps.

• Create a new bookmark in your browser.
• Set the title of the bookmark to 'REDCap ID Pull' or something else that you will understand.
• Copy the text in REDCapIDPull.js.
• Paste the contents of REDCapIDPull.js into the URL field of the new bookmark.
• Click this bookmark when you are on the RADAR Survey/Demographics page.
• Open your browser's developer tools. In Chrome, you can do this by right-clicking the page and selecting Inspect Element or by hitting 'Control-Shift-C' or 'Command-Shift-C'.
• If you are not already there, navigate to the 'Console' tab of the developer tools.
• Refer to your copy of REDCapIds.txt and identify the latest included ID.
• Copy from your console output beginning at the first new ID.
• Paste into REDCapIds.txt.

Note: If you want to run the script without making a bookmark, you can paste the contents of REDCapIDPull.js into your browser's console and run it from there. The majority of the instructions above still apply.

License

This project is licensed under the MIT License - see the LICENSE file for details

Authors

• Mich Elliott - mchlltt
• Patrick Janulis - pfsj

Acknowledgements

My time working on this project is funded by the NIH via Northwestern University's Institute for Sexual and Gender Minority Health and Wellbeing. Visit the RADAR Project's DokuWiki Codebook if you are interested in the study collecting this data.