frequency of words in excel sheet using Python

Asked Nov 25 '19 at 09:03

Active Dec 20 '21 at 13:51

Viewed 26 times

I'm trying to count the frequency of each word in an excel sheet which is structured as bellow,

and expecting the output to be like this

```f=pd.read_excel('test.xlsx', header=None)
f.columns = ["id","information"]
f['count']=1
f.groupby(['id']).count()
f.to_excel('output.xlsx')```

edited Dec 20 '21 at 13:51

Ismael Padilla

asked Nov 25 '19 at 09:03

Black Snow

1

check second answer. – jezrael Nov 25 '19 at 09:04
1

which answer please? jezrael – Black Snow Nov 25 '19 at 10:16
1

https://stackoverflow.com/a/32801170/2901002 – jezrael Nov 25 '19 at 10:17
sir i want find the frequency of each word means, if there is 5 (goes) it should print 5 or if there is 5 (goes) print in the first (goes) 5? any solution – Black Snow Nov 25 '19 at 10:33

0 Answers0