similar to: Data frame "pivoting"

Displaying 20 results from an estimated 1000 matches similar to: "Data frame "pivoting""

2011 Mar 28
2
"Holes" in a data frame with time intervals
Good morning, I am facing a problem very easy to solve with a program, but not too easy (at least IMHO) with a "declarative" approach. I have a dataframe df with some information about bank branches with a validity time associated (start date/end date, format YYYY-MM-DD) to some attributes (for example number of employees assigned). The following example will clarify this
2012 Jun 15
1
R: Securities earning covariance
Good morning. I have a real fuzzy question to ask; we have a calculation engine which is composed by n virtual machines each of them with a jvm 2GB of memory on Linux Red Hat each of them with the "R" package which comes along with the Red Hat Linux distribution. We have now to increase the number of "nodes" trying to avoid to use new virtual or physical machines. So my
2008 Jun 05
2
Securities earning covariance
Good morning, I am a new R user and I am trying to learn how to use it. I am trying to solve this problem. I have a dataframe df of daily securities (for a year) earnings as follows: SEC_ID DAY EARNING IT0000001 20070101 5.467 IT0000001 20070102 5.456 IT0000001 20070103 4.954 IT0000001 20070104 3.456 .......................... IT0000002 20070101 1.456 IT0000002 20070102 1.345
2008 Jun 06
1
Agreggating data using external aggregation rules
Dear R experts, I am currently facing a tricky problem which I have read a lot about in the various R mailing lists without finding exactly what I need. I have a big data frame DF (about 2,000,000 rows) with 7 columns being variables and 1 being a measure (using reshape package nomeclature). There are no "duplicates" in it. Fot each of the variables I have some "rules" to
2008 Sep 18
1
Adding 1 month to a dataframe column
Dear R experts, I have a problem in modifying one column of a dataframe with a datatime format using a datetime operator. Here is my dataframe A: DATACONT PROVINCIA VALORE 1 2007-12-31 MI 1 2 2007-12-31 PV 2 3 2007-12-31 NA 3 4 2007-12-31 MI 4 5 2007-12-31 RM 5 6 2007-12-31 RM 6 7 2007-12-31 MI 7 8
2012 Jun 15
1
R under JVM
Dear all, first of all I apologize for not having changed the object. I just re-used an old email I sent some time ago. The let us go into the question. Our architecture is the following: A (set of) java programs running under a jvm that passes data and instructions to an R instance via RNI and at the end of the process extracts calculated data from R. The question is: can I
2007 Dec 21
0
malloc problem on smbd
Hi guys, I have samba 3.0.24 on AIX 5.3 ML 6 and sometimes in smbd.log, I found many entry like this : get_print_db: malloc fail ! To recover situation, smbd must be restarted. Any idea ? bye ** Le e-mail provenienti dalla Banca d'Italia sono trasmesse in buona fede e non comportano alcun vincolo ne' creano obblighi per la Banca stessa, salvo che cio' non sia espressamente
2015 Aug 22
3
sprintf error: "only 100 arguments allowed"
I'm trying to apply a function defined in the VW R docs, that attemps to convert a data.table object to Vowpal Wabbit format. In the process i'm getting the error in printf mentioned in the subject. The original function is here: https://github.com/JohnLangford/vowpal_wabbit/blob/master/R/dt2vw.R Below there is a small example that reproduces the error. The function works great with
2015 Aug 26
1
sprintf error: "only 100 arguments allowed"
Wouldn't it make sense to have this in the man page? The 8192-byte limitation for 'fmt' is mentioned but not this one. Thanks, H. On 08/25/2015 02:08 AM, Prof Brian Ripley wrote: > From the sources: > > #define MAXNARGS 100 > /* ^^^ not entirely arbitrary, but strongly linked to > allowing %$1 to %$99 !*/ > > > > On 22/08/2015 04:21, Martin
2008 Jul 14
2
long data frame selection error
Hello, I am trying to select the following headers from a data frame but when I try and run the command it executes halfway through and give me an error at V188 and V359. Temp <- data.frame(V4, V5, V6, V7, V8, V9, V10, V11, V12, V13, V14, V15, V16, V17, V18, V19, V20, V21, V22, V23, V24, V25, V26, V27, V28, V29, V30, V31, V32, V33, V34, V35, V36, V37, V38, V39, V40, V41, V42, V43, V44, V45,
2006 Feb 01
2
sort columns
Hi. I have a simple (I think) question My dataset have these variables: names(data) [1] "v1" "v2" "v3" "v4" "v5" "v6" "v7" "v8" "v9" "v10" "v11" "v12" "v13" "v14" "v15" "v16" "v17"
2011 Oct 27
1
preceding X. and X
Hello, Why do I get preceding "X." (that is a and X followed by a period) for negative numbers and an "X" for positive numbers when I read a csv file? Am I stuck with this? If so, how do I convert it to normal numbers? dat=read.csv(file_path) > dat [1] X0.0 X.0.240432350374 X0.355468069625 X.0.211469972378 X1.1812797415 X.0.227975150826
2004 Sep 15
3
Read.fwf
Dear List I have a fixed width file with variables of varying width. The help is pretty transparent for this feature, but I can't seem to figure out how I can make effective use of the package with my data. In my dataset, the first 80 columns are of width 1 followed by other variables with width larger than 1. I think the correct way to do this, by brute force, would be >
2009 Apr 04
1
Problem with sample()
Hi, I'm having a problem using sample() within a function. Basically I get an error reading: Error in sample(v, 1, prob = h) : non-positive probability Can anyone advise me as to the possible origin of this error? Here is my code #Discretised Gillespie algorithm function (From SMfSB, D.J. Wilkinson) gillespied=function (N, T=100, dt=1, ...) { tt=0 n=T%/%dt x=N$M
2015 Aug 25
0
sprintf error: "only 100 arguments allowed"
From the sources: #define MAXNARGS 100 /* ^^^ not entirely arbitrary, but strongly linked to allowing %$1 to %$99 !*/ On 22/08/2015 04:21, Martin Bel wrote: > I'm trying to apply a function defined in the VW R docs, that attemps to > convert a data.table object to Vowpal Wabbit format. In the process i'm > getting the error in printf mentioned in the subject.
2010 May 26
1
Linear Discriminant Analysis in R
Dear R gurus, Thank you all for continuous support and guidance -- learning without you would not be efficient. I have a question regarding LD analysis and how to best code it up in R. I have a file of (V52 and 671 time points across all columns) and another file of phonetic features (each vowel is aligned with a distinct binary sequence, i.e. E 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0 0 0 0
2007 Jul 17
1
distance function (analogue)
Hello R-Users, its again me with a question. I´m using R 2.5.0 on Mac Power Book running Mac OS X 10.4.10 I try to calculate distances betweeen two data tables looking like this V1 V2 V3 V4 V5 V6 V7 V8 V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19 V20 V21 V22 V23 V24 V25 V26 V27 V28 V29 V30 V31 V32 V33 V34 V35 V36 1 1 0 0 0 1 1 0 1 0 0 0 1 0 0 0 0 0 1 0 0
2013 Apr 27
11
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 they are 110 files in the list. Each file has several different columns and rows. My
2010 Apr 16
4
R loop.
Hi every one I?m new to R and I cant figure our how to use the loop to do the following task, any help would be very kind of every one. I have a file called (table3.txt) that contains over 1000 row and over 40 columns. So for example first row would look like that Deafness, EYA4, DIAPH1, MYO7A, TECTA, COL11A2, POU4F3, MYH9, ACTG1, MYO6 I want the loop stamens to loop thro each row
2008 Jun 06
6
Subsetting to unique values
I want to take the first row of each unique ID value from a data frame. For instance > ddTable <- data.frame(Id=c(1,1,2,2),name=c("Paul","Joe","Bob","Larry")) I want a dataset that is Id Name 1 Paul 2 Bob > unique(ddTable) Will give me all 4 rows, and > unique(ddTable$Id) Will give me c(1,2), but not accompanied by the name column.