def get_accept_rate(user_id=246246):
#print 'StackOverflow user %d\'s experience:' % user_id
so = Site(StackOverflow)
user = so.user(user_id)
#print 'Total badge count : %s'% user.badge_total
global_sof_json['badges'] = user.badge_total
global_sof_json['age'] = user.age
global_sof_json['location'] = user.location
global_sof_json['website'] = user.webiste_url
if len(user.top_answer_tags.fetch()) > 0:
global_sof_json['experienced'] = user.top_answer_tags.fetch()[0].tag_name
#print 'Most experienced on %s.' % user.top_answer_tags.fetch()[0].tag_name
#print 'Most curious about %s.' % user.top_question_tags.fetch()[0].tag_name
total_questions = len(user.questions.fetch())
unaccepted_questions = len(user.unaccepted_questions.fetch())
accepted = total_questions - unaccepted_questions
rate = accepted / float(total_questions) * 100
global_sof_json['accept_rate'] = format(rate, '.2f')
from cassandra.cqlengine.models import Model
from cassandra.cluster import Cluster
import time
cluster = Cluster()
session = cluster.connect('stackoverflow')
f = open('finalUSERS.txt', 'r')
idlist = f.read().split(',')
combinedStats = []
i=1
with open('SOoutput.txt','a') as op:
for id in idlist:
user_stat = {}
so = Site(StackOverflow)
user = so.user(id)
total_questions = user.questions.fetch()
user_stat['userID'] = id
questions_text = []
for q in total_questions:
questions_text.append(unicode(q).split("'")[1])
user_stat['questions'] = questions_text
combinedStats.append(user_stat)
combined_questions = " ".join(questions_text)
'''op.write('==='.encode('utf-8') + str(id).encode('utf-8') + ' '.encode('utf-8') + '<<< '.encode('utf-8') + combined_questions.encode('utf-8') + ' >>>'.encode('utf-8'))'''
time.sleep(3)
session.execute("INSERT INTO stackdata(id,questions) VALUES(%s,%s)", (int(id), combined_questions.encode('utf-8')))
print 'finished inserting ' + str(i)
i=i+1
from __future__ import print_function
import sys
sys.path.append('.')
sys.path.append('..')
from stackexchange import Site, StackOverflow
user_id = 41981 if len(sys.argv) < 2 else int(sys.argv[1])
print('StackOverflow user %d\'s experience:' % user_id)
so = Site(StackOverflow)
user = so.user(user_id)
print('Most experienced on %s.' % user.top_answer_tags.fetch()[0].tag_name)
print('Most curious about %s.' % user.top_question_tags.fetch()[0].tag_name)
total_questions = len(user.questions.fetch())
unaccepted_questions = len(user.unaccepted_questions.fetch())
accepted = total_questions - unaccepted_questions
rate = accepted / float(total_questions) * 100
print('Accept rate is %.2f%%.' % rate)
#!/usr/bin/env python
# a hack so you can run it 'python demo/stats.py'
import sys
sys.path.append(".")
sys.path.append("..")
from stackexchange import Site, StackOverflow
user_id = 41981 if len(sys.argv) < 2 else int(sys.argv[1])
print "StackOverflow user %d's experience:" % user_id
so = Site(StackOverflow)
user = so.user(user_id)
print "Most experienced on %s." % user.top_answer_tags.fetch()[0].tag_name
print "Most curious about %s." % user.top_question_tags.fetch()[0].tag_name
total_questions = len(user.questions)
unaccepted_questions = len(user.unaccepted_questions.fetch())
accepted = total_questions - unaccepted_questions
rate = accepted / float(total_questions) * 100
print "Accept rate is %.2f%%." % rate
from cassandra.cluster import Cluster
import time
cluster = Cluster()
session = cluster.connect('stackoverflow')
f = open('finalUSERS.txt', 'r')
idlist = f.read().split(',')
combinedStats = []
i = 1
with open('SOoutput.txt', 'a') as op:
for id in idlist:
user_stat = {}
so = Site(StackOverflow)
user = so.user(id)
total_questions = user.questions.fetch()
user_stat['userID'] = id
questions_text = []
for q in total_questions:
questions_text.append(unicode(q).split("'")[1])
user_stat['questions'] = questions_text
combinedStats.append(user_stat)
combined_questions = " ".join(questions_text)
'''op.write('==='.encode('utf-8') + str(id).encode('utf-8') + ' '.encode('utf-8') + '<<< '.encode('utf-8') + combined_questions.encode('utf-8') + ' >>>'.encode('utf-8'))'''
time.sleep(3)
session.execute("INSERT INTO stackdata(id,questions) VALUES(%s,%s)",
(int(id), combined_questions.encode('utf-8')))
print 'finished inserting ' + str(i)
i = i + 1
__FILENAME__ = experience
#!/usr/bin/env python
# a hack so you can run it 'python demo/stats.py'
import sys
sys.path.append('.')
sys.path.append('..')
from stackexchange import Site, StackOverflow
user_id = 41981 if len(sys.argv) < 2 else int(sys.argv[1])
print 'StackOverflow user %d\'s experience:' % user_id
so = Site(StackOverflow)
user = so.user(user_id)
print 'Most experienced on %s.' % user.top_answer_tags.fetch()[0].tag_name
print 'Most curious about %s.' % user.top_question_tags.fetch()[0].tag_name
total_questions = len(user.questions.fetch())
unaccepted_questions = len(user.unaccepted_questions.fetch())
accepted = total_questions - unaccepted_questions
rate = accepted / float(total_questions) * 100
print 'Accept rate is %.2f%%.' % rate
########NEW FILE########
__FILENAME__ = highest_voted
#!/usr/bin/env python
# a hack so you can run it 'python demo/stats.py'
import sys
sys.path.append('.')
