Extracting common-date data from different excel dates in separate excel workbooks

1 次查看（过去 30 天）

显示更早的评论

b 2014-11-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/162642-extracting-common-date-data-from-different-excel-dates-in-separate-excel-workbooks

评论： Geoff Hayes 2014-11-14

Hello,

I have 2 excel workbooks with the following date-data:

Workbook1:

Date Data

11/14/2014 1.1

11/13/2014 1.2

11/12/2014 1.3

Workbook2:

11/14/2014 2.1

11/12/2014 2.2

11/11/2014 2.3

The problem is to extract and plot only the data of the two series corresponding to the common dates. In the above simple example, it will be to plot date vs data for the 1st and 3rd rows of workbook1 (since there is no data for 11/13/2014 in workbook2); and 'hold on', and on the same figure, plot date vs data for the 1st and 2nd rows of workbook2 (since there is no data for 11/11/2014 in workbook1). The plot will contain two date-points on the x-axis (11/14/2014 and 11/12/2014) and two data series - Workbook1Data (1.1 and 1.3) and Workbook2Data (2.1 and 2.2). How to achieve this in MATLAB?

Thanks.

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

Geoff Hayes 2014-11-14

Have you been able to read in the two sets of data with xlsread? Start with that and then consider how you might merge the two data sets together for those with common dates.

请先登录，再进行评论。

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