Preprocessing Data from Excel
조회 수: 5 (최근 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:
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!