def to_excel(net, filename, include_empty_tables=False, include_results=True): """ Saves a pandapower Network to an excel file. INPUT: **net** (dict) - The pandapower format network **filename** (string) - The absolute or relative path to the output file OPTIONAL: **include_empty_tables** (bool, False) - empty element tables are saved as excel sheet **include_results** (bool, True) - results are included in the excel sheet EXAMPLE: >>> pp.to_excel(net, os.path.join("C:", "example_folder", "example1.xlsx")) # absolute path >>> pp.to_excel(net, "example2.xlsx") # relative path """ writer = pd.ExcelWriter(filename, engine='xlsxwriter') dict_net = io_utils.to_dict_of_dfs( net, include_results=include_results, include_empty_tables=include_empty_tables) for item, table in dict_net.items(): table.to_excel(writer, sheet_name=item) writer.save()
def to_json(net, filename=None): """ Saves a pandapower Network in JSON format. The index columns of all pandas DataFrames will be saved in ascending order. net elements which name begins with "_" (internal elements) will not be saved. Std types will also not be saved. INPUT: **net** (dict) - The pandapower format network **filename** (string or file) - The absolute or relative path to the output file or file-like object EXAMPLE: >>> pp.to_json(net, "example.json") """ dict_net = to_dict_of_dfs(net, include_results=False, create_dtype_df=True) dict_net["dtypes"] = collect_all_dtypes_df(net) json_string = to_json_string(dict_net) if hasattr(filename, 'write'): filename.write(json_string) return with open(filename, "w") as text_file: text_file.write(json_string)
def to_sql(net, con, include_results=True): dodfs = io_utils.to_dict_of_dfs(net, include_results=include_results) for name, data in dodfs.items(): data.to_sql(name, con, if_exists="replace")
def to_sql(net, con, include_empty_tables=False, include_results=True): dodfs = to_dict_of_dfs(net, include_results=include_results) dodfs["dtypes"] = collect_all_dtypes_df(net) for name, data in dodfs.items(): data.to_sql(name, con, if_exists="replace")