EXPORT_CSV

Download Flojoy Studio to try this app

Export a DataContainer into CSV format. Params: dc : OrderedPair|OrderedTriple|DataFrame The DataContainer to export. dir : Directory The directory to export to. filename : str The name of the file to output. Returns: out : None

Python Code

import pandas as pd
import os
from flojoy import (
    DataFrame,
    OrderedPair,
    OrderedTriple,
    Matrix,
    flojoy,
    DataContainer,
    Directory,
)
from typing import Optional


@flojoy
def EXPORT_CSV(
    dc: OrderedPair | OrderedTriple | DataFrame | Matrix,
    dir: Directory,
    filename: str = "exported.csv",
) -> Optional[DataContainer]:
    """Export a DataContainer into CSV format.

    Parameters
    ----------
    dc : OrderedPair|OrderedTriple|DataFrame
        The DataContainer to export.
    dir : Directory
        The directory to export to.
    filename : str
        The name of the file to output.

    Returns
    -------
    None
    """

    if dir is None:
        raise ValueError("Please select a directory to export the data to")

    path = os.path.join(dir.unwrap(), filename)

    match dc:
        case OrderedPair() | OrderedTriple():
            df = pd.DataFrame(dc)
            df = df.drop(columns=["type", "extra"])
            df.to_csv(path, index=False)
        case DataFrame():
            df = dc.m
            df.to_csv(path, index=False)
        case Matrix():
            df = pd.DataFrame(dc.m)
            df.to_csv(path, index=False, header=False)
        case _:
            raise ValueError(
                f"Invalid DataContainer type: {dc.type} cannot be exported as CSV."
            )

    return None

Find this Flojoy Block on GitHub

Example App

Having problems with this example app? Join our Discord community and we will help you out!

In this example, the EXPORT_JSON block exports the OrderedPair data from the default noisy sine app into JSON format, outputting to a specified directory.