Introd u ction to dates W OR K IN G W ITH DATE S AN D TIME S IN - PowerPoint PPT Presentation

Introd u ction to dates W OR K IN G W ITH DATE S AN D TIME S IN R Charlo � e Wickham Instr u ctor

Dates Di � erent con v entions in di � erent places 27 th Feb 2013 NZ : 27/2/2013 USA : 2/27/2013 WORKING WITH DATES AND TIMES IN R

The global standard n u meric date format 1 h � ps ://x kcd . com /1179/ WORKING WITH DATES AND TIMES IN R

ISO 8601 YYYY - MM - DD Val u es ordered from the largest to smallest u nit of time Each has a �x ed n u mber of digits , m u st be padded w ith leading z eros Either , no separators for comp u ters , or - in dates 1 st of Jan u ar y 2011 -> 2011-01-01 WORKING WITH DATES AND TIMES IN R

Dates in R 2003-02-27 as.Date("2003-02-27") 1974 "2003-02-27" "2003-02-27" str(as.Date("2003-02-27")) "2003-02-27" Date[1:1], format: "2003-02-27" str("2003-02-27") Packages that import dates : readr , anytime chr "2003-02-27" WORKING WITH DATES AND TIMES IN R

Let ' s practice ! W OR K IN G W ITH DATE S AN D TIME S IN R

Wh y u se dates ? W OR K IN G W ITH DATE S AN D TIME S IN R Charlo � e Wickham Instr u ctor

Dates act like n u mbers Date objects are stored as da y s since 1970-01-01 as.Date("2003-02-27") > as.Date("2002-02-27") TRUE as.Date("2003-02-27") + 1 "2003-02-28" as.Date("2003-02-27") - as.Date("2002-02-27") Time difference of 365 days WORKING WITH DATES AND TIMES IN R

Plotting w ith dates x <- c(as.Date("2003-02-27"), as.Date("2003-03-27"), as.Date("2003-04-27")) plot(x, 1:3) WORKING WITH DATES AND TIMES IN R

Plotting w ith dates x <- c(as.Date("2003-02-27"), as.Date("2003-03-27"), as.Date("2003-04-27")) library(ggplot2) ggplot() + geom_point(aes(x = x, y = 1:3)) WORKING WITH DATES AND TIMES IN R

R releases releases # A tibble: 105 x 7 major minor patch date datetime time type <int> <int> <int> <date> <dttm> <time> <chr> 1 0 60 NA 1997-12-04 1997-12-04 08:47:58 08:47:58 patch 2 0 61 NA 1997-12-21 1997-12-21 13:09:22 13:09:22 minor 3 0 61 1 1998-01-10 1998-01-10 00:31:55 00:31:55 patch 4 0 61 2 1998-03-14 1998-03-14 19:25:55 19:25:55 patch 5 0 61 3 1998-05-02 1998-05-02 07:58:17 07:58:17 patch 6 0 62 NA 1998-06-14 1998-06-14 12:56:20 12:56:20 minor 7 0 62 1 1998-06-14 1998-06-14 22:13:25 22:13:25 patch 8 0 62 2 1998-07-10 1998-07-10 11:13:45 11:13:45 patch 9 0 62 3 1998-08-28 1998-08-28 09:02:19 09:02:19 patch 10 0 62 4 1998-10-23 1998-10-23 12:08:41 12:08:41 patch # ... with 95 more rows WORKING WITH DATES AND TIMES IN R

What abo u t times ? W OR K IN G W ITH DATE S AN D TIME S IN R Charlo � e Wickham Instr u ctor

ISO 8601 HH : MM : SS Largest u nit to smallest Fi x ed digits Ho u rs : 00 -- 24 Min u tes : 00 -- 59 Seconds : 00 -- 60 (60 onl y for leap seconds ) No separator or : WORKING WITH DATES AND TIMES IN R

Datetimes in R T w o objects t y pes : POSIXlt - list w ith named components POSIXct - seconds since 1970-01-01 00:00:00 POSIXct w ill go in a data frame as.POSIXct() t u rns a string into a POSIXct object x <- as.POSIXct("1970-01-01 00:01:00") str(x) POSIXct[1:1], format: "1970-01-01 00:01:00 WORKING WITH DATES AND TIMES IN R

Time z ones "2013-02-27T18:00:00" - 6 pm local time "2013-02-27T18:00:00Z" - 6 pm UTC "2013-02-27T18:00:00-08:00" - 6 pm in Oregon as.POSIXct("2013-02-27T18:00:00Z") "2013-02-27 PST" as.POSIXct("2013-02-27T18:00:00Z", tz = "UTC") "2013-02-27 UTC" WORKING WITH DATES AND TIMES IN R

Datetimes beha v e nicel y too Once a POSIXct object , datetimes can be : Compared S u btracted Plo � ed WORKING WITH DATES AND TIMES IN R

Wh y l u bridate ? W OR K IN G W ITH DATE S AN D TIME S IN R Charlo � e Wickham Instr u ctor

l u bridate Make w orking w ith dates and times in R eas y! tidyverse package Pla y s nicel y w ith b u iltin datetime objects Designed for h u mans not comp u ters Pla y s nicel y w ith other tidyverse packages Consistent beha v io u r regardless of u nderl y ing object WORKING WITH DATES AND TIMES IN R

Parsing a w ide range of formats ymd("2013-02-27") "2013-02-27" dmy("27/2/13") "2013-02-27" parse_date_time(c("Feb 27th, 2017", "27th Feb 2017"), + order = c("mdy", "dmy")) "2017-02-27 UTC" "2017-02-27 UTC" WORKING WITH DATES AND TIMES IN R

Manip u lating datetimes # Extract components akl_daily <- akl_daily %>% mutate( year = year(date), yday = yday(date), month = month(date, label = TRUE) ) WORKING WITH DATES AND TIMES IN R

Time spans # A tibble: 131 x 3 name period <chr> <S4: Period> 1 Elizabeth II 65y 7m 27d 0H 0M 0S 2 Victoria 63y 7m 2d 0H 0M 0S 3 George V 25y 8m 14d 0H 0M 0S 4 George III 19y 0m 28d 0H 0M 0S 5 George VI 15y 1m 26d 0H 0M 0S WORKING WITH DATES AND TIMES IN R

Other l u bridate feat u res Handling time z ones Fast parsing of standard formats O u tp u � ing datetimes WORKING WITH DATES AND TIMES IN R

Introd u ction to dates W OR K IN G W ITH DATE S AN D TIME S IN - PowerPoint PPT Presentation

Introd u ction to dates W OR K IN G W ITH DATE S AN D TIME S IN R Charlo e Wickham Instr u ctor Dates Di erent con v entions in di erent places 27 th Feb 2013 NZ : 27/2/2013 USA : 2/27/2013 WORKING WITH DATES AND TIMES IN R The

Introd u ction to Te x t Encoding FE ATU R E E N G IN E E R IN G FOR MAC H IN E L E AR N IN G

Introd u ction to statistical seismolog y C ASE STU D IE S IN STATISTIC AL TH IN K IN G J u

Introd u ction to P y D u b SP OK E N L AN G U AG E P R OC E SSIN G IN P YTH ON Daniel Bo u

Introd u ction to a u dio data in P y thon SP OK E N L AN G U AG E P R OC E SSIN G IN P YTH ON

Introd u ction to Net w orks IN TR OD U C TION TO N E TW OR K AN ALYSIS IN P YTH ON Eric Ma

Introd u ction to iterators P YTH ON DATA SC IE N C E TOOL BOX ( PAR T 2 ) H u go Bo w ne -

Introd u ction to s w imming data C ASE STU D IE S IN STATISTIC AL TH IN K IN G J u stin Bois

Welcome and Introd u ction SU P E R VISE D L E AR N IN G IN R : R E G R E SSION Nina Z u mel and

Introd u ction : Working With Web Data in R W OR K IN G W ITH W E B DATA IN R Oli v er Ke y

Introd u ction to APIs and JSONs IN TE R ME D IATE IMP OR TIN G DATA IN P YTH ON H u go Bo w

Introd u ction to the dataset W OR K IN G W ITH G E OSPATIAL DATA IN P YTH ON Joris Van den

Introd u ction IN TE R ME D IATE IN TE R AC TIVE DATA VISU AL IZATION W ITH P L OTLY IN R

Introd u ction to Teacher Forcing MAC H IN E TR AN SL ATION IN P YTH ON Th u shan Ganegedara

Introd u ction VISU AL IZIN G G E OSPATIAL DATA IN P YTH ON Mar y v an Valkenb u rg Data

Introd u ction to databases STR E AML IN E D DATA IN G E STION W ITH PAN DAS Aman y Mahfo uz

Introd u ction to EFA FAC TOR AN ALYSIS IN R Jennifer Br u sso w Ps y chometrician Ps y cho +

Taking differences of datetimes W OR K IN G W ITH DATE S AN D TIME S IN R Charlo e

Loop Quantum Gravity : state of the art Karim NOUI Laboratoire de Math ematiques et de

Alex Suciu Northeastern University Conference on Experimental and Theoretical Methods in

Efficient Geometric Operations on Polyhedra Willem Hagemann Max Planck Institute for Informatics

3. Lattice QCD Or: Using Large Computers for Fun References: [(Path Integral: Ryd 5; Sakurai:

Gods Character Set the table What is Law? What is Law? A system of principles

Count-based Language Modeling CMSC 473/673 UMBC Some slides adapted from 3SLP, Jason Eisner

Principles of Parallel Algorithm Design Ananth Grama, Anshul Gupta, George Karypis, and Vipin