{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "from plotnine import *" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "# results_df = pd.read_csv('structures_experiment_results_1.csv')\n", "results_df = pd.read_csv('./experiment_results/long_chain_results_sin1.csv')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "results_df['cat_retries'] = pd.Categorical(results_df['retries']).rename_categories({100: 'Fail'})\n", "# results_df['fraction'] = results_df['reqs'] / (365*24*60*60)\n", "results_df['fraction'] = results_df['reqs'] / (365*24*60*60/2) # For sin stuff\n", "min_max_per_exp = results_df.groupby(['vendor', 'experiment', 'cat_retries'])['fraction'].agg(['min', 'max', 'mean']).reset_index().fillna(0)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Unnamed: 0 | \n", "vendor | \n", "reqs | \n", "retries | \n", "iteration | \n", "experiment | \n", "cat_retries | \n", "fraction | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "uniform | \n", "1.499495e+07 | \n", "0 | \n", "0 | \n", "deep chain | \n", "0 | \n", "9.509732e-01 | \n", "
| 1 | \n", "1 | \n", "uniform | \n", "7.501410e+05 | \n", "1 | \n", "0 | \n", "deep chain | \n", "1 | \n", "4.757363e-02 | \n", "
| 2 | \n", "2 | \n", "uniform | \n", "2.239900e+04 | \n", "2 | \n", "0 | \n", "deep chain | \n", "2 | \n", "1.420535e-03 | \n", "
| 3 | \n", "3 | \n", "uniform | \n", "4.870000e+02 | \n", "3 | \n", "0 | \n", "deep chain | \n", "3 | \n", "3.088534e-05 | \n", "
| 4 | \n", "4 | \n", "uniform | \n", "1.100000e+01 | \n", "4 | \n", "0 | \n", "deep chain | \n", "4 | \n", "6.976154e-07 | \n", "
| 5 | \n", "5 | \n", "uniform | \n", "1.000000e+00 | \n", "5 | \n", "0 | \n", "deep chain | \n", "5 | \n", "6.341958e-08 | \n", "
| 6 | \n", "6 | \n", "uniform | \n", "1.608636e+01 | \n", "100 | \n", "0 | \n", "deep chain | \n", "Fail | \n", "1.020190e-06 | \n", "
| 7 | \n", "0 | \n", "1.565882e+07 | \n", "0 | \n", "0 | \n", "deep chain | \n", "0 | \n", "9.930757e-01 | \n", "|
| 8 | \n", "1 | \n", "1.052420e+05 | \n", "1 | \n", "0 | \n", "deep chain | \n", "1 | \n", "6.674404e-03 | \n", "|
| 9 | \n", "2 | \n", "1.953000e+03 | \n", "2 | \n", "0 | \n", "deep chain | \n", "2 | \n", "1.238584e-04 | \n", "|
| 10 | \n", "3 | \n", "3.320000e+02 | \n", "3 | \n", "0 | \n", "deep chain | \n", "3 | \n", "2.105530e-05 | \n", "|
| 11 | \n", "4 | \n", "1.656685e+03 | \n", "100 | \n", "0 | \n", "deep chain | \n", "Fail | \n", "1.050663e-04 | \n", "