How to filter two columns of a table in MATLAB, determine the average and count the data in the columns

Question

Jana Sarran 2023-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1934335-how-to-filter-two-columns-of-a-table-in-matlab-determine-the-average-and-count-the-data-in-the-colu

编辑： Cris LaPierre 2023-3-28

Screenshot 2023-03-23 150054.jpg

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Dyuman Joshi 2023-3-23

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.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cris LaPierre 2023-3-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1934335-how-to-filter-two-columns-of-a-table-in-matlab-determine-the-average-and-count-the-data-in-the-colu#answer_1199660

编辑：Cris LaPierre 2023-3-28

在 MATLAB Online 中打开

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.