How to level data of an excel file using Matlab
조회 수: 2 (최근 30일)
이전 댓글 표시
I have an excel files which contains file names like:[oil_1%_water_2%],[oil_2%_water_4%],[oil_6%_water_1%],... And it's a column matrix data. Now I have to give a certain leveling. For example if water percentage is higher than oil then level it as 1. And if Oil percentage is higher then level the data as -1. And output excel file should be looks like, like:[oil_1%_water_2%,1],[oil_2%_water_4%,1],[oil_6%_water_1%,-1],..... Can anyone please tell me how to do that using MATLAB.
댓글 수: 4
Voss
2022년 5월 2일
Also I'm changing my question a bit. If the water percentage is greater than 1% then mark that sample as -1 and if the oil percentage is greater than 2%, then mark that sample as -1. Other than that mark sample as 1. If any one of the component crosses their threshold then that samplee is bad and mark them as -1.
For better clarity I'm attaching one Input sample file and one expected output file.
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!