Quora Challenge "Views" - Data Import


In [24]:
json_data = open('../views/sample/input00.in') # Edit this to where you have put the input00.in file
import pandas as pd
import json

data = []
for line in json_data:
    data.append(json.loads(line))

data.remove(9000)
data.remove(1000)

df = pd.DataFrame(data)

In [25]:
context_topic_df = df['context_topic'].apply(pd.Series).rename(columns='context_topic_{}'.format)

In [26]:
context_topic_df


Out[26]:
context_topic_followers context_topic_name
0 500022.0 Movies
1 179.0 International Mathematical Olympiad (IMO)
2 614223.0 Science
3 614223.0 Science
4 1536.0 Android Tablets
5 91.0 Smartphone Applications
6 241809.0 Startups
7 NaN NaN
8 3006.0 Warfare
9 224.0 Boston Marathon Terrorist Attacks (April 2013)
10 4155.0 Organization
11 304.0 Web Development on Mac OS X
12 3292.0 United States Governments (Federal, State, Local)
13 13867.0 Parenting
14 72820.0 Biology
15 2049.0 Tablet Devices and Tablet Market
16 999.0 Luxury
17 39744.0 Web Development
18 3566.0 Online Video
19 268430.0 Television Series
20 74.0 Noodle Education
21 490.0 Online Reputation
22 264984.0 Dating and Relationships
23 6608.0 Science and Religion
24 1707.0 Democracy
25 2450.0 Wanting and Making Money
26 3567.0 Private Equity
27 238905.0 Facebook
28 238905.0 Facebook
29 986.0 Glenn Gould
... ... ...
9970 35.0 Public Restrooms
9971 7361.0 What Does It Feel Like to X?
9972 NaN NaN
9973 7735.0 Kolkata, West Bengal, India
9974 2763.0 Acoustic Guitar
9975 240658.0 Fine Art
9976 130510.0 India
9977 614223.0 Science
9978 1115.0 Meeting New People
9979 307.0 Configuration Management
9980 252.0 Holi
9981 2360.0 Laptops
9982 167230.0 Investing
9983 2080.0 Driving
9984 1892.0 Lacrosse
9985 3551.0 Human Rights
9986 130510.0 India
9987 526597.0 Business
9988 NaN NaN
9989 238905.0 Facebook
9990 3327.0 Google Docs
9991 382503.0 Health and Wellness
9992 241809.0 Startups
9993 331.0 Indonesian (language)
9994 199.0 Technology Industry in Israel
9995 5652.0 Social Entrepreneurship
9996 10143.0 Jobs
9997 8017.0 Sarcasm
9998 2421.0 Kashmir
9999 64684.0 Venture Capital

10000 rows × 2 columns


In [27]:
cleaned_df = pd.concat([df.drop(['context_topic'], axis=1), context_topic_df], axis = 1)

In [28]:
cleaned_df.shape[0]


Out[28]:
10000

In [29]:
train = cleaned_df[:9000]

In [30]:
test = cleaned_df[9000:]

In [31]:
test


Out[31]:
__ans__ anonymous num_answers promoted_to question_key question_text topics context_topic_followers context_topic_name
9000 NaN False 0 90 AAEAACoD29W+HelUgB32vNEdu0NGxqJi7SH91iH1FLvNDOj2 DCI, or should it be RIC(Role/Interaction/Cont... [{'followers': 24761, 'name': 'Software Engine... 24761.0 Software Engineering
9001 NaN False 0 0 AAEAAIEmRDzBkZ9M9+ff9T/chVUceCbKUjDRUevvvu5qU7ix What agreement does hotwire have with partner ... [{'followers': 110108, 'name': 'Hotels'}, {'fo... 789.0 Hotwire
9002 NaN False 3 0 AAEAADPyyYuxYuSes2G7E9LHLkxu9ZNU6E237WmY1YOe/x0E Are all Autism or Asperger Syndrome people Int... [{'followers': 715, 'name': 'Asperger Syndrome... 828.0 Autism
9003 NaN False 1 0 AAEAAHZRcTcYkYH933/Cssn032ygfGEqeWYsmkQNDzoVGdA/ What businesses hire 15 year olds? [{'followers': 526597, 'name': 'Business'}] 526597.0 Business
9004 NaN False 1 0 AAEAAD/FZeneJxjntn5ZNSVPrjE8H7zsPVePpjl6GjCgUVK2 What are some great table wine magnums for aro... [{'followers': 13119, 'name': 'Wine'}, {'follo... 13119.0 Wine
9005 NaN False 0 0 AAEAAEaEgf32q+1yViJeHIJAuLQPZuAAv/Btejc3b/gSDgZc Why is there such a big power gap, between the... [{'followers': 4649, 'name': 'Politics of Indi... 4649.0 Politics of India
9006 NaN False 6 200 AAEAALsqS9OhREC42UojcxGk0w0xJKukJ4AFRvNYSGgD34Bw Who is your favourite couple in a comics unive... [{'followers': 8760, 'name': 'DC Comics'}, {'f... 7310.0 Survey Questions
9007 NaN False 1 0 AAEAAHHRJ0BlvQiYaY4jFjupBH/rT+SSVQR7RA9VaqhLHaut What are some good places to watch sports in M... [{'followers': 3776, 'name': 'Manhattan (NYC b... 3776.0 Manhattan (NYC borough)
9008 NaN True 0 0 AAEAACWN2WzcacP0QeYb1R6i9/AwT14+CQxOYsGWuWSDyTbY What are some websites designers visit frequen... [{'followers': 5782, 'name': 'Dribbble'}] 5782.0 Dribbble
9009 NaN False 5 0 AAEAAL/9YN4leLj5G1q+OyqQ/vk+bm8gB29rsa4YC1uox4Vk Should we have a President of the Internet? [{'followers': 773218, 'name': 'Technology'}, ... 88471.0 The Internet
9010 NaN False 2 200 AAEAABqTNMM5ooou6dc6goW1jlnSTKePQFtnj5mvXWen/Ipd What is the evolutionary advantage of moths an... [{'followers': 556, 'name': 'Evolution (proces... 556.0 Evolution (process)
9011 NaN False 1 0 AAEAAFkVTXgpL1MeFPsD4PhGaftpGlEPcl5VWImjTM7bU3/W Why do so many stores in New York have long li... [{'followers': 24781, 'name': 'Retail'}, {'fol... 282900.0 Marketing
9012 NaN True 0 0 AAEAABiOwguGI1lILAGwbkPVhGuHQpFn4WiPfa1o9U8RjFbb How does the financial reward of creating and ... [{'followers': 41458, 'name': 'Television Busi... 41458.0 Television Business
9013 NaN True 1 120 AAEAAJo0yQjaLPZysmGuk7bgctmnO6v+3NxoBEpNYjPMb0B4 Would you be interested in a feed that display... [{'followers': 7310, 'name': 'Survey Questions... 4004.0 Startup Ideas
9014 NaN False 2 0 AAEAAB2v4935tdkYURjLB/iDeWvl45iTNYhFG1prQeFjzo4i What is the business model of gaana.com? [{'followers': 321001, 'name': 'Entrepreneursh... 2660.0 Gaana.com
9015 NaN True 2 0 AAEAALJaYVbBydD/6e/xXXO7mJvH0/JVd9d4yHKU0Y06MUoQ How can I split an email conversation in Gmail? [{'followers': 38391, 'name': 'Gmail'}] 38391.0 Gmail
9016 NaN False 3 0 AAEAAHYlmr8+DzSL7h9p8a4RE2pnFaPnb3TETVHvEoZ11TmX How easy is the German language? [{'followers': 988, 'name': 'German (language)... 988.0 German (language)
9017 NaN True 2 30 AAEAAPZSaoGHckv00smkoIAAUYCfden8K9ZudYK/eM9exU1T What would you if you could stop time? [{'followers': 731, 'name': 'What Would You Do... 731.0 What Would You Do If X?
9018 NaN False 0 0 AAEAAOrnDPcIl8r4dKNTds9OJELueKL6xZVOj/kCa7ampXyY What are less-known names of some atypical sha... [{'followers': 16551, 'name': 'Facts and Trivi... 151.0 Shapes
9019 NaN False 0 0 AAEAAGHq58yiEm4rfQ6mFtZUE2iN08E4KoTdu1CTagYuZ33p What are the most innovative marketing uses of... [{'followers': 29, 'name': 'Location-based Mar... 282900.0 Marketing
9020 NaN False 2 400 AAEAAGMs/2HJgXjZ9tK9zqOR7Gh+7DdcKjqjlzniHlHnwflm What are some alternative conceptualizations o... [{'followers': 33423, 'name': 'God'}, {'follow... 33423.0 God
9021 NaN False 1 0 AAEAAJo8cflZCA3hcwCzV5yxXT9qe2viR3mZs7RwHpB40ncw Is there a Happy Bodnick meme? [{'followers': 494, 'name': 'Marc Bodnick'}] 494.0 Marc Bodnick
9022 NaN False 2 0 AAEAAIZV7jnw7LGFDGc/Ldse3CJl52+GCOkuiR8DM3nVG7jC Why there is an Age limit in Olympic Soccer, w... [{'followers': 66768, 'name': 'Football (Socce... 322541.0 Sports
9023 NaN False 1 0 AAEAAFdnuShyaJ85KUXcjsJfiDXKbEqvxo0FxAjrt32tvFFQ What would happen if China linked the Chinese ... [{'followers': 333543, 'name': 'Economics'}, {... 333543.0 Economics
9024 NaN False 0 0 AAEAAGrWxL8SnVtVEG7tsu4JortfnuosAswBPKeymfrLYTiY Was Rehoboth Beach, Delaware seriously affecte... [{'followers': 61, 'name': 'Rehoboth Beach, De... 61.0 Rehoboth Beach, Delaware
9025 NaN False 2 9580 AAEAAMZG9G0/WGABkSj04y6igmOTzdxOHZfwkTdcgUqjLijN If Shah Rukh Khan wrote a book, "How to be Sha... [{'followers': 500022, 'name': 'Movies'}, {'fo... 35412.0 Shah Rukh Khan
9026 NaN True 13 150 AAEAAHH+Aquci2tRcdZGlJInuYdkHkMUz4RbChBnwGss1fhN What can we expect from Christopher Nolan's In... [{'followers': 4, 'name': 'Interstellar (movie... 4.0 Interstellar (movie in development)
9027 NaN True 3 190 AAEAAAt9WYSIk+oxhUOG1hfxWq2RqBBi2JPUyRfGo0Am/g88 What are some businesses, in which the real so... [{'followers': 274839, 'name': 'Business Strat... 526597.0 Business
9028 NaN False 7 600 AAEAAJZa8tqrwo7AdudPrXTKAMF7eFcIzsA4zwVyTEA9qNf8 What are the best ways to guarantee a return o... [{'followers': 424, 'name': 'Quora User Tips'}... 424.0 Quora Credits
9029 NaN False 1 0 AAEAAFOkBI5LhzxTJ+iOcefXdpIgo3WnnqgDJk8gD61ffBnG Could anyone suggest me a name for an event ma... [{'followers': 278, 'name': 'Event Management'}] 278.0 Event Management
... ... ... ... ... ... ... ... ... ...
9970 NaN False 7 0 AAEAAAHZ7eoo1x7ZduZlk826XPxN/yuX5x0SQHtoLpsxK2MA Is it OK to use the disabled restroom in rest ... [{'followers': 46198, 'name': 'Manners and Eti... 35.0 Public Restrooms
9971 NaN False 4 0 AAEAAKBzcyFahiqWIQ5HnBOr6JGdxyiXSuzDXaIP8LK/AVCW How does it feel like to actually be 999999th ... [{'followers': 7361, 'name': 'What Does It Fee... 7361.0 What Does It Feel Like to X?
9972 NaN False 0 0 AAEAAPg3XukDQ+HavVquEyHBWuoif46lRe787qBNZ0cy7c60 Who are the biggest trolls of WWII? [{'followers': 47252, 'name': 'World War II'},... NaN NaN
9973 NaN False 5 0 AAEAAIOmikV3Q8HsiQ3byAbxKOXi6BqpPNIcGGdTe/y4PCQs What are some good "vegeterian" restaurants in... [{'followers': 7735, 'name': 'Kolkata, West Be... 7735.0 Kolkata, West Bengal, India
9974 NaN False 3 0 AAEAAPL1yN77qhZM8ttw3/3DlTumpM9f7njgpVa8c+mxXPGW What is the best way to transport a guitar whe... [{'followers': 2763, 'name': 'Acoustic Guitar'}] 2763.0 Acoustic Guitar
9975 NaN False 0 0 AAEAAKMJys+KhCvsot3ulnAdamgxZUjM00y5KYW+O1ixN7LN How can we find why people buy vitrail dome? [{'followers': 240658, 'name': 'Fine Art'}] 240658.0 Fine Art
9976 NaN False 3 0 AAEAABirDGEz/r8CmOIGrPpe6UcwPtA7CS72NZoNGYcJv7VS What do you think that happens no where in the... [{'followers': 224, 'name': 'Indians On Quora'... 130510.0 India
9977 NaN False 5 200 AAEAAJ6R9EimCjDPYlIpjOBYRQ7CPxobn9C/xCwurd+Zp67w I see a lot of bad science being reported on m... [{'followers': 28, 'name': 'Science Journalism... 614223.0 Science
9978 NaN True 0 0 AAEAAJo09/QYxyDglnKJuYngbSfA0py6jXkx5MiLJDEg61LK Who designed the Martini mobile app that conne... [{'followers': 1115, 'name': 'Meeting New Peop... 1115.0 Meeting New People
9979 NaN False 0 0 AAEAANkBVF9hcaNrU0AGLY4ynp8xGV+2ymgibGsTST8wFDIB Hosted or Privated Chef/Puppet? [{'followers': 307, 'name': 'Configuration Man... 307.0 Configuration Management
9980 NaN False 4 0 AAEAAGKwWCFpoJsi/ZnroU3MhPB11LLDfYAcG+u3sHyNfDfv How would you justify the wastage of water dur... [{'followers': 252, 'name': 'Holi'}, {'followe... 252.0 Holi
9981 NaN False 1 0 AAEAAFrCnoffwcwVpDIsreCyT+XRzPuPt0wA5zpGaeKwh3AH Which processor is better for a graphic design... [{'followers': 773218, 'name': 'Technology'}, ... 2360.0 Laptops
9982 NaN False 1 0 AAEAAHz2iHfkZ17beSDLdG36mqh76iJxbvy7ltVq/hI3dxKN Is Warren Buffett investing in companies becau... [{'followers': 167230, 'name': 'Investing'}] 167230.0 Investing
9983 NaN True 3 0 AAEAAGizmW9Cn964/fe563GXfoIj8jhk98sNBvvobTYxWcj0 I've failed my driving test twice: how can I p... [{'followers': 2080, 'name': 'Driving'}] 2080.0 Driving
9984 NaN False 1 0 AAEAABuDHz22TdRoHnLiVYfQAyvh22kOL/zDvhoAJQoFUhRw Why are men's lacrosse and women's lacrosse so... [{'followers': 322541, 'name': 'Sports'}, {'fo... 1892.0 Lacrosse
9985 NaN False 0 0 AAEAAJKYJgaXheTZGWPCunOIbCsKbGcjD2w1ENUikQPDeNpA Because men are Human beings too do they deser... [{'followers': 3551, 'name': 'Human Rights'}] 3551.0 Human Rights
9986 NaN True 10 0 AAEAAFZUD0HT9fdkyj3oTR6Ew5cXqntfzyUQrAmPr3LiFRWu Why do many Tamils refer to themselves as Tam ... [{'followers': 50, 'name': 'Tamil Culture'}, {... 130510.0 India
9987 NaN False 0 0 AAEAAMXz0j0UAWLFLPK8SmQN5flyCv8HfYnXj3Gc6IOuDM5B How to start a website developing business in ... [{'followers': 526597, 'name': 'Business'}] 526597.0 Business
9988 NaN False 29 200 AAEAAN2HZuSZhaIt/UgzCSRzjztTUJQ2rDMOZmSC6enp4XDt What is the best rebuttal to "If it ain't brok... [{'followers': 364, 'name': 'Disruption'}, {'f... NaN NaN
9989 NaN False 1 0 AAEAAClprKo7msONt3rt+zrm/fP2ZkDg4AK6nBx6zMQkS0ky Facebook app center (versus) existing app stores? [{'followers': 6404, 'name': 'Google Play'}, {... 238905.0 Facebook
9990 NaN False 0 50 AAEAAJCL484wkZIHiRw1MLBu33qqxkTmuJGDIrEgW4vMnyqu Why do Bold fonts and Italics disappear when c... [{'followers': 1915, 'name': 'Google Drive'}, ... 3327.0 Google Docs
9991 NaN False 0 0 AAEAAC72X8TZvRNVSYZ6hTMnTfpBaHPuFpodk23H3xfrK6NH Why does being cold make you catch a cold? [{'followers': 382503, 'name': 'Health and Wel... 382503.0 Health and Wellness
9992 NaN True 1 0 AAEAAM10T++NbYU9JFMEb6QxUnhc5LJxtkOvG1HhfuxSpTg3 What are the hottest under-10 person startups ... [{'followers': 164924, 'name': 'Lean Startups'... 241809.0 Startups
9993 NaN True 0 0 AAEAAMPrlsjCEejyiB4x6Nmvi4yEMD5fUpJZo/WV/oc1L/Yk How do people from other countries think about... [{'followers': 331, 'name': 'Indonesian (langu... 331.0 Indonesian (language)
9994 NaN False 1 200 AAEAAFF/WfbxS4V2roHkQ+WEgqXcVXxTCljXMuGkslg7XtOq What's the average deal size of an Israeli M&A? [{'followers': 199, 'name': 'Technology Indust... 199.0 Technology Industry in Israel
9995 NaN False 2 0 AAEAADHmhdj7ddMsxwLxIORZC+IfLoydhg+FXTwjBssCfemU What is the best career path to take to become... [{'followers': 256, 'name': 'Social Impact'}, ... 5652.0 Social Entrepreneurship
9996 NaN True 3 0 AAEAAF9ASgzjooq/SgiJg58it0eZ6PPYv8B/r4k6gH8VhdCG Is having a facial piercing considered unprofe... [{'followers': 4801, 'name': 'Engineering Recr... 10143.0 Jobs
9997 NaN True 3 0 AAEAAHaDxug0N4SrFLa65nyX0onGDf3C7DpBBF+u/4MTu9ye How does it feel to get sarcastically insulted... [{'followers': 8017, 'name': 'Sarcasm'}] 8017.0 Sarcasm
9998 NaN True 3 60 AAEAABtiDQZgE2LOLxtgl33uaw4xfhMDFqlWV4wVsE9H/Dcq Why did Kashmiri Hindus have to leave their ho... [{'followers': 9393, 'name': 'Islam'}, {'follo... 2421.0 Kashmir
9999 NaN False 3 0 AAEAAL8xXMY8ocS5aVwA+01/21LZ29oejC1zVXl2eS+a+9J6 Is it possible to become a successful venture ... [{'followers': 64684, 'name': 'Venture Capital'}] 64684.0 Venture Capital

1000 rows × 9 columns


In [32]:
train


Out[32]:
__ans__ anonymous num_answers promoted_to question_key question_text topics context_topic_followers context_topic_name
0 2.089474 False 4 0 AAEAAM9EY6LIJsEFvYiwKLfCe7d+hkbsXJ5qM7aSwTqemERp What are some movies with mind boggling twists... [{'followers': 500022, 'name': 'Movies'}] 500022.0 Movies
1 2.692308 False 1 0 AAEAAHM6f92B9jt43/y913/J7ce8vtE6Jn9LLcy3yK2RHFGD How do you prepare a 10 year old for Internati... [{'followers': 179, 'name': 'International Mat... 179.0 International Mathematical Olympiad (IMO)
2 4.612903 False 1 0 AAEAAGzietPvCHLFvaKCjng43iiIeo9gAWnJlSrs+12uYtZ0 Why do bats sleep upside down? [{'followers': 614223, 'name': 'Science'}] 614223.0 Science
3 8.051948 False 1 0 AAEAAM2Sk4U3y4We5TELJXRQgIf6yit5DbbdBw6BCRvuFrcY Tell me everything about the Leidenfrost effec... [{'followers': 614223, 'name': 'Science'}, {'f... 614223.0 Science
4 0.150943 False 0 0 AAEAALb43r/fn9KRKqJ0itd3NGbqZZSZalzi7vaulLxNGzeL Is the Nexus 10 any good despite the dual core... [{'followers': 1536, 'name': 'Android Tablets'}] 1536.0 Android Tablets
5 0.084507 False 0 0 AAEAABSJk8mrfAjuQuxEI6PV2rfGGcnuq/I5JyE0VJvYSoRp Is smartphone app download duplication account... [{'followers': 91, 'name': 'Smartphone Applica... 91.0 Smartphone Applications
6 1.073944 True 1 200 AAEAANLGb0hKlFULx6BPXvVvHQ1SJ2jJTqDCVighUGs/ZDya Are there any CEO's that go by a different nam... [{'followers': 526597, 'name': 'Business'}, {'... 241809.0 Startups
7 0.007299 False 0 0 AAEAAJinkGKp/YRlvWhFbapFNzPkD7coBuf4QRwsmN/c3q7Z Guys who love being sissies? [{'followers': 289, 'name': 'Needs to Be Clear... NaN NaN
8 0.298893 True 1 0 AAEAAB0zSrCTxmdSYxoC1KD0HYeDwTzOyK2lBiXzuZwhhmgn How does one successfully become a conscientio... [{'followers': 59, 'name': 'Pacifism'}, {'foll... 3006.0 Warfare
9 30.614035 False 3 0 AAEAAA7uRr9KzVD3rd+L3OptfwxaWFYfE6D8Wqskxx+ZkfGb How do people in countries with regular and la... [{'followers': 224, 'name': 'Boston Marathon T... 224.0 Boston Marathon Terrorist Attacks (April 2013)
10 24.250000 False 0 0 AAEAAFHJ+5Ozj1TQKLUwzB/pIwiXMwtTJip8NQO1jCCyRS5a How do top entrepreneurs/CEOs stay organized a... [{'followers': 321001, 'name': 'Entrepreneursh... 4155.0 Organization
11 1.666667 False 0 0 AAEAAM3WIWO/Ct/u5SvzPHfwwrHNWrPgHd8Ch7/QdM6CjfZL What companies/independent developers located ... [{'followers': 199, 'name': 'Technology Indust... 304.0 Web Development on Mac OS X
12 0.006231 False 0 0 AAEAAI0XKapeO3+B75zZYu1Kjv5SGn+Mm/4qT3rBNJrDNKce How can I call and talk with President Obama o... [{'followers': 1240, 'name': 'U.S. Presidents'}] 3292.0 United States Governments (Federal, State, Local)
13 0.575972 True 1 100 AAEAAMRnMKIzVIfH55p+aKXak1M0vBd2m7xNKm5KttYyVspo What do parents wish they had known before hav... [{'followers': 26, 'name': 'Deciding Whether t... 13867.0 Parenting
14 5.220859 False 2 0 AAEAAFsd5v511xAQgtEaPDHb+fYF8YSJnsRuMd7715LVQQPf How much time does it take to go from DNA to p... [{'followers': 3693, 'name': 'Medical Research... 72820.0 Biology
15 0.079755 False 0 0 AAEAAOnLQc1KPDw0pqCMpROkdovdRCzJlTsI5nDo9vxjcOm+ What % of tablet users use a stylus? [{'followers': 2049, 'name': 'Tablet Devices a... 2049.0 Tablet Devices and Tablet Market
16 1.075758 False 0 0 AAEAAI0A/7ASkze8LKdTLRwCFtUcFZ2xIpNnS55Zk1xtCwXN Which company make awesome luxury coach? [{'followers': 999, 'name': 'Luxury'}, {'follo... 999.0 Luxury
17 0.717557 False 1 0 AAEAAKKuKEgb+lBKi1iEEST89zLKFr/88CUAwC9xeCdGYss1 I Require professional and creative web desig... [{'followers': 39744, 'name': 'Web Development'}] 39744.0 Web Development
18 1.622010 False 2 0 AAEAAJloaH19a32hbe1Cs0wdW8WWptHbbaa5JG7dKbMwvtaJ What are the short/medium prospects of service... [{'followers': 11842, 'name': 'Internet Advert... 3566.0 Online Video
19 3.388889 False 0 0 AAEAAFHbVuHDWmLslFWH8UZMnN7M5VHntFVDpY19+3ndhmy5 Why can't we create something like game of thr... [{'followers': 268430, 'name': 'Television Ser... 268430.0 Television Series
20 11.457143 False 0 0 AAEAAKkkEpxZp4qBn45yEhzGTnJNhB5e/Mppn75kx1on5ajr Would Noodle make other education lead generat... [{'followers': 167176, 'name': 'Business Model... 74.0 Noodle Education
21 1.013889 False 1 0 AAEAABu6kZw48xJyS1xXW3RjQ0xANWgzwjp6LLVTryDWUM8I ORM is all too often seen simply as minimising... [{'followers': 490, 'name': 'Online Reputation... 490.0 Online Reputation
22 0.389474 True 1 0 AAEAANJFMVE7CEr6gX3LEC9NWGz0a65TjFd1AjHMY9CWujBJ What are some of the funniest noises you have ... [{'followers': 67265, 'name': 'Sex'}, {'follow... 264984.0 Dating and Relationships
23 0.319231 False 1 0 AAEAAKTTk5EUSD+0CPGP0gLS0aBQR97xe0p2+DPRX+ddtoV2 Was Moses talking about humans becoming fully ... [{'followers': 2525, 'name': 'Theology'}, {'fo... 6608.0 Science and Religion
24 4.000000 False 4 200 AAEAAFJxWj/4n1NhOgwpS0d5X7tcBia4jBtjrfw6YxNcYXDr 'Scarcely a human freedom has been obtained wi... [{'followers': 4332, 'name': 'Occupy Movement'... 1707.0 Democracy
25 0.174194 False 0 0 AAEAAH+k9PIQg6lOxHRIqXYE5u18aWO4QqJZTtdahJw9+grv Do actors get paid after they do the movie or ... [{'followers': 2450, 'name': 'Wanting and Maki... 2450.0 Wanting and Making Money
26 0.678322 True 0 0 AAEAAG1dK7AL02j78ugkPaKf5TiFb6iBCaIICXxUd5OYpQYz Private Equity in relation to Movie Industry,c... [{'followers': 3567, 'name': 'Private Equity'}... 3567.0 Private Equity
27 1.007246 False 2 120 AAEAAA15xfSTbyLayedu+P4P6upyw1gZisruGcd5sBeOiO2w What language was used by Mark Zuckerberg to w... [{'followers': 238905, 'name': 'Facebook'}] 238905.0 Facebook
28 46.333333 False 0 0 AAEAALJZ+JSLst8wPq+EApQqSTqcCW9iaHg7OWcdwg+xJEVo How employees at Facebook avoid procrastinatio... [{'followers': 238905, 'name': 'Facebook'}] 238905.0 Facebook
29 0.615385 True 0 0 AAEAAETPeE1zK+aIF5IeOLu2EzMwzSM22EM4i14ZnwDTU17t Was Glenn Gould a fast typist? [{'followers': 986, 'name': 'Glenn Gould'}] 986.0 Glenn Gould
... ... ... ... ... ... ... ... ... ...
8970 0.044610 False 0 0 AAEAAKy7JJbuCln18hVXHhNCqaW/2t4BOJekq4EoJZeZlQAf When was the Quora application launched for An... [{'followers': 3899, 'name': 'Quora (company)'}] 3899.0 Quora (company)
8971 0.028571 False 0 0 AAEAAIPL+PIfMKP6q/d3vCLPeN6qaE5wVTv9jyLyP46riITO 1A group element to show flame test why? [{'followers': 13, 'name': 'Flame Effects'}, {... 53.0 The Flame
8972 0.356364 False 0 0 AAEAAFbZen2AwK+cWhTuxYq89OYYGUdvPKxObTA49ZZY5EoF Hire best webdevelopers to design and maintain... [{'followers': 39744, 'name': 'Web Development'}] 39744.0 Web Development
8973 101.000000 True 1 0 AAEAAEKenPCvJnNPSn3GoyxJGHOgO9Ft1sXtcQIRtzX36ls7 Is it absolutely necessary to have a lot in co... [{'followers': 264984, 'name': 'Dating and Rel... 264984.0 Dating and Relationships
8974 0.424658 False 0 0 AAEAAJ6h5w42SdKWHM1ba0mDrLXfRNF35x5J1ImAXc5k7r9g What civilization had the earliest written num... [{'followers': 1460, 'name': 'Numbers'}, {'fol... 0.0 Numeration
8975 1.787879 True 2 0 AAEAAI0sA6MSlU+uVCoRL9a3wpk5dt0Mnwy/8h0l2jkqoE9K I am never contacted by recruiters (I don't ha... [{'followers': 7928, 'name': 'Recruiting'}] 7928.0 Recruiting
8976 0.183673 False 0 0 AAEAAHQncZgikc5wl/qwturXJ89iVLVLNrUJNGpMfiSGkZLK What is finance software? [{'followers': 4729, 'name': 'Software'}] 4729.0 Software
8977 0.118902 True 1 0 AAEAAIo1t0EvlXTB3vDMjt4DCsJeG6U43ZF/aD8SiMmlmof0 What impact do foreign currency fluctuations h... [{'followers': 93447, 'name': 'Amazon'}] 93447.0 Amazon
8978 0.494382 True 1 0 AAEAACkrgngYk0Gq2+2Jm/c+yfNG3tFyUrZAUpEsbvfAnuAo What are some tips to write a great sales copy? [{'followers': 4859, 'name': 'Sales'}, {'follo... 4859.0 Sales
8979 2.323699 True 1 0 AAEAAKF/1Zvtgov2mB0Ji4jg1/0aE+lQkKxIEhQuLX8yuwzY Is it a good idea to use technical jargon when... [{'followers': 13108, 'name': 'Career Advice'}] 13108.0 Career Advice
8980 0.044944 True 1 0 AAEAAN2Q0FsMgTWonNul3FPog92E1XkMDr+1QcPsIivJyv/z What's it like to work at Done Genetics? [{'followers': 3, 'name': 'Done Genetics'}] 3.0 Done Genetics
8981 2.752941 True 3 0 AAEAAPJKiEWYD6YX59MhOtX8+DnzOqzul+SpdL2Xnl0KJoxx Where can I connect with people in general in ... [{'followers': 6467, 'name': 'Colleges and Uni... 20107.0 Mumbai, Maharashtra, India
8982 0.011662 True 0 0 AAEAAOZFkLJxzpcxaMgr6sM3pBQcOKWQq+ykds/w3GXXgZqo Have anyone any concern or recommendation for ... [{'followers': 289, 'name': 'Needs to Be Clear... 3168.0 Dublin, Ireland
8983 0.133929 False 0 0 AAEAAFxvsqu2YCjgWfq2u+anT+J0OXvtANXSu+elB7CuM1G2 How can I tell facebook to stop emailing me? [{'followers': 238905, 'name': 'Facebook'}] 238905.0 Facebook
8984 0.207373 True 1 0 AAEAAHaEN4jlW0hrNd+wj1Xx9bWV2XiE0+5kkBbpk0cS/XCD Who does cover hound use to provide auto rate ... [{'followers': 809, 'name': 'Auto Insurance'}] 809.0 Auto Insurance
8985 0.662722 True 2 0 AAEAAO10zYF1GIDQenYcsr4KV8T5f53wX0d491daxFrxJfxE Is Wuthering Heights a feminist text? [{'followers': 590279, 'name': 'Books'}, {'fol... NaN NaN
8986 4.123288 False 1 200 AAEAAIO1CRxV7oxl//ejIL5mkNUJqShjAlSNiOaXEiQFChq+ How will better audience data change the movie... [{'followers': 1, 'name': 'User Data'}, {'foll... 500022.0 Movies
8987 0.352941 False 0 0 AAEAAOKeIMX2TbFS2CdHXtBWs++0egdI5p4FB2TZTlLyph7D In what condition to descendants of royalty live? [{'followers': 361, 'name': 'Royalty'}] 361.0 Royalty
8988 0.488525 False 0 400 AAEAALlzDzfzi6ULFlDFEbxjfkQTdJRmyDeB7Oz343GX3Zzz Will the developing world be more innovative d... [{'followers': 24985, 'name': 'Innovation'}, {... 24985.0 Innovation
8989 6.908078 False 5 0 AAEAAJj02/B0zzfVYoV/ujoCNopCXWyQ1l1joancxgjHTOvc Are there living samurai in this age? [{'followers': 12423, 'name': 'Japan'}, {'foll... 782.0 Samurai
8990 2.077295 False 1 200 AAEAAF3/vH5TKSTV79CQ2wWCe7UPuPUQ7GqKZ+zy/WZpyWTS How is it like to hire a life coach or persona... [{'followers': 11233, 'name': 'Life Advice'}, ... 20706.0 Self-Improvement
8991 0.490798 False 2 400 AAEAABeFQkBTvekTH2LwM9QRMeaYrb43rq4KQTB3ixkjIUW6 What happens to my links if I disconnect my cu... [{'followers': 1483, 'name': 'Bitly'}, {'follo... 13867.0 Web Applications
8992 0.197080 False 2 0 AAEAAG1ehKZlxWfZ3u8Ty8xu5l2N+kghEcv62oITGGiqZj62 Can Curiosity record sound? [{'followers': 295, 'name': 'Curiosity (Mars R... 295.0 Curiosity (Mars Rover)
8993 3.375000 False 1 0 AAEAAITna52dCVn2KCVY3+xhMh4dbliiirA/gdi74f+v2zyG Is it realistic to think you can get a decent ... [{'followers': 6423, 'name': 'Germany'}] 6423.0 Germany
8994 0.482143 False 1 0 AAEAAB8MgrMHBPrcEd+z8uWtFtE0jU1VhHBx4bSj3dLaMait Can someone explain to me how the Syrian war b... [{'followers': 854, 'name': 'Syria'}, {'follow... 0.0 Syrian War
8995 2.850000 False 0 0 AAEAANESwEBxHZJt2IIhT1/YgqvPOOHySqU0TPMHvefVX6Rn How old are the wolves growly pants and truck ... [{'followers': 10123, 'name': 'Animals'}, {'fo... 10123.0 Animals
8996 0.274648 False 0 0 AAEAABT6OZZisoRkeAFNxYWAssLUu45g4iNjeQiaAEVkPa2Z What is the best Agenda (notes, gant charts, C... [{'followers': 7149, 'name': 'iPad Application... 7149.0 iPad Applications
8997 3.146893 True 1 0 AAEAAAUdDfIgSIYlFRrY4jOKvHsvSLmlKjyZ576oP8a+L694 December 2012: Are all the Hobbit films alread... [{'followers': 18741, 'name': 'The Hobbit (193... 146.0 The Hobbit (movie series)
8998 0.131086 False 0 0 AAEAADeVLG2awg6hG+dTiPKRiII64khN7fS/OeFLek4lg2QQ Rental Navigator asks...If you are a real esta... [{'followers': 7260, 'name': 'Real Estate'}] 7260.0 Real Estate
8999 2.738739 False 2 0 AAEAAKeoz9V34X6kt6Iq+ywD6JKTBkJxointHniuxnF2ejHa Energy of motion turns into mass? [{'followers': 199773, 'name': 'Physics'}] 199773.0 Physics

9000 rows × 9 columns