[R-meta] Importing Correlations from PDF to table format

[Kiet Huynh]

Hi James,

Thank you for recommending these helpful packages. I was able to import the pdf correlation table into a dataframe format in R. Are you aware of any R code that could convert that correlation matrix dataframe into a meta-analysis type dataframe (i.e., a column for variable 1, a column for variable 2, and a column for correlation effect size)? 

Best,

Kiet

> On Feb 25, 2022, at 10:58 AM, James Pustejovsky <jepusto using gmail.com> wrote:
> 
> The pdftools package might be helpful:
> https://github.com/ropensci/pdftools <https://github.com/ropensci/pdftools>
> It has very low-level utilities for extracting text from pdf. You'd still have to do some data clean-up to get the correlations into the form needed for analysis.
> 
> The tabulizer package is meant to provide tools customized for working with pdf tables:
> https://github.com/ropensci/tabulizer <https://github.com/ropensci/tabulizer>
> But it requires Java and it appears to be archived on CRAN. I'm not sure what its development status is. Caveat emptor, I guess.
> 
> James
> 
> On Fri, Feb 25, 2022 at 12:20 PM Kiet Huynh <kietduchuynh using gmail.com <mailto:kietduchuynh using gmail.com>> wrote:
> Hello,
> 
> I was wondering if anyone knows of a way to automate in R (or any software) the process of importing correlation values from PDF to usable data in a table format that can be used in meta-analysis? My process has been to copy the correlations manually one-by-one from the PDF to excel (which takes a lifetime!), and then import the excel data into R. I'm sure there must be a better, faster, and less error-prone way to do this.
> 
> Thank you,
> 
> Kiet
> 
> ----
> 
> Kiet D. Huynh, Ph.D.
> Pronouns: he/him
> CLEAR Goldblum-Carr Postdoctoral Fellow
> Palo Alto University
> 1791 Arastradero Rd.
> Palo Alto, CA 94304
> 
> 
> 
> 
>         [[alternative HTML version deleted]]
> 
> _______________________________________________
> R-sig-meta-analysis mailing list
> R-sig-meta-analysis using r-project.org <mailto:R-sig-meta-analysis using r-project.org>
> https://stat.ethz.ch/mailman/listinfo/r-sig-meta-analysis <https://stat.ethz.ch/mailman/listinfo/r-sig-meta-analysis>


	[[alternative HTML version deleted]]