Decision Tree Experiments

A journal / scratchpad.

select p.id, HOUR(p.created_at), p.user_reputation, p.revision_count, r.id as reason_id, r.reason_name, p.is_tp, p.is_fp
from posts p
inner join posts_reasons pr on pr.post_id = p.id
inner join reasons r on r.id = pr.reason_id
where p.site_id IS NOT NULL
and p.created_at >= '2018-07-01'
and (p.is_tp = 1 OR p.is_fp = 1)
and p.is_tp != p.is_fp
and revision_count IS NOT NULL