Organize Data Using Cell Array of Time stamps?
3 ビュー (過去 30 日間)
古いコメントを表示
Hi, I am trying to write a program that finds a major change to a known temperature. The data provided to me is in the form of an excel spreadsheet that contains a month's worth of data. The spreadsheet has a column headings of TAG DATE T1. I need to separate this column of timestaps by day so that I can use the index to find organize the temeperatures by day.
The beginning starts like this
raw_data=importdata('filename');
time_stamps=(raw_data.textdata(2:end,10));
new_time=datestr(time_stamps)
I want to use some variety of the find function to look for specific phrases in each timestamp eg. (1/20/2009)
time_stamps is a 43885x1 cell with terms that look like this '1/20/2009 7:00'
new_time is a string that I thought would help but actually seems less helpful.
Any ideas? Thanks
0 件のコメント
回答 (1 件)
Iain
2013 年 5 月 21 日
index = find(strcmpi(desired_date,time_stamps));
2 件のコメント
Iain
2013 年 5 月 21 日
For strcmpi to work, you need to ensure that the date you search for is an EXACT match to an entire string - this would, by necessity, include the time.
I would suggest that you consider changing the dates to serial date numbers via "datenum", you can then use
serials = datenum(time_stamps);
index = find(serials > datenum(desired_date),1)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!