similar to: dplyr - add/expand rows

On 11/26/2017 08:42 PM, jim holtman wrote: > try this: > > ########################################## > > library(dplyr) > > input <- tribble( > ~station, ~from, ~to, ~record, > "07EA001" , 1960 , 1960 , "QMS", > "07EA001" , 1961 , 1970 , "QMC", > "07EA001" , 1971 , 1971 ,

Hi, A benchmarking study with an additional (data.table-based) solution. Enjoy! ;) Cheers, Denes -------------------------- ## packages ########################## library(dplyr) library(data.table) library(IRanges) library(microbenchmark) ## prepare example dataset ########### ## use Bert's example, with 2000 stations instead of 2 d_df <- data.frame( station =

Bert wrote ... Bill's solution seems to be for only one station. No, it works for any number of stations. Bill Dunlap TIBCO Software wdunlap tibco.com On Sun, Nov 26, 2017 at 11:10 AM, Bert Gunter <bgunter.4567 at gmail.com> wrote: > To David W.'s point about lack of a suitable reprex ("reproducible > example"), Bill's solution seems to be for only one

try this: ########################################## library(dplyr) input <- tribble( ~station, ~from, ~to, ~record, "07EA001" , 1960 , 1960 , "QMS", "07EA001" , 1961 , 1970 , "QMC", "07EA001" , 1971 , 1971 , "QMM", "07EA001" , 1972 , 1976 , "QMC", "07EA001" , 1977 ,

dplyr may have something for this, but in base R I think the following does what you want. I've shortened the name of your data set to 'd'. i <- rep(seq_len(nrow(d)), d$YEAR_TO-d$YEAR_FROM+1) j <- sequence(d$YEAR_TO-d$YEAR_FROM+1) transform(d[i,], YEAR=YEAR_FROM+j-1, YEAR_FROM=NULL, YEAR_TO=NULL) Bill Dunlap TIBCO Software wdunlap tibco.com On Sat, Nov 25, 2017 at 11:18 AM,

> On Nov 25, 2017, at 11:18 AM, Hutchinson, David (EC) <david.hutchinson at canada.ca> wrote: > > I have a returned tibble of station operational record similar to the following: > >> data.collection > # A tibble: 5 x 4 > STATION_NUMBER YEAR_FROM YEAR_TO RECORD > <chr> <int> <int> <chr> > 1 07EA001 1960

To David W.'s point about lack of a suitable reprex ("reproducible example"), Bill's solution seems to be for only one station. Here is a reprex and modification that I think does what was requested for multiple stations, again using base R and data frames, not dplyr and tibbles. First the reprex with **two** stations: > d <- data.frame( station =

Or with the Bioconductor IRanges package: df <- with(input, DataFrame(station, year=IRanges(from, to), record)) expand(df, "year") DataFrame with 24 rows and 3 columns station year record <character> <integer> <character> 1 07EA001 1960 QMS 2 07EA001 1961 QMC 3 07EA001 1962 QMC 4

Hi Martin, On 11/29/2017 10:46 PM, Martin Morgan wrote: > On 11/29/2017 04:15 PM, T?th D?nes wrote: >> Hi, >> >> A benchmarking study with an additional (data.table-based) solution. > > I don't think speed is the right benchmark (I do agree that correctness > is!). Well, agree, and sorry for the wording. It was really just an exercise and not a full

On 11/29/2017 04:15 PM, T?th D?nes wrote: > Hi, > > A benchmarking study with an additional (data.table-based) solution. I don't think speed is the right benchmark (I do agree that correctness is!). For the R-help list, maybe something about least specialized R knowledge required would be appropriate? I'd say there were some 'hard' solutions -- Michael (deep

Hey Ilio, I revisited the previous code i posted to you and fixed some things. This should let you collect as many studies as you like, controlled by the num_studies arg. If you try the below url in your browser you can see that it returns a "simpler" version of the link you posted. To get to this you need to hit F12 to open Developer Tools --> go to Network tab and click on the

Hi everyone, I've had automatic printer driver installation running fairly nicely for a while now, but getting the drivers for your newest printer to automatically install completely is a pain in the neck. Basically, everything works except for adding a new section to win.ini, and a registry entry for the printer. All the driver files get copied over, and the printer appears as one would

hi, All. I'm using R 1.2.2 on a linux box. I have very long labels on my y axis, and when I try to print them out, they always come out clipped so I can't see them. How do I change the margin for the y axis? I've tried mai and mar, but they don't seem to do anything... process.names <- c("Makeprod-data", "Makeprod-QMM", "Search",

My message is first in english (hope you'll understand it), et en fran?ais pour ceux qui le causent. --- ENGLISH --- Hi everybody, I've got a matter with my Samba server supplied by Debien 2.2r0. testparm returns there's no problem in smb.conf. It's in 'security = DOMAIN' mode. I've got 3 boxes : SERVEUR$, POSTE1$ and POSTE2$, and 6 users, all correctly added to

Hi all, I have installed samba on my IRIX 6.5 system and configured the smb.conf file but I get the following error each time I try to make a connection to the samba share: "You must supply a password to make this connection, Resource: \\topcondb\ipc$". I have added the Samba server to the NT domain and I have also created a user account that is common to the NT domain and the Topcondb

I have a network which consists of two subnets, each with a linux server providing Samba services. With the configuration listed below, I have successfully achieved Subnet B being able to browse Subnet A but, Subnet A cannot browse Subnet B (sharename not found). Is it a Samba configuration issue or is it DNS? (I have it fixed if I put an /etc/lmhosts file on Linux Server A that has the host

I have a permissions issue on a Samba DC running 3.5.6. UserA does not have permissions to write to file opened by UserB. Specifically, a file created by UserA gets 764 permissions and UserB can't write to the file until permissions are changed either on the server to +w for other or UserA changes the permissions on the file from Windows for Everyone to have write permissions. I have tried nt

Hi Could anyone please tell me what to do to resolve this error message? I tried to run a gam with the mgcv package and got the following error: "Error in qr.qty(qrc, sm$S[[1]]): NA/NaN/Inf in foreign function call (arg 5)" (I have 116 covariates, I'm using the "cr" basis to speed things up, the binomial family and, where necessary, have set the required k to lower than

Hi all, I have installed Samba on Irix 6.5 and I have modified the sample smb configuration file as shown below. I am having problem browsing the Samba from Windows 95 host, it asks me to supply the //servername/IPC$ password. Please assist. Regards, Kunle Olusanya ============================================================================ ==================== ; Configuration file for smbd. ;

Hi, I'm having a little problem with my samba print server. I'm running samba 2.2.1a on a redhat 7.1 distro. I want to use the print$ share, so I can upload print drivers from a windows 2000 machine. I configured the print$ part in the smb.conf, made the directory and the subdir W32X86. They all have the appropriate permissions. When I try to upload drivers for an existing printer,