Replacing Data by variable name

Question

Neesha 2014-6-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/133985-replacing-data-by-variable-name

评论： Azzi Abdelmalek 2014-6-13

采纳的回答： Azzi Abdelmalek

在 MATLAB Online 中打开

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 个评论
显示 1更早的评论隐藏 1更早的评论

Azzi Abdelmalek 2014-6-12

编辑：Azzi Abdelmalek 2014-6-12

What are the classes of your data, cell or dataset?

Neesha 2014-6-12

Dataset

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2014-6-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/133985-replacing-data-by-variable-name#answer_140689

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Azzi Abdelmalek 2014-6-13

Neesha commented

Thanks a lot

请先登录，再进行评论。

Answer 2

Image Analyst 2014-6-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/133985-replacing-data-by-variable-name#answer_140626

Do you have R2013b or later? If so, just use a table.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Image Analyst 2014-6-12

在 MATLAB Online 中打开

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

ok, i will make sure to attach file next time.

Here is the thing, my A and B are internal to code and not in the file. Those are output from a function. So i am trying to figure to convert them into table

请先登录，再进行评论。