Info
이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.
Appending data based on same dates
조회 수: 1 (최근 30일)
이전 댓글 표시
I have two long tables. The first table (A) has two columns. The first indicates a date and the second indicates a value. A sample of the table is illustrated below:
A =
06-Jun-2015 00:00:00 1
07-Jun-2015 00:00:00 6
08-Jun-2010 00:00:00 1
08-Jun-2011 00:00:00 1
09-Jun-2010 00:00:00 52
09-Jun-2011 00:00:00 1
The second table contains a sample id and dates.
B =
"ahfeog" '08-Jun-2011 06:00:00'
"ahegao" '09-Jun-2010 21:00:00'
"agejho" '07-Jun-2015 03:00:00'
"ehagoa" '06-Jun-2015 06:00:00'
"eozjmv" '06-Jun-2015 18:00:00'
Ignoring the times, I want to be able to append the two tables together based on the date. My problem is that table B is significantly larger than table A and has repeat dates. Ideally my output would look like this:
Out =
"ahfeog" '08-Jun-2011 06:00:00' 1
"ahegao" '09-Jun-2010 21:00:00' 52
"agejho" '07-Jun-2015 03:00:00' 6
"ehagoa" '06-Jun-2015 06:00:00' 1
"eozjmv" '06-Jun-2015 18:00:00' 1
Could someone help me figure out how to do this?
댓글 수: 0
답변 (2개)
Paul Shoemaker
2018년 8월 27일
Hello Lee,
You might want to convert these two tables to timetables and then combine them using various functions, such as "synchronize."
Paul Shoemaker
댓글 수: 1
이 질문은 마감되었습니다.
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!