how to access the one to one distances in data frames

how i can access the distances 1 to 1 in results of below example like origin1 to destination1 then origin2 to destination1.........origin10 to destination1 for all destination values till 10 please help

Lat= function(){
 a = runif(10,29.00,34.00)
 
 return(a)
}

Long= function(){
 b = runif(10,69.00,72.00)
 
 return(b)
}
onlineloc=paste0(LAT=Lat(),"+",LONG=Long())
onlineloc
#>  [1] "33.7354194428772+71.3494398894254"
#>  [2] "30.7413132882211+70.9138551698998"
#>  [3] "30.5883582818788+71.9096039920114"
#>  [4] "33.045862632338+71.0958766064141" 
#>  [5] "29.2885750343557+70.7765049319714"
#>  [6] "30.4626142708585+70.1727275485173"
#>  [7] "33.0190124884248+70.3057639268227"
#>  [8] "32.6775916954502+71.3174786302261"
#>  [9] "33.0967068879399+71.7019093113486"
#> [10] "31.1544172114227+69.9206997987349"
instore=paste0(LAT=Lat(),"+",LONG=Long())
instore
#>  [1] "33.0430624212604+70.1033405440394"
#>  [2] "30.5197019814514+70.1542735851835"
#>  [3] "30.3004300009925+70.5621155435219"
#>  [4] "31.2477844555397+69.6533903363161"
#>  [5] "31.6187091867905+71.8852758833673"
#>  [6] "30.1380380985793+70.9889257850591"
#>  [7] "32.3412556524854+69.263568389928" 
#>  [8] "30.1637887277175+70.7543392230291"
#>  [9] "33.4547676318325+70.7117435170803"
#> [10] "30.1503008694854+70.737212235108"
library(mapsapi)
library(gmapsdistance)
results = gmapsdistance(origin = instore, destination = onlineloc, mode = "driving", key = "") 
results
#> $Time
#>                                   or
#> 1  33.0430624212604+70.1033405440394
#> 2  30.5197019814514+70.1542735851835
#> 3  30.3004300009925+70.5621155435219
#> 4  31.2477844555397+69.6533903363161
#> 5  31.6187091867905+71.8852758833673
#> 6  30.1380380985793+70.9889257850591
#> 7   32.3412556524854+69.263568389928
#> 8  30.1637887277175+70.7543392230291
#> 9  33.4547676318325+70.7117435170803
#> 10  30.1503008694854+70.737212235108
#>    Time.33.7354194428772+71.3494398894254
#> 1                                   18330
#> 2                                      NA
#> 3                                   32086
#> 4                                      NA
#> 5                                   25579
#> 6                                   33547
#> 7                                   29746
#> 8                                   32069
#> 9                                   10203
#> 10                                  31691
#>    Time.30.7413132882211+70.9138551698998
#> 1                                   25061
#> 2                                      NA
#> 3                                    6608
#> 4                                      NA
#> 5                                   15004
#> 6                                    5485
#> 7                                   25459
#> 8                                    6592
#> 9                                   26774
#> 10                                   6214
#>    Time.30.5883582818788+71.9096039920114
#> 1                                   30731
#> 2                                      NA
#> 3                                   11721
#> 4                                      NA
#> 5                                   13469
#> 6                                    8919
#> 7                                   31129
#> 8                                   11433
#> 9                                   32444
#> 10                                  10770
#>    Time.33.045862632338+71.0958766064141
#> 1                                   9939
#> 2                                     NA
#> 3                                  23694
#> 4                                     NA
#> 5                                  19268
#> 6                                  25156
#> 7                                  21355
#> 8                                  23678
#> 9                                  10744
#> 10                                 23299
#>    Time.29.2885750343557+70.7765049319714
#> 1                                   36698
#> 2                                      NA
#> 3                                   11496
#> 4                                      NA
#> 5                                   22966
#> 6                                    8722
#> 7                                   37097
#> 8                                   11208
#> 9                                   38412
#> 10                                  10545
#>    Time.30.4626142708585+70.1727275485173
#> 1                                      NA
#> 2                                      NA
#> 3                                      NA
#> 4                                      NA
#> 5                                      NA
#> 6                                      NA
#> 7                                      NA
#> 8                                      NA
#> 9                                      NA
#> 10                                     NA
#>    Time.33.0190124884248+70.3057639268227
#> 1                                    3220
#> 2                                      NA
#> 3                                   25612
#> 4                                      NA
#> 5                                   21918
#> 6                                   27074
#> 7                                   15769
#> 8                                   25596
#> 9                                    6395
#> 10                                  25218
#>    Time.32.6775916954502+71.3174786302261
#> 1                                   13163
#> 2                                      NA
#> 3                                   23001
#> 4                                      NA
#> 5                                   14033
#> 6                                   24463
#> 7                                   20992
#> 8                                   22985
#> 9                                   14877
#> 10                                  22607
#>    Time.33.0967068879399+71.7019093113486
#> 1                                   21790
#> 2                                      NA
#> 3                                   29976
#> 4                                      NA
#> 5                                   17416
#> 6                                   28283
#> 7                                   30471
#> 8                                   29960
#> 9                                   17169
#> 10                                  29582
#>    Time.31.1544172114227+69.9206997987349
#> 1                                   29213
#> 2                                      NA
#> 3                                   23187
#> 4                                      NA
#> 5                                   26411
#> 6                                   23349
#> 7                                   20406
#> 8                                   22986
#> 9                                   30926
#> 10                                  22608
#> 
#> $Distance
#>                                   or
#> 1  33.0430624212604+70.1033405440394
#> 2  30.5197019814514+70.1542735851835
#> 3  30.3004300009925+70.5621155435219
#> 4  31.2477844555397+69.6533903363161
#> 5  31.6187091867905+71.8852758833673
#> 6  30.1380380985793+70.9889257850591
#> 7   32.3412556524854+69.263568389928
#> 8  30.1637887277175+70.7543392230291
#> 9  33.4547676318325+70.7117435170803
#> 10  30.1503008694854+70.737212235108
#>    Distance.33.7354194428772+71.3494398894254
#> 1                                      227398
#> 2                                          NA
#> 3                                      470932
#> 4                                          NA
#> 5                                      316061
#> 6                                      490168
#> 7                                      391552
#> 8                                      463881
#> 9                                      102129
#> 10                                     462688
#>    Distance.30.7413132882211+70.9138551698998
#> 1                                      352463
#> 2                                          NA
#> 3                                       97683
#> 4                                          NA
#> 5                                      199386
#> 6                                       72676
#> 7                                      354845
#> 8                                       90632
#> 9                                      377250
#> 10                                      89439
#>    Distance.30.5883582818788+71.9096039920114
#> 1                                      455266
#> 2                                          NA
#> 3                                      220555
#> 4                                          NA
#> 5                                      167019
#> 6                                      169532
#> 7                                      457649
#> 8                                      197861
#> 9                                      480054
#> 10                                     193414
#>    Distance.33.045862632338+71.0958766064141
#> 1                                     129408
#> 2                                         NA
#> 3                                     372942
#> 4                                         NA
#> 5                                     270254
#> 6                                     392177
#> 7                                     293562
#> 8                                     365891
#> 9                                      95566
#> 10                                    364698
#>    Distance.29.2885750343557+70.7765049319714
#> 1                                      550564
#> 2                                          NA
#> 3                                      162550
#> 4                                          NA
#> 5                                      340787
#> 6                                      113014
#> 7                                      552946
#> 8                                      139855
#> 9                                      575351
#> 10                                     135409
#>    Distance.30.4626142708585+70.1727275485173
#> 1                                          NA
#> 2                                          NA
#> 3                                          NA
#> 4                                          NA
#> 5                                          NA
#> 6                                          NA
#> 7                                          NA
#> 8                                          NA
#> 9                                          NA
#> 10                                         NA
#>    Distance.33.0190124884248+70.3057639268227
#> 1                                       35571
#> 2                                          NA
#> 3                                      394534
#> 4                                          NA
#> 5                                      301804
#> 6                                      413770
#> 7                                      201302
#> 8                                      387483
#> 9                                       74401
#> 10                                     386290
#>    Distance.32.6775916954502+71.3174786302261
#> 1                                      166152
#> 2                                          NA
#> 3                                      343782
#> 4                                          NA
#> 5                                      191636
#> 6                                      363018
#> 7                                      278054
#> 8                                      336731
#> 9                                      190940
#> 10                                     335539
#>    Distance.33.0967068879399+71.7019093113486
#> 1                                      289459
#> 2                                          NA
#> 3                                      449499
#> 4                                          NA
#> 5                                      248530
#> 6                                      435445
#> 7                                      454516
#> 8                                      442448
#> 9                                      204835
#> 10                                     441255
#>    Distance.31.1544172114227+69.9206997987349
#> 1                                      386010
#> 2                                          NA
#> 3                                      281646
#> 4                                          NA
#> 5                                      311147
#> 6                                      288831
#> 7                                      265485
#> 8                                      271220
#> 9                                      410798
#> 10                                     270027
#> 
#> $Status
#>                                   or
#> 1  33.0430624212604+70.1033405440394
#> 2  30.5197019814514+70.1542735851835
#> 3  30.3004300009925+70.5621155435219
#> 4  31.2477844555397+69.6533903363161
#> 5  31.6187091867905+71.8852758833673
#> 6  30.1380380985793+70.9889257850591
#> 7   32.3412556524854+69.263568389928
#> 8  30.1637887277175+70.7543392230291
#> 9  33.4547676318325+70.7117435170803
#> 10  30.1503008694854+70.737212235108
#>    status.33.7354194428772+71.3494398894254
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
#>    status.30.7413132882211+70.9138551698998
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
#>    status.30.5883582818788+71.9096039920114
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
#>    status.33.045862632338+71.0958766064141
#> 1                                       OK
#> 2                          ROUTE_NOT_FOUND
#> 3                                       OK
#> 4                          ROUTE_NOT_FOUND
#> 5                                       OK
#> 6                                       OK
#> 7                                       OK
#> 8                                       OK
#> 9                                       OK
#> 10                                      OK
#>    status.29.2885750343557+70.7765049319714
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
#>    status.30.4626142708585+70.1727275485173
#> 1                           ROUTE_NOT_FOUND
#> 2                           ROUTE_NOT_FOUND
#> 3                           ROUTE_NOT_FOUND
#> 4                           ROUTE_NOT_FOUND
#> 5                           ROUTE_NOT_FOUND
#> 6                           ROUTE_NOT_FOUND
#> 7                           ROUTE_NOT_FOUND
#> 8                           ROUTE_NOT_FOUND
#> 9                           ROUTE_NOT_FOUND
#> 10                          ROUTE_NOT_FOUND
#>    status.33.0190124884248+70.3057639268227
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
#>    status.32.6775916954502+71.3174786302261
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
#>    status.33.0967068879399+71.7019093113486
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
#>    status.31.1544172114227+69.9206997987349
#> 1                                        OK
#> 2                           ROUTE_NOT_FOUND
#> 3                                        OK
#> 4                           ROUTE_NOT_FOUND
#> 5                                        OK
#> 6                                        OK
#> 7                                        OK
#> 8                                        OK
#> 9                                        OK
#> 10                                       OK
z=results$Distance
z
#>                                   or
#> 1  33.0430624212604+70.1033405440394
#> 2  30.5197019814514+70.1542735851835
#> 3  30.3004300009925+70.5621155435219
#> 4  31.2477844555397+69.6533903363161
#> 5  31.6187091867905+71.8852758833673
#> 6  30.1380380985793+70.9889257850591
#> 7   32.3412556524854+69.263568389928
#> 8  30.1637887277175+70.7543392230291
#> 9  33.4547676318325+70.7117435170803
#> 10  30.1503008694854+70.737212235108
#>    Distance.33.7354194428772+71.3494398894254
#> 1                                      227398
#> 2                                          NA
#> 3                                      470932
#> 4                                          NA
#> 5                                      316061
#> 6                                      490168
#> 7                                      391552
#> 8                                      463881
#> 9                                      102129
#> 10                                     462688
#>    Distance.30.7413132882211+70.9138551698998
#> 1                                      352463
#> 2                                          NA
#> 3                                       97683
#> 4                                          NA
#> 5                                      199386
#> 6                                       72676
#> 7                                      354845
#> 8                                       90632
#> 9                                      377250
#> 10                                      89439
#>    Distance.30.5883582818788+71.9096039920114
#> 1                                      455266
#> 2                                          NA
#> 3                                      220555
#> 4                                          NA
#> 5                                      167019
#> 6                                      169532
#> 7                                      457649
#> 8                                      197861
#> 9                                      480054
#> 10                                     193414
#>    Distance.33.045862632338+71.0958766064141
#> 1                                     129408
#> 2                                         NA
#> 3                                     372942
#> 4                                         NA
#> 5                                     270254
#> 6                                     392177
#> 7                                     293562
#> 8                                     365891
#> 9                                      95566
#> 10                                    364698
#>    Distance.29.2885750343557+70.7765049319714
#> 1                                      550564
#> 2                                          NA
#> 3                                      162550
#> 4                                          NA
#> 5                                      340787
#> 6                                      113014
#> 7                                      552946
#> 8                                      139855
#> 9                                      575351
#> 10                                     135409
#>    Distance.30.4626142708585+70.1727275485173
#> 1                                          NA
#> 2                                          NA
#> 3                                          NA
#> 4                                          NA
#> 5                                          NA
#> 6                                          NA
#> 7                                          NA
#> 8                                          NA
#> 9                                          NA
#> 10                                         NA
#>    Distance.33.0190124884248+70.3057639268227
#> 1                                       35571
#> 2                                          NA
#> 3                                      394534
#> 4                                          NA
#> 5                                      301804
#> 6                                      413770
#> 7                                      201302
#> 8                                      387483
#> 9                                       74401
#> 10                                     386290
#>    Distance.32.6775916954502+71.3174786302261
#> 1                                      166152
#> 2                                          NA
#> 3                                      343782
#> 4                                          NA
#> 5                                      191636
#> 6                                      363018
#> 7                                      278054
#> 8                                      336731
#> 9                                      190940
#> 10                                     335539
#>    Distance.33.0967068879399+71.7019093113486
#> 1                                      289459
#> 2                                          NA
#> 3                                      449499
#> 4                                          NA
#> 5                                      248530
#> 6                                      435445
#> 7                                      454516
#> 8                                      442448
#> 9                                      204835
#> 10                                     441255
#>    Distance.31.1544172114227+69.9206997987349
#> 1                                      386010
#> 2                                          NA
#> 3                                      281646
#> 4                                          NA
#> 5                                      311147
#> 6                                      288831
#> 7                                      265485
#> 8                                      271220
#> 9                                      410798
#> 10                                     270027

Created on 2020-02-05 by the reprex package (v0.3.0)

something like this

all_combinations <- tidyr::expand_grid(instore,onlineloc)

results <- purrr::map2_dfr(.x=all_combinations$instore,
                    .y=all_combinations$onlineloc,
                    .f = ~ tibble::enframe(gmapsdistance(origin = .x, destination = .y, mode = "driving", key = "") ))

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.