Preprocessing Data from Excel

3 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

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
Bhavick Singh
Bhavick Singh on 3 Jun 2021
Hello, thanks for the reply. Is there any code for Curvilinear component analysis?

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!