Displaying 5 results from an estimated 5 matches for "pivott".
Did you mean:
pivot
2004 Jun 28
1
R client connection OLAP cube (SQL Analysis Services / PivotTable Service)
...L server 2000).
I am now trying to leverage some of the OLAP features to keep the data
intensive tasks on the DB server side and only keep the analytical tasks
within R (optimize use of memory). Is there any package that would allow to
connect to OLAP cubes (as a client to SQL Analysis Services PivotTable
Service) from an R session (similar to the RODBC package)?
Can this be done directly with special connection parameters (from R)
through the RODBC package or do I have to setup an intermediary XL table
(pivottable linked to the OLAP cube) and then connect to the XL data source
from R?
I w...
2011 Dec 03
1
pivot table help
...nd3 ind1
3 ind2 ind1
to
cluster ind1 ind2 ind3
1 1 1 0
2 1 0 1
3 1 1 0
Has anybody any idea how I can do this? I already tried alot of things with
pivottables (using cast()) But I think I'm missing out on something.
thank you
--
View this message in context: http://r.789695.n4.nabble.com/pivot-table-help-tp4155144p4155144.html
Sent from the R help mailing list archive at Nabble.com.
2004 Jul 01
0
MS OLAP -- RODBC to SQL Server "Slice Server" pass-through query to MS OLAP
...I am now trying to leverage some of the OLAP features to keep the data
> intensive tasks on the DB server side and only keep the analytical tasks
> within R (optimize use of memory). Is there any package that would allow
to
> connect to OLAP cubes (as a client to SQL Analysis Services PivotTable
> Service) from an R session (similar to the RODBC package)?
>
> Can this be done directly with special connection parameters (from R)
> through the RODBC package or do I have to setup an intermediary XL table
> (pivottable linked to the OLAP cube) and then connect to the XL...
2010 May 19
1
Why does my RPy2 program run faster on Windows?
...print "Fetching data"
t3=datetime.now()
for row in self.cursor.execute("select * from (select * from (
select co_code,dlyprice_date,dlyprice_close from feed_dlyprice P where
co_code in (%s,%s) ) DataTable PIVOT ( max(dlyprice_close) FOR co_code IN
([%s],[%s]) )PivotTable ) a order by dlyprice_date" %(cds,bm,cds,bm)):
d1.append(str(row[0]))
v1.append(row[1])
v2.append(row[2])
t4=datetime.now()
t1=datetime.now()
print "Calculating"
d1.pop(0)
d1vec = robjects.StrVector(d...
2018 May 24
2
Tabla dinamica R
Hola!
Solicito ayuda con un data frame relativamente grande ¿? del cual necesito
generar una tabla dinámica a la manera excel.
Si me pueden referenciar algún comando, paquete, pagina web y/o cualquier
ayuda que me puedan dar será muy bienvenida.
Lo que tengo que hacer es pasar de algo así:
NombreMunicipio NombreProvincia Categoria idMedicamento CodMedicamento
CodMedicamentoOL UnidadesEnvSec