65 lines
2.0 KiB
Python
65 lines
2.0 KiB
Python
"""
|
|
This code is based on
|
|
https://github.com/pythongosssss/ComfyUI-Custom-Scripts/blob/main/py/show_text.py
|
|
|
|
See credit/credit.md for the full license.
|
|
"""
|
|
from typing import Any, Dict
|
|
from io import StringIO
|
|
import pandas as pd
|
|
|
|
class PandasSaveCSV:
|
|
"""
|
|
Pandas Save CSV:
|
|
Saves a PandasDataFrame to a CSV file.
|
|
|
|
category: IO
|
|
"""
|
|
@classmethod
|
|
def INPUT_TYPES(s):
|
|
return {
|
|
"required": {
|
|
"dataframe": ("DATAFRAME", {}),
|
|
"file_path": ("STRING", {"multiline": False})
|
|
},
|
|
"hidden": {
|
|
"unique_id": "UNIQUE_ID",
|
|
"extra_pnginfo": "EXTRA_PNGINFO",
|
|
},
|
|
}
|
|
|
|
INPUT_IS_LIST = True
|
|
RETURN_TYPES = ("STRING",)
|
|
FUNCTION = "save_csv"
|
|
OUTPUT_NODE = True
|
|
OUTPUT_IS_LIST = (True,)
|
|
|
|
CATEGORY = "Data Analysis"
|
|
|
|
def save_csv(self, dataframe, file_path=None, unique_id=None, extra_pnginfo=None):
|
|
text = None
|
|
if unique_id is not None and extra_pnginfo is not None:
|
|
if not isinstance(extra_pnginfo, list):
|
|
print("Error: extra_pnginfo is not a list")
|
|
elif (
|
|
not isinstance(extra_pnginfo[0], dict)
|
|
or "workflow" not in extra_pnginfo[0]
|
|
):
|
|
print("Error: extra_pnginfo[0] is not a dict or missing 'workflow' key")
|
|
elif file_path is None or len(file_path) == 0:
|
|
print("Error: file path is not specified")
|
|
else:
|
|
df = dataframe[0]
|
|
df.to_csv(path_or_buf=file_path[0]) # Save as CSV
|
|
text = [str(df)] # wrap in list
|
|
workflow = extra_pnginfo[0]["workflow"]
|
|
node = next(
|
|
(x for x in workflow["nodes"] if str(x["id"]) == str(unique_id[0])),
|
|
None,
|
|
)
|
|
if node:
|
|
node["widgets_values"] = [text]
|
|
else:
|
|
print("unique_id or extra_pnginfo is None.")
|
|
return {"ui": {"text": text}, "result": (text,)}
|