similar to: dataframe: string operations on columns

Displaying 20 results from an estimated 8000 matches similar to: "dataframe: string operations on columns"

2011 Jan 12
3
Outputting csv file from dataframe with columns in a particular order
I have a dataframe with columns "ID",'date","estimate","actual" (but not necessarily in that order - I do a merge somewhere and that somehow messes up the order of the columns). How can I output it to a csv file with the columns in the order that I want? Thanks.
2010 Nov 29
2
Setting Values of Elements in a Dataframe
Dear All, I am experiencing some problems in resetting the values of some selected elements in a dataframe. Consider d<-seq(-1,1,length=16) dim(d)<-c(4,4) d<-as.data.frame(d) sel_pos<-which(d>0, arr.ind=TRUE) d[sel_pos]<- -9 which returns the error Error in `[<-.data.frame`(`*tmp*`, sel_pos, value = -9) : only logical matrix subscripts are allowed in replacement
2011 May 04
1
Str info. Thanks for helping
It looks from str(SA) that Response IPS1 is a data.frame of class "anova", which probably cannot be coerced to vector. Maybe you can use unlist() instead of as.vector() Or something like SA[["Response IPS1"]]["as.factor(WSD)",] ## to select the first row only, even maybe with unlist() Without a better REPRODUCIBLE example, I cannot tell more (maybe some others
2011 Feb 02
3
reshape data, adding rows to dataframe
Hello everyone, I have a data set like this: > head( fish_transect) ID_TRANSECT ID_PROJECT DE_ZONE DE_LOCALITY DE_SECTOR MES 1 42 MB Tarragona Creixell Control I 9 2 42 MB Tarragona Creixell Control I 9 3 42 MB Tarragona Creixell Control I 9 4 42 MB Tarragona Creixell Control I 9 5 42
2010 Dec 08
5
Summing up Non-numeric column
Dear All If I have the following dataset V1 V2 x y y x z b a c b j d l c o How do I use R command to get the total number of different letter in column "V1" column "V1" has 7 different letters. Thank you -- View this message in context: http://r.789695.n4.nabble.com/Summing-up-Non-numeric-column-tp3077710p3077710.html Sent from the R help mailing list archive
2011 Apr 20
2
user input
Dear users, I have looked on different sources and found different functions to prompt the user to provide input. However, I couldn't find one that does exactly what I'm looking for. select.list() and menu() are nice because a graphic window appears to prompt the user. However, the user can only choose from a predefined list of choices. readline() and scan() are more free in the
2010 Dec 13
7
descriptive statistics
Hi. In a data set I have a variable that takes values from 1 to 14. For each subgroup of values of this variable, I would like to obtain some descriptive statistics of other variables present in the data set. I've been trying with a "for" loop but I couldn't get nothing. Could you please suggest me some lines? -- View this message in context:
2011 Feb 28
2
converting the string columns in a data.frame to factors?
Dear All, I'm not sure if I understand the parameter stringsAsFactors correctly. I'm trying to convert the string columns in aframe1 to factors. But it seems stringsAsFactors=T in as.data.frame() doesn't do anything. Could anybody let know what is the correct way to converting strings to factors? > aframe1=data.frame(x=LETTERS[1:10], y=LETTERS[1:10], stringsAsFactors=F) >
2010 May 25
1
Merging dataframe with list
I often read SPSS system files (*.sav) into R using the 'read.spss' function from the 'foreign' library. To retain all the meta data, i.e. 'variable labels', I call the function like this: test.sav <- read.spss('http://www.cdc.gov/healthyYouth/shpps/2006/spss/envs2006.sav', to.data.frame=FALSE, use.value.labels=TRUE ) This returns a list, which is fine.
2010 Dec 06
1
Loading .RData from Internet
Dear All, Can you please suggest me a correct way to load the following R data frame from the internet and save it to the hard drive? The following is what I tried: > raceprofiling <- > read.table("http://rss.acs.unt.edu/Rdoc/library/twang/data/raceprofiling.RData") > save(raceprofiling, file = 'raceprofiling.RData') However, when I used dim() to check the dataset,
2010 Dec 07
3
string
Hi, I'm running R 2.11 Does anyone know if it possible to transform one character vector to one character string ? Many thanks Benoit -- Benoit Wastine Laboratoire des Sciences du Climat et de l?Environnement (LSCE/IPSL) CEA-CNRS-UVSQ CE Saclay Orme des merisiers B?t 703 - Pte 13A 91191 Gif sur Yvette Cedex France Tel : 33 (0)1 69 08 21 97 Fax : 33 (0)1 69 08 77 16
2011 Feb 02
1
combining vectors into list
Hi R users I have these two vectors: Row <- sample(1:25, 10) Col <- sample(1:25, 10) Is there a way to combine them into a list, whose first component is a vector containing the first element of Row and the first element of Col, the second component is a vector containing the second element of Row and the second element of Col, and so on... Thanks you Lorenzo
2011 Feb 28
1
Replacing an element in a vector
Dear R helpers I seem to have one trivial problem but can't find solution to it. Suppose I have following input. A = c(1,  3,  0,  5,  8)                  # 3rd element is 0 B = c(100, 30,  0,  25,  40)          # 3rd element is 0 C = A/B > C [1] 0.01 0.10  NaN 0.20 0.20 Obviously, I can't divide 0/0 and hence NaN. My problem is how to replace this NaN say by 0. So that I can
2011 Mar 09
1
Getting the source file's name where the custom function is written
Dear R experts, I've written some functions in a few source files (such as main.R, control.R ...). After loading them into R, how do I retrieve which functions are loaded from which source file? For example: main.R has functions: myPrint(), myScan() control.R has functions: setPrinter(), setData() After loading the sources (main.R and control.R) into R, I would want to know that
2011 Mar 10
1
How to use conditional statement
Dear R helpers Suppose val1 = c(10, 20, 35, 80, 12) val2 = c(3, 8, 11, 7) I want to select either val1 or val2 depending on value of third quantity val3. val3 assumes either of the values "Monthly" or "Yearly". If val3 = "Monthly", then val = val1 and if val3 = "Yearly", then val = val2. I tried the ifelse statement as ifelse(val3 =
2011 Mar 28
2
deleting the first two characters in each row of a factorized column
Hello, I'd like to ask you something again. I have a database and it has a column which looks like this one here: small_factor <- factor(c("d_variable1","d_variable2","d_variable3")) small_factor Now the thing is that I would like to convert each element of this factorized column. Basically I want to rewrite the words in it without the first two characters:
2011 Apr 19
1
Reducing dimension of a list object
Hi all, I generally use the Reduce() function to reduce the dimension of list object. However in my current session I have few objects which are actually list of list of list..(say n step). If I reduce their dimension then I have call Reduce() function many times. Therefore my question is, is there any 1-step way to reduce the dimension at the lowest level? Take this example: lis1 <-
2011 May 05
3
Remove all whitespaces
Hi I got a string that looks something like this 1 2 3 4 5 6 7 8 9 ... and I want it to be 123456789... So I want to remove all spaces (or whitespaces) from my string. Anyone know a good way of doing this? //Joel -- View this message in context: http://r.789695.n4.nabble.com/Remove-all-whitespaces-tp3497867p3497867.html Sent from the R help mailing list archive at Nabble.com.
2011 Mar 04
1
column removing under certain conditions
Dear collegues! Given a matrix, I would like to remove columns, that do not fulfill a certain condition. The condition is, that the median of the column is higher than a certain value. I've seen the help on removing NA columns, but I cannot figure out how to change the function part of the statement, so that the function is only TRUE if the median of the column is higher than x;
2011 Feb 03
2
how to read the "Sum Sq" - column from summary.aov()
Dear R-Users, I have a trivial problem, but extensive googling and ??'ing did not solve it: I want to obtain the sums of squares from a summary.aov() object for later use. Example: > DV <- rnorm(100) > IV1 <- as.factor(rep(c("male", "female"), times = 50)) > IV2 <- as.factor(rep(c("young", "old"), times = 50)) > >