title: Trying to grab data using an id in one dataframe in another seperate dataframe that do not posses the same column name
body: <p>I have two data frames</p>
  <pre><code>wizards = {player_id': [&quot;3&quot;, &quot;4&quot;, &quot;0&quot;, &quot;9&quot;],
      'name':[&quot;beal&quot;, &quot;avdija&quot;, &quot;hachimura&quot;, &quot;dinwiddie&quot;],
      'total points':}
  stat_sheet = {jersey_number': [&quot;9&quot;, &quot;9&quot; , &quot;0&quot;, &quot;3&quot;, &quot;4&quot;, &quot;0&quot;, &quot;9&quot;, &quot;9&quot;, , &quot;9&quot; , &quot;0&quot;, , &quot;3&quot;, 
  &quot;4&quot;, &quot;0&quot;, &quot;9&quot;], 'total points':[40, 20, 12, 14, 55, 67, 10, 22, 22, 5, 3, 12, 5, 1]}
  wiz_df = pd.DataFrame(wizards)
  weeklystats_df = pd.DataFrame(stat_sheet)
  </code></pre>
  <p>I need to make sure that I add up all the points for each player ex:</p>
  <p>Beal scored in total 17 points so for his section within the wiz_df it would be 17 points for his row within the wiz_df</p>
  <p>So this would need to be done for each player as the unique ID is the player_id and jersey_number</p>
  <p>I tried writing a multiple nested for loop which wouldn't work and I tried joining the tables which also did not work either. Kind of stuck on this would appreciate all the help I can get.</p>