In [108]:
import numpy as np
import pandas as pd
import pickle
In [109]:
genre = np.array(['tech', 'politics', 'music', 'sports'])
tech = np.array(['@microsoft', 'microsoft', 'twitter', 'nokia', 'amazon', 'amazon prime', 'amazon prime day', 'apple', 'apple watch', 'ipad', 'iphone', 'ipod', 'oracle', 'ibm', 'nintendo', 'moto g', 'google', 'google+', 'ps4', 'netflix', 't-mobile', 'windows 10'])
politics = np.array(['ukip', 'angela merkel', 'bernie sanders', 'david cameron', 'donald trump', 'trump', 'tory', 'hillary', 'joe biden', 'michelle obama', 'obama', 'rahul gandhi', 'tony blair', 'boehner', 'tsipras'])
music = np.array(['bee gees', 'beyonce', 'bob marley', 'chris brown', 'david bowie', 'katy perry', 'ed sheeran', 'foo fighters', 'janet jackson', 'lady gaga', 'michael jackson', 'ac/dc', 'the vamps', 'iron maiden', 'rolling stone', 'jay-z', 'snoop dogg', 'nirvana'])
sports = np.array(['arsenal', 'barca', 'federer', 'floyd mayweather', 'hulk hogan', 'john cena', 'kris bryant', 'randy orton', 'real madrid', 'serena', 'messi', 'david beckham', 'rousey', 'super eagles', 'kane', 'red sox', 'white sox', 'chelsea', 'james franklin', 'billy cundiff', 'cundiff', 'tiger woods'])
all_topics = np.concatenate((tech, politics, music, sports))
In [110]:
all_words = ["test1", "test2", "test3"]
df = pd.DataFrame(np.random.randn(len(all_words), len(all_topics)), index=all_words, columns=all_topics)
#df = df.set_index(all_words)
In [111]:
[all_words, df] = pickle.load(open("visualize", "r"))
In [112]:
df = pd.DataFrame(df, index=all_words, columns=all_topics)
df.columns = all_topics
In [107]:
import enchant
d = enchant.Dict("en_US")
#df[df['entrytype'].isin([0,1,2])]
df = df[df['index'].isin(d.)]
In [116]:
import copy
#new_list = copy.deepcopy(old_list)
for column in df:
#print column
X =copy.deepcopy(df[column])
X.sort_values(inplace=True, ascending=False)
print "positive", "\n", X[0:10] , "\n", "negative\n", X[14158:], "\n"
positive
feelin 5.345882
ward 5.254999
redmond 5.199063
today 5.193274
pet 5.174754
invitation 5.161221
visiting 5.153317
feeling 5.146706
love 5.138237
congratulations 5.116904
Name: @microsoft, dtype: float32
negative
car -5.183088
made -5.191580
reinstall -5.191989
says -5.201159
wasnt -5.208539
word -5.217479
installing -5.234506
intern -5.274132
aware -5.279866
suck -5.362804
Name: @microsoft, dtype: float32
positive
bad 5.411175
ward 5.381585
new 5.372876
even 5.338711
itttttt 5.335710
reminded 5.331128
ass 5.327175
followed 5.323972
ein 5.321870
im 5.315552
Name: microsoft, dtype: float32
negative
soooo -2.964589
working -2.995124
promised -3.014059
guy -3.044266
niece -3.064783
disappointed -3.075272
appointed -3.091223
prom -3.196771
work -3.284168
app -3.335596
Name: microsoft, dtype: float32
positive
roses 5.207702
even 5.142887
digits 5.093380
offer 5.072020
evening 5.069022
bluray 5.066435
try 5.059167
blu 5.058602
cents 5.058307
cause 5.035403
Name: twitter, dtype: float32
negative
worried -3.197572
rise -3.236368
something -4.890898
expect -4.974758
damnit -5.059822
mn -5.071739
say -5.075579
damn -5.078363
met -5.079883
dam -5.109533
Name: twitter, dtype: float32
positive
yup 5.315462
tru 5.264578
utter 5.237733
outs 5.231847
db 5.220281
lot 5.212006
quest 5.197208
trust 5.173803
camelot 5.166086
house 5.160829
Name: nokia, dtype: float32
negative
give -5.099292
fuck -5.105416
chunks -5.105498
trying -5.113345
fee -5.136711
try -5.163097
chunk -5.195077
bump -5.202371
feelin -5.212300
lite -5.372554
Name: nokia, dtype: float32
positive
lots 5.298298
ko 5.233451
release 5.209956
spite 5.208265
woohooo 5.204857
funny 5.145682
woo 5.139343
discounts 5.138227
ikon 5.133605
obi 5.124420
Name: amazon, dtype: float32
negative
ace -5.178627
useless -5.197587
damn -5.200196
dam -5.232920
old -5.240627
tweet -5.243147
scam -5.244841
sly -5.260660
never -5.267506
wee -5.387093
Name: amazon, dtype: float32
positive
god 5.240932
gov 5.074179
example 5.038865
ruth 5.036554
truth 5.010377
aw 4.988659
people 4.957221
eso 4.943260
government 4.923462
awesome 4.920908
Name: amazon prime, dtype: float32
negative
ailing -5.066266
retard -5.077270
senseless -5.077366
sele -5.086208
idea -5.094323
sense -5.101968
citizens -5.127744
sens -5.155794
bic -5.178302
bailing -5.226105
Name: amazon prime, dtype: float32
positive
credible 6.050903
fines 5.898808
smartest 5.759730
readinglists 5.743968
faster 5.743019
cet 5.696038
powered 5.694423
coollike 5.599736
floor 5.567826
garden 5.565459
Name: amazon prime day, dtype: float32
negative
zon -5.625334
canada -5.629611
gay -5.638691
guide -5.657112
sucking -5.659877
prof -5.671957
reap -5.683779
sues -5.751888
installing -5.755706
tossing -5.776663
Name: amazon prime day, dtype: float32
positive
changer 5.269600
tie 5.132499
comes 5.043152
ties 5.007133
activities 4.994510
anger 4.960074
fitness 4.928285
game 4.883249
hang 4.119590
fit 4.118107
Name: apple, dtype: float32
negative
guide -3.099557
healthy -3.099910
budge -3.103354
fan -3.104529
sluggish -3.116105
ian -3.117652
budget -3.126473
stack -3.128063
worser -3.139243
added -3.163760
Name: apple, dtype: float32
positive
hashtag 5.212554
witch 5.191536
rise 5.184840
tag 5.176945
car 5.169001
defence 5.167756
citing 5.159544
nov 5.128142
maine 5.118989
hazard 5.110116
Name: apple watch, dtype: float32
negative
instead -5.179555
fuck -5.185488
cover -5.189046
shit -5.190598
prop -5.204802
benefit -5.211757
mufc -5.218322
ames -5.248450
right -5.261894
pic -5.305330
Name: apple watch, dtype: float32
positive
monchurodriguez 5.328143
drink 5.281381
habit 5.248352
lots 5.223734
espnuk 5.218678
believe 5.185096
success 5.166224
lie 5.146342
dj 5.138044
aleix 5.130306
Name: ipad, dtype: float32
negative
name -3.064839
frustrating -3.064942
dunno -3.073162
cf -3.126276
kl -4.679228
want -4.706707
sav -4.830481
klavierstuk -4.917843
van -4.923017
ankursavant -4.939374
Name: ipad, dtype: float32
positive
music 5.198498
gen 5.183274
ari 5.081023
mar 5.074022
favor 5.066647
genius 5.051413
wa 5.040475
maria 5.019882
fav 5.011122
ways 5.001363
Name: iphone, dtype: float32
negative
turnup -0.241138
compton -0.242829
diff -0.247896
travers -0.250481
betraying -0.253897
casemateeurope -0.254052
joined -0.255148
buccigross -0.255637
hints -0.256736
topics -0.262974
Name: iphone, dtype: float32
positive
noticed 5.361614
ani 5.289942
action 5.279469
voice 5.251621
fav 5.233173
fb 5.221903
card 5.221605
ward 5.202167
thom 5.191490
ovi 5.188465
Name: ipod, dtype: float32
negative
wen -3.170278
create -3.172265
america -3.174472
understand -3.186790
stan -3.190656
tax -3.196439
business -3.200104
ip -3.230897
issues -3.279668
eric -3.315895
Name: ipod, dtype: float32
positive
nail 5.233403
tru 5.226134
entertainer 5.181378
extra 5.160739
thurs 5.157142
gen 5.156521
kay 5.118693
god 5.118133
show 5.104852
okay 5.098137
Name: oracle, dtype: float32
negative
tigermania -0.396446
arts -0.402663
jd -0.404149
mkr -0.409180
education -0.409978
suburbs -0.414774
raiment -0.433590
gudbadanfozzy -0.437767
juggles -0.487129
holes -0.521171
Name: oracle, dtype: float32
positive
hebden 0.418157
usopen 0.404368
prospects 0.382597
spazzed 0.382163
models 0.380346
overmars 0.374799
nationally 0.373012
nevada 0.357351
racing 0.354649
stand 0.354004
Name: ibm, dtype: float32
negative
ee -5.199903
changed -5.201390
fu -5.207202
ono -5.219400
eve -5.225735
rs -5.227053
kick -5.272228
ot -5.273497
el -5.276596
que -5.314978
Name: ibm, dtype: float32
positive
really 5.402616
self 5.370550
humans 5.366771
heading 5.359015
rts 5.317905
run 5.308343
ward 5.269192
beg 5.267828
sand 5.265716
mans 5.249745
Name: nintendo, dtype: float32
negative
meanwhile -3.028836
obsession -3.030683
grader -3.030809
midnight -3.047792
hats -3.192754
graders -3.210634
alien -3.220531
mid -3.227083
depressive -3.270542
singing -3.394725
Name: nintendo, dtype: float32
positive
ps 5.230761
apart 5.169588
owns 5.130511
beohner 5.124453
ap 5.094119
psychosix 5.090039
hos 5.080790
dow 5.066125
fok 5.065654
six 5.038782
Name: moto g, dtype: float32
negative
able -5.121206
thur -5.135765
ha -5.145751
nc -5.146914
change -5.152199
bs -5.158643
greatest -5.167898
lab -5.185675
try -5.252553
time -5.279049
Name: moto g, dtype: float32
positive
helps 5.301555
ora 5.249693
ward 5.169840
boosted 5.165599
say 5.136156
hoping 5.122574
international 5.107037
perf 5.101820
rat 5.098345
fucking 5.098018
Name: google, dtype: float32
negative
hurst -5.036354
cost -5.038952
striker -5.049324
ways -5.049919
minutes -5.060475
always -5.062242
costa -5.116981
strike -5.121003
lf -5.227695
selhurst -5.291483
Name: google, dtype: float32
positive
tiaabrown 5.297530
situation 5.297019
saw 5.287033
metal 5.225883
esm 5.215989
noticed 5.188518
shelovesmeechie 5.187265
thug 5.186045
meet 5.177263
uh 5.167554
Name: google+, dtype: float32
negative
outs -3.004180
aziq -3.007310
rihanna -3.008749
izzy -3.053479
outside -3.066581
bail -3.110059
nvm -3.208163
adam -3.254362
sen -3.277736
mn -3.280874
Name: google+, dtype: float32
positive
stand 0.285167
eye 0.279379
worship 0.279229
funny 0.273130
prospects 0.264488
beef 0.259149
faster 0.257158
overpowers 0.255989
dennisritchie 0.254043
regent 0.253500
Name: ps4, dtype: float32
negative
ha -5.117669
thats -5.118389
oo -5.136443
uc -5.144460
subway -5.147968
str -5.180723
cleared -5.194367
inning -5.202401
austin -5.208922
lol -5.240047
Name: ps4, dtype: float32
positive
tgif 5.240350
usb 5.190837
fri 5.159571
bum 5.153613
country 5.130975
wake 5.114953
ice 5.114609
bummer 5.095923
timeline 5.093370
mean 5.086732
Name: netflix, dtype: float32
negative
role -0.974887
thought -4.929684
absolute -4.986627
nowhere -4.996912
bear -5.042194
absolutely -5.074833
near -5.126899
ought -5.143094
elba -5.163990
though -5.289057
Name: netflix, dtype: float32
positive
eso 5.236067
damn 5.224580
xc 5.209830
dam 5.187328
exceptional 5.162041
fresh 5.152974
mn 5.151160
fucking 5.146687
ending 5.145381
pending 5.106995
Name: t-mobile, dtype: float32
negative
vma -0.415486
really -0.902810
heard -1.331546
sure -1.583339
yr -2.406421
labyrinth -2.451168
strangest -2.931628
saw -2.998471
worst -4.859190
watching -5.091619
Name: t-mobile, dtype: float32
positive
bless 5.029722
congratulations 5.016068
god 4.946392
trick 3.328662
ann 3.320454
syrian 3.248673
tour 3.216279
arch 3.200413
hazard 3.194962
kw 3.193454
Name: windows 10, dtype: float32
negative
johnharris -5.079409
dar -5.087560
bastard -5.114618
neck -5.117208
gchq -5.121173
working -5.142941
harris -5.148167
either -5.158817
lure -5.161943
kat -5.174830
Name: windows 10, dtype: float32
positive
jim 5.279547
jimmy 5.216252
ji 5.157933
baby 5.125063
boy 5.048810
got 5.039234
fallon 5.023729
ticket 4.060144
tickets 4.052736
see 4.010524
Name: ukip, dtype: float32
negative
equal -4.948007
racial -4.987289
active -4.988860
inequality -4.995649
toxic -5.002235
masculinity -5.004462
feminism -5.090726
equality -5.101974
xi -5.114524
ruin -5.128592
Name: ukip, dtype: float32
positive
making 5.340323
jaz 5.273765
erry 5.261392
mernakhalil 5.212790
cure 5.196041
side 5.177371
soul 5.165285
akin 5.159555
knew 5.138681
generation 5.125652
Name: angela merkel, dtype: float32
negative
cord -4.883518
macklemore -4.908042
wing -4.930385
ump -4.952729
worst -4.973411
jump -5.010134
reco -5.018723
growing -5.021559
mack -5.067759
moving -5.145893
Name: angela merkel, dtype: float32
positive
consistency 5.255616
topping 5.235025
rm 5.214756
doesnt 5.202547
fav 5.130728
ale 5.123356
love 5.122993
facing 5.118979
right 5.078313
esn 5.077055
Name: bernie sanders, dtype: float32
negative
kp -2.965691
near -2.978920
nou -2.985488
convert -2.992692
pt -3.003129
licia -3.062319
converted -3.066446
nearly -3.067140
pts -3.075065
deliciano -3.090815
Name: bernie sanders, dtype: float32
positive
understand 5.091187
stan 4.982574
knock 4.869445
stand 4.844673
excitement 3.220572
ko 3.215367
fresh 3.183141
money 3.169917
love 3.146806
live 3.131765
Name: david cameron, dtype: float32
negative
goat -4.985082
aliisthegoat -4.987967
pathetic -5.008073
pat -5.015507
disrespectful -5.019631
path -5.037596
tf -5.046792
sth -5.069689
ego -5.153545
disrespect -5.223447
Name: david cameron, dtype: float32
positive
standing 5.345823
outdoors 5.338603
ump 5.312560
horizon 5.302494
since 5.286254
dl 5.281183
zon 5.265244
would 5.263505
mc 5.211892
mid 5.202428
Name: donald trump, dtype: float32
negative
technology -0.472837
relive -0.479776
timthejarhead -0.481756
dariuszporowski -0.489658
bumpergraham -0.498140
florentino -0.503098
feed -1.551284
damn -2.716697
hrs -2.772456
loop -3.071224
Name: donald trump, dtype: float32
positive
tcot 5.676202
yellow 5.585086
nearest 5.565730
adopted 5.555008
elop 5.534382
funniest 5.523337
addthis 5.520063
hanke 5.514048
forward 5.510333
themes 5.485855
Name: trump, dtype: float32
negative
care -5.287142
collect -5.288397
sum -5.291595
soon -5.302739
accessibility -5.313099
hab -5.322517
either -5.330446
crap -5.335936
hypocritical -5.415124
taking -5.505116
Name: trump, dtype: float32
positive
ya 3.294861
ryan 3.233552
shared 3.205798
broadcast 3.194653
ina 3.190872
number 3.189262
conversation 3.181121
applauchtuesday 3.174749
virtual 3.168167
pay 3.165454
Name: tory, dtype: float32
negative
pull -5.057612
spam -5.069879
wonders -5.073700
need -5.077768
action -5.079391
ugly -5.085699
hab -5.117970
fuckin -5.135649
passio -5.146897
dislike -5.189322
Name: tory, dtype: float32
positive
sep 5.229759
taken 5.189050
picture 5.075466
sept 5.074489
pm 5.031204
cincinnati 4.995294
inn 4.621712
ward 3.312734
agreement 3.255533
dela 3.238418
Name: hillary, dtype: float32
negative
history -5.149141
reco -5.149439
last -5.154108
deceased -5.169771
sir -5.199208
save -5.201537
tf -5.212353
cnn -5.223170
revamp -5.231756
laugh -5.370089
Name: hillary, dtype: float32
positive
last 5.142107
tko 4.984365
intro 4.970513
montamania 4.930176
keyboard 3.244540
summer 3.201967
ffs 3.198930
tweets 3.194518
summerslam 3.172878
control 3.169666
Name: joe biden, dtype: float32
negative
crush -3.264760
find -3.278125
rts -3.283587
recording -3.289766
sports -3.301833
dumb -4.944856
human -5.037510
dumbest -5.115357
mans -5.154351
humans -5.155365
Name: joe biden, dtype: float32
positive
yea 5.191533
change 5.182677
wide 5.178781
january 5.149583
straight 5.131778
wait 5.116929
fortune 5.109716
worldwide 5.095113
overall 5.074624
social 5.051077
Name: michelle obama, dtype: float32
negative
whenever -4.871494
ped -4.957586
helped -4.983782
germany -5.000025
ani -5.025279
concentration -5.027081
organize -5.031326
proceedures -5.043483
german -5.095454
nazi -5.145630
Name: michelle obama, dtype: float32
positive
soanxious 5.364390
par 5.280863
student 5.243481
give 5.241825
ya 5.197048
students 5.191928
fun 5.191669
berry 5.176778
alre 5.170278
life 5.164592
Name: obama, dtype: float32
negative
dedicate -3.067544
pewter -3.076259
super -3.082811
og -3.101808
work -3.105522
pausing -3.122665
uses -3.137393
pan -3.141957
enters -3.201102
lest -3.309366
Name: obama, dtype: float32
positive
fina 5.157638
zon 5.151124
blogchat 5.142585
cl 5.139886
hopeful 5.120580
wd 5.113565
aw 5.108050
aways 5.097840
xi 5.086601
following 5.068203
Name: rahul gandhi, dtype: float32
negative
sav -3.046020
train -3.051458
pet -3.053124
chatting -3.068491
doctor -3.084846
suck -3.088346
nose -3.096961
cautionary -3.116124
thumb -3.128786
known -3.311406
Name: rahul gandhi, dtype: float32
positive
vic 5.211103
bucks 5.187165
ton 5.180137
sure 5.174782
person 5.158006
dev 5.147445
ancient 5.128718
starbucks 5.120483
med 5.100248
personal 5.089083
Name: tony blair, dtype: float32
negative
round -3.098140
bled -3.106606
without -3.107395
think -3.112786
create -3.121061
pretty -3.144159
wheel -3.147245
auto -3.160305
guys -3.170951
super -3.171522
Name: tony blair, dtype: float32
positive
trooper 5.270963
reason 5.224319
pan 5.211392
made 5.205994
degree 5.159683
pant 5.139687
late 5.130530
incredible 5.107911
classic 5.067496
pantera 5.049136
Name: boehner, dtype: float32
negative
kept -3.048635
des -3.061087
cross -3.066943
looking -3.080960
bell -3.102684
saying -3.113672
hands -3.124447
imm -3.143423
cowbell -3.148570
xen -3.176170
Name: boehner, dtype: float32
positive
said 5.242499
took 5.242445
gi 5.195346
genius 5.145068
des 5.133868
absolutely 5.129947
bowl 5.128432
safety 5.110395
esp 5.102410
ted 5.094346
Name: tsipras, dtype: float32
negative
clock -5.191607
dc -5.192234
add -5.192361
impressed -5.203568
sweep -5.207062
mark -5.223533
yb -5.224341
wee -5.241929
constant -5.274511
run -5.308521
Name: tsipras, dtype: float32
positive
girl 3.368882
make 3.308124
mah 3.281106
hope 3.259494
trivia 3.258595
lou 3.250731
bri 3.247401
rim 3.246818
vic 3.244273
bs 3.241931
Name: bee gees, dtype: float32
negative
face -3.059511
fuck -3.080071
fucking -3.090496
point -3.091517
roxette -3.099016
thought -3.099212
though -3.153049
mix -3.216094
fuckin -3.220330
announcement -3.221997
Name: bee gees, dtype: float32
positive
certainly 5.294429
bad 5.291355
mind 5.240819
sitting 5.226705
handing 5.226448
expect 5.203944
really 5.149984
drake 5.149630
arch 5.148848
center 5.139788
Name: beyonce, dtype: float32
negative
lure -3.157138
prime -3.158980
another -3.174863
wash -3.189414
middle -3.195096
ryder -3.221191
failure -3.223109
ppl -3.223484
wanker -3.250409
cc -3.387237
Name: beyonce, dtype: float32
positive
kidney 3.249624
came 3.220159
alt 3.210617
defense 3.201135
draftbiden 3.191354
lf 3.190989
arm 3.187220
number 3.186639
wait 3.186249
starting 3.186210
Name: bob marley, dtype: float32
negative
tf -5.040061
debater -5.071601
surfer -5.072014
continued -5.080575
lown -5.093850
attacks -5.096873
surf -5.114693
attack -5.125142
enough -5.131480
clown -5.174407
Name: bob marley, dtype: float32
positive
humans 5.301317
cover 5.215748
earth 5.077869
feel 5.071968
lite 5.051912
soothingly 5.051816
cited 5.044989
rapper 5.030286
greatest 5.021720
smash 5.015769
Name: chris brown, dtype: float32
negative
assault -4.876487
cked -4.976496
locked -4.982239
system -4.991899
needs -5.013125
hr -5.053143
lock -5.055254
thro -5.096401
shit -5.140181
away -5.359952
Name: chris brown, dtype: float32
positive
enjoying 5.186056
command 5.085531
btw 4.989222
rockin 4.984443
commando 4.978878
monster 4.856939
conquer 4.747939
music 4.147956
playing 4.119771
laying 3.941318
Name: david bowie, dtype: float32
negative
ugliest -4.910964
cobb -4.981623
horrifying -5.054488
blackheath -5.085209
white -5.098744
ngo -5.126391
okay -5.140930
hurt -5.156003
nelson -5.228518
kay -5.249962
Name: david bowie, dtype: float32
positive
ahs 5.222962
ted 5.182967
sure 5.165173
bt 5.164561
dam 5.150071
sara 5.147958
mind 5.140663
tickets 5.133337
wants 5.128265
hole 5.114217
Name: katy perry, dtype: float32
negative
body -3.129400
depict -3.134737
stop -3.137543
hair -3.145944
health -3.151453
hai -3.155513
xi -3.163030
elizabeth -3.171307
fucks -3.200108
chair -3.301933
Name: katy perry, dtype: float32
positive
rite 5.143018
fav 5.141301
favor 5.126582
favorite 4.992493
done 4.886828
players 4.119648
around 3.288347
saved 3.270367
thrown 3.211821
wee 3.205345
Name: ed sheeran, dtype: float32
negative
plain -3.074950
cross -3.086208
funk -3.087816
panic -3.111351
fun -3.112198
eta -3.128776
apr -3.135343
dec -3.199353
ja -3.202675
comment -3.285160
Name: ed sheeran, dtype: float32
positive
hope 5.298042
fg 5.186870
girl 5.180293
proud 5.084408
ff 5.059354
hopefully 5.055337
ladygaga 5.051345
omffffg 5.051173
shine 5.047174
sit 5.045211
Name: foo fighters, dtype: float32
negative
ben -3.057898
com -3.065411
wrong -3.094541
hr -3.096699
scare -3.108542
someone -3.112243
hat -3.142384
tony -3.142461
born -3.158276
scared -3.167120
Name: foo fighters, dtype: float32
positive
matches 5.208513
meet 5.207755
header 5.198889
month 5.160851
aw 5.146141
ovi 5.127687
shaking 5.126233
gon 5.123438
halilovic 5.116260
vic 5.114135
Name: janet jackson, dtype: float32
negative
either -2.924270
guy -2.938210
suppose -2.992742
dislike -3.006327
atleti -3.019781
wasnt -3.024531
atletico -3.044278
tl -3.101293
pose -3.104647
guys -3.155561
Name: janet jackson, dtype: float32
positive
local 5.185252
deb 5.179274
wing 5.176514
love 5.163868
pbs 5.150585
kl 5.144840
tending 5.130581
jaz 5.118962
fam 5.105271
attending 5.102529
Name: lady gaga, dtype: float32
negative
survey -0.395620
overnighted -0.397811
regardless -0.403625
fuck -0.415946
appleeventavailable -0.416395
granted -0.435852
holes -0.436382
casemateeurope -0.439702
tempest -0.460186
juggles -0.497872
Name: lady gaga, dtype: float32
positive
admire 5.240537
wind 5.240513
rite 5.239651
insideedition 5.204407
winding 5.178030
collincebey 5.134081
fav 5.131238
classy 5.124538
presence 5.117989
playin 5.115941
Name: michael jackson, dtype: float32
negative
lifetime -5.094618
levin -5.113457
constitution -5.117458
marklevinshow -5.123685
count -5.124767
statement -5.125326
country -5.128769
dictatorship -5.195179
less -5.198721
dictator -5.350689
Name: michael jackson, dtype: float32
positive
arrive 5.764266
offers 5.685816
details 5.622914
stores 5.594927
surf 5.593620
relevance 5.588964
points 5.582696
science 5.578740
ashe 5.575533
gem 5.521762
Name: ac/dc, dtype: float32
negative
everyone -5.519905
techsupport -5.520095
though -5.522585
sumer -5.528801
intern -5.562683
telegraph -5.563118
ruin -5.607967
charles -5.624625
knew -5.627909
plan -5.888354
Name: ac/dc, dtype: float32
positive
like 0.067611
lt 0.062637
bil 0.060511
mess 0.057287
ailing 0.057110
ending 0.055274
ink 0.054324
stop 0.053957
try 0.053615
hr 0.052767
Name: the vamps, dtype: float32
negative
sell -2.991034
crash -2.995635
grief -2.996091
dear -2.998915
sadly -3.004585
given -3.006462
disappointed -3.008161
dp -3.011601
appointed -3.024583
ashes -3.042619
Name: the vamps, dtype: float32
positive
air 5.379739
shrug 5.301239
dinos 5.237104
doin 5.227159
hope 5.216933
covered 5.212333
gossip 5.198098
ace 5.187961
boehner 5.180753
saturday 5.178292
Name: iron maiden, dtype: float32
negative
havnt -4.992898
subscription -4.996792
pins -5.019452
spinsouthwest -5.034129
month -5.041651
script -5.047502
pin -5.048021
ubs -5.139879
hav -5.168286
rip -5.191136
Name: iron maiden, dtype: float32
positive
absolute 5.199219
absolutely 5.138769
bs 5.094816
love 5.019090
supermariomaker 4.979361
cited 3.968878
excited 3.847426
ppl 3.256890
siding 3.228886
rest 3.219889
Name: rolling stone, dtype: float32
negative
yr -3.152574
lets -3.154248
ass -3.159315
win -3.169297
las -3.185200
class -3.194958
bob -3.220584
change -3.231967
stop -3.241399
chad -3.292894
Name: rolling stone, dtype: float32
positive
thank 3.458607
really 3.456318
sooooo 3.350114
made 3.318257
roll 3.296948
charles 3.291073
friends 3.273188
rollingstones 3.270203
tha 3.267724
consist 3.261425
Name: jay-z, dtype: float32
negative
discu -2.930193
funk -2.944258
road -2.964809
queen -3.004427
tending -3.058750
queens -3.069894
jun -3.088541
juncture -3.102507
railroad -3.108046
ending -3.116689
Name: jay-z, dtype: float32
positive
kinda 5.185695
abi 5.181487
wish 5.123028
didnt 5.109053
age 5.089826
scratch 5.082001
exageratin 5.053792
floor 5.028360
dies 5.026799
drop 5.022115
Name: snoop dogg, dtype: float32
negative
fkin -4.971377
better -4.972764
pain -5.009066
cheerful -5.015804
load -5.051645
britain -5.084395
yb -5.091674
cheer -5.096683
month -5.103464
rita -5.147938
Name: snoop dogg, dtype: float32
positive
america 5.132748
potus 5.040648
best 5.031157
american 4.992321
lifetime 4.964489
convinced 4.942805
vince 4.893375
awards 3.224919
israel 3.206967
orvisuk 3.185707
Name: nirvana, dtype: float32
negative
roy -3.953727
lie -4.021974
china -4.872950
belief -4.967462
levin -4.971927
working -4.997544
mark -5.064811
market -5.068044
crash -5.087220
barak -5.090741
Name: nirvana, dtype: float32
positive
feb 3.222225
hall 3.213444
try 3.197720
enjoyed 3.196800
vic 3.186503
print 3.175673
woo 3.170074
dollar 3.165079
improve 3.164797
cat 3.159706
Name: arsenal, dtype: float32
negative
gen -3.210933
die -3.278415
fuck -4.799486
arent -4.874743
ran -4.913039
tran -4.934807
sue -4.978038
transparently -5.045898
spare -5.055328
parent -5.121700
Name: arsenal, dtype: float32
positive
dam 5.236481
waaaa 5.196217
aaaa 5.166891
damn 5.165329
waaaaaay 5.074606
office 4.999948
mn 4.912038
xd 4.799880
pos 3.767566
post 3.668766
Name: barca, dtype: float32
negative
lock -3.157083
came -3.163758
butt -3.169560
alexander -3.172462
consumer -3.174176
messed -3.184734
piece -3.215601
toilet -3.222604
sumer -3.247683
broken -3.251884
Name: barca, dtype: float32
positive
blue 5.089501
blues 5.063036
afternoon 5.049823
help 5.048113
noon 5.015295
gotta 4.970567
much 4.950105
getting 4.933884
aft 4.924540
gettin 4.909851
Name: federer, dtype: float32
negative
sabr -4.913450
thems -4.936750
criminality -4.999974
thy -5.021441
however -5.045201
negative -5.050997
moron -5.054264
well -5.055790
intent -5.153399
wel -5.198098
Name: federer, dtype: float32
positive
book 3.202460
fucking 3.160316
damn 3.153373
tru 3.136853
pretty 3.126527
bad 3.126408
tom 3.126403
looking 3.118021
citing 3.111659
roy 3.108273
Name: floyd mayweather, dtype: float32
negative
lest -3.083753
get -3.087022
tf -3.095082
lake -3.095146
many -3.096641
ade -3.108071
made -3.115206
line -3.127769
roster -3.135883
main -3.141793
Name: floyd mayweather, dtype: float32
positive
years 3.193231
range 3.180484
ali 3.156494
eta 3.151172
shop 3.125422
rogers 3.102788
richest 3.094290
god 3.089745
headers 3.087948
international 3.085914
Name: hulk hogan, dtype: float32
negative
uk -3.097669
galacti -3.101622
set -3.105721
big -3.118437
buy -3.119774
tv -3.121819
getting -3.134726
less -3.140492
mora -3.185137
manutd -3.217459
Name: hulk hogan, dtype: float32
positive
without 3.208131
center 3.193618
live 3.185737
fav 3.182298
bri 3.178758
socia 3.177257
erp 3.164861
wife 3.153407
mike 3.140630
pool 3.138972
Name: john cena, dtype: float32
negative
waste -3.113183
bats -3.120803
mn -3.122175
gravy -3.127717
bambino -3.128394
dont -3.134111
defence -3.156723
wage -3.158541
past -3.158966
sitting -3.194237
Name: john cena, dtype: float32
positive
view 3.271570
rod 3.195414
beg 3.194518
pool 3.171151
third 3.170265
kat 3.164826
songs 3.144890
glo 3.139053
fu 3.138391
sweet 3.137080
Name: kris bryant, dtype: float32
negative
plain -3.074244
ubs -3.075484
moved -3.076482
cc -3.081388
dst -3.092824
probably -3.105602
script -3.114388
dying -3.117867
reds -3.126305
senior -3.149182
Name: kris bryant, dtype: float32
positive
thenyou 5.053110
amazing 4.999885
dar 3.967660
rondarousey 3.548921
talent 3.218803
person 3.208977
grinding 3.198437
class 3.190160
lite 3.168027
knew 3.164881
Name: randy orton, dtype: float32
negative
hero -3.104648
death -3.112475
aim -3.116096
constantly -3.118833
kissing -3.127251
criscyborg -3.127781
itstheryguy -3.143729
bensotokarass -3.148737
pullin -3.158459
complete -3.230343
Name: randy orton, dtype: float32
positive
live 5.230541
yb 5.214437
weird 5.196394
sibling 5.194451
happy 5.179516
cio 5.177874
maybe 5.173094
wondering 5.171242
duo 5.153949
ring 5.140019
Name: real madrid, dtype: float32
negative
nigeria -0.447614
good -1.589527
aid -2.847893
veealways -2.870897
class -2.883166
anno -2.922757
ann -3.010741
cannot -3.167326
taken -3.174142
said -3.340037
Name: real madrid, dtype: float32
positive
ade 5.154561
san 5.151413
presence 5.099111
matters 5.097280
snoopadelic 5.032429
aka 4.993336
thinkin 4.965200
thinking 4.947495
keys 4.928507
love 4.922515
Name: serena, dtype: float32
negative
focused -3.017678
hole -3.025959
documentary -3.027143
team -3.027541
tea -3.029036
universal -3.029909
espn -3.033891
used -3.067803
pac -3.090221
relation -3.242511
Name: serena, dtype: float32
positive
ina 3.228825
god 3.220349
zon 3.205257
really 3.199505
reco 3.170709
highest 3.167899
deliver 3.159848
ines 3.123884
join 3.122800
brilliant 3.120267
Name: messi, dtype: float32
negative
select -2.998632
guardiola -3.002099
pointing -3.002316
hat -3.018291
sap -3.019584
perf -3.027642
disappointing -3.031590
channels -3.040050
elyaqub -3.047252
lacklustre -3.074281
Name: messi, dtype: float32
positive
wanna 5.157760
twc 5.109600
home 5.074178
wc 5.073596
replacement 5.063345
san 5.056780
rocks 5.041064
cancel 5.040281
epl 5.037660
bad 5.028410
Name: david beckham, dtype: float32
negative
sucks -5.054658
care -5.083243
apr -5.096243
switched -5.108187
needs -5.129425
joke -5.135540
pose -5.149446
adam -5.151989
maybe -5.234247
feelin -5.261662
Name: david beckham, dtype: float32
positive
january 5.144932
hc 5.105793
hits 5.084289
hit 5.064448
thetideonthehits 5.040916
kan 5.040314
dud 5.039817
thehitsofficial 5.027900
ari 5.027232
itsjoshcollins 5.017258
Name: rousey, dtype: float32
negative
sadly -3.069200
theperksofworkingatthevenue -3.082813
care -3.092065
answer -3.093297
awful -3.093735
car -3.094954
working -3.107461
approaching -3.113565
asses -3.185374
work -3.198202
Name: rousey, dtype: float32
positive
thought 5.385254
bb 5.258897
greatest 5.242048
solid 5.225765
stl 5.186909
ought 5.180254
good 5.175613
test 5.167013
use 5.153841
eta 5.128374
Name: super eagles, dtype: float32
negative
acc -3.161800
carnage -3.164794
dj -3.164800
mn -3.175642
dw -3.187729
twice -3.197704
titles -3.209940
around -3.266165
week -3.294608
wee -3.329000
Name: super eagles, dtype: float32
positive
best 5.042642
bless 4.818489
tonight 3.346484
revolution 3.235859
state 3.191815
nyt 3.150509
dont 3.133381
moderate 3.111586
speechwriter 3.104881
good 3.095447
Name: kane, dtype: float32
negative
science -5.141290
call -5.144700
hell -5.158818
hun -5.162246
intern -5.174433
mongering -5.184914
ko -5.189199
sand -5.194393
esm -5.219941
hundreds -5.262103
Name: kane, dtype: float32
positive
dine 5.384799
gardiner 5.375050
carding 5.104222
card 5.063302
black 5.022101
lack 4.959969
traffic 4.869288
imm 3.531159
economy 3.437764
big 3.313333
Name: red sox, dtype: float32
negative
leadership -5.162408
hypo -5.162725
jd -5.163450
julie -5.173241
mouths -5.195755
mind -5.212234
hatred -5.212978
forward -5.224383
roll -5.324614
youre -5.337960
Name: red sox, dtype: float32
positive
dec 5.225210
declaring 5.164753
life 5.150716
laring 5.090421
lifetime 4.975964
pundits 4.915051
pun 3.992616
people 3.923105
many 3.891707
msn 3.253280
Name: white sox, dtype: float32
negative
log -5.017655
logan -5.021994
az -5.025484
anti -5.038983
dio -5.079040
messianic -5.092434
fascist -5.114392
messi -5.116867
mike -5.119874
pan -5.162713
Name: white sox, dtype: float32
positive
eng 3.238629
bb 3.232605
splitting 3.217534
hold 3.211921
ato 3.174965
relying 3.164776
auto 3.158369
betteroffin 3.149588
asses 3.147429
comfort 3.139020
Name: chelsea, dtype: float32
negative
camp -3.155102
heading -3.157531
xc -3.158627
realize -3.168450
inside -3.169093
situation -3.172509
secrecy -3.184244
db -3.192157
detail -3.198553
days -3.227594
Name: chelsea, dtype: float32
positive
apple 5.513439
means 5.472116
progr 5.432020
farreal 5.418705
eng 5.414100
believe 5.401307
weird 5.380465
mood 5.378206
miss 5.370694
starting 5.366580
Name: james franklin, dtype: float32
negative
age -5.324932
diff -5.339800
arm -5.348687
seen -5.355443
late -5.426640
funnyyyyyyy -5.434279
fix -5.449319
muchhh -5.450140
thei -5.473583
notif -5.499257
Name: james franklin, dtype: float32
positive
thurs 5.145145
thur 5.066425
blackheath 5.054032
thursday 5.001463
heat 4.962073
makes 4.729200
know 4.039989
kno 4.005864
black 3.995295
lack 3.908732
Name: billy cundiff, dtype: float32
negative
national -5.107406
cock -5.107805
sim -5.109013
average -5.118339
purveyors -5.139388
barongraham -5.157882
east -5.172168
ave -5.173892
hatred -5.209168
daily -5.351571
Name: billy cundiff, dtype: float32
positive
days 3.231051
cover 3.156706
weighing 3.129603
coo 3.123184
retires 3.112101
wel 3.106741
say 3.096737
buy 3.095462
maiker 3.089493
bmr 3.088837
Name: cundiff, dtype: float32
negative
brad -3.070143
quality -3.071778
ugliest -3.071848
react -3.084992
samardzija -3.090092
rated -3.095825
suns -3.098769
bass -3.104101
atrocious -3.107972
town -3.114031
Name: cundiff, dtype: float32
positive
lot 5.091837
kun 5.077047
campers 5.022414
baikunth 5.001144
camp 4.977055
camper 4.863493
cam 4.027404
mm 3.941446
kb 3.249890
tru 3.246327
Name: tiger woods, dtype: float32
negative
though -3.148805
ought -3.152415
funnel -3.158128
photos -3.179862
yall -3.184729
nu -3.194807
without -3.231503
yr -3.264167
member -3.264697
ds -3.288696
Name: tiger woods, dtype: float32
In [ ]:
len(all_words)
In [ ]:
df.shape
In [ ]:
print all_topics.shape
all_topics_pretty = np.reshape(all_topics, (11,7))
In [ ]:
print all_topics_pretty
In [ ]:
for row in all_topics_pretty:
print " , ".join(str(val) for val in row)
In [ ]:
Content source: ProjectsUCSC/NLP
Similar notebooks: