Output - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

This query below returns the following table:

SELECT * FROM tfidf_output2 ORDER BY tf_idf DESC;
TF_IDF Example 2 Output Table
docid term tf idf tf_idf
7 with 0.0625 1.6094379124341 0.100589869527131
8 five 0.0434782608695652 1.6094379124341 0.0699755614101783
8 they 0.0434782608695652 1.6094379124341 0.0699755614101783
8 years 0.0434782608695652 1.6094379124341 0.0699755614101783
8 world 0.0434782608695652 1.6094379124341 0.0699755614101783
8 nadal 0.0434782608695652 1.6094379124341 0.0699755614101783
6 floods 0.04 1.6094379124341 0.064377516497364
6 chennai 0.04 1.6094379124341 0.064377516497364
6 india 0.04 1.6094379124341 0.064377516497364
6 their 0.04 1.6094379124341 0.064377516497364
6 roads 0.04 1.6094379124341 0.064377516497364
7 nadal 0.03125 1.6094379124341 0.0502949347635656
7 rafael 0.03125 1.6094379124341 0.0502949347635656
7 india 0.03125 1.6094379124341 0.0502949347635656
8 federer 0.0434782608695652 0.916290731874155 0.0398387274727894
7 federer 0.03125 0.916290731874155 0.0286340853710673
7 roger 0.03125 0.916290731874155 0.0286340853710673
7 tennis 0.03125 0.916290731874155 0.0286340853710673
7 rivalry 0.03125 0.916290731874155 0.0286340853710673
8 to 0.0434782608695652 0.510825623765991 0.0222098097289561
6 have 0.04 0.510825623765991 0.0204330249506396
6 of 0.08 0.22314355131421 0.0178514841051368
7 to 0.03125 0.510825623765991 0.0159633007426872
7 a 0.03125 0.510825623765991 0.0159633007426872
7 in 0.0625 0.22314355131421 0.0139464719571381
8 has 0.0434782608695652 0.22314355131421 0.00970189353540043
6 in 0.04 0.22314355131421 0.00892574205256839
6 the 0.04 0 0
7 the 0.03125 0 0
6 and 0.08 0 0
7 and 0.03125 0 0
8 and 0.0434782608695652 0 0
8 the 0.0434782608695652 0 0