store

Performing operations on file-like objects.

These operations include saving and loading data, as well as other relevant tasks.

Utilities

_check_saving_path(path[, verbose, ...])

Verify a file path before saving, creates directories, and manages console output.

_autofit_column_width(excel_writer, ...)

Adjust the column widths in an Excel spreadsheet based on the content length.

_check_loading_path(path[, verbose, ...])

Verify a file path for loading and prints status to the console.

_set_index(data[, index_col])

Set the index of a dataframe using column names or integer positions.

Saving data

save_pickle(data, path_to_file[, verbose, ...])

Save data to a pickle file.

save_spreadsheet(data, path_to_file[, ...])

Save data to a spreadsheet file format (e.g. CSV, Microsoft Excel or OpenDocument).

save_spreadsheets(data, path_to_file, ...[, ...])

Save multiple dataframes to a multi-sheet Microsoft Excel (.xlsx, .xls) or OpenDocument (.ods) format file.

save_json(data, path_to_file[, engine, ...])

Save data to a JSON file.

save_joblib(data, path_to_file[, verbose, ...])

Save data to a Joblib file.

save_feather(data, path_to_file[, index, ...])

Save a dataframe to a Feather file.

save_svg_as_emf(path_to_svg, path_to_emf[, ...])

Save a SVG file (.svg) as a EMF file (.emf) using Inkscape.

save_fig(path_to_file[, dpi, ...])

Save a figure object to a file in a supported format.

save_figure(data, path_to_file[, ...])

Save a figure object to a file in a supported format (with the figure object specified).

save_html_as_pdf(data, path_to_file[, ...])

Save a web page as a PDF file using wkhtmltopdf.

save_data(data, path_to_file[, verbose, ...])

Save data to a file in a specific format.

Loading data

load_pickle(path_to_file[, verbose, ...])

Load data from a Pickle file.

load_csv(path_to_file[, delimiter, header, ...])

Load data from a CSV file.

load_spreadsheets(path_to_file[, as_dict, ...])

Load one or multiple sheets from a Microsoft Excel or an OpenDocument format file.

load_json(path_to_file[, engine, verbose, ...])

Load data from a JSON file.

load_joblib(path_to_file[, verbose, ...])

Load data from a Joblib file.

load_feather(path_to_file[, index_col, ...])

Load a dataframe from a Feather file.

load_csr_matrix(path_to_file[, verbose, ...])

Load in a compressed sparse row (CSR) or compressed row storage (CRS).

load_data(path_to_file[, verbose, ...])

Load data from a file.

Transforming data files

unzip(path_to_zip_file[, output_dir, ...])

Unzip data from a Zip (compressed) file.

seven_zip(zip_file_path[, output_dir, mode, ...])

Extract data from a compressed file using 7-Zip.

markdown_to_rst(path_to_md, path_to_rst[, ...])

Convert a Markdown (.md) file to a reStructuredText (.rst) file.

xlsx_to_csv(path_to_xlsx[, path_to_csv, ...])

Convert a Microsoft Excel spreadsheet to a CSV file.