Grouping by 3 variable and renaming groups

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]]

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]]

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]]

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]]