Hello,
I have created many excel files in my working dir. 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
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
