LDATopicSummary Example 3: ShowWordWeight ('true'), ShowWordCount ('true') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

Input

SQL Call

SELECT * FROM LDATopicSummary (
  ON ldamodel PARTITION BY 1
  USING
  OutputByWord ('true')
  WordWeight ('true')
  WordCount ('true')
) AS dt ORDER BY topicid, wordweight desc;

Output

topicid word wordweight wordcount
0 wipers 0.0473832596384327 3.99849732474236
0 would 0.0363395766162982 3.04325478408759
0 switch 0.0358233149828459 2.9985998375998
0 when 0.0249627005285442 2.05919213062327
0 on 0.0248539560903985 2.04978609160819
0 recall 0.0246409921706825 2.03136540755472
0 windshield 0.0243743208776925 2.00829921098562
0 notified 0.013018595230812 1.02606600163296
0 manufacturer 0.0129851924509451 1.02317677018355
0 dealer 0.012895292750406 1.01540073947214
0 has 0.012882546189796 1.01429820357743
0 repaired 0.0128536151128524 1.0117957598376
0 under 0.0128535972733459 1.01179421677851
0 after 0.012853557971549 1.01179081730133
0 by 0.0128080265518535 1.00785249808822
0 work 0.0128035467275753 1.00746500790795
... ... ... ...