> -----Original Message----- > From: metal_lical...@live.com > Sent: Thu, 28 Mar 2013 11:24:43 +0300 > To: r-help@r-project.org > Subject: [R] How to search in each excel in my working dir and extract > part information of one product in each country? > > Hello, > > I have created many excel files in my working dir.
Why? >each excel file > contain one country's data. In the excel, I have dataframe in sheet1, > where each product and its relative information is > in each row as following: > > Product PE Retail_price_Band Country Model_Fit > A -2.5 0-50 CN > 84% > B -2.1 51-100 CN 90% > ..... > > > not every product presents in each country, in other words, they may have > common products or not. > How do I create program in R to search each excel file in my working dir > in order to make the list of the such product for each > country based on my input(for example, I want to have all information > related to product B in each country) > the result what I want: > > > Product PE Retail_price_Band Country Model_Fit > B -2.4 51-100 IN 80% > B -2.1 51-100 CN 90% > > > How do I achieve this? thanks. > > Kind regards, > Lingyi > If you are doing the original analyses in R why not just run them put the results for the countries in a list. Then just convert the list to a data.frame and subset. Quick and dirty example. md1 <- data.frame(aa = 1:10, b = letters[1:5]) md2 <- data.frame(aa = 11:20, b = letters[6:10]) mlist <- list(md1,md2) dd1 <- do.call(rbind.data.frame, mlist) ____________________________________________________________ FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! ______________________________________________ R-help@r-project.org mailing list 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.
