Elvis,
first, keep things on the list - so others can learn and comment. Second, as
Sarah already commented: We do not like to open unsolicited binary attachments
on the list. Sarah gives a good hint how to post data to the list.
What I would do so far is use the matching columns to get the names you need
from BTemperature:
temp_inv <- read.table("Temperature Inventory", … ) (here I would change the
.xlsx to a .csv and use read.csv instead of read.table)
btemp <- read.table(“BTemperature_Stations.txt”, … ) (again think about
converting via Excel to .csv - it makes things far more easy)
Check ?read.table for options - you gonna need them.
Then match
mynames <- btemp[(temp_inv[,3] %in% btemp[, 3]), 2]
Now you have the names of the stations and if your .txt files are named by the
stations you can do something like:
for (name in mynames) {
tmp.table <- read.table(paste(“path/to/your/Homog_daily_min_temp/“, name,
“.txt”, sep = “”), … )
…. do things with the data
}
Best
Simon
On 08 Nov 2013, at 19:26, Zilefac Elvis <[email protected]> wrote:
> Hi Simon,
> Attached are my data files.
> Btemperature_Stations is my main file.
> Temperature inventory is my 'wanted' file and is a subset of
> Btemperature_Stations.
> Using column 3 in both files, select the files in Temperature inventory from
> Btemperature_Stations.
> The .zip file contains the .txt files which you will extract to a folder and
> do the selection in R.
>
> Thanks,
> Atem.
>
>
>
>
>
> On Friday, November 8, 2013 11:54 AM, Simon Zehnder <[email protected]>
> wrote:
> If you want to type in the names by hand, you can simply use read.table to
> load them into R … I still don’t get the aim of your text file handling
>
>
> On 08 Nov 2013, at 18:51, Zilefac Elvis <[email protected]> wrote:
>
> > All files are text files. They are found in a folder on my computer.
> > Assume that I know the names of some of the files I want to select from the
> > 300 txt files.
> > How can I do this in R.
> > Atem.
> >
> >
> > On Friday, November 8, 2013 11:44 AM, Simon Zehnder <[email protected]>
> > wrote:
> > I do not understand the question. If you already know the names what is the
> > problem to select the files by names?
> >
> > If you have the names but not inside of R you have to find a name pattern
> > to avoid typing them in. Is there a pattern, e.g. da.txt, db.txt, dc.txt?
> >
> >
> > On 08 Nov 2013, at 18:33, Zilefac Elvis <[email protected]> wrote:
> >
> > > Hi,
> > > I have 300 .txt files in a directory. Out of this 300, I need just 100 of
> > > the files.
> > > I have the names of the 100 .txt files which are also found in the 300
> > > .txt files.
> > > How can I extract only the 100 .txt files from the 300 ,txt files?
> > >
> > > e.g given d1.txt, ds.txt, dx.txt, df.txt...d300.txt, how can I select
> > > only d1.txt and df.txt? Remember, I have 300 of such and want to extract
> > > 100 of them with names known.
> > >
> > > Thanks for your great help.
> > > Atem.
> >
> > > [[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.
> >
> >
> >
>
>
> <BTemperature_Stations.txt><Tempearture
> inventory.xlsx><Homog_daily_min_temp.zip>
______________________________________________
[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.
