Skip to content

Instantly share code, notes, and snippets.

@Zmey56

Zmey56/gist:20682d998714292468c0aa781182f93c

Last active September 2, 2022 14:44
Show Gist options
  • Save Zmey56/20682d998714292468c0aa781182f93c to your computer and use it in GitHub Desktop.
Save Zmey56/20682d998714292468c0aa781182f93c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
report = msg.format(date=today.date(),
events=data_msg[data_msg['date'] == today.date()]['msg'].iloc[0]
+ data_feed[data_feed['date'] == today.date()]['events'].iloc[0],
users=data_dau_all[data_dau_all['date'] == today.date()]['users'].iloc[0],
to_users_day_ago = (data_dau_all[data_dau_all['date'] == today.date()]['users'].iloc[0]
- data_dau_all[data_dau_all['date'] == day_ago.date()]['users'].iloc[0])
/data_dau_all[data_dau_all['date'] == day_ago.date()]['users'].iloc[0],
to_users_week_ago = (data_dau_all[data_dau_all['date'] == today.date()]['users'].iloc[0]
- data_dau_all[data_dau_all['date'] == week_ago.date()]['users'].iloc[0])
/data_dau_all[data_dau_all['date'] == week_ago.date()]['users'].iloc[0],
users_ios=data_dau_all[data_dau_all['date'] == today.date()]['users_ios'].iloc[0],
to_users_ios_day_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_ios'].iloc[0]
- data_dau_all[data_dau_all['date'] == day_ago.date()]['users_ios'].iloc[0])
/ data_dau_all[data_dau_all['date'] == day_ago.date()]['users_ios'].iloc[0],
to_users_ios_week_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_ios'].iloc[0]
- data_dau_all[data_dau_all['date'] == week_ago.date()]['users_ios'].iloc[0])
/ data_dau_all[data_dau_all['date'] == week_ago.date()]['users_ios'].iloc[0],
users_and=data_dau_all[data_dau_all['date'] == today.date()]['users_and'].iloc[0],
to_users_and_day_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_and'].iloc[0]
- data_dau_all[data_dau_all['date'] == day_ago.date()]['users_and'].iloc[0])
/ data_dau_all[data_dau_all['date'] == day_ago.date()]['users_and'].iloc[0],
to_users_and_week_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_and'].iloc[0]
-
data_dau_all[data_dau_all['date'] == week_ago.date()]['users_and'].iloc[
0])
/ data_dau_all[data_dau_all['date'] == week_ago.date()]['users_and'].iloc[
0],
users_male=data_dau_all[data_dau_all['date'] == today.date()]['users_male'].iloc[0],
to_users_male_day_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_male'].iloc[0]
- data_dau_all[data_dau_all['date'] == day_ago.date()]['users_male'].iloc[0])
/ data_dau_all[data_dau_all['date'] == day_ago.date()]['users_male'].iloc[0],
to_users_male_week_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_male'].iloc[0]
- data_dau_all[data_dau_all['date'] == week_ago.date()]['users_male'].iloc[0])
/ data_dau_all[data_dau_all['date'] == week_ago.date()]['users_male'].iloc[0],
users_female=data_dau_all[data_dau_all['date'] == today.date()]['users_female'].iloc[0],
to_users_female_day_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_female'].iloc[0]
- data_dau_all[data_dau_all['date'] == day_ago.date()]['users_female'].iloc[0])
/ data_dau_all[data_dau_all['date'] == day_ago.date()]['users_female'].iloc[0],
to_users_female_week_ago=(data_dau_all[data_dau_all['date'] == today.date()]['users_female'].iloc[0]
-
data_dau_all[data_dau_all['date'] == week_ago.date()]['users_female'].iloc[
0])
/ data_dau_all[data_dau_all['date'] == week_ago.date()]['users_female'].iloc[
0],
new_users=data_new_users[data_new_users['date'] == today.date()]['new_users'].iloc[0],
to_new_users_day_ago=(data_new_users[data_new_users['date'] == today.date()]['new_users'].iloc[0]
- data_new_users[data_new_users['date'] == day_ago.date()]['new_users'].iloc[0])
/ data_new_users[data_new_users['date'] == day_ago.date()]['new_users'].iloc[0],
to_new_users_week_ago=(data_new_users[data_new_users['date'] == today.date()]['new_users'].iloc[0]
-
data_new_users[data_new_users['date'] == week_ago.date()]['new_users'].iloc[
0])
/ data_new_users[data_new_users['date'] == week_ago.date()]['new_users'].iloc[
0],
new_users_ads=data_new_users[data_new_users['date'] == today.date()]['new_users_ads'].iloc[0],
to_new_users_ads_day_ago=(data_new_users[data_new_users['date'] == today.date()]['new_users_ads'].iloc[0]
- data_new_users[data_new_users['date'] == day_ago.date()]['new_users_ads'].iloc[0])
/ data_new_users[data_new_users['date'] == day_ago.date()]['new_users_ads'].iloc[0],
to_new_users_ads_week_ago=(data_new_users[data_new_users['date'] == today.date()]['new_users_ads'].iloc[0]
- data_new_users[data_new_users['date'] == week_ago.date()][
'new_users_ads'].iloc[0])
/
data_new_users[data_new_users['date'] == week_ago.date()]['new_users_ads'].iloc[
0],
new_users_org=data_new_users[data_new_users['date'] == today.date()]['new_users_organic'].iloc[
0],
to_new_users_org_day_ago=(data_new_users[data_new_users['date'] == today.date()]['new_users_organic'].iloc[0]
- data_new_users[data_new_users['date'] == day_ago.date()]['new_users_organic'].iloc[
0])
/ data_new_users[data_new_users['date'] == day_ago.date()]['new_users_organic'].iloc[0],
to_new_users_org_week_ago=(data_new_users[data_new_users['date'] == today.date()][
'new_users_organic'].iloc[0]
- data_new_users[data_new_users['date'] == week_ago.date()][
'new_users_organic'].iloc[0])
/
data_new_users[data_new_users['date'] == week_ago.date()][
'new_users_organic'].iloc[
0],
users_feed=data_feed[data_feed['date'] == today.date()]['users_feed'].iloc[0],
to_users_feed_day_ago=(data_feed[data_feed['date'] == today.date()]['users_feed'].iloc[0]
- data_feed[data_feed['date'] == day_ago.date()]['users_feed'].iloc[0])
/ data_feed[data_feed['date'] == day_ago.date()]['users_feed'].iloc[0],
to_users_feed_week_ago=(data_feed[data_feed['date'] == today.date()]['users_feed'].iloc[0]
- data_feed[data_feed['date'] == week_ago.date()]['users_feed'].iloc[0])
/ data_feed[data_feed['date'] == week_ago.date()]['users_feed'].iloc[0],
likes=data_feed[data_feed['date'] == today.date()]['likes'].iloc[0],
to_likes_day_ago=(data_feed[data_feed['date'] == today.date()]['likes'].iloc[0]
- data_feed[data_feed['date'] == day_ago.date()]['likes'].iloc[0])
/ data_feed[data_feed['date'] == day_ago.date()]['likes'].iloc[0],
to_likes_week_ago=(data_feed[data_feed['date'] == today.date()]['likes'].iloc[0]
- data_feed[data_feed['date'] == week_ago.date()]['likes'].iloc[0])
/ data_feed[data_feed['date'] == week_ago.date()]['likes'].iloc[0],
views=data_feed[data_feed['date'] == today.date()]['views'].iloc[0],
to_views_day_ago=(data_feed[data_feed['date'] == today.date()]['views'].iloc[0]
- data_feed[data_feed['date'] == day_ago.date()]['views'].iloc[0])
/ data_feed[data_feed['date'] == day_ago.date()]['views'].iloc[0],
to_views_week_ago=(data_feed[data_feed['date'] == today.date()]['views'].iloc[0]
- data_feed[data_feed['date'] == week_ago.date()]['views'].iloc[0])
/ data_feed[data_feed['date'] == week_ago.date()]['views'].iloc[0],
ctr=data_feed[data_feed['date'] == today.date()]['CTR'].iloc[0],
to_ctr_day_ago=(data_feed[data_feed['date'] == today.date()]['CTR'].iloc[0]
- data_feed[data_feed['date'] == day_ago.date()]['CTR'].iloc[0])
/ data_feed[data_feed['date'] == day_ago.date()]['CTR'].iloc[0],
to_ctr_week_ago=(data_feed[data_feed['date'] == today.date()]['CTR'].iloc[0]
- data_feed[data_feed['date'] == week_ago.date()]['CTR'].iloc[0])
/ data_feed[data_feed['date'] == week_ago.date()]['CTR'].iloc[0],
users_msg=data_msg[data_msg['date'] == today.date()]['users_msg'].iloc[0],
to_users_msg_day_ago=(data_msg[data_msg['date'] == today.date()]['users_msg'].iloc[0]
- data_msg[data_msg['date'] == day_ago.date()]['users_msg'].iloc[0])
/ data_msg[data_msg['date'] == day_ago.date()]['users_msg'].iloc[0],
to_users_msg_week_ago=(data_msg[data_msg['date'] == today.date()]['users_msg'].iloc[0]
- data_msg[data_msg['date'] == week_ago.date()]['users_msg'].iloc[0])
/ data_msg[data_msg['date'] == week_ago.date()]['users_msg'].iloc[0],
msg=data_msg[data_msg['date'] == today.date()]['msg'].iloc[0],
to_msg_day_ago=(data_msg[data_msg['date'] == today.date()]['msg'].iloc[0]
- data_msg[data_msg['date'] == day_ago.date()]['msg'].iloc[0])
/ data_msg[data_msg['date'] == day_ago.date()]['msg'].iloc[0],
to_msg_week_ago=(data_msg[data_msg['date'] == today.date()]['msg'].iloc[0]
- data_msg[data_msg['date'] == week_ago.date()]['msg'].iloc[0])
/ data_msg[data_msg['date'] == week_ago.date()]['msg'].iloc[0],
mpu=data_msg[data_msg['date'] == today.date()]['mpu'].iloc[0],
to_mpu_day_ago=(data_msg[data_msg['date'] == today.date()]['mpu'].iloc[0]
- data_msg[data_msg['date'] == day_ago.date()]['mpu'].iloc[0])
/ data_msg[data_msg['date'] == day_ago.date()]['mpu'].iloc[0],
to_mpu_week_ago=(data_msg[data_msg['date'] == today.date()]['mpu'].iloc[0]
- data_msg[data_msg['date'] == week_ago.date()]['mpu'].iloc[0])
/ data_msg[data_msg['date'] == week_ago.date()]['mpu'].iloc[0]
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment