How to convert 183*5 matrix data into column vector data

5 Ansichten (letzte 30 Tage)
Changhyun Kim
Changhyun Kim am 2 Jan. 2022
Beantwortet: KSSV am 2 Jan. 2022
I am wondering how to convert excel data in 183*5 matrix into column vector data.
I hope to get the general code that converts excel data in m*5 matrix as well as 183*5 into column vector data.
plz, help me and refer to the attached excel file.
Also, Since it is a ground acceleration value, it must be arranged in order.

Akzeptierte Antwort

KSSV
KSSV am 2 Jan. 2022
T = readtable('data.xlsx') ;
T = table2array(T) ;
T = T' ;
T = T(:) ;
plot(T)

Weitere Antworten (1)

Matt J
Matt J am 2 Jan. 2022
You mean like this?
x=rand(183,5);
y=x(:);
whos x y
Name Size Bytes Class Attributes x 183x5 7320 double y 915x1 7320 double
  1 Kommentar
Changhyun Kim
Changhyun Kim am 2 Jan. 2022
NOPE...Since it is a ground acceleration value, it must be arranged in order.

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by