similar to: Joining R Local Dataset with Table from Database

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