Selecting specific values in timestamp

4 次查看（过去 30 天）
Sam
Sam 2020-3-2
回答： Sai Sri Pathuri 2020-3-5
Hello,
I have a 7000000x8 matrix. In the second column, I have the timestamp information (e.g.: 11/02/2020 14:19:34.000). My sampling frequency is 25 Hz. In the 7th column I have temperature data. The timestamp column has continuous data for 4 consequetive days. How can I select the temperature data on 12/02/2020 14:00:00.000 until 12/02/2020 15:30:00.000? Or how can I find the indices of a specific timestamp in order to retrieve the temperature data?
Thank you.

请先登录，再回答此问题。

回答（1 个）

Sai Sri Pathuri
Sai Sri Pathuri 2020-3-5
Assuming you have a
  • Table t of size 7000000x8 with column names timestamp and temperature for timestamp (2nd column) and temperatue (4th column) data respectively. You may find the indices containing the required timestamps as below
first_index = find(ismember(t.timestamp,'12/02/2020 14:00:00.000','rows'))
last_index = find(ismember(t.timestamp,'12/02/20201 5:30:00.000','rows'))
Now temperature data can be obtained from these indices
temperatureData = t.temperature(first_index:last_index)
  • Cell array c of size 7000000x8. You may find the indices containing the required timestamps as below. Note that ‘2’ is the column containing timestamp values
first_index = find(ismember(c(:,2),'12/02/2020 14:00:00.000'))
last_index = find(ismember(c(:,2),'12/02/20201 5:30:00.000'))
Now temperature data (column = ‘4’) can be obtained from these indices.
temperatureData = c(first_index:last_index,4)

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by