how to identify and read positive and negative data from excel?

8 ビュー (過去 30 日間)
Vishnuvardhan Naidu Tanga
Vishnuvardhan Naidu Tanga 2021 年 10 月 27 日
回答済み: Mathieu NOE 2021 年 10 月 27 日
Hello all,
I am trying to read excel data which has positive and negative. Is there any way to identify the data. I am currently using the following code to identify it. But is theree any other simple way because i need to analyse other data where the number of cells change. Thanks in advance.
My code:
X1 = xlsread('Abb73at100.xlsx','A1:A63');
Y1 = xlsread('Abb73at100.xlsx','B1:B63');
V = 40.020;
A1 = pi*(X1).^2;
Int1 = trapz(A1, Y1);
X2 = xlsread('Abb73at100.xlsx','A64:A130');
Y2 = xlsread('Abb73at100.xlsx','B64:B130');
A2 = pi*(X2).^2;
Int2 = trapz(A2, Y2);

採用された回答

C B
C B 2021 年 10 月 27 日
編集済み: C B 2021 年 10 月 27 日
[num data raw] = xlsread('Abb73at100.xlsx');
% get data in two columns
col_1 = num(:,1);
col_2 = num(:,2);
% get negative index by col_1<0
Neg_X = col_1(col_1<0);
Neg_Y = col_2(col_1<0);
% get positive index by col_1>=0
POS_X = col_1(col_1>=0);
POS_Y = col_2(col_1>=0);
A1 = pi*(Neg_X).^2;
Int1 = trapz(A1, Neg_Y)
Int1 = 0.5773
A2 = pi*(POS_X).^2;
Int2 = trapz(A2, POS_Y)
Int2 = 0.5789
  3 件のコメント
C B
C B 2021 年 10 月 27 日
Please take look at where 0 should be incuded.
in above code i have added it as positive number.
Vishnuvardhan Naidu Tanga
Vishnuvardhan Naidu Tanga 2021 年 10 月 27 日
Thats fine. I am considering the zero as a positive integer. Thanks once again

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

その他の回答 (1 件)

Mathieu NOE
Mathieu NOE 2021 年 10 月 27 日
Hello
try this - it also only need one call to readxls
data = xlsread('Abb73at100.xlsx');
X = data(:,1);
Y = data(:,2);
X1 = X(X<0);
X2 = X(X>=0);
Y1 = Y(X<0);
Y2 = Y(X>=0);
V = 40.020;
A1 = pi*(X1).^2;
Int1 = trapz(A1, Y1)
A2 = pi*(X2).^2;
Int2 = trapz(A2, Y2)

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by