Sorry if this is a stupid question or has been asked before, but I'm new to programming and this is what's holding me back from successfully making my first Prophet forecasts.
So basically, I imported data from an API into Excel, tried all sorts of combinations but every time I save it as .csv and try to load it into R, instead of properly getting "ds" and "y" columns it bugs out and I get a column named "d'.żds". Because of this I cannot make a forecast - columns need to be labelled correctly.
Here is how it should look like (example provided by prophet) - https://imgur.com/a/jC2q1dE
Here are the screenshots of all of my attempts, before and after converting to .csv:
When I try to make a forecast on these I get an error message: "Error in fit.prophet(m, df, ...) : Dataframe must have columns 'ds' and 'y' with dates and values respectively
Can someone please help me fix this?
Thanks a lot!