Extract data based on the name and month from the table

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.

[Mohammad Sami]

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]

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.

Answer 1

[Image Analyst]

Try ismember() or contains().