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.
