MATLAB Answers

Unable to change data from row to column by using transpose

95 views (last 30 days)
Gil Cheah
Gil Cheah on 20 Jun 2017
Commented: 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.

Accepted Answer

Wayne King
Wayne King on 20 Jun 2017
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

Gil Cheah
Gil Cheah on 20 Jun 2017
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
Wayne King
Wayne King on 20 Jun 2017
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.
Gil Cheah
Gil Cheah on 21 Jun 2017
Thanks, now i can extract those information with that!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!