long time lurker, first time poster. I've recently been digging into time-series analysis and, for my master thesis one of the steps is to use an ARIMA model to be able to forecast short-term taxi demand. I'll give some context so I apologize in advance if it's too long.
I've built a clean database in MySQL with all the needed variables and extracted data and, after a spatiotemporal exploratory analysis of the case study, I'm now ready to start predicting/forecasting. I've been watching tutorial after tutorial and reading a lot in how properly use an ARIMA model but sadly, my journey stops even before reaching that point.
It's no secret that often R has some issues with table columns that aren't read as "dates" when they should. In my case, I exported a small sample to a .csv that has only 2 columns: 337 Days of 2016 (the remaining were not considered due to low counts) and taxi trips that occurred in each of those days.
When I analyze the structure of the date column i get:
str(Ano2016$DatasTaxis) Factor w/ 337 levels "1/1/2016","1/10/2016",..: 1 12 23 26 27 28 29 30 31 2 ...
So in order to convert it to a time-series, my guess is that I'll need to first convert these factors to dates. I've tried converting to Posix using anytime but it started filling some rows with "NA" and it keeps being Factor with levels
 "POSIXct" "POSIXt"
Factor w/ 337 levels "1/1/2016","1/10/2016",..: 1 12 23 26 27 28 29 30 31 2 ...
I've tried using as.Date() as well and even stipulate the format, to no avail.
I've tried to convert to char as you can see first but I'm starting to feel a little frustrated.
If it helps, the data wasn't directly from MySQL. I went from MySQL to Tableau (data visualization software) to filter the year and count the observations.
Thanks in advance, my next step will be buying online courses, I guess...