Import values from excel to use it as content

13 vues (au cours des 30 derniers jours)
Alfredo Scigliani
Alfredo Scigliani le 11 Mar 2022
I know that this may sound complicated, but I will give it a shot anyway. I using the import data feature to pull data from an excel sheet. In this excel sheet I have 3 sets of results with 7 data points each. (Test 1, 2 and 3) the result can be either A B or C. In matlab I have a value for A B and C for each section. What I need help doing is to use the content of the cell and imput it in the matlab code.
I have been converting the excel data into three column vectors with categorical variables. One vector is the T1 column, the other is T2 and then T3. So for example if my first value of T1 column vector is A, I would like to write in matlab: result_T1_1=T1(1) and if A is = 3, then result_T1_1 would be equal to 3.
What I am not sure is if I shouls import the excel content as text or as categorical variables or as tables... there are many options with which I am not really familiar with.
This is how my excel looks like.
I auto generate the section of the code that imports data from excel:
This is the code I have been using:
clear; clc;
%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
% Workbook: C:\Users\alfre\Desktop\Book1.2.xlsx
% Worksheet: Sheet1
%
% Auto-generated by MATLAB on 11-Mar-2022 13:51:57
%% Setup the Import Options and import the data
opts = spreadsheetImportOptions("NumVariables", 3);
% Specify sheet and range
opts.Sheet = "Sheet1";
opts.DataRange = "C3:E9";
% Specify column names and types
opts.VariableNames = ["T1", "T2", "T3"];
opts.VariableTypes = ["categorical", "categorical", "categorical"];
% Specify variable properties
opts = setvaropts(opts, ["T1", "T2", "T3"], "EmptyFieldRule", "auto");
% Import the data
tbl = readtable("C:\Users\alfre\Desktop\Book1.2.xlsx", opts, "UseExcel", false);
%% Convert to output type
T1 = tbl.T1;
T2 = tbl.T2;
T3 = tbl.T3;
%% Clear temporary variables
clear opts tbl
%A C and C values for test 1
A=5;
B=10;
C=20;
result_T1_1=T1(1)
result_T1_2=T1(2)
result_T1_3=T1(3)
result_T1_4=T1(4)
result_T1_5=T1(5)
result_T1_6=T1(6)
result_T1_7=T1(7)
%A B and C values for test 2
A=8;
B=15;
C=25;
result_T2_1=T2(1)
result_T2_2=T2(2)
result_T2_3=T2(3)
result_T2_4=T2(4)
result_T2_5=T2(5)
result_T2_6=T2(6)
result_T2_7=T2(7)
%A B and C values for test 2
A=3;
B=12;
C=19;
result_T3_1=T3(1)
result_T3_2=T3(2)
result_T3_3=T3(3)
result_T3_4=T3(4)
result_T3_5=T3(5)
result_T3_6=T3(6)
__________________________________________________________
Now this is the output:
result_T1_1 =
categorical
A
result_T1_2 =
categorical
A
result_T1_3 =
categorical
B
result_T1_4 =
categorical
A
result_T1_5 =
categorical
C
result_T1_6 =
categorical
B
result_T1_7 =
categorical
C
result_T2_1 =
categorical
A
result_T2_2 =
categorical
A
result_T2_3 =
categorical
A
result_T2_4 =
categorical
B
result_T2_5 =
categorical
C
result_T2_6 =
categorical
C
result_T2_7 =
categorical
C
result_T3_1 =
categorical
A
result_T3_2 =
categorical
B
result_T3_3 =
categorical
A
result_T3_4 =
categorical
B
result_T3_5 =
categorical
C
result_T3_6 =
categorical
C
result_T3_7 =
categorical
C
>>
_____________________________________________________________________
Now the desired output I would want it to be :
result_T2_1= 5
result_T2_2= 5
result_T2_3= 10
result_T2_4= 5
result_T2_5= 20
result_T2_6= 10
result_T2_7= 20
and so on...

Réponse acceptée

Peter Perkins
Peter Perkins le 14 Mar 2022
You can index into a vector of your numic values with a categorical:
>> opts = detectImportOptions("Book1.2.xlsx")
>> opts.VariableTypes = ["double" "categorical" "categorical" "categorical"];
>> t = readtable("Book1.2.xlsx",opts)
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
t =
7×4 table
Test_ T1 T2 T3
_____ __ __ __
1 A A A
2 A A B
3 B A A
4 A B B
5 C C C
6 B C C
7 C C C
>> values1 = [5; 10; 20];
>> values1(t.T1)
ans =
5
5
10
5
20
10
20

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Produits


Version

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by