Combining excel files with unequal rows
显示 更早的评论
I have two excel files which I would like to combine into a single file. The data is as follows
:
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.
采纳的回答
%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])
4 个评论
Katelyn
2024-4-9
移动：Dyuman Joshi
2024-4-9
Dyuman Joshi
2024-4-9
编辑：Dyuman Joshi
2024-4-9
Katelyn
2024-4-9
Dyuman Joshi
2024-4-9
Glad to have helped!
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
