capiq_excel.tools package

Submodules

capiq_excel.tools.dates module

capiq_excel.tools.dates.freq_and_periods_to_begin_date_str(freq, periods)[source]
Return type

str

capiq_excel.tools.dates.today_as_str()[source]
Return type

str

capiq_excel.tools.ext_pandas module

capiq_excel.tools.ext_pandas.add_year_month_column_from_date_string_column(df, date_str_col='Date')[source]

note: inplace

capiq_excel.tools.ext_pandas.append_csv_to_csv(inpath, outpath)[source]
capiq_excel.tools.ext_pandas.append_csv_to_monthly_csv_of_first_date(inpath, rootname)[source]
capiq_excel.tools.ext_pandas.append_csvs_to_csv(csv_filepath_list, outpath=None)[source]

Appends csvs into a single csv. Is memory efficient by only keeping the current processed file in memory. However still keeps track of changing columns to ensure data is correctly aligned.

Parameters

  • csv_filepath_list –

  • outpath –

Returns

capiq_excel.tools.ext_pandas.append_csvs_to_monthly_csv_of_first_date(csv_filepath_list, rootname)[source]
capiq_excel.tools.ext_pandas.append_df_to_csv(df, outpath)[source]
capiq_excel.tools.ext_pandas.append_df_to_monthly_csv_of_first_date(df_for_append, rootname)[source]
capiq_excel.tools.ext_pandas.convert_excel_date_to_pandas_date(exceldates)[source]
capiq_excel.tools.ext_pandas.date_from_year_month(df, day=15, month_col='Month', year_col='Year', date_col='Date')[source]

Note: inplace

Return type

None

capiq_excel.tools.ext_pandas.first_year_month_in_df(df, date_str_col='Date')[source]
capiq_excel.tools.ext_pandas.get_full_date_df_from_date_series(date_series, new_date_name=None)[source]
capiq_excel.tools.ext_pandas.left_merge_df(df, other_df, ids)[source]
capiq_excel.tools.ext_pandas.outer_merge_df(df, other_df, ids)[source]
capiq_excel.tools.ext_pandas.replace_first_line_of_file(inpath, new_first_line, outpath=None)[source]
capiq_excel.tools.ext_pandas.right_merge_df(df, other_df, ids)[source]
capiq_excel.tools.ext_pandas.scale_variables(df, rescale_factor, rescale_vars)[source]

Note: inplace

Module contents