How to filter two columns of a table in MATLAB, determine the average and count the data in the columns
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Jana Sarran
el 23 de Mzo. de 2023
Editada: Cris LaPierre
el 28 de Mzo. de 2023
I would like to filter for Vehtype = 650 and their respective Travel Time (Trav). After which, I would like to extract all the filter data and determine the average Travel Time (Trav.) for this vehicle type. I would also like to count the number of vehicles under this vehicle type (Vehtype = 650).
1 comentario
Dyuman Joshi
el 23 de Mzo. de 2023
What have you tried yet? Please show your code.
And please attach your code using the paperclip button, so it is easy for us to provide suggestions or solutions.
Respuesta aceptada
Cris LaPierre
el 23 de Mzo. de 2023
Editada: Cris LaPierre
el 28 de Mzo. de 2023
Use groupsummary
If you have shared your data instead of a screenshot, we could test the settings, but you probably want something like this.
mnTbl = groupsummary(Tbl,"Vehtype","mean","Trav")
This will give you the groupcount and mean travel time for each vehicle type. From there, you can extract the info for the specific vehicle type you are interested in. See the Access Data in Tables page for more on how to do that.
Más respuestas (0)
Ver también
Categorías
Más información sobre Logical 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!