Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. >>> from pandas import Series, DataFrame
  2. >>> import pandas as pd
  3. >>> df = pd.DataFrame({'class': ['A', 'B', 'C'], 'count':[1,0,2]})
  4. >>> print(df)
  5. class count
  6. 0 A 1
  7. 1 B 0
  8. 2 C 2
  9.  
  10. >>> for group in df.groupby('class', group_keys = True):
  11. >>> print(group)
  12. ('A', class count
  13. 0 A 1)
  14. ('B', class count
  15. 1 B 0)
  16. ('C', class count
  17. 2 C 2)
  18.  
  19. >>> def checkit(group):
  20. >>> print(group)
  21. >>> df.groupby('class', group_keys = True).apply(checkit)
  22. class count
  23. 0 A 1
  24. class count
  25. 0 A 1
  26. class count
  27. 1 B 0
  28. class count
  29. 2 C 2
  30.  
  31. >>> def addone(group):
  32. >>> group['count'] += 1
  33. >>> return group
  34.  
  35. >>> df.groupby('class', group_keys = True).apply(addone)
  36. >>> print(df)
  37.  
  38. class count
  39. 0 A 1
  40. 1 B 0
  41. 2 C 2
  42.  
  43. class count
  44. 0 A 2
  45. 1 B 1
  46. 2 C 3
  47.  
  48. guestid,keyword
  49. 1,null
  50. 2,null
  51. 2,null
  52. 3,null
  53. 3,null
  54. 3,null
  55. 4,null
  56. 4,null
  57. 4,null
  58. 4,null
  59.  
  60. df=pd.read_csv("log_sample.csv")
  61. grouped = df.groupby("guestid")
  62.  
  63. for guestid, df_group in grouped:
  64. print(list(df_group['guestid']))
  65.  
  66. df.head(100)
  67.  
  68. [1]
  69. [2, 2]
  70. [3, 3, 3]
  71. [4, 4, 4, 4]
  72.  
  73. df = pd.DataFrame({"a": ["x", "y"], "b": [1, 2]})
  74.  
  75. def func(group):
  76. print(group.name)
  77. return group
  78.  
  79. df.groupby('a').apply(func)
  80. x
  81. y
  82.  
  83. a b
  84. 0 x 1
  85. 1 y 2
  86.  
  87. df.groupby('a').apply(func)
  88. x
  89. x
  90. y
  91.  
  92. a b
  93. 0 x 1
  94. 1 y 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement