Day1 of using Matlab I have managed to pull in data from an outside vendor that is organized like this
Data1 = 1×5 cell array {50×2 table} {50×2 table} {50×2 table} {50×2 table} {50×2 table}
Each 50x2 table has a date column first followed by a price column "S" is a 1x5 cell containing the source name of each price
How do I combine this into a single table that includes the date and appropriate name and reads left to right Date|Name1|Name2|Name3|Name4|Name5
Thanks

답변 (2개)

Star Strider
Star Strider 2018년 11월 9일

0 개 추천

One option is vertcat (link), another is join (link).

댓글 수: 2

Guillaume
Guillaume 2018년 11월 9일
I think join is more likely to be what the OP is after or even possibly outerjoin.
Another option would be to convert to timetable with table2timetable then synchronize.
@Guillaume — Thank you!

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

Peter Perkins
Peter Perkins 2018년 11월 15일

0 개 추천

If there's really only 5, just rename the variables and horzcat, and I guess also leave out the date var from all but one. I guess maybe S is a separate cell array containing the names of each price? So use that to modify the var names. But your description is not at all clear.

카테고리

도움말 센터 및 File Exchange에서 Tables에 대해 자세히 알아보기

제품

릴리스

R2018b

질문:

2018년 11월 9일

답변:

2018년 11월 15일

Community Treasure Hunt

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

Start Hunting!

Translated by