{"id":2682,"date":"2022-10-24T00:14:20","date_gmt":"2022-10-24T00:14:20","guid":{"rendered":"http:\/\/optimumsportsperformance.com\/blog\/?p=2682"},"modified":"2022-10-24T12:54:10","modified_gmt":"2022-10-24T12:54:10","slug":"tidyx-episode-121-cleaning-research-data-for-analysis-viewer-question-answered","status":"publish","type":"post","link":"https:\/\/optimumsportsperformance.com\/blog\/tidyx-episode-121-cleaning-research-data-for-analysis-viewer-question-answered\/","title":{"rendered":"TidyX Episode 121: Cleaning Research Data for Analysis &#8211; Viewer Question Answered"},"content":{"rendered":"<p>This week, <span style=\"color: #0000ff;\"><strong><a style=\"color: #0000ff;\" href=\"https:\/\/twitter.com\/ellis_hughes\">Ellis Hughes<\/a><\/strong><\/span> and I work on cleaning some data for a research who messaged us asking about how to get a data set in a format that he can analyze. He created a file of some fake data that resembled the data that he received from practitioners working in various treatment centers. The data was in a very wide format, serial measurements going horizontally with one row per patient. To analyze such data the researcher required the data to be in a long format. However, this was trickier than just doing a simple <strong>pivot_longer()<\/strong> because there were multiple columns requiring pivoting. Ellis and I cover two different approaches to handling this issue, both resulting in the same final data set.<\/p>\n<p>To watch the screen cast, <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.youtube.com\/watch?v=RvV6aL5RD4U\">CLICK HERE<\/a><\/span><\/strong>.<\/p>\n<p>To access the data and our code, <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/github.com\/thebioengineer\/TidyX\/tree\/master\/TidyTuesday_Explained\/121-tell_me_what_you_want\">CLICK HERE<\/a><\/span><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This week, Ellis Hughes and I work on cleaning some data for a research who messaged us asking about how to get a data set in a format that he can analyze. He created a file of some fake data that resembled the data that he received from practitioners working in various treatment centers. The [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[],"class_list":["post-2682","post","type-post","status-publish","format-standard","hentry","category-tidyx-screen-cast"],"_links":{"self":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/comments?post=2682"}],"version-history":[{"count":1,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2682\/revisions"}],"predecessor-version":[{"id":2683,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2682\/revisions\/2683"}],"wp:attachment":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/media?parent=2682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/categories?post=2682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/tags?post=2682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}