How to normalize data set in MATLAB. If it is csv file .
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
tejasvee
am 26 Apr. 2017
Beantwortet: temeraire007
am 11 Feb. 2024
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 Kommentar
Jan
am 26 Apr. 2017
"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?
Akzeptierte Antwort
Jan
am 26 Apr. 2017
Bearbeitet: Jan
am 26 Apr. 2017
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 Kommentare
Chris
am 11 Aug. 2023
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
am 11 Aug. 2023
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;
Weitere Antworten (1)
temeraire007
am 11 Feb. 2024
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)
0 Kommentare
Siehe auch
Kategorien
Mehr zu Standard File Formats finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!