similar to: How to delete an entire row, if a specific colum has the value of "#VALUE!"

Displaying 20 results from an estimated 10000 matches similar to: "How to delete an entire row, if a specific colum has the value of "#VALUE!""

2010 Aug 01
3
finding max value in a row and reporting colum name
Hi, Hopefully someone can point me in the right direction on how I would go about solving the following. I have some data and need to find the column name of the maximum value in each row. This could be the data... > a <- data.frame(x = rnorm(4), y = rnorm(4), z = rnorm(4)) > a x y z 1 1.6534561 0.11523404 0.2261730 2 -1.2274320 -0.24096054 1.5096028
2011 Apr 18
4
Deleting the last value of a vector
Hey guys, I've search a few threads about deleting a value from a vector, but no one has addressed this question so far. I want to delete the last value from a string of values I have: r = [ 1, 2, 3, 4, 5 ], and i want to make r2 = to [ 1, 2, 3, 4] So that r2 is just like r, except that it missing the final value. Thanks, -- View this message in context:
2011 Mar 30
1
CDR Mysql adaptive Colum
Hello folks, i installed asterisk 1.8 from repo: https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages And Looked at this article about CDR in mysl. http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql I installed asterisk-mysql pacakge from debian repo. The cdr in mysql is working, but i can not get cdr adaptive colums are not, i use this in my extension.conf exten =>
2017 Jul 01
0
How to replace match words whith colum name of data frame?
Dear ?, I'm sure that there are many ways to do what you want; here's one: > cbind(concept_df, category= + ifelse(apply( + sapply(chemical_df$chemical, + function(x) grepl(x, concept_df$concept)), + 1, any), + "chemical", "")) concept category 1 butan
2008 Mar 22
2
counting values on one colum only
Hi all: Can someone help me count the number of rows with values in colum "a" only. assume the name of my dataframe is "weekly" I was trying i<- nrows(weekly$a) i but returns 7 when it should be 4. Thanks a b c d 27.000 27.000 1.569 0.013 160.000 27.000 1.632 0.013 146.000 27.000 1.830 0.015 70.000 27.000 2.475 0.019
2007 May 29
2
summing up colum values for unique IDs when multiple ID's exist in data frame
I have data.frame's with IDs and multiple columns. B/c some of IDs showed up more than once, I need sum up colum values to creat a new dataframe with unique ids. I hope there are some cheaper ways of doing it... Because the dataframe is huge, it takes almost an hour to do the task. Thanks so much in advance! Young # ------------------------- examples are here and sum.dup.r is at the
2009 Nov 06
2
how can I delete those columes with the same element in every row?
e.g. a= a b c d e 1 1 1 3 1 1 2 1 2 3 4 5 3 1 3 3 8 3 4 1 4 3 3 5 5 1 1 3 1 1 I want to delete colume a and colume c, because they have the same values in every row, then ,I want to get this data.frame . b= b d e 1 1 1 1 2 2 4 5 3 3 8 3 4 4 3 5 5 1 1 1 the following is my code but it's wrong. rm(list=ls()) a=c(1,1,1,1,1); b=c(1,2,3,4,1); c=c(3,3,3,3,3);
2009 Feb 22
1
Filtering a data frame using a string for colum header
Hi all, I was just radomly playing with R and got the following error when trying to filter a data frame using a string: > Angel <- c(7,8,6,9,10) > Buffy <- c(8,9,4,9,10) > Firefly <- c(9,9,10,10,10) > DrHorrible <- c(10,9,9,10,10) > my.df <- data.frame(Angel, Buffy, Firefly, DrHorrible) > my.df["DrHorrible"] DrHorrible 1 10 2 9 3
2006 Jan 22
0
Get colum types in auto form
Hi all, I''m trying to build a routine that generates table rows with the appropriate field types (text_area and text_field for now), and filters out the ''created_at'' and ''deleted_at''. <% for column in Project.content_columns %> <tr class="ListLine<%= cycle("0","1") %>"> <td><%=
2017 Aug 01
0
How to replace match words whith colum name of data frame?Hi--
Hi-- concept_df$NewCol <- ""; kw <- "acid|ph"; bb <- grepl(kw,concept_df$concept) concept_df[dd,2] <- "chemical" The is a bit late but it accomplish the same with base R. Good luck--EK PS.. my email doesn't accept reply [[alternative HTML version deleted]]
2017 Jul 01
0
How to replace match words whith colum name of data frame?
I have two data frame. I want to use "chemical_df" to match "concept_df " concept_df <- data.frame(concept=c("butan acid ", "nano diamond particl", "slurri composit", "composit ph polis", " inorgan particl ", "grind liquid", "liquid formul", "nanoparticl", "size abras particl",
2017 Jul 30
0
How to replace match words whith colum name of data frame?
Try the stringr package. This should work chemical=c("basic", "alkalin", "alkali", "acid", " ph ", "hss") chemical_match <- str_c(chemical, collapse = "|") chemical_match concept_df$match[str_detect(concept_df$concept, chemical_match)] <- "chemical" concept_df > concept_df concept match
2009 Dec 04
1
Converting a Matrix in a colum vector
Hi all, Imagine I have a matrix G with N rows and M columns So L=NxM is the number of different cells in my matrix. I want to create a column vector F whose size will be F(L,1) So the fisrt row in F is G(1,1) Second row in F is G(1,2) When we arrive to a point M the element M+1 will be G(2, 1) Element M+2 will be G(2,2) and so on. I´m trying but allways error.... Easy Example: G= 2 3 4
2008 Jul 18
1
only "T" becomes logical colum with read.table
Hello, I am a biologist and I am dealing with files composed of columns with T or A or C or G (example below) Sometimes a column is composed of only "T" and in that case, the columns becomes a logical column TRUE (example below) I know that the argument "as.is" controls the turns off turning a column into a factor, instead becoming a character Is there something similar for
2011 Oct 25
2
extract data for specific levels factor
Dear all, I'm trying to analyze data with the following structure: ind cat tx age 40.2 por fol peq vh 35 41.9 por fol med vh 35 68.9 por fol preov vh 35 71.5 por fol peq ser 37 67.5 por fol med ser 37 76.9 por fol preov ser 37 78.7 por fol peq otr 37 78.3 por fol med otr 37 82.1 por fol
2011 May 06
2
no connection point for {33ad4f92-6699-11cf-b70c-00aa0060d39
Trying to run a certain game called Empyrean Challenge. The program is written in VB apparently. In the past, the program ran fine by installing via winetricks dcom98. Well, that has been removed from dcom98. Without dcom98, I get a Windows runtime error 438. The relevant message on the console, near as I can tell, is: fixme:ole:OLEPictureImpl_FindConnectionPoint no connection point for
2006 Nov 29
2
db:migrate to add colum bombs...
Hi I get the following when I try and run "rake db:migrate" (I"m running un Ubuntu linux) ********** code ********** (in /<home hidden>) == AddRpts: migrating ========================================================= -- add_column("rpts", :integer, {:limit=>3}) rake aborted! You have a nil object when you didn''t expect it! You might have expected an
2007 Sep 06
1
labelling specific points xyplot
Hello R-helpers, I'm trying to add labels to points in xyplot graphs, but I want lo label only those points which have a certain level of my grouping variable, and have encountered a few problems. An example dataframe that goes with the following code is at the end of this message. 1st step, adding labels (from another column in the dataframe) to my chosen points : I've figures this
2007 Oct 03
4
Secondary Dialtone and selecting a specific line from Zap/g
I need to select a line from the Zap group channel using the SIP Phone (not FXO and not FXS ports). ignorepat does not work? Also, what is the method to let the second dial tone has another tone frequency? Regards Bilal ---------------- No, ignorepat is for FXS ports (FXS ports use FXO signaling). Also, ignorepat does not apply to SIP phones, because SIP phones provide their own dialtone,
2007 Sep 30
1
Selecting a specific line from Zap/g
Dear List; How can I place a call via Zap/g1 (group) but need to determine the line (FXO port) that will go via it? Also, how it will be possible to assign an dedicated line (connected to FXO) to an button on the Polycom IP Phone or Broadtel IP Phone, so if user select that button then he will be sure that his outside call will be via that specific line. Regards Bilal