def update_users_genre_lang_score(cursor):
cursor.execute("select user_id,playDuration,lang,genre from sd_archive_track_clicks where playDuration > 15 and user_id!=0 and genre!=0 and lang!=0 and lang <21 and genre <24 and playDate > '2016-10-01'order by playDate desc")
db.commit()
numrows = int(cursor.rowcount)
tracks_played= cursor.fetchall()
#print tracks_played

genre_list=[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
lang_list=[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
#initialization part
user_genre_score = {}
user_lang_score = {}

for track in tracks_played:

        user_genre_score[track['user_id']]={}
        user_lang_score[track['user_id']]={}
        for genre in genre_list:
                user_genre_score[track['user_id']][genre]=0
        for lang in lang_list:
                user_lang_score[track['user_id']][lang]=0
#initialization part end
for track in tracks_played:
        user_genre_score[track['user_id']][track['genre']]=int(user_genre_score[track['user_id']][track['genre']]) + 1
        user_lang_score[track['user_id']][track['lang']]=int(user_lang_score[track['user_id']][track['lang']]) + 1