Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. {'$match':
  2. {'charRange':
  3. {'$gt': 0},
  4. 'countPar':
  5. {'$gte': 0}
  6. },
  7.  
  8. {'$group':
  9. {'_id':
  10. {'charRange': '$charRange', 'parNr': '$countPar'},
  11. 'count':
  12. {'$sum': 1}
  13. }
  14. },
  15.  
  16. {'$project':
  17. {'optimalCredit':
  18. {'$cond':
  19. {'if':
  20. {'$gt': [
  21. {'$avg': 'credit'},
  22. {'$stdDevPop': 'credit'}
  23. ]
  24. },
  25. 'then':
  26. {'$avg': '$credit'},
  27. 'else':
  28. {'$stdDevPop': '$credit'}
  29. }
  30. }
  31. }
  32. },
  33.  
  34. {'$sort':
  35. {'optimalCredit': -1}
  36. }
  37.  
  38. {'$match':
  39. {'charRange':
  40. {'$gt': 0},
  41. 'countPar':
  42. {'$gte': 0},
  43. }
  44. },
  45.  
  46. {'$group':
  47. {'_id':
  48. {'charRange': '$charRange', 'parNr': '$countPar'},
  49. 'creditAvg':
  50. {'$avg': '$credit'},
  51. 'creditStdDev':
  52. {'$stdDevPop':'$credit'},
  53. 'count': {'$sum': 1}
  54. }
  55. }
  56.  
  57. {'_id': {'parNr': 7, 'charRange': 1500}, 'optimalCredit': None}
  58.  
  59. {'_id': {'charRange': 1500, 'parNr': 7}, 'creditStdDev': 19.430788855719562, 'count': 9, 'creditAvg': 16.0}
  60.  
  61. {'_id': {'parNr': 7, 'charRange': 1500}, 'count': 9, 'optimalCredit': 19.430788855719562}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement