Extract data based on the name and month from the table
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Mohammad Sami
am 26 Jan. 2020
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.
Akzeptierte Antwort
Image Analyst
am 26 Jan. 2020
Bearbeitet: Image Analyst
am 26 Jan. 2020
Try ismember() or contains().
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!