Extracting data from excel spreadsheet based on shared dates

Question

0 个投票

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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.

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question

Answer 1

Jemima Pulipati 2021-2-25

0 个投票

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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

请先登录，再进行评论。

Extracting data from excel spreadsheet based on shared dates

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

回答（1 个）

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

类别

标签

Community Treasure Hunt

Extracting data from excel spreadsheet based on shared dates

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

回答（1 个）

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

类别

标签

另请参阅

Community Treasure Hunt

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论