[R] Splitting strings in data files R

Please I need help processing files with strings in R. All the files have two patterns (thus,examine separately): Pattern 1 (see file1 below): Delete Lines 1,2 & 4 in file1. Line 3 contains the column names. Then find anything as.character and delete. Please do not delete any values (e.g.

[R] Fitting fevd fuction to list R

I have data for 90 climate stations. For each station, I have made 100+ simulations using a statistical model. So, in R, I have 90 dataframes, each dataframe has 100+ simulations arranged column-wise. Now, I would like to fit an extreme value distribution (EVD) to each climate station. That

[R] Fit an Extreme Value Distribution to List of dataframes R

Hello, I have a list object with many dataframes (example provided below). Each coulmn in a dataframe represents a simluation and each dataframe represents a clmate station. I want to fit an extreme value distribution on each coulmn of a dataframe and then average the confidence intervals and

Re: [R] Apply t-test on list in R

Many thanks, Petr.You solved my problem.AT. [[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

[R] Apply t-test on list in R

I have a list object in R with dataframe names as: pav_DJF_histo.csvpav_DJF_rcp26_2040s.csv pav_DJF_rcp26_2080s.csv pav_DJF_rcp45_2040s.csvpav_DJF_rcp45_2080s.csv pav_DJF_rcp85_2040s.csv pav_DJF_rcp85_2080s.csv pav_JJA_histo.csv pav_JJA_rcp26_2040s.csv pav_JJA_rcp26_2080s.csv

Re: [R] split dataframe to several dataframes in R

. lst4 - lapply(lst4, function(x) {as.data.frame(t(iris1.csv))}) #Get the data.frames in the list to the global environment list2env(lst4 ,.GlobalEnv) Regards On 17 February 2015 at 09:23, Zilefac Elvis via R-help r-help@r-project.org wrote: Hi All,I have a dataframe called 'means' as shown

Re: [R] split dataframe to several dataframes in R

, is more useful. Chris Campbell, PhD Tel. +44 (0)1249 705 450 | Mobile. +44 (0) 7929 628 349 www.mango-solutions.com Mango Solutions 2 Methuen Park, Chippenham, Wiltshire. SN14 OGB UK -Original Message- From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Zilefac Elvis

[R] split dataframe to several dataframes in R

Hi All,I have a dataframe called 'means' as shown below:iris1.csv - iris iris2.csv - iris names - c(iris1.csv, iris2.csv) dat - mget(names) lst4 - lapply(dat, function(x) apply(x[,-5], 2, mean)) # Build the new data frame means - as.data.frame(do.call(rbind, lst4)) means$source - names(lst4)

Re: [R] Angle brackets ?plotmath

Perfect! # italic(symbol(\341)*T[min]*symbol(\361)) Thanks, Uwe. Asong. On 10.12.2014 04:49, Zilefac Elvis via R-help wrote: Hi All, Please, I would like to enclose T[min] using angle brackets in R. I have tried something like: mtext(text=expression(Winter(DJF)~daily~minimum~temperature

[R] add symbol above letter in R

Hi, I would like to add a dash (—) on a letter in R. How can I add a dash on letter P in the following: mtext(text=expression(Winter(DJF)~mean~daily~precipitation~italic(P)), side=3, line=1, cex=1.3, col=black) ?plotmath could not provide an answer to my problem. many thanks for your

Re: [R] add symbol above letter in R

I got the right answer: mtext(text=expression(Winter(DJF)~mean~daily~precipitation~bar(italic(P))), side=3, line=1, cex=1.3, col=black) Thanks. On Tuesday, December 9, 2014 1:28 PM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi, I would like to add a dash (—) on a letter in R. How can I

[R] Angle brackets ?plotmath

Hi All, Please, I would like to enclose T[min] using angle brackets in R. I have tried something like: mtext(text=expression(Winter(DJF)~daily~minimum~temperature~bold((italic(symbol(\341)T[min]symbol(\361), side=3, line=1, cex=1.3, col=black) but did not succeed. I learnt that adobe-type

Re: [R] Rename multiple files in a directory and write renamed files back to directory

. format(c(1,5,32,100), width=3, flag=0) [1] 1 5 32 100 formatC(c(1,5,32,100), width=3, flag=0) [1] 001 005 032 100 I hope this helps. Chel Hee Lee On 12/04/2014 10:54 PM, Zilefac Elvis wrote: Hi Chel, Thanks for the timely reply. It works but a minor problem remains. Here

Re: [R] Rename multiple files in a directory and write renamed files back to directory

Hi Chel, I got it right. Many thanks. file.rename(file_names, to=paste0(rcp45_Daily_Sim, 200:210)) list.files(pattern=rcp45_Daily_Sim) [1] rcp45_Daily_Sim200 rcp45_Daily_Sim201 rcp45_Daily_Sim202 On Friday, December 5, 2014 9:35 AM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi Chel, How

[R] Rename multiple files in a directory and write renamed files back to directory

Hello, I would like to rename multiple files in a directory. Filenames are read using: lfile - list.files(pattern=rcp45_Daily_) files - paste(paste(getwd(),lfile,sep=/), list.files(lfile),sep=/)# getwd of these files dput(lfile) c(rcp45_Daily_Sim001.dat, rcp45_Daily_Sim002.dat) - How can

Re: [R] Rename multiple files in a directory and write renamed files back to directory

:44 PM, Zilefac Elvis via R-help wrote: Hello, I would like to rename multiple files in a directory. Filenames are read using: lfile - list.files(pattern=rcp45_Daily_) files - paste(paste(getwd(),lfile,sep=/), list.files(lfile),sep=/)# getwd of these files dput(lfile) c

[R] How to fill rainbow colors under curves in R

Hi All, I have a tricky problem here. The short code below plots some percentiles from a simulation. The percentiles are indicated in different colors. Problem: - How can I fill the area under the curve using the same colors as for the percentiles-1? - Also, I would like the rainbow intensity

Re: [R] LAT/LON to UTM in R

Hi Admas,Sorry I missed out the reproducible example.Here it is: dput(xy)structure(list(ID = 1:120, X = c(-102.6, -101.9, -97.1, -97, -95.7, -99.1, -100.1, -97.2, -97, -99.3, -96, -95.2, -98.8, -98.1, -99.6, -97.8, -96.1, -98.3, -95.6, -96.8, -101.2, -101.1, -97.2, -111.1, -111.2, -116, -117.6,

Re: [R] LAT/LON to UTM in R

Hi Adam,I was not sure if my solution was correct.This is what I got using ArcGIS to convert the same coordinates: +proj=lcc +lat_1=49 +lat_2=77 +lat_0=49 +lon_0=-95 +x_0=0 +y_0=0 +datum=NAD83 +units=m +no_defs +ellps=GRS80 +towgs84=0,0,0 structure(list(Long = c(662843L, 303344L, 634922L,

Re: [R] LAT/LON to UTM in R

Many thanks Jean for the clarification.Zilefac. [[alternative HTML version deleted]] __ 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

[R] LAT/LON to UTM in R

Hi, I am trying to convert lat/lon to UTM but my results are extremely flawed. Is it because of wrong UTM zone or my lon points are negative? I read a shapefile from ESRI using: library(rgdal) stations - readOGR(.,stations) print(proj4string(stations)) ## +proj=longlat +ellps=WGS84 +datum=WGS84

[R] Overlay two shapefiles in same map axes rgdal/maptools

Hello, I have two spatial map objects (reproducible example further down) which I would like to overlay in R. The ESRI shapefiles were read using: library(rgdal) Prairie.Boundaries - readOGR(., boundaries) watersheds-readOGR(.,watersheds) The two objects have same projection:

[R] Display two polygons in same map axes R

Hello, I have two spatial map objects (reproducible example further down) which I would like to overlay in R. The ESRI shapefiles were read using: library(rgdal) Prairie.Boundaries - readOGR(., boundaries) watersheds-readOGR(.,watersheds) The two objects have same projection:

[R] Split fixed width data in R

Hi, I have fixed width data that I would like to split into columns. Here is a sanpshot of the data (actual data is a list object): lst1Sub- 20131124GGG1 23.00 20131125GGG1 15.00 20131128GGG1 0.00 201312 1GGG1 0.00 201312 4GGG1 0.00 201312 7GGG1 10.00 20131210GGG1 0.00 20131213GGG1

Re: [R] Split fixed width data in R

] On Behalf Of Zilefac Elvis Sent: 22 October 2014 16:38 To: R. Help Subject: [R] Split fixed width data in R Hi, I have fixed width data that I would like to split into columns. Here is a sanpshot of the data (actual data is a list object): lst1Sub- 20131124GGG1 23.00 20131125GGG1 15.00

Re: [R] Split fixed width data in R

Thanks John. AT. On Wednesday, October 22, 2014 5:23 PM, John McKown john.archie.mck...@gmail.com wrote: On Wed, Oct 22, 2014 at 10:37 AM, Zilefac Elvis zilefacel...@yahoo.comwrote: Hi, I have fixed width data that I would like to split into columns. Here is a sanpshot of the data (actual

[R] Plot Lines instead of colour bands in R

Hi, I have a plotting issue which I am trying to resolve in R. Please load my attached sample data (I used dput(lapply(sim.summary,head,1)) but the data are too large) to R, install Rglimclim package and run this code which shows an example plot I would like to change. My main function, myplot

Re: [R] Apply quantile function to each dataframe in a List R

Great! Thanks. AT. On Monday, August 4, 2014 8:59 PM, rhelpmaillist rhelpmaill...@163.com wrote: Try this: lapply(a,function(x) apply(x[,-c(1,2)],2,quantile,probs=0.95)) # a is your example list At 2014-08-05 09:17:23, Zilefac Elvis zilefacel...@yahoo.com wrote: Hello, I would like

Re: [R] Convert some columns of List to dataframe R

Great! Thanks, John. For the eye sees not itself, but by reflection and someother things On Sunday, August 3, 2014 4:54 PM, John McKown john.archie.mck...@gmail.com wrote: On Sun, Aug 3, 2014 at 5:12 PM, Zilefac Elvis zilefacel...@yahoo.com wrote: Dear All, I have a List in R and would like

[R] Apply quantile function to each dataframe in a List R

Hello, I would like to calculate for each numeric column in a dataframe, quantile(x,probs=o.95). My list object has 120 dataframes, each dataframe has 102 columns. Here is an example as well as a reproducible example: [[120]]   Year Site Sim001 Sim002 Sim003 Sim004 Sim005 Sim006 Sim007 Sim008

Re: [R] Extract particular months from List in R

, 2014 1:47 AM, Uwe Ligges lig...@statistik.tu-dortmund.de wrote: On 03.08.2014 07:17, Zilefac Elvis wrote: Hi ALL, I have a List object in R. The dataframes in the List have equal rows and columns. How can I extract from the List, data corresponding to say c(June, July , August)? Remember

Re: [R] Extract particular months from List in R

Great! Thanks very much Uwe. AT. On Sunday, August 3, 2014 2:12 PM, Uwe Ligges lig...@statistik.tu-dortmund.de wrote: On 03.08.2014 21:23, Zilefac Elvis wrote: Hi Uwe, Thanks for replying. Here is a reproducible example. I would like to extract data for the Months of c(6,7,8). Output

[R] Convert some columns of List to dataframe R

Dear All, I have a List in R and would like to convert it to data.frame. Below is a reproducible example. I can do something like:  x1-do.call(cbind.data.frame, lst3) #OR x1-as.data.frame(lst3). However, my output looks like this: Year Site  x   Year Site x 2001 G101 33.1 2001 G102 34 I

Re: [R] Convert some columns of List to dataframe R

, Aug 3, 2014 at 5:43 PM, John McKown john.archie.mck...@gmail.com wrote: On Sun, Aug 3, 2014 at 5:12 PM, Zilefac Elvis zilefacel...@yahoo.com wrote: Dear All, I have a List in R and would like to convert it to data.frame. Below is a reproducible example. I can do something like: x1-do.call

[R] Extract particular months from List in R

Hi ALL, I have a List object in R. The dataframes in the List have equal rows and columns. How can I extract from the List, data corresponding to say c(June, July , August)? Remember, it is a List object, containing 100 dataframes, with daily data arranged by YYMMDD. Thanks for your thoughtful

[R] Bubble map in R

Hi, I would like to create a nice looking bubble map in R. Here is what I have done so far (the data is found below): # library(ggplot2) if (dev.cur() == 1) x11(width=8,height=6) par(mfcol=c(1,1))

[R] Freeing up memory in R

Hi, I will like to free up memory in R and make my program execute faster. At the moment, MY PROGRAM IS VERY SLOW probably due to memory issues. Here is sample data (Rcode is found at the end) from one simulation(I have 1000 such files to process):  list(c(1971 1 1GGG1 0.00 -3.68 -0.29,

Re: [R] : Quantile and rowMean from multiple files in a folder

Hi AK, Thanks very much for the updated code. My simulated results are even more consistent with observations after apply the updated version of the code. Cheers, Atem. On Wednesday, April 16, 2014 11:31 PM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi AK, Thanks very much. Atem

Re: [R] : Quantile and rowMean from multiple files in a folder

          1%      1.005563      1.039288 #3          2%      1.029126      1.057685 any(is.na(ReadOut2$pint_DJF))  [1] FALSE A.K. On Wednesday, April 16, 2014 12:34 PM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi AK, I tried the updated Quantilecode.txt. It works well but when I open the files

Re: [R] : Quantile and rowMean from multiple files in a folder

, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi AK, Please ignore any such site. I will check it and include in the analysis. Thanks, Atem. On Monday, April 14, 2014 9:34 PM, arun smartpink...@yahoo.com wrote: Hi, I looked at your Observed.zip.  In that one of the file is without any data

Re: [R] : Quantile and rowMean from multiple files in a folder

      0.96572 #3          2%    0.825364      0.96904 Attached is the file. A.K. On Tuesday, April 15, 2014 4:00 AM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi AK, I tried all codes for observations. All others work great except this (probably due to different dimensions. What I did is that I

Re: [R] Quantile and rowMean from multiple files in a folder

. On Sunday, April 13, 2014 2:46 AM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi AK, Q1) I need your help again. Using the previous data (attached) and the previous code below,instead of taking rowMeans, let's do quantile(x,seq(0,1,by=0.01)).  Delete the last 2 rows (Trend and p) in each file

Re: [R] Splitting columns and forming new data files in R

was unable to edit lst1NEW-. -- Original Message -- From : arun To : Zilefac Elvis; Sent : 10-04-2014 22:02 Subject : Re: Re: Splitting columns and forming new data files in R   Hi Atem, It may be that the program slows with the size of the dataset.  On Thursday, April 10, 2014 11:13 PM

Re: [R] Aggregate time series from daily to monthly by date and site

Thanks, Rui. It works great. Atem. On Saturday, April 5, 2014 4:46 AM, Rui Barradas ruipbarra...@sapo.pt wrote: Hello, Maybe the following will do. dat - structure(...) aggregate(dat[5:8], dat[c(1, 2, 4)], FUN = mean) Hope this helps, Rui Barradas Em 05-04-2014 06:37, Zilefac Elvis

[R] Aggregate time series from daily to monthly by date and site

Hi, I have daily data arranged by date and site. Keeping the number of columns as there are, I will like to aggregate (FUN=mean) from daily to monthly the following data (only part is shown here) which starts in 1971 and ends in 1980.     Year Month Day Site Sim001 Sim002 Sim003 Sim004 1   1971

Re: [R] Aggregate time series from daily to monthly by date and site

Hi, I have daily data arranged by date and site. Keeping the number of columns as there are, I will like to aggregate (FUN=mean) from daily to monthly the following data (only part is shown here) which starts in 1971 and ends in 1980. structure(list(Year = c(1971, 1971, 1971, 1971, 1971,

Re: [R] Please help

-14.32  3.87 26 1971    6  5 G107        144.09  11.25 30.44 27 1971    6  5 G108          0.66  9.33 32.96   A.K. On Monday, March 31, 2014 2:35 AM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi AK, I figured out that the error is from Sim1971-2000_Daily_Sim001.dat. The other files had

[R] Split dataframe by year

Hi, I have a dataframe in R and would like to split the data (1900-1980) into two sets. For example, one dataframe should have data from 1900-1960 and the other from 1961-1980. Thanks for your help. AT. [[alternative HTML version deleted]] __

[R] Spatial Correlation Map using R

Hi, I have rainfall data from 100 locations, with coordinates  for each location available. Now, I have a correlation matrix showing the correlation between rainfall at a single location against all other locations and so on for the 100 locations. How can I visualize this correlation matrix

Re: [R] Spatial Correlation Map using R

Hi Jim, I tried as you described but did not succeed. Can I send you sample data? Thanks, Zilefac. On Tuesday, December 3, 2013 4:19 PM, Jim Lemon j...@bitwrit.com.au wrote: On 12/04/2013 08:59 AM, Jim Lemon wrote: On 12/04/2013 05:26 AM, Zilefac Elvis wrote: Hi, I have rainfall data from

Re: [R] melt dataframe

- dat2M[with(dat2M,order(year,month,day,variable)),]  dim(dat2M1) #[1] 1972320   5  row.names(dat2M1) - 1:nrow(dat2M1)  colnames(dat2M1)[4:5] - c(site,rain) 16436*120 #[1] 1972320 A.K. On Saturday, November 16, 2013 11:28 PM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hello AK, I would

Re: [R] select .txt from .txt in a directory

,stringsAsFactors=FALSE) str(res3) res3$dates-as.Date(res3$dates) res4 - res3[!is.na(res3$dates),] res4[1:3,1:3] dim(res4)  #[1] 16436    99 A.K. On Friday, November 8, 2013 5:54 PM, Zilefac Elvis zilefacel...@yahoo.com wrote: Hi Ak, I think I figured out how to do the sub-setting. All I

[R] select .txt from .txt in a directory

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

Re: [R] select .txt from .txt in a directory

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 zilefacel

[R] Apply acf to data frame containing 'NA'

Hi, I have a data frame with each column representing a separate site. Following this code, I can apply acf to all columns in A. 'A' contains randomly generated data. A - matrix(rnorm(1500),nrow=500) par(mfrow=c(ncol(A),1)) lapply(split(A,col(A)), acf) #OR lapply(split(A,col(A)),

Re: [R] Apply acf to data frame containing 'NA'

is not a multiple of split variable AE. From: arun smartpink...@yahoo.com To: Zilefac Elvis zilefacel...@yahoo.com Cc: R help r-help@r-project.org Sent: Sunday, June 23, 2013 11:41 AM Subject: Re: [R] Apply acf to data frame containing 'NA' Hi, May

Re: [R] dates and time series management

Hi A.K, I go an error on line 24 when processing all the 100 files: res-fun1(lstf1) Error in read.table(x, sep = , header = TRUE, stringsAsFactors = FALSE) :    more columns than column names There seem to be a difference between lstf and lstf1. Thanks, Atem.

[R] Sort data by month

Hello, I have a 'zoo' object containing dates [dd/mm/yr] in the first column and values in the second column. I tried as.Date but did not succeed. Here is an example of date format  01/01/2000 01/02/2000 ... 01/12/2000 01/01/2001 01/02/2001 ... 01/12/2000   etc. I would like to sort all Jans

Re: [R] Sort data by month

. From: arun smartpink...@yahoo.com To: Zilefac Elvis zilefacel...@yahoo.com Cc: R help r-help@r-project.org Sent: Wednesday, May 22, 2013 8:47 PM Subject: Re: [R] Sort data by month Hi, May be this helps. date1-seq.Date(as.Date(01/01/2000,format=%d/%m/%Y),as.Date(31/12/2010

[R] estimate value from simulations

Hello, I need your help on this matrix:    1 1 1 1 1 1  2 2 2 2 2 2  3 3 3 3 3 3   5 5 5 5 5 5  2 2 2 2 2 2  3 3 3 3 3 3   6 6 6 6 6 6  2 2 2 2 2 2  3 3 3 3 3 3   1 1 1 1 1 1  2 2 2 2 2 2  3 3 3 3 3 3  First three rows represent first simulation, next three rows = second simulation etc. I

Re: [R] Loop through a simulation

Thanks AK. It works as expected. Atem. From: arun [smartpink...@yahoo.com] Sent: Thursday, May 16, 2013 11:16 AM To: Zilefac, Elvis Cc: R help Subject: Re: Loop through a simulation Hi, May be this is what you meant. dat1- read.csv(data2.csv,header

[R] Estimating confidence intervals from several simulations

Hi, I have 1000 simulations each arranged beneath another. The attached data is on monthly basis. First column is number of simulation, second is year and the rest, months. Problem:  1) Take sim 1 for example to be my original data from 1961-2005 with twelve months. You can delete the years.

Re: [R] Help

. Thanks for much. -- Original Message -- From : arun To : Zilefac Elvis; Cc : R help; Sent : 27-04-2013 16:29 Subject : Re: [R] Help   HI, Find 'T','C','A','F' and 'Y', delete them from all the 110 files I assume that you meant to replace it with NA. set.seed(28) myfiles- lapply(1:5

[R] Help

Hello, I have a question and need your help urgently. I am new to R but want to learn it. I have several files in a folder which I have imported to R using : temp = list.files(pattern=*.txt) myfiles = lapply(temp, read.delim) The resulting files are on the workspace stored as List[110]. So

Re: [R] find and replace missing data in several different files

Hello, I have a question and need your help urgently. I am new to R but want to learn it. I have several files in a folder which I have imported to R using : temp = list.files(pattern=*.txt) myfiles = lapply(temp, read.delim) The resulting files are on the workspace stored as List[110]. So