I'm trying to come up with a data structure to predict water visibility in a lake. I have some measured samples but would like to take other features into the equation.
As an example, I would like to get weather data such as rain and temperature for the past 7 days of an event. I got this data from BigQuery which seems to work fine. But sometimes it does not find data for all the past 7 days. How would I handle such a case? What would be a good way to structure my features? I thought something like:
While the last one would be the field I like to predict at some point.