do_compare_dp_results.sql
Save this script as do_compare_dp_results.sql.
with
nt_results as (
select
bucket, n, min_s, max_s
from dp_results
where method = 'ntile')
,
pr_results as (
select
bucket, n, min_s, max_s
from dp_results
where method = 'percent_rank')
,
cd_results as (
select
bucket, n, min_s, max_s
from dp_results
where method = 'cume_dist')
select
bucket,
(nt.n = pr.n )::text as "pr n equal",
(nt.min_s = pr.min_s)::text as "pr min_s equal",
(nt.max_s = pr.max_s)::text as "pr max_s equal",
(nt.n = cd.n )::text as "cd n equal",
(nt.min_s = cd.min_s)::text as "cd min_s equal",
(nt.max_s = cd.max_s)::text as "cd max_s equal"
from nt_results nt
inner join pr_results pr using (bucket)
inner join cd_results cd using (bucket)
order by bucket;