writing the count of items from dataframe to a cell in an excel sheet

Asked Sep 20 '17 at 14:55

Active Sep 20 '17 at 15:26

Viewed 27 times

I have a dataframe as

df=pd.DataFrame(list(v.items()),columns=["Associate","Dailycount"])

where v=r.value_counts() -v is the count of each associate

r=pd.Series(Associates) -r is the series of names of associates

Output of df is-

Associate | Dailycount
----------------------
Associate1 | 14
Associate2 | 5
Associate3 | 31
Associate4 | 4

Now, I want to write the count of each Associate to an excel sheet which is in a format as-

| Date____ | Associate1 | Associate2 | Associate3 | Associate4
-----------------------------------------------
9/19/2017  | 3_________ | 20________ | 16________ | 4__________|
9/20/2017  |___________ | _____________ | ____________ | ____________|

Columns of the excel sheet are- Date, associate1, associate2 and so on

I want to write the count of each associate in the cell which is at a particular date(say 9/20/2017) How can I write it into the excel?

edited Sep 20 '17 at 15:26

asked Sep 20 '17 at 14:55

user8635794

And what is your question? – Jan Zeiseweis Sep 20 '17 at 15:01
A sample data would be lot better. – Bharath M Shetty Sep 20 '17 at 15:09
@user8635794 please add this in your question with a bit of formatting. – Bharath M Shetty Sep 20 '17 at 15:14
And what did you try to do this? What part is not working? – Jan Zeiseweis Sep 20 '17 at 15:14
@Bharathshetty added it – user8635794 Sep 20 '17 at 15:27
@JanZeiseweis I want to write the count of each associate in the cell which is at a particular date(say 9/20/2017) How can I write it into the excel? – user8635794 Sep 20 '17 at 15:28
You can read the existing excel file into a dataframe, add your new data and then overwrite the existing file: https://stackoverflow.com/questions/20219254/how-to-write-to-an-existing-excel-file-without-overwriting-data-using-pandas – Jan Zeiseweis Sep 20 '17 at 15:31
@JanZeiseweis could you write me the code for adding data and overwriting the file – user8635794 Sep 21 '17 at 17:20

writing the count of items from dataframe to a cell in an excel sheet

0 Answers0