i have excel sheet 31 coulmn,, the first coulmn is time and in the other coulmns the signals names , what i need from the code is that at spefic time to tell me for examplk

1 ビュー (過去 30 日間)
i have excel sheet 31 coulmn,, the first coulmn is time and in the other coulmns the signals names , what i need from the code is that at spefic time to tell me for example how many ones are there and which samples of the 31 are the one at that time , how to that ?
  4 件のコメント
Hagar Hendy
Hagar Hendy 2022 年 12 月 7 日
i get that table from another program , and i know the at which time the signal is one, so acording to that , i am choosing that spesfic time, , my concerns is how to know that this signal is one , not only the counting , i want to know the signal name that is 1 out of the 30

サインインしてコメントする。

採用された回答

Walter Roberson
Walter Roberson 2022 年 12 月 7 日
編集済み: Walter Roberson 2022 年 12 月 7 日
Given a particular scalar row index (calculated from the time, perhaps):
VarNames = YourTable.Properties.VariableNames;
ValuesAtIndex = YourTable{RowIndex, 2:end};
match_columns = 1 + find(ValuesAtIndex == 1);
matched_signal_names = VarNames(match_columns);
matched_signal_names will be a cell array of character vectors. It will be empty if there are no matches, and might have multiple entries if there are multiple matches.
  3 件のコメント
Peter Perkins
Peter Perkins 2022 年 12 月 12 日
In recent versions, if time is involved, use readtimetable. Then use time subscripting on the timetable, and beyond that, I can't tell what the question is.

サインインしてコメントする。

その他の回答 (0 件)

製品


リリース

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by