Convert 1 min average data to hourly average data
4 ビュー (過去 30 日間)
古いコメントを表示
Hello!
I have data in the following format:
mm-dd-yy HH:MM m/s
There are some missing entries in this data, and I need to convert this to hourly average data. I have data for a whole year and doing it manually or just with for and if statements will be extremely time consuming. Could anyone please help me with this to get it done in the most efficient way?
0 件のコメント
回答 (3 件)
Walter Roberson
2017 年 2 月 28 日
If you have a new enough MATLAB, you can read the data using readtable() and convert the resulting table() object to a timetable() object which then has direct functions to group by time.
Otherwise, the easiest way to read the date and time depends on which MATLAB release you have. Also, is the file a .xls or .xlsx or a .csv ?
4 件のコメント
Walter Roberson
2017 年 7 月 17 日
I should have suggested
[num, raw] = xlsread('YourFile.xlsx', [], [], 'basic');
compared to the same thing without the 'basic' option, for R2013a.
Chad Greene
2017 年 3 月 1 日
1 件のコメント
Kanachi
2017 年 11 月 30 日
Hi,
I have the timestamp of my timeseries data for hydrophone data in datenum format. Each record is 8min duration. I would like to do 3hourly averages for my data and look at the plots. How do i got about. I have obtained the power spectrum levels using pwelch and got the corresponding frequecies too. Please advise. THANK YOU.
Ohad Zivan
2017 年 7 月 17 日
if you have a timetable (called OldData here) in matlab it should be easy enough.
NewData=retime(OldData ,'hourly','mean');
you can also define your own time steps (for example, 15 minute averages):
TimeStep=[OldData.Date(1):minutes(15):OldData.Date(end)];
NewData2=retime(OldData ,TimeStep,'mean');
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Dates and Time についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!