Displaying 20 results from an estimated 100 matches similar to: "Joining R Local Dataset with Table from Database"
2023 Jun 04
2
Adding a numeric class to a data.frame
R-Help Community
How do I add a numeric class to a data .frame.
For example, I have calculated the following probabilities
1 2 3
0.0011566127 0.0009267028 0.0081623324
How would I add them back into my data.frame for example
My_df <- data.frame(col_1 = c('A', 'B', 'C')) such that I end up with
col_1
2010 Sep 06
1
combining collumns for data.frames
Hi
This question is far less simple than the title suggests, please read carefully, thanks.
I have 2 sets of data, both read into R
>data1<-read.table ("1.txt", header=T, sep="\t")
>data2<-read.table ("2.txt", header=T, sep="\t")
>data1
Taxon stage1 stage2 stage3 stage4
T1 0 0 1 1
T2 0
2024 Apr 18
1
Tidyverse/dplyr solution for filling values of a tibble/dataframe from a column with a nested list.
Hi experts.
I have a tibble? with a column containing a nested list (<list<list<double>>>? data type to be specific).
Looks something like the following (but in R/Arrow? format):
ID
Nestedvals
001
[[1]](1,0.1)[[2]](2,0.2)[[3]](3,0.3)[[4]](4,0.4)[[5]](5,0.5)
002
[[1]](1,0.1)[[2]](2,0.2)[[3]](3,0.3)[[4]](4,0.4)
003
[[1]](1,0.1)[[2]](2,0.2)[[3]](3,0.3)
004
[[1]](1,0.1)[[2]](2,0.2)
2011 Jul 20
4
R on Multicore for Linux
Hi all,
I have R installed on a box, which is running on a machine with 16 core and
Redhat - Linux. I am handling huge (size of dataset will be 5 GB) dataset.
Lets assume that my data is in the form of structured (multiple) logs. I
access the data by using all.files(). Since by default basic version of R
utilizes single core, the processing of my analysis code is taking too much
time. I got to
2011 Jul 25
2
Binding multiple data frames into single data frame
Hi all,
I have multiple data frames created with equal number of columns in each
data frame by using mclapply() on multicore processor. The data frames are
like DF[[1]], DF[[2]], ... DF[[150]]. Now i want to bind (Similar like
rbind()) all these data frames and create one single data frame called DF so
that i can have the complete data for further analysis. Can someone help me
in performing this
2011 Jul 14
5
Splitting one column value into multiple rows
Hi i have the data in the following format:
rent,100,1,common,674
pipe,200,0,usual,864
car,300,1,uncommon,392:jump,700,0,common,664
car,200,1,uncommon,864:snap,900,1,usual,746
stint,600,1,uncommon,257
pull,800,0,usual,594
where as i want the above 6 lines data into 8 lines as below (Spliting row 3
& 4 at : and sending to a new row):
rent,100,1,common,674
pipe,200,0,usual,864
2012 Sep 20
1
SQL query with Multicore option on R -linux
Hi all,
I have the following sql query that I am executing on a machine with single
core. I want to know how can I execute the same sqery on a maching that is
running with 4 cores. Please provide me the code.
NEW_TABLE <- rhive.query("SELECT A, B, COUNT(C) FROM TABLE_A WHERE
A>='01-01-2012'")
Also let me know how can I leverage only 2 / 3 cores of the machine.
2017 Oct 09
2
Incluir símbolo matemático en data frame
Muchas gracias Carlos.
Pero eso haría que el signo se muestre tal como se deba mostrar , es decir:
?
Manuel
El 9 de octubre de 2017, 1:46, Carlos Ortega <cof en qualityexcellence.es>
escribió:
> Puedes incluir estos signos en una columna nueva antes de cada una de las
> columnas numéricas.
> Que el data.frame tuviera esta pinta...
>
> Signo_1, Col_1, Signo_2, Col_2,
2017 Oct 09
2
Incluir símbolo matemático en data frame
Muchas gracias Jesús,
Por lo que veo hay que hacer una columna diferente para los símbolos, tal
como sugiere Carlos. No hay forma de ubicarlos en el mismo string,
acompañando al número?
Manuel
El 9 de octubre de 2017, 8:52, Jesús Para Fernández <
j.para.fernandez en hotmail.com> escribió:
> Con
>
> print("\u2265")
>
>
> lo consigues.
>
> Aqui tienes
2009 Aug 06
2
robots.txt
Hi all,
I have again noticed that the wiki does not really show up in search
results and wonder if it has any impact that robots.txt on
wiki.centos.org is empty.
Perhaps it should at least contain User-agent: * ?
Best Regards
Marcus
2004 Dec 29
0
dovecot_auth / pam_mysql login errors
I am getting this errors at the maillog file :
Dec 29 12:22:10 websrv dovecot-auth: pam_sm_authenticate called.
Dec 29 12:22:10 websrv dovecot-auth: host changed.
Dec 29 12:22:10 websrv dovecot-auth: database changed.
Dec 29 12:22:10 websrv dovecot-auth: dbuser changed.
Dec 29 12:22:10 websrv dovecot-auth: dbpasswd changed.
Dec 29 12:22:10 websrv dovecot-auth: table changed.
Dec 29 12:22:10 websrv
2005 Dec 31
1
can't switch off login debuggin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi there,
I tried the change from cyrus to dovecot. This was just some days ago
and I'm really happy. Just a little problem. For testing I switched on
some login debugging. Now I can't switch it off. Dovecot seems to ignore
the "no" in the config file.
<snip>
auth_verbose = no
auth_debug = no
</snip>
That is what I get
2006 Jun 08
7
How to make an OSX Finder in rails/AJAX?
I need to make a category browser that would allow nested categories. Is
there any receipe on that?
Currently, I use the :onchange event from one of the form element to
update the first select (out of 4-5 selects), but I dont know how to
elegantly reset all the child selects if I change the value from the
first.
All the categories are fetched from the DB and I would like a
2017 Oct 09
2
Incluir símbolo matemático en data frame
Estimados miembros de la lista,
Cómo se puede incluir. por ejemplo, el símbolo de menor o igual en un
data.frame para luego hacer un cuadro (table con kable in rmarkadown)?
columna1 <- c("a", "b", "c")
columna2 <- c(<= 0.3, 0.5, 0.8)
columna3 <- c(>=0.5, 0.6, 0.9)
cuadro <- data.frame(columna1, columna2, columna3)
kable(cuadro)
Manuel
--
2009 Feb 26
0
[cdr_odbc] error: Cannot insert the value NULL into column 'calldate'
Hi,
I am trying to get * log to mssql server. I have odbc and freetds
configured, but my insert query is missing calldate which is a NOT
NULL field in database schema.
cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed:
INSERT INTO cdr
(clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid)
VALUES
2007 Apr 28
0
[975] branches/wxruby2/wxwidgets_282/rake/rakemswin.rb: Correct spacing for link command; remove odbc and db_table which aren''t
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><style type="text/css"><!--
#msg dl { border: 1px #006 solid; background: #369; padding:
2009 Feb 27
1
Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available
Hi,
I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf
configured and modules.conf have
preload => res_odbc.so
preload => res_config_odbc.so
extconfig.conf has queue_log => odbc,asterisk.
When I start asterisk I get the following messages. The important one being:
Realtime mapping for 'queue_log' found to engine 'odbc', but the
engine is not available
2005 Feb 02
0
Re: VFS calls after disconnect
Hello,
Below is the sample code almost similar to the one in Samba Developers's
guide. I tested it with a win2k client for samba 3.0.2a on FreeBSD.
When the example_connect is called the second time by the same client
handle->data is null.
The test can be reproduced as follows-
1) search for the computer from windows explorer. Access the vfs share and
create directory or perform any other
2005 Sep 13
1
populating asterisk realtime tables from configfiles
Here is my file to parse and load extensions. No wise cracks about my
code....
DB.php is the Pear DB module. (pear.php.net)
<?php
include('DB.php');
$db_host = '';
$db_name = '';
$db_login = '';
$db_pass = '';
$db_table = 'extensions_table';
define(DBINFO,"mysql://$db_login:$db_pass@$db_host/$db_name");
$db =
2012 Aug 31
1
after_fork - ActiveRecord::AdapterNotSpecified
Hi all,
I''m fighting with the after_fork hook and my sinatra application. The Sinatra app is using active_record,
In my unciron.rb file I''m using
preload_app true
after_fork do |server, worker|
? defined?(ActiveRecord::Base) and
??? ActiveRecord::Base.establish_connection
End
but I always get the error:
ERROR -- : ActiveRecord::AdapterNotSpecified