How to filter rows from excel in matlab
11 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi, I am working on a project and I need this small help. I am currently observing the average speed for cars during weekdays and weekends. Now I have an excel sheet and imported all of the data as column vectors, observation number, time, date, day of the week, average speed of a car, that sort of thing. Now here is where I am stuck. I need to classify or lets say filter all the observations as either weekday or weekend refer to the screenshot for how the excel looks like. so how can I classify the observation as a weekday or weekend
0 comentarios
Respuestas (1)
Star Strider
el 2 de Mayo de 2024
Editada: Star Strider
el 2 de Mayo de 2024
There are two principal options.
D = '12 May 2024';
[Dnum,Dnam] = weekday(D)
D = datetime([2024 05 12])
Dnam = day(D, 'name')
Dnam = day(D, 'shortname')
Dnum = day(D,'dayofweek')
You can then use the day numbers to classify the days as either weekdays (2 to 6) or weekends (7 or 1).
.
EDIT — Corrected typographical errors.
2 comentarios
Star Strider
el 2 de Mayo de 2024
Editada: Star Strider
el 2 de Mayo de 2024
It would help to have the file.
Since there is aready a ‘DayOf Week’ column (that I didn’t see before, since that image is vanishingly small), one option (where ‘Table’ is the name for the table created by reading the file, change that as necessary) could be:
Table.DayOfWeek = {'Sunday'; 'Monday';'Tuesday';'Friday';'Saturday'};
daytypes = ismember(Table.DayOfWeek, {'Saturday','Sunday'})
Weekends = table(Table.DayOfWeek, daytypes, 'VariableNames',{'DayOfWeek','WeekendDay'})
This returns ‘true’ (or 1) for days that are weekends and 'false' (or 0) for weekdays. You can use that to create your categories.
.
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!