Places/Stats: Difference between revisions
< Places
Jump to navigation
Jump to search
m (→Code) |
m (→Code) |
||
Line 33: | Line 33: | ||
places$bookmark_tagged_pct = (places$bookmark_cnt - places$bookmark_nontag_cnt )/ places$bookmark_cnt | places$bookmark_tagged_pct = (places$bookmark_cnt - places$bookmark_nontag_cnt )/ places$bookmark_cnt | ||
places$folder_cnt_crrctd = places$folder_cnt - places$bookmark_cnt | places$folder_cnt_crrctd = places$folder_cnt - places$bookmark_cnt | ||
places$user_of_tags <- ifelse(places$tag_cnt > 0, c("1"), c("0")) | |||
Other Derived Values | Other Derived Values |
Revision as of 18:02, 14 June 2009
Context
Analysis
Goals:
- Insights into usage of bookmarks history
- Define characteristics for test places databases
- 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 places$user_of_tags <- ifelse(places$tag_cnt > 0, c("1"), c("0"))
Other Derived Values
places$percent_visits_new = places$places_visited_unique_cnt / places$moz_historyvisits_cnt places$pages_per_day = places$moz_historyvisits_cnt / as.numeric(places$time_delta)
Subsets
taggers <- places[places$tag_cnt > 0,] livemarkers <- places[places$livemark_container_cnt > 0,] bookmarkers <- places[places$bookmark_cnt>20,]