Combining excel files with unequal rows
1 次查看(过去 30 天)
显示 更早的评论
I have two excel files which I would like to combine into a single file. The data is as follows
:![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1664521/image.jpeg)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1664521/image.jpeg)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1664526/image.jpeg)
I would like to combine these two tables into a single table with the columns "Name" "Date" "Value 1" "Value2" where the occassion of John 04-05-2011 shows a value for Value 1 but remains empty for Value 2.
0 个评论
采纳的回答
Dyuman Joshi
2024-4-9
编辑:Dyuman Joshi
2024-4-9
%Data from the images attached for example
%Use readtable() to read the data as tables directly
Name = ["Adam" "Adam" "John" "John" "John" "Karen"].';
Date = datetime(2010, [11 12 11 12 5 5], [5 6 5 6 4 4]).';
Value1 = [12 16 8 3 14 12].';
t1 = table(Name, Date, Value1)
Name = ["Adam" "Adam" "John" "John" "Karen"].';
Date = datetime(2010, [11 12 11 12 5], [5 6 5 6 4]).';
Value2 = [8 6 1 3 8].';
t2 = table(Name, Date, Value2)
%join tables
out = outerjoin(t1, t2, 'Keys', [1 2])
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!