Displaying 6 results from an estimated 6 matches for "current_local".
Did you mean:
current_locale
2018 May 08
3
Bilateral matrix
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, 2018 at 9:21 AM, Huzefa
2018 May 16
0
Bilateral matrix
Dear Bert and Huzefa,
Apologies for the late reply, my account got hacked and I have just managed
to recover it.
Thank you very much for your replies and the solutions. Both work well.
I was wondering if there was any way to ensure (force) that all possible
combinations show up in the output. The full dataset has 25 cities but of
course people have not moved from Boston to all the other 24
2018 May 08
2
Bilateral matrix
I have data on current and previous location of individuals. I would like
to have a matrix with bilateral movement between locations. I would like
the final output to look like the second table below.
I have tried using crosstab() from the ecodist but I do not have another
variable to measure the flow. Ultimately I would like to compute the
probability of movement between cities (movement to
2018 May 08
0
Bilateral matrix
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 =
2018 May 16
2
Bilateral matrix
xtabs does this automatically if your cross classifying variables are
factors with levels all the cities (sorted, if you like):
> x <- sample(letters[1:5],8, rep=TRUE)
> y <- sample(letters[1:5],8,rep=TRUE)
> xtabs(~ x + y)
y
x c d e
a 1 0 0
b 0 0 1
c 1 0 0
d 1 1 1
e 1 1 0
> lvls <- sort(union(x,y))
> x <- factor(x, levels = lvls)
> y <-
2018 May 17
0
Bilateral matrix
Dear William and Ben,
Thank you for your replies and elegant solutions. I am having trouble with
the fact that two of the previous locations do not appear in current
locations (that is no one moved to OKC and Dallas from other cities), so
these two cities are not being included in the output.
I have provided a better sample of the data and the ideal output (wide form
- a 10x10 bilateral matrix)