Azzera filtri
Azzera filtri

Extracting values from a cell then converting to a matrix

1 visualizzazione (ultimi 30 giorni)
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 Commento
WILLBES BANDA
WILLBES BANDA il 31 Mag 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 .

Accedi per commentare.

Risposta accettata

madhan ravi
madhan ravi il 31 Mag 2020
Modificato: madhan ravi il 31 Mag 2020
A([1,2],:) = [];
A(:,1) = [];
Mat = cell2mat(A)
  3 Commenti
WILLBES BANDA
WILLBES BANDA il 31 Mag 2020
Modificato: Stephen23 il 31 Mag 2020
Works perfectly. Thank you once more honorable!

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Data Type Conversion in Help Center e File Exchange

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by