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                   Lon                    Address

Anchorage    45.87576     -12.567          Starbucks, Van dyke road, 33456,
USA





I would like to write a script in R that goes through each folder and
gathers the data to create a single data frame that has all the data in
each folder. So I would have a single data frame that consists of all
observation appended together from in each excel file in each folder in one
data frame i.e



State       Lat              Lon             Address

xxx          xxx               xxx              xxx

xxx          xxx               xxx              xxx

xxx          xxx               xxx              xxx



Please let me know how I would go about this

Vijay

	[[alternative HTML version deleted]]

