custom module

add_xl_formula(df[, column_name, formula, …])

add Excel (xl) formula column

duration(s1[, s2, unit, round, freq])

calculate duration between two columns (series)

factorize(series[, categories, ordered])

factorize / make column a categorical dtype

fiscal_year(date[, start_month, year_only])

Convert to fiscal year

from_excel(excel_date)

apply_date function: excel serial date -> pd.Timestamp

from_julian(julian[, jde_format])

apply_date function: (JDE) Julian -> Gregorian

ratio(value1, value2[, precision, percent, …])

Calculate the Ratio / percentage of two values

to_julian(greg_date[, format])

apply_date function: Gregorian -> (JDE) Julian