Data from excel with operators

조회 수: 3 (최근 30일)
Lepakshi Ramkiran
Lepakshi Ramkiran 2020년 5월 11일
댓글: Lepakshi Ramkiran 2020년 5월 12일
I have a excel sheet with two coloumns. One has a name other has the corresponding mass to it. I have used the correspèonding line to read it and find the position of the name. But when i am trying to fing the mass to the corresponding name as shown below it is not able to store it in the memory. In the excel i have the mass values as 1.989*10^30. this seems to affect the code as the same code works fine when the cells in the excel has just numeric values.
majbod = 'Sun';
minbod = 'Earth';
majbodin = readtable("Major_and_Minor_Bodies.xlsx","Sheet",1);
minbodin = readtable("Major_and_Minor_Bodies.xlsx","Sheet",2);
MAJORBODY = table2array(majbodin(:,"Major_Body"));
MINORBODY = table2array(minbodin(:,"Minor_Body"));
mmaj = table2array(majbodin(:,"Mass"));
mmin = table2array(minbodin(:,"Mass"));
selected_majbody = find(strcmp(MAJORBODY,majbod));
selected_minbody = find(strcmp(MINORBODY,minbod));
M = mmaj(selected_majbody);
m = mmin(selected_minbody);
disp([M ;m])
I have attached the excel file with the code. Please help me with this.
Is there a better way to write the code compared to the way which I wrote?
Thanks.

채택된 답변

Cris LaPierre
Cris LaPierre 2020년 5월 11일
편집: Cris LaPierre 2020년 5월 11일
The main issue you are having is that your numbers are not numbers, but text. If possible, update your numbers in Excel to use this notation instead: 1.989E+30
That way, the mass can be read in as a number. Otherwise, convert the text representation of the number to a number.
Is there an easier way? Yes! Use the table to your advantage. Make the object the row name, and then reference it by name.
opts = spreadsheetImportOptions("NumVariables", 2);
% Specify sheet and range
opts.Sheet = "Sheet2";
opts.DataRange = "A2";
% Specify column names and types
opts.VariableNames = ["Minor_Body", "Mass"];
opts.VariableTypes = ["categorical", "string"];
minorBodies = readtable("Major_and_Minor_Bodies.xlsx", opts,"ReadRowNames",true);
%This next line replaces the " *10^" with "e"
minorBodies.Mass=str2double(regexprep(minorBodies.Mass,['(\s*)+\*10\^'],['e']));
Now when you want to reference a mass, use the rowname.
minorBodies.Mass("Saturn")
ans = 5.6830e+26
  댓글 수: 6
Cris LaPierre
Cris LaPierre 2020년 5월 12일
It's not 0, it's 0.000e+26
1.0e+26 *
5.6830
5.6830
0.0000
The value is being hidden because the magnitude of the other values are so high. Remove the semicolon from the end of the line that assigns a value to rma to see it.
Lepakshi Ramkiran
Lepakshi Ramkiran 2020년 5월 12일
yup that was it. thanks a lot.

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

제품


릴리스

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by