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