Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. TICKER_id DXJ EWA EWC EWG EWI EWP EWQ EWU EWW EWY EWZ
  2. DATE
  3. 2019-05-20 -1.0 1.5 0.0 -0.5 0.0 0.0 0.5 0.0 -0.5 0.0 0.0
  4. 2019-05-21 -1.0 1.5 0.5 -0.5 0.0 0.0 0.0 0.0 -0.5 -0.5 0.0
  5. 2019-05-22 -1.0 1.5 0.0 -1.0 0.0 0.0 0.0 0.0 -0.5 -0.5 0.0
  6.  
  7. [{'id': 00001, 'DATE': datetime.date(2019, 7, 8), 'TICKER_id': 'DXJ', 'FINAL_SCORE': -0.5, 'MODEL_SCORE': -0.5, 'G': 0.0, 'L': 0.0, 'R': 0.0, 'RV': -1.0, 'SN': -1.0, 'TC': -1.0, 'FN': 0.0}
  8.  
  9. scores = overall_scores.objects.filter(TICKER__in = countries, DATE = last_date).values()
  10. lag_scores_df = pd.DataFrame([x for x in overall_scores.objects.filter(TICKER__in = countries, DATE__gte = lag_date).values()])
  11. lag_scores_df = lag_scores_df.pivot_table(index = 'DATE', columns = 'TICKER_id', values = 'FINAL_SCORE')
  12. lag_scores_df.fillna(method= 'ffill', inplace = True)
  13. lag_scores_df.diff(21)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement