Package GetLattesData

September 4, 2017

[This article was first published on R and Finance, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Downloading and reading bibliometric data from Lattes –

Lattes is the largest and unique platform for
academic curriculumns. There you can find information about the academic
work of ALL Brazilian scholars. It includes institution of PhD,
current employer, field of work, all publications metadata and many
more. It is an unique and reliable source of information for
bibliometric studies.

I’ve been working with Lattes data for some time. Here I present a short
list of papers that have used this data.

Package GetLattesData is a wrap up of the functions that I’ve been
using for acessing the dataset. It’s main innovation is the possibility
of downloading data directly from Lattes, without any kind of manual


The package is not yet in CRAN. It should be there in a couple of days.
In the meanwhile, you can install it using devtools.


Example of usage

Let’s consider a simple example of downloading information for a group
of scholars. I selected a couple of coleagues at my university. Their
Lattes id can be easilly found in Lattes
. After searching for a name, notice the
internet address of the resulting CV, such as
Lattes ID is the final 10 digit code of this address. In our case, it is

Since we all work in the business department of UFRGS, the quality of
our publications is locally set by the Qualis ranking of field
Qualis is the local journal ranking in Brazil. You can read more about
Qualis in Wikipedia and

Now, based on the two sets of information, vector of ids and field of
Qualis, we can use GetLattesData to download all up to date
information about the researchers:


# ids from EA-UFRGS
my.ids <- c('K4713546D3', 'K4440252H7', 
            'K4783858A0', 'K4723925J2')

# qualis for the field of management

l.out <- gld_get_lattes_data(id.vec = my.ids, field.qualis = field.qualis)

## Downloading file  /tmp/Rtmp9ODS2F/
## Downloading file  /tmp/Rtmp9ODS2F/
## Downloading file  /tmp/Rtmp9ODS2F/
## Downloading file  /tmp/Rtmp9ODS2F/
## Reading -  Marcelo Scherer Perlin  found 18  papers
## Reading -  Marcelo Brutti Righi    found 42  papers
## Reading -  João Luiz Becker    found 58  papers
## Reading -  Denis Borenstein    found 64  papers

The output my.l is a list with two items:


## [1] "tpesq"   "tpublic"

The first is a dataframe with information about researchers:

tpesq <- l.out$tpesq

## 'data.frame':    4 obs. of  9 variables:
##  $ name           : chr  "Marcelo Scherer Perlin" "Marcelo Brutti Righi" "João Luiz Becker" "Denis Borenstein"
##  $ last.update    : Date, format: "2017-08-29" "2017-08-02" ...
##  $ phd.institution: chr  "University of Reading" "Universidade Federal de Santa Maria" "University Of California At Los Angeles" "University of Strathclyde"
##  $ phd.start.year : chr  "2007" "2013" "1982" "1991"
##  $ phd.end.year   : chr  "2010" "2015" "1986" "1995"
##  $ country.origin : Factor w/ 1 level "Brasil": 1 1 1 1
##  $ Minor Field    : chr  "Administração" "Administração" "Administração" "Engenharia de Produção"
##  $ id.file        : chr  "" "" "" ""

and the second dataframe containing information about all publications,
including Qualis and SJR:

tpublic <- l.out$tpublic

## 'data.frame':    182 obs. of  13 variables:
##  $ name         : chr  "Marcelo Scherer Perlin" "Marcelo Scherer Perlin" "Marcelo Scherer Perlin" "Marcelo Scherer Perlin" ...
##  $ article.title: chr  "Análise do Perfil dos Acadêmicos e de suas Publicações Científicas em Administração" "The Brazilian scientific output published in journals: A study based on a large CV database" "THE FORECASTING POWER OF INTERNET SEARCH QUERIES IN THE BRAZILIAN FINANCIAL MARKET" "A multistage stochastic programming asset-liability management model: an application to the Brazilian pension fund industry" ...
##  $ year         : chr  "2017" "2017" "2017" "2017" ...
##  $ language     : chr  "Português" "Inglês" "Inglês" "Inglês" ...
##  $ journal.title: chr  "RAC. Revista de Administração Contemporânea (Impresso)" "Journal of Informetrics" "RAM. REVISTA DE ADMINISTRAÇÃO MACKENZIE (ONLINE)" "OPTIMIZATION AND ENGINEERING" ...
##  $ ISSN         : chr  "1415-6555" "1751-1577" "1678-6971" "1389-4420" ...
##  $   : chr  "62" "18" "184" "349" ...
##  $     : chr  "83" "31" "210" "368" ...
##  $ order.aut    : chr  "2" "1" "3" "3" ...
##  $ n.authors    : chr  "3" "5" "3" "5" ...
##  $ qualis       : chr  "A2" NA "B1" "A2" ...
##  $ SJR          : num  NA 2.029 NA 0.481 NA ...
##  $ H.SJR        : int  NA 50 NA 29 NA NA 45 NA NA NA ...

An application of GetLattesData

Based on GetLattesData and other packages, it is easy to create
academic reports for a large number of researchers. See next, where we
plot the number of publications for each researcher, conditioning on
Qualis ranking.


p <- ggplot(tpublic, aes(x = qualis)) +
  geom_bar(position = 'identity') + facet_wrap(~name) +
  labs(x = paste0('Qualis: ', field.qualis))

We can also use dplyr to do some simple assessment of academic


## Attaching package: 'dplyr'

## The following objects are masked from 'package:stats':
##     filter, lag

## The following objects are masked from 'package:base':
##     intersect, setdiff, setequal, union <- tpublic %>%
  group_by(name) %>%
  summarise(n.papers = n(),
            max.SJR = max(SJR, na.rm = T),
            mean.SJR = mean(SJR, na.rm = T),
            n.A1.qualis = sum(qualis == 'A1', na.rm = T),
            n.A2.qualis = sum(qualis == 'A2', na.rm = T),
            median.authorship = median(as.numeric(order.aut), na.rm = T ))

name n.papers max.SJR mean.SJR n.A1.qualis n.A2.qualis median.authorship
Denis Borenstein 64 3.674 1.3165610 22 15 2
João Luiz Becker 58 3.885 0.8090000 5 13 2
Marcelo Brutti Righi 42 1.767 0.3961111 6 14 1
Marcelo Scherer Perlin 18 2.029 0.7755000 2 3 1

To leave a comment for the author, please follow the link and comment on their blog: R and Finance. offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Search R-bloggers


Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)