[prev in list] [next in list] [prev in thread] [next in thread] 

List:       r-help
Subject:    Re: [R] Help with clinical trials.gov AACT database
From:       bharat rawlley via R-help <r-help () r-project ! org>
Date:       2021-08-27 0:08:06
Message-ID: 1676597745.947961.1630022886660 () mail ! yahoo ! com
[Download RAW message or body]

 I am completely stuck here, any help would be greatly appreciated!
    On Thursday, 26 August, 2021, 04:18:31 pm GMT-4, bharat rawlley via R-help \
<r-help@r-project.org> wrote:    
 
  Hello, I am trying to use R to access the clinicaltrials.gov AACT database to \
create a list of facility_investigators for a specific topic.

The following code is an example of how to get a list of all clinical trials on the \
topic TP53 library(dplyr)
library(RPostgreSQL)

aact = src_postgres(dbname = 'aact',
                              host = "aact-db.ctti-clinicaltrials.org",
                              user = 'aact',
                              password = 'aact')
study_tbl = tbl(src=aact, 'studies')
x   = study_tbl %>% filter(official_title %like% '%TP53%') %>% collect()

Similarly, if I want a list of principal investigators,
library(dplyr)
library(RPostgreSQL)
aact = src_postgres(dbname = 'aact',
                              host = "aact-db.ctti-clinicaltrials.org",
                              user = 'aact',
                              password = 'aact')
study_tbl = tbl(src=aact, 'facility_investigators')

I am unable to make a list on only TP53 facility_investigators. Something like TP53 & \
facility_investigators. Any help would be appreciated

This is a link where some explanation is provided, but my problem is not resolved -  \
http://www.cancerdatasci.org/post/2017/03/approaches-to-accessing-clinicaltrials.gov-data/


Sent from Yahoo Mail on Android
       [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
  
	[[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.


[prev in list] [next in list] [prev in thread] [next in thread]