MATLAB Answers

Extracting data from excel spreadsheet based on shared dates

조회 수: 1(최근 30일)
Wendy Cameron
Wendy Cameron 2021년 2월 20일
댓글: Wendy Cameron 2021년 2월 28일
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.
  댓글 수: 1
Wendy Cameron
Wendy Cameron 2021년 2월 22일
Actually this is easily done using the lookup function in excel but I just wondered if Matlab had a similar function.

댓글을 달려면 로그인하십시오.

답변(1개)

Jemima Pulipati
Jemima Pulipati 2021년 2월 25일
Hello,
From my understanding, you can use the following functions to read and write data from the excel files.
The readtable() function creates a table by reading columns from any of the supported file formats.
The writetable() function is used to write data to any of the mentioned supported file formats.
  댓글 수: 1
Wendy Cameron
Wendy Cameron 2021년 2월 28일
Thanks for this response but it hasn't really answered the question. I have used excel instead, but just wondered if Matlab had a similar LOOKUP function as excel.
Kind regards, Wendy

댓글을 달려면 로그인하십시오.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by