R Tutorial: Data Restructuring and Correlations

Want to learn more? Take the full course at https://learn.datacamp.com/courses/longitudinal-analysis-in-r at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- This section will explore techniques that are useful for longitudinal data, data restructuring, and correlations over time. Data are often stored in wide format, where each measurement occasion is stored as a separate column with one row for each individual unit. However, analysis in R is done in long format, with the measurements stacked on top of one another and variables for time and the measurement value. The tidyr package can be used for data restructuring. The gather function is used for restructuring data from wide to long and the spread function is used for restructuring data from long to wide. You can learn more about the tidyr package in other DataCamp courses. Long to wide format is not used as often as wide to long, however, it can be useful to calculate correlations between the outcomes over time. To change from long to wide using the BodyWeight data, first, mutate creates a new variable that adds Time underscore in front of the numeric time variable. This ensures valid column names in R. Next, spread restructures the data using two arguments. The first argument is the column representing the name for the new wide columns and the second determines the values for the new columns. Finally, select reorders the time variables instead of the alphabetical default order. The resulting wide format is shown for the first three rows. Using the newly created structure from the previous example, the gather function restructures the data back to long format. The function takes the data as the first argument. The next two arguments, key and value, are the names of the new columns in the long format. The key is the name of the data columns in wide format and the value is the name for the data stored in each column. Finally, the variables to be rest