How to normalize data set in MATLAB. If it is csv file .

4 次查看（过去 30 天）
tejasvee
tejasvee 2017-4-26
回答： temeraire007 2024-2-11
I want to train my Extreme Learning Machine. but data set should be normalized between -1 to 1.My data set is csv file.i want to know how to normalize csv file.I read the question asked by others but it didn't work.please help.
  1 个评论
Jan
Jan 2017-4-26
"It didn't work" is not a useful description of your problems. Please post your code and post a complete copy of the error message. How could we suggest an improvement, when we have to guess, what the problem is?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Jan
Jan 2017-4-26
编辑：Jan 2017-4-26
You cannot normalize a file. You have to import the data at first, most likely by csvread or readtable. Then the normalization should be exactly as shown in many otehr threads:
Data = rand(10, 20); % Test data, use your data instead
minData = min(Data(:));
maxData = max(Data(:));
scaled = (Data - minData) / (maxData - minData); % Scaled to [0, 1]
scaled = scaled * 2 - 1; % Scaled to [-1, 1]
  6 个评论
显示 4更早的评论
Chris
Chris 2023-8-11
This doesn't work. It says Error using " / " Arguments must be numeric, char or logical. Even though the data i used is a numeric data.
Walter Roberson
Walter Roberson 2023-8-11
@Chris
It sounds as if you might have a table() object instead of a numeric array.
ExistingVars = YourTable.Properties.VariableNames;
NewTable = varfun(YourTable, @(V)rescale(V,-1,1), 'InputVariables', @isnumeric );
NewTable.Properties.Variablenames = ExistingVars;

请先登录，再进行评论。

更多回答（1 个）

temeraire007
temeraire007 2024-2-11
There are also a couple of tools you can use. I have to do this kind of data cleaning on a monthly basis as our CRM is just completely useless. The tools are not perfect by any means, but for me for large files like +5K data entries saved some time.
OpenRefine (will have to download the tool but its really powerful to automate)
DataNormalizer (Online solution, so no need to download anything, got quiet good results quickly)
TableAnalyzer (tool from Microsoft but I think only works for MicrosoftAccess)

类别

在 Help Center 和 File Exchange 中查找有关 Standard File Formats 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by