词云

步骤

1. 将以下聚合管道粘贴到图表生成器顶部的Query栏中：

   [
     {
       $addFields: {
         words: {
           $map: {
             input: { $split: ['$description', ' '] },
             as: 'str',
             in: {
               $trim: {
                 input: { $toLower: ['$$str'] },
                 chars: " ,|(){}-<>.;"
               }
             }
           }
         }
       }
     },
     { $unwind: '$words' },
     {
       $match: {
         words: {
           $nin: ["", "also", "i", "me", "my", "myself", "we", "us",
                  "our", "ours", "ourselves", "you", "your", "yours",
                  "yourself", "yourselves", "he", "him", "his",
                  "himself", "she", "her", "hers", "herself", "it",
                  "its", "itself", "they", "them", "their", "theirs",
                  "themselves", "what", "which", "who", "whom", "whose",
                  "this", "that", "these", "those", "am", "is", "are",
                  "was", "were", "be", "been", "being", "have", "has",
                  "had", "having", "do", "does", "did", "doing", "will",
                  "would", "should", "can", "could", "ought", "i'm",
                  "you're", "he's", "she's", "it's", "we're", "they're",
                  "i've", "you've", "we've", "they've", "i'd", "you'd",
                  "he'd", "she'd", "we'd", "they'd", "i'll", "you'll",
                  "he'll", "she'll", "we'll", "they'll", "isn't",
                  "aren't", "wasn't", "weren't", "hasn't", "haven't",
                  "hadn't", "doesn't", "don't", "didn't", "won't",
                  "wouldn't", "shan't", "shouldn't", "can't", "cannot",
                  "couldn't", "mustn't", "let's", "that's", "who's",
                  "what's", "here's", "there's", "when's", "where's",
                  "why's", "how's", "a", "an", "the", "and", "but",
                  "if", "or", "because", "as", "until", "while", "of",
                  "at", "by", "for", "with", "about", "against",
                  "between", "into", "through", "during", "before",
                  "after", "above", "below", "to", "from", "up", "upon",
                  "down", "in", "out", "on", "off", "over", "under",
                  "again", "further", "then", "once", "here", "there", "when",
                  "where", "why", "how", "all", "any", "both", "each",
                  "few", "more", "most", "other", "some", "such", "no",
                  "nor", "not", "only", "own", "same", "so", "than",
                  "too", "very", "say", "says", "said", "shall"]
         }
       }
     }
   ]

2. 单击Apply以执行管道。

   现在我们有一个包含每条评论中的各个单词的字段，我们可以在词云中可视化这些单词。

3. 将新创建的words字段应用于Text渠道，将每个单词添加到词云中。

4. 应用限制为 80 以仅显示评论中最常见的 80 个单词。

5. 将words字段应用于Size渠道，并根据每个单词的计数进行聚合。

您的文字云应如下所示：

点击放大

云中词语的大小代表了它们的相对频率。