ワードクラウド

手順

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エンコーディング チャンネルに適用し、個々の単語の数に基づいて集計します。

ワードクラウドは次のようになります。

クリックして拡大します

クラウド内の単語のサイズは、相対的な頻度を表します。