import pandas as pd
from wmfdata import charting, hive
import numpy as np
You can find the source for `wmfdata` at https://github.com/neilpquinn/wmfdata
charting.set_mpl_style()
--------------------------------------------------------------------------- AttributeError Traceback (most recent call last) <ipython-input-2-80bd11ee1024> in <module>() ----> 1 charting.set_mpl_style() ~/venv/lib/python3.5/site-packages/wmfdata/charting.py in set_mpl_style() 12 13 def set_mpl_style(): ---> 14 mpl.style.use(mpl_style) 15 16 def M_str(x, pos): AttributeError: module 'matplotlib' has no attribute 'style'
window_opens = hive.run("""
select
to_date(dt) as date,
event.action as action,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 7 and
event.action like "window-open%"
group by
to_date(dt),
event.action
""")
window_opens = (
window_opens
.pivot_table(index="date", columns="action")
)
old_window_opens = window_opens.iloc[:, 0]
new_window_opens = window_opens.iloc[:, 1:].sum(axis=1)
pd.concat([old_window_opens, new_window_opens], axis=1).plot()
<matplotlib.axes._subplots.AxesSubplot at 0x7f0d9ad1c630>
window_opens_by_platform_r = hive.run("""
select
to_date(eas.dt) as date,
eas.event.platform,
vefu.event.action as action,
count(*) as events
from event.visualeditorfeatureuse vefu
inner join event.editattemptstep eas
on
vefu.event.editingsessionid = eas.event.editing_session_id and
eas.event.action = "init" and
vefu.event.action like "window-open%" and
vefu.year = 2019 and vefu.month = 7 and
eas.year = 2019 and eas.month = 7
group by
to_date(eas.dt),
eas.event.platform,
vefu.event.action
""")
(
window_opens_by_platform_r
.pivot_table(index="date", columns=["action", "platform"])
.fillna(0)
.applymap(int)
)
events | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
action | window-open | window-open-from-command | window-open-from-context | window-open-from-sequence | window-open-from-tool | window-open-from-trigger | ||||||
platform | desktop | phone | desktop | phone | desktop | phone | desktop | phone | desktop | phone | desktop | phone |
date | ||||||||||||
2019-07-01 | 6902 | 1580 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-02 | 7185 | 1673 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-03 | 7234 | 1851 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-04 | 7225 | 14030 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-05 | 6225 | 12924 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-06 | 5260 | 12187 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-07 | 5994 | 15977 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-08 | 6920 | 11916 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-09 | 6889 | 12526 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2019-07-10 | 7162 | 14158 | 1 | 0 | 5 | 2 | 0 | 0 | 9 | 0 | 0 | 0 |
2019-07-11 | 5784 | 10328 | 150 | 56 | 126 | 597 | 30 | 31 | 474 | 674 | 5 | 0 |
2019-07-12 | 24 | 20 | 254 | 430 | 898 | 3709 | 229 | 310 | 2047 | 3028 | 52 | 0 |
2019-07-13 | 1 | 2 | 384 | 404 | 889 | 3034 | 170 | 245 | 1965 | 4160 | 47 | 1 |
2019-07-14 | 7 | 2 | 267 | 390 | 881 | 3978 | 258 | 371 | 2011 | 3873 | 66 | 0 |
2019-07-15 | 2 | 0 | 315 | 375 | 996 | 3115 | 186 | 366 | 1818 | 3464 | 55 | 0 |
2019-07-16 | 0 | 1 | 330 | 400 | 968 | 2869 | 181 | 340 | 2563 | 3998 | 63 | 2 |
2019-07-17 | 0 | 0 | 472 | 409 | 950 | 2966 | 143 | 277 | 1862 | 3273 | 82 | 1 |
2019-07-18 | 0 | 0 | 352 | 321 | 1060 | 2969 | 216 | 264 | 2427 | 3439 | 45 | 0 |
2019-07-19 | 0 | 0 | 612 | 331 | 947 | 2852 | 246 | 391 | 2638 | 3344 | 54 | 1 |
2019-07-20 | 0 | 0 | 220 | 367 | 797 | 3362 | 122 | 396 | 1761 | 4014 | 65 | 2 |
2019-07-21 | 0 | 0 | 302 | 398 | 939 | 3485 | 172 | 325 | 2039 | 3802 | 71 | 0 |
2019-07-22 | 0 | 0 | 276 | 342 | 1121 | 3791 | 132 | 269 | 2258 | 3084 | 97 | 0 |
2019-07-23 | 0 | 0 | 505 | 342 | 1165 | 3161 | 277 | 217 | 2376 | 2960 | 95 | 1 |
2019-07-24 | 0 | 0 | 499 | 357 | 993 | 3039 | 188 | 316 | 2441 | 3302 | 106 | 0 |
2019-07-25 | 0 | 0 | 310 | 288 | 745 | 2342 | 139 | 148 | 1514 | 2327 | 113 | 0 |
window_opens_by_feature_r = hive.run("""
select
to_date(dt) as date,
event.feature as feature,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 7 and
event.action like "window-open%"
group by
to_date(dt),
event.feature
""")
window_opens_by_feature_r.pivot_table(index="date", columns=["feature"]).fillna(0).sort_values("2019-07-01", axis=1, ascending=False)
events | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
feature | mwSave | link | transclusion | citoid | cite | media | reference | meta | wikitextLink | gallery | ... | score | mwPre | mwLanguageVariant-twoway | mwLanguageVariant-disabled | chemDialog | syntaxhighlightInspector | flowMention | commandHelp | chemInspector | wikitextswitchconfirm |
date | |||||||||||||||||||||
2019-07-01 | 7894.0 | 6920.0 | 4939.0 | 2168.0 | 539.0 | 438.0 | 197.0 | 129.0 | 84.0 | 78.0 | ... | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-02 | 7713.0 | 7281.0 | 4644.0 | 2246.0 | 723.0 | 477.0 | 277.0 | 100.0 | 38.0 | 74.0 | ... | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 |
2019-07-03 | 7561.0 | 6992.0 | 4514.0 | 2191.0 | 459.0 | 421.0 | 272.0 | 135.0 | 34.0 | 59.0 | ... | 1.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 |
2019-07-04 | 7926.0 | 7794.0 | 5204.0 | 2253.0 | 500.0 | 377.0 | 305.0 | 116.0 | 68.0 | 77.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1.0 | 0.0 | 0.0 |
2019-07-05 | 7535.0 | 6606.0 | 4970.0 | 2106.0 | 578.0 | 276.0 | 278.0 | 95.0 | 31.0 | 64.0 | ... | 3.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 4.0 | 0.0 | 1.0 | 0.0 |
2019-07-06 | 7371.0 | 6125.0 | 4755.0 | 1866.0 | 443.0 | 249.0 | 255.0 | 91.0 | 28.0 | 54.0 | ... | 2.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-07 | 9337.0 | 7922.0 | 5869.0 | 2288.0 | 580.0 | 417.0 | 233.0 | 106.0 | 39.0 | 58.0 | ... | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 |
2019-07-08 | 7505.0 | 6539.0 | 4678.0 | 2074.0 | 529.0 | 309.0 | 277.0 | 117.0 | 29.0 | 68.0 | ... | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 2.0 | 0.0 | 1.0 |
2019-07-09 | 7517.0 | 7534.0 | 4748.0 | 2206.0 | 436.0 | 396.0 | 281.0 | 96.0 | 34.0 | 70.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 2.0 | 0.0 | 0.0 |
2019-07-10 | 8200.0 | 7977.0 | 4687.0 | 2354.0 | 574.0 | 415.0 | 289.0 | 96.0 | 75.0 | 55.0 | ... | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 1.0 | 0.0 | 0.0 |
2019-07-11 | 6151.0 | 7314.0 | 4615.0 | 1727.0 | 480.0 | 355.0 | 314.0 | 111.0 | 61.0 | 97.0 | ... | 3.0 | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 1.0 | 2.0 | 0.0 | 0.0 |
2019-07-12 | 20.0 | 7194.0 | 5082.0 | 105.0 | 44.0 | 339.0 | 246.0 | 71.0 | 105.0 | 78.0 | ... | 1.0 | 0.0 | 1.0 | 0.0 | 2.0 | 0.0 | 2.0 | 2.0 | 0.0 | 0.0 |
2019-07-13 | 2.0 | 7679.0 | 4836.0 | 0.0 | 0.0 | 324.0 | 248.0 | 42.0 | 20.0 | 85.0 | ... | 0.0 | 0.0 | 0.0 | 5.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 |
2019-07-14 | 2.0 | 8326.0 | 5280.0 | 0.0 | 0.0 | 329.0 | 298.0 | 53.0 | 96.0 | 54.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4.0 | 2.0 | 0.0 | 0.0 |
2019-07-15 | 1.0 | 6888.0 | 4655.0 | 0.0 | 0.0 | 356.0 | 360.0 | 92.0 | 38.0 | 59.0 | ... | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 |
2019-07-16 | 2.0 | 8552.0 | 4519.0 | 0.0 | 0.0 | 350.0 | 260.0 | 76.0 | 53.0 | 63.0 | ... | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4.0 | 0.0 | 3.0 | 0.0 | 0.0 |
2019-07-17 | 0.0 | 6950.0 | 4397.0 | 0.0 | 0.0 | 420.0 | 309.0 | 67.0 | 37.0 | 76.0 | ... | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 2.0 | 0.0 | 0.0 |
2019-07-18 | 0.0 | 7431.0 | 4587.0 | 0.0 | 0.0 | 265.0 | 323.0 | 71.0 | 36.0 | 62.0 | ... | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 |
2019-07-19 | 0.0 | 7815.0 | 4476.0 | 0.0 | 0.0 | 458.0 | 241.0 | 98.0 | 18.0 | 55.0 | ... | 2.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 5.0 | 0.0 | 0.0 |
2019-07-20 | 0.0 | 7653.0 | 4534.0 | 0.0 | 0.0 | 291.0 | 382.0 | 55.0 | 56.0 | 93.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 |
2019-07-21 | 0.0 | 7541.0 | 5390.0 | 0.0 | 0.0 | 270.0 | 307.0 | 76.0 | 40.0 | 89.0 | ... | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 8.0 | 0.0 | 0.0 | 0.0 |
2019-07-22 | 0.0 | 7179.0 | 5286.0 | 0.0 | 0.0 | 326.0 | 328.0 | 81.0 | 74.0 | 98.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 |
2019-07-23 | 0.0 | 7646.0 | 4786.0 | 0.0 | 0.0 | 297.0 | 251.0 | 64.0 | 62.0 | 95.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 2.0 | 0.0 | 0.0 |
2019-07-24 | 0.0 | 7544.0 | 4849.0 | 0.0 | 0.0 | 400.0 | 244.0 | 101.0 | 54.0 | 63.0 | ... | 0.0 | 5.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 3.0 | 0.0 |
2019-07-25 | 0.0 | 7508.0 | 4820.0 | 0.0 | 0.0 | 352.0 | 262.0 | 77.0 | 49.0 | 94.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 |
2019-07-26 | 0.0 | 7660.0 | 4353.0 | 0.0 | 0.0 | 331.0 | 224.0 | 61.0 | 45.0 | 58.0 | ... | 14.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 4.0 | 1.0 | 0.0 | 0.0 |
2019-07-27 | 0.0 | 7818.0 | 4863.0 | 0.0 | 0.0 | 347.0 | 258.0 | 39.0 | 11.0 | 68.0 | ... | 1.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 |
2019-07-28 | 0.0 | 7573.0 | 4782.0 | 0.0 | 0.0 | 300.0 | 265.0 | 70.0 | 23.0 | 70.0 | ... | 5.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 2.0 | 1.0 | 1.0 | 0.0 |
2019-07-29 | 0.0 | 4958.0 | 3017.0 | 0.0 | 0.0 | 255.0 | 200.0 | 63.0 | 81.0 | 44.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
29 rows × 38 columns
dialog_events = hive.run("""
select
to_date(dt) as date,
event.action as action,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 7 and
event.action like "dialog%"
group by
to_date(dt),
event.action
""").pivot_table(index="date", columns="action")
dialog_events.fillna(0)
events | ||||
---|---|---|---|---|
action | dialog-abort | dialog-convert | dialog-done | dialog-remove |
date | ||||
2019-07-10 | 13.0 | 0.0 | 32.0 | 0.0 |
2019-07-11 | 769.0 | 3.0 | 1146.0 | 0.0 |
2019-07-12 | 3486.0 | 19.0 | 5161.0 | 2.0 |
2019-07-13 | 3584.0 | 10.0 | 5863.0 | 8.0 |
2019-07-14 | 3863.0 | 10.0 | 6232.0 | 12.0 |
2019-07-15 | 3693.0 | 12.0 | 5087.0 | 14.0 |
2019-07-16 | 4079.0 | 14.0 | 6487.0 | 31.0 |
2019-07-17 | 3639.0 | 5.0 | 5188.0 | 19.0 |
2019-07-18 | 4050.0 | 7.0 | 5485.0 | 8.0 |
2019-07-19 | 3789.0 | 8.0 | 5806.0 | 31.0 |
2019-07-20 | 3518.0 | 5.0 | 5812.0 | 31.0 |
2019-07-21 | 3984.0 | 7.0 | 5576.0 | 13.0 |
2019-07-22 | 3845.0 | 5.0 | 5390.0 | 6.0 |
2019-07-23 | 3795.0 | 8.0 | 5833.0 | 6.0 |
2019-07-24 | 3868.0 | 10.0 | 5786.0 | 8.0 |
2019-07-25 | 2466.0 | 6.0 | 3983.0 | 7.0 |
context_events = hive.run("""
select
to_date(dt) as date,
event.action as action,
count(*) as events
from event_sanitized.visualeditorfeatureuse
where
year = 2019 and (month = 07 OR month = 08) and
event.action like "context%"
group by
to_date(dt),
event.action
""").pivot_table(index="date", columns="action")
context_events.fillna(0)
events | |||||
---|---|---|---|---|---|
action | context-clear | context-close | context-delete | context-label | context-show |
date | |||||
2019-07-10 | 7.0 | 0.0 | 15.0 | 0.0 | 126.0 |
2019-07-11 | 253.0 | 0.0 | 309.0 | 10.0 | 13726.0 |
2019-07-12 | 1251.0 | 0.0 | 1937.0 | 97.0 | 75965.0 |
2019-07-13 | 2233.0 | 0.0 | 2223.0 | 47.0 | 75380.0 |
2019-07-14 | 873.0 | 0.0 | 1277.0 | 89.0 | 82460.0 |
2019-07-15 | 1129.0 | 0.0 | 1639.0 | 91.0 | 74844.0 |
2019-07-16 | 1632.0 | 0.0 | 2456.0 | 118.0 | 82762.0 |
2019-07-17 | 810.0 | 0.0 | 1381.0 | 71.0 | 69179.0 |
2019-07-18 | 1368.0 | 0.0 | 1337.0 | 93.0 | 74481.0 |
2019-07-19 | 1091.0 | 0.0 | 1167.0 | 85.0 | 73857.0 |
2019-07-20 | 1109.0 | 0.0 | 1243.0 | 91.0 | 76822.0 |
2019-07-21 | 895.0 | 0.0 | 1397.0 | 74.0 | 76003.0 |
2019-07-22 | 1460.0 | 0.0 | 1256.0 | 101.0 | 76706.0 |
2019-07-23 | 1455.0 | 0.0 | 1138.0 | 87.0 | 81642.0 |
2019-07-24 | 935.0 | 0.0 | 948.0 | 89.0 | 76595.0 |
2019-07-25 | 859.0 | 0.0 | 1040.0 | 102.0 | 72893.0 |
2019-07-26 | 962.0 | 0.0 | 1047.0 | 54.0 | 72568.0 |
2019-07-27 | 1103.0 | 0.0 | 1295.0 | 48.0 | 74801.0 |
2019-07-28 | 1144.0 | 0.0 | 1441.0 | 164.0 | 76470.0 |
2019-07-29 | 782.0 | 0.0 | 1216.0 | 112.0 | 71016.0 |
2019-07-30 | 740.0 | 0.0 | 1174.0 | 136.0 | 71626.0 |
2019-07-31 | 1160.0 | 2.0 | 1411.0 | 140.0 | 77262.0 |
2019-08-01 | 1217.0 | 390.0 | 1074.0 | 133.0 | 66899.0 |
2019-08-02 | 2001.0 | 3112.0 | 1797.0 | 551.0 | 46889.0 |
2019-08-03 | 818.0 | 3096.0 | 1117.0 | 459.0 | 45742.0 |
2019-08-04 | 1282.0 | 3279.0 | 1141.0 | 422.0 | 44869.0 |
2019-08-05 | 1253.0 | 3110.0 | 1230.0 | 488.0 | 49102.0 |
2019-08-06 | 1069.0 | 3107.0 | 1226.0 | 456.0 | 45270.0 |
2019-08-07 | 1349.0 | 3181.0 | 1459.0 | 453.0 | 50204.0 |
2019-08-08 | 1554.0 | 3138.0 | 1316.0 | 432.0 | 50587.0 |
2019-08-09 | 1039.0 | 3236.0 | 1241.0 | 484.0 | 49373.0 |
2019-08-10 | 1271.0 | 3584.0 | 1347.0 | 465.0 | 49176.0 |
2019-08-11 | 2031.0 | 3464.0 | 1380.0 | 525.0 | 49951.0 |
2019-08-12 | 1094.0 | 3325.0 | 1405.0 | 465.0 | 53112.0 |
2019-08-13 | 874.0 | 3407.0 | 1273.0 | 498.0 | 50593.0 |
2019-08-14 | 955.0 | 3136.0 | 1226.0 | 571.0 | 51949.0 |
2019-08-15 | 1094.0 | 3062.0 | 1371.0 | 618.0 | 48107.0 |
2019-08-16 | 1005.0 | 3374.0 | 1308.0 | 560.0 | 51285.0 |
2019-08-17 | 1629.0 | 3506.0 | 1639.0 | 594.0 | 49344.0 |
2019-08-18 | 1506.0 | 3152.0 | 1631.0 | 521.0 | 50439.0 |
2019-08-19 | 901.0 | 3331.0 | 1239.0 | 588.0 | 56112.0 |
2019-08-20 | 1538.0 | 3223.0 | 1597.0 | 612.0 | 62515.0 |
2019-08-21 | 1767.0 | 3302.0 | 1461.0 | 433.0 | 57943.0 |
2019-08-22 | 1250.0 | 3185.0 | 1362.0 | 507.0 | 46665.0 |
2019-08-23 | 1404.0 | 3086.0 | 1428.0 | 556.0 | 47525.0 |
2019-08-24 | 1142.0 | 2931.0 | 1330.0 | 449.0 | 45865.0 |
2019-08-25 | 1802.0 | 3215.0 | 1770.0 | 657.0 | 57749.0 |
2019-08-26 | 1626.0 | 3086.0 | 1748.0 | 566.0 | 58447.0 |
2019-08-27 | 1731.0 | 2872.0 | 1697.0 | 601.0 | 54594.0 |
2019-08-28 | 1278.0 | 3185.0 | 1427.0 | 653.0 | 49909.0 |
2019-08-29 | 1124.0 | 3273.0 | 1247.0 | 516.0 | 54358.0 |
2019-08-30 | 1206.0 | 3317.0 | 1136.0 | 554.0 | 46776.0 |
2019-08-31 | 1138.0 | 3119.0 | 1289.0 | 544.0 | 49414.0 |
link_events = hive.run("""
select
to_date(dt) as date,
event.action as action,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 7 and
event.feature like "link%"
group by
to_date(dt),
event.action
""").pivot_table(index="date", columns="action")
link_events.fillna(0)
events | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
action | clear | context-clear | context-delete | context-label | context-show | dialog-abort | dialog-convert | dialog-done | external-link-input | panel-switch | search-pages-choose | search-pages-input | show | window-open | window-open-from-command | window-open-from-context | window-open-from-sequence | window-open-from-tool |
date | ||||||||||||||||||
2019-07-01 | 677.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 213.0 | 6943.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-02 | 1130.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 210.0 | 7301.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-03 | 720.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 192.0 | 7017.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-04 | 774.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 198.0 | 7820.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-05 | 2313.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 166.0 | 6617.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-06 | 2064.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 110.0 | 6146.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-07 | 1361.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 137.0 | 7942.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-08 | 4319.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 166.0 | 6562.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-09 | 1063.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 198.0 | 7569.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-10 | 742.0 | 7.0 | 0.0 | 0.0 | 65.0 | 13.0 | 0.0 | 31.0 | 8.0 | 25.0 | 22.0 | 7.0 | 217.0 | 7943.0 | 0.0 | 29.0 | 0.0 | 16.0 |
2019-07-11 | 603.0 | 251.0 | 3.0 | 10.0 | 8866.0 | 321.0 | 3.0 | 1110.0 | 56.0 | 240.0 | 913.0 | 725.0 | 188.0 | 5857.0 | 99.0 | 112.0 | 33.0 | 1229.0 |
2019-07-12 | 3.0 | 1184.0 | 13.0 | 97.0 | 46162.0 | 1652.0 | 19.0 | 5001.0 | 405.0 | 1240.0 | 3981.0 | 3242.0 | 150.0 | 278.0 | 51.0 | 883.0 | 386.0 | 5596.0 |
2019-07-13 | 1.0 | 2207.0 | 21.0 | 47.0 | 47943.0 | 1620.0 | 10.0 | 5782.0 | 823.0 | 1677.0 | 4151.0 | 3489.0 | 153.0 | 4.0 | 149.0 | 487.0 | 371.0 | 6668.0 |
2019-07-14 | 0.0 | 832.0 | 30.0 | 89.0 | 55025.0 | 1878.0 | 10.0 | 6084.0 | 358.0 | 1253.0 | 4966.0 | 3950.0 | 133.0 | 1.0 | 87.0 | 1226.0 | 535.0 | 6477.0 |
2019-07-15 | 0.0 | 1105.0 | 29.0 | 91.0 | 44237.0 | 1634.0 | 12.0 | 5001.0 | 326.0 | 1102.0 | 3975.0 | 3303.0 | 204.0 | 1.0 | 70.0 | 582.0 | 465.0 | 5770.0 |
2019-07-16 | 0.0 | 1571.0 | 38.0 | 118.0 | 53534.0 | 1918.0 | 14.0 | 6375.0 | 827.0 | 1652.0 | 4796.0 | 3850.0 | 173.0 | 0.0 | 156.0 | 654.0 | 437.0 | 7305.0 |
2019-07-17 | 0.0 | 779.0 | 27.0 | 71.0 | 41620.0 | 1607.0 | 5.0 | 5084.0 | 812.0 | 1714.0 | 3710.0 | 2859.0 | 214.0 | 0.0 | 226.0 | 712.0 | 378.0 | 5634.0 |
2019-07-18 | 0.0 | 1358.0 | 22.0 | 93.0 | 45015.0 | 1796.0 | 7.0 | 5393.0 | 386.0 | 1207.0 | 4391.0 | 3314.0 | 208.0 | 0.0 | 106.0 | 580.0 | 402.0 | 6343.0 |
2019-07-19 | 0.0 | 1062.0 | 15.0 | 85.0 | 47188.0 | 1858.0 | 8.0 | 5721.0 | 306.0 | 1105.0 | 4734.0 | 3537.0 | 166.0 | 0.0 | 377.0 | 524.0 | 469.0 | 6445.0 |
2019-07-20 | 0.0 | 987.0 | 25.0 | 91.0 | 50089.0 | 1730.0 | 5.0 | 5682.0 | 257.0 | 983.0 | 4769.0 | 3878.0 | 128.0 | 0.0 | 67.0 | 711.0 | 533.0 | 6342.0 |
2019-07-21 | 0.0 | 859.0 | 29.0 | 74.0 | 48378.0 | 1798.0 | 7.0 | 5461.0 | 405.0 | 1238.0 | 4452.0 | 3559.0 | 168.0 | 0.0 | 63.0 | 544.0 | 374.0 | 6560.0 |
2019-07-22 | 0.0 | 1306.0 | 18.0 | 101.0 | 47572.0 | 1691.0 | 5.0 | 5246.0 | 330.0 | 1200.0 | 4240.0 | 3484.0 | 203.0 | 0.0 | 66.0 | 1056.0 | 336.0 | 5721.0 |
2019-07-23 | 0.0 | 1404.0 | 46.0 | 87.0 | 53679.0 | 1628.0 | 8.0 | 5703.0 | 329.0 | 1219.0 | 4513.0 | 3748.0 | 222.0 | 0.0 | 224.0 | 1000.0 | 481.0 | 5941.0 |
2019-07-24 | 0.0 | 905.0 | 27.0 | 89.0 | 44663.0 | 1679.0 | 10.0 | 5618.0 | 341.0 | 1171.0 | 4580.0 | 3352.0 | 182.0 | 0.0 | 273.0 | 712.0 | 399.0 | 6160.0 |
2019-07-25 | 0.0 | 851.0 | 25.0 | 102.0 | 48511.0 | 1626.0 | 13.0 | 5626.0 | 350.0 | 1181.0 | 4617.0 | 3426.0 | 177.0 | 0.0 | 119.0 | 720.0 | 348.0 | 6321.0 |
2019-07-26 | 0.0 | 947.0 | 14.0 | 54.0 | 46103.0 | 1864.0 | 9.0 | 5472.0 | 372.0 | 1173.0 | 4459.0 | 3622.0 | 175.0 | 0.0 | 62.0 | 799.0 | 409.0 | 6390.0 |
2019-07-27 | 0.0 | 1094.0 | 34.0 | 48.0 | 46628.0 | 1689.0 | 8.0 | 5847.0 | 351.0 | 1126.0 | 4875.0 | 3775.0 | 160.0 | 0.0 | 147.0 | 576.0 | 308.0 | 6787.0 |
2019-07-28 | 0.0 | 1108.0 | 23.0 | 164.0 | 46689.0 | 1749.0 | 5.0 | 5567.0 | 327.0 | 1079.0 | 4601.0 | 3564.0 | 152.0 | 0.0 | 174.0 | 723.0 | 403.0 | 6273.0 |
2019-07-29 | 0.0 | 535.0 | 15.0 | 80.0 | 28606.0 | 1071.0 | 7.0 | 3712.0 | 242.0 | 746.0 | 2994.0 | 2290.0 | 130.0 | 0.0 | 68.0 | 429.0 | 242.0 | 4219.0 |
citoid_events = hive.run("""
select
to_date(dt) as date,
event.action as action,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 7 and
event.feature = "citoid"
group by
to_date(dt),
event.action
""").pivot_table(index="date", columns="action")
citoid_events.fillna(0)
events | |||||||
---|---|---|---|---|---|---|---|
action | automatic-generate | automatic-insert | dialog-abort | manual-choose | panel-switch | reuse-choose | window-open |
date | |||||||
2019-07-01 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2168.0 |
2019-07-02 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2246.0 |
2019-07-03 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2191.0 |
2019-07-04 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2253.0 |
2019-07-05 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2106.0 |
2019-07-06 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1866.0 |
2019-07-07 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2288.0 |
2019-07-08 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2074.0 |
2019-07-09 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2206.0 |
2019-07-10 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2354.0 |
2019-07-11 | 225.0 | 170.0 | 423.0 | 55.0 | 293.0 | 40.0 | 1727.0 |
2019-07-12 | 801.0 | 631.0 | 1763.0 | 331.0 | 1336.0 | 90.0 | 105.0 |
2019-07-13 | 786.0 | 662.0 | 1917.0 | 407.0 | 1434.0 | 112.0 | 0.0 |
2019-07-14 | 726.0 | 606.0 | 1889.0 | 368.0 | 1421.0 | 116.0 | 0.0 |
2019-07-15 | 782.0 | 645.0 | 1993.0 | 510.0 | 1436.0 | 105.0 | 0.0 |
2019-07-16 | 954.0 | 812.0 | 2100.0 | 380.0 | 1660.0 | 165.0 | 0.0 |
2019-07-17 | 873.0 | 728.0 | 1967.0 | 320.0 | 1501.0 | 132.0 | 0.0 |
2019-07-18 | 988.0 | 850.0 | 2194.0 | 464.0 | 1692.0 | 118.0 | 0.0 |
2019-07-19 | 762.0 | 638.0 | 1882.0 | 389.0 | 1439.0 | 147.0 | 0.0 |
2019-07-20 | 715.0 | 615.0 | 1691.0 | 332.0 | 1230.0 | 80.0 | 0.0 |
2019-07-21 | 932.0 | 795.0 | 2101.0 | 427.0 | 1585.0 | 104.0 | 0.0 |
2019-07-22 | 1044.0 | 859.0 | 2091.0 | 343.0 | 1730.0 | 136.0 | 0.0 |
2019-07-23 | 951.0 | 807.0 | 2096.0 | 394.0 | 1572.0 | 155.0 | 0.0 |
2019-07-24 | 992.0 | 872.0 | 2115.0 | 378.0 | 1564.0 | 144.0 | 0.0 |
2019-07-25 | 811.0 | 681.0 | 1912.0 | 416.0 | 1401.0 | 147.0 | 0.0 |
2019-07-26 | 945.0 | 776.0 | 1975.0 | 382.0 | 1528.0 | 135.0 | 0.0 |
2019-07-27 | 811.0 | 722.0 | 1919.0 | 372.0 | 1517.0 | 123.0 | 0.0 |
2019-07-28 | 786.0 | 683.0 | 1997.0 | 495.0 | 1586.0 | 138.0 | 0.0 |
2019-07-29 | 591.0 | 484.0 | 1369.0 | 321.0 | 1004.0 | 73.0 | 0.0 |
_57.sum(axis=1)
date 2019-07-01 2168.0 2019-07-02 2246.0 2019-07-03 2191.0 2019-07-04 2253.0 2019-07-05 2106.0 2019-07-06 1866.0 2019-07-07 2288.0 2019-07-08 2074.0 2019-07-09 2206.0 2019-07-10 2354.0 2019-07-11 2933.0 2019-07-12 5057.0 2019-07-13 5318.0 2019-07-14 5126.0 2019-07-15 5471.0 2019-07-16 6071.0 2019-07-17 5521.0 2019-07-18 6306.0 2019-07-19 5257.0 2019-07-20 4663.0 2019-07-21 5944.0 2019-07-22 6203.0 2019-07-23 5975.0 2019-07-24 6065.0 2019-07-25 5368.0 2019-07-26 5741.0 2019-07-27 5464.0 2019-07-28 5685.0 2019-07-29 3842.0 dtype: float64
cite_events = hive.run("""
select
to_date(dt) as date,
event.action as action,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 7 and
event.feature = "cite"
group by
to_date(dt),
event.action
""").pivot_table(index="date", columns="action")
cite_events.fillna(0)
events | ||
---|---|---|
action | manual-template-input | window-open |
date | ||
2019-07-01 | 0.0 | 539.0 |
2019-07-02 | 0.0 | 723.0 |
2019-07-03 | 0.0 | 459.0 |
2019-07-04 | 0.0 | 500.0 |
2019-07-05 | 0.0 | 578.0 |
2019-07-06 | 0.0 | 443.0 |
2019-07-07 | 0.0 | 580.0 |
2019-07-08 | 0.0 | 529.0 |
2019-07-09 | 0.0 | 436.0 |
2019-07-10 | 0.0 | 574.0 |
2019-07-11 | 0.0 | 480.0 |
2019-07-12 | 0.0 | 44.0 |
2019-07-25 | 192.0 | 0.0 |
2019-07-26 | 324.0 | 0.0 |
2019-07-27 | 276.0 | 0.0 |
2019-07-28 | 431.0 | 0.0 |
2019-07-29 | 240.0 | 0.0 |
reference_events = hive.run("""
select
to_date(dt) as date,
event.action as action,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 7 and
event.feature = "reference"
group by
to_date(dt),
event.action
""").pivot_table(index="date", columns="action")
reference_events.fillna(0)
events | |||||||||
---|---|---|---|---|---|---|---|---|---|
action | context-delete | context-show | input | reuse-choose | window-open | window-open-from-command | window-open-from-context | window-open-from-sequence | window-open-from-tool |
date | |||||||||
2019-07-01 | 0.0 | 0.0 | 0.0 | 0.0 | 197.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-02 | 0.0 | 0.0 | 0.0 | 0.0 | 277.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-03 | 0.0 | 0.0 | 0.0 | 0.0 | 272.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-04 | 0.0 | 0.0 | 0.0 | 0.0 | 305.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-05 | 0.0 | 0.0 | 0.0 | 0.0 | 278.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-06 | 0.0 | 0.0 | 0.0 | 0.0 | 255.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-07 | 0.0 | 0.0 | 0.0 | 0.0 | 233.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-08 | 0.0 | 0.0 | 0.0 | 0.0 | 277.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-09 | 0.0 | 0.0 | 0.0 | 0.0 | 281.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-10 | 0.0 | 0.0 | 0.0 | 0.0 | 289.0 | 0.0 | 0.0 | 0.0 | 0.0 |
2019-07-11 | 16.0 | 140.0 | 15.0 | 0.0 | 273.0 | 16.0 | 9.0 | 0.0 | 16.0 |
2019-07-12 | 157.0 | 836.0 | 154.0 | 1.0 | 2.0 | 90.0 | 111.0 | 0.0 | 43.0 |
2019-07-13 | 425.0 | 1279.0 | 156.0 | 0.0 | 0.0 | 104.0 | 102.0 | 0.0 | 42.0 |
2019-07-14 | 117.0 | 913.0 | 198.0 | 4.0 | 0.0 | 92.0 | 118.0 | 3.0 | 85.0 |
2019-07-15 | 206.0 | 1138.0 | 250.0 | 2.0 | 0.0 | 175.0 | 130.0 | 0.0 | 55.0 |
2019-07-16 | 441.0 | 1089.0 | 153.0 | 4.0 | 0.0 | 96.0 | 117.0 | 0.0 | 47.0 |
2019-07-17 | 190.0 | 976.0 | 214.0 | 2.0 | 0.0 | 88.0 | 154.0 | 0.0 | 67.0 |
2019-07-18 | 161.0 | 1126.0 | 217.0 | 7.0 | 0.0 | 106.0 | 133.0 | 0.0 | 84.0 |
2019-07-19 | 107.0 | 802.0 | 153.0 | 11.0 | 0.0 | 91.0 | 80.0 | 2.0 | 68.0 |
2019-07-20 | 157.0 | 1312.0 | 228.0 | 1.0 | 0.0 | 120.0 | 219.0 | 0.0 | 43.0 |
2019-07-21 | 105.0 | 1031.0 | 206.0 | 1.0 | 0.0 | 126.0 | 143.0 | 0.0 | 38.0 |
2019-07-22 | 145.0 | 1259.0 | 208.0 | 1.0 | 0.0 | 141.0 | 138.0 | 0.0 | 49.0 |
2019-07-23 | 141.0 | 895.0 | 173.0 | 4.0 | 0.0 | 93.0 | 105.0 | 0.0 | 53.0 |
2019-07-24 | 68.0 | 851.0 | 137.0 | 17.0 | 0.0 | 104.0 | 99.0 | 0.0 | 41.0 |
2019-07-25 | 87.0 | 776.0 | 162.0 | 3.0 | 0.0 | 122.0 | 102.0 | 0.0 | 38.0 |
2019-07-26 | 100.0 | 853.0 | 148.0 | 3.0 | 0.0 | 101.0 | 78.0 | 0.0 | 45.0 |
2019-07-27 | 101.0 | 926.0 | 171.0 | 1.0 | 0.0 | 127.0 | 102.0 | 0.0 | 29.0 |
2019-07-28 | 135.0 | 970.0 | 164.0 | 4.0 | 0.0 | 126.0 | 84.0 | 0.0 | 55.0 |
2019-07-29 | 73.0 | 619.0 | 153.0 | 0.0 | 0.0 | 109.0 | 77.0 | 0.0 | 25.0 |
_55.sum(axis=1)
date 2019-07-01 197.0 2019-07-02 277.0 2019-07-03 272.0 2019-07-04 305.0 2019-07-05 278.0 2019-07-06 255.0 2019-07-07 233.0 2019-07-08 277.0 2019-07-09 281.0 2019-07-10 289.0 2019-07-11 485.0 2019-07-12 1394.0 2019-07-13 2108.0 2019-07-14 1530.0 2019-07-15 1956.0 2019-07-16 1947.0 2019-07-17 1691.0 2019-07-18 1834.0 2019-07-19 1314.0 2019-07-20 2080.0 2019-07-21 1650.0 2019-07-22 1941.0 2019-07-23 1464.0 2019-07-24 1317.0 2019-07-25 1290.0 2019-07-26 1328.0 2019-07-27 1457.0 2019-07-28 1538.0 2019-07-29 1056.0 dtype: float64
context_item_closes = hive.run("""
select
to_date(dt) as date,
event.action as action,
event.feature as feature,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and ((month = 7 and day > 24) or month = 8) and
event.action like "context-close%"
group by
to_date(dt),
event.action,
event.feature
""")
context_item_closes = (
context_item_closes
.pivot_table(index="date", columns= ["action", "feature"])
)
context_item_closes.head()
events | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
action | context-close | ||||||||||||||||||||
feature | cite-Literatur | cite-Webseite | cite-any | cite-book | cite-journal | cite-news | cite-online-book | cite-online-news | cite-web | cite-מאמר | ... | link/mwNumberedExternal | math | mergeCells | mwGallery | mwLanguageVariant | mwMedia | reference | referencesList | transclusion | undefined |
date | |||||||||||||||||||||
2019-07-31 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | 2.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
2019-08-01 | NaN | NaN | NaN | 1.0 | 1.0 | 4.0 | NaN | NaN | 11.0 | NaN | ... | 7.0 | NaN | 9.0 | NaN | NaN | 2.0 | 7.0 | 3.0 | 216.0 | NaN |
2019-08-02 | NaN | 6.0 | 1.0 | 16.0 | 3.0 | 15.0 | NaN | 1.0 | 110.0 | NaN | ... | 19.0 | NaN | 102.0 | 10.0 | NaN | 45.0 | 77.0 | 49.0 | 1628.0 | NaN |
2019-08-03 | NaN | 10.0 | NaN | 10.0 | 6.0 | 16.0 | NaN | NaN | 100.0 | NaN | ... | 7.0 | NaN | 109.0 | 21.0 | NaN | 53.0 | 60.0 | 48.0 | 1653.0 | NaN |
2019-08-04 | NaN | 2.0 | NaN | 27.0 | 9.0 | 22.0 | NaN | NaN | 115.0 | NaN | ... | 9.0 | NaN | 91.0 | 12.0 | NaN | 71.0 | 75.0 | 42.0 | 1610.0 | NaN |
5 rows × 25 columns
context_item_closes.sum(axis = 1)
date 2019-07-31 2.0 2019-08-01 390.0 2019-08-02 3112.0 2019-08-03 3096.0 2019-08-04 3279.0 2019-08-05 3110.0 2019-08-06 3107.0 2019-08-07 3181.0 2019-08-08 3138.0 2019-08-09 3236.0 2019-08-10 3584.0 2019-08-11 3464.0 2019-08-12 3325.0 2019-08-13 3407.0 2019-08-14 3136.0 2019-08-15 3062.0 2019-08-16 3374.0 2019-08-17 3506.0 2019-08-18 3152.0 2019-08-19 3331.0 2019-08-20 3223.0 2019-08-21 1873.0 dtype: float64
Events start recording at the end of July as expected and then increase to about 3000 events per day
context_item_closes.sum(axis = 0).sort_values(ascending = False)
action feature events context-close transclusion 32470.0 link/internal 19600.0 mergeCells 2794.0 cite-web 2154.0 reference 1566.0 mwMedia 1215.0 link 1156.0 referencesList 1068.0 comment 395.0 link/mwNumberedExternal 343.0 cite-book 301.0 cite-news 282.0 cite-journal 239.0 mwGallery 217.0 cite-Webseite 110.0 language 76.0 cite-any 43.0 math 18.0 cite-Literatur 10.0 mwLanguageVariant 8.0 undefined 8.0 link/mwMagic 7.0 cite-online-book 5.0 cite-online-news 2.0 cite-מאמר 1.0 dtype: float64
Additional Instrumentation Event logged when a contributor types text into the "Text" field within "Wikipedia" or "External site" panel/tab.
Deploy Date September 3, 2019
How events are logged:
label_input_events = hive.run("""
select
to_date(dt) as date,
event.action as action,
event.feature as feature,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and month = 9 and
event.action like "label-input%"
group by
to_date(dt),
event.action,
event.feature
""")
label_input_events = (
label_input_events
.pivot_table(index="date", columns= ["action", "feature"])
)
label_input_events.head(20)
events | |
---|---|
action | label-input |
feature | link |
date | |
2019-09-11 | 20 |
2019-09-12 | 45 |
2019-09-13 | 36 |
2019-09-14 | 48 |
2019-09-15 | 35 |
2019-09-16 | 278 |
2019-09-17 | 628 |
2019-09-18 | 584 |
2019-09-19 | 532 |
2019-09-20 | 603 |
2019-09-21 | 669 |
2019-09-22 | 648 |
2019-09-23 | 357 |
Events started appearing around September 11th. All events are recorded for links as expected. Starting on September 16th, the number of events increases to 278.
label_input_events.sum(axis = 0).sort_values(ascending = False)
action feature events label-input link 4483 dtype: int64
As of September 23rd, a total of 4483 label-input events have been logged since deployment date.
label_input_events_by_platform = hive.run("""
select
to_date(eas.dt) as date,
eas.event.platform,
vefu.event.action as action,
count(*) as events
from event.visualeditorfeatureuse vefu
inner join event.editattemptstep eas
on
vefu.event.editingsessionid = eas.event.editing_session_id and
vefu.event.action like "label-input%" and
vefu.year = 2019 and vefu.month = 9 and
eas.year = 2019 and eas.month = 9
group by
to_date(eas.dt),
eas.event.platform,
vefu.event.action
""")
label_input_events_by_platform.head()
date | platform | action | events | |
---|---|---|---|---|
0 | 2019-09-11 | phone | label-input | 43 |
1 | 2019-09-12 | phone | label-input | 157 |
2 | 2019-09-13 | phone | label-input | 89 |
3 | 2019-09-14 | phone | label-input | 124 |
4 | 2019-09-15 | phone | label-input | 121 |
Confirmed events are recorded only for mobile for this feature.
label_input_events_by_wiki = hive.run("""
select
wiki,
count(*) as events
from event.visualeditorfeatureuse
where
year = 2019 and ((month = 8 and day > 24) or month = 9) and
event.action like "label-input%"
group by
wiki
ORDER BY events DESC LIMIT 50
""")
# Top 10 wikis with label input events recorded.
label_input_events_by_wiki.head(10)
wiki | events | |
---|---|---|
0 | enwiki | 1368 |
1 | eswiki | 326 |
2 | ptwiki | 246 |
3 | fawiki | 211 |
4 | commonswiki | 188 |
5 | arwiki | 156 |
6 | itwiki | 150 |
7 | frwiki | 140 |
8 | idwiki | 137 |
9 | jawiki | 120 |