Tables Reporting (Pandas and CSV Files)

The pandas_reporting.py example demonstrates reporting tabular data from Pandas DataFrames and CSV files as tables.

Trains reports these tables in the Trains Web (UI), experiment details, RESULTS tab, PLOTS sub-tab.

When the script runs, it creates an experiment named pandas table reporting, which is associated with the examples project.

Reporting Pandas DataFrames as tables

Report Pandas DataFrames by calling the Logger.report_table method providing the DataFrame in the table_plot parameter.

# Report table - DataFrame with index
df = pd.DataFrame(
    {
        "num_legs": [2, 4, 8, 0],
        "num_wings": [2, 0, 0, 0],
        "num_specimen_seen": [10, 2, 1, 8],
    },
    index=["falcon", "dog", "spider", "fish"],
)
df.index.name = "id"
Logger.current_logger().report_table("table pd", "PD with index", iteration=iteration, table_plot=df)

image

Reporting CSV files as tables

Report CSV files by providing the URL location of the CSV file in the url parameter. For a local CSV file, use the csv parameter.

# Report table - CSV from path
csv_url = "https://raw.githubusercontent.com/plotly/datasets/master/Mining-BTC-180.csv"
Logger.current_logger().report_table("table csv", "remote csv", iteration=iteration, url=csv_url)

image