Skip to content

Instantly share code, notes, and snippets.

@jvanlier

jvanlier/gist:62d6c22017029e1b1437

Created January 5, 2015 19:33
Show Gist options
  • Save jvanlier/62d6c22017029e1b1437 to your computer and use it in GitHub Desktop.
Save jvanlier/62d6c22017029e1b1437 to your computer and use it in GitHub Desktop.
Download ZIP
ReturnVisits
Raw
gistfile1.txt
[jorivanlier@gate-001 Hadoop_ReturnVisit]$ ./ReturnVisitAnalysis.py
[DEBUG] ApplicationId: kpmgRestaurant
measurementTimestamp lastSeenTimestamp tDiffSec tDiffDays
count 5.060000e+02 5.060000e+02 5.060000e+02 506.000000
mean 1.420460e+12 1.419093e+12 1.367332e+09 15.825605
std 6.961196e+06 5.102638e+08 5.088012e+08 5.888903
min 1.420443e+12 1.417697e+12 7.191615e+07 0.832363
25% 1.420456e+12 1.418813e+12 1.118531e+09 12.945955
50% 1.420458e+12 1.418989e+12 1.468340e+09 16.994682
75% 1.420460e+12 1.419338e+12 1.651124e+09 19.110230
max 1.420486e+12 1.420413e+12 2.758769e+09 31.930199
[DEBUG] Total unique visits on date: 838, new (unknown) visits: 332, return visits: 506, return rate: 60.4 procent
[DEBUG] Bin 1: ( 0.0, 1.5]: 9
[DEBUG] Bin 2: ( 1.5, 7.0]: 41
[DEBUG] Bin 3: ( 7.0, 14.0]: 153
[DEBUG] Bin 4: ( 14.0, 30.0]: 302
[DEBUG] Bin 5: ( 30.0, 90.0]: 1
[DEBUG] Bin 6: ( 90.0,180.0]: 0
[DEBUG] Bin 7: (180.0,365.0]: 0
{'processingTimestamp': datetime.datetime(2015, 1, 5, 19, 23, 39, 636724), 'measurementTimestamp': datetime.datetime(2015, 1, 5, 19, 22, 6, tzinfo=<UTC>), 'layer': 'returnVisitDaily', 'value': {'new': {'value': 332, 'error': 18.2}, 'return': {'value': 506, 'error': 22.5}, 'graph': {'1': {'maxDays': 1.5, 'minDays': 0, 'value': 9}, '3': {'maxDays': 14, 'minDays': 7, 'value': 153}, '2': {'maxDays': 7, 'minDays': 1.5, 'value': 41}, '5': {'maxDays': 90, 'minDays': 30, 'value': 1}, '4': {'maxDays': 30, 'minDays': 14, 'value': 302}, '7': {'maxDays': 365, 'minDays': 180, 'value': 0}, '6': {'maxDays': 180, 'minDays': 90, 'value': 0}}}}
[DEBUG] ApplicationId: ikeaDelftRest
measurementTimestamp lastSeenTimestamp tDiffSec tDiffDays
count 1.160000e+03 1.160000e+03 1.160000e+03 1160.000000
mean 1.420461e+12 1.419547e+12 9.137477e+08 10.575784
std 1.183801e+07 7.659194e+08 7.665668e+08 8.872301
min 1.420428e+12 1.417627e+12 1.846058e+07 0.213664
25% 1.420453e+12 1.418834e+12 1.409888e+08 1.631815
50% 1.420458e+12 1.419843e+12 6.189364e+08 7.163615
75% 1.420469e+12 1.420315e+12 1.626717e+09 18.827744
max 1.420486e+12 1.420413e+12 2.851229e+09 33.000332
[DEBUG] Total unique visits on date: 5411, new (unknown) visits: 4251, return visits: 1160, return rate: 21.4 procent
[DEBUG] Bin 1: ( 0.0, 1.5]: 283
[DEBUG] Bin 2: ( 1.5, 7.0]: 279
[DEBUG] Bin 3: ( 7.0, 14.0]: 130
[DEBUG] Bin 4: ( 14.0, 30.0]: 465
[DEBUG] Bin 5: ( 30.0, 90.0]: 3
[DEBUG] Bin 6: ( 90.0,180.0]: 0
[DEBUG] Bin 7: (180.0,365.0]: 0
{'processingTimestamp': datetime.datetime(2015, 1, 5, 19, 24, 39, 561100), 'measurementTimestamp': datetime.datetime(2015, 1, 5, 19, 23, 10, tzinfo=<UTC>), 'layer': 'returnVisitDaily', 'value': {'new': {'value': 4251, 'error': 65.2}, 'return': {'value': 1160, 'error': 34.1}, 'graph': {'1': {'maxDays': 1.5, 'minDays': 0, 'value': 283}, '3': {'maxDays': 14, 'minDays': 7, 'value': 130}, '2': {'maxDays': 7, 'minDays': 1.5, 'value': 279}, '5': {'maxDays': 90, 'minDays': 30, 'value': 3}, '4': {'maxDays': 30, 'minDays': 14, 'value': 465}, '7': {'maxDays': 365, 'minDays': 180, 'value': 0}, '6': {'maxDays': 180, 'minDays': 90, 'value': 0}}}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment