22 lines
950 B
Python
22 lines
950 B
Python
import pandas, os
|
|
|
|
def getNRRdata(filename):
|
|
df = pandas.read_excel(filename, engine="openpyxl")
|
|
jason014sum = df.sum(axis=0)['jasonapp014 counts']
|
|
jason018sum = df.sum(axis=0)['jasonapp018 counts']
|
|
jason019sum = df.sum(axis=0)['jasonapp019 counts']
|
|
nrdf = df[df['result Counts'] == 0]
|
|
nrjason014sum = nrdf.sum(axis=0)['jasonapp014 counts']
|
|
nrjason018sum = nrdf.sum(axis=0)['jasonapp018 counts']
|
|
nrjason019sum = nrdf.sum(axis=0)['jasonapp019 counts']
|
|
jason014nrr = nrjason014sum / jason014sum
|
|
jason018nrr = nrjason018sum / jason018sum
|
|
jason019nrr = nrjason019sum / jason019sum
|
|
res = [{'할인중독NRR': jason014nrr, '심쿵할인NRR': jason018nrr, '공구마켓NRR': jason019nrr}]
|
|
resdf = pandas.DataFrame(res)
|
|
return resdf
|
|
|
|
# 스크립트를 실행하려면 여백의 녹색 버튼을 누릅니다.
|
|
if __name__ == '__main__':
|
|
df = getNRRdata("./usrkwds_2023-03-08_day.xlsx")
|
|
print(df) |