title: Fill DataFrame row values based on another dataframe row's values pandas
body: <p>DataFrame1:</p>
  
  <pre><code>Device  MedDescription  Quantity
  
  RWCLD   Acetaminophen (TYLENOL) 325 mg Tab  54
  RWCLD   Ampicillin Inj (AMPICILLIN) 2 g Each    13
  RWCLD   Betamethasone Inj *5mL* (CELESTONE SOLUSPAN) 30 mg (5 mL) Each  2
  RWCLD   Calcium Carbonate Chew (500mg) (TUMS) 200 mg Tab    17
  RWCLD   Carboprost Inj *1mL* (HEMABATE) 250 mcg (1 mL) Each 5
  RWCLD   Chlorhexidine Gluc Liq *UD* (PERIDEX/PERIOGARD) 0.12 % (15 mL) Each 5
  </code></pre>
  
  <p>Data Frame2: </p>
  
  <pre><code>Device  DrwSubDrwPkt    MedDescription  BrandName   MedID   PISAlternateID  CurrentQuantity Min Max StandardStock   ActiveOrders    DaysUnused
  
  RWC-LD  RWC-LD_MAIN Drw 1-Pkt 12    Mag/AlOH/Smc 200-200-20/5 *UD* (MYLANTA/MAALOX) (30 mL) Each    MYLANTA/MAALOX  A03518  27593   7   4   10  N   Y   3
  RWC-LD  RWC-LD_MAIN Drw 1-Pkt 20    ceFAZolin in Dextrose(ISO-OS) (ANCEF/KEFZOL) 1 g (50 mL) Each   ANCEF/KEFZOL    A00984  17124   6   5   8   N   N   2
  RWC-LD  RWC-LD_MAIN Drw 1-Pkt 22    Clindamycin Phosphate/D5W (CLEOCIN) 900 mg (50 mL) IV Premix    CLEOCIN A02419  19050   7   6   8   N   N   2
  </code></pre>
  
  <p>What I want to do is append DataFrame2 values to Data Frame 1 ONLY if the 'MedDescription' matches. When it find the match, I would like to add only certain columns from dataFrame2[Min,Max,Days Unused] which are all integers</p>
  
  <p>I had an iterative solution where I access the dataframe 1 object 1 row at a time and then check for a match with dataframe 2, once found I append the column numbers from there to the original dataFrame.</p>
  
  <p>Is there a better way? It is making my computer slow to a crawl as I have thousands upon thousands of rows.</p>