long_to_wide.md
In RcensusPkg: Easily Access US Census Bureau Survey and Geographic Data

long_to_wide()

Code
  B19001_1yr_long_dt <- RcensusPkg::get_vintage_data(dataset = "acs/acs1",
    vintage = 2016, group = "B19001", region = "state", wide_to_long = TRUE)
  head(RcensusPkg::long_to_wide(dt = B19001_1yr_long_dt, parameter_col = "variable",
    value_col = c("estimate", "moe")))
Output
  Key: <NAME, GEOID>
           NAME  GEOID B19001_001E B19001_002E B19001_003E B19001_004E
         <char> <char>      <char>      <char>      <char>      <char>
  1:    Alabama     01     1852518      176641      120590      117332
  2:     Alaska     02      248468        9066        7301        7545
  3:    Arizona     04     2519052      184109      123141      116678
  4:   Arkansas     05     1142718      101085       75579       71364
  5: California     06    12944178      699927      584989      526006
  6:   Colorado     08     2108992      108697       80074       81207
     B19001_005E B19001_006E B19001_007E B19001_008E B19001_009E B19001_010E
          <char>      <char>      <char>      <char>      <char>      <char>
  1:      108912      102080      103366       91011       86996       74864
  2:        8611        8600        8473        8481        8641        8927
  3:      130098      130486      123857      124089      128122      106138
  4:       73293       67142       68962       59857       60179       53457
  5:      581059      495728      539507      498105      515009      457955
  6:       90408       84492       88961       89926       90355       81731
     B19001_011E B19001_012E B19001_013E B19001_014E B19001_015E B19001_016E
          <char>      <char>      <char>      <char>      <char>      <char>
  1:      149568      172123      210500      131506       72234       73159
  2:       20236       26130       35805       30674       19356       22973
  3:      218352      253777      315958      199132      118826      124871
  4:       98492      110734      118374       75019       40069       35574
  5:      890403     1219707     1574447     1228401      805397     1019268
  6:      167806      224015      287881      205649      126674      148964
     B19001_017E B19001_001M B19001_002M B19001_003M B19001_004M B19001_005M
          <char>      <char>      <char>      <char>      <char>      <char>
  1:       61636       12189        6328        5347        5956        5308
  2:       17649        2841        1377        1240         932        1079
  3:      121418       11479        6989        6489        4765        6069
  4:       33538        7341        6031        3958        4519        4690
  5:     1308270       15703       11559       11873        9875       13320
  6:      152152        7767        4740        5196        4568        4111
     B19001_006M B19001_007M B19001_008M B19001_009M B19001_010M B19001_011M
          <char>      <char>      <char>      <char>      <char>      <char>
  1:        4740        5246        4699        4418        4210        6892
  2:        1529        1159        1245        1304        1607        1870
  3:        5512        5885        6284        5561        5649        7180
  4:        4264        4048        3585        4458        3591        4975
  5:       10465       10981       12317       10363       11042       13192
  6:        5128        4492        4993        4678        4939        6211
     B19001_012M B19001_013M B19001_014M B19001_015M B19001_016M B19001_017M
          <char>      <char>      <char>      <char>      <char>      <char>
  1:        6491        7253        4899        4037        3975        3326
  2:        2303        2520        2987        2281        2070        1810
  3:        8268        7243        7314        5184        5471        5454
  4:        5136        5054        3999        2962        2858        2717
  5:       16817       19640       15370       14330       14059       14617
  6:        7495        6606        6336        5114        5145        4761