Extracting rows associated with a month written in string form in a table

Question

Tully_N 2020-3-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/512336-extracting-rows-associated-with-a-month-written-in-string-form-in-a-table

评论： Tully_N 2020-3-27

Hi there!

I have imported a data set using readtable that has a column of months to the left of various columns of data associated each month. The column with the months in it is called 'Month' and each month in the column is written as a string ('Jan', 'Feb', 'Mar' etc.).

I am trying to find all of the rows associated with May so that I can extract and average all of the data associated with this month, (i.e. I would love an array with the rows associated with May, i.e. [4, 21, 89, 164]) however I am struggling to find a way to code this, as all of the techniques I have found don't seem to work for a table of data. I am also struggling to convert the months into a numerical form which might be easier?

Thanks for your help!