I want to find the most similar person with me.

Here is what I think: I want to apply humming distance to each answer, and if the hamming distance is smaller than 2, then that person get one points.

After applying to all the answers in this sheet, sum all the points and find which one has the highest score. Here is the hamming distance, 

def hamming(str1, str2):
diff = 0
for ch1,ch2 in zip(str1,str2):
if ch1!=ch2:
diff += 1
return diff

I don't know how to apply this to all the answers by using for loop

(This question should be solved in Python, Pandas)

 

 

qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Name
Wade
Jack
Aaditya
Abdul
Abdullahi
Aidan
Alan
Alexander
Allen
Ameya
Andrew
Angelos
Arshia
Ayush
Bobby
Bowen
Bryan
Caren
Cheng
Daksh
Daniel L.
Daniel Z.
Danish
Diana
Dolly
Emilio
Eric
Gordon
Grant
Guohao
Handi
Harsh
Heng
Henry
Hung
Ibrahim
Jackson
Janish
Jason
Jeannelle
Jeffrey
Jennifer
Jingxiang
John
Kai
Keshav
Keye
Lance
Lingkai
Majdi
May
Megha Major
Class
Computer Science
Applied Math
Electrical Engineering Sophomore
Computer Science
Sophomore
Computer Science
Sophomore
CS + Linguistics
Freshman
Computer Science
Freshman
DGS
Sophomore
System Engineering
Freshman
Computer Engineering Junior
Computer Science
Freshman
Computer Science
Freshman
Computer Science
Freshman
CS + Math
Freshman
CS + Math
Freshman
Mathematics
Junior
CS + Math
Junior
Computer Science
Freshman
Computer Engineering Sophomore
Electrical Engineering Sophomore
Statistics
Sophomore
Computer Science
Freshman
Computer Science
Freshman
CS + Math
Sophomore
Computer Science
Freshman
Computer Science
Freshman
Electrical Engineering Junior
CS + Math
Freshman
Computer Science
Freshman
Finance
Junior
Computer Science
Freshman
Electrical Engineering Sophomore
DGS
Sophomore
DGS
Sophomore
CS + Math
Junior
Electrical Engineering Sophomore
Computer Science
Freshman
Computer Engineering Sophomore
DGS
Freshman
Linguistics
Junior
DGS
Freshman
Computer Science
Freshman
Computer Science
Freshman
DGS
Sophomore
Statistics
Junior
Mechanical EngineeringJunior
Material Science
Junior
Engineering mechanic Sophomore
Mathematics
Freshman
Computer Engineering Sophomore
Physics
Freshman
Computer Science
Freshman Favorite Coffeshop Drink
Latte
Latte
Hot Chocolate
Mocha Frappucino
Tea
Hot Chocolate
Bubble Tea
Milk Tea
Iced White Mocha
Latte
Green Tea Latte
Bubble Tea
Bubble Tea
Chai
Milk
Water
Mango Tea
Water
White Chocolate Mocha
Tea
Green Tea
Juice
Oolong Milk Tea
Water
Green Tea
Coffee, Iced
Latte
Green Tea
Water
Iced White Mocha
Hot Chocolate
Mocha
Hot Chocolate
Lemon Iced Tea
Cappuccino
Green Tea
Coffee
Vanilla Hazelnut
Mocha
Water
Latte
Hazelnut Latte
Flat White
Hot Chocolate
Strawberry Smoothie
Latte
Bubble Tea
Page 1 Favorite Fruit
Peach
Mango
Lychee
Mango
Mangostene
Blueberry
Banana
Watermelon
Strawberry
Pumpkin
Pineapple
Mango
Watermelon
Banana
Apple
Mango
Durian
Peach
Apple
Kiwi
Watermelon
Watermelon
Watermelon
Apple
Mango
Pear
Mango
Orange
Watermelon
Mango
Blueberry
Mango
Orange
Grape
Apple
Watermelon
Grape
Watermelon
Mango
Apple
Strawberry
Strawberry
Mango
Mango
Blueberry
Cherry
Blackberry
Banana
Mango qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Mengqi
Ophir
Peiyao
Peng
Pengyu
Phoebe
Piotr
Rahul
Ray
Riley
Rohit
Sanskruti
Seongsu
Shengkun
Shuchen
Siwei
Siyu
Sudeep
The
Travis
Unknown
Uttam
Will
Xinyu
Yajie
Yaoyang
Yichen
Yuanzhe
Yuchen
Yuxin
Zecheng
Zehao
Zhe
Zhengdai
Ziang
Zifan
Zifei
Zihan
Zixin Aerospace Engineering Sophomore
Computer Science
Freshman
Computer Science
Freshman
Computer Engineering Sophomore
CS + Statistics
Sophomore
Architecture
Freshman
Computer Science
Freshman
Computer Science
Freshman
Computer Science
Freshman
Computer Science
Freshman
Computer Science
Freshman
CS + Math
Sophomore
Computer Science
Sophomore
Computer Engineering Junior
Computer Engineering Sophomore
Electrical Engineering Sophomore
Electrical Engineering Sophomore
Computer Engineering Sophomore
Computer Science
Freshman
Computer Science
Freshman
Computer Engineering Sophomore
Mechanical EngineeringFreshman
Computer Engineering Sophomore
Computer Science
Freshman
Computer Science
Sophomore
CS + Math
Junior
Electrical Engineering Sophomore
CS + Math
Junior
Electrical Engineering Sophomore
CS + Math
Freshman
Computer Science
Sophomore
CS + Astronomy
Freshman
Mathematics
Sophomore
Computer Science
Freshman
Computer Science
Freshman
Mathematics
Freshman
DGS
Freshman
CS + Math
Freshman
DGS
Sophomore Milk Tea
Latte
Green Tea Latte
Iced Tea
Frappuccino
Coffee
Caramel Mochiatto
Water
Earl Grey Tea
Mocha Frappucino
Hot Chocolate
Iced Latte
Bubble Tea
Mocha
Water
Latte
Mountain Dew
Cappuccino
Coffee
Hot Chocolate
Water
Hot Chocolate
Latte
Milk Tea
Milk
Bubble Tea
Peach Tea
Bubble Tea
Green Milk Tea
Lemon Tea
Americano
Mint Mocha
Iced Tea
Bubble Tea
Hot Chocolate
Java Chip
Hot Chocolate
Strawberry Lemonade Page 2 Banana
Raspberries
Orange
Apple
Apple
Apple
Apple
Strawberry
Nectarine
Grape
Apple
Strawberry
Blueberry
Apple
Mango
Apple
Banana
Banana
Banana
Nectarine
Grape
Mango
Blueberry
Pineapple
Blueberry
Watermelon
Orange
Orange
Orange
Apple
Banana
Watermelon
Watermelon
Mango
Banana
Watermelon
Strawberry qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Favorite Code Editor
Atom
vim
Atom
Atom
vim
Sublime Text
Sublime Text
Atom
Atom
Atom
Atom
Visual Studio
IntelliJ
vim
vim
Visual Studio
Atom
Sublime Text
Atom
gedit
Visual Studio
Sublime Text
emacs
Sublime Text
Atom
emacs
vim
Atom
vim
Sublime Text
vim
Sublime Text
Sublime Text
Visual Studio
Atom
Atom
Sublime Text
Atom
Atom
Atom
Atom
Atom
gedit
Atom
Sublime Text
Atom
vim
Atom
Sublime Text
vim
Visual Studio Favorite Programming Language
JavaScript
Python
C++
Java
C++
Scala
Python
Python
C++
LC3
Python
C++
Python
Java
Python
Python
Java
Python
Ruby
C#
Python
Python
Python
C++
C
Java
Python
C++
Python
Python
Java
Python
C++
Java
C++
C
Java
C++
C++
LaTex
Python
Python
Python
Java
Python
C++
Python
Python
Java
Python
C++
C++ Birthplace
USA, Maryland
USA, California
USA, Texas
USA
Somalia
USA, Virginia
USA
USA
China
USA
USA
China
USA, California
Russia
China
Chinda
Mongolia
USA, California
China
india
Korea
USA, Illinois
USA
USA, Illinois
China
Puerto Rico
USA
USA, Tennessee
USA, New York
China
China
India
China
USA
Malaysia
USA
USA
India
USA, Illinois
USA
China
China
USA
China
India
China
China
China
USA
China Page 3 OS of Choice
Windows
OS X
Windows
Windows
Linux
Windows
OS X
Windows
Linux
Windows
Linux
Windows
OS X
Windows
Linux
Windows
Linux
Windows
Windows
Windows
Windows
Windows
Windows
Windows
Windows
Linux
Windows
Linux
Linux
Windows
OS X
Linux
OS X
Windows
Windows
Windows
Windows
Windows
OS X
Linux
Windows
Windows
Windows
Windows
Windows
Windows
Windows
Windows
Windows
Windows
Windows
OS X Favorite Animal
Human
Human
Donkey
Cheetah
Whale
Squirrel
Rabbit
Cat
Whale
Dog
Tiger
Tiger
Dog
Petrel
Turtle
Dog
Dog
Dog
Dog
Tiger
Monkey
Dog
Dog
Dog
Dog
Shrimp
Penguin
Toad
Toad
Dog
Dog
Dog
Dog
Walrus
Dog
Armadilloooooo
Whale
Ant
Cat
Dog
Penguin
Dog
Squirrel
Unicorn
Flamingo
Cat
Unicorn
Elephant
Monkey qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Atom
vim
Atom
gedit
Sublime Text
Atom
Notepad++
Atom
vim
vim
Visual Studio
vim
vim
Atom
vim
Atom
Atom
Atom
vim
vim
gedit
Atom
Atom
Sublime Text
Sublime Text
vim
Atom
vim
Atom
Atom
vim
Atom
Atom
vim
Atom
Sublime Text
Sublime Text
vim
Sublime Text Python
C++
Python
Java
C++
C++
Binary
JavaScript
C#
C++
Python
C++
C++
Python
Python
C++
Java
Makefile
Python
C++
C++
Fortran
C++
Java
Python
C
C
Haskell
Matlab
Java
Python
C++
C++
C++
Java
Python
Java
Java
C++ China
USA, California
China
China
China
China
USA
USA, Illinois
USA, Illinois
USA
USA, Colorado
India
South Korea
China
China
China
China
India
USA, California
USA
India
USA
USA
China
China
China
China
China
China
China
China
China
China
China
China
China
China
China
China Page 4 Windows
Windows
Windows
Windows
Windows
Windows
Linux
Linux
Linux
Windows
Linux
OS X
Linux
Windows
OS X
Windows
Windows
Windows
OS X
Windows
Windows
Windows
Windows
Windows
Windows
Windows
Windows
OS X
Windows
Windows
Linux
Windows
Windows
OS X
Windows
OS X
Android
Windows
Windows Dog
Turtle
Toad
Toad
Dog
Squirrel
Dog
Tiger
Bear
Frog
Cheetah
Panda
Dog
Dog
Koala
Human
Cat
Dog
Dog
Koala
Falcon
Quokka
Prairie dog
Cat
Rabbit
Cat
Tiger
Cat
Toad
Cat
Dog
Graffiti
Panda
Cat
Wolf
Dog
Cat
Cat qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Favorite Color
Turquoise
Yellow
Purple
Blue
Blue
Green
Red
Black
Green
Purple
Red
Black
Purple
Black
Blue
Cyan
#00ffff
Green
Yellow
Blue
Red
Black
Cyan
Turquoise
Purple
Blue
Blue
Blue
Purple
Green
Purple
Black
Blue
Blue
Red
Blue
Blue
Blue
Atom Green
Purple
Blue
Blue
Blue
Blue
Black
Yellow
Red
Black
Blue
Black
Orange Favorite Class this sem. CS 296
CS 225
MAT 415
CS 412 CS 296
ECE 391
CS 225
CS 225
CS 296
MATH 490
CS 225
CS 225
ECE 342
STAT 425
CS 357
CS 225
SPAN 307
CS 225
CS 225
ECE 420
CS 225
CS 233
CS 296
CS 225
ECE 398
CS 225
CS 296
STAT 400
ECE 342
CS 225
ECE 385
CS 225
LING 415
ECE 314
CS 225
CS 199
CS 225
CS 225
CS 225
CS 225
CS 225
CS 225
CS 225
CS 296
CS 296 Favorite Game
Keystone
Ticket to Ride
Badminton
MW2
Poker
League of Legends
Total War
DotA 2
DotA 2
ITG
Dark Souls
Call of Duty
FIFA
League of Legends
DotA 2
Overwatch
Chess
Cards
CS:GO
FIFA
League of Legends
Overwatch Favorite Food
BBQ
Sushi
Durian
Sushi
Biryani
Pasta
Burrito
Sushi
Ramen
Pad Thai
Pizza
Cheese
Dim sum
stir fry
Steak
Sushi
Ramen
Kimbap
Burrito
Pizza Sushi
Rice
Pierogi
Call of Duty
Noodles
League of Legends Steak
Bingo
Ramen
DotA 2
Pumpkin bread
Blackjack
Sushi
The Binding of Issac Orange
League of Legends Ramen
Indian Food
Hotpot
Overwatch
Black Bean Noodles
MouseHunt
Nasi Lemak
Fallout 3
Steak
Need For Speed
Steak
Arkham Asylum
Thai
Dark Souls
Anything Cantonese
SimCity 4
Cereal
Pokemon
Rice
League of Legends Ice cream
HearthStone
Chicken
Runescape
Spaghetti
DotA 2
Burger
FIFA
Chipotle
FIFA
Ribeye
Call of Duty
Steak
DotA 2
Beef
Skyrim
Steak
StarCraft 2
Ice cream
Dessert
Page 5 qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Green
Turquoise
Purple
Red
Black
Green
Black
Red
Green
Green
Orange
Blue
Black
Blue
Blue
Red
Blue
Black
Blue
Blue
Blue
Blue
Green
Pink
Green
Kuro
Blue
White
Blue
Orange
Blue
Blue
Green
Blue
Black
Blue
Green
Blue
Blue CS 225
CS 225
MATH 415
EALC 130
CS 225
CS 225
CS 126
CS 296
CS 233
CS 225
CS 233
CS 241
CS 233
CS 391
ECE 385
THEA 101
CS 225
ECE 385
CS 397
CS 225
CS 225
STAT 400
CS 296
CS 225
CS 296
CS 498 AML
MATH 416
MATH 412
CS 225
CS 225
CS 241
CS 225
CS 296
CS 225
CS 296
CS 225
CS 225
CS 296
CS 225 Onmyouji
CS:GO
Dangan Ronpa
Gundam Online
Path of Exile
The Last of Us
The Witcher 3
Madden
Faster Than Light
RB6:Siege
KSP Sushi
Eggs
Sushi
Noodles
Chocolate
Pizza
Fried rice
Burger
Chicken
Pizza
Pizza
Lemon grass chicken
Mocha Ice cream
Animal
Chimichanga
Pizza
Bagels
Sushi The Witcher 3
Ace combat
Overwatch
DotA 2
Call of Duty
Risk
Destiny
Pong
MW2
Borderlands 2 Pizza
Burrito
Ramen Onmyouji
NBA 2K
Neko Atsume Noodles
Cantonese cuisine
Sushi
Sushi
Sushi
Sushi
Chicken
Sushi
Noodles
Bamboo shoot
Chocolate
Smash Potato
Rice
Noodles DotA 2
StarCraft 2
CS:GO
NBA 2K
Minecraft
Overwatch Cards
Battlefield 1
0
0 Page 6 qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Spoken Languages Fluent Favorite # Favorite Physical Activity to Play
-3 Running
32 Biking
42 Running
25 Soccer
10 Soccer
Ultimate Frisbee
7 Swimming
9 Gaming 1
1
4
3.5
3
2 INT_MAX
3
3
2
1
7 tennis
1.618033989
2
2
3.141592654 Basketball
2
28 Ice skating
2.67 Jan-00
Soccer
2
32767 Rock Climbing
2
5.916687664 Basketball
2
3 Running
2e
Badminton
2
6666 Basketball
2
25 Squash
2
13 Soccer
2.25
2 Badminton
3
5 Basketball
4
12 Swimming
2
6 Swimming
2
3.141592654 Fencing
2
Hiking
2
256 Soccer
3
4 Volleyball
2
7 Swimming
3
7 Frisbee
2
7 Football
2
7 Badminton
3
25 Badminton
4
11 Gaming
2
27 Basketball
1
10 Volleyball
4
5 Soccer
2
42 Football
2
21 Triathlon
2
35 Basketball
2.5
7 Swimming
3
5 Basketball
1
12 Track and Field
2
7 Basketball
3
12 Basketball
2
22 Swimming
3
5 Rock Climbing
2
14 Badminton
2
0 Soccer
2
55 Basketball
2
Eating
Page 7 qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
2
2
3
3
2
2
3
1
2
2 7 Tennis
3 Basketball
16 Eating
66 Table Tennis
3 Swimming
5 Table Tennis
2
27 Baseball
3 Tennis
3 Basketball
Biking
4
7 Basketball
2
11 Soccer
3 INT_MAX
Running
2
7 Biking
3
0 Skiing
2
33 Football
3
3.141592654 Cricket
1
649 Basketball
2
31 Baseball
4
2 Basketball
3
7 Eating
1.5 e
Frisbee
3 444444000000 Sleeping
2
3
12 Sleeping
2
6 Basketball
3
1024 Swimming
5 Badminton
2
Badminton
2
8 Gaming
2
7 Running
2.25
2 Coding
2
2147483647 Cycling
2
666
3
3 Eating
3
2 Ultimate Frisbee
2
7 Badminton
2
8 Badminton Page 8 qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Favorite Physical Activity to Watch
Ice Skating
Volleyball
Basketball
Basketball
Soccer Favorite Show
House of Cards
Top of the Lake
Always Sunny Football 24
JoJo
Sherlock
Changes but currently Firefly
Yahari Ore no Seishun Love Come wa Machigatteiru
bilibili
Game of Thrones Soccer
Gymnastics
Cricket True Detective
nikita
Friends Basketball How I Met Your Mother
One punch man
Suits
game of throne
agents of shield
The Office
Game of Thrones
Stein's Gate
Che Dio ci aiuti
Scorpion
Flash
Fringe
Breaking Bad Swimming
Weapon fighting Gymnastics
eSports
Cricket
Basketball
Basketball
Basketball
Soccer
Swimming Soccer
Luge
Soccer
Basketball
Football
Volleyball
Anime
Basketball
Basketball
Soccer
eSports
Hockey
Basketball
Gymnastics
Basketball
Football
Basketball
Basketball
Soccer
Badminton
Football
Basketball Don't watch TV
Westworld
Game of Thrones
Westworld
Yahari Ore no Seishun Love Come wa Machigatteiru
Parks and Rec
Impractical Jokers
The Office
Game of Thrones
Bojack Horseman
Lost
White Collar
Big Bang Theory
Game of Thrones
Game of Thrones
True Detective
Breaking Bad Westworld
The strain
Naruto
Page 9 qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Tennis
Basketball Basketball
Volleyball
Football
Soccer
Soccer
Soccer
Soccer F1
eSports
Cricket
Soccer
Table Tennis
Basketball
Soccer
Basketball Breaking Bad
Person of interest
ŽÑ_Š¼¼Ž©ÂŒ_¤Œ¤
Westworld
Friends
How I Met Your Mother
Red vs. Blue
House of Cards
Westworld
Friends
Game of Thrones
Suits
South Park
Game of Thrones
Game of Thrones
Sherlock
Breaking Bad
Westworld
Game of Thrones
TBBT Flying
Soccer
Soccer Ž÷_Œ_Á¾Ð¡¤âŒøÙ
Big Bang Theory Soccer
eSports
Basketball
Basketball
Football Game of Thrones
wawa
Lost
Person of interest
Westworld Badminton
Soccer
Basketball That 70's Show
That 70's Show
Walking Dead Page 10 qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
Favorite Pokemon Favorite Social Network
Ditto
Twitter
Facebook
Magikarp
Reddit
Blastoise
Snapchat
Mankey
Twitter
Emolga
Facebook
Umbreon
Snapchat
Rayquaza
Reddit
Squirtle
Infernape
Meow two
Bulbasaur
Charizard snek
caterpie
Charizard
Mew
Charmander
Diglet Slaking
Charizard
Magikarp
Pikachu
Deoxys
Charizard
Pikachu
Pikachu
Charizard
Charizard
Charizard
Hodor
Evee->Vaporeon
dugtrio
Sylveon
Mew
Squirtle
Charizard
Charizard
Charizard
Magikarp
Doremon
eevee Piazza
Facebook
github
Facebook
StackOverflow
Slack
Snapchat
Linkedin
Tinder
Facebook
Piazza
Snapchat
Instagram
WeChat
Reddit
WeChat
Reddit
Facebook
WeChat
WeChat
Facebook
WeChat
Reddit
Facebook
Reddit
Snapchat
Tinder
WeChat
Reddit
Piazza
Twitter
WeChat
Facebook
WeChat
Facebook
Facebook
Facebook
WeChat
Christian mingle
WeChat
Snapchat Python experience? Favorite Hobby Yes
Some
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
No
Yes
Some
Yes
Yes
Some
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Some
Yes Reading
Violin
Sleep
Manga
Guitar
Writing Yes
Yes
Yes
Yes
Yes
No
Yes
Some
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
No
No
No Page 11 Anime
Sleep
Reading
Film
Ice skating
Gym
Data Structure
existential crisis
Cooking
Guitar
Exercise
Gym
Ping pong
Music
anything besides coding
Singing
Photography
Figure Skating
Meeting People
Origami
Jogging
Eating
Photography
Snowboarding
Lifting
Reading
Tea collecting, triathlon
YouTube
Sleep
Track
Lifting
Guitar
Sleep
Movie
Sleep
Bodybuilding
Eating qattachments_80c591b04d0c38f44c7ce41538813d8d03efb092
shrek
sadoxi Inferno
Charizard
Rayquaza Charizard Snorlax
chamander
Bulbasaur Latios
Ditto
Jigglypuff Mewtwo
Togepi
Pikachu Charmander
Marshtomp Charizard WeChat
MySpace
Bilibili
WeChat
Piazza Piazza
Snapchat
4Chan
Twitter
Facebook
Facebook
Piazza
WeChat
github
Instagram
Reddit
Facebook
MySpace
IRC
Houseparty
Snapchat
WeChat
QQ
WeChat
WeChat
WeChat
WeChat
WeChat
WeChat
Reddit
Instagram
WeChat
WeChat
WeChat
WeChat
github Yes
Yes
Yes
No
No
No
Yes
No
Yes
No
Yes
Yes
No
Yes
Yes
No
Yes
Some
Yes
Yes
Yes
Yes
No
No
Yes
Yes
No
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
Yes
Yes
No Page 12 Drawing
Theatre
Anime
Cooking
Sleep
Music
Guitar
Chess
Kino
Reading
Theatre
Electric guitar Skiing
Guitar
Cooking
Bug house
Piano
Basketball
Sleep
Model UN
Eating Basketball
Cooking
Cooking
Movie
Meditation
Photography
Photography
Gaming
Cello
Frisbee
Chess
Travel