Displaying 20 results from an estimated 200 matches similar to: "Saving Splitted Series to Excel via XLConnect"
2015 Sep 17
2
Fwd: Creación fichero excel con loadWorkbook
>
>
> Hola chic en s,
>
> sigo intentando crear un archivo de Excel pero no hay manera. Sigo los pasos del documento de ayuda siguiente:
>
> http://altons.github.io/r/2015/02/13/quick-intro-to-xlconnect/#load
>
> los pasos que hago son:
>
> install.packages("XLConnect")
> require(XLConnect)
> wb <-
2016 Jul 26
7
Exportar datos en formato de Excel
Buenos días a todos!
Estoy trabajando con una base de datos que directamente he descargado de
internet y después de prepararla un poco necesito exportarla a Excel he
intentando con las dos opciones que mencionaré al final pero ninguna
funciona, de qué otra manera puedo exportar esos datos a Excel... muchas
gracias por su ayuda y pronta respuesta!
1)
library(xlsx)
library(rJava)
2016 Jul 26
3
Exportar datos en formato de Excel
Hola.
En mi caso, no he podido resolver los problemas con el Java para usar
XLConnect, que en los papeles me parece el mejor. Supongo que algo de la
arquitectura del sistema o bien de la relación entre el Java, el R y el
RStudio.
Así que utilizo
library(openxlsx)
write.xlsx(datos, file = "EDA1.xlsx") #donde datos es el objeto que quiero
guardar.
Requiere instalar el RTools, según tipo y
2012 Aug 06
2
Splitting Data Into Different Series
Dear R Community,
I'm trying to write a loop to split my data into different series. I
need to make a
new matrix (or series) according to the series code.
For instance, every time the "code" column assumes the value "433" I need to
save "date", "value", and "code" into the "dados433" matrix.
Please take a look at the following
2013 Feb 23
3
data.frame and import to xlsx
Hi,
i have a very huge number of data with the size 2375ko, i want to import
them for R to xlsx
but the size of excel is limited
How can i resolve this problem?
And please how can i define the frame
Note that i have a table
rows times c(1.....100) columns WLc(200...1000) and inside S c(15,.........)
the table it is full values
--
View this message in context:
2016 Apr 27
0
R Script Template
The subject of your email is missing. Perhaps you need to read the Posting Guide (again?) about attachments. Embedding your example directly in the body of the email is generally more accessible in archives than attaching it.
--
Sent from my phone. Please excuse my brevity.
On April 27, 2016 1:14:17 PM GMT+01:00, G.Maubach at gmx.de wrote:
>Hi All,
>
>I am addressing this post to all
2016 Apr 27
2
R Script Template
Hi All,
I am addressing this post to all who are new to R.
When learing R in the last weeks I took some notes for myself to have code snippets ready for the data analysis process. I put these snippets
together as a script template for future use. Almost all of the given command prototypes are tested. The template script contains snippets for best practices and leaves out the commands that
2006 May 18
3
just softphone
Hi,
I'm trying to start with Asterisk, but I could not put 2 softphones to talk.
The asterisk server rejects the connections always when I dial.
May 17 07:49:22 NOTICE[1924]: Rejected connect attempt from 192.168.0.106
What is necessary to put it to work?
There is no need to configure external lines.
extensions.conf
[internal1]
exten => 311000,1,Dial(SIP/teste1)
[internal2]
exten
2013 Apr 22
2
subset dataframe
I can't understand what is happening. This is the code and results:
> agoa <- read.table(file = "C:/Users/HTPC/Documents/_Documents/Research/WithDidia/AGOAUSImports.txt", header = T, sep = "\t", dec = ".", na.strings = "NA", stringsAsFactors = T)#
> str(agoa); names(agoa)
'data.frame':109 obs. of 19 variables:
$ X : Factor w/ 39
2016 Oct 25
4
Fix sharing ACL
Dear Rowland,
I changed smb.conf as its tip.
I had already read about the ACL's Windows and Posix.
Even changing the smb.conf and using the ACL methods, I still do not write access to the folder.
Example:
# mkdir /mnt/data/teste1
# ls -all /mnt/data/teste1
total 12
drwxrws---+ 2 administrator domain admins 6 Out 25 10:05 .
drwxrwxr-x+ 10 root domain admins 4096 Out 25
2011 Oct 17
2
Beginner's question about plotting variables in a time series object with the date on the x axis
Dear R helpers,
I am a beginner at R so please be gentle :)
I have already read manuals and FAQs, with no help.
I have a monthly time series data on public debt with 40 variables, it starts on January 1994 and ends on June 2011.
I am loading the data into R using read.csv and the data looks ok when I do edit(dados):
> dados<-read.csv("dadosR3.csv", header=T)
then I tried making
2006 Nov 20
1
g729 registered
Hi guys,
I've registered some g729 licenses, during register process everything
worked fine.
astk2*CLI> show g729
0/0 encoders/decoders of 20 licensed channels are currently in use
But I'm not able to use this codec. I'm trying to use a linksys PAP2 to talk
using g729 but I got this answer from asterisk:
Got SIP response 488 "Not Acceptable Here" back from
2007 Dec 31
1
SVM error
Hi all,
I'm having this error, since I'm working with a data matrix I don't understand what's happening; I've tried several ways to solve this, even working with sparse matrix, but nothing seems to solve it, I've also tried svm (with a simple matrix 3*3 and still got the same error.
> dados<-read.table("b.txt",sep="",nrows=30000)
>
2012 Sep 26
3
Reading multiple files
Hi,
I have 35 data files for reading. I would like get a program for
performing reading of 35 files at once.
All are of the type: Dados1.raw, Dados2.raw and so on.
If the files have the same number of columns, I can read with the
following commands:
rm(list=ls())
filenames = list.files(path="~/Silvano/Arq", pattern="Dados+.*raw")
names = substr(filenames, 1, 7)
for(i in
2012 Nov 07
8
Aggregate data frame across columns
Folks,
I have a data frame with columns 200401, 200402, ..., 201207, 201208.
These represent years/months. What would be the best way to sum these columns by year? What about by quarter?
Thanks for your time,
KW
--
[[alternative HTML version deleted]]
2009 Jun 12
2
Sweave recode(car) and Lyx, compiling but not executing on Mac
I am just beginning to use Sweave with Lyx on a Mac (R2.8.1). I have
12 chunks of Sweave code that work fine, but this piece:
<<>>=
library(car)
2010 Nov 17
3
stacking consecutive columns
I have a file, each column of which is a separate year, and each row of each column is mean precipitation for that month. Looks like this (except it goes back to 1964).
month X2000 X2001 X2002 X2003 X2004 X2005 X2006 X2007 X2008 X2009
1 1.600 1.010 4.320 2.110 0.925 3.275 3.460 0.675 1.315 2.920
2 2.960 3.905 3.230 2.380 2.720 1.880 2.430 1.380
2016 Oct 24
4
Fix sharing ACL
Gentlemen,
I am struggling to solve this problem.
My file server Samba 4.4.5.
Even the administrator user (domain admin) could not write to the share.
Could someone give me a hint, in order to solve this problem?
shared folder: /mnt/data
Folder permissions:
# getfacl /mnt/data/teste/
getfacl: Removing leading '/' from absolute path names
# file: mnt/data/teste/
# owner: ricardo
2006 Jan 16
2
New RPM packages for CentOS4.0
Greetings list,
It's been a while since I've been able to focus on asterisk packaging
but this weekend I took some time to audit and recompile packages for
CentOS 4.2. You can find them here.
ftp://ftp.linuxsys.com/ftp/pub/releases/CentOS-4.0
You have your choice of 1.2.1 or 1.0.10 releases. If you need zaptel
modules then install this kernel as well:
2011 May 30
0
Question of the XLConnect package
Hi Everybody
I have started to learn how to use the XLConnect package and I think it is
going to be very helpful to help me to operate between Excel users.
Is there a function that can export a dataframe to a Excel sheet and
automatically create a named region for every column (excluding the column
heading) that correspond to the column name? If this is possible one can
then also create formulae