{"id":2027,"date":"2021-06-21T04:40:00","date_gmt":"2021-06-21T04:40:00","guid":{"rendered":"http:\/\/optimumsportsperformance.com\/blog\/?p=2027"},"modified":"2021-06-21T16:02:19","modified_gmt":"2021-06-21T16:02:19","slug":"tidyx-64-cleaning-ugly-excel-data-part-1","status":"publish","type":"post","link":"https:\/\/optimumsportsperformance.com\/blog\/tidyx-64-cleaning-ugly-excel-data-part-1\/","title":{"rendered":"TidyX 64: Cleaning ugly excel data, Part 1"},"content":{"rendered":"<p>Continuing on with the <em>data cleaning <\/em>theme of our previous 3 episodes, <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/twitter.com\/ellis_hughes\">Ellis Hughes<\/a><\/span><\/strong> and I work through messy excel data that was simulated to look like something we&#8217;d see in practice.<\/p>\n<p>We decided to take turns with this, to show how both of us might handle the problem. This week is my approach to handling the issue and next week will be Ellis approach.<\/p>\n<p>Things that we cover:<\/p>\n<ol>\n<li>Reading in excel files to R, selecting the tabs to read data from, and setting the data types<\/li>\n<li>Turning messy data in a data frame that can be analyzed<\/li>\n<li>Writing a <strong><em>for<\/em><\/strong> <em><strong>loop<\/strong><\/em> to operationalize the approach over a larger excel file, with many tabs<\/li>\n<\/ol>\n<p>To access our code, <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/github.com\/thebioengineer\/TidyX\/tree\/master\/TidyTuesday_Explained\/064-Data_Cleaning_Excel_Files_1\">CLICK HERE<\/a><\/span><\/strong>.<\/p>\n<p>To watch the screen cast, <strong><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.youtube.com\/watch?v=R8LK1SNH9p0\">CLICK HERE<\/a><\/span><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Continuing on with the data cleaning theme of our previous 3 episodes, Ellis Hughes and I work through messy excel data that was simulated to look like something we&#8217;d see in practice. We decided to take turns with this, to show how both of us might handle the problem. This week is my approach to [&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-2027","post","type-post","status-publish","format-standard","hentry","category-tidyx-screen-cast"],"_links":{"self":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2027","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=2027"}],"version-history":[{"count":1,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2027\/revisions"}],"predecessor-version":[{"id":2028,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/posts\/2027\/revisions\/2028"}],"wp:attachment":[{"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/media?parent=2027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/categories?post=2027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimumsportsperformance.com\/blog\/wp-json\/wp\/v2\/tags?post=2027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}