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

10 visualizaciones (últimos 30 días)
Changhyun Kim
Changhyun Kim el 2 de En. de 2022
Respondida: KSSV el 2 de En. de 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.

Respuesta aceptada

KSSV
KSSV el 2 de En. de 2022
T = readtable('data.xlsx') ;
T = table2array(T) ;
T = T' ;
T = T(:) ;
plot(T)

Más respuestas (1)

Matt J
Matt J el 2 de En. de 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 comentario
Changhyun Kim
Changhyun Kim el 2 de En. de 2022
NOPE...Since it is a ground acceleration value, it must be arranged in order.

Iniciar sesión para comentar.

Community Treasure Hunt

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

Start Hunting!

Translated by