I'm new to R so I'm having trouble organizing my data I have a data frame with various occurrences of about 200 different species and their location. Something like this
Species Longitude Latitude
1 Abronia graminea -97.30 18.72
2 Abronia graminea -97.33 18.70
3 Abronia graminea -97.03 19.65
4 Abronia graminea -97.10 18.85
5 Abronia graminea -97.03 19.61
6 Abronia graminea -97.34 18.69
What I want to do is create a new column with info for "type" of each species. I have another table with the information of the type for each species that looks like this:
Species Type
1 Abronia graminea lizard-like
2 Acontias litoralis short-tailed
3 Anguis fragilis long-tailed
4 Anilius scytale short-tailed