How to level data of an excel file using Matlab

3 次查看（过去 30 天）

Supriya Gain 2022-5-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1709150-how-to-level-data-of-an-excel-file-using-matlab

评论： Voss 2022-5-2

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

Voss 2022-5-2

Thank you for the information.

Voss 2022-5-2

Comment from @Supriya Gain on my (deleted due to changing requirements) answer moved here:

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.

请先登录，再进行评论。

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