Adds a column with state ansi joining by a column with state abbreviation
join_ansi_abb(.data, .abb)data.frame or tibble
column with state abbreviation
.data with column .abb replaced with state ansi
data('stata')
stata %>% join_ansi_abb(abb)
#> fips abb name ansi.x region division
#> 1 01 AL Alabama 1779775 South East South Central
#> 2 02 AK Alaska 1785533 West Pacific
#> 3 04 AZ Arizona 1779777 West Mountain
#> 4 05 AR Arkansas 0068085 South West South Central
#> 5 06 CA California 1779778 West Pacific
#> 6 08 CO Colorado 1779779 West Mountain
#> 7 09 CT Connecticut 1779780 Northeast New England
#> 8 10 DE Delaware 1779781 South South Atlantic
#> 9 11 DC District of Columbia 1702382 South South Atlantic
#> 10 12 FL Florida 0294478 South South Atlantic
#> 11 13 GA Georgia 1705317 South South Atlantic
#> 12 15 HI Hawaii 1779782 West Pacific
#> 13 16 ID Idaho 1779783 West Mountain
#> 14 17 IL Illinois 1779784 Midwest East North Central
#> 15 18 IN Indiana 0448508 Midwest East North Central
#> 16 19 IA Iowa 1779785 Midwest West North Central
#> 17 20 KS Kansas 0481813 Midwest West North Central
#> 18 21 KY Kentucky 1779786 South East South Central
#> 19 22 LA Louisiana 1629543 South West South Central
#> 20 23 ME Maine 1779787 Northeast New England
#> 21 24 MD Maryland 1714934 South South Atlantic
#> 22 25 MA Massachusetts 0606926 Northeast New England
#> 23 26 MI Michigan 1779789 Midwest East North Central
#> 24 27 MN Minnesota 0662849 Midwest West North Central
#> 25 28 MS Mississippi 1779790 South East South Central
#> 26 29 MO Missouri 1779791 Midwest West North Central
#> 27 30 MT Montana 0767982 West Mountain
#> 28 31 NE Nebraska 1779792 Midwest West North Central
#> 29 32 NV Nevada 1779793 West Mountain
#> 30 33 NH New Hampshire 1779794 Northeast New England
#> 31 34 NJ New Jersey 1779795 Northeast Mid-Atlantic
#> 32 35 NM New Mexico 0897535 West Mountain
#> 33 36 NY New York 1779796 Northeast Mid-Atlantic
#> 34 37 NC North Carolina 1027616 South South Atlantic
#> 35 38 ND North Dakota 1779797 Midwest West North Central
#> 36 39 OH Ohio 1085497 Midwest East North Central
#> 37 40 OK Oklahoma 1102857 South West South Central
#> 38 41 OR Oregon 1155107 West Pacific
#> 39 42 PA Pennsylvania 1779798 Northeast Mid-Atlantic
#> 40 44 RI Rhode Island 1219835 Northeast New England
#> 41 45 SC South Carolina 1779799 South South Atlantic
#> 42 46 SD South Dakota 1785534 Midwest West North Central
#> 43 47 TN Tennessee 1325873 South East South Central
#> 44 48 TX Texas 1779801 South West South Central
#> 45 49 UT Utah 1455989 West Mountain
#> 46 50 VT Vermont 1779802 Northeast New England
#> 47 51 VA Virginia 1779803 South South Atlantic
#> 48 53 WA Washington 1779804 West Pacific
#> 49 54 WV West Virginia 1779805 South South Atlantic
#> 50 55 WI Wisconsin 1779806 Midwest East North Central
#> 51 56 WY Wyoming 1779807 West Mountain
#> 52 60 AS American Samoa 1802701 <NA> <NA>
#> 53 66 GU Guam 1802705 <NA> <NA>
#> 54 69 MP Northern Mariana Islands 1779809 <NA> <NA>
#> 55 72 PR Puerto Rico 1779808 <NA> <NA>
#> 56 74 UM U.S. Minor Outlying Islands 1878752 <NA> <NA>
#> 57 78 VI U.S. Virgin Islands 1802710 <NA> <NA>
#> ansi.y
#> 1 1779775
#> 2 1785533
#> 3 1779777
#> 4 0068085
#> 5 1779778
#> 6 1779779
#> 7 1779780
#> 8 1779781
#> 9 1702382
#> 10 0294478
#> 11 1705317
#> 12 1779782
#> 13 1779783
#> 14 1779784
#> 15 0448508
#> 16 1779785
#> 17 0481813
#> 18 1779786
#> 19 1629543
#> 20 1779787
#> 21 1714934
#> 22 0606926
#> 23 1779789
#> 24 0662849
#> 25 1779790
#> 26 1779791
#> 27 0767982
#> 28 1779792
#> 29 1779793
#> 30 1779794
#> 31 1779795
#> 32 0897535
#> 33 1779796
#> 34 1027616
#> 35 1779797
#> 36 1085497
#> 37 1102857
#> 38 1155107
#> 39 1779798
#> 40 1219835
#> 41 1779799
#> 42 1785534
#> 43 1325873
#> 44 1779801
#> 45 1455989
#> 46 1779802
#> 47 1779803
#> 48 1779804
#> 49 1779805
#> 50 1779806
#> 51 1779807
#> 52 1802701
#> 53 1802705
#> 54 1779809
#> 55 1779808
#> 56 1878752
#> 57 1802710