Actually this is easily done using the lookup function in excel but I just wondered if Matlab had a similar function.
Extracting data from excel spreadsheet based on shared dates
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have two spreadsheets. One has the dates for a given plant phenological event. The other has the appropriate weather data for the year related to those dates.
I want to extract the data from the weather spreadsheet for the correspoding dates and add to the plant data sheet. I have attached sample data with an example colour highlighted of where the extracted data should end up.
I've tried some "ismatch" stuff but can't see a way forward. I'm sure it should be easy but I'm not making much progress.
Kindest regards.
Réponses (1)
Jemima Pulipati
le 25 Fév 2021
Hello,
From my understanding, you can use the following functions to read and write data from the excel files.
Voir également
Catégories
En savoir plus sur Spreadsheets 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!