search

digital-wellbeing / pws-data

Code used to process the raw PowerWash Simulator study dataset
Creative Commons Zero v1.0 Universal
4 stars 1 forks source link

Merge telemetry and survey data #5

Closed mvuorre closed 2 years ago

mvuorre commented 2 years ago

What is the best way to merge PlayFab data with corresponding Qualtrics survey data when OxfordStudyTimeStamp is not available. See #4.

rpsychologist commented 2 years ago

(I'm just posting this to document our most recent conversation about this.)

We'll join using Timestamp_adjusted (see #5). We're left joining the Qualtrics data to the PlayFab data.

I think the only remaining question is what interval we should use for the non-equi join. Something like -10 to +30 seconds.

mvuorre commented 2 years ago

Yeah, thanks! I think we can either yolo a e.g. one-minute interval or use something like a "scree plot" to determine a good interval.

mvuorre commented 2 years ago

Done in #9