i need to convert data from hourly data to daily data and plot these data

1 view (last 30 days)
hassan elkholy
hassan elkholy on 26 Sep 2020
Answered: Peter O on 26 Sep 2020
i have hourly data in an excel sheet for a year and these data per hour but i need to plot it per day, how to do this please
these data until 8/25/2020

Sign in to answer this question.

Answers (1)

Peter O
Peter O on 26 Sep 2020
  1. Import using a timetable. https://www.mathworks.com/help/matlab/timetables.html
  2. Decide how you want to decimate the data in column C. Does it make sense to take the average of the day? Or to only use the data at 8:00 am from each day? https://www.mathworks.com/help/matlab/matlab_prog/resample-and-aggregate-data-in-timetable.html
  3. Use either plot(mytimetable.MyTimes, mytimetable.MyVariable), or stackedplot(mytimetable) to get the plot.

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!