Preprocessing Data from Excel

Question

Bhavick Singh 2021-6-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/845025-preprocessing-data-from-excel

评论： Kunal Kandhari 2021-6-3

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mathieu NOE 2021-6-1

hello

what do you mean by "standardized " ?

请先登录，再进行评论。

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

Answer 1

Kunal Kandhari 2021-6-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/845025-preprocessing-data-from-excel#answer_714600

在 MATLAB Online 中打开

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:

https://in.mathworks.com/help/matlab/ref/readtable.html

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:

https://in.mathworks.com/help/matlab/ref/mean.html

https://in.mathworks.com/help/matlab/ref/std.html

It will standardization your dataset