Skip to main content

Tables Reporting (Pandas and CSV Files)

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

ClearML reports these tables in the ClearML 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, and 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