Cut radio signal by hours
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Shahar ben ezra
am 11 Nov. 2020
Kommentiert: Shahar ben ezra
am 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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/410450/image.png)
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 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 Kommentare
Peter Perkins
am 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,:);
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Line Plots finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!