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!

Translated by