title: pandas: Create new column by comparing DataFrame rows with columns of another DataFrame
body: <p>Assume I have <code>df1</code>:</p>
  <pre><code>df1= pd.DataFrame({'alligator_apple': range(1, 11),
                    'barbadine': range(11, 21),
                    'capulin_cherry': range(21, 31)})
  
     alligator_apple  barbadine  capulin_cherry
  0                1         11              21
  1                2         12              22
  2                3         13              23
  3                4         14              24
  4                5         15              25
  5                6         16              26
  6                7         17              27
  7                8         18              28
  8                9         19              29
  9               10         20              30
  </code></pre>
  <p>And a <code>df2</code>:</p>
  <pre><code>df2= pd.DataFrame({'alligator_apple': [6, 7, 15, 5],
                    'barbadine': [3, 19, 25, 12],
                    'capulin_cherry': [1, 9, 15, 27]})
  
     alligator_apple  barbadine  capulin_cherry
  0                6          3               1
  1                7         19               9
  2               15         25              15
  3                5         12              27
  </code></pre>
  <p>I'm looking for a way to create a new column in <code>df2</code> that gets number of rows based on a condition where all columns in <code>df1</code> has values greater than their counterparts in <code>df2</code> for each row. For example:</p>
  <pre><code>   alligator_apple  barbadine  capulin_cherry  greater
  0                6          3               1       4
  1                7         19               9       1
  2               15         25              15       0
  3                5         12              27       3
  </code></pre>
  <p>To elaborate, at row 0 of <code>df2</code>, <code>df1.alligator_apple</code> has  4 rows which values are higher than <code>df2.alligator_apple</code> with the value of 6. <code>df1.barbadine</code> has 10 rows which values are higher than <code>df2.barbadine</code> with value of 3, while similarly <code>df1.capulin_cherry</code> has 10 rows.</p>
  <p>Finally, apply an 'and' condition to all aforementioned conditions to get the number '4' of <code>df2.greater</code> of first row. Repeat for the rest of rows in <code>df2</code>.</p>
  <p>Is there a simple way to do this?</p>