knitr::include_graphics("Imagem4.jpg")

1. Contexto

Harry Potter é uma série de 7 livros de fantasia escrita pela autora J.K Rowling, que foram adaptados em 8 longas cinematográficos. Desde o lançamento do primeiro romance, “Harry Potter e a Pedra Filosofal”, em 26 de junho de 1997, os livros ganharam uma imensa popularidade, aclamação da crítica e foram um sucesso comercial em todo o mundo. Até maio de 2015, já haviam sido vendidas 450 milhões de cópias ao redor do mundo, tornando a série um best-seller, sendo traduzida para 73 idiomas.

2. História

A história dos livros e filmes se passam ao redor do jovem órfão Harry James Potter, que descobre em seu aniversário de 11 anos que é um bruxo. O menino vai para o mundo da magia, onde poderá estudar na Escola de magia e bruxaria de Hogwarts. Os livros vão acompanhar as aventuras do Harry ao longo de sua adolescência onde ele deverá aprender a superar seus problemas como bruxo na escola de bruxaria, no mundo mágico e os problemas de qualquer adolescente comum como: amizades, paixões e a puberdade.

A Escola de Magia e Bruxaria de Hogwarts foi fundada por quatro grandes bruxos: Godrico Gryffindor, Helga Hufflepuff, Rowena Ravenclaw e Salazar Slytherin. Suas personalidades e os critérios para admissão no ensino deram origem a quatro casas, conforme seus sobrenomes, para abrigar os estudantes.

Os alunos são encaminhados para uma das Casas por meio da decisão do Chapéu Seletor, um artefato mágico capaz de ler a ambição de um indivíduo. Seu julgamento, por vezes impreciso, leva os estudantes para uma das quatro casas de Hogwarts: Grifinória, Sonserina, Lufa-Lufa e Corvinal .

knitr::include_graphics("Imagem2.png")

3. Objetivo

O presente trabalho objetiva analisar a relação entre as casas da Escola de Magia e Bruxaria de Hogwarts e os seguintes aspectos:

  • Personagens;
  • Gênero;
  • Status Sanguíneo.

4. Metodologia

Base de dados.

A base de dados utilizada foi retirada do site Kaggle a partir do link a seguir: https://www.kaggle.com/datasets/gulsahdemiryurek/harry-potter-dataset?select=Characters.csv.

Esta base de dados foi renomeada para HarryPotter e é mostrada abaixo

library(dplyr)
library(ggplot2)
library(ggthemes)
library(flextable)
library(corrplot)
library(janitor)
library(RColorBrewer)
library(kableExtra)
library(DT)

library(readr)
HarryPotter <- read_delim("C:/Users/wandr/OneDrive/Documentos/ENEM_UNIRIO/2022.2/R/HarryPotter/Characters.csv", 
                          delim = ";", escape_double = FALSE, trim_ws = TRUE)

kable(HarryPotter, row.names = FALSE)%>%
  kable_styling( full_width = T,bootstrap_options = c("striped", "hover", "condensed", "responsive"), 
                 position = "center", fixed_thead = T) %>%
  scroll_box(width = "900px", height = "600px")
Id Name Gender Job House Wand Patronus Species Blood status Hair colour Eye colour Loyalty Skills Birth Death
1 Harry James Potter Male Student Gryffindor 11”” Holly phoenix feather Stag Human Half-blood Black Bright green Albus Dumbledore | Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Parseltongue| Defence Against the Dark Arts | Seeker 31 July 1980 NA
2 Ronald Bilius Weasley Male Student Gryffindor 12”” Ash unicorn tail hair Jack Russell terrier Human Pure-blood Red Blue Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Wizard chess | Quidditch goalkeeping 1 March 1980 NA
3 Hermione Jean Granger Female Student Gryffindor 10¾”” vine wood dragon heartstring Otter Human Muggle-born Brown Brown Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Almost everything 19 September, 1979 NA
4 Albus Percival Wulfric Brian Dumbledore Male Headmaster Gryffindor 15”” Elder Thestral tail hair core Phoenix Human Half-blood Silver| formerly auburn Blue Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Considered by many to be one of the most powerful wizards of his time Late August 1881 30 June, 1997 
5 Rubeus Hagrid Male Keeper of Keys and Grounds | Professor of Care of Magical Creatures Gryffindor 16”” Oak unknown core None Half-Human/Half-Giant Part-Human (Half-giant) Black Black Albus Dumbledore | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Resistant to stunning spells| above average strength | crossbowmanship 6 December 1928 NA
6 Neville Longbottom Male Student Gryffindor 13”” Cherry unicorn hair Non-corporeal Human Pure-blood Blond NA Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Herbology 30 July, 1980 NA
7 Fred Weasley Male Student Gryffindor Unknown Unknown Human Pure-blood Red Brown Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Beater 1 April, 1978  2 May, 1998
8 George Weasley Male Student Gryffindor Unknown Unknown Human Pure-blood Red Brown Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Beater 1 April, 1978  NA
9 Ginevra (Ginny) Molly Weasley Female Student Gryffindor Unknown Horse Human Pure-blood Red Bright brown Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Chaser| Bat-Bogey hex 11 August, 1981 NA
10 Dean Thomas Male Student Gryffindor Unknown Unknown Human Muggle-born Black Brown Dumbledore’s Army | Hogwarts School of Witchcraft and Wizardry Chaser  1 September 1979- 31 August 1980 NA
11 Seamus Finnigan Male Student Gryffindor Unknown Fox Human Half-blood Sandy NA Dumbledore’s Army | Hogwarts School of Witchcraft and Wizardry Pyrotechnics  1 September 1979- 31 August 1981 NA
12 Lily J. Potter Female NA Gryffindor 10¼”” Willow unknown core Doe Human Muggle-born Auburn Bright green Order of the Phoenix NA 30 January, 1960  31 October, 1981
13 James Potter Male NA Gryffindor 11”” Mahogany unknown core Stag Human Pure-blood Black Hazel Order of the Phoenix Animagus| Seeker 27 March, 1960 31 October, 1981
14 Sirius Black Male NA Gryffindor Unknown Unknown Human Pure-blood Black Grey Order of the Phoenix Animagus| nonverbal magic| Charms 3 November, 1959 18 June, 1996
15 Remus John Lupin Male Professor of Defence Against the Dark Arts  Gryffindor 10¼”” Cypress unicorn hair Wolf Werewolf Half-blood Light brown flecked with grey Green Order of the Phoenix Exceptionally gifted in Defence Against the Dark Arts 10 March, 1960 2 May, 1998
16 Peter Pettigrew Male The Servant of Lord Voldemort Gryffindor 9¼”” Chestnut dragon heartstring None Human Half-blood or pure-blood Colourless and balding Blue Lord Voldemort| Death Eaters Animagus 1 September 1959- 31 August 1960 Late March 1998
17 Percy Ignatius Weasley Male Student|Prefect| Personal assistant to Barty Crouch Snr Gryffindor Unknown Unknown Human Pure-blood Red Blue Order of the Phoenix| Hogwarts School of Witchcraft and Wizardry |British Ministry of Magic Intelligent| hard-working| a model student 22 August, 1976  NA
18 (Bill) William Arthur Weasley Male Curse-Breaker for Gringotts Bank Gryffindor Unknown Unknown Human (Werewolf traits) Pure-blood Red Blue Order of the Phoenix Highly skilled curse-breaker for Gringotts Wizarding Bank| very intelligent| past Hogwarts Head Boy 29 November, 1970 NA
19 Charles Weasley Male Dragonologist Gryffindor 12”” Ash unicorn tail hair Unknown Human Pure-blood Red Grey Order of the Phoenix | Gringotts Wizarding Bank Highly skilled dragon trainer| one-time Gryffindor Seeker 12 December, 1972 NA
20 Lee Jordan  Male Student Gryffindor Unknown Unknown Human Pure-blood or half-blood Black Brown Dumbledore’s Army | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Quidditch commentary | broadcasting  1 September 1977- 31 August 1978 NA
21 Oliver Wood Male Student Gryffindor Unknown Unknown Human Pure-blood or Half-blood NA NA Hogwarts School of Witchcraft and Wizardry Keeper| Captain of the Gryffindor Quidditch team  October 1975 - 31 August 1976 NA
22 Angelina Johnson Female Student Gryffindor Unknown Unknown Human Unknown Brown Brown Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Chaser 24 – 30 October, 1977 NA
23 Katie Bell Female Student Gryffindor Unknown Unknown Human Pure-blood or half-blood Brown Brown Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Chaser  1 September 1978- 31 August 1979 NA
24 Alicia Spinnet Female Student Gryffindor Unknown Unknown Human Pure-blood or half-blood Brown Brown Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Chaser 1 September 1977- 31 August 1978 NA
25 Lavender Brown Female Student Gryffindor Unknown Unknown Human Pure-blood Blond Blue Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Divination  1 September 1979- 31 August 1980 2 May, 1998
26 Parvati Patil Female Student Gryffindor Unknown Unknown Human Pure-blood or half-blood Dark Dark Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Divination  1 September 1979- 21 April 1980 NA
27 Romilda Vane Female Student Gryffindor Unknown Unknown Human Pure-blood or half-blood Black Dark Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Spiking Chocolate Cauldrons with love potion  1 September 1981- 31 August 1982 NA
28 Colin Creevey Male Student Gryffindor Unknown Unknown Human Muggle-born Mousy NA Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Photography  3 May - 31 August 1981 2 May, 1998
29 Cormac McLaggen Male Student Gryffindor Unknown Unknown Human Pure-blood or half-blood Blond NA Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Quidditch Keeper  1 September 1978- 31 August 1979 NA
30 Minerva McGonagall Female Professor of Transfiguration | Head of Gryffindor Gryffindor 9½”” Fir dragon heartstring Cat Human Half-blood Black Green Albus Dumbledore | Order of the Phoenix | Hogwarts School of Witchcraft and Wizardry Animagus  4 October NA
31 Molly Weasley Female NA Gryffindor Unknown Unknown Human Pure-blood Red Bright brown Order of the Phoenix Household spells| healing magic 30 October, 1949  NA
32 Arthur Weasley Male Head of the Misuse of Muggle Artefacts Office Gryffindor Unknown Weasel Human Pure-blood Red Green Order of the Phoenix| British Ministry of Magic Muggle world works 6 February, 1950 NA
33 Quirinus Quirrell Male Defence Against the Dark Arts(1991-1992) Ravenclaw 9”” Alder unicorn hair bendy Non-corporeal Human Half-blood NA NA Lord Voldemort Learned in the theory of Defensive Magic| less adept in the practise 26 September,1970 or earlier 4 June 1992
34 Cho Chang Female Student Ravenclaw Unknown Swan Human Pure-blood or half-blood Black Dark Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Seeker 1 September 1978-31 August 1979 NA
35 Luna Lovegood Female Student Ravenclaw Unknown Hare Human Pure-blood or half-blood Dirty-blonde Pale silvery Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Spotting Nargles 13 February, 1981 NA
36 Gilderoy Lockhart Male Defence Against the Dark Arts(1992-1993) Ravenclaw 9”” Cherry dragon heartstring Non-corporeal Human Half-blood Blond Blue NA NA 26 January 1964 NA
37 Filius Flitwick Male Professor of Charms | Head of Ravenclaw Ravenclaw Unknown Non-corporeal Human(goblin ancestry) Part-Goblin White NA NA Charms 17 October 1958 or earlier  NA
38 Sybill Patricia Trelawney Female Professor of Divination Ravenclaw 9 ½” hazel unicorn hair core Non-corporeal Human Half-blood NA NA NA A Seer, though the gift is unpredictable and unconscious 9 March prior to 1962 NA
39 Garrick Ollivander Male Wandmaker Ravenclaw 12¾”” Hornbeam dragon heartstring Non-corporeal Human Half-blood NA Silvery NA An incomparable understanding of wandcraft 25 September, pre 1908 NA
40 Myrtle Elizabeth Warren (Moaning Myrtle) Female Student Ravenclaw Unknown Unknown Ghost Muggle-born NA NA NA NA 14 June 1928 -13 June 1929 13 June, 1943
41 Padma Patil Female Student Ravenclaw Unknown Non-corporeal Human Pure-blood or half-blood Dark Dark Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Prefect  1 September 1979 - 21 April 1980 NA
42 Michael Corner Male Student Ravenclaw Unknown Squirrel Human Half-blood Black Brown Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Potions  1 September 1979 - 31 August 1980 NA
43 Marietta Edgecombe Female Student Ravenclaw Unknown Unknown Human Pure-blood or half-blood Reddish-blonde Grey NA Covering up the spots that blight her face after betraying Dumbledore’s Army 1978-1979 NA
44 Terry Boot Male Student Ravenclaw Unknown Unknown Human Pure-blood or half-blood NA NA Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Potions, also knowledgable about Charms 1 September 1979- 21 April 1980 NA
45 Anthony Goldstein Male Student Ravenclaw Unknown Non-corporeal Human Half-blood Blonde Grey Dumbledore’s Army |Hogwarts School of Witchcraft and Wizardry Prefect  1 September 1979- 31 August 1980 NA
46 Severus Snape Male Professor of Potions | Head of Slytherin Slytherin Unknown Doe Human Half-blood Black Black NA Extremely skilled at potions and Occlumency 9 January 1960 2 May, 1998
47 Draco Malfoy Male Student Slytherin 10”” Hawthorn unicorn hair Unknown Human Pure-blood White-blond Grey NA Prefect, Seeker 5 June, 1980 NA
48 Vincent Crabbe Male Student Slytherin Unknown Unknown Human Pure-blood Black Black NA Beater
  1. 1979-1980
2 May, 1998
49 Gregory Goyle Male Student Slytherin Unknown Unknown Human Pure-blood Brown NA NA Beater 1 September 1979-31 August 1980 NA
50 Bellatrix Lestrange Female NA Slytherin 12¾”” Walnut dragon heartstring NA Human Pure-blood Black NA Lord Voldemort  | Death Eaters She is a duellist of great skill and an experienced Occlumens 1951 2 May, 1998
51 Dolores Jane Umbridge Female Professor of Defence Against the Dark Arts | Department of Magical Law Enforcement Slytherin 8”” Birch dragon heartstring Cat Human Half-blood Iron grey NA Ministry of Magic Her punishment quill is of her own invention 26 August NA
52 Horace Eugene Flaccus Slughorn NA Professor of Potions Slytherin 10¼”” Cedar dragon heartstring fairly flexible Non-corporeal Human Pure-blood or half-blood Bald Gooseberry NA Accomplished Occlumens, expert Potioneer, advanced self-transfiguration 28 April NA
53 Lucius Malfoy Male School Governor Slytherin Elm and dragon heartstring Unknown Human Pure-blood White-blond Grey Lord Voldemort  | Death Eaters Skilled duellist and potioneer
  1. 1954
NA
54 Narcissa Malfoy Female NA Slytherin Unknown Unknown Human Pure-blood Blonde Blue Lord Voldemort  | Death Eaters NA 1955 NA
55 Regulus Arcturus Black Male NA Slytherin Unknown Non-corporeal Human Pure-blood Black NA NA Seeker 1961 1979
56 Pansy Parkinson Female Student Slytherin Unknown Unknown Human Pure-blood or half-blood NA NA NA Prefect  1 September 1979- 31 August 1980 NA
57 Blaise Zabini Male Student Slytherin Unknown Unknown Human Pure-blood or half-blood Black Brown NA Chaser 1 September, 1979 – 21 April, 1980 NA
58 Tom Marvolo Riddle Male Student Slytherin 13½”” Yew phoenix feather core Unknown Human Half-blood Bald Scarlet  NA Dark Lord, Outstanding manipulation, Parseltongue, Heir of Slytherin, Dark magic, Inferi creation and control 31 December 1926 2 May, 1998
59 Theodore Nott Male Student Slytherin Unknown Unknown Human Pure-blood Brown NA NA NA 1 September, 1979 – 21 April, 1980 NA
60 Rodolphus Lestrange Male NA Slytherin Unknown Unknown Human Pure-blood Dark Dark Lord Voldemort  | Death Eaters NA Pre 1964 NA
61 Millicent Bulstrode Female Student Slytherin Unknown Unknown Human Half-blood Black NA NA NA 1 September 1979- 31 August 1980  NA
62 Graham Montague Male Student Slytherin Unknown Unknown Human Pure-blood or half-blood Brown Brown NA Quidditch captain, Chaser In or prior to c.1981 NA
63 Bloody Baron Male Slytherin House Ghost Slytherin Unknown Unknown Ghost Pure-blood or half-blood NA NA NA Controlling Peeves Post 982 11th century
64 Marcus Flint Male Student Slytherin Unknown Unknown Human Pure-blood or half-blood Black NA NA Chaser, Captain  1 September 1975- 31 August 1976 NA
65 Penelope Clearwater Female Student Ravenclaw Unknown Non-corporeal Human Muggle-born or half-blood[ Blonde NA NA Prefect  1 September 1975- 31 August 1976 NA
66 Roger Davies Male Student Ravenclaw Unknown Unknown Human NA Dark Dark NA Quidditch Captain, Chaser  1 September 1977- 31 August 1978 NA
67 Marcus Belby Male Student Ravenclaw Unknown Unknown Human Pure-blood or half-blood Brown Dark NA NA  1 September 1978 - 31 August 1979 NA
68 Salazar Slytherin Male Founder of Slytherin Slytherin snakewood, Basilisk horn Unknown Human Pure-blood Grey Dark NA Accomplished Legilimens and one of the first recorded Parselmouths Pre 976 11th century
69 Godric Gryffindor Male Founder of Gryffindor Gryffindor Unknown Unknown Human Pure-blood or half-blood Red Green NA The most accomplished duellist of his time Pre 976 11th century
70 Rowena Ravenclaw Female Founder of Ravenclaw Ravenclaw Unknown Unknown Human Pure-blood or half-blood Black Dark NA Extremely skilled witch, known for her intelligence and wisdom Pre 976 11th century
71 Nicholas de Mimsy-Porpington Male Gryffindor House Ghost Gryffindor Unknown Unknown Ghost NA Grey NA NA NA 1401 -1475 31 October, 1492
72 Cuthbert Binns Male Professor of History of Magic  NA Unknown Unknown Ghost NA White (balding) Black NA Boring a class with facts that might be interesting if anyone else was giving the lesson NA Pre 1970s
73 Barty Crouch Jr.  Male Professor of Defence Against the Dark Arts (as Alastor Moody)  NA Unknown Unknown Human Pure-blood or half-blood Straw blond Pale, freckled Lord Voldemort  | Death Eaters Skilled potioneer 1962 1995-1996
74 Charity Burbage Female Professor of Muggle Studies NA Unknown Non-corporeal Human Pure-blood or half-blood Blonde NA NA Teaching and studying the Muggle world Before 1976 Late July, 1997
75 Firenze Male Professor of Divination NA NA NA Centaur NA White-blond Astonishingly blue NA NA NA NA
76 Alecto Carrow Female Professor of Muggle Studies Slytherin Unknown Unknown Human Pure-blood or half-blood NA NA Lord Voldemort  | Death Eaters Spreading anti-Muggle propaganda Pre 1981 NA
77 Amycus Carrow Male Professor of Dark Arts Slytherin Unknown Unknown Human Pure-blood or half-blood NA NA Lord Voldemort  | Death Eaters Cruciatus Curse Pre 1982 NA
78 Helga Hufflepuff Female Founder of Hufflepuff Hufflepuff Unknown Unknown Human Pure-blood or half-blood Brown Blue NA Food-related Charms. Many traditional Hogwarts recipes originated with her Pre 976 11th century
79 Fat Friar Male Hufflepuff House Ghost Hufflepuff Unknown Unknown Ghost NA Brown NA NA Curing peasants of the pox 10th century Pre 1988
80 Helena Ravenclaw Female Ravenclaw House Ghost Ravenclaw Unknown Unknown Ghost Pure-blood or half-blood Black Grey NA NA Post 982 996-1000
81 Nymphadora Tonks Female Auror Hufflepuff Unknown Jack rabbit, Wolf Human Half-blood Variable Variable Ministry of Magic | Order of the Phoenix Talented Auror, Metamorphmagus  1 September 1972- 31 August 1973 2 May, 1998
82 Pomona Sprout Female Professor of Herbology | Head of Hufflepuff House Hufflepuff Unknown Non-corporeal Human Pure-blood or half-blood NA Grey NA Herbology 15 May NA
83 Newton Scamander Male Employee in the Beast Division of the Department for the Regulation and Control of Magical Creatures Hufflepuff Unknown Unknown Human Pure-blood or half-blood Red brown Blue NA Magizoology, Order of Merlin, Second Class 24 February 1897 NA
84 Cedric Diggory Male Student Hufflepuff 12¼”“, Ash, unicorn hair Unknown Human Pure-blood Dark Grey NA Skilled Seeker 1 September - 30 October 1977 24 June, 1995
85 Justin Finch-Fletchley Male Student Hufflepuff Unknown Non-corporeal Human Muggle-born Red NA Dumbledore’s Army NA 1 September 1979- 31 August 1980 NA
86 Zacharias Smith Male Student Hufflepuff Unknown Unknown Human Pure-blood or half-blood Blonde NA Dumbledore’s Army Chaser 1 September 1979 - 2 May 1981 NA
87 Hannah Abbott Female Student Hufflepuff Unknown Non-corporeal Human Half-blood Blonde Brown Dumbledore’s Army Defensive spells, learned with Dumbledore’s Army 1 September 1979 - 31 August 1980 NA
88 Ernest Macmillan Male Student Hufflepuff Unknown Boar Human Pure-blood Blond NA Dumbledore’s Army Revising, being a Prefect, getting the wrong end of the stick 21 April 1980 - 31 August 1980 NA
89 Susan Bones Female Student Hufflepuff Unknown Unknown Human Half-blood NA NA Dumbledore’s Army Defensive spells, learned with Dumbledore’s Army 1 September 1979 - 31 August 1980 NA
90 Walden Macnair Male Executioner for the Committee for the Disposal of Dangerous Creatures Slytherin Unknown Unknown Human Pure-blood or half-blood Black NA Lord Voldemort  | Death Eaters Liaising with giants In or before 1970s NA
91 Augustus Rookwood Male Unspeakable Slytherin Unknown None Human Pure-blood or half-blood Brown/greying NA Lord Voldemort  | Death Eaters Spying for Lord Voldemort pre 1964 NA
92 Antonin Dolohov Male Death Eater Slytherin Unknown None Human Pure-blood or Half-blood Dark NA Lord Voldemort  | Death Eaters Duelling. Fought and killed Molly Weasley’s brothers and Remus Lupin pre 1950 NA
93 Corban Yaxley Male Head of the Department of Magical Law Enforcement Slytherin Unknown None Human Pure-blood or Half-blood Blonde Blue Lord Voldemort  | Death Eaters Imperius curse, undercover work Pre 1970s NA
94 Igor Karkaroff Male Headmaster of Durmstrang Institute NA Unknown None Human Pure-blood or Half-blood Silver| formerly black NA NA Skilled in the Dark Arts pre 1965 24 June, 1995 – 31 July, 1996
95 Kingsley Shacklebolt Male Auror | Minister for Magic NA Unknown Lynx Human Pure-blood Bald Black Order of the Phoenix Exceptionally skilled duellist and Auror Pre 1973 NA
96 Alastor Moody Male Auror NA Unknown Non-corporeal Human Pure-blood Grey One dark, one electric blue Order of the Phoenix A highly accomplished Auror and an outstanding duellist, also skilled in non-verbal magic Pre 1960 27 July, 1997
97 Alice Longbottom Female Auror NA Unknown Unknown Human Pure-blood Blonde NA Original Order of the Phoenix Auror NA NA
98 Frank Longbottom Male Auror Gryffindor Inherited by his son, Neville. It was broken in battle at the Department of Mysteries. Unknown Human Pure-blood Blonde NA Original Order of the Phoenix Auror  1 September 1957 - 31 August 1959 or earlier NA
99 Rufus Scrimgeour Male Head of Auror Office| Minister for Magic NA Unknown Non-corporeal Human NA Tawny Yellowish Minister of Magic Highly regarded as a skilled Auror Pre 1968 1 August, 1997
100 Cornelius Oswald Fudge Male Minister for Magic NA Unknown Non-corporeal Human Pure-blood or Half-blood Grey NA Minister of Magic Turning a blind eye to the continuing threat of Dark Magic in the name of keeping up morale Pre 1964 NA
101 Barty Crouch Sr.  Male Head of the Department of International Magical Cooperation NA Unknown Non-corporeal Human Pure-blood Grey NA Minister of Magic Multilingual, able to fight the Imperius curse Pre 1940 27 May, 1995
102 Amos Diggory Male Employee of the Department for the Regulation and Control of Magical Creatures[ NA Unknown Non-corporeal Human Pure-blood or half-blood Brown Ruddy Minister of Magic Works for the Department for the Regulation and Control of Magical Creatures NA NA
103 Dedalus Diggle Male NA NA Unknown Non-corporeal Human Pure-blood or half-blood NA NA Order of the Phoenix An enthusiastic volunteer for the Order and a helpful escort for Harry and his relatives Pre 1964 NA
104 Elphias Doge Male Special Advisor to the Wizengamot NA Unknown Non-corporeal Human Pure-blood Silver Grey/Blue[ Order of the Phoenix Writing 1 September 1880 - 31 August 1881 NA
105 Fleur Isabelle Delacour Female Part-time at Gringotts Wizarding Bank Beauxbatons Academy of Magic 9½”“, Rosewood, veela hair Non-corporeal Human Quarter-Veela Silvery-blonde Dark blue[ Order of the Phoenix part Veela, and therefore possesses some of their magical powers. She was also selected to compete in the Triwizard Tournament Pre 30 October, 1977 NA
106 Aberforth Dumbledore Male Owner and Barman of the Hog’s Head Inn NA Unknown Goat Human Half-blood Grey Bright Blue Order of the Phoenix Bartending, caring for Ariana  1 September 1883-31 August 1884 NA
107 Mundungus Fletcher Male Dealer of wizarding artifacts NA Unknown Non-corporeal Human Half-blood[ Ginger Brown Order of the Phoenix Gathering information for the Order, dealing in stolen cauldrons, ‘acquiring’ the odd Muggle car Before 1962 NA
108 Sturgis Podmore Male Advance Guard NA Unknown Unknown Human Pure-blood or half-blood Straw-coloured Brown Order of the Phoenix Carrying out guard duty for the Order  8 September 1956 - 7 September 1957 NA
109 Hestia Jones Female Advance Guard NA Unknown Unknown Human Pure-blood or half-blood Black NA Order of the Phoenix Carrying out escort missions for the Order Pre 1978 NA
110 Marlene McKinnon Female NA NA Unknown Unknown Human NA Red Brown Original Order of the Phoenix NA NA July, 1981
111 Fabian Prewett Male NA NA Unknown Unknown Human Pure-blood Red Grey Original Order of the Phoenix Duelling NA 1981
112 Gideon Prewett Male NA NA Unknown Unknown Human Pure-blood Red Dark Grey Original Order of the Phoenix Duelling NA 1981
113 Emmeline Vance Female Advance Guard NA Unknown Unknown Human NA NA NA Order of the Phoenix NA pre 1964 Early July, 1996
114 Edgar Bones Male NA Hufflepuff Unknown Unknown Human Pure-blood or half-blood Reddish-brown Grey Original Order of the Phoenix Said to be a great wizard NA 1981
115 Dorcas Meadowes Female NA NA Unknown Unknown Human NA Black Brown Original Order of the Phoenix NA NA 1981
116 Benjy Fenwick Male NA NA Unknown Unknown Human NA Black Black Original Order of the Phoenix NA NA 1981
117 Madame Olympe Maxime Female Headmistress of Beauxbatons Academy of Magic Beauxbatons Academy of Magic Unknown Unknown Half-Human/Half-Giant Part-Human (Half-giant) Brown Black NA An ‘excellent dancer’, in the words of Dumbledore himself NA NA
118 Gabrielle Delacour Female NA Beauxbatons Academy of Magic Unknown Unknown Human  Quarter-Veela Silvery-blonde NA NA part Veela and therefore may possess some of their magical powers  31 July 1985 - 30 July 1986 NA
119 Viktor Krum Male Seeker for the Bulgarian National Quidditch team Durmstrang Institute 10¼”“, Hornbeam, dragon heartstring Unknown Human  Pure-blood or half-blood Dark Dark NA One of the best Seekers in the world April-August, 1976 NA
120 Petunia Dursley Female NA NA NA NA Human  Muggle Blonde NA NA NA Pre 1960 NA
121 Vernon Dursley Male Director at Grunnings NA NA NA Human  Muggle Black NA NA Schmoozing clients, pretending magic doesn’t exist Pre 1954 NA
122 Dudley Dursley Male NA NA NA NA Human  Muggle Blond Blue NA NA  23 June 1980 NA
123 Marge Dursley Female Dog breeder NA NA NA Human  Muggle Grey NA NA Breeding bulldogs Pre 1954 NA
124 Dennis Creevey Male Student Gryffindor Unknown Unknown Human  Muggle-born Mousy brown NA Dumbledore’s Army NA  1 September 1982 - 31 August 1983 NA
125 Albus Severus Potter Male Student Slytherin Unknown Unknown Human  Half-blood Jet-black Bright green NA NA Between 1 September 2005-31 August 2006 NA
126 Scorpius Hyperion Malfoy Male Student Slytherin Unknown Unknown Human  Pure-blood White blond Grey NA NA Between 1 September 2005-31 August 2007 NA
127 Edward Remus Lupin Male Student Hufflepuff Unknown Unknown Human (Metamorphmagus) Half-blood Variable Variable NA NA April, 1998 NA
128 James Sirius Potter Male Student Gryffindor Unknown Unknown Human  Half-blood NA NA NA NA 1 September 2003-31 August 2004 NA
129 Rose Granger-Weasley Female Student Gryffindor Unknown Unknown Human  Half-blood Red NA NA Chaser 1 September 2005-31 August 2006  NA
130 Argus Filch Male Caretaker of Hogwarts NA NA NA Human  Squib Grey Pale Hogwarts School of Witchcraft and Wizardry Sniffing out mischief Pre 1951 NA
131 Poppy Pomfrey Female Matron at Hogwarts School NA Unknown Non-corporeal Human  Pure-blood or half-blood NA NA Hogwarts School of Witchcraft and Wizardry Skilled medical healer pre 1954 NA
132 Rolanda Hooch Female Flying Instructor at Hogwarts NA Unknown Non-corporeal Human  NA Grey Yellow Hogwarts School of Witchcraft and Wizardry Teaching, flying, refereeing Quidditch matches pre 1918 NA
133 Irma Pince Female Librarian at Hogwarts NA Unknown Non-corporeal Human  NA NA NA Hogwarts School of Witchcraft and Wizardry NA Pre 1966 NA
134 Aurora Sinistra Female Astronomer at Hogwarts NA Unknown Unknown Human  Pure-blood or half-blood Dark Dark Hogwarts School of Witchcraft and Wizardry NA Pre 1968 NA
135 Septima Vector Female Professor of Arithmancyat Hogwarts NA Unknown Unknown Human  NA Black NA Hogwarts School of Witchcraft and Wizardry NA Before 1974 NA
136 Wilhelmina Grubbly-Plank Female Substitute professor of Care of Magical Creatures at Hogwarts NA Unknown Non-corporeal Human  NA Grey NA Hogwarts School of Witchcraft and Wizardry NA NA NA
137 Fenrir Greyback Male NA NA Unknown None Werewolf NA Grey NA Lord Voldemort  | Death Eaters Physical combat Pre 1945 NA
138 Gellert Grindelwald Male Revolutionary leader(c. 1920s[6] – 1945) NA 15”“, Elder, Thestral tail hair core NA Human  Pure-blood or half-blood Blond Blue Gellert Grindelwald’s Acolytes Duelling 1883 March, 1998
139 Dobby Male Malfoy family’s house-elf (? - 1993), Hogwarts kitchens worker (December 1994 - 1998) NA NA NA House elf NA Green NA NA A type of magic specific to house-elves, performed without a wand which includes the ability to apparate, disarm and make objects levitate 28 June Late March, 1998
140 Kreacher Male Black family’s house-elf (?-1996), Harry Potter’s house-elf, Hogwarts kitchen worker NA NA NA House elf NA White NA NA Magic performed without a wand which includes the ability to apparate, disarm and make objects levitate NA NA

Dicionário de dados.

O dicionário de dados está na tabela abaixo:

nomes<-c("Id","Nome dos personagens","Genero: male (masculino), female (feminino)","Atividade exercida pelo personagem",
         "Casa: o equivalente a turmas dentro da escola de magia; Gryffindor (Grifinolia), Hufflepuff (Lufa-Lufa), Ravenclaw (Corvinal), Slytherin (Sonserina)","Varinha ","Patrono do personagem",
         "Especie do personagem","Status sanguineo = tipo de sangue relacionado a ascendencia","Cor do cabelo",
         "Cor dos olhos","Lealdade: por quem o personagem tem lealdade","Habilidades","Data de nascimento","Data da morte")

variavel = names(HarryPotter)
dicionario = data.frame(variavel,nomes)
dicionario %>% flextable(cwidth = 3) %>% theme_vanilla()

Análise dos dados.

A Gliffindor (Grifinólia) é a casa que possui mais personagens?
HarryPotter %>%
  group_by(House) %>%
  summarise(contagem = n()) %>%
  ggplot(aes(x = House, y = contagem, label = contagem)) + 
  geom_bar(stat = "identity", fill = "green", color = "red") +
  geom_label() + coord_flip()

Sim. Dentre as casas de magia a Gryffindor (Grifinólia) é a que possui mais personagems (38)

Qual casa tem mais personagens do gênero masculino e qual possui mais do gênero feminino?
HarryPotter %>%
  group_by(House, Gender) %>%
  summarise(contagem = n()) %>%
  ggplot(aes(x = House, y = contagem, fill = Gender, label = contagem)) + 
  geom_bar(stat = "identity", fill = "green", color = "red") +
  geom_label() + coord_flip()

Dentre as casas de magia a Gryffindor (Grifinólia) é a que possui mais personagens do gênero masculino (26) e do gênero feminino (12)

Existe dominância de status sanguineo em alguma das casas?
HarryPotter%>%
  filter(`Blood status` %in% c("Pure-blood","Half-blood","Muggle-born","Part-Human (Half-giant)","Half-blood or pure-blood",
                               "Unknown","Part-Goblin","Muggle-born or half-blood[","Quarter-Veela","Muggle","Squib","Pure-blood or half-blood")) %>%
  group_by(`Blood status`,House) %>%
  summarise(
    contagem=n()
  )%>%
  ggplot(aes(x=`Blood status`, y=contagem, fill = House,label=contagem))+
  geom_bar(stat= "identity", position="dodge")+
  geom_label(position= position_dodge(width=1),alpha=0.5)+
  theme_calc()

Há dominância do tipo “Pure-blood” na casa Gryffindor (Grifinolia)

Hipóteses

Para os testes de hipótese vamos associar duas variáveis qualitativas categóricas

Primeira hipótese

  • Há relação entre o gênero (Gender) e a escolha da casa (House)?

– Variável de interesse: casa (House)

– Variável explicativa: gênero (Gender)

Hipótese nula (H0): Não há relação (associação) entre o gênero e a escolha da casa.

Hipótese alternativa (H1): Há relação (associação) entre o gênero e a escolha da casa.

alpha = 0,05.

Se pvalor <= 0,05 Rej H0.

Se pvalor > 0,05 Não Rej H0.

Escolha do teste

Para isso vamos primeiro fazer uma tabela relacionado as duas variáveis:

#######Tabela relacionando as duas variáveis
Tabela_Gender_House <- table(HarryPotter$Gender,HarryPotter$House)
Tabela_Gender_House
##         
##          Beauxbatons Academy of Magic Durmstrang Institute Gryffindor
##   Female                            3                    0         12
##   Male                              0                    1         26
##         
##          Hufflepuff Ravenclaw Slytherin
##   Female          5         9         6
##   Male            8         9        21

Como a tabela é maior que 2 x 2 com mais de duas categorias em uma das variáveis, o teste escolhido é o Teste exato de Fisher com aproximação híbrida.

Tabela de contingência para o teste:

#######Tabela de contingência para o teste
TT1 <- as.table(rbind(c(3,0,12,5,9,6),c(0,1,26,8,9,21)))
#rótulo para tabela
dimnames(TT1) <- list(gender = c("Female","Male"), casas = c("Beauxbatons Academy of Magic","Durmstrang Institute","Gryffindor","Hufflepuff","Ravenclaw","Slytherin"))

TT1
##         casas
## gender   Beauxbatons Academy of Magic Durmstrang Institute Gryffindor
##   Female                            3                    0         12
##   Male                              0                    1         26
##         casas
## gender   Hufflepuff Ravenclaw Slytherin
##   Female          5         9         6
##   Male            8         9        21

Teste exato de Fisher:

# fisher teste
# usando aproximação hibrida pois a tabela é maior que 2x2

teste_fisher1 <- fisher.test(TT1, hybrid = TRUE)
teste_fisher1
## 
##  Fisher's Exact Test for Count Data hybrid using asym.chisq. iff (exp=5,
##  perc=80, Emin=1)
## 
## data:  TT1
## p-value = 0.06996
## alternative hypothesis: two.sided

Análise do resultado

p-valor = 0.06996 portanto não rejeita a hipótese nula.

Discussão: Não há relação entre o gênero e a escolha da casa

Segunda hipótese

  • Há relação entre o Status sanguineo (Blood status) e a escolha da casa (House)?

– Variável de interesse: casa (House)

– Variável explicativa: Status sanguineo (Blood status)

Hipótese nula (H0): Não há relação (associação) entre o Status sanguineo (Blood status) e a escolha da casa (House).

Hipótese alternativa (H1): Há relação (associação) entre o Status sanguineo (Blood status) e a escolha da casa (House).

alpha = 0,05.

Se pvalor <= 0,05 Rej H0.

Se pvalor > 0,05 Não Rej H0.

Escolha do teste

Para isso vamos primeiro fazer uma tabela relacionado as duas variáveis:

#####Tabela relacionando as duas variáveis
Tabela_Blood_House <- table(HarryPotter$`Blood status`,HarryPotter$House)
Tabela_Blood_House
##                             
##                              Beauxbatons Academy of Magic Durmstrang Institute
##   Half-blood                                            0                    0
##   Half-blood or pure-blood                              0                    0
##   Half-blood[                                           0                    0
##   Muggle                                                0                    0
##   Muggle-born                                           0                    0
##   Muggle-born or half-blood[                            0                    0
##   Part-Goblin                                           0                    0
##   Part-Human (Half-giant)                               1                    0
##   Pure-blood                                            0                    0
##   Pure-blood or half-blood                              0                    0
##   Pure-blood or half-blood                              0                    1
##   Pure-blood or Half-blood                              0                    0
##   Quarter-Veela                                         2                    0
##   Squib                                                 0                    0
##   Unknown                                               0                    0
##                             
##                              Gryffindor Hufflepuff Ravenclaw Slytherin
##   Half-blood                          7          4         6         5
##   Half-blood or pure-blood            1          0         0         0
##   Half-blood[                         0          0         0         0
##   Muggle                              0          0         0         0
##   Muggle-born                         5          1         1         0
##   Muggle-born or half-blood[          0          0         1         0
##   Part-Goblin                         0          0         1         0
##   Part-Human (Half-giant)             1          0         0         0
##   Pure-blood                         14          2         0        11
##   Pure-blood or half-blood            1          0         1         0
##   Pure-blood or half-blood            6          5         7        10
##   Pure-blood or Half-blood            1          0         0         2
##   Quarter-Veela                       0          0         0         0
##   Squib                               0          0         0         0
##   Unknown                             1          0         0         0

Como a tabela é maior que 2 x 2 com mais de duas categorias nas duas variáveis, o teste escolhido também é o Teste exato de Fisher com aproximação híbrida.

Tabela de contingência para o teste:

#######Tabela de contingência para o teste
TT2 <- as.table(rbind(c(0,0,7,4,6,5),c(0,0,1,0,0,0),c(0,0,0,0,0,0),c(0,0,0,0,0,0),c(0,0,5,1,1,0),c(0,0,0,0,1,0),c(0,0,0,0,1,0),c(1,0,1,0,0,0),c(0,0,14,2,0,11),c(0,0,1,0,1,0),c(0,1,6,5,7,10),c(0,0,1,0,0,2),c(2,0,0,0,0,0),c(0,0,0,0,0,0),c(0,0,1,0,0,0)))

#rótulo para tabela
dimnames(TT2) <- list(Sangue = c("Half-blood","Half-blood or pure-blood","Half-blood[","Muggle","Muggle-born","Muggle-born or half-blood[","Part-Goblin","Part-Human (Half-giant)","Pure-blood","Pure-blood or half-blood","Pure-blood or half-blood","Pure-blood or Half-blood","Quarter-Veela","Squib","Unknown"), casas = c("Beauxbatons Academy of Magic","Durmstrang Institute","Gryffindor","Hufflepuff","Ravenclaw","Slytherin"))

TT2
##                             casas
## Sangue                       Beauxbatons Academy of Magic Durmstrang Institute
##   Half-blood                                            0                    0
##   Half-blood or pure-blood                              0                    0
##   Half-blood[                                           0                    0
##   Muggle                                                0                    0
##   Muggle-born                                           0                    0
##   Muggle-born or half-blood[                            0                    0
##   Part-Goblin                                           0                    0
##   Part-Human (Half-giant)                               1                    0
##   Pure-blood                                            0                    0
##   Pure-blood or half-blood                              0                    0
##   Pure-blood or half-blood                              0                    1
##   Pure-blood or Half-blood                              0                    0
##   Quarter-Veela                                         2                    0
##   Squib                                                 0                    0
##   Unknown                                               0                    0
##                             casas
## Sangue                       Gryffindor Hufflepuff Ravenclaw Slytherin
##   Half-blood                          7          4         6         5
##   Half-blood or pure-blood            1          0         0         0
##   Half-blood[                         0          0         0         0
##   Muggle                              0          0         0         0
##   Muggle-born                         5          1         1         0
##   Muggle-born or half-blood[          0          0         1         0
##   Part-Goblin                         0          0         1         0
##   Part-Human (Half-giant)             1          0         0         0
##   Pure-blood                         14          2         0        11
##   Pure-blood or half-blood            1          0         1         0
##   Pure-blood or half-blood            6          5         7        10
##   Pure-blood or Half-blood            1          0         0         2
##   Quarter-Veela                       0          0         0         0
##   Squib                               0          0         0         0
##   Unknown                             1          0         0         0

Teste exato de Fisher

#teste exato de fisher usando aproximação hibrida
teste_fisher2 <- fisher.test(TT2, hybrid = TRUE, workspace = 200000000)
teste_fisher2
## 
##  Fisher's Exact Test for Count Data hybrid using asym.chisq. iff (exp=5,
##  perc=80, Emin=1)
## 
## data:  TT2
## p-value = 0.001396
## alternative hypothesis: two.sided

Análise do resultado

p-valor = 0,001396 portanto rejeita a hipótese nula (H0)

Dicussão do resultado: Há relação entre status sanguineo e escolha da casa

5. Conclusão

A partir dos resultados obtidos podemos chegar nas seguintes conclusões: Grifinólia (Gryffindor) é a casa que mais possui personagens (38 no total) e a que mais possui personagens masculinos e femininos em números quantitativos. No entanto, a Sonserina (Slytherin) é a que mais possui personagens masculinos quando se trata da proporção feminino por masculino, sendo 21 personagens homens e apenas 6 personagens mulheres e a casa Cornival (Raveclaw) possui uma distribuição igualitária possuindo a mesma quantidade de mulheres e homens. Além disso, podemos perceber que existe uma dominância de personagens puro sangue (pure-blood) nas casa Sonserina e Grifinólia, e meio-sangue (half-blood) na casa Cornival.

E ao realizarmos o teste de Fisher podemos perceber que existe relação do tipo de sangue na escolha das casas, mas não existe relação do gênero com a escolha das casas.