University of Nairobi Accident of the Titanic and the Iceberg Questions

Using a new Jupyter notebook, analyze the partial list of Titanic passengers (titanic.csv (Links to an external site.)) with pandas.

Answer the following three questions:

1. What was the average cost in U.S. dollars of a first-class ticket? (See Note 1.)
2. How many passengers over 20 had siblings onboard? (See Note 2.)
3. What was the median age of those who did not survive?

Then, create and answer three additional questions using the Titanic passengers’ data.

Create the following three graphs and three additional graphs of your own choice using matplotlib. Use colors to enhance your graphs.

1. Use a pie chart to show the number of males and females.
2. Use a bar chart to show the count of male survivors and the count of female survivors.
3. Use a bar chart to show the count of each age.

Note 1: Use £1.00 British pound = $1.28 U.S. dollars.

Note 2: The dataset contains two fields that have mixed data: The Siblings/Spouse Aboard and the Parents/Children Aboard. Use the age of 20 as the threshold for differentiating the data in both fields. For example, if the age is 19, then interpret the number in Siblings/Spouse Aboard as siblings aboard. But if the age is 20, then interpret the number as spouse aboard unless the number is greater than 1, then interpret the number as siblings aboard.

Capture as many screenshots as necessary to demonstrate successful completion of all the assigned tasks. One screenshot can be used to demonstrate more than one task. Ensure the code is large enough in the screenshots to be readable in your Word document submission.

All code must be explained in the narrative of your paper.

Submit one Word document with your screenshots demonstrating successful completion of the above items. In addition to the screenshots, include a description of lessons you learned from this exercise.

Your paper should be 2-3 pages in length, not including the title and reference pages, and conform to the CSU Global Writing Center (Links to an external site.). Support your lessons learned with at least two scholarly references in addition to the course textbook. The CSU Global Library (Links to an external site.) is a good place to find these references.