{ "cells": [ { "cell_type": "code", "execution_count": 9, "id": "60b87c23-996d-4c80-8846-f30e6bf9ebfc", "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Token successfully refreshed.\n" ] } ], "source": [ "%update_token" ] }, { "cell_type": "code", "execution_count": 10, "id": "d2038e9a-9c82-4898-b121-babc4dd156b2", "metadata": { "tags": [] }, "outputs": [], "source": [ "import warnings\n", "warnings.filterwarnings(\"ignore\")" ] }, { "cell_type": "code", "execution_count": 11, "id": "78a98f8c-1752-45ea-a42f-bf37d3862f39", "metadata": { "tags": [] }, "outputs": [ { "data": { "text/html": [ "Running query in 'presto://ezpresto-sts-mst-0.ezpresto-svc-hdl.ezpresto.svc.cluster.local:8081'" ], "text/plain": [ "Running query in 'presto://ezpresto-sts-mst-0.ezpresto-svc-hdl.ezpresto.svc.cluster.local:8081'" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stderr", "output_type": "stream", "text": [ "select * from cache.retail.retailagg1\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
storeyearcountrytotqtytotsales
Store D2021Czech Republic141506520763310.75
Store D2019Swiss29247150394023854.99
Store E2021Swiss29714055400286738.09
Store A2023Swiss33516058451288092.37
Store D2023Swiss46174112621087039.29
Store E2019Czech Republic139289924136123.33
Store A2020Czech Republic215524832678250.64
Store B2020Swiss69268812958354298.13
Store C2022Swiss38640558550076306.28
Store B2023Swiss28926638389724220.29
\n", "ResultSet : to convert to pandas, call .DataFrame() or to polars, call .PolarsDataFrame()
\n", "Truncated to displaylimit of 10
If you want to see more, please visit displaylimit configuration" ], "text/plain": [ "+---------+------+----------------+----------+--------------+\n", "| store | year | country | totqty | totsales |\n", "+---------+------+----------------+----------+--------------+\n", "| Store D | 2021 | Czech Republic | 1415065 | 20763310.75 |\n", "| Store D | 2019 | Swiss | 29247150 | 394023854.99 |\n", "| Store E | 2021 | Swiss | 29714055 | 400286738.09 |\n", "| Store A | 2023 | Swiss | 33516058 | 451288092.37 |\n", "| Store D | 2023 | Swiss | 46174112 | 621087039.29 |\n", "| Store E | 2019 | Czech Republic | 1392899 | 24136123.33 |\n", "| Store A | 2020 | Czech Republic | 2155248 | 32678250.64 |\n", "| Store B | 2020 | Swiss | 69268812 | 958354298.13 |\n", "| Store C | 2022 | Swiss | 38640558 | 550076306.28 |\n", "| Store B | 2023 | Swiss | 28926638 | 389724220.29 |\n", "+---------+------+----------------+----------+--------------+" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%%sql\n", "select * from cache.retail.retailagg1" ] }, { "cell_type": "code", "execution_count": 12, "id": "51a46f64-e18a-4a4c-9b43-ebacacdb2057", "metadata": {}, "outputs": [ { "data": { "text/html": [ "Running query in 'presto://ezpresto-sts-mst-0.ezpresto-svc-hdl.ezpresto.svc.cluster.local:8081'" ], "text/plain": [ "Running query in 'presto://ezpresto-sts-mst-0.ezpresto-svc-hdl.ezpresto.svc.cluster.local:8081'" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stderr", "output_type": "stream", "text": [ "(select * from cache.retail.retailagg1)\n" ] } ], "source": [ "output = %sql (select * from cache.retail.retailagg1)" ] }, { "cell_type": "code", "execution_count": 13, "id": "5b9ec60c-739f-41cb-81c3-143dee5f50e4", "metadata": { "tags": [] }, "outputs": [ { "data": { "text/plain": [ "sql.run.resultset.ResultSet" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "type(output)" ] }, { "cell_type": "code", "execution_count": 14, "id": "a542a51a-b1f1-47d2-aaf9-023a15080a57", "metadata": { "tags": [] }, "outputs": [ { "data": { "text/plain": [ "pandas.core.frame.DataFrame" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = output.DataFrame()\n", "type(df)" ] }, { "cell_type": "code", "execution_count": 15, "id": "76614a4b-6696-470a-be9d-f57ab8fa48e2", "metadata": { "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 50 entries, 0 to 49\n", "Data columns (total 5 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 store 50 non-null object\n", " 1 year 50 non-null int64 \n", " 2 country 50 non-null object\n", " 3 totqty 50 non-null int64 \n", " 4 totsales 50 non-null object\n", "dtypes: int64(2), object(3)\n", "memory usage: 2.1+ KB\n" ] } ], "source": [ "df.info()" ] }, { "cell_type": "code", "execution_count": 16, "id": "a1e8d574-0268-42ea-a78d-b0a62e9b36cb", "metadata": { "tags": [] }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
storeyearcountrytotqtytotsales
45Store A2021Czech Republic161737623730424.94
46Store B2021Czech Republic70440910338684.56
47Store C2019Czech Republic140303723444291.23
48Store D2020Czech Republic252242836377005.10
49Store C2023Czech Republic207687132298143.98
\n", "
" ], "text/plain": [ " store year country totqty totsales\n", "45 Store A 2021 Czech Republic 1617376 23730424.94\n", "46 Store B 2021 Czech Republic 704409 10338684.56\n", "47 Store C 2019 Czech Republic 1403037 23444291.23\n", "48 Store D 2020 Czech Republic 2522428 36377005.10\n", "49 Store C 2023 Czech Republic 2076871 32298143.98" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.tail()" ] }, { "cell_type": "code", "execution_count": null, "id": "d60fadd2-c889-41ee-8087-cad54fac8f6f", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.9" } }, "nbformat": 4, "nbformat_minor": 5 }