{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Quora Challenge \"Views\" - Data Import" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": true }, "outputs": [], "source": [ "json_data = open('../views/sample/input00.in') # Edit this to where you have put the input00.in file\n", "import pandas as pd\n", "import json\n", "\n", "data = []\n", "for line in json_data:\n", " data.append(json.loads(line))\n", "\n", "data.remove(9000)\n", "data.remove(1000)\n", "\n", "df = pd.DataFrame(data)\n" ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "collapsed": true }, "outputs": [], "source": [ "context_topic_df = df['context_topic'].apply(pd.Series).rename(columns='context_topic_{}'.format)" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
context_topic_followerscontext_topic_name
0500022.0Movies
1179.0International Mathematical Olympiad (IMO)
2614223.0Science
3614223.0Science
41536.0Android Tablets
591.0Smartphone Applications
6241809.0Startups
7NaNNaN
83006.0Warfare
9224.0Boston Marathon Terrorist Attacks (April 2013)
104155.0Organization
11304.0Web Development on Mac OS X
123292.0United States Governments (Federal, State, Local)
1313867.0Parenting
1472820.0Biology
152049.0Tablet Devices and Tablet Market
16999.0Luxury
1739744.0Web Development
183566.0Online Video
19268430.0Television Series
2074.0Noodle Education
21490.0Online Reputation
22264984.0Dating and Relationships
236608.0Science and Religion
241707.0Democracy
252450.0Wanting and Making Money
263567.0Private Equity
27238905.0Facebook
28238905.0Facebook
29986.0Glenn Gould
.........
997035.0Public Restrooms
99717361.0What Does It Feel Like to X?
9972NaNNaN
99737735.0Kolkata, West Bengal, India
99742763.0Acoustic Guitar
9975240658.0Fine Art
9976130510.0India
9977614223.0Science
99781115.0Meeting New People
9979307.0Configuration Management
9980252.0Holi
99812360.0Laptops
9982167230.0Investing
99832080.0Driving
99841892.0Lacrosse
99853551.0Human Rights
9986130510.0India
9987526597.0Business
9988NaNNaN
9989238905.0Facebook
99903327.0Google Docs
9991382503.0Health and Wellness
9992241809.0Startups
9993331.0Indonesian (language)
9994199.0Technology Industry in Israel
99955652.0Social Entrepreneurship
999610143.0Jobs
99978017.0Sarcasm
99982421.0Kashmir
999964684.0Venture Capital
\n", "

10000 rows × 2 columns

\n", "
" ], "text/plain": [ " context_topic_followers \\\n", "0 500022.0 \n", "1 179.0 \n", "2 614223.0 \n", "3 614223.0 \n", "4 1536.0 \n", "5 91.0 \n", "6 241809.0 \n", "7 NaN \n", "8 3006.0 \n", "9 224.0 \n", "10 4155.0 \n", "11 304.0 \n", "12 3292.0 \n", "13 13867.0 \n", "14 72820.0 \n", "15 2049.0 \n", "16 999.0 \n", "17 39744.0 \n", "18 3566.0 \n", "19 268430.0 \n", "20 74.0 \n", "21 490.0 \n", "22 264984.0 \n", "23 6608.0 \n", "24 1707.0 \n", "25 2450.0 \n", "26 3567.0 \n", "27 238905.0 \n", "28 238905.0 \n", "29 986.0 \n", "... ... \n", "9970 35.0 \n", "9971 7361.0 \n", "9972 NaN \n", "9973 7735.0 \n", "9974 2763.0 \n", "9975 240658.0 \n", "9976 130510.0 \n", "9977 614223.0 \n", "9978 1115.0 \n", "9979 307.0 \n", "9980 252.0 \n", "9981 2360.0 \n", "9982 167230.0 \n", "9983 2080.0 \n", "9984 1892.0 \n", "9985 3551.0 \n", "9986 130510.0 \n", "9987 526597.0 \n", "9988 NaN \n", "9989 238905.0 \n", "9990 3327.0 \n", "9991 382503.0 \n", "9992 241809.0 \n", "9993 331.0 \n", "9994 199.0 \n", "9995 5652.0 \n", "9996 10143.0 \n", "9997 8017.0 \n", "9998 2421.0 \n", "9999 64684.0 \n", "\n", " context_topic_name \n", "0 Movies \n", "1 International Mathematical Olympiad (IMO) \n", "2 Science \n", "3 Science \n", "4 Android Tablets \n", "5 Smartphone Applications \n", "6 Startups \n", "7 NaN \n", "8 Warfare \n", "9 Boston Marathon Terrorist Attacks (April 2013) \n", "10 Organization \n", "11 Web Development on Mac OS X \n", "12 United States Governments (Federal, State, Local) \n", "13 Parenting \n", "14 Biology \n", "15 Tablet Devices and Tablet Market \n", "16 Luxury \n", "17 Web Development \n", "18 Online Video \n", "19 Television Series \n", "20 Noodle Education \n", "21 Online Reputation \n", "22 Dating and Relationships \n", "23 Science and Religion \n", "24 Democracy \n", "25 Wanting and Making Money \n", "26 Private Equity \n", "27 Facebook \n", "28 Facebook \n", "29 Glenn Gould \n", "... ... \n", "9970 Public Restrooms \n", "9971 What Does It Feel Like to X? \n", "9972 NaN \n", "9973 Kolkata, West Bengal, India \n", "9974 Acoustic Guitar \n", "9975 Fine Art \n", "9976 India \n", "9977 Science \n", "9978 Meeting New People \n", "9979 Configuration Management \n", "9980 Holi \n", "9981 Laptops \n", "9982 Investing \n", "9983 Driving \n", "9984 Lacrosse \n", "9985 Human Rights \n", "9986 India \n", "9987 Business \n", "9988 NaN \n", "9989 Facebook \n", "9990 Google Docs \n", "9991 Health and Wellness \n", "9992 Startups \n", "9993 Indonesian (language) \n", "9994 Technology Industry in Israel \n", "9995 Social Entrepreneurship \n", "9996 Jobs \n", "9997 Sarcasm \n", "9998 Kashmir \n", "9999 Venture Capital \n", "\n", "[10000 rows x 2 columns]" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "context_topic_df" ] }, { "cell_type": "code", "execution_count": 27, "metadata": { "collapsed": true }, "outputs": [], "source": [ "cleaned_df = pd.concat([df.drop(['context_topic'], axis=1), context_topic_df], axis = 1)" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "10000" ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cleaned_df.shape[0]" ] }, { "cell_type": "code", "execution_count": 29, "metadata": { "collapsed": true }, "outputs": [], "source": [ "train = cleaned_df[:9000]" ] }, { "cell_type": "code", "execution_count": 30, "metadata": { "collapsed": true }, "outputs": [], "source": [ "test = cleaned_df[9000:]" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
__ans__anonymousnum_answerspromoted_toquestion_keyquestion_texttopicscontext_topic_followerscontext_topic_name
9000NaNFalse090AAEAACoD29W+HelUgB32vNEdu0NGxqJi7SH91iH1FLvNDOj2DCI, or should it be RIC(Role/Interaction/Cont...[{'followers': 24761, 'name': 'Software Engine...24761.0Software Engineering
9001NaNFalse00AAEAAIEmRDzBkZ9M9+ff9T/chVUceCbKUjDRUevvvu5qU7ixWhat agreement does hotwire have with partner ...[{'followers': 110108, 'name': 'Hotels'}, {'fo...789.0Hotwire
9002NaNFalse30AAEAADPyyYuxYuSes2G7E9LHLkxu9ZNU6E237WmY1YOe/x0EAre all Autism or Asperger Syndrome people Int...[{'followers': 715, 'name': 'Asperger Syndrome...828.0Autism
9003NaNFalse10AAEAAHZRcTcYkYH933/Cssn032ygfGEqeWYsmkQNDzoVGdA/What businesses hire 15 year olds?[{'followers': 526597, 'name': 'Business'}]526597.0Business
9004NaNFalse10AAEAAD/FZeneJxjntn5ZNSVPrjE8H7zsPVePpjl6GjCgUVK2What are some great table wine magnums for aro...[{'followers': 13119, 'name': 'Wine'}, {'follo...13119.0Wine
9005NaNFalse00AAEAAEaEgf32q+1yViJeHIJAuLQPZuAAv/Btejc3b/gSDgZcWhy is there such a big power gap, between the...[{'followers': 4649, 'name': 'Politics of Indi...4649.0Politics of India
9006NaNFalse6200AAEAALsqS9OhREC42UojcxGk0w0xJKukJ4AFRvNYSGgD34BwWho is your favourite couple in a comics unive...[{'followers': 8760, 'name': 'DC Comics'}, {'f...7310.0Survey Questions
9007NaNFalse10AAEAAHHRJ0BlvQiYaY4jFjupBH/rT+SSVQR7RA9VaqhLHautWhat are some good places to watch sports in M...[{'followers': 3776, 'name': 'Manhattan (NYC b...3776.0Manhattan (NYC borough)
9008NaNTrue00AAEAACWN2WzcacP0QeYb1R6i9/AwT14+CQxOYsGWuWSDyTbYWhat are some websites designers visit frequen...[{'followers': 5782, 'name': 'Dribbble'}]5782.0Dribbble
9009NaNFalse50AAEAAL/9YN4leLj5G1q+OyqQ/vk+bm8gB29rsa4YC1uox4VkShould we have a President of the Internet?[{'followers': 773218, 'name': 'Technology'}, ...88471.0The Internet
9010NaNFalse2200AAEAABqTNMM5ooou6dc6goW1jlnSTKePQFtnj5mvXWen/IpdWhat is the evolutionary advantage of moths an...[{'followers': 556, 'name': 'Evolution (proces...556.0Evolution (process)
9011NaNFalse10AAEAAFkVTXgpL1MeFPsD4PhGaftpGlEPcl5VWImjTM7bU3/WWhy do so many stores in New York have long li...[{'followers': 24781, 'name': 'Retail'}, {'fol...282900.0Marketing
9012NaNTrue00AAEAABiOwguGI1lILAGwbkPVhGuHQpFn4WiPfa1o9U8RjFbbHow does the financial reward of creating and ...[{'followers': 41458, 'name': 'Television Busi...41458.0Television Business
9013NaNTrue1120AAEAAJo0yQjaLPZysmGuk7bgctmnO6v+3NxoBEpNYjPMb0B4Would you be interested in a feed that display...[{'followers': 7310, 'name': 'Survey Questions...4004.0Startup Ideas
9014NaNFalse20AAEAAB2v4935tdkYURjLB/iDeWvl45iTNYhFG1prQeFjzo4iWhat is the business model of gaana.com?[{'followers': 321001, 'name': 'Entrepreneursh...2660.0Gaana.com
9015NaNTrue20AAEAALJaYVbBydD/6e/xXXO7mJvH0/JVd9d4yHKU0Y06MUoQHow can I split an email conversation in Gmail?[{'followers': 38391, 'name': 'Gmail'}]38391.0Gmail
9016NaNFalse30AAEAAHYlmr8+DzSL7h9p8a4RE2pnFaPnb3TETVHvEoZ11TmXHow easy is the German language?[{'followers': 988, 'name': 'German (language)...988.0German (language)
9017NaNTrue230AAEAAPZSaoGHckv00smkoIAAUYCfden8K9ZudYK/eM9exU1TWhat would you if you could stop time?[{'followers': 731, 'name': 'What Would You Do...731.0What Would You Do If X?
9018NaNFalse00AAEAAOrnDPcIl8r4dKNTds9OJELueKL6xZVOj/kCa7ampXyYWhat are less-known names of some atypical sha...[{'followers': 16551, 'name': 'Facts and Trivi...151.0Shapes
9019NaNFalse00AAEAAGHq58yiEm4rfQ6mFtZUE2iN08E4KoTdu1CTagYuZ33pWhat are the most innovative marketing uses of...[{'followers': 29, 'name': 'Location-based Mar...282900.0Marketing
9020NaNFalse2400AAEAAGMs/2HJgXjZ9tK9zqOR7Gh+7DdcKjqjlzniHlHnwflmWhat are some alternative conceptualizations o...[{'followers': 33423, 'name': 'God'}, {'follow...33423.0God
9021NaNFalse10AAEAAJo8cflZCA3hcwCzV5yxXT9qe2viR3mZs7RwHpB40ncwIs there a Happy Bodnick meme?[{'followers': 494, 'name': 'Marc Bodnick'}]494.0Marc Bodnick
9022NaNFalse20AAEAAIZV7jnw7LGFDGc/Ldse3CJl52+GCOkuiR8DM3nVG7jCWhy there is an Age limit in Olympic Soccer, w...[{'followers': 66768, 'name': 'Football (Socce...322541.0Sports
9023NaNFalse10AAEAAFdnuShyaJ85KUXcjsJfiDXKbEqvxo0FxAjrt32tvFFQWhat would happen if China linked the Chinese ...[{'followers': 333543, 'name': 'Economics'}, {...333543.0Economics
9024NaNFalse00AAEAAGrWxL8SnVtVEG7tsu4JortfnuosAswBPKeymfrLYTiYWas Rehoboth Beach, Delaware seriously affecte...[{'followers': 61, 'name': 'Rehoboth Beach, De...61.0Rehoboth Beach, Delaware
9025NaNFalse29580AAEAAMZG9G0/WGABkSj04y6igmOTzdxOHZfwkTdcgUqjLijNIf Shah Rukh Khan wrote a book, \"How to be Sha...[{'followers': 500022, 'name': 'Movies'}, {'fo...35412.0Shah Rukh Khan
9026NaNTrue13150AAEAAHH+Aquci2tRcdZGlJInuYdkHkMUz4RbChBnwGss1fhNWhat can we expect from Christopher Nolan's In...[{'followers': 4, 'name': 'Interstellar (movie...4.0Interstellar (movie in development)
9027NaNTrue3190AAEAAAt9WYSIk+oxhUOG1hfxWq2RqBBi2JPUyRfGo0Am/g88What are some businesses, in which the real so...[{'followers': 274839, 'name': 'Business Strat...526597.0Business
9028NaNFalse7600AAEAAJZa8tqrwo7AdudPrXTKAMF7eFcIzsA4zwVyTEA9qNf8What are the best ways to guarantee a return o...[{'followers': 424, 'name': 'Quora User Tips'}...424.0Quora Credits
9029NaNFalse10AAEAAFOkBI5LhzxTJ+iOcefXdpIgo3WnnqgDJk8gD61ffBnGCould anyone suggest me a name for an event ma...[{'followers': 278, 'name': 'Event Management'}]278.0Event Management
..............................
9970NaNFalse70AAEAAAHZ7eoo1x7ZduZlk826XPxN/yuX5x0SQHtoLpsxK2MAIs it OK to use the disabled restroom in rest ...[{'followers': 46198, 'name': 'Manners and Eti...35.0Public Restrooms
9971NaNFalse40AAEAAKBzcyFahiqWIQ5HnBOr6JGdxyiXSuzDXaIP8LK/AVCWHow does it feel like to actually be 999999th ...[{'followers': 7361, 'name': 'What Does It Fee...7361.0What Does It Feel Like to X?
9972NaNFalse00AAEAAPg3XukDQ+HavVquEyHBWuoif46lRe787qBNZ0cy7c60Who are the biggest trolls of WWII?[{'followers': 47252, 'name': 'World War II'},...NaNNaN
9973NaNFalse50AAEAAIOmikV3Q8HsiQ3byAbxKOXi6BqpPNIcGGdTe/y4PCQsWhat are some good \"vegeterian\" restaurants in...[{'followers': 7735, 'name': 'Kolkata, West Be...7735.0Kolkata, West Bengal, India
9974NaNFalse30AAEAAPL1yN77qhZM8ttw3/3DlTumpM9f7njgpVa8c+mxXPGWWhat is the best way to transport a guitar whe...[{'followers': 2763, 'name': 'Acoustic Guitar'}]2763.0Acoustic Guitar
9975NaNFalse00AAEAAKMJys+KhCvsot3ulnAdamgxZUjM00y5KYW+O1ixN7LNHow can we find why people buy vitrail dome?[{'followers': 240658, 'name': 'Fine Art'}]240658.0Fine Art
9976NaNFalse30AAEAABirDGEz/r8CmOIGrPpe6UcwPtA7CS72NZoNGYcJv7VSWhat do you think that happens no where in the...[{'followers': 224, 'name': 'Indians On Quora'...130510.0India
9977NaNFalse5200AAEAAJ6R9EimCjDPYlIpjOBYRQ7CPxobn9C/xCwurd+Zp67wI see a lot of bad science being reported on m...[{'followers': 28, 'name': 'Science Journalism...614223.0Science
9978NaNTrue00AAEAAJo09/QYxyDglnKJuYngbSfA0py6jXkx5MiLJDEg61LKWho designed the Martini mobile app that conne...[{'followers': 1115, 'name': 'Meeting New Peop...1115.0Meeting New People
9979NaNFalse00AAEAANkBVF9hcaNrU0AGLY4ynp8xGV+2ymgibGsTST8wFDIBHosted or Privated Chef/Puppet?[{'followers': 307, 'name': 'Configuration Man...307.0Configuration Management
9980NaNFalse40AAEAAGKwWCFpoJsi/ZnroU3MhPB11LLDfYAcG+u3sHyNfDfvHow would you justify the wastage of water dur...[{'followers': 252, 'name': 'Holi'}, {'followe...252.0Holi
9981NaNFalse10AAEAAFrCnoffwcwVpDIsreCyT+XRzPuPt0wA5zpGaeKwh3AHWhich processor is better for a graphic design...[{'followers': 773218, 'name': 'Technology'}, ...2360.0Laptops
9982NaNFalse10AAEAAHz2iHfkZ17beSDLdG36mqh76iJxbvy7ltVq/hI3dxKNIs Warren Buffett investing in companies becau...[{'followers': 167230, 'name': 'Investing'}]167230.0Investing
9983NaNTrue30AAEAAGizmW9Cn964/fe563GXfoIj8jhk98sNBvvobTYxWcj0I've failed my driving test twice: how can I p...[{'followers': 2080, 'name': 'Driving'}]2080.0Driving
9984NaNFalse10AAEAABuDHz22TdRoHnLiVYfQAyvh22kOL/zDvhoAJQoFUhRwWhy are men's lacrosse and women's lacrosse so...[{'followers': 322541, 'name': 'Sports'}, {'fo...1892.0Lacrosse
9985NaNFalse00AAEAAJKYJgaXheTZGWPCunOIbCsKbGcjD2w1ENUikQPDeNpABecause men are Human beings too do they deser...[{'followers': 3551, 'name': 'Human Rights'}]3551.0Human Rights
9986NaNTrue100AAEAAFZUD0HT9fdkyj3oTR6Ew5cXqntfzyUQrAmPr3LiFRWuWhy do many Tamils refer to themselves as Tam ...[{'followers': 50, 'name': 'Tamil Culture'}, {...130510.0India
9987NaNFalse00AAEAAMXz0j0UAWLFLPK8SmQN5flyCv8HfYnXj3Gc6IOuDM5BHow to start a website developing business in ...[{'followers': 526597, 'name': 'Business'}]526597.0Business
9988NaNFalse29200AAEAAN2HZuSZhaIt/UgzCSRzjztTUJQ2rDMOZmSC6enp4XDtWhat is the best rebuttal to \"If it ain't brok...[{'followers': 364, 'name': 'Disruption'}, {'f...NaNNaN
9989NaNFalse10AAEAAClprKo7msONt3rt+zrm/fP2ZkDg4AK6nBx6zMQkS0kyFacebook app center (versus) existing app stores?[{'followers': 6404, 'name': 'Google Play'}, {...238905.0Facebook
9990NaNFalse050AAEAAJCL484wkZIHiRw1MLBu33qqxkTmuJGDIrEgW4vMnyquWhy do Bold fonts and Italics disappear when c...[{'followers': 1915, 'name': 'Google Drive'}, ...3327.0Google Docs
9991NaNFalse00AAEAAC72X8TZvRNVSYZ6hTMnTfpBaHPuFpodk23H3xfrK6NHWhy does being cold make you catch a cold?[{'followers': 382503, 'name': 'Health and Wel...382503.0Health and Wellness
9992NaNTrue10AAEAAM10T++NbYU9JFMEb6QxUnhc5LJxtkOvG1HhfuxSpTg3What are the hottest under-10 person startups ...[{'followers': 164924, 'name': 'Lean Startups'...241809.0Startups
9993NaNTrue00AAEAAMPrlsjCEejyiB4x6Nmvi4yEMD5fUpJZo/WV/oc1L/YkHow do people from other countries think about...[{'followers': 331, 'name': 'Indonesian (langu...331.0Indonesian (language)
9994NaNFalse1200AAEAAFF/WfbxS4V2roHkQ+WEgqXcVXxTCljXMuGkslg7XtOqWhat's the average deal size of an Israeli M&A?[{'followers': 199, 'name': 'Technology Indust...199.0Technology Industry in Israel
9995NaNFalse20AAEAADHmhdj7ddMsxwLxIORZC+IfLoydhg+FXTwjBssCfemUWhat is the best career path to take to become...[{'followers': 256, 'name': 'Social Impact'}, ...5652.0Social Entrepreneurship
9996NaNTrue30AAEAAF9ASgzjooq/SgiJg58it0eZ6PPYv8B/r4k6gH8VhdCGIs having a facial piercing considered unprofe...[{'followers': 4801, 'name': 'Engineering Recr...10143.0Jobs
9997NaNTrue30AAEAAHaDxug0N4SrFLa65nyX0onGDf3C7DpBBF+u/4MTu9yeHow does it feel to get sarcastically insulted...[{'followers': 8017, 'name': 'Sarcasm'}]8017.0Sarcasm
9998NaNTrue360AAEAABtiDQZgE2LOLxtgl33uaw4xfhMDFqlWV4wVsE9H/DcqWhy did Kashmiri Hindus have to leave their ho...[{'followers': 9393, 'name': 'Islam'}, {'follo...2421.0Kashmir
9999NaNFalse30AAEAAL8xXMY8ocS5aVwA+01/21LZ29oejC1zVXl2eS+a+9J6Is it possible to become a successful venture ...[{'followers': 64684, 'name': 'Venture Capital'}]64684.0Venture Capital
\n", "

1000 rows × 9 columns

\n", "
" ], "text/plain": [ " __ans__ anonymous num_answers promoted_to \\\n", "9000 NaN False 0 90 \n", "9001 NaN False 0 0 \n", "9002 NaN False 3 0 \n", "9003 NaN False 1 0 \n", "9004 NaN False 1 0 \n", "9005 NaN False 0 0 \n", "9006 NaN False 6 200 \n", "9007 NaN False 1 0 \n", "9008 NaN True 0 0 \n", "9009 NaN False 5 0 \n", "9010 NaN False 2 200 \n", "9011 NaN False 1 0 \n", "9012 NaN True 0 0 \n", "9013 NaN True 1 120 \n", "9014 NaN False 2 0 \n", "9015 NaN True 2 0 \n", "9016 NaN False 3 0 \n", "9017 NaN True 2 30 \n", "9018 NaN False 0 0 \n", "9019 NaN False 0 0 \n", "9020 NaN False 2 400 \n", "9021 NaN False 1 0 \n", "9022 NaN False 2 0 \n", "9023 NaN False 1 0 \n", "9024 NaN False 0 0 \n", "9025 NaN False 2 9580 \n", "9026 NaN True 13 150 \n", "9027 NaN True 3 190 \n", "9028 NaN False 7 600 \n", "9029 NaN False 1 0 \n", "... ... ... ... ... \n", "9970 NaN False 7 0 \n", "9971 NaN False 4 0 \n", "9972 NaN False 0 0 \n", "9973 NaN False 5 0 \n", "9974 NaN False 3 0 \n", "9975 NaN False 0 0 \n", "9976 NaN False 3 0 \n", "9977 NaN False 5 200 \n", "9978 NaN True 0 0 \n", "9979 NaN False 0 0 \n", "9980 NaN False 4 0 \n", "9981 NaN False 1 0 \n", "9982 NaN False 1 0 \n", "9983 NaN True 3 0 \n", "9984 NaN False 1 0 \n", "9985 NaN False 0 0 \n", "9986 NaN True 10 0 \n", "9987 NaN False 0 0 \n", "9988 NaN False 29 200 \n", "9989 NaN False 1 0 \n", "9990 NaN False 0 50 \n", "9991 NaN False 0 0 \n", "9992 NaN True 1 0 \n", "9993 NaN True 0 0 \n", "9994 NaN False 1 200 \n", "9995 NaN False 2 0 \n", "9996 NaN True 3 0 \n", "9997 NaN True 3 0 \n", "9998 NaN True 3 60 \n", "9999 NaN False 3 0 \n", "\n", " question_key \\\n", "9000 AAEAACoD29W+HelUgB32vNEdu0NGxqJi7SH91iH1FLvNDOj2 \n", "9001 AAEAAIEmRDzBkZ9M9+ff9T/chVUceCbKUjDRUevvvu5qU7ix \n", "9002 AAEAADPyyYuxYuSes2G7E9LHLkxu9ZNU6E237WmY1YOe/x0E \n", "9003 AAEAAHZRcTcYkYH933/Cssn032ygfGEqeWYsmkQNDzoVGdA/ \n", "9004 AAEAAD/FZeneJxjntn5ZNSVPrjE8H7zsPVePpjl6GjCgUVK2 \n", "9005 AAEAAEaEgf32q+1yViJeHIJAuLQPZuAAv/Btejc3b/gSDgZc \n", "9006 AAEAALsqS9OhREC42UojcxGk0w0xJKukJ4AFRvNYSGgD34Bw \n", "9007 AAEAAHHRJ0BlvQiYaY4jFjupBH/rT+SSVQR7RA9VaqhLHaut \n", "9008 AAEAACWN2WzcacP0QeYb1R6i9/AwT14+CQxOYsGWuWSDyTbY \n", "9009 AAEAAL/9YN4leLj5G1q+OyqQ/vk+bm8gB29rsa4YC1uox4Vk \n", "9010 AAEAABqTNMM5ooou6dc6goW1jlnSTKePQFtnj5mvXWen/Ipd \n", "9011 AAEAAFkVTXgpL1MeFPsD4PhGaftpGlEPcl5VWImjTM7bU3/W \n", "9012 AAEAABiOwguGI1lILAGwbkPVhGuHQpFn4WiPfa1o9U8RjFbb \n", "9013 AAEAAJo0yQjaLPZysmGuk7bgctmnO6v+3NxoBEpNYjPMb0B4 \n", "9014 AAEAAB2v4935tdkYURjLB/iDeWvl45iTNYhFG1prQeFjzo4i \n", "9015 AAEAALJaYVbBydD/6e/xXXO7mJvH0/JVd9d4yHKU0Y06MUoQ \n", "9016 AAEAAHYlmr8+DzSL7h9p8a4RE2pnFaPnb3TETVHvEoZ11TmX \n", "9017 AAEAAPZSaoGHckv00smkoIAAUYCfden8K9ZudYK/eM9exU1T \n", "9018 AAEAAOrnDPcIl8r4dKNTds9OJELueKL6xZVOj/kCa7ampXyY \n", "9019 AAEAAGHq58yiEm4rfQ6mFtZUE2iN08E4KoTdu1CTagYuZ33p \n", "9020 AAEAAGMs/2HJgXjZ9tK9zqOR7Gh+7DdcKjqjlzniHlHnwflm \n", "9021 AAEAAJo8cflZCA3hcwCzV5yxXT9qe2viR3mZs7RwHpB40ncw \n", "9022 AAEAAIZV7jnw7LGFDGc/Ldse3CJl52+GCOkuiR8DM3nVG7jC \n", "9023 AAEAAFdnuShyaJ85KUXcjsJfiDXKbEqvxo0FxAjrt32tvFFQ \n", "9024 AAEAAGrWxL8SnVtVEG7tsu4JortfnuosAswBPKeymfrLYTiY \n", "9025 AAEAAMZG9G0/WGABkSj04y6igmOTzdxOHZfwkTdcgUqjLijN \n", "9026 AAEAAHH+Aquci2tRcdZGlJInuYdkHkMUz4RbChBnwGss1fhN \n", "9027 AAEAAAt9WYSIk+oxhUOG1hfxWq2RqBBi2JPUyRfGo0Am/g88 \n", "9028 AAEAAJZa8tqrwo7AdudPrXTKAMF7eFcIzsA4zwVyTEA9qNf8 \n", "9029 AAEAAFOkBI5LhzxTJ+iOcefXdpIgo3WnnqgDJk8gD61ffBnG \n", "... ... \n", "9970 AAEAAAHZ7eoo1x7ZduZlk826XPxN/yuX5x0SQHtoLpsxK2MA \n", "9971 AAEAAKBzcyFahiqWIQ5HnBOr6JGdxyiXSuzDXaIP8LK/AVCW \n", "9972 AAEAAPg3XukDQ+HavVquEyHBWuoif46lRe787qBNZ0cy7c60 \n", "9973 AAEAAIOmikV3Q8HsiQ3byAbxKOXi6BqpPNIcGGdTe/y4PCQs \n", "9974 AAEAAPL1yN77qhZM8ttw3/3DlTumpM9f7njgpVa8c+mxXPGW \n", "9975 AAEAAKMJys+KhCvsot3ulnAdamgxZUjM00y5KYW+O1ixN7LN \n", "9976 AAEAABirDGEz/r8CmOIGrPpe6UcwPtA7CS72NZoNGYcJv7VS \n", "9977 AAEAAJ6R9EimCjDPYlIpjOBYRQ7CPxobn9C/xCwurd+Zp67w \n", "9978 AAEAAJo09/QYxyDglnKJuYngbSfA0py6jXkx5MiLJDEg61LK \n", "9979 AAEAANkBVF9hcaNrU0AGLY4ynp8xGV+2ymgibGsTST8wFDIB \n", "9980 AAEAAGKwWCFpoJsi/ZnroU3MhPB11LLDfYAcG+u3sHyNfDfv \n", "9981 AAEAAFrCnoffwcwVpDIsreCyT+XRzPuPt0wA5zpGaeKwh3AH \n", "9982 AAEAAHz2iHfkZ17beSDLdG36mqh76iJxbvy7ltVq/hI3dxKN \n", "9983 AAEAAGizmW9Cn964/fe563GXfoIj8jhk98sNBvvobTYxWcj0 \n", "9984 AAEAABuDHz22TdRoHnLiVYfQAyvh22kOL/zDvhoAJQoFUhRw \n", "9985 AAEAAJKYJgaXheTZGWPCunOIbCsKbGcjD2w1ENUikQPDeNpA \n", "9986 AAEAAFZUD0HT9fdkyj3oTR6Ew5cXqntfzyUQrAmPr3LiFRWu \n", "9987 AAEAAMXz0j0UAWLFLPK8SmQN5flyCv8HfYnXj3Gc6IOuDM5B \n", "9988 AAEAAN2HZuSZhaIt/UgzCSRzjztTUJQ2rDMOZmSC6enp4XDt \n", "9989 AAEAAClprKo7msONt3rt+zrm/fP2ZkDg4AK6nBx6zMQkS0ky \n", "9990 AAEAAJCL484wkZIHiRw1MLBu33qqxkTmuJGDIrEgW4vMnyqu \n", "9991 AAEAAC72X8TZvRNVSYZ6hTMnTfpBaHPuFpodk23H3xfrK6NH \n", "9992 AAEAAM10T++NbYU9JFMEb6QxUnhc5LJxtkOvG1HhfuxSpTg3 \n", "9993 AAEAAMPrlsjCEejyiB4x6Nmvi4yEMD5fUpJZo/WV/oc1L/Yk \n", "9994 AAEAAFF/WfbxS4V2roHkQ+WEgqXcVXxTCljXMuGkslg7XtOq \n", "9995 AAEAADHmhdj7ddMsxwLxIORZC+IfLoydhg+FXTwjBssCfemU \n", "9996 AAEAAF9ASgzjooq/SgiJg58it0eZ6PPYv8B/r4k6gH8VhdCG \n", "9997 AAEAAHaDxug0N4SrFLa65nyX0onGDf3C7DpBBF+u/4MTu9ye \n", "9998 AAEAABtiDQZgE2LOLxtgl33uaw4xfhMDFqlWV4wVsE9H/Dcq \n", "9999 AAEAAL8xXMY8ocS5aVwA+01/21LZ29oejC1zVXl2eS+a+9J6 \n", "\n", " question_text \\\n", "9000 DCI, or should it be RIC(Role/Interaction/Cont... \n", "9001 What agreement does hotwire have with partner ... \n", "9002 Are all Autism or Asperger Syndrome people Int... \n", "9003 What businesses hire 15 year olds? \n", "9004 What are some great table wine magnums for aro... \n", "9005 Why is there such a big power gap, between the... \n", "9006 Who is your favourite couple in a comics unive... \n", "9007 What are some good places to watch sports in M... \n", "9008 What are some websites designers visit frequen... \n", "9009 Should we have a President of the Internet? \n", "9010 What is the evolutionary advantage of moths an... \n", "9011 Why do so many stores in New York have long li... \n", "9012 How does the financial reward of creating and ... \n", "9013 Would you be interested in a feed that display... \n", "9014 What is the business model of gaana.com? \n", "9015 How can I split an email conversation in Gmail? \n", "9016 How easy is the German language? \n", "9017 What would you if you could stop time? \n", "9018 What are less-known names of some atypical sha... \n", "9019 What are the most innovative marketing uses of... \n", "9020 What are some alternative conceptualizations o... \n", "9021 Is there a Happy Bodnick meme? \n", "9022 Why there is an Age limit in Olympic Soccer, w... \n", "9023 What would happen if China linked the Chinese ... \n", "9024 Was Rehoboth Beach, Delaware seriously affecte... \n", "9025 If Shah Rukh Khan wrote a book, \"How to be Sha... \n", "9026 What can we expect from Christopher Nolan's In... \n", "9027 What are some businesses, in which the real so... \n", "9028 What are the best ways to guarantee a return o... \n", "9029 Could anyone suggest me a name for an event ma... \n", "... ... \n", "9970 Is it OK to use the disabled restroom in rest ... \n", "9971 How does it feel like to actually be 999999th ... \n", "9972 Who are the biggest trolls of WWII? \n", "9973 What are some good \"vegeterian\" restaurants in... \n", "9974 What is the best way to transport a guitar whe... \n", "9975 How can we find why people buy vitrail dome? \n", "9976 What do you think that happens no where in the... \n", "9977 I see a lot of bad science being reported on m... \n", "9978 Who designed the Martini mobile app that conne... \n", "9979 Hosted or Privated Chef/Puppet? \n", "9980 How would you justify the wastage of water dur... \n", "9981 Which processor is better for a graphic design... \n", "9982 Is Warren Buffett investing in companies becau... \n", "9983 I've failed my driving test twice: how can I p... \n", "9984 Why are men's lacrosse and women's lacrosse so... \n", "9985 Because men are Human beings too do they deser... \n", "9986 Why do many Tamils refer to themselves as Tam ... \n", "9987 How to start a website developing business in ... \n", "9988 What is the best rebuttal to \"If it ain't brok... \n", "9989 Facebook app center (versus) existing app stores? \n", "9990 Why do Bold fonts and Italics disappear when c... \n", "9991 Why does being cold make you catch a cold? \n", "9992 What are the hottest under-10 person startups ... \n", "9993 How do people from other countries think about... \n", "9994 What's the average deal size of an Israeli M&A? \n", "9995 What is the best career path to take to become... \n", "9996 Is having a facial piercing considered unprofe... \n", "9997 How does it feel to get sarcastically insulted... \n", "9998 Why did Kashmiri Hindus have to leave their ho... \n", "9999 Is it possible to become a successful venture ... \n", "\n", " topics \\\n", "9000 [{'followers': 24761, 'name': 'Software Engine... \n", "9001 [{'followers': 110108, 'name': 'Hotels'}, {'fo... \n", "9002 [{'followers': 715, 'name': 'Asperger Syndrome... \n", "9003 [{'followers': 526597, 'name': 'Business'}] \n", "9004 [{'followers': 13119, 'name': 'Wine'}, {'follo... \n", "9005 [{'followers': 4649, 'name': 'Politics of Indi... \n", "9006 [{'followers': 8760, 'name': 'DC Comics'}, {'f... \n", "9007 [{'followers': 3776, 'name': 'Manhattan (NYC b... \n", "9008 [{'followers': 5782, 'name': 'Dribbble'}] \n", "9009 [{'followers': 773218, 'name': 'Technology'}, ... \n", "9010 [{'followers': 556, 'name': 'Evolution (proces... \n", "9011 [{'followers': 24781, 'name': 'Retail'}, {'fol... \n", "9012 [{'followers': 41458, 'name': 'Television Busi... \n", "9013 [{'followers': 7310, 'name': 'Survey Questions... \n", "9014 [{'followers': 321001, 'name': 'Entrepreneursh... \n", "9015 [{'followers': 38391, 'name': 'Gmail'}] \n", "9016 [{'followers': 988, 'name': 'German (language)... \n", "9017 [{'followers': 731, 'name': 'What Would You Do... \n", "9018 [{'followers': 16551, 'name': 'Facts and Trivi... \n", "9019 [{'followers': 29, 'name': 'Location-based Mar... \n", "9020 [{'followers': 33423, 'name': 'God'}, {'follow... \n", "9021 [{'followers': 494, 'name': 'Marc Bodnick'}] \n", "9022 [{'followers': 66768, 'name': 'Football (Socce... \n", "9023 [{'followers': 333543, 'name': 'Economics'}, {... \n", "9024 [{'followers': 61, 'name': 'Rehoboth Beach, De... \n", "9025 [{'followers': 500022, 'name': 'Movies'}, {'fo... \n", "9026 [{'followers': 4, 'name': 'Interstellar (movie... \n", "9027 [{'followers': 274839, 'name': 'Business Strat... \n", "9028 [{'followers': 424, 'name': 'Quora User Tips'}... \n", "9029 [{'followers': 278, 'name': 'Event Management'}] \n", "... ... \n", "9970 [{'followers': 46198, 'name': 'Manners and Eti... \n", "9971 [{'followers': 7361, 'name': 'What Does It Fee... \n", "9972 [{'followers': 47252, 'name': 'World War II'},... \n", "9973 [{'followers': 7735, 'name': 'Kolkata, West Be... \n", "9974 [{'followers': 2763, 'name': 'Acoustic Guitar'}] \n", "9975 [{'followers': 240658, 'name': 'Fine Art'}] \n", "9976 [{'followers': 224, 'name': 'Indians On Quora'... \n", "9977 [{'followers': 28, 'name': 'Science Journalism... \n", "9978 [{'followers': 1115, 'name': 'Meeting New Peop... \n", "9979 [{'followers': 307, 'name': 'Configuration Man... \n", "9980 [{'followers': 252, 'name': 'Holi'}, {'followe... \n", "9981 [{'followers': 773218, 'name': 'Technology'}, ... \n", "9982 [{'followers': 167230, 'name': 'Investing'}] \n", "9983 [{'followers': 2080, 'name': 'Driving'}] \n", "9984 [{'followers': 322541, 'name': 'Sports'}, {'fo... \n", "9985 [{'followers': 3551, 'name': 'Human Rights'}] \n", "9986 [{'followers': 50, 'name': 'Tamil Culture'}, {... \n", "9987 [{'followers': 526597, 'name': 'Business'}] \n", "9988 [{'followers': 364, 'name': 'Disruption'}, {'f... \n", "9989 [{'followers': 6404, 'name': 'Google Play'}, {... \n", "9990 [{'followers': 1915, 'name': 'Google Drive'}, ... \n", "9991 [{'followers': 382503, 'name': 'Health and Wel... \n", "9992 [{'followers': 164924, 'name': 'Lean Startups'... \n", "9993 [{'followers': 331, 'name': 'Indonesian (langu... \n", "9994 [{'followers': 199, 'name': 'Technology Indust... \n", "9995 [{'followers': 256, 'name': 'Social Impact'}, ... \n", "9996 [{'followers': 4801, 'name': 'Engineering Recr... \n", "9997 [{'followers': 8017, 'name': 'Sarcasm'}] \n", "9998 [{'followers': 9393, 'name': 'Islam'}, {'follo... \n", "9999 [{'followers': 64684, 'name': 'Venture Capital'}] \n", "\n", " context_topic_followers context_topic_name \n", "9000 24761.0 Software Engineering \n", "9001 789.0 Hotwire \n", "9002 828.0 Autism \n", "9003 526597.0 Business \n", "9004 13119.0 Wine \n", "9005 4649.0 Politics of India \n", "9006 7310.0 Survey Questions \n", "9007 3776.0 Manhattan (NYC borough) \n", "9008 5782.0 Dribbble \n", "9009 88471.0 The Internet \n", "9010 556.0 Evolution (process) \n", "9011 282900.0 Marketing \n", "9012 41458.0 Television Business \n", "9013 4004.0 Startup Ideas \n", "9014 2660.0 Gaana.com \n", "9015 38391.0 Gmail \n", "9016 988.0 German (language) \n", "9017 731.0 What Would You Do If X? \n", "9018 151.0 Shapes \n", "9019 282900.0 Marketing \n", "9020 33423.0 God \n", "9021 494.0 Marc Bodnick \n", "9022 322541.0 Sports \n", "9023 333543.0 Economics \n", "9024 61.0 Rehoboth Beach, Delaware \n", "9025 35412.0 Shah Rukh Khan \n", "9026 4.0 Interstellar (movie in development) \n", "9027 526597.0 Business \n", "9028 424.0 Quora Credits \n", "9029 278.0 Event Management \n", "... ... ... \n", "9970 35.0 Public Restrooms \n", "9971 7361.0 What Does It Feel Like to X? \n", "9972 NaN NaN \n", "9973 7735.0 Kolkata, West Bengal, India \n", "9974 2763.0 Acoustic Guitar \n", "9975 240658.0 Fine Art \n", "9976 130510.0 India \n", "9977 614223.0 Science \n", "9978 1115.0 Meeting New People \n", "9979 307.0 Configuration Management \n", "9980 252.0 Holi \n", "9981 2360.0 Laptops \n", "9982 167230.0 Investing \n", "9983 2080.0 Driving \n", "9984 1892.0 Lacrosse \n", "9985 3551.0 Human Rights \n", "9986 130510.0 India \n", "9987 526597.0 Business \n", "9988 NaN NaN \n", "9989 238905.0 Facebook \n", "9990 3327.0 Google Docs \n", "9991 382503.0 Health and Wellness \n", "9992 241809.0 Startups \n", "9993 331.0 Indonesian (language) \n", "9994 199.0 Technology Industry in Israel \n", "9995 5652.0 Social Entrepreneurship \n", "9996 10143.0 Jobs \n", "9997 8017.0 Sarcasm \n", "9998 2421.0 Kashmir \n", "9999 64684.0 Venture Capital \n", "\n", "[1000 rows x 9 columns]" ] }, "execution_count": 31, "metadata": {}, "output_type": "execute_result" } ], "source": [ "test" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
__ans__anonymousnum_answerspromoted_toquestion_keyquestion_texttopicscontext_topic_followerscontext_topic_name
02.089474False40AAEAAM9EY6LIJsEFvYiwKLfCe7d+hkbsXJ5qM7aSwTqemERpWhat are some movies with mind boggling twists...[{'followers': 500022, 'name': 'Movies'}]500022.0Movies
12.692308False10AAEAAHM6f92B9jt43/y913/J7ce8vtE6Jn9LLcy3yK2RHFGDHow do you prepare a 10 year old for Internati...[{'followers': 179, 'name': 'International Mat...179.0International Mathematical Olympiad (IMO)
24.612903False10AAEAAGzietPvCHLFvaKCjng43iiIeo9gAWnJlSrs+12uYtZ0Why do bats sleep upside down?[{'followers': 614223, 'name': 'Science'}]614223.0Science
38.051948False10AAEAAM2Sk4U3y4We5TELJXRQgIf6yit5DbbdBw6BCRvuFrcYTell me everything about the Leidenfrost effec...[{'followers': 614223, 'name': 'Science'}, {'f...614223.0Science
40.150943False00AAEAALb43r/fn9KRKqJ0itd3NGbqZZSZalzi7vaulLxNGzeLIs the Nexus 10 any good despite the dual core...[{'followers': 1536, 'name': 'Android Tablets'}]1536.0Android Tablets
50.084507False00AAEAABSJk8mrfAjuQuxEI6PV2rfGGcnuq/I5JyE0VJvYSoRpIs smartphone app download duplication account...[{'followers': 91, 'name': 'Smartphone Applica...91.0Smartphone Applications
61.073944True1200AAEAANLGb0hKlFULx6BPXvVvHQ1SJ2jJTqDCVighUGs/ZDyaAre there any CEO's that go by a different nam...[{'followers': 526597, 'name': 'Business'}, {'...241809.0Startups
70.007299False00AAEAAJinkGKp/YRlvWhFbapFNzPkD7coBuf4QRwsmN/c3q7ZGuys who love being sissies?[{'followers': 289, 'name': 'Needs to Be Clear...NaNNaN
80.298893True10AAEAAB0zSrCTxmdSYxoC1KD0HYeDwTzOyK2lBiXzuZwhhmgnHow does one successfully become a conscientio...[{'followers': 59, 'name': 'Pacifism'}, {'foll...3006.0Warfare
930.614035False30AAEAAA7uRr9KzVD3rd+L3OptfwxaWFYfE6D8Wqskxx+ZkfGbHow do people in countries with regular and la...[{'followers': 224, 'name': 'Boston Marathon T...224.0Boston Marathon Terrorist Attacks (April 2013)
1024.250000False00AAEAAFHJ+5Ozj1TQKLUwzB/pIwiXMwtTJip8NQO1jCCyRS5aHow do top entrepreneurs/CEOs stay organized a...[{'followers': 321001, 'name': 'Entrepreneursh...4155.0Organization
111.666667False00AAEAAM3WIWO/Ct/u5SvzPHfwwrHNWrPgHd8Ch7/QdM6CjfZLWhat companies/independent developers located ...[{'followers': 199, 'name': 'Technology Indust...304.0Web Development on Mac OS X
120.006231False00AAEAAI0XKapeO3+B75zZYu1Kjv5SGn+Mm/4qT3rBNJrDNKceHow can I call and talk with President Obama o...[{'followers': 1240, 'name': 'U.S. Presidents'}]3292.0United States Governments (Federal, State, Local)
130.575972True1100AAEAAMRnMKIzVIfH55p+aKXak1M0vBd2m7xNKm5KttYyVspoWhat do parents wish they had known before hav...[{'followers': 26, 'name': 'Deciding Whether t...13867.0Parenting
145.220859False20AAEAAFsd5v511xAQgtEaPDHb+fYF8YSJnsRuMd7715LVQQPfHow much time does it take to go from DNA to p...[{'followers': 3693, 'name': 'Medical Research...72820.0Biology
150.079755False00AAEAAOnLQc1KPDw0pqCMpROkdovdRCzJlTsI5nDo9vxjcOm+What % of tablet users use a stylus?[{'followers': 2049, 'name': 'Tablet Devices a...2049.0Tablet Devices and Tablet Market
161.075758False00AAEAAI0A/7ASkze8LKdTLRwCFtUcFZ2xIpNnS55Zk1xtCwXNWhich company make awesome luxury coach?[{'followers': 999, 'name': 'Luxury'}, {'follo...999.0Luxury
170.717557False10AAEAAKKuKEgb+lBKi1iEEST89zLKFr/88CUAwC9xeCdGYss1I Require professional and creative web desig...[{'followers': 39744, 'name': 'Web Development'}]39744.0Web Development
181.622010False20AAEAAJloaH19a32hbe1Cs0wdW8WWptHbbaa5JG7dKbMwvtaJWhat are the short/medium prospects of service...[{'followers': 11842, 'name': 'Internet Advert...3566.0Online Video
193.388889False00AAEAAFHbVuHDWmLslFWH8UZMnN7M5VHntFVDpY19+3ndhmy5Why can't we create something like game of thr...[{'followers': 268430, 'name': 'Television Ser...268430.0Television Series
2011.457143False00AAEAAKkkEpxZp4qBn45yEhzGTnJNhB5e/Mppn75kx1on5ajrWould Noodle make other education lead generat...[{'followers': 167176, 'name': 'Business Model...74.0Noodle Education
211.013889False10AAEAABu6kZw48xJyS1xXW3RjQ0xANWgzwjp6LLVTryDWUM8IORM is all too often seen simply as minimising...[{'followers': 490, 'name': 'Online Reputation...490.0Online Reputation
220.389474True10AAEAANJFMVE7CEr6gX3LEC9NWGz0a65TjFd1AjHMY9CWujBJWhat are some of the funniest noises you have ...[{'followers': 67265, 'name': 'Sex'}, {'follow...264984.0Dating and Relationships
230.319231False10AAEAAKTTk5EUSD+0CPGP0gLS0aBQR97xe0p2+DPRX+ddtoV2Was Moses talking about humans becoming fully ...[{'followers': 2525, 'name': 'Theology'}, {'fo...6608.0Science and Religion
244.000000False4200AAEAAFJxWj/4n1NhOgwpS0d5X7tcBia4jBtjrfw6YxNcYXDr'Scarcely a human freedom has been obtained wi...[{'followers': 4332, 'name': 'Occupy Movement'...1707.0Democracy
250.174194False00AAEAAH+k9PIQg6lOxHRIqXYE5u18aWO4QqJZTtdahJw9+grvDo actors get paid after they do the movie or ...[{'followers': 2450, 'name': 'Wanting and Maki...2450.0Wanting and Making Money
260.678322True00AAEAAG1dK7AL02j78ugkPaKf5TiFb6iBCaIICXxUd5OYpQYzPrivate Equity in relation to Movie Industry,c...[{'followers': 3567, 'name': 'Private Equity'}...3567.0Private Equity
271.007246False2120AAEAAA15xfSTbyLayedu+P4P6upyw1gZisruGcd5sBeOiO2wWhat language was used by Mark Zuckerberg to w...[{'followers': 238905, 'name': 'Facebook'}]238905.0Facebook
2846.333333False00AAEAALJZ+JSLst8wPq+EApQqSTqcCW9iaHg7OWcdwg+xJEVoHow employees at Facebook avoid procrastinatio...[{'followers': 238905, 'name': 'Facebook'}]238905.0Facebook
290.615385True00AAEAAETPeE1zK+aIF5IeOLu2EzMwzSM22EM4i14ZnwDTU17tWas Glenn Gould a fast typist?[{'followers': 986, 'name': 'Glenn Gould'}]986.0Glenn Gould
..............................
89700.044610False00AAEAAKy7JJbuCln18hVXHhNCqaW/2t4BOJekq4EoJZeZlQAfWhen was the Quora application launched for An...[{'followers': 3899, 'name': 'Quora (company)'}]3899.0Quora (company)
89710.028571False00AAEAAIPL+PIfMKP6q/d3vCLPeN6qaE5wVTv9jyLyP46riITO1A group element to show flame test why?[{'followers': 13, 'name': 'Flame Effects'}, {...53.0The Flame
89720.356364False00AAEAAFbZen2AwK+cWhTuxYq89OYYGUdvPKxObTA49ZZY5EoFHire best webdevelopers to design and maintain...[{'followers': 39744, 'name': 'Web Development'}]39744.0Web Development
8973101.000000True10AAEAAEKenPCvJnNPSn3GoyxJGHOgO9Ft1sXtcQIRtzX36ls7Is it absolutely necessary to have a lot in co...[{'followers': 264984, 'name': 'Dating and Rel...264984.0Dating and Relationships
89740.424658False00AAEAAJ6h5w42SdKWHM1ba0mDrLXfRNF35x5J1ImAXc5k7r9gWhat civilization had the earliest written num...[{'followers': 1460, 'name': 'Numbers'}, {'fol...0.0Numeration
89751.787879True20AAEAAI0sA6MSlU+uVCoRL9a3wpk5dt0Mnwy/8h0l2jkqoE9KI am never contacted by recruiters (I don't ha...[{'followers': 7928, 'name': 'Recruiting'}]7928.0Recruiting
89760.183673False00AAEAAHQncZgikc5wl/qwturXJ89iVLVLNrUJNGpMfiSGkZLKWhat is finance software?[{'followers': 4729, 'name': 'Software'}]4729.0Software
89770.118902True10AAEAAIo1t0EvlXTB3vDMjt4DCsJeG6U43ZF/aD8SiMmlmof0What impact do foreign currency fluctuations h...[{'followers': 93447, 'name': 'Amazon'}]93447.0Amazon
89780.494382True10AAEAACkrgngYk0Gq2+2Jm/c+yfNG3tFyUrZAUpEsbvfAnuAoWhat are some tips to write a great sales copy?[{'followers': 4859, 'name': 'Sales'}, {'follo...4859.0Sales
89792.323699True10AAEAAKF/1Zvtgov2mB0Ji4jg1/0aE+lQkKxIEhQuLX8yuwzYIs it a good idea to use technical jargon when...[{'followers': 13108, 'name': 'Career Advice'}]13108.0Career Advice
89800.044944True10AAEAAN2Q0FsMgTWonNul3FPog92E1XkMDr+1QcPsIivJyv/zWhat's it like to work at Done Genetics?[{'followers': 3, 'name': 'Done Genetics'}]3.0Done Genetics
89812.752941True30AAEAAPJKiEWYD6YX59MhOtX8+DnzOqzul+SpdL2Xnl0KJoxxWhere can I connect with people in general in ...[{'followers': 6467, 'name': 'Colleges and Uni...20107.0Mumbai, Maharashtra, India
89820.011662True00AAEAAOZFkLJxzpcxaMgr6sM3pBQcOKWQq+ykds/w3GXXgZqoHave anyone any concern or recommendation for ...[{'followers': 289, 'name': 'Needs to Be Clear...3168.0Dublin, Ireland
89830.133929False00AAEAAFxvsqu2YCjgWfq2u+anT+J0OXvtANXSu+elB7CuM1G2How can I tell facebook to stop emailing me?[{'followers': 238905, 'name': 'Facebook'}]238905.0Facebook
89840.207373True10AAEAAHaEN4jlW0hrNd+wj1Xx9bWV2XiE0+5kkBbpk0cS/XCDWho does cover hound use to provide auto rate ...[{'followers': 809, 'name': 'Auto Insurance'}]809.0Auto Insurance
89850.662722True20AAEAAO10zYF1GIDQenYcsr4KV8T5f53wX0d491daxFrxJfxEIs Wuthering Heights a feminist text?[{'followers': 590279, 'name': 'Books'}, {'fol...NaNNaN
89864.123288False1200AAEAAIO1CRxV7oxl//ejIL5mkNUJqShjAlSNiOaXEiQFChq+How will better audience data change the movie...[{'followers': 1, 'name': 'User Data'}, {'foll...500022.0Movies
89870.352941False00AAEAAOKeIMX2TbFS2CdHXtBWs++0egdI5p4FB2TZTlLyph7DIn what condition to descendants of royalty live?[{'followers': 361, 'name': 'Royalty'}]361.0Royalty
89880.488525False0400AAEAALlzDzfzi6ULFlDFEbxjfkQTdJRmyDeB7Oz343GX3ZzzWill the developing world be more innovative d...[{'followers': 24985, 'name': 'Innovation'}, {...24985.0Innovation
89896.908078False50AAEAAJj02/B0zzfVYoV/ujoCNopCXWyQ1l1joancxgjHTOvcAre there living samurai in this age?[{'followers': 12423, 'name': 'Japan'}, {'foll...782.0Samurai
89902.077295False1200AAEAAF3/vH5TKSTV79CQ2wWCe7UPuPUQ7GqKZ+zy/WZpyWTSHow is it like to hire a life coach or persona...[{'followers': 11233, 'name': 'Life Advice'}, ...20706.0Self-Improvement
89910.490798False2400AAEAABeFQkBTvekTH2LwM9QRMeaYrb43rq4KQTB3ixkjIUW6What happens to my links if I disconnect my cu...[{'followers': 1483, 'name': 'Bitly'}, {'follo...13867.0Web Applications
89920.197080False20AAEAAG1ehKZlxWfZ3u8Ty8xu5l2N+kghEcv62oITGGiqZj62Can Curiosity record sound?[{'followers': 295, 'name': 'Curiosity (Mars R...295.0Curiosity (Mars Rover)
89933.375000False10AAEAAITna52dCVn2KCVY3+xhMh4dbliiirA/gdi74f+v2zyGIs it realistic to think you can get a decent ...[{'followers': 6423, 'name': 'Germany'}]6423.0Germany
89940.482143False10AAEAAB8MgrMHBPrcEd+z8uWtFtE0jU1VhHBx4bSj3dLaMaitCan someone explain to me how the Syrian war b...[{'followers': 854, 'name': 'Syria'}, {'follow...0.0Syrian War
89952.850000False00AAEAANESwEBxHZJt2IIhT1/YgqvPOOHySqU0TPMHvefVX6RnHow old are the wolves growly pants and truck ...[{'followers': 10123, 'name': 'Animals'}, {'fo...10123.0Animals
89960.274648False00AAEAABT6OZZisoRkeAFNxYWAssLUu45g4iNjeQiaAEVkPa2ZWhat is the best Agenda (notes, gant charts, C...[{'followers': 7149, 'name': 'iPad Application...7149.0iPad Applications
89973.146893True10AAEAAAUdDfIgSIYlFRrY4jOKvHsvSLmlKjyZ576oP8a+L694December 2012: Are all the Hobbit films alread...[{'followers': 18741, 'name': 'The Hobbit (193...146.0The Hobbit (movie series)
89980.131086False00AAEAADeVLG2awg6hG+dTiPKRiII64khN7fS/OeFLek4lg2QQRental Navigator asks...If you are a real esta...[{'followers': 7260, 'name': 'Real Estate'}]7260.0Real Estate
89992.738739False20AAEAAKeoz9V34X6kt6Iq+ywD6JKTBkJxointHniuxnF2ejHaEnergy of motion turns into mass?[{'followers': 199773, 'name': 'Physics'}]199773.0Physics
\n", "

9000 rows × 9 columns

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