Matlab read table of values

Question

sudo 2022-8-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1779040-matlab-read-table-of-values

编辑： sudo 2022-9-2

I have a table of data. Column 1 is a building ID #. Column 2-7 are contact names. Data is entered such that the building ID# could repeat. I'm looking to pull names from column 2-7 for each building ID #. So row 1-5 maybe building 100 and row 6 and 7, are building 101. It is unknown how many rows are duplicate building #'s. In the end, i'd like to create an output for each building # that cintains all the names from column 2-7 for each row the building # was the same. Make sense?

5 个评论
显示 3更早的评论隐藏 3更早的评论

Lei Hou 2022-8-31

在 MATLAB Online 中打开

Hi Sudo,

Does the following solution solve your problem?

>> BuildingID = [100;100;100;100;100;101;101];
>> column2 = ["A";"B";"C";"D";"E";"F";"G"];
>> t = table(BuildingID, column2, column2, column2, column2, column2, column2, 'VariableNames',{'BuildingID' 'column2' 'column3' 'column4' 'column5' 'column6' 'column7'})
t =
  7×7 table
    BuildingID    column2    column3    column4    column5    column6    column7
    __________    _______    _______    _______    _______    _______    _______
       100          "A"        "A"        "A"        "A"        "A"        "A"  
       100          "B"        "B"        "B"        "B"        "B"        "B"  
       100          "C"        "C"        "C"        "C"        "C"        "C"  
       100          "D"        "D"        "D"        "D"        "D"        "D"  
       100          "E"        "E"        "E"        "E"        "E"        "E"  
       101          "F"        "F"        "F"        "F"        "F"        "F"  
       101          "G"        "G"        "G"        "G"        "G"        "G"  
>> t(t.BuildingID==100,:)
ans =
  5×7 table
    BuildingID    column2    column3    column4    column5    column6    column7
    __________    _______    _______    _______    _______    _______    _______
       100          "A"        "A"        "A"        "A"        "A"        "A"  
       100          "B"        "B"        "B"        "B"        "B"        "B"  
       100          "C"        "C"        "C"        "C"        "C"        "C"  
       100          "D"        "D"        "D"        "D"        "D"        "D"  
       100          "E"        "E"        "E"        "E"        "E"        "E"  
>> t(t.BuildingID==101,:)
ans =
  2×7 table
    BuildingID    column2    column3    column4    column5    column6    column7
    __________    _______    _______    _______    _______    _______    _______
       101          "F"        "F"        "F"        "F"        "F"        "F"  
       101          "G"        "G"        "G"        "G"        "G"        "G"  

sudo 2022-8-31

编辑：sudo 2022-8-31

This is close. The only other item I'm wondering about is how to handle this line t(t.BuildingID==100,:) if the building ID numbers are new/unknown. So while your solution provides the output im looking for, rather than have a "hard-coded" check of each build ID how would I automate that portion? Looping through each unique buildingID.

Thanks a bunch, I think it's close.

请先登录，再进行评论。

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

Answer 1

Chunru 2022-8-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1779040-matlab-read-table-of-values#answer_1038365

编辑：Chunru 2022-8-31

在 MATLAB Online 中打开

BuildingID = [100;100;100;100;100;101;101;102];
column2 = ["A";"B";"C";"D";"E";"F";"G"; ""];
t = table(BuildingID, column2, column2, 'VariableNames',{'BuildingID' 'Name' 'column3'})
t = 8×3 table
    BuildingID    Name    column3
    __________    ____    _______

       100        "A"       "A"  
       100        "B"       "B"  
       100        "C"       "C"  
       100        "D"       "D"  
       100        "E"       "E"  
       101        "F"       "F"  
       101        "G"       "G"  
       102        ""        ""   
t.IDName = t.BuildingID+t.Name
t = 8×4 table
    BuildingID    Name    column3    IDName
    __________    ____    _______    ______

       100        "A"       "A"      "100A"
       100        "B"       "B"      "100B"
       100        "C"       "C"      "100C"
       100        "D"       "D"      "100D"
       100        "E"       "E"      "100E"
       101        "F"       "F"      "101F"
       101        "G"       "G"      "101G"
       102        ""        ""       "102" 