Insights from Avengers Dataset
Dataset analysis of Avengers' appearances, gender, status, and years since joining. Obtained from data.world, the dataset consists of 173 records capturing various details about Avengers characters. Methods for examining appearances, gender distribution, status types, and years since joining were applied to derive statistical insights. The dataset was cleaned and presented in a structured manner, providing valuable information for further research and analysis.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Avengers Dataset Sarah Baskey DSCI 101.002
Avengers Dataset I hoped to pull interesting statistics and uncommonly known details about the Avengers characters.
The Dataset This dataset was obtained from data.world, specifically https://data.world/fivethirtyeight/avengers. It was collected and contributed from @fivethirtyeight, who pulled it from marvel.wikia.com. The data consists of 173 records each containing 12 fields. Originally downloaded as a .csv file 26.99KB file
My Data Appearances The number of comic books that character appeared in as of April 30, 2015 Gender The recorded gender of the character Status The status of the avenger, if they were given "Honorary" Avenger status, if they are simply in the "Academy," or "Full" otherwise Year The year the character was introduced as a full or reserve member of the Avengers Years since joining 2015 minus the year Current Is the member currently active on an avengers affiliated team Death Yes if the Avenger died, No if not Return Yes if the Avenger returned from their first death, No if they did not, blank if not applicable
Methods -Appearances Frequency of Appearances 140 130 Five Number Summary Appearances 120 100 Frequency Min 2 80 60 Max 4333 40 Q1 58 23 20 8 4 4 4 Q2 132 0 0 0 0 500 1000 Number of Appearances 1500 2000 2500 3000 <3000 Q3 491
Methods -Gender MALE 115 FEMALE 58 Gender of Avenger 140 120 100 80 Count 60 Male 40 Female 20 0
Methods -Status Academy 17 Full 138 Honorary 16 Probationary 2 Avenger Status 140 138 120 100 80 Count 60 40 20 17 16 2 0 Academy Full Honorary Probationary Status Type
Methods -Years Five Number Summary of Year Frequency of Years Since Joining Avengers Min 1900 80 70 76 Max 2015 60 Frequency 50 Q1 1979 40 Q2 1996 30 34 20 Q3 2010 21 21 10 2 9 10 0 Five Number Summary of Years Since Joining 0 10 20 30 40 50 <50 Years Since Joining Avengers Min 0 Max 115 Q1 5 Q2 19 Q3 36
Problems with Data Don t waste time on the probationary introl and full/reserve avengers intro columns. There is not much to pull from these two columns of data. I could not figure out a formula or function to find the discrepancy between the current, death and return columns, so I did that entire column by typing in each cell individually.
Conclusion I found that 104 out of 173 characters have died at least once during their appearances. I found there were 115 male characters verse 58 female characters. I found that the most amount of characters have been introduced between 2005 and 2015. Furthermore, fourteen characters were introduced in 1900. Another interesting statistics is most of the Avenger characters have made 500 or less appearances over the years.
Future Work If I had more time and skill I would work with the data I originally deleted; death and returns 2 through death and returns 5. Even though that data is sparse, it could be used to pull something interesting together. I would also have tried to figure out a way to add in a pivot table to the data. I didn t leave anything unfinished that I started.
Questions or Comments? Thank you!
