ó
`¸òRc@sÑdd
lm
Z

dZd„Zddd„ƒYZddd„ƒYZddd	„ƒYZd
„Zd„Zd„Z	d
„Z
d„Zd„Zd„Z
d„Zd„Zd„Zd„Zd„Zd„ZdS(iÿÿÿÿ(
tconnectsifdb_data.sqlitec
CsItt
ƒ
}
|
1
|
jƒ}|jd
j|ƒ
ƒ

|jƒSWdQXdS(s>Returns contents of one entire table from the sqlite database.sSELECT * FROM {!s}N(Rtdb_pathtcursortexecutetformattfetchall(t	tableNametconntcurs((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyt	get_tables




tdata_holderc
BseZ
dZd
„ZRS(sDAn object to hold data from each of the four tables in the database.c

CsXtt
d
ƒ
ƒ
|_tt
dƒ
ƒ
|_tt
dƒ
ƒ
|_tt
dƒ
ƒ
|_dS(Nt
Receptionst
AuthoringstWorkstAgents(tsetR	t
receptionst
authoringstworkstagents(
tself((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyt__init__s



(t__name__t
__module__t__doc__R(((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyR
s
t
entity_holdercBseZ
dZd
d„
ZRS(sFAn object to hold data cheaply processed from those held in the above.ics 
d
„|
jDƒ
ˆ
_d„|
jDƒ
ˆ
_
d„|
jDƒ
ˆ
_d„|
jDƒ
ˆ
_d„|
jDƒ
ˆ
_d„|
jDƒ
ˆ
_d„|
jDƒ
ˆ
_d„|
jDƒ
ˆ
_	d	„|
jDƒ
ˆ
_
‡f
d
†|
jDƒ
ˆ
_d„ˆ
jDƒ
ˆ
_‡
f
d†|
jDƒ
ˆ
_
d
„ˆ
jDƒ
ˆ
_ˆ
jˆ
j
@ˆ
_ˆ
jˆ
j@ˆ
_ˆ
jˆ
j
@ˆ
_ˆ
jˆ
j@ˆ
_ˆ
j
ˆ
j@ˆ
_ˆ
jˆ
jBˆ
_dS(Nc
Ssh|]}
|
d’qS(
i((t.0t
x((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>#s	c
Ss0h|]&}
t|
dƒ
d
kr|
d’qS(ii
(
tlen(RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>$s	c
Ss0h|]&}
t|
dƒ
d
kr|
d’qS(ii
(
R(RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>%s	c
Ssh|]}
|
d’qS(
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>&s	c
Ssh|]}
|
d’qS(
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>'s	c
Ssh|]}
|
d’qS(
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>(s	c
Ssh|]}
|
d’qS(
i
((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>)s	c
Ss*h|] }
|
dd
kr|
d
’qS(ii
((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>*s	c
Ss*h|] }
|
dd
kr|
d’qS(ii
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>+s	c
s*h|] }
|
dˆkr|
d ’qS(
i((RR(
trating_threshold(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>,s	
c
Ssh|]}
|
d’qS(
i
((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>.s	c
s-h|]#}
|
dˆjkr|
d
’qS(i
i(
t	highrated(RR(
R(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>/s	
c
Ssh|]}
|
d’qS(
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>1s	(RtuserstnonusersRtauthorsRRt	receiverstreceivedtratedtraterstrecognitionsRt
recognisedtrecogniserstauthor_userstauthor_receiverst
author_raterstauthor_recogniserstrecognised_recogniserstactive_users(RtdataR((RRsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyR"s&
















(RRRR(((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyRs
tattribute_holderc
BseZ
dZd
„ZRS(sBAn object to hold ranges of categorical values for some variables.cCsFd
„|
jDƒ
|_
d„|
jDƒ
|_d„|
jDƒ
|_dS(Nc
Ssh|]}
|
d’qS(
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>=s	c
Ssh|]}
|
d’qS(
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>>s	c
Ssh|]}
|
d’qS(
i((RR((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>?s	(Rtyearst	languagestdev_systems(RR/((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyR<s


(RRRR(((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyR09s
c

Csà
g}
g}g}g}g}g}g}g}xA
|jD]6
}	|	d
sPq:nd|	d
krt|
j
|	dƒ

q:d|	d
kr˜|j
|	dƒ

q:d|	d
kr¼|j
|	dƒ

q:d|	d
krà|j
|	dƒ

q:d|	d
kr
|j
|	dƒ

q:d|	d
kr(
|j
|	dƒ

q:d	|	d
krL
|j
|	dƒ

q:d
|	d
kr:|j
|	dƒ

q:q:Wit|
ƒ
d6t|ƒ
d6t|ƒ
d
6t|ƒ
d6t|ƒ
d6t|ƒ
d6t|ƒ
d6t|ƒ
d6S(s[
Returns a dictionary: keys are systems; values, works created therewith.

    Note that this doesn't bother with the full range of values in the
    data. Only the most common systems are returned, and different
    versions of a system are treated as the same system (e.g. 'Inform
    6' and 'Inform 7' games are grouped together under 'Inform').itADRIFTitInformtTADStZILtHugotQuilltEamontScotttadrifttinformttadstziltquillteamontscottthugo(RtappendR(
R/tADRIFT_listtInform_listt	TADS_listtZIL_listt
Quill_listt
Eamon_listt
Scott_listt	Hugo_listtwork((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytworks_by_systemAs>




























cst‡f
d
†|
Dƒ
ƒ
S(sÚReturns the human-readable name associated with an ID string.

    To get agent names, pass in the agents variable of a data_holder
    object; to get work names, pass in the works variable of a
    data_holder object.c
3s)|]}
|
dˆkr|
d
V
qdS(ii
N((Rt
a(
tid(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<genexpr>ps(
tnext(RPtentity_data((
RPsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytname_entityiscs!t‡f
d
†|
j
Dƒ
ƒ
dS(s0Returns the year a particular work was released.c
3s%|]}
|
dˆkr|
V
qd
S(iN((RRM(
twork_ID(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<genexpr>usi(RQR(RTR/((
RTsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytyear_ofrscs‡‡
fd
†|Dƒ
S(s=Returns a dictionary of entities with a particular attribute.c

s,i|]"‰‡‡
fd†ˆDƒ
ˆ“qS(
c
s*h|] }
|
ˆ
ˆkr|
d’qS(
i((Rtmember(tattrt
attr_index(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>zs	
((
R(RXt
entity_set(
RWsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys
<dictcomp>zs	((t	attributeRYRX((RXRYsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytattribute_entity_dictwscCsygt||
ƒD]}|^q}t
|ƒ
}|d
kr>dStg|D]}|d^qHƒ
t|ƒ
}|tfSdS(sGReturns the number of ratings and the mean rating that a work received.iiN(ii(twork_ratingsRtsumtfloattmean_ratings(RMR/t
rtratingstnum_ratings((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytwork_number_and_mean_ratings~s"

-
c
Cs=tg|j
D]}
t|
|ƒ|
f
^q
ƒ
d
d
d…S(sIReturns list of tuples in order of ranking of works by number of ratings.Niÿÿÿÿ(tsortedRRc(R/RM((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyt
most_ratedˆs
cs‡f
d
†|
jDƒ
S(s@Returns set of agents credited with authorship of a single work.c
s*h|] }
|
dˆkr|
d
’qS(i
i((Rt	authoring(
RM(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>‘s	
(
R(RMR/((
RMsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyt
authors_ofŽscs‡f
d
†|
jDƒ
S(s5Returns set of works for which an author is credited.c
s*h|] }
|
dˆkr|
d
’qS(ii
((RRf(
tauthor(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>—s	
(
R(RhR/((
Rhsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytworks_by”scs‡‡
fd
†|
jDƒ
S(s“Returns set of agents who rated a given work highly.

    Note that ratings of works for which the rater is credited as an
    author are excluded.c
sGh|]=}
|
dˆ
kr|
dt|
d
ˆƒkr|
d
’qS(i
i(
Ri(Rtrec(R/RM(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp> s	

(
R&(RMtentitiesR/((R/RMsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytrecognisers_ofšscCs@tgƒ
}x-t
||ƒD]}|t||
|ƒB}qW|S(
s²Returns set of agents who rated a given author's works highly.

    Note that an agent's ratings of works that he or she co-authored
    with the author in question are excluded.(RRiRl(RhRkR/R(RM((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytrecognisers_of_author¤s


cs‡‡
fd
†|jDƒ
S(sFReturns all receptions of works with the given value for one variable.c
s*h|] }
|
dˆˆ
kr|
’qS(
i
((Rt	reception(tattr_entity_dictRZ(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys	<setcomp>²s	
(
R(RZRoR/((RoRZsm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyttotal_receptions_attribute¯scs‡‡
fd
†|Dƒ
S(s8
Returns a dictionary of receptions of works for one variable.

    Key is every value which that variable has in the data. I used
    this for comparing the number of ratings and reviews received by
    works in different languages, released in different years, or
    developed with different authoring systems.c
s%i|]}
t|
ˆˆ
ƒ|
“qS((
Rp(Rtatt(tatt_entity_dictR/(sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pys
<dictcomp>½s	
((tatt_typeRrR/((RrR/sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyt$dict_total_receptions_attribute_typeµs
c
Cs3
tƒ}t
|ƒ
}
t|ƒ
}t|j|jd
ƒ}td||ƒ}djt|ƒ
ƒ
GHt|j	|jdƒ}djt|dƒ
ƒ
GHt
|j	||ƒ}djt|dƒ
ƒ
GHt|j|jdƒ}t
|j||ƒ}d	GHd
GHx9|jD].}	dj|	t||	ƒ
t||	ƒ
ƒGHqýWdS(
s%This is just to show how things work.isInform 6s!Receptions of Inform 6 works: {}
isWorks in Russian: {}sRussian (ru)s#Receptions of works in Russian: {}
isWorks and receptions by years$Year	Works	Receptions of those workss{}	{}	{}N(R
RR0R[R3RRpRRR2RtR1(
R/Rkt
attributest	sys_workstinf6_recepst
lang_workstlang_receptionst
year_workstyear_receptionst
y((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pytdemonstrateÀs 	










N((((tsqlite3RR
R	R
RR0RNRSRUR[RcReRgRiRlRmRpRtR}(((sm/Users/annajordanous/Dropbox/KCL/projects/SoundCloudValue/git/cleaned_IFDB_code_and_data/process_ifdb_data.pyt<module>
s$			(