This query below returns the following table:
SELECT * FROM tfidf_output2 ORDER BY tf_idf DESC;
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 |