[R] Saving Rdataframe into a SQL Server Schema and updating the resulting table

Hi all Can someone assist me in creating a table in SQL Server using a Rdataframe as well as updating it with new records Here's my sample script in R. library(RODBC) #Connecting to Datum myconn <-odbcConnect("Datum", uid="bihy", pwd="tarta") ### Server name is Datum Now I would like to save

[R] Reverse geocoding Latitude and Longitude to address/name of location

I have a data frame with the column for latitude and another column for longitude. I would like to create a reverse geocoding function that creates another column with the address corresponding to this lat and lon i.e lat lon address 41.4938 -81.9860

[R] Appending Excel File Data in different folders into Single Dataframe

Hi all I have about 10 folders in my directory i.e Folder 1 – Folder 10. Each Folder has a single excel file containing data with the following attributes “State”,”lat”,”lon”, “address” i.e State Lat LonAddress Anchorage45.87576 -