Extract data based on the name and month from the table

Question

BN 2020-1-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502016-extract-data-based-on-the-name-and-month-from-the-table

编辑： BN 2020-1-26

stations.mat

Hey, all,

I have a table (25560 x 12). I want to extract data from it based on the names (from station_name column) and month names (from date column). I want to save all results on the workspace as separate tables.

for example I want to save these in my workplace:

Ahvaz_Jan

Ahvaz_Feb

Ahvaz_Mar

...

Ahvaz_Dec

then next station_name:

Abadan_Jan

Abadan_Feb

Abadan_Mar

...

Abadan_Dec

Then the next station and so on ... the year doesn't matter, I only care about name of stations and month.

I don't know how to start doing that. Can anyone help me? I attached my file.

2 个评论
显示无隐藏无

Mohammad Sami 2020-1-26

Can I ask why do you want to create separate variables for each station / month combination ? If you want to further process the data later, it will just make it more complicated.

BN 2020-1-26

In fact in the water resources engineering when we want to use climate stations data always we have some missing values in each station that should estimate and fill using linear regression from the nearest station. Please consider station A and station B which they are near together and we have their monthly precipitation data from 1989 to 2018 that containing missing values. To fill missing values in the month, we should use linear regression for each month between A and B and use the equation (for example A = 2B-2.3) to fill missing values in station A (12 regressions for each station). Now I have 71 stations that with your kindly help in the previous question I found the nearest stations. Now I want to conduct linear regression between them and then fill missing values.

请先登录，再进行评论。

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