Facebook Friends Analyser?

A few months ago, I found an application on facebook that analyse people's friends with only a few clicks.

It showed me

1. How many male/female friends I have
2. which country I have the most friends from
3. percentage of single/not-single
4. the longest/shortest name
5. the most name my friends have
and so on..
but did not show details.

I wanted to do again, but I couldn't do it with some unknown reasons.

So, I decided to do it myself as I finished my exams so that have plenty of time.
I started on 3 days ago, and finally today, 10. July, I finished it.
Well, to satisfy my goal, I still have to do some more things, but as a first task, it is good enough.

My purpose of doing this was
1. to find out from which country I know people
2. How many I know people from each country
3. Where they are right now
4. How I met them / How I could get to know them

Methods
I did it in a super simple way.
(some people will think maybe I am too stupid to do this, or I could do something more productive rather than spending my time on my laptop for a few days)

I simply copied all the friends list from facebook to Microsoft Excel 2007.
I deleted some unimportant information such as pages, network links which followed them, and removed the whole links.

So I could get only names of people I have on facebook.
I looked through the whole lists to test myself whether I could fill the gaps without checking their profiles.
At first, I couldn't manage well to be honest. - Because the first name was too hard to reconise, so I had to check!
However, soon I could do it. 70% of people I did it on my own.
So started filling in with where they are from, where they are right now, How I knew them.

# Details
Name _ Nationality _ Current Place _ Home Country _ How I know
1. Current Place and Home Country is divided in to Country and its category
(1) Category : Asia, Africa, Europa, Eurasia, America, Latin America and Oceania
2. How I know: Common thing, Detail 1 and 2, and the place(country) I met them.

Basic information
I have 632 friends on facebook totally; 334 are female and 298 are male.

Q. Who are they? (Credibility 50%)
I can not say it is absolutely correct.
To make it trustworthy, I had to make sure what 'Nationality' means in this process.

(1) the Passport nationality?
(2) what they think about their nationality?
(3) the home country they have lived more than their half of life?
(4) the place that they were born?

I did not have enough time to research it, and I was too lazy to do it, so I just wrote as their homecity(place) that they put on the facebook, or what they said to me before, and so on.

A. Result:
totally 56 nationalities.

Germany is the most, and the least is..'are' some other countries.
Result is as below:

Q. Where are their home countries?

It can be as same as their nationalities, but just in case, I had to do it again with this question.

It is because of the cases such as

born in a country, but moved to another/got nationality or citizenship or whatever in another countries.

A. Results.

and 58 Countries


How can it be increased 56 countries to 58?
Well, I have to admit that there was a mistake, and I am, at the moment too lazy to edit it.
1 more venezuela, and 1 less in Spain.
and 1 more mistake/difference is going to be found sooner or later. :)

So, you can see most of them have the same figure from Nationality question.
But there are small differences in South Korea, Brazil, USA and so on.
This is because, of the case that I mentioned.
Differences are more or less because of some Korean people/family who immigrated/emigrated.

the next following question will be then, how many moved, and from where to where.


Q. Where are they actually right now?

As I am also not in S. Korea doing enjoying my last month as an exchange student in Germany, some of them, or most of them are also in another country doing their own work.

So I decided to figure out 'right now, where are the people?'

A. Results.

Since this is my first time to do this work, I could not manage comparing the data from their home country, so that figure out from which country to which country that they moved.

This time, all the data is just simple and focusing on 'right now'.

Current Location;

totally 52 countries


If you roughly compare with this result to previous one, you can find that there are more people in Germany, South Korea, France, Austria, Switzerland.

Also currently there are less people in some countries such as China, Japan, USA, Colombia, Brazil, Greece, Denmark and Ukraine.

Also, as I said above, the number of countries is also reduced from 56 to 52.

Q. How did I get to know them?

Are they all my school friends? - yes or no.

Are they all my old friends? - yes or no.

from the class? on the street? train? plane? hostel? club? birthday party? FROM WHERE?

So, I recalled all my memory and figure out how could I know them.

A. From Every where, actually.

It is actually the most important part for me that facebook application never showed.

As I looked through all the lists, there were a lot channel that I got to know them through.

This time, I listed them based on the place that I met and then simple categories such as school, work or parties.

There were 5 countries that I met almost all the people (610)

and 22 of the people haven't met me yet in anywhere.

Results (*least to most):

1. Ireland - 3

Last year, I was travelling Dublin, Ireland with one of my friends from Exchange Students Programme for 4(or 5)days. We stayed in a hostel near four courts.

3 of people I have on facebook were from the same hostel.

1 Brazilian (studying in Paris) , 1 American and 1 South Korean (both were studying in London).

2. France - 6

6 of people I know were from Paris on New Year.

At the end of year 2009, I went to Paris for a week to visit my friends that I know from Seoul. (They are French though.) We had a great private New Year Party, and 5 of them were friends, and 1 was cousin of my friend.

They are all French.

3. Austria - 16

Halloween 2009. I visited my Mexican friend, I knew her from summer in 2008 and she was exchange student in Wiener Neustadt, in Austria. There, I could get to know her friends, who were also exchange students there.

15 were friends of her, and 1 was a brother of one of them.

They were from USA, Canada, Ireland, Finland, Slovenia, Mexico, Spain, Korea and....... :)

4. Germany - 279

Because I met so many people in Germany I divided into 3 groups. - Osnabrueck, Worms and Other places

A. Osnabrueck. 57

Last summer, I did my Summer German course in Osnabrueck which is in north part of Germany for 1 months.

- 47 people who actually participated the German course with me

- 7 the tutors during the course

- 2 from the FH that I could know through one of the tutor

- 1 a friend of a participants of German course. she came to Osnabrueck from Berlin for a visit.

B. Worms 213

During 1 year in Worms as an exchange student, I got to know more or less 213 people

a. From the FH Worms 187

Related to the FH Programme

- Erasmus (Exchange students) 46

- Regular Students (actually studying/graduated/praktikum etc.) 139

- Teacher/Staff 2

b. Worms 26

Not only the people who are actually living in Worms. This means that we met in Worms so that it includes the visitors as well.

- Visitors for Friends (mostly Exchange students) 14: Most of them were from Spain (10), 2 from Grecce, 1 from Bulgaria and 1 from the other city in Germany.

- I've got to know through the others (Mostly Wormser): 10

- Etc. 2 : 1 was visiting FH on the day that the FH introduces the programme to the Gymmnasium students. The other one is from the Tab (like always)

* Even among the people that I've met from the FH, some of them were from the classes, through other friends. Also there were a lot of people that I just met in Tab, which is Students' club in the FH. =)

c. Other places 9

- 4 in Mannheim: Mannheim Stadtfest, Himbeerparty and Latinparty

- 1 in Bensheim when we went for the wine hiking

- 1 in Heidelberg for the castle-firework fest.

- 1 in Koeln, a girlfriend of a friend.

- 1in Munich, and a friend of one of Erasmus

- 1in Frankfurt, the funniest story, I'm sure only some of you can remember him when we went to cocoon for the first time. Our best friend from Frankfurt ;)

5. South Korea 306

Of course the MOST. but it's more simple than analysing German part. but also 3 parts: School, Work and Etc.

A. School 286

a. Primary school(Elementary School) 2

b. High School 6

- All of them are Koreans

c. University 278

- Regular Students 9: 1 South Africa, 2 India and I think rest of them were Koreans

- Students volunteering club activity: 9 all Koreans

- Exchange students from abroad 38: 2008-02(fall) 5 / 2009-01(spring) 33

: In spring, it was easy for me to get to know the exchange students because I was working for the international office in my University at that time.

- International Summer Semester 222: My school launched this programme in 2008 and I participated 2 times in 2008 and 2009. 88 of the people were from 2008 and 134 are from the last year, 2009.

B. Workplace 11

a. British Council, Korea 9 : from 2007 spring until 2008 autumn, I worked there. 8 of them are British/Irish who were/are teachers there for English courses and 1 is Korean who worked with me.

b. International Office, SKKU 2: my colleagues. 1 is from Czech Republic and the other is Korean. Both of them don't work there any more.

C. Other places 9

a. 1 is my German teacher in Korea.

b. people that I got to know through other friends 6: 2 Germans, 1 Korean-American, 1 Hong-kong-y, 1 French and 1 Dutch.

c. 1 friend of mine that I knew her from when I was 14 or 15, but we don't remember how we got to know.

d. **** My cousin who is in the states. 1

6. Haven't met me yet. 22

Some people using facebook to make new friends everywhere. I rather use it to contact existing friends.

So 22 people that I haven't met face to face, is unexpected for me. I thought it's quite a lot.

Not all of them were just added randomly.

There are some people that I actually going to meet very soon.

Some of them are just from the School.: The last months when I was working at the International Office, I could contact some students who were coming to my school, so because of that we added each other.

A. Going to meet soon 3: in Spain 1, in Korea 2

B. Exchange students at my University while I was/am in Germany for my exchange programme. 9

C. I have no idea 10

- including random adds (1 or 2)

- sister/friends of friends but not sure when we are going to actually meet in person. rest of them.

- through other website 1

# Pros and Cons about this Process

I took almost 3 days to finish this task. I do not call it as too simple or stupid task, because I did it for my own curiosity. I could have spent my time with other stuffs. tanning under the sun, watching good films, reading book or some more beer with friends. However it did not mean that I didn't do all those things because of this.

Of course I hung out with friends, watched film and so on. I just used my night time (almost after 1 am) to do this.

What I learned from this task is, "knowing people". When I could answer all the questions without any help but on my own, I was so proud of me. It did not matter that whey also knew me well or not, It is for 'me' knowing the people around me.

Some of them, I can call them as friends, some are just people I know and some of them are just 'I don't care'. But, even though I am not a closest person to them, it is not that bad just to know who they are, don't you think so?

It also made me think that it would be better that I could take care of them more carefully as long as I know them. You never know how you will meet them again in the future.... well.. :)

This time I simply calculated the figures.

Next time, I would like to research more about the facts such as the questions that I made above

: from where to where most people moved / why? / what are they doing there? or about photos something like this. :)

more likely a real psychologic questions.

Oh, the bad points of this process is...

My neck and shoulder really hurt!!!!!!!

What do you think about this?

Some weeks ago, I read 1 stupid (totally subjective view) posting from an online community.
some parts I understood, but generally I disagreed with the contents.

It was about certain types of girls that guys should avoid written by a Korean guy.


1. 어머님과 사이가 나쁜 여자
Who has a bad relationship with her mother
-> 정말 중요합니다. 엄마와 사이 나쁜 여자치고 성격 유들유들한 여자 못봤습니다. 뭔가 항상 악에 바쳐있어요. 미움도 강하고 가슴속에 한이 있는 듯해서 짜증이나 히스테리 받아주기가 어렵습니다.
This is very important. I’ve never seen any girl who has a good personality but has bad relationship with her mother. Always kind of got upset. This kind of girls are always hatred and something bad in their minds so really hard to deal with them when they’re annoyed.


2.'나 재밌게 해줘' 하는 여자
Who keeps saying ‘entertain me’
-> 무책임한 여자 부류들 중에 하나죠. 소개팅 혹은 데이트를 할 때 그 자리의 책임을 남자에게 모두 떠넘기려는 부류들입니다. 남자가 자신을 즐겁게 하지 않으면 쓸모 없다 라고 생각하는 부류들 입니다. 같이 만났는데 같이 대화도하고 교감해야지 남자가 무슨 광대입니까? 이런 여자들은 80%이상이 이기적이며 된장녀 기질이 농후합니다.
Unreponsibility. Whenever they have a chance to know new guys they hand on responsibility of the chance to men. They think if men cannot entertain girls, they are useless. When women and men meet, they have to communicate each other. Men are not clowns. 80% of this kind of women are usually selfish and likely to be posh.


3. 죽어도 지갑 안여는 여자
Who never open their wallet
-> 소개팅 후에 2달이 지나도록 지갑에 손도 안대는 여자 만나봤던 기억이 있는데요 정말 짜증나더라구요 하루는 맘먹고 돈없다고 빈 지갑 가지고 나갔더니 그렇게 준비성도 없이 자기 만나러 나왔냐는 이야기를 하더군요 ㅎㅎ. 뼛속까지 얻어먹는 근성으로 가득한 부류들입니다.
I’ve met one who never opened her wallet for more than 2 months after we’d met. Really annoying. One day I went out with empty wallet and told her I didn’t have any money. She told me back that I was very unprepared. They’re eager to make you spend more.

4. 싸울때 전화 확 끊는 여자
Hang up the phone suddenly when you argue.
-> 골치 아픕니다. 애초에 대화의 가능성 조차 열어두지 않는 여자이므로 상황은 점점 악화되기만 할 뿐 개선의 여지가 보이지 않는 암담한 연애를 하게 됩니다.
Pain in the ass. They never give any chance to make a conversation, so situation is becoming worse. You’ll have a relationship which you cannot see any improvement.


5. 남자와 친구가 될 수 있다고 믿는 여자
Who believes that men and women can be friends.
-> 열에 아홉 엄청 피곤한 스타일입니다. 주변에 일단 남자를 잔뜩 만들어 놓고 상대방을 속 태우게 하는 스타일인데요 남자가 맞대응 할 수 있을 정도의 어장이 있지 않다면 절대로 피해야 할 스타일 입니다. 예쁘고 현명한 진짜 고수 여자들은 어장 함부러 만들고 다니지 않습니다.
90% very tiring. Normally they make a lot of male friends and make the other very nervous. Unless men has same kind of fish net to compare, avoid them. Real pretty and wise women never make their fishnet easily.

6. 변덕스러운 여자
Moody ones.
-> 사귀면 정말 피곤합니다. 이런 경우 본인의 감정을 타인의 감정보다 훨씬 중요시 여기는 기질이 있습니다. 아무리 자신이 잘못했다고 해도 자신의 기분이 나쁘면 그냥 화내고 그냥 지릅니다. 이성적 사고가 결여되어 있습니다. 이런 부류와 사귀게 되면 온몸의 기가 다 여자에게 빨려들어가는 경험을 하실 겁니다. 그리고 여자 달래는게 상사 X핥는거 보다 더 기분 나쁠수도 있다는 것을 깨달을 수 있습니다
You’ll have a tiring relationship with these types. They think their own feeling is more important than the other’s. Although men apologise properly, if they still feel bad, they just shout and still be upset. They are lack of reasonable thinking. You’ll feel you’re energy is sucked up when you meet them. Making them happy can be much harder than licking your boss’s dick.


남자가 추구하는 이상형이 예쁘고 현명하고 지조있는 여성임을 감안할 때 앞선 부류의 여자들은 절대로 피해야할 스타일이라고 하겠습니다.
Regarding to the desirable types of women are pretty, wise and sincere(?), these types above are the most people that you have to avoid.

So what do you think?

I asked some friends of mine, who are Koreans.
well, they all said this was stupid.
(well, mainly I asked them about number 5 that I really don't agree)
Of course not every men think like this, but we cannot ignore that actually this is also not a minor opinion.

Why cannot men and women be friend, when they have boy/girlfriend?
Why do they think all the friends who are opposite sex with their boy/girlfriends are just fish in the fishnet not friends?

I will update about this later.

But,
What do you think about it?