Skip to content

Instantly share code, notes, and snippets.

🌴
On vacation

catindog/nardtree GINK03

🌴
On vacation
Block or report user

Report or block GINK03

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View BigQuery_query_talkingdata.sql
-- Feature engineering BigQuery SQL queries for the kaggle talkingdata competition by tkm2261
-- it may acheve 0.9823 on the public LB with simple GBDT.
-- destination table: takling.train_test
SELECT
null as click_id,
ip, app, device, os, channel, click_time, attributed_time, is_attributed, timediff, year, month, day, dayofweek, hour, minute, second
FROM
`talking.train`
UNION ALL
You can’t perform that action at this time.