Category: 3

SELECT anxiety;

rossetti@Wakatipu:~/door$ sqlite3 -column door_wordlist.db 'SELECT ratings_1.q3, articles.date, articles.title FROM articles LEFT JOIN ratings_1 ON articles.id = ratings_1.id ORDER BY ratings_1.q3 DESC LIMIT 10;'

0.800 2007-04-24 Henry Porter: Islam must condemn the chlorine bombers
0.798 2007-07-09 Australian police could get more time to hold terror s
0.780 2007-07-24 NZ climber dies in French Alps
0.779 2007-05-10 Russian writer finds being rebellious can be dangerous
0.735 2007-11-14 MacCormack: Nats stick to the script, shameless pork h
0.725 2007-05-28 Dead teenagers named
0.691 2007-08-14 Bomb Derails Train in Russia
0.688 2007-11-08 Finland mourns teen’s ‘revolution’ massacre
0.682 2007-02-03 Hundreds protest against new desalination plants in Sy
0.673 2007-10-10 Wines vie for awards

Basic conceptnet2.1 query

#!/usr/local/bin/python

import sys, os
reload(sys)

os.environ['CONCEPTNET'] = 'libs/conceptnet2.1'
sys.path.append('libs/')
sys.setdefaultencoding("latin1")

import ConceptNetDB
processor = ConceptNetDB.ConceptNetDB(None,'ConceptNet.ini')

phrase = sys.argv[1]
print  phrase

text = processor.nltools.guess_mood(phrase)
print text

$ python _test-mood.py
PC_524727138 <- for/IN good/JJ man/NN PC_902158629 <- of/IN party/NN PC_725835205 <- for/IN all/DT good/JJ men/NNS PC_502591577 <- of/IN the/DT party/NN [('disgusted', 0.4862797314730406), ('angry', 0.44568548377190498), ('sad', 0.25683556430435933), ('fearful', 0.2219426823049894), ('happy', 0.11441016214900629), ('surprised', 0.0)]