Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- import numpy as np
- import pandas as pd
- from pandas import DataFrame
- import matplotlib.pyplot as plt
- gp_conn = psycopg2.connect("dbname='gp_ns_ddl_prod' user='martin_ilavsky' password='' host='ddlpldurgpm11.us.dell.com' port='6420'")
- gp_cur = gp_conn.cursor()
- sql = """
- SELECT s.identity_id_val,
- s.journey_stage_score,
- m.journey_stage_score
- FROM ws_mkt_dst.cjs_scores s
- LEFT JOIN (SELECT identity_id_val,journey_stage_score FROM ws_mkt_dst.cjs_scores where run_uid = 99 and journey_stage_score != 0) m ON m.identity_id_val = s.identity_id_val
- WHERE s.run_uid = 34
- and s.journey_stage_score != 0
- """
- gp_cur.execute(sql)
- df = pd.DataFrame(gp_cur.fetchall(),columns=['acct','parabolic','linear'],dtype='float')
- #df = pd.DataFrame(gp_cur.fetchall(),columns=['acct','m12','m11','m10','m9','m8','m7','m6','m5','m4','m3','m2','m1','m0'],dtype='float')
- df.info()
- plt.axvline(x=0.016181229773106796)
- plt.axvline(x=0.05933117583038835)
- df.boxplot(column=['parabolic','linear'],vert=False,figsize=("10","10"),showfliers=False)
- #df.boxplot(column=['m12','m11','m10','m9','m8','m7','m6','m5','m4','m3','m2','m1','m0'],vert=False,figsize=("10","10"),showfliers=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement