df1
A B
a 1
a 1
a 4
b 1
b 3
df2
A B
a 1
a 2
c 3
c 5
df1.groupby("A").size()
a 3
b 2
df2.groupby("A").size()
a 2
c 2
I'd like to get following sizeaggregation
df1 df2
a 3 2
b 2 0
c 0 2
Are there any way to achieve this? I'd like to know aggregation method.
If someone has opinion,please let me know. Thanks