{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "71852e5b-67d9-4de4-984a-6a0e95ee27b1", "metadata": { "tags": [] }, "outputs": [], "source": [ "%load_ext autoreload\n", "%autoreload 2" ] }, { "cell_type": "code", "execution_count": 2, "id": "b9a1069f-b23f-455e-a741-f855e13ddd8f", "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", " \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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
monthseasonhouryearholidaytemperaturefeeling_temphumiditywinspeedcasualregisteredcountwork yes or notam or pmDay of the week
\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\t\n", "\u000b", "\f", "\r", "\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\u001c", "\u001d", "\u001e", "\u001f !\"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…", "†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿdate
2011-01-012011-01-011winter02011no3.283.001481.00.0000313160am6
2011-01-011winter12011\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\u000b", "\f", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\u001c", "\u001d", "\u001e", "\u001f !\"#$%&'()*+...2.341.998280.00.0000832400am6
2011-01-011winter22011no2.341.998280.00.0000527320am6
2011-01-011winter32011no3.283.001475.00.0000310130am6
2011-01-011winter42011no3.283.001475.00.00000110am6
2011-01-011winter52011no3.281.001675.06.00320110am6
2011-01-011winter62011no2.341.998280.00.00002020am6
2011-01-011winter72011no1.401.001686.00.00001230am6
2011-01-011winter82011no3.283.001475.00.00001780am6
2011-01-011winter92011no7.047.001076.00.000086140am6
\n", "
" ], "text/plain": [ " month season \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", " 2011-01-01 1 winter \n", "\n", " hour year \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 0 2011 \n", " 2011-01-01 1 2011 \n", " 2011-01-01 2 2011 \n", " 2011-01-01 3 2011 \n", " 2011-01-01 4 2011 \n", " 2011-01-01 5 2011 \n", " 2011-01-01 6 2011 \n", " 2011-01-01 7 2011 \n", " 2011-01-01 8 2011 \n", " 2011-01-01 9 2011 \n", "\n", " holiday \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 no \n", " 2011-01-01 \u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+... \n", " 2011-01-01 no \n", " 2011-01-01 no \n", " 2011-01-01 no \n", " 2011-01-01 no \n", " 2011-01-01 no \n", " 2011-01-01 no \n", " 2011-01-01 no \n", " 2011-01-01 no \n", "\n", " temperature \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 3.28 \n", " 2011-01-01 2.34 \n", " 2011-01-01 2.34 \n", " 2011-01-01 3.28 \n", " 2011-01-01 3.28 \n", " 2011-01-01 3.28 \n", " 2011-01-01 2.34 \n", " 2011-01-01 1.40 \n", " 2011-01-01 3.28 \n", " 2011-01-01 7.04 \n", "\n", " feeling_temp \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 3.0014 \n", " 2011-01-01 1.9982 \n", " 2011-01-01 1.9982 \n", " 2011-01-01 3.0014 \n", " 2011-01-01 3.0014 \n", " 2011-01-01 1.0016 \n", " 2011-01-01 1.9982 \n", " 2011-01-01 1.0016 \n", " 2011-01-01 3.0014 \n", " 2011-01-01 7.0010 \n", "\n", " humidity \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 81.0 \n", " 2011-01-01 80.0 \n", " 2011-01-01 80.0 \n", " 2011-01-01 75.0 \n", " 2011-01-01 75.0 \n", " 2011-01-01 75.0 \n", " 2011-01-01 80.0 \n", " 2011-01-01 86.0 \n", " 2011-01-01 75.0 \n", " 2011-01-01 76.0 \n", "\n", " winspeed \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 0.0000 \n", " 2011-01-01 0.0000 \n", " 2011-01-01 0.0000 \n", " 2011-01-01 0.0000 \n", " 2011-01-01 0.0000 \n", " 2011-01-01 6.0032 \n", " 2011-01-01 0.0000 \n", " 2011-01-01 0.0000 \n", " 2011-01-01 0.0000 \n", " 2011-01-01 0.0000 \n", "\n", " casual \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 3 \n", " 2011-01-01 8 \n", " 2011-01-01 5 \n", " 2011-01-01 3 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 2 \n", " 2011-01-01 1 \n", " 2011-01-01 1 \n", " 2011-01-01 8 \n", "\n", " registered \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 13 \n", " 2011-01-01 32 \n", " 2011-01-01 27 \n", " 2011-01-01 10 \n", " 2011-01-01 1 \n", " 2011-01-01 1 \n", " 2011-01-01 0 \n", " 2011-01-01 2 \n", " 2011-01-01 7 \n", " 2011-01-01 6 \n", "\n", " count \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 16 \n", " 2011-01-01 40 \n", " 2011-01-01 32 \n", " 2011-01-01 13 \n", " 2011-01-01 1 \n", " 2011-01-01 1 \n", " 2011-01-01 2 \n", " 2011-01-01 3 \n", " 2011-01-01 8 \n", " 2011-01-01 14 \n", "\n", " work yes or not \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", " 2011-01-01 0 \n", "\n", " am or pm \\\n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", " 2011-01-01 am \n", "\n", " Day of the week \n", "\u0001\u0002\u0003\u0004\u0005\u0006\u0007\b\\t\\n\n", "\n", "\\r\u000e\u000f\u0010\u0011\u0012\u0013\u0014\u0015\u0016\u0017\u0018\u0019\u001a\u001b\n", "\n", "\n", "\u001f !\"#$%&'()*+,... date \n", "2011-01-01 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 \n", " 2011-01-01 6 " ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "df = pd.read_csv('./bike_sharing_dc.csv', parse_dates=['date'])[:10]\n", "strange_name = f\"{''.join([chr(i) for i in range(1, 256)])}\"\n", "df[strange_name] = df['date']\n", "df = df.set_index([strange_name, 'date'])\n", "df.iloc[1, 4] = strange_name\n", "df" ] }, { "cell_type": "code", "execution_count": 3, "id": "83efd0c8-bb46-41e8-be66-15eebe6de3e5", "metadata": { "tags": [] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", " \n", " \n", "
\n", " \n", "\n", "" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import pygwalker as pyg\n", "pyg.walk(df)" ] }, { "cell_type": "code", "execution_count": null, "id": "47e9f905-d6f4-496c-81cf-1d098c0c42c6", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "PyGWalker", "language": "python", "name": "pygwalker" }, "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.8.16" }, "widgets": { "application/vnd.jupyter.widget-state+json": { "state": {}, "version_major": 2, "version_minor": 0 } } }, "nbformat": 4, "nbformat_minor": 5 }