title: Transposing one column in python pandas with the simplest index possible
body: <p>I have the following data (<code>data_current</code>):</p>
  
  <pre><code>import pandas as pd
  import numpy as np
  
  data_current=pd.DataFrame({'medicine':['green tea','fried tomatoes','meditation','meditation'],'disease':['acne','hypertension', 'cancer','lupus']})
  data_current
  </code></pre>
  
  <p>What I would like to do is to transpose one of the columns, so that instead of having multiple rows with same medicine and different diseases I have one row for each medicine with several columns for diseases. It is also important to keep index as simple as possible, i.e. 0,1,2... i.e. I don't want to assign 'medicines' as index column because I will merge it on some other key. 
  So, I need to get <code>data_needed</code></p>
  
  <pre><code>data_needed=pd.DataFrame({'medicine':['green tea','fried tomatoes','meditation'],'disease_1':['acne','hypertension','cancer'], 'disease_2':['np.nan','np.nan','lupus']})
  data_needed
  </code></pre>