最常用关键字的Google文档电子表格公式 [英] Google Docs spreadsheet formula for most frequent keywords

问题描述

我想知道Google文档电子表格中是否有一个公式可以识别和显示(例如，在D列中)电子表格中最常用的(关键字)词?

让我们说我有一列(第B列)中满是推文(请参见示例图像)，我想在B列中找到热门关键字并将其显示在D列中.有没有办法做到这一点? /p>

谢谢！

解决方案

要返回B列中排名前10位的单个单词及其频率，请尝试:

=ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(" ";B3:B);" ")&{"";""});"select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 10 label Col1 'Word', count(Col2) 'Frequency'";0))

I wonder if there is a formula in Google Docs Spreadsheet which could identify and display (for example in column D) the most frequent (key)words in a spreadsheet?

Let's say that I have a column (Column B) full of tweets (see example image) and I would like to find top keywords in the column B and display them in column D. Is there a way to do that?

Thank you!

解决方案

To return the top 10 individual words in column B, with their frequency, try:

=ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(" ";B3:B);" ")&{"";""});"select Col1, count(Col2) group by Col1 order by count(Col2) desc limit 10 label Col1 'Word', count(Col2) 'Frequency'";0))

这篇关于最常用关键字的Google文档电子表格公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！