MATLAB: Multiply/divided two tables

hw

How would I mulyiply two tables togther. I have one table and I took two columns from the table and I want to multiply them togther. Also how would I divide as well thanks.

Best Answer

The arithmetic operators aren't defined for table or timetable arrays, in part because they often contain data for which those arithmetic operators don't really make sense.
load patients
patients = table(LastName,Gender,Age,Height,Weight,Smoker,Systolic,Diastolic);
head(patients)
ans = 8x8 table
      LastName        Gender      Age    Height    Weight    Smoker    Systolic    Diastolic
    ____________    __________    ___    ______    ______    ______    ________    _________

    {'Smith'   }    {'Male'  }    38       71       176      true        124          93    
    {'Johnson' }    {'Male'  }    43       69       163      false       109          77    
    {'Williams'}    {'Female'}    38       64       131      false       125          83    
    {'Jones'   }    {'Female'}    40       67       133      false       117          75    
    {'Brown'   }    {'Female'}    49       64       119      false       122          80    
    {'Davis'   }    {'Female'}    46       68       142      false       121          70    
    {'Miller'  }    {'Female'}    33       64       142      true        130          88    
    {'Wilson'  }    {'Male'  }    40       68       180      false       115          82
What should the variable LastName in patients2 in the example below contain? How about the variable Smoker?
%{
patients2 = 2*patients
%}
As Jon and KALYAN ACHARJYA said, you can operate on the variables in a table. One thing their posts did not show is that you don't have to store the results to a temporary variable then put them into a table. You can stick them directly back into the table.
patients.AgeNextYear = patients.Age + 1;
patients.WeightKG = patients.Weight/2.205;
patients.HeightM = patients.Height/39.37;
patients.BMI = patients.WeightKG./(patients.HeightM).^2;
% Extract just a few variables to display from patients
patients2 = patients(:, ["LastName", "Age", "AgeNextYear", "HeightM", "WeightKG", "BMI"]);
head(patients2)
ans = 8x6 table
      LastName      Age    AgeNextYear    HeightM    WeightKG     BMI  
    ____________    ___    ___________    _______    ________    ______

    {'Smith'   }    38         39         1.8034      79.819     24.542
    {'Johnson' }    43         44         1.7526      73.923     24.066
    {'Williams'}    38         39         1.6256       59.41     22.482
    {'Jones'   }    40         41         1.7018      60.317     20.827
    {'Brown'   }    49         50         1.6256      53.968     20.423
    {'Davis'   }    46         47         1.7272      64.399     21.587
    {'Miller'  }    33         34         1.6256      64.399      24.37
    {'Wilson'  }    40         41         1.7272      81.633     27.364
Related Question