How can I filter an entire row using a date?

1 view (last 30 days)
Taine Ryan
Taine Ryan on 17 May 2022
Answered: KSSV on 17 May 2022
I have a 37200x22 table that basically has columns for the data about the weather in different weather stations, such as temperature and the name of each weather station. It also has rows for every day of December in 2007 in different cities and provinces. One column has the date in the format 'yyyy-mm-dd' and I am required to find the average temperature for a certain day of December.
Is there a specific way to find data in a table using just a date from one column?

Answers (1)

KSSV
KSSV on 17 May 2022
You have varities of cunction to do that. Cnvert the required datetime column into class datetime. This class has the information of day, month, year. From this you can extract your required value.
Also have a look on retime

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!