pandas

>>> df = pd.DataFrame({'PlaceTest':[21,21,22,22], 'Approved':[1,0,1,0]})
>>> df
   Approved  PlaceTest
0         1         21
1         0         21
2         1         22
3         0         22
>>> df['Not Approved'] = df.groupby('PlaceTest')['Approved'].sum()

>>> df
   Approved  PlaceTest  Not Approved
0         1         21           NaN
1         0         21           NaN
2         1         22           NaN
3         0         22           NaN
>>> df = df.groupby('PlaceTest')['Approved', 'Not Approved'].sum().fillna("1").reset_index()
>>> df
   PlaceTest  Approved Not Approved
0         21         1            1
1         22         1            1