Displaying 20 results from an estimated 300 matches similar to: "Merging dataframes"
2018 May 02
0
Merging dataframes
Thanks, Peter, Eivind and Lui
Sorry, I could not explain it properly in the first go. Trying to simplify it here with an example - Say I have two dataframes as below that are not equally-sized data frames:
Table_A:
Email Name Phone
abc at gmail.com<mailto:abc at gmail.com> John Chan 0909
bcd at yahoo.com<mailto:bcd at yahoo.com> Tim Ma
2018 May 02
2
Merging dataframes
Thanks - Peter, Eivind, Rui
Sorry, I perhaps could not explain it properly in the first go.
Trying to simplify it here with an example - Say I have two dataframes as
below that are NOT equally-sized data frames (i.e., number of columns are
different in each table):
Table_A:
Email Name Phone
abc at gmail.com John Chan 0909
bcd at yahoo.com Tim Ma
2018 May 02
0
Merging dataframes
Hi,
I'll coded your example into R code:
Table_A <- c('abc at gmail.com', 'John Chan', '0909')
Table_A <- rbind(Table_A, c('bcd at yahoo.com', 'Tim Ma', '89089'))
colnames(Table_A) <- c('Email', 'Name', 'Phone')
Table_A
Table_B <- c('abc at gmail.com', 'John Chan', 'M',
2018 May 01
0
Merging dataframes
Hello,
Is it something like this that you want?
x <- data.frame(a = c(1:3, 5, 5:10), b = c(1:7, 7, 9:10))
y <- data.frame(a = 1:10, b = 1:10)
which(x != y, arr.ind = TRUE)
Hope this helps,
Rui Barradas
On 5/1/2018 11:35 AM, Chintanu wrote:
> Hi,
>
>
> May I please ask how I do the following in R. Sorry - this may be trivial,
> but I am struggling here for this.
>
2012 Jul 27
3
Counting frequency within each range
Hi,
This is a simple problem, but for the life of me I cannot find the answer.
How to determine frequency within given ranges ?
I know that table() gives frequency, for example
a <- table(numbers)
> a
numbers
4 5 23 34 43 54 56 65 67 324 435 453 456 567 657
2 1 2 2 1 1 2 1 2 1 3 1 1 1 1
> as.data.frame(table(numbers))
numbers
2012 Mar 08
3
legend
Hi,
A very simple thing that I'm unable to do. I did look at the help but ....
While putting a legend on a plot, I don't wish to have the enclosing
border surrounding the words (as given below).
Tried to use the following, but didn't help :
legend (locator(1), border=FALSE, fill=FALSE, "Important ones")
legend (locator(1), border=NILL, fill=NILL, "Important
2011 Aug 15
2
A small nag
Hi,
I am not sure how to fix the following error.
LGD <- c(11.6, 12.3, 15.8, 33.1, 43.5, 51.3,
67.3, 84.9)
cor (x=(file [1:47231,3:10]), y= rep (LGD, 47231), method = "pearson")
Error in cor(x = (file[1:47231, 3:10]), y = rep(LGD, 47231), method =
"pearson") :
incompatible dimensions
> sessionInfo()
R version 2.13.0 (2011-04-13)
2008 Dec 03
3
Stable Samba for AIX5.1
Hello,
I need to upgrade Samba 2.2.2 to a stable Samba version compatible with
AIX5.1 . Need to know the samba version I need to download and apply.
Tito
2003 Feb 13
3
search contrasts tutorial
I'm looking for a tutorial or notes on the use of contrasts factor in
linear model in R,
I've found some mails and infos about in various documents about R,
but I've probably missed
a good review on this subject.
--
Robert Espesser
Laboratoire Parole et Langage UMR 6057, CNRS
29 Av. Robert Schuman 13621 AIX (FRANCE)
Tel: +33 (0)4 42 95 36 26 Fax: +33 (0)4 42 59 50
2012 Apr 11
1
Merging multiple .csv files
Hi all,
I wish to merge 24 .csv files, each having a common identifier-column
("Name") and do two things:
1. Retrieve the common one's. [Analogy: while merging 2-dataframes, similar
to using: merge (.... ,by="Name", all=FALSE) ]
2. Retrieve all, i.e., the union of the rows of 24 files. [again, somthing
like: merge (.... ,by="Name", all=TRUE) ]
On the web,
2013 Apr 15
1
Kruskal-Wallis
Hi,
I have got two groups of samples; and for every row, I wish to calculate
Kruskal-Wallis' p-value.
In the example below, and the stars (****) show where I am struggling to
design and put things together. Any help would be appreciated.
myFile <- data.frame(Sample_1a = 1:10, Sample_1b = 2:11, Sample_1c = 3:12,
Sample_2a=4:13, Sample_2b=7:16, row.names=LETTERS[1:10])
groups <- rep
2013 Jan 26
2
different legends in lattice panels
Hi listers,
I want to make lattice plots xyplots with the indication of legends
inside each panel with only the points and the lines actually ploted
inside each given panel according to the group(ing) factor.
The code below shows what I have achieved so far and I hope will make
clear what I want to have.
It seems to me that my solution is a very "dirty hack" and there
certainly is
2004 May 04
3
Smbd not running
Hi,
I installed Samba on Solaris to enable me print from the solaris
workstation to a windows print server.
When I start smbd and nmbd , smbd does not run but nmbd runs
2016 Dec 13
8
spec file frustration (rant)
I'm getting spec files from centos git which is really convenient when
the related source is easy to find. But some things - e.g. from a spec file
# How to create the source tarball:
#
# git clone git://git.fedorahosted.org/git/python-rhsm.git/
# cd client/python-rhsm
# tito build --tag python-rhsm-$VERSION-$RELEASE --tgz
Never used tito before, so I install it and try, and rather than
2010 May 17
1
Loess fit
Hi,
I wonder why my attempt to extend an existing loess fit to a new data set is
producing error. I was trying the following:
dat = read.csv(choose.files())
x = dat[,2]; y = dat[,1]
x.sort = sort(x)
y.loess = loess(y~x, span=0.75)
# For testing the above fit with a new dataset:
test = read.csv(choose.files()) # test data
new_x = test [,1]; new_y = test[,2]
new_x.sort = sort(new_x)
predicted
2012 Sep 24
2
Rows not common in dataframes
Hi,
I have two dataframes (Dataframe_A, Dataframe_B) with the same no. of
columns. The first column of both the dataframes contains unique names.
I wish to have Dataframe_A with the rows that are NOT common to
Dataframe_B.
With merge (), it is possible to get the common rows or to merge rows, but
I am not quite sure how to do it in a simpler way. Any help would be much
appreciated.
Thank you.
2012 Jul 31
2
Significance of correlation
Hi,
I understand that to test the significance of correlation between two
PAIRED variables, the function, cor.test () can be used. However, in my
case, I have tested the correlation (i.e., Correlation Coefficient, r)
between two independent (i.e, different) variables, and now I wish to test
for the statistical significance of the correlation. Could you please
suggest how I should do that.
Thank
2004 Mar 08
3
SIP registration fails
Thanks for the info so far. I am still trying to asterisk'ize my ML9.2
firewall box and can't get the external SIP registration to work. If I
hook up my Sipura directly to the WAN it registers OK.
This is the message I get from asterisk:
Mar 8 21:03:07 NOTICE[196621]: chan_sip.c:3140 sip_reg_timeout:
Registration for '263872@192.246.69.223' timed out, trying again
If tried
2003 Aug 13
1
stars graphs
Hi listers,
A few days ago I posted a question about the use of the stars function
on selected lines of a frame. Thanks to two helpers, a closer look at
the scale argument allowed to partially solve the problem. Yet I still
have a problem with stars.
Allow me to explain what I intend to do (sorry for my poor English and
the long post):
I want to graph an activity index of a fish during the day
2018 Jun 25
2
Transformar muchas variables factor en variables binarias de acuerdo a niveles
Buenas, compaƱeros.
Tengo una base de datos con bastantes variables todas medidas como factor,
quiero que todos los factores pasen a ser variables binarias en funciĆ³n de
sus valores.
En este ejemplo de Stackoverflow muestran como hacerlo con una variable:
https://stackoverflow.com/questions/33990760/converting-factors-to-binary-in-r
df <-data.frame(a = c(1,2,3), b = c(1,1,2), c =