Collaboration KPI Overview


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

Attaching package: 'lubridate'
The following objects are masked from 'package:base':

    date, intersect, setdiff, union

Attaching package: 'tidygraph'
The following object is masked from 'package:stats':

    filter
── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ forcats 1.0.1     ✔ readr   2.2.0
✔ purrr   1.2.2     ✔ tibble  3.3.1
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ tidygraph::filter() masks dplyr::filter(), stats::filter()
✖ dplyr::lag()        masks stats::lag()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors

Collaboration KPI Overview

This document provides an overview of the development of collaboration graphics and provides a status update for the project.

Objectives:

  • Provide information about number of publications within a year range.

  • Identify the number of papers that are collaborative (among any institutions).

  • For all publications, determine the

author list

author institution

author department

  • Filter down to only TAMU authors

  • Determine collaboration type at level of College

  • Determine collaboration type at level of Department

  • Circle packing figures

  • Extend to grants awarded and grants applied

Current Status:

Process

Retrieve 2025 Publication Data from Interfolio F180.

Parse author field and separate into separate line for each author using openalex.

Warning in value[[3L]](cond): Failed to fetch batch 7 from OpenAlex: OpenAlex
API request failed [400]
Warning in value[[3L]](cond): Failed to fetch batch 36 from OpenAlex: OpenAlex
API request failed [400]
Warning in value[[3L]](cond): Failed to fetch batch 45 from OpenAlex: OpenAlex
API request failed [400]
Warning in value[[3L]](cond): Failed to fetch batch 102 from OpenAlex: OpenAlex
API request failed [400]

For authors with missing affiliation, use check orcid id to determine affiliation.

Parse affiliation to find TAMU authors

Parse affiliation to determine Department and College

Filter out non-tamu authors

Identify collaborations among tamu authors

Using uid as the key, join results back to original dataset

Total Publications

8,272

Processed

1,729

Single Author

740

Create circle packing figure for all publications to distinguish single author from multiple author papers (one circle for each).

Warning: Expected 2 pieces. Additional pieces discarded in 33 rows [7, 12, 15, 24, 26,
28, 31, 33, 36, 38, 42, 44, 46, 47, 56, 57, 58, 59, 61, 63, ...].
Multiple parents. Unfolding graph