Extracting values from a cell then converting to a matrix

1 visualización (últimos 30 días)
WILLBES BANDA
WILLBES BANDA el 31 de Mayo de 2020
Editada: Stephen23 el 31 de Mayo de 2020
Hi, i have a cell array A, i want to remove column 1, row 1 and row 2 so that i am left with the other points to analyse.
A = {1x1 missing} {'Pressure'} {[ 0.0136]} {[ 0.0166]} {[ 0.0196]} {[ 0.0226]}
{'Tempera'} {[ 0.0060]} {[ 0.0074]} {[ 0.0087]} {[ 0.0100]} {[ 0.0109]}
{[ 0]} {[ 0]} {[ 0]} {[ 0]} {[ 0]} {[ 0]}
{[-0.0070]} {[-0.0095]} {[-0.0119]} {[-0.0130]} {[-0.0138]} {[-0.0140]}
{[-0.0158]} {[-0.0205]} {[-0.0251]} {[-0.0285]} {[-0.0307]} {[-0.0306]}
{[-0.0283]} {[-0.0347]} {[-0.0405]} {[-0.0455]} {[-0.0488]} {[-0.0488]}
{[-0.0442]} {[-0.0522]} {[-0.0552]} {[-0.0573]} {[-0.0588]} {[-0.0595]}
After extracting those values, i want to change them into a matrix and store them in Mat. Below is the code that i used but it gives me wrong answers. Please help.
A(:,1) = [];
A(1,:) = [];
A(1,:) = [];
CurMat = string(A);
Mat = str2double(CurSheetMat);
  1 comentario
WILLBES BANDA
WILLBES BANDA el 31 de Mayo de 2020
Thank you, it works. But when i use it for cells that include powers (eg 7.0000e-5) it rounds them off to four decimals, what do i do to store them exactly as they are without rounding off .

Iniciar sesión para comentar.

Respuesta aceptada

madhan ravi
madhan ravi el 31 de Mayo de 2020
Editada: madhan ravi el 31 de Mayo de 2020
A([1,2],:) = [];
A(:,1) = [];
Mat = cell2mat(A)
  3 comentarios
madhan ravi
madhan ravi el 31 de Mayo de 2020
Use
format longg % at the beginning
WILLBES BANDA
WILLBES BANDA el 31 de Mayo de 2020
Editada: Stephen23 el 31 de Mayo de 2020
Works perfectly. Thank you once more honorable!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by