title: Check if Column exceeding specific value and replace
body: <p>I use the long list of codes similar to below codes, to check data frame with multiple columns</p>
  <p>I need to check if the column has any values greater than Eg. 1000. If &gt;1000 its error value, so make it '0'</p>
  <pre><code>b=1000
  a = np.array(df['E8'].values.tolist()); df['E8'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E9'].values.tolist()); df['E9'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E10'].values.tolist()); df['E10'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E11'].values.tolist()); df['E11'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E12'].values.tolist()); df['E12'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E13'].values.tolist()); df['E13'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E20'].values.tolist()); df['E20'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E21'].values.tolist()); df['E21'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E29'].values.tolist()); df['E29'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E28'].values.tolist()); df['E28'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E30'].values.tolist()); df['E30'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E31'].values.tolist()); df['E31'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E32'].values.tolist()); df['E32'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E36'].values.tolist()); df['E36'] = np.where(a &gt; b, 0, a).tolist()
  a = np.array(df['E37'].values.tolist()); df['E37'] = np.where(a &gt; b, 0, a).tolist()
  
  </code></pre>
  <p>Is there a simple and efficient way to do it.</p>