Skip to content

Indicators

Alex Simoes edited this page Dec 26, 2016 · 1 revision

indicators.tsv

Column Descriptions

Column ID Description
curid Person ID
dt Month Date/Timestamp (YYYY-MM-DD) from 2007-01-01 to 2015-12-01
pv_en Number of english pageviews
l Number of page editions
l_nw
l_mw
r
r_mr
c
c_n
s
s_n

Sample Rows

(first 5 rows)

curid dt pv_en l l_nw l_mw r r_mr c c_n s s_n
6226 2014-09-01 13914.0 62.0 0.218309859155 2.56020119933 7.0 4.33382862803e-05 21.6015525244 0.892005172262 729.440520566 0.00214079324351
6226 2014-08-01 8728.0 62.0 0.218309859155 2.57945082323 21.4504561119 0.892425752845 733.380839531 0.00200539818882
6226 2014-05-01 12973.0 62.0 0.218309859155 2.63277131965 4.0 2.30764349216e-05 21.039585488 0.89342608468 748.262864463 0.00168134288416
6226 2014-04-01 13103.0 62.0 0.218309859155 2.6522867458 7.0 4.26626360633e-05 20.9004746065 0.894097609353 756.053697002 0.00167497189791
6226 2014-07-01 9448.0 62.0 0.218309859155 2.59763341253 21.3073227101 0.892719571021 736.435363449 0.00199339954015

(last 5 rows)

curid dt pv_en l l_nw l_mw r r_mr c c_n s s_n
286847 2015-06-01 2.0 1.078958158e-05
286847 2015-08-01 5.0 2.55339141448e-05
286847 2015-09-01 8.0 4.47650116669e-05
286847 2015-10-01 2.0 1.13642820615e-05
286847 2015-11-01 5.0 2.98386326745e-05

Pandas import

pd.read_csv("raw/indicators.tsv", sep="\t", na_values="null", true_values="true", false_values="false", parse_dates=[1])
Clone this wiki locally