[算表] 計算不特定的文字出現的頻率
軟體: EXCEL
版本: 2013
==============
請問,若我要將一段文字(英文)中每個單字所出現的頻率分別計算出來的話,
該怎麼使用excel實現這項功能?
網路上找到的方法皆是針對某特定已知的字去做加總。
有發現一個網站可以實現我想要的功能,所以我想excel應該也可以
但我花了點時間嘗試還沒有頭緒。
以下舉例,若我想將:
PM Benjamin Netanyahu described Mr Sharon as "one of the greatest military
commanders Israel has had".
Mr Sharon, regarded by many Israelis as a great warrior and statesmen but
widely loathed in the Arab world, died on Saturday aged 85 after eight years
in a coma.
Mr Sharon will be buried later at the family ranch in the Negev desert.
Thousands of mourners paid their final respects on Sunday, when Mr Sharon's
coffin lay in state outside parliament.
US Vice-President Joe Biden is among some 20 foreign delegates attending
Monday's service at Israel's parliament - the Knesset.
'Living military legend'
Delivering the first speech at the memorial, President Shimon Peres said Mr
Sharon was a "living military legend" who also always dreamed of peace for
Israel.
這段文章統計出最常出現的字,這個網站
http://www.wordcounter.net/
可以做到我想要的事情,統計出 sharon 這個字出現5次、military出現3次等。
請各位幫忙,感謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.116.71.141
→
01/13 18:21, , 1F
01/13 18:21, 1F
→
01/14 16:07, , 2F
01/14 16:07, 2F