title: How do you extract specific values from a column in one dataframe and append them to a column in another dataframe? - Pandas
body: <p>Lets say I have two dataframes in pandas. df1 and df2.</p>
  <pre class="lang-py prettyprint-override"><code>df1 = 'column1': ['a','b','c','a','c'], 'column2':[1,2,3,4,5]
  
  df2 = ['columnA', 'columnB', 'columnC'] (empty except for these column names)
  </code></pre>
  <p>I want to take all the values from column1 in df1 that equal 'a' and put them into 'columnA' of df2. Then do the same for 'b' and put them in 'columnB' and then the same for 'c' and 'columnC'.</p>
  <p>Whats the best way of doing this?</p>
  <p>I've looked all over and can only find answers for moving entire columns, not specific values like this, so any help is appreciated</p>
  <p>Thanks</p>