After casting:
## # A tibble: 6 x 51
## `1 AVE (R248)` `14 ST (R105)` `18 ST (R321)` `2 AVE (R300)`
## <dbl> <dbl> <dbl> <dbl>
## 1 3275. 1329. 415. 2343.
## 2 474. 288. 110 263.
## 3 1484. 786. 235. 504.
## 4 6186. 3637. 1735. 3008.
## 5 3575. 2549. 978. 2346.
## 6 5472. 3549. 1240. 4749.
## # ... with 47 more variables: `23 ST (R111)` <dbl>, `23 ST-5 AVE
## # (R083)` <dbl>, `23 ST-6 AVE (R203)` <dbl>, `23 ST-6 AVE (R453)` <dbl>,
## # `28 ST-BROADWAY (R082)` <dbl>, `3 AVE (R330)` <dbl>, `34 ST-HERALD SQ
## # (R022)` <dbl>, `34 ST-HERALD SQ (R023)` <dbl>, `34 ST-PENN STA
## # (R012)` <dbl>, `34 ST-PENN STA (R013)` <dbl>, `34 ST-PENN STA
## # (R031)` <dbl>, `42 ST-BRYANT PK (R021)` <dbl>, `42 ST-GRD CNTRL
## # (R046)` <dbl>, `5 AVE-BRYANT PK (R054)` <dbl>, `6 AVE (R163)` <dbl>,
## # `8 ST-B'WAY NYU (R085)` <dbl>, `BEDFORD AVE (R235)` <dbl>, `BLEECKER
## # ST (R194)` <dbl>, `BOROUGH HALL/CT (R108)` <dbl>, `BOWERY
## # (R311)` <dbl>, `BOWLING GREEN (R041)` <dbl>, `BOWLING GREEN
## # (R042)` <dbl>, `CANAL ST (R139)` <dbl>, `CHAMBERS ST (R030)` <dbl>,
## # `CHAMBERS ST (R044)` <dbl>, `CHRISTOPHER ST (R189)` <dbl>, `CLARK ST
## # (R224)` <dbl>, `DEKALB AVE (R099)` <dbl>, `EAST BROADWAY
## # (R257)` <dbl>, `GRAND ST (R240)` <dbl>, `GREENPOINT AVE (R239)` <dbl>,
## # `HIGH ST (R252)` <dbl>, `HOYT ST (R225)` <dbl>, `HOYT ST
## # (R456)` <dbl>, `JAY ST-METROTEC (R089)` <dbl>, `JAY ST-METROTEC
## # (R127)` <dbl>, `MURRAY ST-B'WAY (R087)` <dbl>, `NASSAU AV
## # (R256)` <dbl>, `PRINCE ST-B'WAY (R086)` <dbl>, `RECTOR ST
## # (R227)` <dbl>, `RECTOR ST (R304)` <dbl>, `SPRING ST (R282)` <dbl>,
## # `SPRING ST (R322)` <dbl>, `VERNON/JACKSON (R276)` <dbl>, `WALL ST
## # (R027)` <dbl>, `WALL ST (R043)` <dbl>, `WORLD TRADE CTR (R029)` <dbl>
And now transpose the matrix:
## [,1] [,2] [,3] [,4] [,5] [,6]
## 1 AVE (R248) 3275.2273 474.5000 1484.3182 6186.045 3575.091 5471.636
## 14 ST (R105) 1328.8636 288.4545 785.8182 3637.182 2549.273 3549.045
## 18 ST (R321) 414.6818 110.0000 234.7273 1734.545 978.500 1240.318
## 2 AVE (R300) 2343.1818 263.0909 503.5909 3008.318 2346.318 4748.545
## 23 ST (R111) 1457.3636 420.9091 1064.3182 4705.364 2652.727 3778.864
## 23 ST-5 AVE (R083) 652.4545 180.1364 707.3636 5787.955 2435.136 2598.318