MATLAB Answers

0

Unable to change data from row to column by using transpose

Asked by Gil Cheah on 20 Jun 2017
Latest activity Commented on by Gil Cheah on 21 Jun 2017
I imported the data from excel file, and the data is needed to run with wavelet 1-D analysis. After entering the wavemenu, it said that my data is not in 1-D dimension, so i guess that my data have to listed as column instead of row. However, I have unable to transpose the data by using A.' or A'
This is the showed on my command window "Error using ' (line 148) Undefined function 'ctranspose' for input arguments of type 'table'."
Anyone can tell me why? Thanks in advance

  0 Comments

Sign in to comment.

1 Answer

Answer by Wayne King
on 20 Jun 2017
 Accepted Answer

Is the data in your workspace in the form of a MATLAB table?
What does the >>whos
command print out in your workspace? or better yet, let's say the data is stored in your MATLAB workspace as X, what does >>class(X)
print out.

  3 Comments

yes, it is a table. I just realised that this only happens when I import data directly via 'Import Data' on the 'Home' tab. And if I typed xlsread(x), it became 'double' class which I can transpose.
But it is not convenient because through xlsread(x), some 'date' data is missing
I glad you helped
You can also extract a numeric vector from a a table() with table2array()
load patients
patients = table(LastName,Gender,Age,Height,Weight,Smoker,Systolic,Diastolic);
weight = table2array(patients(:,4)); % extract weight variable as vector
The Wavelet 1-D tool will not care if your signal is a row or column vector.
Thanks, now i can extract those information with that!

Sign in to comment.