similar to: sum multiple csv files

Displaying 20 results from an estimated 1000 matches similar to: "sum multiple csv files"

2018 Jan 15
0
sum multiple csv files
Your message seems unclear, and as evidence the respondents are giving various answers. You should provide a small sample of input and output data as it would look in R to avoid this kind of thrashing about. See [1][2][3] for guidance. Note that you also really need to figure out how to make sure your email program sends plain text, because HTML formatting WILL be stripped by the mailing list
2011 Nov 23
2
zeros to NA's - faster
Hello, Is there a faster way to do this? Basically, I'd like to NA all values in all_data if there are no 1's in the same column of the other matrix, iu. Put another way, I want to replace values in the all_data columns if values in the same column in iu are all 0. This is pretty slow for me, but works: all_data = matrix(c(1:9),3,3) colnames(all_data) =
2010 Jul 08
4
Duda con orden Cars93
Cordial saludo, Estoy haciendo una grafica de la base de datos Cars93 conde relaciono Manufacturer con Price con este codigo library(MASS) with(Cars93,plot(Manufacturer, Price, las=2, ylab="Precio (en $1,000)")) necesito el comando para que queden ordenados de manera ascendente como en la grafica 2, muchas gracias por su ayuda Grafica 1 [image: M-P.JPG] Grafica 2 [image: M-P
2024 Apr 16
5
read.csv
Dear R-developers, I came to a somewhat unexpected behaviour of read.csv() which is trivial but worthwhile to note -- my data involves a protein named "1433E" but to save space I drop the quote so it becomes, Gene,SNP,prot,log10p YWHAE,13:62129097_C_T,1433E,7.35 YWHAE,4:72617557_T_TA,1433E,7.73 Both read.cv() and readr::read_csv() consider prot(ein) name as (possibly confused by
2009 Apr 09
2
how to automatically select certain columns using for loop in dataframe
Hi, I am trying to display / print certain columns in my data frame that share certain condition (for example, part of the column name). I am using for loop, as follow: # below is the sample data structure all.data <- data.frame( NUM_A = 1:5, NAME_A = c("Andy", "Andrew", "Angus", "Alex", "Argo"), NUM_B = 1:5, NAME_B =
2004 Nov 25
3
Searching for a string in RSQLite
I'd like to search for a particular string in an SQLite database using RSQLite, but I'm running into problems constructing the query properly, because of embedded quotes and parens in the string. Is there a function that escapes these for me, or some other fixup that would let me do the queries below? In the real situation I don't have control over what strings get searched for.
2008 Dec 08
2
Permutation exact test to compare related series
I all, is there a way with R to perform an exact permutation test to replace the wilcoxon test to compare paired series and/or to perform pairwise multiple comparisons for related series after a Friedman test ? Thanks Gilles
2008 Sep 05
1
boxplot including null info from dataframe, not with SQLite dataframe
I have been trying to use R to gather some information from parsed log files (as part of examining some performance issues). I parsed the log files and put the data into an SQLite database, and then used RSQLite to load the data into R. The fields of interest are controller, action and total_time: controller and action have string values; total_time has a decimal value. I first did the
2011 Jul 06
1
Subset creates row_names column when exported to MYSQL
Dear R-helpers, I have a huge dataset and I create a filter selecting only the cases I want using: >data <- subset(data, data$var=='x' | data$var=='y' | data$var=='z' | ... ) The problem is, when i check my new data it doen't show a row_names column but when the data is exported to MYSQL (using RMYSQL) it creates a column row_names. I've already tried
2017 Aug 27
1
In Ops.factor(...) not meaningful for factors
Good evening! I don't know R, but I have to do this work for my diploma. So I'm sorry for the strange message below. Help me anybody decides this issues, please. a part of the code is: for (i in 1:133) { r_squared <- vector() sample_bank <- mydata[((i-1)*311+1):(i*311),] #return for bank return_bank <- diff(sample_bank[,4])/sample_bank[,4][-length(sample_bank[,4])] I've
2001 Jan 15
3
A QUESTION ABOUT TIME SERIES
Dear sirs, My name is Marcelo Grimaldi and i work for General Electric in the Six Sigma Program. Recently I became very interested in spectral analysis, because I think it can be applied to my job. I use Minitab 12 and i have heard that writing macros for spectral analysis in this software is very difficult. Could I perform this analysis in a easier way throught "R" ? Have you ever
2018 May 22
4
Pasar palabras de una lista a una variable del dataframe
Buenas tardes, Tengo una lista de 600 palabras. Quiero saber cuántas de esas palabras aparecen en cada observación de mi variable "texto". La variable "texto" es de tipo caracter. ¿Cómo lo haríais? Muchas gracias.
2024 Apr 16
1
read.csv
?s 11:46 de 16/04/2024, jing hua zhao escreveu: > Dear R-developers, > > I came to a somewhat unexpected behaviour of read.csv() which is trivial but worthwhile to note -- my data involves a protein named "1433E" but to save space I drop the quote so it becomes, > > Gene,SNP,prot,log10p > YWHAE,13:62129097_C_T,1433E,7.35 > YWHAE,4:72617557_T_TA,1433E,7.73 >
2018 May 23
2
Pasar palabras de una lista a una variable del dataframe
Muchas gracias Carlos, Me da error al hacerlo. Mi variable donde quiero que localice las palabras de la lista tiene más de una palabra, no se si puede ser por eso. Gracias El Mar, 22 de Mayo de 2018, 20:15, Carlos Ortega escribió: > Hola, > > Aquí tienes un ejemplo (reproducible)... > > #----------------------- >> # Generar nombres de mujer >> library(randNames)
2024 Apr 16
1
read.csv
Gene names being misinterpreted by spreadsheet software (read.csv is no different) is a classic issue in bioinformatics. It seems like every practitioner ends up encountering this issue in due time. E.g. https://pubmed.ncbi.nlm.nih.gov/15214961/ https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 https://www.nature.com/articles/d41586-021-02211-4
2003 Jul 03
2
unlist
Hi I have a list with several data.frames, all with the same number of colunms but different number of rows, and I'd like to transform this list into a single dataframe. I need to mimic an rbind of all dataframes ... Transform doesn't seem to work :-( Thanks EJ -- Ernesto Jardim <ernesto at ipimar.pt> Bi?logo Marinho/Marine Biologist IPIMAR - Instituto Nacional de Investiga??o
2007 May 25
2
xyplot: different scales accross rows, same scales within rows
Dear list members, I would like to set up a multiple panel in xyplots, with the same scale for all colunms in each row, but different accross rows. relation="free" would set up all x or y scales free... which is not what I want :-( Is this possible? Thank you in advance, Best wishes, Marta
2007 Apr 18
1
[Bridge] Re: Bridge Digest, Vol 31, Issue 6
Hello You must add first: vlan (tagged) to eth2 eth2 interface is not tagged by default and not know vlan-s . It is like a cisco if you have 24 ports in cisco by default all ports are in vlan1. if you want to do trunk (with vlans) you myst add (vlans) to this ports (tagged or untagged) So you can compare that all interfaces in linux by default are in one vlan(but not tagged). (only for
2017 Nov 17
3
Dataframe is character
Hi everybody, Question: why are my dataframe and numeric variables a character? I read an excel file via readxl but my dataframe is a character, and numeric variables, eg "yi", are also a character. My excelfile is in English numeric Sometimes the dataframe was indeed a dataframe, but I do not know why it did sometimes. Thank you in advance, Roberto PS I used "guess". The
2009 Jun 25
1
interaction terms formula error
Hi, I'm trying to fit a binary logistic regression model, and would like to consider certain characteristics B and C only for people with variable A=1 and not for those with variable A=0, so I'm trying to do the following: model<- lrm(formula= y ~ A: (B+C) + D + E +...) I've had no problem with adding interaction terms using " * ", but every time I try to use