Skip to contents

Identify if a dataframe has a long or a wide format

Source: R/split_mixed.R
table_format.Rd

A dataset is either in the wide format or in the long format (link). This function identifies the format of a dataframe with respect to a subject ID. If a dataframe has some wide and long columns, it is considered "mixed".

Usage

table_format(
  df,
  id = get_subjid_cols(),
  ...,
  ignore_cols = get_meta_cols(0.95),
  na_rm = FALSE,
  warn = TRUE
)

Arguments

df

a dataframe

id

the identifying subject ID

...

not used

ignore_cols

columns to ignore. Usually meta columns (see get_meta_cols).

na_rm

whether to consider missing values

warn

whether to warn if ID is not found

Value

a string value in c("wide", "long", "mixed)

Examples

tm = edc_example_mixed()
#> Warning: Option "edc_lookup" has been overwritten.
sapply(tm, table_format, warn=FALSE) 
#> $short
#> [1] "wide"
#> 
#> $long_pure
#> [1] "long"
#> 
#> $long_mixed
#> [1] "mixed"
#> 
#> $date_extraction
#> NULL
#> 
#> $datetime_extraction
#> NULL
#> 
#> $.lookup
#> NULL
#>