How to separate features and target (numeric values) in a tabular text datastore to import into Deep Network Design?

8 次查看(过去 30 天)
Hello everyone, I have the following problem: I imported a csv file with numerical data containing the features and the target into a tabular text datastore, however, to import into Deep Network Design this tabular text datastore needs to contain separate features and target. I have no idea how to do this, can someone give me a hand?
For example, my csv file has 500 rows 10 features and the target.
Thank you very much!

回答(1 个)

yanqi liu
yanqi liu 2021-12-3
yes,sir,may be choose the data to X and Y,such as
% 500 rows 10 features and the target.
X = Data(:, 1:10); % 10 features
Y = Data(:, end); % target
may be upload some data mat to do analysis
  4 个评论
paulo silva
paulo silva 2021-12-4
编辑:paulo silva 2021-12-8
Hi Yanqi, thanks again for your help and proactivity. But after many tests and analysis of the structure of a tabular test datastore, I found a way that solves the issue and separates the 10 features from the target:
dsTrain = tabularTextDatastore("datasetrain.csv");
preview(dsTrain)
dsnewTrain = transform(dsTrain, @(x) [cellfun(@transpose, mat2cell(x{:,1:10},ones(1,500)),'UniformOutput',false), mat2cell(x{:,11},ones(1,500))])
preview(dsnewTrain)
dsValid = tabularTextDatastore("datasevalid.csv");
preview(dsValid)
dsnewValid = transform(dsValid, @(x) [cellfun(@transpose, mat2cell(x{:,1:10},ones(1,250)),'UniformOutput',false), mat2cell(x{:,11},ones(1,250))])
preview(dsnewValid)
dsTest = tabularTextDatastore("datasettest.csv");
preview(dsTest)
dsnewTest = transform(dsTest, @(x) [cellfun(@transpose, mat2cell(x{:,1:10},ones(1,250)),'UniformOutput',false), mat2cell(x{:,11},ones(1,250))])
preview(dsnewTest)
Again, thank you very much for your help and for those who have the same problem as me, this solution solves it simply. :)

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Image Data Workflows 的更多信息

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by