Info

此问题已关闭。请重新打开它进行编辑或回答。

您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

how do i "re attach" string columns to data columns for identification?

2 次查看（过去 30 天）

显示更早的评论

john borsellino 2013-12-19

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification

⋮

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification

关闭： MATLAB Answer Bot 2021-8-20

when i input data, matlab always separates my string data( column headers and row id's) from the data it represents...i have been able to work around this because matlab keeps everything in place and it is easy to slap them back together outside of matlab... but i am working with data brushing and graphs, the databrushing retrieves the data values but not the row id...so how do i "link' my data with its original identifiers in Matlab???

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sean de Wolski 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186164

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186164

Can you provide a small example?

此问题已关闭。

回答（1 个）

Sean de Wolski 2013-12-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#answer_118871

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#answer_118871

在 MATLAB Online 中打开

If I understand you correctly, here is a small example:

x = rand(100,1);
y = rand(100,1);
names = char(randi(100,[100 3])+50); %random names
scatter(x,y);
%Do the brushing
%
% Brush your selection and then right-click, create variable, name it
% xbrush
%
[~,idx] = ismember(xbrush,[x y],'rows'); %locate them
names(idx) %extract names

11 个评论
显示 9更早的评论隐藏 9更早的评论

john borsellino 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186183

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186183

thanks for your input sean, i believe i understand your code except the "~" in the 2nd to last line...i will give it a try...for some reason i was thinking "cell arrays" may be the answer

Sean de Wolski 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186210

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186210

在 MATLAB Online 中打开

Well the cell array could hold your strings rather than the char that I had. How do you have the strings stored now?

To convert my names to a cell, just write

names = cellstr(names)

john borsellino 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186212

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186212

so my data is made up of 12 columns, the 1st column is made up of identifiers for the values across that row. evrytime i input into matlab, it separates the numeric data from the column of row identifiers. the "data" file consists of the columns of number values and the "textdata" file consists of the row id's which are characters, like, jb001,or GABD7...iv'e been able to work around this by keeping my data in order. but now i am creating scattterplots, and brushing the graph to extract outliers on the plots...the problem is that i only get back the values and not the row identifiers that they represent...cell array didn't work because i cannot plot only parts of the cell, i have to create variables from each column, plot them, extract and id outliers...i am trying your code now...

john borsellino 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186214

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186214

sorry sean but your code is coming back unbalanced...i have 3 columns, all the same length A,B and id( column with id's) i brushed my graph and created a new variable "ans" i coded;

[~,idx]=ismember(ans,[A,B],'rows');

i got back unbalanced statement

Sean de Wolski 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186225

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186225

Don't use ans!! It's overwritten every time you do anything. Try my example first. Then change it to use idx (indices corresponding to brushed points) into your column of ids.

john borsellino 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186228

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186228

to clarify...an example of my data... column1= john001, jim5, jane09. column2=4.5, 2, 1.5. column3= 8.1,7.0, 4. i create a scatter plot from columns 2 and 3 and brush the graph. i get back values, but i need the corresponding name from column 1...i will work with your example some more...

Sean de Wolski 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186229

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186229

So data is a cell array?

Are you using R2013b by any chance?

john borsellino 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186237

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186237

nosir, its R2008b...as to previous example using 3x3 dataset--so i input the data as shown, matlab auto separates the data...1 file "data' contains numeric values in a matrix. the 2nd file, 'textdata' contains a column of "row identifiers" AND a row of column identifiers, i amnow wondering if i should remove that row of column headers...so that the id column is = to the value columns...duh

john borsellino 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186242

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186242

also the codeline, names=...came back unbalanced, when i tried you example

john borsellino 2013-12-19

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186243

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186243

iam looking into how to work with cell array data...

Sean de Wolski 2013-12-20

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186316

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110243-how-do-i-re-attach-string-columns-to-data-columns-for-identification#comment_186316