weigangtang-reftab 0.0.9

manage journal reference

Package Description

RefTab is used to manage reference of journal papers. It can export reference table into 1) Excel and 2) Bibtex. Excel contains hyperlink, so users can quickly open the PDF of papers. Bibtex can be recognized for LaTex.

Functions

• is_year_format_correct()
• is_author_format_correct()
• auto_correct_author_string()
• auto_fill_abbr()
• auto_fill_link()
• read_ref_workbook()
• merge_ref_workbook()
• get_pdf_list()
• create_df_from_pdf_name()
• sort_header()
• save_workbook_to_excel()
• save_df_to_excel()
• save_df_to_latex()

RefTab Class

• __init__()
  • two inputs required:
    • dataframe of reference table
    • file path of readcube folder
  • generate a list of pdf file name in readcube folder
  • file path of readcube folder is used to build hyperlink to pdf
• update()
  • replace dataframe with new reference table
• find_incomplete_ref()
• find_duplicated_ref()
• find_duplicated_ref_by_abbr()
• find_nolink_ref()
• find_unlisted_pdf()
• find_invalid_pdf_name()
• get_unique_keywords()
  • find categories of papers
• get_unique_ref()
  • each record has an unqiue link
    • take Link (pdf name) as primary key
  • merge duplicated records
    • Keyword for multiple records were combined in a string seperate by ','
      • for example, "General Hydrology, Classification"
• subset_ref_by_keyword()
• subset_ref_by_abbr()
• save_to_excel()
  • allow to save as either single-sheet or multiple-sheet (separate by keyword) workbook
• save_to_latex()

Data Type

• Reference Table (DataFrame)

  • Required Columnes: 1) Title, 2) Year, 3) Journal, 4) Authors, 5) Vol, 6) Pages
  • Optional Columnes: 1) Link, 2) Abbreviation, 3) Keyword
    • Link and Abberviation can be auto-filled on the basis of other columns

• Workbook (Dictionary)

  • consist of a number of dataframe
    • key = sheet name
    • values = dataframe of reference table

Change Log

• Version 0.0.5 (2021-07-20)

  • Intialize
  • Start from 0.0.5 as previous versions are all failed
  • Remove os, re, string from 'install_requires', as they are built-in packages. Issue raise up if list those packages.

• Version 0.0.6 (2021-07-20)

  • Merge scripts into init.py. Script can not load function from another.

• Version 0.0.7 (2021-07-21)

  • Adjust the column width of reference table.

• Version 0.0.8 (2021-07-23)

  • Add merge_duplicated_ref()
    • merge keywords together
    • sort keywords by alphabet
  • When export to Excel
    • Assign referneces with no keyword to "No Category" sheet
    • Assign references with keyword of " * " to "Important" sheet

• Version 0.0.9 (2021-08-02)

  • Add check_ref_workbook()
    • list sheets with missing columns
    • list references with incorrect format of authors and year
    • require tabulate package