Create a Detailed Record Table

This function generates a formatted summary table using the gt package, which displays detailed counts for each citation source. The table includes columns for the number of records imported, distinct records, unique records, non-unique records, and various contribution percentages. Data from the function calculate_detailed_records is pre-formatted for this table.

Usage

create_detailed_record_table(data)

Arguments

data

A data frame containing the detailed counts for each citation source. The data frame must include the following columns:

• Source: The name of the citation source.

• Records Imported: The total number of records imported from the source.

• Distinct Records: The number of distinct records after deduplication within the source.

• Unique Records: The number of records unique to that source.

• Non-unique Records: The number of records found in at least one other source.

• Source Contribution %: The percentage contribution of each source to the total distinct records.

• Source Unique Contribution %: The percentage contribution of each source to the total unique records.

• Source Unique %: The percentage of records from each source that were unique.

Value

A gt table object summarizing the detailed record counts for each citation source.

Examples

sample_data <- data.frame(
  Source = c("Source1", "Source2", "Total"),
  `Records Imported` = c(100, 150, 250),
  `Distinct Records` = c(90, 140, 230),
  `Unique Records` = c(50, 70, 120),
  `Non-unique Records` = c(40, 70, 110),
  `Source Contribution %` = c("39.1%", "60.9%", "100%"),
  `Source Unique Contribution %` = c("41.7%", "58.3%", "100%"),
  `Source Unique %` = c("55.6%", "50%", "52.2%"),
  check.names = FALSE
)
create_detailed_record_table(sample_data)


  
Record Summary
    

      

        
Records
      
      

        
Uniqueness
      
      

        
Contribution to Total
      
      

        
Within-source Rate
      
    
Imported1
      
Distinct2
      
Unique3
      
Shared4
      
% of All Distinct5
      
% of All Unique6
      
Unique Rate7
    
Source1
100
90
50
40
39.1%
41.7%
55.6%
Source2
150
140
70
70
60.9%
58.3%
50%
Total
250
8 230
120
110
100%
100%
52.2%
1 Number of raw records imported from each database.
    
2 Number of records after internal source deduplication.
    
3 Number of records not found in another source.
    
4 Number of records found in at least one other source.
    
5 Percent distinct records contributed to the total number of distinct records.
    
6 Percent of unique records contributed to the total unique records.
    
7 Percentage of records from each source that were unique.
    
8 Total citations discovered (after internal and cross-source deduplication).