How should I extract the data

Question

Shubham Pathare 2022-2-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1649530-how-should-i-extract-the-data

回答： Seth Furman 2022-2-28

采纳的回答： Seth Furman

Sample.txt

for a=1:count_rows

if Tablename.Var1(a,1)<0 && Tablename.Var1(a+1,1)==0

c=a;

end

if Tablename.Var1(a,1)==0 && Tablename.Var1(a,1)<0

c=d;

d=a;

newvar1=['Var1',num2str(count1)];

newvar2=['var2',num2str(count1)];

newvar3=['var3',num2str(count1)];

assignin('caller',newvar1,Var1(c:d,1));

assignin('caller',newvar2,Var2(c:d,1));

assignin('caller',newvar3,Var3(c:d,1));

count1=1+count1;

end

I have text file with four columns and few values of one columns are like below and I want to create new table for each set of cells having value 0 and they should be in between positive 1 only(unlined 0). New table should also contains remaining three corresponding values.

Then I need to perform exact same operations (eg.calculating avg) on newly created table. I used the for loop but then it will be difficulat to perform futher operations on newly created varibales as they have dynamic names.

Column 1

1

0 -1st new table

1

0 -ignore

-1

0 -ignore

1

0 -Should be in 2nd new table

0 Should be in 2nd new table

1

2 个评论
显示无隐藏无

Rik 2022-2-14

Please attach an example file and post the code you have already tried.

Shubham Pathare 2022-2-14

Pleasee see the updated post

请先登录，再进行评论。

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

Answer 1

Seth Furman 2022-2-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1649530-how-should-i-extract-the-data#answer_906535

在 MATLAB Online 中打开

Read tabular text data into a table

t = readtable("https://www.mathworks.com/matlabcentral/answers/uploaded_files/894130/Sample.txt")
t = 31×4 table
Var1Var2Var3Var4____________________

     1     1.5907    42.882
   1.2     1.5937    42.963
   1.3     1.5967    43.044
   1.2     1.5997    43.124
   1.3     1.6027    43.205
   1.4     1.6057    43.286
   1.5     1.6087    43.367
   1.6     1.6117    43.448
     3     1.6147    43.529
   2.3     1.6177     43.61
   2.4     1.6207     43.69
   2.5     1.6237    43.771
   3.3     1.6267    43.852
   3.4     1.6297    43.933
     -1     3.2     1.6327    44.014
     -1       1     1.6357    44.095

Use logical indexing to extract rows that meet criteria

Array Indexing - MATLAB & Simulink (mathworks.com)

t(t.Var1 == 0, :)
ans = 13×4 table
    Var1    Var2     Var3      Var4 
    ____    ____    ______    ______

    1.3     1.6027    43.205
    1.4     1.6057    43.286
    1.5     1.6087    43.367
    1.6     1.6117    43.448
    2.5     1.6237    43.771
    3.3     1.6267    43.852
    3.4     1.6297    43.933
    1.3     1.6447    44.337
    1.4     1.6477    44.418
    1.5     1.6507    44.499
    2.3     1.6627    44.823
    2.4     1.6657    44.904
      1     1.6687    44.984