Please use Python script to solve below and attached please kindly find the datasets.

Data contains the details of over 11,000 athletes, with 47 disciplines, along with 743 Teams taking part in the 2021(2020) Tokyo Olympics. This dataset includes the details of the Athletes, Coaches, Teams participating as well as the Entries by gender. It contains their names, countries represented, discipline, gender of competitors, name of the coaches. There are 5 datasets in xlsx format: Athletes.xlsx: Contains details about the participating Athletes Coaches.xlsx: Details about coaches, countries and disciplines along with event EntriesGender.xlsx: Details about the Discipline and the number of females and males participating Medals.xlsx: Contains the Medals and Scoreboard of countries that participated in Tokyo Olympics Teams.xlsx: Details about the Teams, discipline, Name of Country and the event 1. Read the 5 xlsx to be your pandas data frame into your kernel. 2. In Athletes. xlsx and Coaches.xlsx, how many athletics (Discipline = "Athletics") where the NOC of athletics and coaches are different. 3. In EntriesGender.xlsx, please find the top 5 disciplines having highest proportions of females. 4. In Medals. xlsx, please draw a stacked bar chart, medals no. against countries, having appropriate colors for various medal types, ordering countries by rank in t dataset. Show top 30 countries only. 5. In Teams.xlsx, how many countries where the names are different from NOC ? please show results with Python code