calCtr.py 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. #coding utf-8
  2. import sys
  3. from operator import itemgetter
  4. import json
  5. import pandas as pd
  6. from db_help import RedisHelper
  7. if __name__=="__main__":
  8. #1.load data
  9. nowdate=sys.argv[1]
  10. vlog='0'
  11. love_live = 4
  12. data_path = "./data/video_data_"+nowdate
  13. f = open(data_path)
  14. #data = pd.read_csv(data_path, encoding="utf-8", sep='\t')
  15. #print(data)
  16. index = 0
  17. data_dict = {}
  18. redis_helper = RedisHelper()
  19. while True:
  20. line = f.readline()
  21. if not line:
  22. break
  23. if index==0:
  24. index += 1
  25. continue
  26. index +=1
  27. items = line.strip().split("\t")
  28. if len(items)<11:
  29. continue
  30. vid = items[1]
  31. view_users = int(items[4])
  32. view_pv = int(items[5])
  33. play_users = int(items[6])
  34. play_pv = int(items[7])
  35. share_users = int(items[8])
  36. share_pv = int(items[9])
  37. return_users = int(items[10])
  38. #print(items)
  39. if vid not in data_dict:
  40. data_dict[vid] = (view_users, view_pv, play_users, play_pv, share_users, share_pv, return_users)
  41. else:
  42. item_info = data_dict[vid]
  43. view_users = item_info[0]+view_users
  44. view_pv = item_info[1]+view_pv
  45. play_users = item_info[2]+play_users
  46. play_pv = item_info[3]+play_pv
  47. share_users = item_info[4]+share_users
  48. share_pv = item_info[5]+share_pv
  49. return_users = item_info[6]+return_users
  50. data_dict[vid] = (view_users, view_pv, play_users, play_pv, share_users, share_pv, return_users)
  51. #print(data_dict.items())
  52. info_dict = {}
  53. data_path = "./data/sorted_data_"+nowdate
  54. f = open(data_path, 'w')
  55. for k, v in data_dict.items():
  56. #print(v)
  57. return_users = v[6]
  58. #print(return_users)
  59. view_users = v[0]
  60. view_pv = v[1]
  61. share_pv = v[5]
  62. share_users = v[4]
  63. play_users = v[2]
  64. play_pv = v[3]
  65. #print("return_users:", return_users)
  66. k_score = float(return_users)/(float(view_users)+10)
  67. k_score2 = float(return_users)/(float(view_pv)+10)
  68. #print(k_score)
  69. share_score = float(share_pv)/(float(view_pv)+5)
  70. backrate = float(return_users)/(float(view_users)+5)
  71. #print(k, k_score, share_score*backrate, share_score, backrate)
  72. score_info = [k_score2, share_score*backrate, share_score, backrate, view_users, view_pv, play_users, play_pv, share_users, share_pv, return_users]
  73. k = "k_p:"+k
  74. score_info = json.dumps(score_info)
  75. info_dict[k] = score_info
  76. f.write(k+"\t"+score_info+"\n")
  77. redis_helper.update_batch_setnx_key(info_dict, 60*60*24*15)
  78. f.close()