Extracting values from a cell then converting to a matrix

1 vue (au cours des 30 derniers jours)
WILLBES BANDA
WILLBES BANDA le 31 Mai 2020
Modifié(e) : Stephen23 le 31 Mai 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 commentaire
WILLBES BANDA
WILLBES BANDA le 31 Mai 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 .

Connectez-vous pour commenter.

Réponse acceptée

madhan ravi
madhan ravi le 31 Mai 2020
Modifié(e) : madhan ravi le 31 Mai 2020
A([1,2],:) = [];
A(:,1) = [];
Mat = cell2mat(A)
  3 commentaires
madhan ravi
madhan ravi le 31 Mai 2020
Use
format longg % at the beginning
WILLBES BANDA
WILLBES BANDA le 31 Mai 2020
Modifié(e) : Stephen23 le 31 Mai 2020
Works perfectly. Thank you once more honorable!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Data Type Conversion dans Help Center et File Exchange

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by