MATLAB Answers

Preprocessing Data from Excel

9 views (last 30 days)
I have Raw Data in a excel Spreadsheet. I have power, voltage and current according to time. How to I standardized the data. Please assist with steps.
Thank you
  1 Comment
Mathieu NOE
Mathieu NOE on 1 Jun 2021
hello
what do you mean by "standardized " ?

Sign in to comment.

Accepted Answer

Kunal Kandhari
Kunal Kandhari on 1 Jun 2021
Hello
You can easily do that by reading the file and calling internal Matlab functions
_______________________________________
Formula for standardization:
where
x=data,
μ=mean,
σ=standard deviatoion
Code for reading file:
T = readtable('fileName.csv','NumHeaderLines',1);
% It will load the file in variable T, and remove the headings
For reading file you can refer:
Assign variables to columns:
power= T.Var1;
voltage=T.Var2;
current=T.Var3;
time=T.Var4;
standardization data:
power=(power-mean(power))/std(power);
voltage=(voltage-mean(voltage))/std(voltage);
current=(current-mean(current))/std(current);
time=(time-mean(time))/std(time);
For mean and standard deviation you can refer:
It will standardization your dataset
  4 Comments

Sign in to comment.

More Answers (0)

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!