Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)

[hayathbasha]

Hi,

Is it possible to convert below the input

Customer_Name, Product_1, Price_1, Product_2, Price_2
Zayn, Milk, 30, Chocolate, 40
Peter, Cheese, 190, Oil, 80
Andrew, Coconut, 10, Milk, 60
Dwayne, Soya, 100, Butter, 120

to this output where the Product name should be ascending and it should also have its price in the next column

Customer_Name, Product_1, Price_1, Product_2, Price_2
Zayn, Chocolate, 40, Milk, 30
Peter, Cheese, 190, Oil, 80
Andrew, Coconut, 10, Milk, 60
Dwayne, Butter, 120, Soya, 100


Can you please help