Extracting data from excel spreadsheet based on shared dates

Question

Wendy Cameron 2021-2-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/750959-extracting-data-from-excel-spreadsheet-based-on-shared-dates

评论： 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 个评论
显示 -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.

请先登录，再进行评论。

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

Answer 1

Jemima Pulipati 2021-2-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/750959-extracting-data-from-excel-spreadsheet-based-on-shared-dates#answer_633299

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

请先登录，再进行评论。