MATLAB Answers

Preprocessing Data from Excel

11 ビュー (過去 30 日間)
Bhavick Singh
Bhavick Singh 2021 年 6 月 1 日
コメント済み: 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 件のコメント
Mathieu NOE
Mathieu NOE 2021 年 6 月 1 日
hello
what do you mean by "standardized " ?

サインインしてコメントする。

採用された回答

Kunal Kandhari
Kunal Kandhari 2021 年 6 月 1 日
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 件のコメント

サインインしてコメントする。

その他の回答 (0 件)

製品


リリース

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by