title: Can I multiply an entire column with a scalar in a dataframe in python?
body: <p><a href="https://i.stack.imgur.com/D6LJX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D6LJX.png" alt="enter image description here" /></a>&gt;</p>
  <blockquote>
  <pre><code>df = pd.DataFrame(pd.read_csv(&quot;SPOILER_Monster_Hunt.csv&quot;))
  df.columns = [&quot;S/No&quot;, &quot;Member_Name&quot;, &quot;L1&quot;, &quot;L2&quot;, &quot;L3&quot;, &quot;L4&quot;, &quot;L5&quot;]
  #some modifications below
  df = df.drop(index=0)
  df = df.drop(columns='S/No')
  df = df.fillna(0)
  
   #Adjusting points with monster levels
  
  df['L1'] = df['L1'] * 50
  df['L2'] = df['L2'] * 150
  df['L3'] = df['L3'] * 300
  df['L4'] = df['L4'] * 1000
  df['L5'] = df['L5'] * 2000
  
  df.head()
  # show the dataframe
  print(df)
  </code></pre>
  </blockquote>
  <blockquote>
  <p>Now the problem here is that multiplication of a column with a scaler just multiplies the value in that column to appear multiple times for instance <code>df[L1] = df[L1]*50</code> will make values of L1 repeat 50 times in the entire column but what I want is to multiply each value in that column to be multiplied by 50.</p>
  </blockquote>
  <p><a href="https://www.dropbox.com/s/kssr3zfj8ugyn5r/SPOILER_Monster_Hunt.xlsx?dl=0" rel="nofollow noreferrer">here is the link to dataset I am using</a></p>