In this project you will be using the Foreign Pilgrims During Hajj Data provided from the General Authority for Statistics of Saudi Arabia to carry out analysis. The data contains the number of Foreign Pilgrims per country based on gender for the years 1433-1440 H. The project must be completed in a report style, meaning you should explain each step or output within your code. For this purpose, you can use the text cells in Google Collaboratory to explain your work. The first cell must be a text cell containing the names and IDs of your group members. Feel free to style the figures as you like. The specific requirements are given in the following.

1. Import the file (hajj_stats.xlsx) as a pandas DataFrame.

2. Replace the values of the Hijri Years to the corresponding Gregorian year. (Example: replace 1435 with 2014)

3. Capitalize the first character of each value in the Nationality column.

Create a new DataFrame object that compares the total number of Males and Females for Foreign Pilgrims per year. (Hint: use the groupby function and sum) .4

Create a Line Plot Figure with a circle marker ('o') containing the data from the new object you created from the previous step. Save the figure as a png file.5

6. Create a Pie Chart comparing Male and Female Pilgrims for the year 2015. Save the figure as a png file.

7. Create a new column Total that contains the sum of Male and Female pilgrims from each row.

8. Create a Bar Plot showing the total foreign pilgrims per Year. Save the figure as a png file.

9. Using Hierarchical Indexing, set the index of the main DataFrame from the columns (Year, Nationality). Make sure it is done in that same order.

10. Print the new DataFrame to the screen and export it as a csv file.

this is excal link

https://sg.docworkspace.com/l/sIDrqvMWMAfz_5J4G