Question: help geometadb r package
1
gravatar for andreiareis1987
4.7 years ago by
andreiareis198730 wrote:

Hi guys,

I am new in Geometadb package in R!

I have been doing some tests to understand how it works geometadb. Well my goal its to join all the tables (gsm, gpl, gse and gds) and next filter the metadata... but now i am focus on looking for all variables and data to understand its right or not the number and if i filter the data some important data missing ...

I did this code to join two tables and its correct the output:

gsm_gpl <- dbGetQuery(con,paste("select * from gsm join gpl on gsm.gpl=gpl.gpl"))

but if i write this the output its wrong (number of variables and obs. data):

gse_gds <- dbGetQuery(con,paste("select * from gds join gse on gds.gse=gse.gse"))

Finally I "did" this code:

all <- paste("SELECT * ", "FROM", " gsm JOIN gse_gsm ON gsm.gsm=gse_gsm.gsm", " JOIN gse ON gse_gsm.gse=gse.gse", " JOIN gse_gpl ON gse_gpl.gse=gse.gse", " JOIN gpl ON gse_gpl.gpl=gpl.gpl", sep = " ")

rs <- dbGetQuery(con, all)

and the number of variables that i get and number obs. its not correct ...

Conclusion: i need urgent help to join all the tables that i said before, can anyone help me?

Thanks in advance.

Andreia

metadata R geometadb • 1.3k views
ADD COMMENTlink modified 2.1 years ago by RamRS30k • written 4.7 years ago by andreiareis198730

Hi Andreia. Did you solve this problem?

ADD REPLYlink written 4.0 years ago by Leandro Lima960
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 839 users visited in the last hour