Replacing Data by variable name
显示 更早的评论
Hi All
I have two data set as below
A =
Name subName Type Output Q1 Q2 Q3 Q4
x y xy Person 3 4 5 6
a b ab Animal 2 3 4 5
m n mn Bird 1 2 3 4
s t st None 9 9 9 9
x y NA All 1 1 1 1
B =
Name subName Type Output Q2 Q3
x y xy Person -1 -1
m n mn Bird -2 -2
and I want to replace A's value for given qtrs in B repalced with A so that my new set is
C =
Name subName Type Output Q1 Q2 Q3 Q4
x y xy Person 3 -1 -1 6
a b ab Animal 2 3 4 5
m n mn Bird 1 -2 -2 4
s t st None 9 9 9 9
x y NA All 1 1 1 1
I tried using replacedata with variable names but it gives me error.
I am using Matlab 2013b
3 个评论
Neesha
2014-6-12
looks like text not coming out well, here is an image
Azzi Abdelmalek
2014-6-12
编辑：Azzi Abdelmalek
2014-6-12
What are the classes of your data, cell or dataset?
Neesha
2014-6-12
采纳的回答
Azzi Abdelmalek
2014-6-13
If your array is not a cell array, use dataset2cell to convert it
a={ 'Name' 'subName' 'Type' 'Output' 'Q1' 'Q2' 'Q3' 'Q4'
'x' 'y' 'xy' 'Person' [ 3] [ 4] [ 5] [ 6]
'a' 'b' 'ab' 'Animal' [ 2] [ 3] [ 4] [ 5]
'm' 'n' 'mn' 'Bird' [ 1] [ 2] [ 3] [ 4]
's' 't' 'st' 'None' [ 9] [ 9] [ 9] [ 9]
'x' 'y' 'NA' 'All' [ 1] [ 1] [ 1] [ 1]}
b={'Name' 'subName' 'Type' 'Output' 'Q2' 'Q3'
'x' 'y' 'xy' 'Person' [-1] [-1]
'm' 'n' 'mn' 'Bird' [-2] [-2]}
name1=a(1,5:end)
name2=b(1,5:end)
text_a=a(2:end,1:4)
text_b=b(2:end,1:4)
idx_text=find(all(ismember(text_a,text_b),2))+1
idx_names=find(ismember(name1,name2))+4
c=a
c(idx_text,idx_names)=b(2:end,5:end)
更多回答（1 个）
Image Analyst
2014-6-12
0 个投票
Do you have R2013b or later? If so, just use a table.
4 个评论
Neesha
2014-6-12
Neesha
2014-6-12
Image Analyst
2014-6-12
Did you use
tableA = readtable(ExcelFileName);
to read the Excel file into a table (a wonderful new data type started with R2013b)? Please attach the workbook if you want people to try things.
First you need to identify which rows need to get replaced. You do that with ismember(). Then it's straightforward and I think would go something like this ( very untested and just off the top of my head )
for currentRow = 1 : length(tableB.Q2)
% Find rows in A that need to be replaced.
rowsToReplace = ismember(tableB.name(currentRow), tableA.name);
% Replace all the rows in A that need replacing with the value from B.
for rowsInA = find(rowsToReplace)
tableA.Q2(rowsInA) = tableB.Q2(currentRow);
tableA.Q3(rowsInA) = tableB.Q3(currentRow);
end
end
You should also check subname.
Neesha
2014-6-12
类别
在 帮助中心 和 File Exchange 中查找有关 Calendar 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
