Pie Chart in Plotly with Dropdown

Hi,
The idea is to create a pie chart with a drop-down, whenever I value is selected in the drop-down the pie-chart should get updated accordingly
Sample Data :
Column1 Column2 Column3
A Y 10
A N 90
B Y 80
B N 20

So for every Column1 value I want to populate the drop-down field and with that, I should get a pie-chart with values corresponding to Column3, Y and N are my labels.

Thanks,