Normalizes bimodal or discordant measurement values to a canonical target unit.
Usage
normalize_units(
con_or_df,
concept_id = NULL,
feature = NULL,
target_unit = "mg/dL",
auto_convert_ratio = 88.42,
threshold = NULL,
bimodal_threshold = NULL,
value_col = "value_as_number",
concept_col = "measurement_concept_id",
measurement_concept_id = NULL,
measurement_table = "measurement",
output_table = NULL
)Arguments
- con_or_df
Active DuckDB connection or data frame.
- concept_id
Optional concept ID.
- feature
Optional feature column name.
- target_unit
Target unit (default 'mg/dL').
- auto_convert_ratio
Numeric ratio (default 88.42).
- threshold
Optional threshold above which values are converted.
- bimodal_threshold
Alias for threshold.
- value_col
Value column name (default 'value_as_number').
- concept_col
Concept column name (default 'measurement_concept_id').
- measurement_concept_id
Alias for concept_id.
- measurement_table
Measurement table name (default 'measurement').
- output_table
Optional output table name to materialize into DuckDB.