Places/Stats: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
mNo edit summary
Line 12: Line 12:


==== Toolset ====
==== Toolset ====
* R
* [http://www.r-project.org/ R]
* GGobi
* [http://www.ggobi.org/rggobi/ GGobi]


==== Code ====
==== Code ====

Revision as of 18:51, 13 June 2009

Context

See Places-Stats.mozilla


Analysis

Goals:

  • Insights into usage of bookmarks history
  • Use open source tools to create and iterate on reproducible analysis of the places stats data set
  • [Andyed] Investigate potential to gather updated stats for metrics tracked in historical research (% usage of bookmarks, % new urls visited, etc.)

Toolset

Code

See the Etherpad Page for the scratchpad

Load Data (save https://places-stats.mozilla.com/stats?format=csv locally)

places <- read.csv("...places.csv")

Compute age metrics

places$oldest_stamp = as.POSIXct(strptime(as.character(places$visit_date_oldest),format="%m/%d/%y %H:%M"))
places$newest_stamp = as.POSIXct(strptime(as.character(places$visit_date_newest),format="%m/%d/%y %H:%M"))
places$time_delta = difftime(places$newest_stamp,places$oldest_stamp, units="days")

Tags & Bookmark Metrics

places$bookmark_tagged_pct = (places$bookmark_cnt - places$bookmark_nontag_cnt )/ places$bookmark_cnt
places$folder_cnt_crrctd = places$folder_cnt - places$bookmark_cnt