Preprocessing Data from Excel
2 ビュー (過去 30 日間)
古いコメントを表示
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
採用された回答
Kunal Kandhari
2021 年 6 月 1 日
Hello
You can easily do that by reading the file and calling internal Matlab functions
_______________________________________
Formula for standardization:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/638605/image.png)
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
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!