Guest User

Untitled

a guest
Jan 22nd, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.03 KB | None | 0 0
  1. df =
  2. GROUP HOUR AVG_MINUTES AVG_GRADE
  3. AAA 7 67 5.5
  4. AAA 8 58 6.5
  5. AAA 9 55 4.5
  6. BBB 7 15 5.1
  7. BBB 8 18 5.4
  8. CCC 9 34 5.5
  9.  
  10. [
  11. {
  12. "GROUP":"AAA",
  13. "AVG_MINUTES":[[7,67],[8,58],[9,55]],
  14. "AVG_GRADE":[[7,5.5],[8,6.5],[9,4.5]]
  15. },
  16. {
  17. "GROUP":"BBB",
  18. "AVG_MINUTES":[[7,15],[8,18],[9,34]],
  19. "AVG_GRADE":[[7,5.1],[8,5.4],[9,5.5]]
  20. }
  21. ]
  22.  
  23. df.AVG_MINUTES = df[['HOUR','AVG_MINUTES']].values.tolist()
  24. df.AVG_GRADE = df[['HOUR','AVG_GRADE']].values.tolist()
  25.  
  26. print (df)
  27. GROUP HOUR AVG_MINUTES AVG_GRADE
  28. 0 AAA 7 [7, 67] [7.0, 5.5]
  29. 1 AAA 8 [8, 58] [8.0, 6.5]
  30. 2 AAA 9 [9, 55] [9.0, 4.5]
  31. 3 BBB 7 [7, 15] [7.0, 5.1]
  32. 4 BBB 8 [8, 18] [8.0, 5.4]
  33. 5 CCC 9 [9, 34] [9.0, 5.5]
  34.  
  35. df = df.groupby('GROUP')['AVG_MINUTES','AVG_GRADE']
  36. .agg(lambda x : x.tolist())
  37. .reset_index()
  38. .to_dict(orient='records')
  39. print (df)
  40. [
  41. {'GROUP': 'AAA',
  42. 'AVG_GRADE': [[7.0, 5.5], [8.0, 6.5], [9.0, 4.5]],
  43. 'AVG_MINUTES': [[7, 67], [8, 58], [9, 55]]},
  44. {'GROUP': 'BBB',
  45. 'AVG_GRADE': [[7.0, 5.1], [8.0, 5.4]],
  46. 'AVG_MINUTES': [[7, 15], [8, 18]]},
  47. {'GROUP': 'CCC',
  48. 'AVG_GRADE': [[9.0, 5.5]],
  49. 'AVG_MINUTES': [[9, 34]]}
  50. ]
  51.  
  52. df.AVG_MINUTES = list(map(list, zip(df.HOUR, df.AVG_MINUTES)))
  53. df.AVG_GRADE = list(map(list, zip(df.HOUR, df.AVG_GRADE)))
  54.  
  55. print (df)
  56. GROUP HOUR AVG_MINUTES AVG_GRADE
  57. 0 AAA 7 [7, 67] [7, 5.5]
  58. 1 AAA 8 [8, 58] [8, 6.5]
  59. 2 AAA 9 [9, 55] [9, 4.5]
  60. 3 BBB 7 [7, 15] [7, 5.1]
  61. 4 BBB 8 [8, 18] [8, 5.4]
  62. 5 CCC 9 [9, 34] [9, 5.5]
  63.  
  64. df = df.groupby('GROUP')['AVG_MINUTES','AVG_GRADE']
  65. .agg(lambda x : x.tolist())
  66. .reset_index()
  67. .to_json(orient='records')
  68. print (df)
  69. [{"GROUP":"AAA",
  70. "AVG_MINUTES":[[7,67],[8,58],[9,55]],
  71. "AVG_GRADE":[[7,5.5],[8,6.5],[9,4.5]]},
  72. {"GROUP":"BBB",
  73. "AVG_MINUTES":[[7,15],[8,18]],
  74. "AVG_GRADE":[[7,5.1],[8,5.4]]},
  75. {"GROUP":"CCC",
  76. "AVG_MINUTES":[[9,34]],
  77. "AVG_GRADE":[[9,5.5]]}]
Add Comment
Please, Sign In to add comment