Hi all, I have several files in different folders or subdirectories. Here is an example of the data set.
c:\country\state\city. There might be more than 500 cities. ********************************** c:\country\state\city1 c:\country\state\city2 . . . c:\country\state\city500 *************************** Cities may keep the population record either in Excel file or text file format ( *.xlsx or *.txt) Each file contains : first name, last name, address, zip code, etc I want to create one data set from all the cities for analysis of in interest. Output should looks like country, state, city, first name, last name, address, zip code, etc. USA , NY , city1, Alex , John , 102 st name , 10004 , USA , NY , city1 Martin , Leno , 284 street name , 10003 , . . USA, NY , city500, Ethan , Noah , 543 st name , 10015 , Please note that variables Country, state and city come from the " c:\country\state\city" I would appreciate your help me in reading and combing this data sets Thank you in advance, [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.