Grouping by 3 variable and renaming groups

Hello,

See if this is it:

priceStore_Grps$StoreID <- paste("Store", 
seq_len(nrow(priceStore_Grps)), sep = "_")


Hope this helps,

Rui Barradas

On 5/26/2018 2:03 PM, Jeff Reichman wrote:

ALCON


I'm trying to figure out how to rename groups in a data frame after 
groups
by selected variabels.? I am using the dplyr library to group my data 
by 3
variables as follows


# group by lat (StoreX)/long (StoreY)

priceStore <- LapTopSales[,c(4,5,15,16)]

priceStore <- priceStore[complete.cases(priceStore), ]? # keep only 
non NA
records

priceStore_Grps <- priceStore %>%

?? group_by(StorePC, StoreX, StoreY) %>%

?? summarize(meanPrice=(mean(RetailPrice)))


which results in .

priceStore_Grps

# A tibble: 15 x 4

# Groups:?? StorePC, StoreX [?]

??? StorePC? StoreX StoreY meanPrice

??? <fct>???? <int>? <int>???? <dbl>

1 CR7 8LE? 532714 168302????? 472.

2 E2 0RY?? 535652 182961????? 520.

3 E7 8NW?? 541428 184515????? 467.

4 KT2 5AU? 517917 170243????? 522.

5 N17 6QA? 533788 189994????? 523.


Which is fine, but I then want to give each group (e.g. CR7 8LE? 532714
168302) a unique identifier (say) Store 1, 2, 3 or some other unique
identifier.


??? StorePC? StoreX StoreY meanPrice

??? <fct>???? <int>? <int>???? <dbl>

1 CR7 8LE? 532714 168302????? 472.?? Store 1

2 E2 0RY?? 535652 182961????? 520.?? Store 2

3 E7 8NW?? 541428 184515????? 467.?? Store 3

4 KT2 5AU? 517917 170243????? 522.?? Store 4

5 N17 6QA? 533788 189994????? 523.?? Store 5



????[[alternative HTML version deleted]]