Integrate / Split Columns

KEY:

ds = dataset you are currently using.

DV = dependent variable of interest

IV = independent variable of interest

 

Subject = name of subject number column 

XYXY = dummy name for a variable, matrix, or data frame into which you are moving information.

Integrate - No identifier column

_____________________________

ds$new <- ds$Col1
ds$new[!is.na(ds$Col2)] <- ds$Col2[!is.na(ds$Col2)]
ds$new[!is.na(ds$Col3)] <- ds$Col3[!is.na(ds$Col3)]

_____________________________

Integrate - With an identifier

_____________________________

ds$New[ds$Condition == "C1"] <-ds$Col1[ds$Condition == "C1"]
ds$New[ds$Condition == "C2"] <-ds$Col1[ds$Condition == "C2"]

ds$New[ds$Condition == "C3"] <-ds$Col1[ds$Condition == "C3"]

_____________________________

Split column in two

Please note: This example "CorrResp", "Old", "New", "ACC", "Hits", and "CR" correspond to information in the above graphic. Adjust as needed.

Translation: When CorrResp is "Old", move accuracy to "Hits" column. When CorrResp is "New", move accuracy to "CR" column.

_____________________________

ds$Hit[ds$CorrResp=="Old"] <-ds$ACC[ds$CorrResp=="Old"]
ds$CR[ds$CorrResp=="New"] <-ds$ACC[ds$CorrResp=="New"]

_____________________________