This query returns the following table:
SELECT * FROM tfidf_output1 ORDER BY tf_idf DESC;
docid | term | tf | idf | tf_idf |
---|---|---|---|---|
5 | series | 0.0727272727272727 | 1.6094379124341 | 0.117050029995207 |
5 | ashes | 0.0545454545454545 | 1.6094379124341 | 0.0877875224964055 |
5 | england | 0.0545454545454545 | 1.6094379124341 | 0.0877875224964055 |
5 | five | 0.0545454545454545 | 1.6094379124341 | 0.0877875224964055 |
1 | were | 0.0465116279069767 | 1.6094379124341 | 0.0748575773225163 |
1 | chennai | 0.0465116279069767 | 1.6094379124341 | 0.0748575773225163 |
3 | nadal | 0.0447761194029851 | 1.6094379124341 | 0.0720643841388403 |
4 | viewers | 0.037037037037037 | 1.6094379124341 | 0.0596088115716333 |
4 | world | 0.037037037037037 | 1.6094379124341 | 0.0596088115716333 |
4 | cricket | 0.037037037037037 | 1.6094379124341 | 0.0596088115716333 |
4 | one | 0.037037037037037 | 1.6094379124341 | 0.0596088115716333 |
5 | tests | 0.0363636363636364 | 1.6094379124341 | 0.0585250149976036 |
5 | australia | 0.0363636363636364 | 1.6094379124341 | 0.0585250149976036 |
5 | 32 | 0.0363636363636364 | 1.6094379124341 | 0.0585250149976036 |
3 | they | 0.0298507462686567 | 1.6094379124341 | 0.0480429227592269 |
3 | many | 0.0298507462686567 | 1.6094379124341 | 0.0480429227592269 |
2 | australian | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | 10 | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | mutiple | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | 1981 | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | inside | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | born | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | frenchopen | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | on | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | continuously | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | player | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | usopen | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | ranked | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | 8 | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | titles | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
2 | 2002 | 0.0285714285714286 | 1.6094379124341 | 0.04598394035526 |
... | ... | ... | ... | ... |