Guest User

Untitled

a guest
Jan 22nd, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. all_temps = []
  2. all_tokens = []
  3. tables = {"joined_df": mastertemp.columns}
  4. n_months = 12
  5.  
  6. for y in range(1, n_months + 1):
  7. josh_mody_n_str = "floor((josh_mody_n - " + str(y) + ")/12.0)"
  8. query = "SELECT loan_id, " + josh_mody_n_str + " as josh_mody_n, max(max_d12) > 3 as max_d12_gt3, min(min_upb_12) = 0 as min_upb_12_eq0, min(min_upb_12) as upb_12 FROM main.joined_df as joined_df GROUP BY loan_id, " + josh_mody_n_str
  9.  
  10. metaToken = pyblazing.run_query_get_token(query, tables)
  11. all_tokens.append(metaToken)
  12.  
  13. for metaToken in all_tokens:
  14. temp = pyblazing.run_query_get_results(metaToken)
  15. all_temps.append(temp
Add Comment
Please, Sign In to add comment