title: Pandas python and excel file
body: <p>I'm trying to write on an excel the following:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;table&gt;
    &lt;tr&gt;
      &lt;td&gt;user&lt;/td&gt;&lt;td&gt;4&lt;/td&gt;&lt;td&gt;Method&lt;/td&gt;&lt;td&gt;method 1&lt;/td&gt;
    &lt;/tr&gt;  
    &lt;tr&gt;
      &lt;td&gt;&lt;/td&gt;&lt;td&gt;title&lt;/td&gt;&lt;td&gt;note&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;/td&gt;&lt;td&gt;Hangover&lt;/td&gt;&lt;td&gt;7&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;/td&gt;&lt;td&gt;...&lt;/td&gt;&lt;td&gt;...&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;user&lt;/td&gt;&lt;td&gt;4&lt;/td&gt;&lt;td&gt;Method&lt;/td&gt;&lt;td&gt;method 2&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;/td&gt;&lt;td&gt;title&lt;/td&gt;&lt;td&gt;note&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;/td&gt;&lt;td&gt;Lord of the ring&lt;/td&gt;&lt;td&gt;9&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;/td&gt;&lt;td&gt;...&lt;/td&gt;&lt;td&gt;...&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>So I did the following code:</p>
  
  <pre><code>def get_users_recommandation(users, score_mpm_user, score_mpm_unique_user):
     writer = pd.ExcelWriter('recommendation.xlsx', engine='xlsxwriter')
     for user in users:
         label = pd.DataFrame({'user' : [user], 'method' : "mpm unique"})
         label.to_excel(writer, sheet_name='Sheet1')
         recommendation = get_recommandation(score_mpm_unique_user, user)
         df_recommendation = get_data_frame_from_recommendation(recommendation)
         df_recommendation.to_excel(writer, sheet_name='Sheet1')
         label = pd.DataFrame({'user' : [user], 'method' : "mpms"})
         label.to_excel(writer, sheet_name='Sheet1')
         recommendation = get_recommandation(score_mpm_user, user)
         df_recommendation = get_data_frame_from_recommendation(recommendation)
         df_recommendation.to_excel(writer, sheet_name='Sheet1')
  </code></pre>
  
  <p>But the problem when I'm doing so is that I overwrite the previous content and the result is only the last write I did. I'm new to pandas and I don't really know how to do. Should I build an entire data frame from the 4 previous one is there some other method to append data frame at the end of the previous one.</p>