Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ python37
- Python 3.7.0 (default, Jul 26 2018, 06:52:13)
- [GCC 6.3.0] on linux
- Type "help", "copyright", "credits" or "license" for more information.
- >>> import pandas as pd
- >>> df = pd.DataFrame({'PlaceTest':[21,21,22,22], 'Approved':[1,0,1,0]})
- >>> df
- PlaceTest Approved
- 0 21 1
- 1 21 0
- 2 22 1
- 3 22 0
- >>> df['Not Approved'] = df.groupby('PlaceTest')['Approved'].sum()
- >>> df
- PlaceTest Approved Not Approved
- 0 21 1 NaN
- 1 21 0 NaN
- 2 22 1 NaN
- 3 22 0 NaN
- >>> df = df.groupby('PlaceTest')['Approved', 'Not Approved'].sum().fillna("1").reset_index()
- >>> df
- PlaceTest Approved Not Approved
- 0 21 1 0.0
- 1 22 1 0.0
- >>> pd.__version__
- '0.23.3'
Add Comment
Please, Sign In to add comment