Auto generate table input type for predictFcn exported model
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Alireza Ghaderi
le 21 Juil 2022
Réponse apportée : Alireza Ghaderi
le 11 Mai 2023
Hi
I have already read the documentaion about the methods requiervedVariable and hotToPredict of the exported model.
I also manually created the required input format for predictFcn.
My dataset is a table with lots of categorical and double data. I select a few of the columns as feature in regression lerarner app.
I am looking for an easier way to create a input data table for testing and predicting with my model after exporing. Its a little hard to each time create a table manually with the variable names and variable types.
This is my Method now:
if trained == true
load trainedModel.mat
varNames = ["BlockTime","FlightTime","dayOfYear","hourOfDay","payloadKg","totalWeightKg"];
varTypes = ["double","double","double","double","double","double"];
inT = table('Size',size(varNames),'VariableTypes',varTypes,'VariableNames',varNames);
intT(1,:) = array2table([BlockTime FlightTime dayofYear PayloadKG TotalKG]);
fuelPredict = trainedModel.predictFcn(inT)
end
but my main data has lots of other columns so I cant use that for input template
opts.Sheet = "Sheet1";
opts.DataRange = "A2:AM5115";
% Specify column names and types
opts.VariableNames = ["ACType", "ACReg", "FlightDateM", "FlightNo", "Origin", "Destination", "Airborn", "OffBlock", "TouchDown", "OnBlock", "BaggageKG", "BaggagePD", "AdultCount", "InfantCount", "ChildCount", "FlightTime", "BlockTime", "SitaFlightTime", "RemainingFuelKG", "RemainingFuelLt", "RemainingFuelPD", "UpliftFuelKG", "UpliftFuelLT", "UpliftFuelPD", "ArrFuelKG", "ArrFuelLT", "ArrFuelPD", "DiffFuelKG", "DiffFuelLT", "DiffFuelPD", "RampFuelKG", "RampFuelLT", "RampFuelPD", "SitaFuelKG", "SitaFuelLT", "SitaFuelPD", "TaxiFuelKG", "TaxiFuelLT", "TaxiFuelPD"];
opts.VariableTypes = ["categorical", "categorical", "datetime", "string", "categorical", "categorical", "datetime", "datetime", "datetime", "datetime", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double"];
1 commentaire
Siddharth Bhutiya
le 22 Juil 2022
Can you share a sample MAT file of what the initial data looks like and what you want the final table to look like ?
Réponse acceptée
Plus de réponses (0)
Voir également
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!