Package: EDCimport 0.7.0.9005

EDCimport: Import Data from EDC Software

A convenient toolbox to import data exported from Electronic Data Capture (EDC) software 'TrialMaster'.

Authors:Dan Chaltiel [aut, cre]

EDCimport_0.7.0.9005.tar.gz
EDCimport_0.7.0.9005.zip(r-4.7)EDCimport_0.7.0.9005.zip(r-4.6)EDCimport_0.7.0.9005.zip(r-4.5)
EDCimport_0.7.0.9005.tgz(r-4.6-any)EDCimport_0.7.0.9005.tgz(r-4.5-any)
EDCimport_0.7.0.9005.tar.gz(r-4.7-any)EDCimport_0.7.0.9005.tar.gz(r-4.6-any)
EDCimport_0.7.0.9005.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
EDCimport/json (API)

# Install 'EDCimport' in R:
install.packages('EDCimport', repos = c('https://danchaltiel.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/danchaltiel/edcimport/issues

Pkgdown/docs site:https://danchaltiel.github.io

On CRAN:

Conda:

quarto

6.11 score 24 scripts 265 downloads 61 exports 44 dependencies

Last updated from:e7e65bd337. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK192
source / vignettesOK290
linux-release-x86_64OK209
macos-release-arm64OK212
macos-oldrel-arm64OK148
windows-develOK181
windows-releaseOK183
windows-oldrelOK153
wasm-releaseOK149

Exports:%>%assert_no_duplicateassert_no_rowscheck_subjidcompare_databasescrf_status_plotedc_browse_exceledc_clean_namesedc_crf_plotedc_data_stopedc_data_warnedc_data_warningsedc_db_to_exceledc_exampleedc_example_multipleedc_example_plotedc_find_columnedc_find_valueedc_full_joinedc_inform_codeedc_left_joinedc_lookupedc_optionsedc_pal_crfedc_patient_gridplotedc_peek_optionsedc_population_plotedc_reset_optionsedc_right_joinedc_split_mixededc_swimmerplotedc_unify_subjidedc_vieweredc_warn_extraction_dateedc_warn_patient_diffsfct_yesnofind_keywordget_common_colsget_datasetsget_lookupget_project_nameharmonize_subjidlastnews_tableload_databaseload_listmanual_correctionread_all_csvread_all_sasread_all_xptread_tm_all_xptread_trialmasterreset_manual_correctionsave_edc_data_warningssave_plotlysave_sessioninfosearch_for_newer_dataselect_distinctset_project_nametable_formattibbleunify

Dependencies:bitbit64clicliprcpp11crayondplyrfarverforcatsfsgenericsggplot2gluegtablehavenhmsisobandlabelinglifecyclelubridatemagrittrpillarpkgconfigprettyunitsprogresspurrrR6RColorBrewerreadrrlangS7scalesstringistringrtibbletidyrtidyselecttimechangetzdbutf8vctrsviridisLitevroomwithr

Table Reading Date Error
Steps to Correct the Issue
Rendered fromtrialmaster_date_error.qmdusingquarto::html

Last update: 2026-01-06
Started: 2025-12-28

1 - Read your database
Read your database | Explore your database | Shiny browser
Rendered fromreading.qmdusingquarto::html

Last update: 2025-06-24
Started: 2025-02-14

2 - Post processing
Introduction | Harmonize Subject ID across the database | Clean dataset names | Split some dataset to short+long | You can combine!
Rendered frompostprocessing.qmdusingquarto::html

Last update: 2025-06-23
Started: 2025-02-15

3 - Data checking
Introduction | Data warning | Data errors | Fatal error | Duplicate-free dataset assertion | Last-news table
Rendered fromchecking.qmdusingquarto::html

Last update: 2025-06-23
Started: 2025-02-15

4 - Database Visualizing
Introduction | Swimmer plot | CRF completion plot | Patient gridplot | Population plot
Rendered fromvisualizing.qmdusingquarto::html

Last update: 2025-06-23
Started: 2025-02-16

5 - Utility Functions
Introduction | Joins | "Yes/No" harmonizer | Miscellaneous
Rendered fromutils.qmdusingquarto::html

Last update: 2025-02-16
Started: 2025-02-16

Readme and manuals

Help Manual

Help pageTopics
Assert that a dataframe has one row per patientassert_no_duplicate
Compare multiple EDC database extractionscompare_databases
Clean up the names of all datasetsedc_clean_names
Show the current CRF status distributioncrf_status_plot edc_crf_plot edc_pal_crf
Standardized warning systemassert_no_rows edc_data_stop edc_data_warn edc_data_warnings
EDCimport Databaseedc_database
Save the database as an Excel fileedc_browse_excel edc_db_to_excel
Example databaseedc_example edc_example_plot
Search the whole databaseedc_find_column edc_find_value find_keyword
Shows how many code you wroteedc_inform_code
Join within the EDCimport frameworkedc_full_join edc_left_join edc_right_join
Retrieve the lookup table from optionsedc_lookup get_lookup
Set global options for 'EDCimport'edc_options
Patient gridplotedc_patient_gridplot
See which 'EDCimport' option is currently setedc_peek_options
Plot the populationsedc_population_plot
Reset all 'EDCimport' optionsedc_reset_options
Split mixed datasetsedc_split_mixed
Swimmer plot of all dates columnsedc_swimmerplot
Harmonize the subject ID of the databaseedc_unify_subjid harmonize_subjid
Shiny data exploreredc_viewer
Warn if extraction is too oldedc_warn_extraction_date
Check the validity of the subject ID columncheck_subjid edc_warn_patient_diffs
Format factor levels as Yes/Nofct_yesno
Get columns that are common to multiple datasetsget_common_cols summary.common_cols
Retrieve the datasets as a list of data.framesget_datasets
Get a table with the latest date for each patientlastnews_table
Load a list in an environmentload_database load_list
Manual correctionmanual_correction reset_manual_correction
Read all '.csv' files in a directoryread_all_csv
Read all '.sas7bdat' files in a directoryread_all_sas
Read all '.xpt' files in a directoryread_all_xpt read_tm_all_xpt
Read the '.zip' archive of a TrialMaster exportread_trialmaster
Save EDCimport warning to Excelsave_edc_data_warnings
Save a plotly to an HTML filesave_plotly
Save 'sessionInfo()' outputsave_sessioninfo
Search for newer datasearch_for_newer_data
Select only distinct columnsselect_distinct
Set the project nameget_project_name set_project_name
Identify if a dataframe has a long or a wide formattable_format
Unify a vectorunify