Copy data for one table to another

12 次查看（过去 30 天）
Juan Martinez
Juan Martinez 2018-7-29
编辑： Stephen23 2018-7-30
Hi all, i am working with tables and i have one problem. I have one table:
This table have unique sort index values (1,2,3...) and the values in second column that i want copy.
The other table that i want to paste the values with his index is:
The result would be:
How i can make this? I am trying to have some indexing such as:
if true
B.coefic = [B A(B,2)];
end
But wrong results.
Thank you very much!

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

采纳的回答

Stephen23
Stephen23 2018-7-30
编辑：Stephen23 2018-7-30
[~,idx] = ismember(B.Fecha,A.Fecha);
B.coeff = A.values1(idx)
Or
B = A(idx,:)
https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html
Demonstrated using numeric arrays:
>> A = [1,2,3,4,5,6,7;15,12,18,11,19,10,14].'
A =
1 15
2 12
3 18
4 11
5 19
6 10
7 14
>> B = [1,1,1,2,2,3,3,3,4,5,5,6,7].'
B =
1
1
1
2
2
3
3
3
4
5
5
6
7
>> [~,idx] = ismember(B,A(:,1));
>> A(idx,:)
ans =
1 15
1 15
1 15
2 12
2 12
3 18
3 18
3 18
4 11
5 19
5 19
6 10
7 14

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2015b

Community Treasure Hunt

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

Start Hunting!

Translated by