How do I extract certain data from a table? (2024)

Thanks for the help. Unfortunately, when using the code, I received following error message:

Error using categorical (line 277) Conversion from table not supported. Extract data from one or more table variables into an array using dot or brace subscripting. Then convert the array to a categorical array.

Any further ideas?

I'd figured that TMW would've gotten that limitation removed by now... :(

It's the array syntax trying to shorten the multiple variables into a vectorized form, sorry.

Use

for each variable in the table or a loop with indexing for a column at a time with the curly braces indexing on the RHS to return the underlying data in each rather than the table that is the result of "regular" parentheses addressing.

Now it's working. Your last comment was the key. Thank you

No problem; glad to help. It takes some time to learn the nuances of what is/isn't allowable inside the table object but overall it's pretty handy for many things. Be sure to read the doc on the categorical data type as well; there are as noted earlier some other facilities with it that can be very helpful depending on just what you want to do with the data. Grouping is one possibility that comes to mind...

thanks a ton. i was struggling with the same issue as well

T(:,1:3)=categorical(T(:,1:3)); % where T is your table variable

when I am trying this is says "Conversion from table not supported. Extract data from one or more table variables into an array using dot or brace subscripting. Then convert the array to a categorical array."

Huh. Surprised nobody else had noticed..."air code" (meaning just typed in at the prompt, not tested) tends to have such oversights. The expression needs the curlies ("{}") instead of parentheses to return the base array when using subscript indexing into a table.

T.name for a column variable does return the variable as its storage type; it's easy to forget that the array indexing form returns the table section referred to instead. It's consistent wit MATLAB syntax; just easy to forget/overlook.

That code is overwriting all of data each iteration.

It looks to me as if data will not be a vector, but I do not seem to be able to locate any hellopatches() function so I cannot tell what shape it will be. As you are not doing imresize() I also cannot be sure that all of the images are the same size, so I cannot be sure that data will be the same size for each iteration. Under the circ*mstances you should be considering saving into a cell array.

Note: please do not post the same query multiple times. I found at least 10 copies of your query :(