diff options
Diffstat (limited to 'opendc-experiments/opendc-experiments-greenifier/src/main/Python_scripts')
| -rw-r--r-- | opendc-experiments/opendc-experiments-greenifier/src/main/Python_scripts/OpenDCdemo.ipynb | 123 |
1 files changed, 86 insertions, 37 deletions
diff --git a/opendc-experiments/opendc-experiments-greenifier/src/main/Python_scripts/OpenDCdemo.ipynb b/opendc-experiments/opendc-experiments-greenifier/src/main/Python_scripts/OpenDCdemo.ipynb index 61ae6322..ecef829e 100644 --- a/opendc-experiments/opendc-experiments-greenifier/src/main/Python_scripts/OpenDCdemo.ipynb +++ b/opendc-experiments/opendc-experiments-greenifier/src/main/Python_scripts/OpenDCdemo.ipynb @@ -2,7 +2,7 @@ "cells": [ { "cell_type": "code", - "execution_count": 1, + "execution_count": 3, "id": "18170001", "metadata": {}, "outputs": [], @@ -13,7 +13,7 @@ "\n", "from IPython.display import display, HTML\n", "\n", - "base_folder = \"../../../../..\"" + "base_folder = \"../\"" ] }, { @@ -26,7 +26,7 @@ }, { "cell_type": "code", - "execution_count": 2, + "execution_count": 4, "id": "a2d05361", "metadata": {}, "outputs": [ @@ -165,7 +165,7 @@ }, { "cell_type": "code", - "execution_count": 140, + "execution_count": 5, "id": "fd17d88a", "metadata": {}, "outputs": [ @@ -251,7 +251,7 @@ "4 1019 2013-08-12 14:15:46+00:00 900000 1 0.000000" ] }, - "execution_count": 140, + "execution_count": 5, "metadata": {}, "output_type": "execute_result" } @@ -263,7 +263,7 @@ }, { "cell_type": "code", - "execution_count": 141, + "execution_count": 6, "id": "346f097f", "metadata": { "scrolled": true @@ -364,7 +364,7 @@ "4 2599.999649 179306 " ] }, - "execution_count": 141, + "execution_count": 6, "metadata": {}, "output_type": "execute_result" } @@ -392,7 +392,7 @@ }, { "cell_type": "code", - "execution_count": 144, + "execution_count": 10, "id": "0d400ffd", "metadata": {}, "outputs": [], @@ -401,14 +401,14 @@ "workload = \"workload=bitbrains-small\"\n", "seed = \"seed=0\"\n", "\n", - "df_host_single = pd.read_parquet(f\"{output_folder}/host/topology=single/{workload}/{seed}/data.parquet\")\n", - "df_host_multi = pd.read_parquet(f\"{output_folder}/host/topology=multi/{workload}/{seed}/data.parquet\")\n", + "df_host_single = pd.read_parquet(f\"{output_folder}/topology=single/{workload}/{seed}/host.parquet\")\n", + "df_host_multi = pd.read_parquet(f\"{output_folder}/topology=multi/{workload}/{seed}/host.parquet\")\n", "\n", - "df_server_single = pd.read_parquet(f\"{output_folder}/server/topology=single/{workload}/{seed}/data.parquet\")\n", - "df_server_multi = pd.read_parquet(f\"{output_folder}/server/topology=multi/{workload}/{seed}/data.parquet\")\n", + "df_server_single = pd.read_parquet(f\"{output_folder}/topology=single/{workload}/{seed}/server.parquet\")\n", + "df_server_multi = pd.read_parquet(f\"{output_folder}/topology=multi/{workload}/{seed}/server.parquet\")\n", "\n", - "df_service_single = pd.read_parquet(f\"{output_folder}/service/topology=single/{workload}/{seed}/data.parquet\")\n", - "df_service_multi = pd.read_parquet(f\"{output_folder}/service/topology=multi/{workload}/{seed}/data.parquet\")\n", + "df_service_single = pd.read_parquet(f\"{output_folder}/topology=single/{workload}/{seed}/service.parquet\")\n", + "df_service_multi = pd.read_parquet(f\"{output_folder}/topology=multi/{workload}/{seed}/service.parquet\")\n", "\n", "def add_absolute_timestamp(df, start_dt):\n", " df[\"absolute_timestamp\"] = start_dt + (df[\"timestamp\"] - df[\"timestamp\"].min())\n", @@ -425,76 +425,125 @@ }, { "cell_type": "code", - "execution_count": 145, + "execution_count": 11, "id": "a9a61332", "metadata": {}, "outputs": [ { "data": { "text/plain": [ - "25922" + "Index(['timestamp', 'host_id', 'cpu_count', 'mem_capacity',\n", + " 'guests_terminated', 'guests_running', 'guests_error', 'guests_invalid',\n", + " 'cpu_limit', 'cpu_usage', 'cpu_demand', 'cpu_utilization',\n", + " 'cpu_time_active', 'cpu_time_idle', 'cpu_time_steal', 'cpu_time_lost',\n", + " 'power_draw', 'energy_usage', 'uptime', 'downtime', 'boot_time',\n", + " 'absolute_timestamp'],\n", + " dtype='object')" ] }, - "execution_count": 145, + "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ - "len(df_service_single)" + "df_host_single.columns" ] }, { "cell_type": "code", - "execution_count": 146, + "execution_count": 12, "id": "d6fb41d9", "metadata": {}, "outputs": [ { "data": { "text/plain": [ - "1970-01-01 00:05:00+00:00 1\n", - "1970-03-01 23:55:00+00:00 1\n", - "1970-03-02 00:45:00+00:00 1\n", - "1970-03-02 00:40:00+00:00 1\n", - "1970-03-02 00:35:00+00:00 1\n", - " ..\n", - "1970-01-30 23:50:00+00:00 1\n", - "1970-01-30 23:45:00+00:00 1\n", - "1970-01-30 23:40:00+00:00 1\n", - "1970-01-30 23:35:00+00:00 1\n", - "1970-04-01 00:10:00+00:00 1\n", - "Name: timestamp, Length: 25922, dtype: int64" + "0 350.000000\n", + "1 350.000000\n", + "2 350.000000\n", + "3 291.779985\n", + "4 297.482719\n", + " ... \n", + "25918 267.445769\n", + "25919 276.532201\n", + "25920 263.564494\n", + "25921 273.482545\n", + "25922 200.000186\n", + "Name: power_draw, Length: 25923, dtype: float64" + ] + }, + "execution_count": 12, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "df_host_single.power_draw" + ] + }, + { + "cell_type": "code", + "execution_count": 13, + "id": "3c271734", + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "0 105000.000000\n", + "1 105000.000000\n", + "2 105000.000000\n", + "3 87533.995628\n", + "4 89244.815826\n", + " ... \n", + "25918 79980.733894\n", + "25919 80669.879478\n", + "25920 82337.210297\n", + "25921 79545.414650\n", + "25922 68917.601292\n", + "Name: energy_usage, Length: 25923, dtype: float64" ] }, - "execution_count": 146, + "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ - "df_host_single.timestamp.value_counts()" + "df_host_single.energy_usage" ] }, { "cell_type": "code", - "execution_count": 149, + "execution_count": 14, "id": "89977c44", "metadata": {}, "outputs": [ { "data": { "text/plain": [ - "array([50, 49, 48, 47, 46, 45, 44, 35, 34, 16, 15, 14, 13, 12, 11, 10])" + "0 1970-01-01 00:05:00+00:00\n", + "1 1970-01-01 00:10:00+00:00\n", + "2 1970-01-01 00:15:00+00:00\n", + "3 1970-01-01 00:20:00+00:00\n", + "4 1970-01-01 00:25:00+00:00\n", + " ... \n", + "25918 1970-03-31 23:55:00+00:00\n", + "25919 1970-04-01 00:00:00+00:00\n", + "25920 1970-04-01 00:05:00+00:00\n", + "25921 1970-04-01 00:10:00+00:00\n", + "25922 1970-04-01 00:14:12+00:00\n", + "Name: timestamp, Length: 25923, dtype: datetime64[ns, UTC]" ] }, - "execution_count": 149, + "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ - "df_server_single.timestamp.value_counts().unique()" + "df_host_single.timestamp" ] }, { |