title: Combining two series in the same dataframe into a single series
body: <p>I have a dataframe:</p>
  <pre><code>import pandas as pd
  
  data = {'Name': ['car', 'car', 'truck', 'car'],
          'SysNum': [1, 2, 3, 4 ]
              }
  
  df = pd.DataFrame(data)
  </code></pre>
  <p>The output looks like:</p>
  <pre><code>    Name    SysNum
  0   car     1
  1   car     2
  2   truck   3
  3   car     4
  </code></pre>
  <p>I want to be able to loop over this data frame and create a third column that combines the two columns together and look like:</p>
  <pre><code>    Name    SysNum  Count
  0   car     1       car1
  1   car     2       car2
  2   truck   3       truck3
  3   car     4       car4
  </code></pre>
  <p>The loop is much longer than this but I am struggling to create a decent loop that results in this third column.  So say there are 50 cars I need the loop to be the length of 50 and combine each row together.</p>