Extract data based on the name and month from the table
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Mohammad Sami
le 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.
Réponse acceptée
Image Analyst
le 26 Jan 2020
Modifié(e) : Image Analyst
le 26 Jan 2020
Try ismember() or contains().
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!