Question: How do you graph a map in R when your dataset has abbreviations for the state instead of the state name? For example I have

How do you graph a map in R when your dataset has abbreviations for the state instead of the state name? For example I have "AL" for "Alabama"... below is my coded so far but the dataset I am trying to merge with has the state name instead of the abbreviations...so the data will not megre...is there a dataset I can merge with that has the initial instead?

library(maps) library(mapdata) library(ggplot2) library(mapproj)

states_map = map_data("state")

ggplot(states_map, aes(x=long, y=lat, group=group)) + geom_polygon(fill="white", color="black")

FoodSrvcdata = read.table("FoodSrvcByCounty.txt", header=T, sep="\t")

head(FoodSrvcdata)

FoodSrvc_map = merge(states_map, FoodSrvcdata, by.x="Region", by.y="state") head(FoodSrvc_map) head(states_map)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

c++ # Instructions Use the dataset named "MedianZIP.xlsx" that has median income by zip code (an excel file). Read the `MedianZIP.xlsx`, use the proper function, and save it as `mydata`. Save the...

CS 112 Project #5 dictionaries and file I/O Background The purpose of this assignment is to explore dictionaries and file reading and writing. We will be reading in some data about US elections1,...

Please solve as soon as possible, nee help with computer science project Definitions CSV file : This is a file containing plain text where each line in the file represents one record of information,...

CSV file: This is a file containing plain text where each line in the file represents one record of information, and each piece of info in the record is separated by a single comma. Luckily the...

Python3 please!! http://cs.gmu.edu/~marks/112/projects/votes.csv http://cs.gmu.edu/~marks/112/projects/abbreviations.csv Candidate: we will use the following representation for a candidate inside our...

Help with computer science question CSV file : This is a file containing plain text where each line in the file represents one record of information, and each piece of info in the record is separated...

Part 2: ZIP Code Look up and Distance Calculation As part of the Open Data Policy, the U.S. Government released a large number of datasets. Among these is a dataset that provides geographic...

Part 2: ZIP code look up and distance calculation As part of an Open Data Policy, the U.S. Government released a large number of datasets to conduct research, develop web and mobile applications,...

For this extra credit assignment, you will complete the major forms that you learned about in the rst three weeks of class-~Forms 941, W-3, W-2. 940 and an Annual Reconciliation worksheet-- for a...

Scenario As the accountant for Runson Moving Company, you are preparing the company's annual return, Form 940 and Schedule A. Use the following information to complete both. Address: 423 Bristol Pike...

In the above problem determine. (a) The change of entropy of the air. (b) The entropy transferred into the atmosphere at 10C. (c) The entropy generation in the system's universe during the...

Where can authoritative iGAAP guidance related to inventories be found?

6. How many times will the MessageBox.Show method in the following code be processed? For intCount As Integer = 6 To 13 Step 2 MessageBox.Show("Hello") Next intCount a. 3 b. 4 c. 5 d. 8

if efficiency is equal to = 1 - tc / th then tc is yemperature of first reservoir and efficiency must be , n = 1 - 1 0 0 0 / t 2 but expert have done t 1 in denominator, can you please explain this...

=+ e. Using your graph, show the impact of an increase in u. (Hint: This change affects both curves.) Describe both the immediate and the steady-state effects.

=+ 7. Choose two countries that interest youone rich and one poor. What is the income per person in each country? Find some data on country characteristics that might help explain the difference in...

=+difference? In your judgment, how useful is the Solow model as an analytic tool for understanding the difference between the two countries you chose?