title: new field in dataset using pandas
body: <p>I am trying to transition from using SAS to Python, which I am enjoying.  I found a nice SQL to Pandas guide which helped a lot, but there's a couple of things I do in SAS that I'm not certain how to do in Pandas:</p>
  
  <pre><code>/*  looks at variable within a dataset and assigns it to high, med, low */
  
  data scores;
  
  set scores;
  
  if score_value &gt;= 80 then score_cat = "high";
  
  else if score_value &gt;= 50 then score_cat = "med";
  
  else score_cat = "low";
  
  run;
  
  
  
  /*  looks at the value of a particular variable and deletes the record */
  
  data people;
  
  set people;
  
  if trim(name)="" then delete;
  
  run;
  </code></pre>
  
  <p>I'm sure this is pretty easy to do, but I'm just not seeing it at the moment.  T</p>
  
  <p>Thanks!
  JT</p>