I am trying to plot the data below in a pie chart. I split the pie chart based on the group first and then based on the Id. But since for some rows, the count is very small, I am not able to see it in the pie chart.
I am trying to normalise the data. I am not sure on how to do that. Any help would be sincerely appreciated.
Group Id Count
G1 12 276938
G1 13 102
G2 12 27
G3 12 4683
G3 13 7
G4 12 301
Don't pie chart what doesn't fit a visual representation in a pie chart
( df.groupby(['Group', 'Id']) .sum().Count.sort_values(ascending=False) .plot.bar(logy=True, subplots=True) )