Cut radio signal by hours
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Shahar ben ezra
le 11 Nov 2020
Commenté : Shahar ben ezra
le 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 commentaires
Réponse acceptée
Walter Roberson
le 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 commentaires
Peter Perkins
le 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,:);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Line Plots dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!