title: Put upper and lower bounds on values in DataFrame column
body: <p>I have the following column:</p>
  
  <pre><code> Column 1
   1
   10
   5
   100
   50
   1000
   50000
   2000
   100
   1000
   3000
   ...
  </code></pre>
  
  <p>I would like to assign every row in Col1 with a value >= 1000 the value 1000 in Col 2 and every value &lt;= 100 the value 100.</p>
  
  <pre><code> Column 1   Column 2
   1          100
   10         100
   5          100
   100        100
   50         100
   1000       1000
   50000      1000
   2000       1000
   100        100
   1000       1000
   3000       1000
   ...
  </code></pre>
  
  <p>How can I do this?</p>