필터 지우기
필터 지우기

Cut radio signal by hours

조회 수: 4 (최근 30일)
Shahar ben ezra
Shahar ben ezra 2020년 11월 11일
댓글: Shahar ben ezra 2020년 11월 21일
Hi
I have an excel file
I get in the file a date, hours and amplitude by frequency
How can I "cut" the hours as I wish
For example I want to get a new matrix but only between the hours of 00:00 and 12:00

채택된 답변

Walter Roberson
Walter Roberson 2020년 11월 11일
I26 = readtable(YourFileName);
mask = I26.time < hours(12);
selected_I26 = I26(mask,:);
This would extract only the entries before noon. <= if you want to include noon.
  댓글 수: 10
Peter Perkins
Peter Perkins 2020년 11월 20일
Walter's solution(s) are correct, but I recommend that for your first spreadsheet, you combine the date and time, and in the second you don't split them apart. Then turn your table into a timetable.
Recent versions of MATLAB have made importing durations more automatic, so you may or may not get durations automatically.
t = readtable("yourFile.xlsx")
t.data = t.data + t.time; % or t.data + duration(t.time)
tt = table2timetable(t(:,[1 4:end],'RowTimes',t.data);
ttMorning = tt(tt.Time.Hour <= 12,:);
Shahar ben ezra
Shahar ben ezra 2020년 11월 21일
Tnx Peter Perkins :)
I will try that too

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Line Plots에 대해 자세히 알아보기

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by