Extracting data into different variables

4 views (last 30 days)
Wei Jun Yap
Wei Jun Yap on 22 Nov 2022
Edited: dpb on 23 Nov 2022
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?

Answers (2)

dpb
dpb on 22 Nov 2022
"...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 Comments
dpb
dpb on 23 Nov 2022
Edited: dpb on 23 Nov 2022
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.

Sign in to comment.


MisterQuax
MisterQuax on 22 Nov 2022
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)

Products

Community Treasure Hunt

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

Start Hunting!

Translated by