Welcome to TheCodingDocs!
TheCodingDocs.com is a free website founded by Brandon Rose, MD, MPH, with the goal of teaching computer coding and data topics to any interested doctors, residents, medical students, and pre-medical students. The open-source programming language R, and it's wrapper program, RStudio, will be the main focus at first. We are open to adding additional topics. If you want to collaborate please contact us (see website footer)! I also offer one on help in R and shiny apps.
Use your REDCap API token to create an updatable R list object (DB)
To be used downstream for analysis, data exports, shiny apps, and even data imports
GitHub code found at https://github.com/brandonerose/rosyredcap
Built in part by using REDCapR package. Check out their page!
Imports all metadata and tables and organizes them into tables for export or app use
This code supports basic REDCap projects (not ones with timepoints)
May require customization to get it to work for your project.
Email thecodingdocs@gmail.com with suggestions or issues.
Consider donating small or otherwise if I helped your project! https://account.venmo.com/u/brandonerose
Go to https://brandonerose.shinyapps.io/rosyicd10/ for the LIVE app
Filter at the top of the main table and/or select different levels (or use tabs)
Click on a row to add it to your codes, and watch the sidebar count go up!
Remove unwanted codes by highlighting from your selections table and click remove
Email thecodingdocs@gmail.com with suggestions or issues.
GitHub code found at https://github.com/brandonerose/rosyicd10
Same code but easier to learn Shiny found at https://github.com/brandonerose/rosyicd10_simple
Consider donating small or otherwise if I helped your project! https://account.venmo.com/u/brandonerose
Reasons to STOP using Microsoft Excel (for everything)!
If a publication asks to see your data and your analysis they will likely not accept an Excel table. They need a path from raw data all the way to final products. If they ask for changes it's a lot easier to change a few lines of code and run again!
MISTAKES - Everybody makes mistakes. Unless you exported the data yourself, there is no way to trust that the data in an excel table is accurate (unedited).
You can brute-force 100 or 200 rows but not thousands or tens of thousands of rows!
Changes cannot be tracked long-term. Control Z is not forever.
Certain data types in Excel, especially dates and times can be misinterpreted by other programs and passed on.
Multiple tabs, hidden rows, copys of copys - what a nightmare!
IF your institution has biostaticians or data helpers they are likely very busy and scheduling meetings take time.
Why Learn Some Basic Coding?
You are smart enough to, and it will make your life easier.
Code is reproducible, scalable, and sharable.
Excel should only be used for raw data storage and unofficial tasks.
Excel SHOULD NOT be used for data manipulation!
If your data needs to be manipulated at all you will likely need to code.
IF your institution has biostatisticians or data helpers they are likely very busy and scheduling meetings takes time. Being somewhat independent will maximize everyone's time.