vignettes/analyse-endnote.Rmd
analyse-endnote.Rmd
library(kwb.endnote)
endnote_xml <- kwb.endnote::default_xml()
references_df <- kwb.endnote::create_df_from_endnote_xml(endnote_xml) %>%
dplyr::filter(.data$ref_type_name != "Generic")
#> Reading '2020-06-17_KWB-documents.xml' in folder
#> '/Users/runner/work/_temp/Library/kwb.endnote/extdata' ... ok.
#> Joining, by = "record_id"
n_publications <- length(unique(references_df$record_id))The imported Endnote XML library 2020-06-17_KWB-documents.xml contains 952 which are analysed in detail in the following.
refs_by_type <- kwb.endnote::get_reference_type_names(endnote_xml) %>%
dplyr::count(.data$ref_type_name) %>%
dplyr::arrange(dplyr::desc(.data$n))
knitr::kable(refs_by_type)| ref_type_name | n |
|---|---|
| Conference Paper | 333 |
| Report | 280 |
| Journal Article | 202 |
| Thesis | 87 |
| Conference Proceedings | 24 |
| Book Section | 19 |
| Book | 7 |
endnote_list <- kwb.endnote::create_endnote_list(endnote_xml)
refs_df <- kwb.endnote::create_references_df(endnote_list)
p1 <- kwb.endnote::plot_pubs_by_year(refs_df)
plotly::ggplotly(p1)
refs_by_language <- refs_df %>%
dplyr::count(language) %>%
dplyr::mutate(percent = round(100*n/nrow(refs_df), 1))
knitr::kable(refs_by_language)| language | n | percent |
|---|---|---|
| de | 306 | 32.1 |
| en | 635 | 66.7 |
| fr | 10 | 1.1 |
| NA | 1 | 0.1 |
refs_with_abstract <- references_df %>%
dplyr::filter(.data$key1 == "abstract") %>%
dplyr::count(.data$record_id, .data$rec_number, .data$ref_type_name)
n_pubs_with_abstract <- nrow(refs_with_abstract)
### Percent of Publications with Abstracts
percent_pubs_with_abstracts <- round(100*nrow(refs_with_abstract)/n_publications,1) 62.2 percent (i.e. 592 / 952 publications) have an abstract.
refs_with_abstract_and_linebreaks <- refs_with_abstract %>%
dplyr::filter(.data$n > 1) %>%
dplyr::arrange(dplyr::desc(.data$n))
n_pubs_with_abstract_and_linebreaks <- nrow(refs_with_abstract_and_linebreaks)
knitr::kable(refs_with_abstract_and_linebreaks)| record_id | rec_number | ref_type_name | n |
|---|---|---|---|
| 443 | 536 | Thesis | 14 |
| 422 | 512 | Journal Article | 11 |
| 628 | 798 | Conference Proceedings | 11 |
| 615 | 768 | Conference Paper | 9 |
| 318 | 379 | Journal Article | 7 |
| 692 | 935 | Journal Article | 7 |
| 727 | 993 | Conference Paper | 6 |
| 37 | 48 | Report | 5 |
| 374 | 449 | Conference Paper | 5 |
| 653 | 835 | Conference Paper | 5 |
| 731 | 997 | Journal Article | 5 |
| 772 | 1044 | Conference Paper | 5 |
| 789 | 1062 | Thesis | 5 |
| 842 | 1128 | Conference Paper | 5 |
| 353 | 420 | Journal Article | 4 |
| 5 | 7 | Report | 3 |
| 380 | 455 | Report | 3 |
| 384 | 460 | Thesis | 3 |
| 525 | 640 | Conference Paper | 3 |
| 631 | 806 | Report | 3 |
| 729 | 995 | Thesis | 3 |
| 760 | 1031 | Conference Proceedings | 3 |
| 801 | 1075 | Report | 3 |
| 95 | 113 | Journal Article | 2 |
| 114 | 134 | Journal Article | 2 |
| 180 | 215 | Conference Paper | 2 |
| 281 | 328 | Conference Paper | 2 |
| 300 | 351 | Report | 2 |
| 392 | 468 | Thesis | 2 |
| 522 | 636 | Journal Article | 2 |
| 691 | 934 | Journal Article | 2 |
However there are some line breaks for these abstracts for in total 31 publications as shown in the table above.
These need to be corrected manually!
Is the accessibility level for the referenc defined in the fiel“caption” (confidential or not?)
refs_with_accessability_level <- refs_df %>%
dplyr::count(.data$caption) %>%
dplyr::mutate(percent = round(100*n/nrow(refs_df), 1))
n_pubs_with_accessability_level <- sum(refs_with_accessability_level$n[1:2])
percent_with_accessibility_level <- round(100*n_pubs_with_accessability_level/n_publications, 1)
is_confidential <- refs_with_accessability_level$caption=="confidential" & !is.na(refs_with_accessability_level$caption)
knitr::kable(refs_with_accessability_level)| caption | n | percent |
|---|---|---|
| confidential | 45 | 4.7 |
| public | 56 | 5.9 |
| NA | 851 | 89.4 |
Only for 101 (i.e. 10.6 percent) meta information on the accessibility level is explicitly defined, out of which 45 are defined as confidential (i.e. 4.7 of the publications with metadata on the accessibility level).
Recommendation:
Fill the field caption for all publications with either:
public or
confidential
Group references by “label” (i.e. “project names”)
refs_with_project <- refs_df[!is.na(refs_df$label),]
n_pubs_with_project_meta <- nrow(refs_with_project)
### in percent
percent_pubs_with_project_meta <- round(100*n_pubs_with_project_meta/n_publications,1)
unique_project_names <- refs_with_project %>%
dplyr::count(.data$label)
knitr::kable(unique_project_names)| label | n |
|---|---|
| abluft | 1 |
| amedeus | 7 |
| antiocker | 9 |
| aquanes | 12 |
| aquisafe-1 | 29 |
| aquisafe-2 | 18 |
| askuris | 7 |
| bephor | 1 |
| berlinbeach | 1 |
| biosens | 1 |
| carismo | 18 |
| carismo, codigreen, htc-berlin | 1 |
| circularagro | 1 |
| codigreen | 19 |
| compas | 2 |
| cosma | 9 |
| cylin | 14 |
| decamax | 3 |
| demeau | 16 |
| demoware | 12 |
| dswt | 3 |
| dw-biofilters | 1 |
| dwc | 1 |
| e-vent | 3 |
| ecotreat | 1 |
| enrem | 28 |
| enrem-plus | 1 |
| erdre | 2 |
| eva | 13 |
| flusshygiene | 3 |
| gstew | 1 |
| htc-berlin | 2 |
| htc-check | 7 |
| ic-nasri | 5 |
| ic-pharma | 2 |
| idb-india | 1 |
| imf | 13 |
| ism | 30 |
| ism, eva | 2 |
| ist4r | 9 |
| itzm | 1 |
| karolin | 2 |
| keys | 1 |
| kuras | 35 |
| mbr-train | 4 |
| merezon | 4 |
| mia-cso | 31 |
| monitor | 10 |
| nasri | 74 |
| networks4 | 16 |
| newfert | 3 |
| nextgen | 1 |
| nitrolimit | 13 |
| nostotox | 8 |
| nurec4org | 2 |
| odoco-1 | 1 |
| odoco-artnose | 5 |
| oemp | 2 |
| ogre | 22 |
| ogre, flusshygiene | 1 |
| oligo | 6 |
| optiwells-1 | 6 |
| optiwells-2 | 4 |
| oxeram-1 | 5 |
| oxeram-2 | 31 |
| oximar | 2 |
| oxired-1 | 3 |
| oxired-2 | 9 |
| p-pot | 1 |
| p-rex | 41 |
| pharmatreat | 1 |
| phorwaerts | 7 |
| pilotox | 3 |
| powerstep | 15 |
| pprp | 2 |
| prepared | 8 |
| prepared, wsstp | 1 |
| reef2w | 5 |
| riko | 7 |
| rkm | 10 |
| rwe-bo | 4 |
| sam-cso | 16 |
| saph-pani | 15 |
| scst | 16 |
| sema | 16 |
| sema-berlin-1 | 4 |
| sema-berlin-2 | 1 |
| senbao | 1 |
| smart-plant | 1 |
| spree2011 | 4 |
| t-mon | 6 |
| techneau | 31 |
| testtools | 4 |
| trace | 2 |
| ufo-wwv | 1 |
| wawi | 1 |
| wellma-1 | 14 |
| wellma-2 | 24 |
| wellma-dna | 5 |
| wsstp | 6 |
In total 92.9 percent (i.e. 884 / 952 publications) contain meta-information on the project. However, the spelling of project names does not follow a controlled vocabulary yet as can be seen in the table above.
Thus it is recommended to establish a controlled vocabulary for project identifiers according to the best-practices defined in the FAKIN project (see here).
refs_by_author_lastfirst <- references_df %>%
dplyr::filter(.data$key2 == "authors") %>%
dplyr::count(.data$value) %>%
dplyr::arrange(dplyr::desc(.data$n))
p2 <- kwb.endnote::plot_pubs_by_author(refs_by_author_lastfirst[1:50, ])
plotly::ggplotly(p2)Quite messy the figure above. Thus names should be entered in Endnote in the following format:
Lastname, Firstname
Also note the , also is an author! This is due to entering a wrong semicolon in the Endnote database and needs to be fixed here for at least the following entries:
pubs_with_semicolon_as_author <- references_df %>%
dplyr::filter(.data$key2 == "authors",
.data$value == ",") %>%
dplyr::count(.data$rec_number) %>%
dplyr::arrange(dplyr::desc(.data$n))
n_pubs_with_semicolon_as_author <- nrow(pubs_with_semicolon_as_author)
knitr::kable(pubs_with_semicolon_as_author)| rec_number | n |
|---|---|
| 239 | 1 |
In total 1 publications contain one or more semicolon authors. This needs to be fixed manually in the Endnote DB.
For now data-munging is needed to just use the authors` lastname for aggregating the data
refs_by_author_last <- references_df %>%
dplyr::filter(.data$key2 == "authors") %>%
dplyr::mutate(value = stringr::str_remove_all(.data$value, ",.*")) %>%
dplyr::mutate(value = stringr::str_remove_all(.data$value, "^\\w+\\.?\\s+")) %>%
dplyr::count(.data$value) %>%
dplyr::arrange(dplyr::desc(.data$n))
p3 <- kwb.endnote::plot_pubs_by_author(refs_by_author_last[1:50, ])
plotly::ggplotly(p3)Journal names need to be harmonised. Also needs to be checked what the differences between full-title and secondary-title of journal are.
Defined in: \(`record`\)periodical\(`full-title`\)style[[1]]
pubs_in_journals <- references_df %>%
dplyr::filter(.data$ref_type_name == "Journal Article")
n_pubs_in_journals <- length(unique(pubs_in_journals$record_id))
journal_title_full <- pubs_in_journals %>%
dplyr::filter(.data$key2 %in% c("full-title")) %>%
dplyr::mutate("source_field" = sprintf("%s_%s",.data$key1,
.data$key2)) %>%
dplyr::count(.data$value, .data$source_field)
knitr::kable(journal_title_full)| value | source_field | n |
|---|---|---|
| Acta hydrochimica et hydrobiologica | periodical_full-title | 2 |
| AMBIO. A Journal of the Human Environment | periodical_full-title | 1 |
| Applied and Environmental Microbiology | periodical_full-title | 1 |
| Applied Geochemistry | periodical_full-title | 1 |
| Aqua & Gas | periodical_full-title | 1 |
| Aqua Strategy | periodical_full-title | 1 |
| Aquatic Geochemistry | periodical_full-title | 1 |
| bbr Fachmagazin für Brunnen- und Leitungsbau | periodical_full-title | 4 |
| BfN Skripten | periodical_full-title | 1 |
| bluefacts | periodical_full-title | 5 |
| Bornimer Agrartechnische Berichte | periodical_full-title | 1 |
| Bundesgesundheitsblatt - Gesundheitsforschung - Gesundheitsschutz | periodical_full-title | 1 |
| Chemical Engineering Transactions | periodical_full-title | 1 |
| Chemie Ingenieur Technik | periodical_full-title | 3 |
| Chemosphere | periodical_full-title | 3 |
| Computers & Geosciences | periodical_full-title | 1 |
| Critical Reviews in Environmental Science and Technology | periodical_full-title | 1 |
| Desalination | periodical_full-title | 2 |
| Desalination and Water Treatment | periodical_full-title | 4 |
| DVGW Energie | Wasser-Praxis | periodical_full-title | 4 |
| Ecological Engineering | periodical_full-title | 1 |
| Environ Toxicology | periodical_full-title | 1 |
| Environmental Earth Sciences | periodical_full-title | 4 |
| Environmental Engineering Science | periodical_full-title | 1 |
| Environmental Geology | periodical_full-title | 1 |
| Environmental Science & Technology | periodical_full-title | 4 |
| Environmental Sciences Europe | periodical_full-title | 1 |
| Ernst & Sohn Regenwasser-Management | periodical_full-title | 2 |
| Ernst & Sohn Special 2019 - Regenwasser-Management | periodical_full-title | 1 |
| fbr-Wasserspiegel | periodical_full-title | 1 |
| FEMS Microbiology | periodical_full-title | 1 |
| Fertilizer International | periodical_full-title | 1 |
| Filtration+Separation | periodical_full-title | 1 |
| Gebäudegrün | periodical_full-title | 1 |
| German American Water Technology Magazine | periodical_full-title | 1 |
| green facts | periodical_full-title | 1 |
| Groundwater | periodical_full-title | 1 |
| Groundwater Monitoring & Remediation | periodical_full-title | 2 |
| Grundwasser - Zeitschrift der Fachsektion Hydrogeologie | periodical_full-title | 2 |
| GWF Wasser/Abwasser | periodical_full-title | 4 |
| Harmful Algae | periodical_full-title | 1 |
| Humuswirtschaft & Kompost aktuell | periodical_full-title | 2 |
| Hydrogeology Journal | periodical_full-title | 2 |
| Hydrological Processes | periodical_full-title | 1 |
| Hydroplus | periodical_full-title | 1 |
| HyWa Hydrologie und Wasserbewirtschaftung | periodical_full-title | 1 |
| ICUD | periodical_full-title | 1 |
| IGB Jahresforschungsbericht | periodical_full-title | 2 |
| International Journal of Environmental Science and Technology | periodical_full-title | 1 |
| International Journal of Systematic and Evolutionary Microbiology | periodical_full-title | 1 |
| IWA Specialist group on diffuse pollution. Newsletter | periodical_full-title | 1 |
| IWA Water Research | periodical_full-title | 6 |
| IWA Water Reuse Newsletter July 2011 | periodical_full-title | 1 |
| Journal of Environmental Sciences | periodical_full-title | 1 |
| Journal of Hazardous Materials | periodical_full-title | 1 |
| Journal of Hazardous, Toxic, and Radioactive Waste | periodical_full-title | 1 |
| Journal of Hydroinformatics | periodical_full-title | 1 |
| Journal of Hydrology | periodical_full-title | 2 |
| Journal of Plankton Research | periodical_full-title | 1 |
| Journal of Soils and Sediments | periodical_full-title | 1 |
| Journal of Water and Climate Change | periodical_full-title | 1 |
| Journal of Water and Health | periodical_full-title | 1 |
| KA Korrespondenz Abwasser, Abfall | periodical_full-title | 14 |
| KW Korrespondenz Wasserwirtschaft | periodical_full-title | 2 |
| Lake and Reservoir Management | periodical_full-title | 1 |
| Limnology and Oceanography | periodical_full-title | 2 |
| Mitt Umweltchem Ökotox | periodical_full-title | 1 |
| Mittendrin | periodical_full-title | 1 |
| Naturnahe Pufferzonen als Gewässerschutzmodelle | periodical_full-title | 1 |
| Neue Landschaft | periodical_full-title | 1 |
| Oecologia | periodical_full-title | 1 |
| Phycologia | periodical_full-title | 1 |
| ReSource | periodical_full-title | 1 |
| Science of the Total Environment | periodical_full-title | 1 |
| Springer Professional, Online Article | periodical_full-title | 1 |
| Structure and Infrastructure Engineering | periodical_full-title | 1 |
| Sustainability | periodical_full-title | 1 |
| Sustainable Water Resources Management | periodical_full-title | 1 |
| Toxicology letters | periodical_full-title | 1 |
| Toxicon | periodical_full-title | 4 |
| Umweltmagazin | periodical_full-title | 1 |
| Urban Water Journal | periodical_full-title | 2 |
| VDI Nachrichten | periodical_full-title | 1 |
| Vom Wasser | periodical_full-title | 1 |
| Wasser und Abfall | periodical_full-title | 1 |
| wasserwirtschaft wassertechnik | periodical_full-title | 2 |
| Water | periodical_full-title | 1 |
| Water & Wastewater International | periodical_full-title | 4 |
| Water Environmental Research | periodical_full-title | 1 |
| Water Practice & Technology | periodical_full-title | 3 |
| Water Research | periodical_full-title | 11 |
| Water Resources Management | periodical_full-title | 1 |
| Water Resources Research | periodical_full-title | 2 |
| Water Science & Technology | periodical_full-title | 16 |
| Water Science & Technology Water Supply | periodical_full-title | 1 |
| World of Mining | periodical_full-title | 1 |
| wwt Modernisierungsreport 2019/20 | periodical_full-title | 1 |
| wwt Wasserwirtschaft Wassertechnik | periodical_full-title | 11 |
Defined in: \(`record`\)titles\(`secondary-title`\)style[[1]]
journal_title_secondary <- pubs_in_journals %>%
dplyr::filter(.data$key2 %in% c("secondary-title")) %>%
dplyr::mutate("source_field" = sprintf("%s_%s",.data$key1,
.data$key2)) %>%
dplyr::count(.data$value, .data$source_field)
knitr::kable(journal_title_secondary)| value | source_field | n |
|---|---|---|
| Acta hydrochimica et hydrobiologica | titles_secondary-title | 2 |
| AMBIO. A Journal of the Human Environment | titles_secondary-title | 1 |
| Applied and Environmental Microbiology | titles_secondary-title | 1 |
| Applied Geochemistry | titles_secondary-title | 1 |
| Aqua & Gas | titles_secondary-title | 1 |
| Aqua Strategy | titles_secondary-title | 1 |
| Aquatic Geochemistry | titles_secondary-title | 1 |
| bbr Fachmagazin für Brunnen- und Leitungsbau | titles_secondary-title | 4 |
| BfN Skripten | titles_secondary-title | 1 |
| bluefacts | titles_secondary-title | 5 |
| Bornimer Agrartechnische Berichte | titles_secondary-title | 1 |
| Bundesgesundheitsblatt - Gesundheitsforschung - Gesundheitsschutz | titles_secondary-title | 1 |
| Chemical Engineering Transactions | titles_secondary-title | 1 |
| Chemie Ingenieur Technik | titles_secondary-title | 3 |
| Chemosphere | titles_secondary-title | 3 |
| Computers & Geosciences | titles_secondary-title | 1 |
| Critical Reviews in Environmental Science and Technology | titles_secondary-title | 1 |
| Desalination | titles_secondary-title | 2 |
| Desalination and Water Treatment | titles_secondary-title | 4 |
| DVGW Energie | Wasser-Praxis | titles_secondary-title | 4 |
| Ecological Engineering | titles_secondary-title | 1 |
| Ecological Engineering | titles_secondary-title | 1 |
| Environ Toxicology | titles_secondary-title | 1 |
| Environmental Earth Sciences | titles_secondary-title | 4 |
| Environmental Engineering Science | titles_secondary-title | 1 |
| Environmental Geology | titles_secondary-title | 1 |
| Environmental Science & Technology | titles_secondary-title | 4 |
| Environmental Sciences Europe | titles_secondary-title | 1 |
| Ernst & Sohn Regenwasser-Management | titles_secondary-title | 2 |
| Ernst & Sohn Special 2019 - Regenwasser-Management | titles_secondary-title | 1 |
| fbr-Wasserspiegel | titles_secondary-title | 1 |
| FEMS Microbiology | titles_secondary-title | 1 |
| Fertilizer International | titles_secondary-title | 1 |
| Filtration+Separation | titles_secondary-title | 1 |
| Gebäudegrün | titles_secondary-title | 1 |
| German American Water Technology Magazine | titles_secondary-title | 1 |
| green facts | titles_secondary-title | 1 |
| groundwater | titles_secondary-title | 1 |
| Groundwater Monitoring & Remediation | titles_secondary-title | 2 |
| Grundwasser - Zeitschrift der Fachsektion Hydrogeologie | titles_secondary-title | 2 |
| GWF Wasser/Abwasser | titles_secondary-title | 4 |
| Harmful Algae | titles_secondary-title | 1 |
| Humuswirtschaft & Kompost aktuell | titles_secondary-title | 2 |
| Hydrogeology Journal | titles_secondary-title | 2 |
| Hydrological Processes | titles_secondary-title | 1 |
| Hydroplus | titles_secondary-title | 1 |
| HyWa Hydrologie und Wasserbewirtschaftung | titles_secondary-title | 1 |
| ICUD | titles_secondary-title | 1 |
| IGB Jahresforschungsbericht | titles_secondary-title | 2 |
| International Journal of Environmental Science and Technology | titles_secondary-title | 1 |
| International Journal of Systematic and Evolutionary Microbiology | titles_secondary-title | 1 |
| IWA Specialist group on diffuse pollution. Newsletter | titles_secondary-title | 1 |
| IWA Water Research | titles_secondary-title | 6 |
| IWA Water Reuse Newsletter July 2011 | titles_secondary-title | 1 |
| Journal of Environmental Management | titles_secondary-title | 1 |
| Journal of Environmental Sciences | titles_secondary-title | 1 |
| Journal of Hazardous Materials | titles_secondary-title | 1 |
| Journal of Hazardous, Toxic, and Radioactive Waste | titles_secondary-title | 1 |
| Journal of Hydroinformatics | titles_secondary-title | 1 |
| Journal of Hydrology | titles_secondary-title | 2 |
| Journal of Plankton Research | titles_secondary-title | 1 |
| Journal of Soils and Sediments | titles_secondary-title | 1 |
| Journal of Water and Climate Change | titles_secondary-title | 1 |
| Journal of Water and Health | titles_secondary-title | 1 |
| KA Korrespondenz Abwasser, Abfall | titles_secondary-title | 14 |
| KW Korrespondenz Wasserwirtschaft | titles_secondary-title | 2 |
| Lake and Reservoir Management | titles_secondary-title | 1 |
| Limnology and Oceanography | titles_secondary-title | 2 |
| Mitt Umweltchem Ökotox | titles_secondary-title | 1 |
| Mittendrin | titles_secondary-title | 1 |
| Naturnahe Pufferzonen als Gewässerschutzmodelle | titles_secondary-title | 1 |
| Neue Landschaft | titles_secondary-title | 1 |
| Oecologia | titles_secondary-title | 1 |
| Phycologia | titles_secondary-title | 1 |
| ReSource | titles_secondary-title | 1 |
| Science of the Total Environment | titles_secondary-title | 1 |
| Springer Professional, Online Article | titles_secondary-title | 1 |
| Structure and Infrastructure Engineering | titles_secondary-title | 1 |
| Sustainability | titles_secondary-title | 1 |
| Sustainable Water Resources Management | titles_secondary-title | 1 |
| Toxicology letters | titles_secondary-title | 1 |
| Toxicon | titles_secondary-title | 4 |
| Umweltmagazin | titles_secondary-title | 1 |
| Urban Water Journal | titles_secondary-title | 2 |
| VDI Nachrichten | titles_secondary-title | 1 |
| Vom Wasser | titles_secondary-title | 1 |
| Wasser und Abfall | titles_secondary-title | 1 |
| wasserwirtschaft wassertechnik | titles_secondary-title | 2 |
| Water | titles_secondary-title | 1 |
| Water & Wastewater International | titles_secondary-title | 4 |
| Water Environmental Research | titles_secondary-title | 1 |
| Water Practice & Technology | titles_secondary-title | 3 |
| Water Research | titles_secondary-title | 11 |
| Water Research | titles_secondary-title | 1 |
| Water Resources Management | titles_secondary-title | 1 |
| Water Resources Research | titles_secondary-title | 2 |
| Water Science & Technology | titles_secondary-title | 16 |
| Water Science & Technology Water Supply | titles_secondary-title | 1 |
| World of Mining | titles_secondary-title | 1 |
| wwt Modernisierungsreport 2019/20 | titles_secondary-title | 1 |
| wwt Wasserwirtschaft Wassertechnik | titles_secondary-title | 11 |
All 202 journal articles should have an DOI. Let`s check for how many we have this metadata:
has_doi <- pubs_in_journals %>%
dplyr::filter(.data$key1 == "electronic-resource-num",
.data$value != "")
n_pubs_in_journals_with_doi <- nrow(has_doi)
knitr::kable(has_doi)| record_id | key1 | key2 | key3 | key4 | value | rec_number | ref_type_id | ref_type_name |
|---|---|---|---|---|---|---|---|---|
| 21 | electronic-resource-num | style | 10.2166/wst.2005.0457 | 28 | 17 | Journal Article | ||
| 42 | electronic-resource-num | style | 10.1016/S0015-1882(06)71005-9 | 54 | 17 | Journal Article | ||
| 44 | electronic-resource-num | style | 10.1016/j.desal.2005.04.130 | 57 | 17 | Journal Article | ||
| 46 | electronic-resource-num | style | 10.1016/j.toxicon.2008.07.017 | 59 | 17 | Journal Article | ||
| 47 | electronic-resource-num | style | 10.1002/tox.20230 | 60 | 17 | Journal Article | ||
| 48 | electronic-resource-num | style | 10.1016/j.toxicon.2005.10.013 | 61 | 17 | Journal Article | ||
| 49 | electronic-resource-num | style | 10.1016/j.toxicon.2007.06.019 | 62 | 17 | Journal Article | ||
| 50 | electronic-resource-num | style | 10.1016/j.hal.2008.02.010 | 63 | 17 | Journal Article | ||
| 51 | electronic-resource-num | style | 10.2216/05-58.1 | 64 | 17 | Journal Article | ||
| 52 | electronic-resource-num | style | 10.1007/s00442-007-0683-5 | 65 | 17 | Journal Article | ||
| 58 | electronic-resource-num | style | 10.1002/cite.200390121 | 72 | 17 | Journal Article | ||
| 60 | electronic-resource-num | style | 10.1016/S0011-9164(02)00762-2 | 74 | 17 | Journal Article | ||
| 62 | electronic-resource-num | style | 10.2166/wst.2005.0723 | 76 | 17 | Journal Article | ||
| 64 | electronic-resource-num | style | 10.1016/j.watres.2005.11.028 | 79 | 17 | Journal Article | ||
| 65 | electronic-resource-num | style | 10.1016/j.watres.2005.05.049 | 80 | 17 | Journal Article | ||
| 67 | electronic-resource-num | style | 10.2175/106143006X111826 | 82 | 17 | Journal Article | ||
| 72 | electronic-resource-num | style | 10.1002/aheh.200400543 | 89 | 17 | Journal Article | ||
| 73 | electronic-resource-num | style | 10.2166/wst.2004.0127 | 90 | 17 | Journal Article | ||
| 79 | electronic-resource-num | style | 10.1021/es052506t | 96 | 17 | Journal Article | ||
| 80 | electronic-resource-num | style | 10.1029/2005WR004095 | 97 | 17 | Journal Article | ||
| 85 | electronic-resource-num | style | 10.1007/s00103-007-0161-6 | 102 | 17 | Journal Article | ||
| 93 | electronic-resource-num | style | 10.1111/j.1745-6592.2004.tb00714.x | 111 | 17 | Journal Article | ||
| 95 | electronic-resource-num | style | 10.1016/S0378-4274(02)00041-3 | 113 | 17 | Journal Article | ||
| 98 | electronic-resource-num | style | 10.1016/j.cageo.2006.01.009 | 116 | 17 | Journal Article | ||
| 99 | electronic-resource-num | style | 10.1016/j.apgeochem.2005.03.002 | 117 | 17 | Journal Article | ||
| 100 | electronic-resource-num | style | 10.1016/j.watres.2005.05.030 | 118 | 17 | Journal Article | ||
| 110 | electronic-resource-num | style | 10.1016/j.chemosphere.2007.12.017 | 129 | 17 | Journal Article | ||
| 111 | electronic-resource-num | style | 10.1016/j.chemosphere.2007.12.017 | 131 | 17 | Journal Article | ||
| 113 | electronic-resource-num | style | 10.1007/s00767-007-0036-7 | 133 | 17 | Journal Article | ||
| 114 | electronic-resource-num | style | 10.1002/hyp.6649 | 134 | 17 | Journal Article | ||
| 117 | electronic-resource-num | style | 10.1016/j.jhydrol.2005.12.009 | 137 | 17 | Journal Article | ||
| 119 | electronic-resource-num | style | 10.1016/j.jhydrol.2008.07.004 | 139 | 17 | Journal Article | ||
| 127 | electronic-resource-num | style | 10.1111/j.1745-6592.2004.tb00715.x | 147 | 17 | Journal Article | ||
| 128 | electronic-resource-num | style | 10.1080/07438140709354024 | 148 | 17 | Journal Article | ||
| 129 | electronic-resource-num | style | 10.1002/aheh.200500632 | 149 | 17 | Journal Article | ||
| 130 | electronic-resource-num | style | 10.2166/wst.2006.833 | 150 | 17 | Journal Article | ||
| 147 | electronic-resource-num | style | 10.1016/j.watres.2009.01.007 | 180 | 17 | Journal Article | ||
| 200 | electronic-resource-num | style | 10.2166/wst.2008.289 | 235 | 17 | Journal Article | ||
| 223 | electronic-resource-num | style | 10.1016/j.jhazmat.2007.01.085 | 258 | 17 | Journal Article | ||
| 225 | electronic-resource-num | style | 10.1016/j.watres.2007.05.046 | 260 | 17 | Journal Article | ||
| 227 | electronic-resource-num | style | 10.1002/cite.200500036 | 262 | 17 | Journal Article | ||
| 250 | electronic-resource-num | style | 10.1007/s10040-008-0389-8 | 289 | 17 | Journal Article | ||
| 262 | electronic-resource-num | style | 10.5004/dwt.2009.747 | 304 | 17 | Journal Article | ||
| 263 | electronic-resource-num | style | 10.5004/dwt.2009.769 | 305 | 17 | Journal Article | ||
| 269 | electronic-resource-num | style | 10.2166/wst.2009.576 | 312 | 17 | Journal Article | ||
| 271 | electronic-resource-num | style | 10.1021/es9016816 | 314 | 17 | Journal Article | ||
| 272 | electronic-resource-num | style | 10.1080/15730620903038453 | 315 | 17 | Journal Article | ||
| 287 | electronic-resource-num | style | 10.1016/j.toxicon.2009.06.036 | 336 | 17 | Journal Article | ||
| 290 | electronic-resource-num | style | 10.1007/s12665-010-0458-x | 340 | 17 | Journal Article | ||
| 302 | electronic-resource-num | style | 10.3303/CET1023031 | 353 | 17 | Journal Article | ||
| 310 | electronic-resource-num | style | 10.1016/j.watres.2010.11.015 | 371 | 17 | Journal Article | ||
| 311 | electronic-resource-num | style | 10.1016/j.watres.2010.06.011 | 372 | 17 | Journal Article | ||
| 317 | electronic-resource-num | style | 10.4319/lo.2010.55.5.2073 | 378 | 17 | Journal Article | ||
| 318 | electronic-resource-num | style | 10.1016/j.watres.2010.10.019 | 379 | 17 | Journal Article | ||
| 319 | electronic-resource-num | style | 10.1016/j.toxicon.2010.06.021 | 381 | 17 | Journal Article | ||
| 320 | electronic-resource-num | style | 10.1128/AEM.02285-09 | 382 | 17 | Journal Article | ||
| 321 | electronic-resource-num | style | 10.1111/j.1745-6584.2010.00771.x | 383 | 17 | Journal Article | ||
| 322 | electronic-resource-num | style | 10.1016/j.watres.2010.08.047 | 384 | 17 | Journal Article | ||
| 323 | electronic-resource-num | style | 10.2166/wst.2011.058 | 385 | 17 | Journal Article | ||
| 331 | electronic-resource-num | style | 10.2166/wst.2010.084 | 395 | 17 | Journal Article | ||
| 332 | electronic-resource-num | style | 10.1016/j.watres.2010.06.007 | 396 | 17 | Journal Article | ||
| 333 | electronic-resource-num | style | 10.2166/wst.2010.127 | 397 | 17 | Journal Article | ||
| 341 | electronic-resource-num | style | 10.1016/j.scitotenv.2010.11.002 | 406 | 17 | Journal Article | ||
| 353 | electronic-resource-num | style | 10.1016/j.watres.2011.02.015 | 420 | 17 | Journal Article | ||
| 356 | electronic-resource-num | style | 10.1093/plankt/fbq033 | 426 | 17 | Journal Article | ||
| 357 | electronic-resource-num | style | 10.1016/j.watres.2011.06.040 | 429 | 17 | Journal Article | ||
| 359 | electronic-resource-num | style | 10.5004/dwt.2010.1783 | 431 | 17 | Journal Article | ||
| 360 | electronic-resource-num | style | 10.1007/s00254-007-0792-9 | 432 | 17 | Journal Article | ||
| 361 | electronic-resource-num | style | 10.1029/2007WR006746 | 433 | 17 | Journal Article | ||
| 362 | electronic-resource-num | style | 10.1016/j.chemosphere.2008.06.056 | 434 | 17 | Journal Article | ||
| 363 | electronic-resource-num | style | 10.2166/wst.2011.672 | 435 | 17 | Journal Article | ||
| 397 | electronic-resource-num | style | 10.5675/HyWa_2012,1_1 | 477 | 17 | Journal Article | ||
| 398 | electronic-resource-num | style | 10.3242/kae2011.06.006 | 480 | 17 | Journal Article | ||
| 407 | electronic-resource-num | style | 10.2166/wcc.2012.022 | 491 | 17 | Journal Article | ||
| 411 | electronic-resource-num | style | 10.1080/19443994.2012.683073 | 495 | 17 | Journal Article | ||
| 415 | electronic-resource-num | style | 10.1089/ees.2006.23.623 | 501 | 17 | Journal Article | ||
| 416 | electronic-resource-num | style | 10.2166/wpt.2013.039 | 505 | 17 | Journal Article | ||
| 422 | electronic-resource-num | style | 10.1021/es301422r | 512 | 17 | Journal Article | ||
| 428 | electronic-resource-num | style | 10.2166/wst.2012.529 | 519 | 17 | Journal Article | ||
| 461 | electronic-resource-num | style | 10.1007/s11368-013-0671-9 | 559 | 17 | Journal Article | ||
| 499 | electronic-resource-num | style | 10.2166/wpt.2013.042 | 611 | 17 | Journal Article | ||
| 500 | electronic-resource-num | style | 10.2166/wst.2013.524 | 612 | 17 | Journal Article | ||
| 522 | electronic-resource-num | style | 10.1016/j.ecoleng.2013.02.010 | 636 | 17 | Journal Article | ||
| 594 | electronic-resource-num | style | 10.1007/s10498-014-9234-y | 734 | 17 | Journal Article | ||
| 595 | electronic-resource-num | style | 10.2166/wh.2014.134 | 735 | 17 | Journal Article | ||
| 596 | electronic-resource-num | style | 10.1007/s12665-014-3269-7 | 736 | 17 | Journal Article | ||
| 602 | electronic-resource-num | style | 10.3242/kae2015.04.005 | 750 | 17 | Journal Article | ||
| 605 | electronic-resource-num | style | 10.1007/s12665-015-4149-5 | 753 | 17 | Journal Article | ||
| 612 | electronic-resource-num | style | 10.2166/ws.2015.008 | 762 | 17 | Journal Article | ||
| 638 | electronic-resource-num | style | 10.1016/j.jenvman.2014.10.025 | 813 | 17 | Journal Article | ||
| 647 | electronic-resource-num | style | 10.1007/s13280-014-0613-9 | 829 | 17 | Journal Article | ||
| 650 | electronic-resource-num | style | 10.3242/kae2015.10.001 | 832 | 17 | Journal Article | ||
| 651 | electronic-resource-num | style | 10.2166/wst.2014.465 | 833 | 17 | Journal Article | ||
| 662 | electronic-resource-num | style | 10.3242/kae2015.12.002 | 854 | 17 | Journal Article | ||
| 671 | electronic-resource-num | style | 10.1007/s10040-017-1554-8 | 865 | 17 | Journal Article | ||
| 674 | electronic-resource-num | style | 10.1016/j.watres.2016.08.010 | 872 | 17 | Journal Article | ||
| 675 | electronic-resource-num | style | 10.1016/j.watres.2016.08.017 | 873 | 17 | Journal Article | ||
| 686 | electronic-resource-num | style | 10.1007/s11269-015-0985-z | 916 | 17 | Journal Article | ||
| 687 | electronic-resource-num | style | 10.1016/j.watres.2015.03.031 | 919 | 17 | Journal Article | ||
| 691 | electronic-resource-num | style | 10.2166/wst.2014.087 | 934 | 17 | Journal Article | ||
| 692 | electronic-resource-num | style | 10.2166/wst.2014.436 | 935 | 17 | Journal Article | ||
| 703 | electronic-resource-num | style | 10.1016/j.watres.2016.05.070 | 956 | 17 | Journal Article | ||
| 705 | electronic-resource-num | style | 10.1080/1573062X.2017.1325497 | 958 | 17 | Journal Article | ||
| 708 | electronic-resource-num | style | 10.1007/s12665-015-4911-8 | 973 | 17 | Journal Article | ||
| 715 | electronic-resource-num | style | 10.3242/kae2016.11.004 | 980 | 17 | Journal Article | ||
| 730 | electronic-resource-num | style | 10.3242/kae2017.04.003 | 996 | 17 | Journal Article | ||
| 731 | electronic-resource-num | style | 10.3242/kae2017.05.002 | 997 | 17 | Journal Article | ||
| 733 | electronic-resource-num | style | 10.1016/j.jes.2016.04.010 | 1001 | 17 | Journal Article | ||
| 779 | electronic-resource-num | style | 10.1016/j.watres.2018.06.057 | 1051 | 17 | Journal Article | ||
| 784 | electronic-resource-num | style | 10.3390/su10051482 | 1057 | 17 | Journal Article | ||
| 786 | electronic-resource-num | style | 10.3242/kae2018.12.004 | 1059 | 17 | Journal Article | ||
| 787 | electronic-resource-num | style | 10.2166/hydro.2018.217 | 1060 | 17 | Journal Article | ||
| 793 | electronic-resource-num | style | 10.1007/s10040-018-1841-z | 1067 | 17 | Journal Article | ||
| 799 | electronic-resource-num | style | 10.3390/w10111599 | 1073 | 17 | Journal Article | ||
| 802 | electronic-resource-num | style | 10.1080/15732479.2017.1356858 | 1076 | 17 | Journal Article | ||
| 831 | electronic-resource-num | style | 10.1016/j.watres.2019.115383 | 1114 | 17 | Journal Article | ||
| 852 | electronic-resource-num | style | 10.1061/(ASCE)HZ.2153-5515.0000160 | 1144 | 17 | Journal Article | ||
| 853 | electronic-resource-num | style | 10.1002/cite.201200195 | 1145 | 17 | Journal Article | ||
| 859 | electronic-resource-num | style | 10.1016/j.ecoleng.2012.12.085 | 1151 | 17 | Journal Article | ||
| 870 | electronic-resource-num | style | 10.2166/wpt.2018.085 | 1162 | 17 | Journal Article | ||
| 913 | electronic-resource-num | style | 10.1186/s12302-019-0250-9 | 1207 | 17 | Journal Article | ||
| 914 | electronic-resource-num | style | 10.2166/ws.2019.025 | 1208 | 17 | Journal Article | ||
| 918 | electronic-resource-num | style | 10.1007/s13762-018-1881-x | 1212 | 17 | Journal Article | ||
| 949 | electronic-resource-num | style | 10.1002/Ino.11460 | 1245 | 17 | Journal Article |
Only 124 (61.4 %) journal publications have a DOI which is encoded in the field electronic-resource-num.
All DOIs should be entered in the field electronic-resource-num in the following format, i.e.:
10.6084/m9.figshare.828487
Write references dataframe to xlsx with one sheet for each publication type to references.xlsx
kwb.endnote::write_references_df_to_xlsx(endnote_list)And also writting a cleaned version after automatically running kwb.endnote::clean_references_df() to references_cleaned.xlsx.
kwb.endnote::write_clean_references_df_to_xlsx(endnote_list)
problematic_entries <- kwb.endnote::check_problematic_entries(endnote_list)
#> Creating data frame from 'endnote_list' ... ok. (17.60s)
#> Creating 'cleaned' data frame from 'endnote_list' for comparison ... Check 'Author Names' ... No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 3 values with fix_firstname_lastname_with_lastname_semicolon_firstname ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 933 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 942 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 951 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 27 values with fix_firstname_lastname_with_lastname_semicolon_firstname ... ok. (0.00s)
#> Replacing 884 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_firstname_lastname_with_lastname_semicolon_firstname ... ok. (0.00s)
#> Replacing 933 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 941 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 943 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 947 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 948 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 951 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 951 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 951 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> Replacing 1 NA values with add_at_least_one_author_with_lastname_semicolon_firstname ... ok. (0.00s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 2 values with fix_firstname_lastname_with_lastname_semicolon_firstname ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> ok. (0.00s)
#> Replacing 1 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.03s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 2 values with fix_firstname_lastname_with_lastname_semicolon_firstname ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> ok. (0.00s)
#> Replacing 197 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.03s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 2 values with fix_firstname_lastname_with_lastname_semicolon_firstname ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> ok. (0.00s)
#> Replacing 333 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_firstname_lastname_with_lastname_semicolon_firstname ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> ok. (0.00s)
#> Replacing 486 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 612 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 722 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 2 values with fix_author_name_by_deleting_last_semicolon ... Replacing 2 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 787 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 2 values with fix_author_name_by_deleting_last_semicolon ... Replacing 2 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 841 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 876 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 897 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 909 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 920 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 925 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 928 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 930 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 933 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 934 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 934 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 935 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 937 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 937 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 937 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 937 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 937 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 1 values with fix_author_name_by_deleting_last_semicolon ... Replacing 1 values with fix_multiple_authors_per_line ... ok. (0.00s)
#> ok. (0.00s)
#> Replacing 941 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 943 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 948 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 948 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 948 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 948 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 949 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.01s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 951 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> No cleaning of author_names implemented yet. Only hints are generated in
#> case that user defines 'give_hints = TRUE' (default: FALSE) ... ok. (0.00s)
#> Generate hints for 'Author Names' ... Replacing 951 NA values with add_author_lastname_semicolon_firstname ... ok. (0.00s)
#> ok. (0.02s)
#> ok. (0.79s)
#> Clean 'DOI' ... ok. (0.00s)
#> Clean 'Project Names' ... Generate hints for 'Project Names' ... Replacing 622 NA values with add_project_name ... ok. (0.00s)
#> ok. (0.00s)
#> ok. (0.00s)
#> Clean 'Accessibility' ... Generate hints for 'Accessiblity' ... Replacing 929 NA values with add_public_or_confidential ... ok. (0.00s)
#> ok. (0.00s)
#> ok. (0.00s)
#> ok. (19.02s)
knitr::kable(problematic_entries[1:100,])| rec_number | key | value_org | value_clean |
|---|---|---|---|
| 2 | author_secondary01 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary02 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary03 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary04 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary05 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary06 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary07 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary08 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_secondary09 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_tertiary01 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_tertiary02 | NA | add_author_lastname_semicolon_firstname |
| 2 | author_tertiary03 | NA | add_author_lastname_semicolon_firstname |
| 2 | author04 | NA | add_author_lastname_semicolon_firstname |
| 2 | author05 | NA | add_author_lastname_semicolon_firstname |
| 2 | author06 | NA | add_author_lastname_semicolon_firstname |
| 2 | author07 | NA | add_author_lastname_semicolon_firstname |
| 2 | author08 | NA | add_author_lastname_semicolon_firstname |
| 2 | author09 | NA | add_author_lastname_semicolon_firstname |
| 2 | author10 | NA | add_author_lastname_semicolon_firstname |
| 2 | author11 | NA | add_author_lastname_semicolon_firstname |
| 2 | author12 | NA | add_author_lastname_semicolon_firstname |
| 2 | author13 | NA | add_author_lastname_semicolon_firstname |
| 2 | author14 | NA | add_author_lastname_semicolon_firstname |
| 2 | author15 | NA | add_author_lastname_semicolon_firstname |
| 2 | author16 | NA | add_author_lastname_semicolon_firstname |
| 2 | author17 | NA | add_author_lastname_semicolon_firstname |
| 2 | author18 | NA | add_author_lastname_semicolon_firstname |
| 2 | author19 | NA | add_author_lastname_semicolon_firstname |
| 2 | author20 | NA | add_author_lastname_semicolon_firstname |
| 2 | author21 | NA | add_author_lastname_semicolon_firstname |
| 2 | author22 | NA | add_author_lastname_semicolon_firstname |
| 2 | author23 | NA | add_author_lastname_semicolon_firstname |
| 2 | author24 | NA | add_author_lastname_semicolon_firstname |
| 2 | author25 | NA | add_author_lastname_semicolon_firstname |
| 2 | author26 | NA | add_author_lastname_semicolon_firstname |
| 2 | author27 | NA | add_author_lastname_semicolon_firstname |
| 2 | author28 | NA | add_author_lastname_semicolon_firstname |
| 2 | author29 | NA | add_author_lastname_semicolon_firstname |
| 2 | author30 | NA | add_author_lastname_semicolon_firstname |
| 2 | author31 | NA | add_author_lastname_semicolon_firstname |
| 2 | author32 | NA | add_author_lastname_semicolon_firstname |
| 2 | author33 | NA | add_author_lastname_semicolon_firstname |
| 2 | custom2 | NA | add_project_name |
| 2 | custom3 | NA | add_public_or_confidential |
| 3 | author_secondary01 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary02 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary03 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary04 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary05 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary06 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary07 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary08 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_secondary09 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_tertiary01 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_tertiary02 | NA | add_author_lastname_semicolon_firstname |
| 3 | author_tertiary03 | NA | add_author_lastname_semicolon_firstname |
| 3 | author06 | NA | add_author_lastname_semicolon_firstname |
| 3 | author07 | NA | add_author_lastname_semicolon_firstname |
| 3 | author08 | NA | add_author_lastname_semicolon_firstname |
| 3 | author09 | NA | add_author_lastname_semicolon_firstname |
| 3 | author10 | NA | add_author_lastname_semicolon_firstname |
| 3 | author11 | NA | add_author_lastname_semicolon_firstname |
| 3 | author12 | NA | add_author_lastname_semicolon_firstname |
| 3 | author13 | NA | add_author_lastname_semicolon_firstname |
| 3 | author14 | NA | add_author_lastname_semicolon_firstname |
| 3 | author15 | NA | add_author_lastname_semicolon_firstname |
| 3 | author16 | NA | add_author_lastname_semicolon_firstname |
| 3 | author17 | NA | add_author_lastname_semicolon_firstname |
| 3 | author18 | NA | add_author_lastname_semicolon_firstname |
| 3 | author19 | NA | add_author_lastname_semicolon_firstname |
| 3 | author20 | NA | add_author_lastname_semicolon_firstname |
| 3 | author21 | NA | add_author_lastname_semicolon_firstname |
| 3 | author22 | NA | add_author_lastname_semicolon_firstname |
| 3 | author23 | NA | add_author_lastname_semicolon_firstname |
| 3 | author24 | NA | add_author_lastname_semicolon_firstname |
| 3 | author25 | NA | add_author_lastname_semicolon_firstname |
| 3 | author26 | NA | add_author_lastname_semicolon_firstname |
| 3 | author27 | NA | add_author_lastname_semicolon_firstname |
| 3 | author28 | NA | add_author_lastname_semicolon_firstname |
| 3 | author29 | NA | add_author_lastname_semicolon_firstname |
| 3 | author30 | NA | add_author_lastname_semicolon_firstname |
| 3 | author31 | NA | add_author_lastname_semicolon_firstname |
| 3 | author32 | NA | add_author_lastname_semicolon_firstname |
| 3 | author33 | NA | add_author_lastname_semicolon_firstname |
| 3 | custom2 | NA | add_project_name |
| 3 | custom3 | NA | add_public_or_confidential |
| 4 | author_secondary01 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary02 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary03 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary04 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary05 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary06 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary07 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary08 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_secondary09 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_tertiary01 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_tertiary02 | NA | add_author_lastname_semicolon_firstname |
| 4 | author_tertiary03 | NA | add_author_lastname_semicolon_firstname |
| 4 | author04 | NA | add_author_lastname_semicolon_firstname |
| 4 | author05 | NA | add_author_lastname_semicolon_firstname |