Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Geodatabases In ArcGIS Pro

Authors: David W. Allen

1st Edition

1589484452, 978-1589484450

More Books

Students also viewed these Databases questions