search for: current_loc

or in base R : ?xtabs ?? as in: xtabs(~previous_location + current_location,data=x) (You can convert the 0s to NA's if you like) Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Tue, May 8, 2...

...t moved from Boston to all the other 24 cities. I would like all the combinations if possible. Thank you again! Sincerely, Milu On Tue, May 8, 2018 at 6:28 PM, Bert Gunter <bgunter.4567 at gmail.com> wrote: > or in base R : ?xtabs ?? > > as in: > xtabs(~previous_location + current_location,data=x) > > (You can convert the 0s to NA's if you like) > > > Cheers, > Bert > > > > Bert Gunter > > "The trouble with having an open mind is that people keep coming along and > sticking things into it." > -- Opus (aka Berkeley Breathed...

...e to measure the flow. Ultimately I would like to compute the probability of movement between cities (movement to city_i/total movement from city_j). Is it possible to aggregate the data in this way? Any guidance would be highly appreciated. Thank you! # Original data structure(list(id = 101:115, current_location = structure(c(2L, 8L, 8L, 3L, 6L, 5L, 1L, 2L, 7L, 4L, 2L, 8L, 8L, 3L, 6L), .Label = c("Austin", "Boston", "Cambridge", "Durham", "Houston", "Lynn", "New Orleans", "New York"), class = "factor"), previous_...

Dear Miluji, If I understand correctly, this should get you what you need. temp1 <- structure(list(id = 101:115, current_location = structure(c(2L, 8L, 8L, 3L, 6L, 5L, 1L, 2L, 7L, 4L, 2L, 8L, 8L, 3L, 6L), .Label = c("Austin", "Boston", "Cambridge", "Durham", "Houston", "Lynn", "New Orleans", "New York"), class = "factor"), previous_...

...all the combinations if possible. > > Thank you again! > > Sincerely, > > Milu > > On Tue, May 8, 2018 at 6:28 PM, Bert Gunter <bgunter.4567 at gmail.com> > wrote: > >> or in base R : ?xtabs ?? >> >> as in: >> xtabs(~previous_location + current_location,data=x) >> >> (You can convert the 0s to NA's if you like) >> >> >> Cheers, >> Bert >> >> >> >> Bert Gunter >> >> "The trouble with having an open mind is that people keep coming along >> and sticking things...

...c(3L, 9L, 8L, 10L, 2L, 5L, 1L, 7L, 4L, 6L, 10L, 5L), .Label = c("Atlanta", "Austin", "Boston", "Cambridge", "Dallas", "Durham", "Lynn", "New Orleans", "New York", "OKC"), class = "factor"), current_location. = structure(c(8L, 3L, 3L, 8L, 4L, 1L, 4L, 5L, 6L, 4L, 7L, 2L), .Label = c("Atlanta", "Austin", "Boston", "Cambridge", "Durham", "Lynn", "New Orleans", "New York"), class = "factor")), class = "data....