How to use python to draw pivot chart similar to excel pivot plot?

Question

I want to create a pivot chart plot using python and below is the data format(csv file)

below is the pivot chart plot using excel:

The code I used to generate pivot chart:

expect to see the same result as excel plot

As you can see from the figure created from python is not what I expected. Any solutions for this problem?

Thank you very much!