import pandas as pd
df = pd.read_csv("halloween_costumes.csv", sep=",")
df
State | 1 | 2 | 3 | 4 | 5 | |
---|---|---|---|---|---|---|
0 | Alaska | Pirate | Minecraft | Superhero | Vampire | Queen of Hearts |
1 | Alabama | Pirate | Batman | Minnie Mouse | Harley Quinn | Superhero |
2 | Arkansas | Superhero | Harley Quinn | Witch | Superwoman | Pirate |
3 | Arizona | Star Wars | Harley Quinn | Pirate | Batman | Superhero |
4 | California | Star Wars | Harley Quinn | Pirate | Superhero | Batman |
5 | Colorado | Star Wars | Superhero | Pirate | Batman | Harley Quinn |
6 | Connecticut | Star Wars | Mermaid | Minnie Mouse | Harley Quinn | Elsa |
7 | District of Columbia | Batman | Harley Quinn | Superhero | Star Wars | Princess |
8 | Delaware | Harley Quinn | Superwoman | Star Wars | Pirate | Fairy |
9 | Florida | Harley Quinn | Superhero | Star Wars | Pirate | Batman |
10 | Georgia | Superhero | Star Wars | Harley Quinn | Pirate | Batman |
11 | Hawaii | Star Wars | Pirate | Superhero | Minions | Clown |
12 | Iowa | Superhero | Batman | Witch | Harley Quinn | Teenage Mutant Ninja Turtles |
13 | Idaho | Star Wars | Pirate | Werewolf | Angel | Teenage Mutant Ninja Turtles |
14 | Illinois | Harley Quinn | Batman | Superhero | Star Wars | Minions |
15 | Indiana | Pirate | Superhero | Batman | Witch | Star Wars |
16 | Kansas | Superhero | Pirate | Harley Quinn | Batman | Dinosaur |
17 | Kentucky | Harley Quinn | Batman | Star Wars | Pirate | Superhero |
18 | Louisiana | Superhero | Minnie Mouse | Batman | Harley Quinn | Witch |
19 | Massachusetts | Superhero | Harley Quinn | Star Wars | Pirate | Batman |
20 | Maryland | Batman | Superhero | Pirate | Minnie Mouse | Witch |
21 | Maine | PAW Patrol | Harley Quinn | Steampunk | Pirate | Ghost |
22 | Michigan | Batman | Harley Quinn | Superhero | Pirate | Star Wars |
23 | Minnesota | Star Wars | Pirate | Superhero | The Renaissance | Minions |
24 | Missouri | Batman | Superhero | Pirate | Harley Quinn | Witch |
25 | Mississippi | Minnie Mouse | Star Wars | Pirate | Witch | Teenage Mutant Ninja Turtles |
26 | Montana | Star Wars | Steampunk | Tiger | Wonder Woman | Minions |
27 | North Carolina | Pirate | Batman | Harley Quinn | Star Wars | Superhero |
28 | North Dakota | Mickey Mouse | Maleficent | Owl | Superhero | Witch |
29 | Nebraska | Superhero | Witch | Star Wars | Pirate | Teenage Mutant Ninja Turtles |
30 | New Hampshire | Ewok | Pirate | Minnie Mouse | Witch | Harley Quinn |
31 | New Jersey | Star Wars | Superhero | Batman | Harley Quinn | Pirate |
32 | New Mexico | Teenage Mutant Ninja Turtles | Superhero | Star Wars | Harley Quinn | Batman |
33 | Nevada | Harley Quinn | Star Wars | Wonder Woman | Joker | Witch |
34 | New York | Harley Quinn | Batman | Superhero | Star Wars | Minnie Mouse |
35 | Ohio | Batman | Harley Quinn | Superhero | Pirate | Star Wars |
36 | Oklahoma | Batman | Star Wars | Superhero | Harley Quinn | Pirate |
37 | Oregon | Pirate | Star Wars | Superhero | Batman | Witch |
38 | Pennsylvania | Batman | Pirate | Harley Quinn | Star Wars | Minnie Mouse |
39 | Rhode Island | Harley Quinn | Mermaid | Witch | Superhero | Gray wolf |
40 | South Carolina | Harley Quinn | Pirate | Batman | Witch | Superhero |
41 | South Dakota | Harley Quinn | Clown | Maleficent | Raccoon | Elsa |
42 | Tennessee | Pirate | Superhero | Star Wars | Witch | Batman |
43 | Texas | Harley Quinn | Superhero | Batman | Star Wars | Pirate |
44 | Utah | Witch | Star Wars | Pirate | Superhero | Vampire |
45 | Virginia | Star Wars | Pirate | Batman | Superhero | Harley Quinn |
46 | Vermont | Fairy | Zombie Bride | Steampunk | Steampunk | Minnie Mouse |
47 | Washington | Star Wars | Harley Quinn | Pirate | Batman | Princess |
48 | Wisconsin | Pirate | Superhero | Star Wars | Batman | Clown |
49 | West Virginia | Harley Quinn | Minnie Mouse | Teenage Mutant Ninja Turtles | Witch | Clown |
50 | Wyoming | Witch | Chucky | Ghost | Minnie Mouse | Hulk |
costume_list = []
for item in df["1"]:
if item not in costume_list:
costume_list.append(item)
for item in df["2"]:
if item not in costume_list:
costume_list.append(item)
for item in df["3"]:
if item not in costume_list:
costume_list.append(item)
for item in df["4"]:
if item not in costume_list:
costume_list.append(item)
for item in df["5"]:
if item not in costume_list:
costume_list.append(item)
costume_list
['Pirate', 'Superhero', 'Star Wars', 'Batman', 'Harley Quinn', 'PAW Patrol', 'Minnie Mouse', 'Mickey Mouse', 'Ewok', 'Teenage Mutant Ninja Turtles', 'Witch', 'Fairy', 'Minecraft', 'Mermaid', 'Superwoman', 'Steampunk', 'Maleficent', 'Clown', 'Zombie Bride', 'Chucky', 'Werewolf', 'Tiger', 'Owl', 'Wonder Woman', 'Ghost', 'Vampire', 'Minions', 'Angel', 'The Renaissance', 'Joker', 'Raccoon', 'Queen of Hearts', 'Elsa', 'Princess', 'Dinosaur', 'Gray wolf', 'Hulk']
allcostume_dict = []
for item in costume_list:
costume_dict = {}
costume_dict["name"] = item
costume_dict["number_1"] = 0
costume_dict["number_2"] = 0
costume_dict["number_3"] = 0
costume_dict["number_4"] = 0
costume_dict["number_5"] = 0
costume_dict["total_score"] = 0
for row in df["1"]:
if row == item:
costume_dict["number_1"] += 5
for row in df["2"]:
if row == item:
costume_dict["number_2"] += 4
for row in df["3"]:
if row == item:
costume_dict["number_3"] += 3
for row in df["4"]:
if row == item:
costume_dict["number_4"] += 2
for row in df["5"]:
if row == item:
costume_dict["number_5"] += 1
costume_dict["total_score"] = costume_dict["number_1"] + costume_dict["number_2"] + costume_dict["number_3"] + costume_dict["number_4"] + costume_dict["number_5"]
allcostume_dict.append(costume_dict)
allcostume_dict
[{'name': 'Pirate', 'number_1': 35, 'number_2': 32, 'number_3': 24, 'number_4': 18, 'number_5': 4, 'total_score': 113}, {'name': 'Superhero', 'number_1': 35, 'number_2': 40, 'number_3': 30, 'number_4': 10, 'number_5': 5, 'total_score': 120}, {'name': 'Star Wars', 'number_1': 55, 'number_2': 24, 'number_3': 24, 'number_4': 12, 'number_5': 3, 'total_score': 118}, {'name': 'Batman', 'number_1': 35, 'number_2': 24, 'number_3': 18, 'number_4': 12, 'number_5': 6, 'total_score': 95}, {'name': 'Harley Quinn', 'number_1': 55, 'number_2': 36, 'number_3': 12, 'number_4': 16, 'number_5': 3, 'total_score': 122}, {'name': 'PAW Patrol', 'number_1': 5, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 0, 'total_score': 5}, {'name': 'Minnie Mouse', 'number_1': 5, 'number_2': 8, 'number_3': 9, 'number_4': 4, 'number_5': 3, 'total_score': 29}, {'name': 'Mickey Mouse', 'number_1': 5, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 0, 'total_score': 5}, {'name': 'Ewok', 'number_1': 5, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 0, 'total_score': 5}, {'name': 'Teenage Mutant Ninja Turtles', 'number_1': 5, 'number_2': 0, 'number_3': 3, 'number_4': 0, 'number_5': 4, 'total_score': 12}, {'name': 'Witch', 'number_1': 10, 'number_2': 4, 'number_3': 9, 'number_4': 12, 'number_5': 6, 'total_score': 41}, {'name': 'Fairy', 'number_1': 5, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 1, 'total_score': 6}, {'name': 'Minecraft', 'number_1': 0, 'number_2': 4, 'number_3': 0, 'number_4': 0, 'number_5': 0, 'total_score': 4}, {'name': 'Mermaid', 'number_1': 0, 'number_2': 8, 'number_3': 0, 'number_4': 0, 'number_5': 0, 'total_score': 8}, {'name': 'Superwoman', 'number_1': 0, 'number_2': 4, 'number_3': 0, 'number_4': 2, 'number_5': 0, 'total_score': 6}, {'name': 'Steampunk', 'number_1': 0, 'number_2': 4, 'number_3': 6, 'number_4': 2, 'number_5': 0, 'total_score': 12}, {'name': 'Maleficent', 'number_1': 0, 'number_2': 4, 'number_3': 3, 'number_4': 0, 'number_5': 0, 'total_score': 7}, {'name': 'Clown', 'number_1': 0, 'number_2': 4, 'number_3': 0, 'number_4': 0, 'number_5': 3, 'total_score': 7}, {'name': 'Zombie Bride', 'number_1': 0, 'number_2': 4, 'number_3': 0, 'number_4': 0, 'number_5': 0, 'total_score': 4}, {'name': 'Chucky', 'number_1': 0, 'number_2': 4, 'number_3': 0, 'number_4': 0, 'number_5': 0, 'total_score': 4}, {'name': 'Werewolf', 'number_1': 0, 'number_2': 0, 'number_3': 3, 'number_4': 0, 'number_5': 0, 'total_score': 3}, {'name': 'Tiger', 'number_1': 0, 'number_2': 0, 'number_3': 3, 'number_4': 0, 'number_5': 0, 'total_score': 3}, {'name': 'Owl', 'number_1': 0, 'number_2': 0, 'number_3': 3, 'number_4': 0, 'number_5': 0, 'total_score': 3}, {'name': 'Wonder Woman', 'number_1': 0, 'number_2': 0, 'number_3': 3, 'number_4': 2, 'number_5': 0, 'total_score': 5}, {'name': 'Ghost', 'number_1': 0, 'number_2': 0, 'number_3': 3, 'number_4': 0, 'number_5': 1, 'total_score': 4}, {'name': 'Vampire', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 2, 'number_5': 1, 'total_score': 3}, {'name': 'Minions', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 2, 'number_5': 3, 'total_score': 5}, {'name': 'Angel', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 2, 'number_5': 0, 'total_score': 2}, {'name': 'The Renaissance', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 2, 'number_5': 0, 'total_score': 2}, {'name': 'Joker', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 2, 'number_5': 0, 'total_score': 2}, {'name': 'Raccoon', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 2, 'number_5': 0, 'total_score': 2}, {'name': 'Queen of Hearts', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 1, 'total_score': 1}, {'name': 'Elsa', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 2, 'total_score': 2}, {'name': 'Princess', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 2, 'total_score': 2}, {'name': 'Dinosaur', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 1, 'total_score': 1}, {'name': 'Gray wolf', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 1, 'total_score': 1}, {'name': 'Hulk', 'number_1': 0, 'number_2': 0, 'number_3': 0, 'number_4': 0, 'number_5': 1, 'total_score': 1}]
costumes = pd.DataFrame(allcostume_dict)
costumes
name | number_1 | number_2 | number_3 | number_4 | number_5 | total_score | |
---|---|---|---|---|---|---|---|
0 | Pirate | 35 | 32 | 24 | 18 | 4 | 113 |
1 | Superhero | 35 | 40 | 30 | 10 | 5 | 120 |
2 | Star Wars | 55 | 24 | 24 | 12 | 3 | 118 |
3 | Batman | 35 | 24 | 18 | 12 | 6 | 95 |
4 | Harley Quinn | 55 | 36 | 12 | 16 | 3 | 122 |
5 | PAW Patrol | 5 | 0 | 0 | 0 | 0 | 5 |
6 | Minnie Mouse | 5 | 8 | 9 | 4 | 3 | 29 |
7 | Mickey Mouse | 5 | 0 | 0 | 0 | 0 | 5 |
8 | Ewok | 5 | 0 | 0 | 0 | 0 | 5 |
9 | Teenage Mutant Ninja Turtles | 5 | 0 | 3 | 0 | 4 | 12 |
10 | Witch | 10 | 4 | 9 | 12 | 6 | 41 |
11 | Fairy | 5 | 0 | 0 | 0 | 1 | 6 |
12 | Minecraft | 0 | 4 | 0 | 0 | 0 | 4 |
13 | Mermaid | 0 | 8 | 0 | 0 | 0 | 8 |
14 | Superwoman | 0 | 4 | 0 | 2 | 0 | 6 |
15 | Steampunk | 0 | 4 | 6 | 2 | 0 | 12 |
16 | Maleficent | 0 | 4 | 3 | 0 | 0 | 7 |
17 | Clown | 0 | 4 | 0 | 0 | 3 | 7 |
18 | Zombie Bride | 0 | 4 | 0 | 0 | 0 | 4 |
19 | Chucky | 0 | 4 | 0 | 0 | 0 | 4 |
20 | Werewolf | 0 | 0 | 3 | 0 | 0 | 3 |
21 | Tiger | 0 | 0 | 3 | 0 | 0 | 3 |
22 | Owl | 0 | 0 | 3 | 0 | 0 | 3 |
23 | Wonder Woman | 0 | 0 | 3 | 2 | 0 | 5 |
24 | Ghost | 0 | 0 | 3 | 0 | 1 | 4 |
25 | Vampire | 0 | 0 | 0 | 2 | 1 | 3 |
26 | Minions | 0 | 0 | 0 | 2 | 3 | 5 |
27 | Angel | 0 | 0 | 0 | 2 | 0 | 2 |
28 | The Renaissance | 0 | 0 | 0 | 2 | 0 | 2 |
29 | Joker | 0 | 0 | 0 | 2 | 0 | 2 |
30 | Raccoon | 0 | 0 | 0 | 2 | 0 | 2 |
31 | Queen of Hearts | 0 | 0 | 0 | 0 | 1 | 1 |
32 | Elsa | 0 | 0 | 0 | 0 | 2 | 2 |
33 | Princess | 0 | 0 | 0 | 0 | 2 | 2 |
34 | Dinosaur | 0 | 0 | 0 | 0 | 1 | 1 |
35 | Gray wolf | 0 | 0 | 0 | 0 | 1 | 1 |
36 | Hulk | 0 | 0 | 0 | 0 | 1 | 1 |
sorted_costumes = costumes.sort(['total_score'], ascending=0)
sorted_costumes
name | number_1 | number_2 | number_3 | number_4 | number_5 | total_score | |
---|---|---|---|---|---|---|---|
4 | Harley Quinn | 55 | 36 | 12 | 16 | 3 | 122 |
1 | Superhero | 35 | 40 | 30 | 10 | 5 | 120 |
2 | Star Wars | 55 | 24 | 24 | 12 | 3 | 118 |
0 | Pirate | 35 | 32 | 24 | 18 | 4 | 113 |
3 | Batman | 35 | 24 | 18 | 12 | 6 | 95 |
10 | Witch | 10 | 4 | 9 | 12 | 6 | 41 |
6 | Minnie Mouse | 5 | 8 | 9 | 4 | 3 | 29 |
9 | Teenage Mutant Ninja Turtles | 5 | 0 | 3 | 0 | 4 | 12 |
15 | Steampunk | 0 | 4 | 6 | 2 | 0 | 12 |
13 | Mermaid | 0 | 8 | 0 | 0 | 0 | 8 |
16 | Maleficent | 0 | 4 | 3 | 0 | 0 | 7 |
17 | Clown | 0 | 4 | 0 | 0 | 3 | 7 |
11 | Fairy | 5 | 0 | 0 | 0 | 1 | 6 |
14 | Superwoman | 0 | 4 | 0 | 2 | 0 | 6 |
7 | Mickey Mouse | 5 | 0 | 0 | 0 | 0 | 5 |
8 | Ewok | 5 | 0 | 0 | 0 | 0 | 5 |
23 | Wonder Woman | 0 | 0 | 3 | 2 | 0 | 5 |
26 | Minions | 0 | 0 | 0 | 2 | 3 | 5 |
5 | PAW Patrol | 5 | 0 | 0 | 0 | 0 | 5 |
24 | Ghost | 0 | 0 | 3 | 0 | 1 | 4 |
18 | Zombie Bride | 0 | 4 | 0 | 0 | 0 | 4 |
19 | Chucky | 0 | 4 | 0 | 0 | 0 | 4 |
12 | Minecraft | 0 | 4 | 0 | 0 | 0 | 4 |
21 | Tiger | 0 | 0 | 3 | 0 | 0 | 3 |
22 | Owl | 0 | 0 | 3 | 0 | 0 | 3 |
20 | Werewolf | 0 | 0 | 3 | 0 | 0 | 3 |
25 | Vampire | 0 | 0 | 0 | 2 | 1 | 3 |
27 | Angel | 0 | 0 | 0 | 2 | 0 | 2 |
28 | The Renaissance | 0 | 0 | 0 | 2 | 0 | 2 |
29 | Joker | 0 | 0 | 0 | 2 | 0 | 2 |
30 | Raccoon | 0 | 0 | 0 | 2 | 0 | 2 |
32 | Elsa | 0 | 0 | 0 | 0 | 2 | 2 |
33 | Princess | 0 | 0 | 0 | 0 | 2 | 2 |
31 | Queen of Hearts | 0 | 0 | 0 | 0 | 1 | 1 |
34 | Dinosaur | 0 | 0 | 0 | 0 | 1 | 1 |
35 | Gray wolf | 0 | 0 | 0 | 0 | 1 | 1 |
36 | Hulk | 0 | 0 | 0 | 0 | 1 | 1 |
import matplotlib.pyplot as plt
%matplotlib inline
scores = sorted_costumes[['name', 'total_score']]
scores
name | total_score | |
---|---|---|
4 | Harley Quinn | 122 |
1 | Superhero | 120 |
2 | Star Wars | 118 |
0 | Pirate | 113 |
3 | Batman | 95 |
10 | Witch | 41 |
6 | Minnie Mouse | 29 |
9 | Teenage Mutant Ninja Turtles | 12 |
15 | Steampunk | 12 |
13 | Mermaid | 8 |
16 | Maleficent | 7 |
17 | Clown | 7 |
11 | Fairy | 6 |
14 | Superwoman | 6 |
7 | Mickey Mouse | 5 |
8 | Ewok | 5 |
23 | Wonder Woman | 5 |
26 | Minions | 5 |
5 | PAW Patrol | 5 |
24 | Ghost | 4 |
18 | Zombie Bride | 4 |
19 | Chucky | 4 |
12 | Minecraft | 4 |
21 | Tiger | 3 |
22 | Owl | 3 |
20 | Werewolf | 3 |
25 | Vampire | 3 |
27 | Angel | 2 |
28 | The Renaissance | 2 |
29 | Joker | 2 |
30 | Raccoon | 2 |
32 | Elsa | 2 |
33 | Princess | 2 |
31 | Queen of Hearts | 1 |
34 | Dinosaur | 1 |
35 | Gray wolf | 1 |
36 | Hulk | 1 |
sorted_costumes.to_csv("costumes.csv", index=False)