Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- all_temps = []
- all_tokens = []
- tables = {"joined_df": mastertemp.columns}
- n_months = 12
- for y in range(1, n_months + 1):
- josh_mody_n_str = "floor((josh_mody_n - " + str(y) + ")/12.0)"
- 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
- metaToken = pyblazing.run_query_get_token(query, tables)
- all_tokens.append(metaToken)
- for metaToken in all_tokens:
- temp = pyblazing.run_query_get_results(metaToken)
- all_temps.append(temp
Add Comment
Please, Sign In to add comment