Extracting data into different variables

Question

Wei Jun Yap 2022-11-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1859933-extracting-data-into-different-variables

编辑： dpb 2022-11-23

Hey there, I am trying to export the data file i got below.

As you can see, different country has different country code. How could I extract each data of a specific country into a variable?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2022-11-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1859933-extracting-data-into-different-variables#answer_1108753

"...could I extract each data of a specific country into a variable?"

You could do that, but don't -- use grouping variables or the higher-level tools like groupsummary and work on the data in situ in a table instead. Far superior way to go at virtually anything you can imagine to do with such data; the builtin facilities are astounding when you discover they're there...

2 个评论
显示无隐藏无

Wei Jun Yap 2022-11-23

ahh alright. But in this case i'll be working backwards to assign the respective year, and country to matrices in a variable. How would you do that in this case?

dpb 2022-11-23

编辑：dpb 2022-11-23

Not sure (well, that's not right, am sure) I understand the question. Show us a small example of what you're trying to accomplish with what is available for input and desired output. Telling us the end objective besides what is seen as a step along the way is always beneficial to add context and guide the development of the path to the end objective; oftentimes there is a much straighter route to the end objective.

"... i'll be working backwards to assign the respective year, and country to matrices in a variable"

I think that's the conceptual issue here -- I'm saying most likely you don't have to (and shoudn't) be trying to assign to new variable(s) but extracting and using the given data directly from the table. You've already got it; efficiency would be to not create copies of the same thing.

请先登录，再进行评论。

Answer 2

MisterQuax 2022-11-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1859933-extracting-data-into-different-variables#answer_1108773

在 MATLAB Online 中打开

Hello,

this is one possible solution for a table I created. If you want to use A afterward, you should convert it to a number.

data(1:10,1) = "RUS"
data(10:20,1) = "ROU"
data(10:20,2) = "1"
data(1:10,2) = "2"
data(10:20,3) = "3"
data(1:10,3) = "4"
A = data(data(:,1)=="ROU",2:end)