Cut radio signal by hours

3 views (last 30 days)
Shahar ben ezra
Shahar ben ezra on 11 Nov 2020
Commented: Shahar ben ezra on 21 Nov 2020
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

Accepted Answer

Walter Roberson
Walter Roberson on 11 Nov 2020
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 Comments
Peter Perkins
Peter Perkins on 20 Nov 2020
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 on 21 Nov 2020
Tnx Peter Perkins :)
I will try that too

Sign in to comment.

More Answers (0)

Categories

Find more on Line Plots in Help Center and File Exchange

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!