Database Reference
In-Depth Information
tamingoftheshrew
,
SUM(IF (corpus == 'tempest', tfidf, 0)) AS tempest
,
SUM(IF (corpus == 'timonofathens', tfidf, 0)) AS
timonofathens
,
SUM(IF (corpus == 'titusandronicus', tfidf, 0)) AS
titusandronicus
,
SUM(IF (corpus == 'troilusandcressida', tfidf, 0))
AS troilusandcressida
,
SUM(IF (corpus == 'twelfthnight', tfidf, 0)) AS
twelfthnight
,
SUM(IF (corpus == 'twogentlemenofverona', tfidf, 0))
AS twogentlemenofverona
,
SUM(IF (corpus == 'winterstale', tfidf, 0)) AS
winterstale
,
FROM [ch13.shakespeare_tfidf]
GROUP BY word"
You can set this as the query in R and fetch the results:
>
results <- query_exec("bigquery-e2e", "ch13", query
,
billing=billing_project
,
max_pages=Inf)
3.6 megabytes processed
Retrieving data: 28.7s
>
summary(results)
word onekinghenryiv
onekinghenryvi twokinghenryiv
Length:16281 Min. : 0.0000 Min. :
0.000 Min. : 0.0000
Class :character 1st Qu.: 0.0000 1st Qu.:
0.000 1st Qu.: 0.0000
Mode :character Median : 0.0000 Median :
0.000 Median : 0.0000
Mean : 0.7842 Mean :
0.738 Mean : 0.8419
3rd Qu.: 0.0000 3rd Qu.:
0.000 3rd Qu.: 0.0000
Max. :631.0000 Max.