Hi all, I am trying to reformat a column of dates in the format mm-dd-yyyy into a new column that spits out the weekday of the corresponding date, but I have been stuck for the last couple of hours. Is there any guidelines I can follow to help write the code?
Some of the code I have tried using are as follows;
mutate(daily_steps = as.Date(Date, format = "%A", abbreviate = FALSE))
This function runs, however, it is spitting out the correct weekday of the date.
The dataset I am using for my project is from this link FitBit Fitness Tracker Data | Kaggle
And the CSV file I am using is the dailySteps_merged.csv
Any tips would be greatly appreciated, thank you!