Detect whether a data frame is a Qualtrics survey export

Fires when the columns include enough of Qualtrics' reserved response-metadata names (StartDate, EndDate, Progress, Duration (in seconds), Finished, RecordedDate, ResponseId, DistributionChannel, ...) that the file is unambiguously a Qualtrics export – these exact names essentially never co-occur outside Qualtrics. The ResponseId column (values like R_xxxxx) or a leftover ImportId JSON header cell is treated as corroborating.

Usage

data_check_is_qualtrics(df, min_meta = 4L)

Arguments

df

a data.frame (a read tabular file)

min_meta

minimum number of distinct metadata columns required

Value

TRUE when df looks like a Qualtrics export, else FALSE.

Examples

df <- data.frame(StartDate = "2024-01-01 10:00", EndDate = "2024-01-01 10:05",
                 Status = 0, IPAddress = "0.0.0.0", Progress = 100,
                 ResponseId = "R_1", Q1 = 3)
data_check_is_qualtrics(df)
#> [1] TRUE
data_check_is_qualtrics(data.frame(id = 1:3, rt = c(512, 640, 498)))
#> [1] FALSE