Google Cloud Platformではじめる機械学習と深層学習を読む

2-3 DatalabとBigQueryの連携

2-3.-2 クエリをDatalabから実行

!bq mk testdataset
!bq load testdataset.names ../datasets/name.csv ../datasets/schema.json

%%bq query
SELECT 
name,count
FROM 
testdataset.names
WHERE
state = 'CA' AND gender = 'F'
ORDER BY
count DESC
LIMIT 5

[f:id:bitop:20171224140708p:plain]

2-3-3 クエリ結果をチャートにプロット

%%bq query --name popular_names
SELECT 
name,count
FROM 
testdataset.names
WHERE
state = 'CA' AND gender = 'F'
ORDER BY
count DESC
LIMIT 10

%%bq query --name count_by_state
SELECT 
state,SUM(count) as sum_count
FROM 
testdataset.names
GROUP BY
1
ORDER BY
2 DESC

%chart geo --data count_by_state
{"region":"US","resolution":"provinces"}