Pandas python and excel file

Question

I'm trying to write on an excel the following:

<table>
  <tr>
    <td>user</td><td>4</td><td>Method</td><td>method 1</td>
  </tr>  
  <tr>
    <td></td><td>title</td><td>note</td>
  </tr>
  <tr>
    <td></td><td>Hangover</td><td>7</td>
  </tr>
  <tr>
    <td></td><td>...</td><td>...</td>
  </tr>
  <tr>
    <td>user</td><td>4</td><td>Method</td><td>method 2</td>
  </tr>
  <tr>
    <td></td><td>title</td><td>note</td>
  </tr>
  <tr>
    <td></td><td>Lord of the ring</td><td>9</td>
  </tr>
  <tr>
    <td></td><td>...</td><td>...</td>
  </tr>
</table>

So I did the following 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')

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.

Community · Accepted Answer · 2017-05-23 12:24:01Z

1

You can use openpyxl to modify existing excel files with pandas.

look on this example: https://stackoverflow.com/a/20221655/590335

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered May 26, 2016 at 11:45

Ophir Yoktan

8,4877 gold badges66 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shivsn · Accepted Answer · 2016-05-26 11:38:21Z

1

Hope it helps you you can append all the dataframes and then write it to excel:
data=label.append(df_recommendation)
similarly for the next two dataframes.

edited May 26, 2016 at 11:38

answered May 26, 2016 at 9:42

shivsn

7,9141 gold badge28 silver badges34 bronze badges

1 Comment

jmcnamara Over a year ago

The to_csv() method has a mode parameter but the to_excel() method doesn't.

Collectives™ on Stack Overflow

Pandas python and excel file

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related