icj_to_csv

inset_chart_json_to_csv_dataframe_pd(output_path)

Convert InsetChart.json file in 'output_path' to InsetChart.csv. Adding Simulation_Year column if Base_Year exists in config.json.

Args:

output_path (str): Subdirectory in which to find InsetChart.json

Returns:

Raises:

Type	Description
ValueError	if InsetChart.json can't be found.
ValueError	if InsetChart.csv can't be written.

Source code in emod_api/channelreports/icj_to_csv.py

def inset_chart_json_to_csv_dataframe_pd( output_path: str ):
    """
    Convert InsetChart.json file in 'output_path' to InsetChart.csv.
    Adding Simulation_Year column if Base_Year exists in config.json.

    Args:

        output_path (str): Subdirectory in which to find InsetChart.json

    Returns:

    Raises:
        ValueError: if InsetChart.json can't be found.
        ValueError: if InsetChart.csv can't be written.
    """

    icj_path = os.path.join( output_path, "InsetChart.json" )
    if not os.path.exists( icj_path ):
        raise ValueError( f"InsetChart.json not found at {output_path}." )

    # Load JSON data from file
    with open( icj_path ) as fp:
        icj = json.load( fp )

    optional_years_channel = _get_sim_years( output_path )
    if optional_years_channel:
        icj["Channels"]["Simulation_Year"]["Data"] = optional_years_channel

    # Create an empty DataFrame
    df = pd.DataFrame()

    # Iterate over the Channels keys and extract time series data
    for channel, values in icj["Channels"].items():
        # Create a column in the DataFrame for each channel
        df[channel] = values["Data"]

    try:
        # Convert DataFrame to CSV
        csv_path = os.path.join( output_path, "InsetChart.csv" )
        df.to_csv(csv_path, index=False)
    except Exception as ex:
        print( f"ERROR: Exception {ex} while writing csv dataframe of InsetChart.json to disk." )
        raise ValueError( ex )