{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "provenance": [], "collapsed_sections": [ "CoofhZcDtp6R" ] }, "kernelspec": { "name": "python3", "display_name": "Python 3" }, "language_info": { "name": "python" } }, "cells": [ { "cell_type": "markdown", "source": [ "# Ноутбук для решения задач из 4 модуля\n", "\n" ], "metadata": { "id": "4uF_KywH0yV9" } }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "Yk-K_mHMs7ns", "colab": { "base_uri": "https://localhost:8080/" }, "outputId": "a8f9ef8c-735f-4551-a0f7-bb25f84cabf4" }, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m1.0/1.0 MB\u001b[0m \u001b[31m11.5 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m2.0/2.0 MB\u001b[0m \u001b[31m30.5 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m314.1/314.1 kB\u001b[0m \u001b[31m16.4 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m302.9/302.9 kB\u001b[0m \u001b[31m17.8 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m120.8/120.8 kB\u001b[0m \u001b[31m7.2 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m1.8/1.8 MB\u001b[0m \u001b[31m29.7 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m75.6/75.6 kB\u001b[0m \u001b[31m3.6 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m49.3/49.3 kB\u001b[0m \u001b[31m2.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m77.9/77.9 kB\u001b[0m \u001b[31m6.4 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m58.3/58.3 kB\u001b[0m \u001b[31m4.8 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m53.0/53.0 kB\u001b[0m \u001b[31m2.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m142.5/142.5 kB\u001b[0m \u001b[31m4.3 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n", "\u001b[?25h" ] } ], "source": [ "!pip install langchain langchain-community huggingface_hub langchain-openai openai langchainhub -q" ] }, { "cell_type": "markdown", "source": [ "## Если используете ключ от OpenAI, запустите эту ячейку 👇\n", "\n", "\n", "\n", "\n", "\n" ], "metadata": { "id": "CoofhZcDtp6R" } }, { "cell_type": "code", "source": [ "from langchain_openai import ChatOpenAI\n", "import os\n", "from getpass import getpass\n", "\n", "\n", "# os.environ['OPENAI_API_KEY'] = \"Введите ваш OpenAI API ключ\"\n", "os.environ['OPENAI_API_KEY'] = getpass(prompt='Введите ваш OpenAI API ключ')\n", "\n", "# Инициализируем языковую модель\n", "llm = ChatOpenAI(temperature=0.0)" ], "metadata": { "id": "k48wWXnPtKa2" }, "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "source": [ "## Если используете ключ из курса, запустите эти ячейки 👇\n" ], "metadata": { "id": "DiQqMwQJt8rP" } }, { "cell_type": "code", "source": [ "!wget https://raw.githubusercontent.com/a-milenkin/LLM_practical_course/main/notebooks/utils.py" ], "metadata": { "id": "Keq0WAjLuPgJ", "colab": { "base_uri": "https://localhost:8080/" }, "outputId": "8fc60a48-7298-4a75-f800-473be4ad48c1" }, "execution_count": null, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "--2024-05-08 23:23:01-- https://raw.githubusercontent.com/a-milenkin/LLM_practical_course/main/notebooks/utils.py\n", "Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.199.108.133, 185.199.109.133, 185.199.110.133, ...\n", "Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.199.108.133|:443... connected.\n", "HTTP request sent, awaiting response... 200 OK\n", "Length: 11184 (11K) [text/plain]\n", "Saving to: ‘utils.py’\n", "\n", "\rutils.py 0%[ ] 0 --.-KB/s \rutils.py 100%[===================>] 10.92K --.-KB/s in 0s \n", "\n", "2024-05-08 23:23:02 (67.1 MB/s) - ‘utils.py’ saved [11184/11184]\n", "\n" ] } ] }, { "cell_type": "code", "source": [ "from utils import ChatOpenAI\n", "from getpass import getpass\n", "\n", "#course_api_key= \"Введите ваш API ключ с курса\"\n", "course_api_key = getpass(prompt='Введите API ключ')\n", "\n", "# Инициализируем языковую модель\n", "llm = ChatOpenAI(temperature=0.0, course_api_key=course_api_key)" ], "metadata": { "id": "PCS_WedHtPRg", "colab": { "base_uri": "https://localhost:8080/" }, "outputId": "792ce614-cac1-410d-ba29-0f5219b7edac" }, "execution_count": null, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Введите API ключ··········\n" ] } ] }, { "cell_type": "markdown", "source": [ "## Задание из стэпа 9 📊Задача на SQL-агента.🕵️‍♂️\n" ], "metadata": { "id": "okESYbnsXoJM" } }, { "cell_type": "code", "source": [ "# Установим postgres сервер\n", "!sudo apt-get -y -qq update\n", "!sudo apt-get -y -qq install postgresql\n", "!sudo service postgresql start\n", "\n", "# установим пароль `postgres` для пользователя `postgres`\n", "!sudo -u postgres psql -U postgres -c \"ALTER USER postgres PASSWORD 'postgres';\"" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "gtDOHnboXjQ1", "outputId": "08e5a04f-fba4-4fcd-848f-7c0c69dcab98" }, "execution_count": null, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "debconf: unable to initialize frontend: Dialog\n", "debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78, <> line 13.)\n", "debconf: falling back to frontend: Readline\n", "debconf: unable to initialize frontend: Readline\n", "debconf: (This frontend requires a controlling tty.)\n", "debconf: falling back to frontend: Teletype\n", "dpkg-preconfigure: unable to re-open stdin: \n", "Selecting previously unselected package logrotate.\n", "(Reading database ... 121918 files and directories currently installed.)\n", "Preparing to unpack .../00-logrotate_3.19.0-1ubuntu1.1_amd64.deb ...\n", "Unpacking logrotate (3.19.0-1ubuntu1.1) ...\n", "Selecting previously unselected package netbase.\n", "Preparing to unpack .../01-netbase_6.3_all.deb ...\n", "Unpacking netbase (6.3) ...\n", "Selecting previously unselected package libcommon-sense-perl:amd64.\n", "Preparing to unpack .../02-libcommon-sense-perl_3.75-2build1_amd64.deb ...\n", "Unpacking libcommon-sense-perl:amd64 (3.75-2build1) ...\n", "Selecting previously unselected package libjson-perl.\n", "Preparing to unpack .../03-libjson-perl_4.04000-1_all.deb ...\n", "Unpacking libjson-perl (4.04000-1) ...\n", "Selecting previously unselected package libtypes-serialiser-perl.\n", "Preparing to unpack .../04-libtypes-serialiser-perl_1.01-1_all.deb ...\n", "Unpacking libtypes-serialiser-perl (1.01-1) ...\n", "Selecting previously unselected package libjson-xs-perl.\n", "Preparing to unpack .../05-libjson-xs-perl_4.030-1build3_amd64.deb ...\n", "Unpacking libjson-xs-perl (4.030-1build3) ...\n", "Selecting previously unselected package postgresql-client-common.\n", "Preparing to unpack .../06-postgresql-client-common_238_all.deb ...\n", "Unpacking postgresql-client-common (238) ...\n", "Selecting previously unselected package postgresql-client-14.\n", "Preparing to unpack .../07-postgresql-client-14_14.11-0ubuntu0.22.04.1_amd64.deb ...\n", "Unpacking postgresql-client-14 (14.11-0ubuntu0.22.04.1) ...\n", "Selecting previously unselected package ssl-cert.\n", "Preparing to unpack .../08-ssl-cert_1.1.2_all.deb ...\n", "Unpacking ssl-cert (1.1.2) ...\n", "Selecting previously unselected package postgresql-common.\n", "Preparing to unpack .../09-postgresql-common_238_all.deb ...\n", "Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'\n", "Unpacking postgresql-common (238) ...\n", "Selecting previously unselected package postgresql-14.\n", "Preparing to unpack .../10-postgresql-14_14.11-0ubuntu0.22.04.1_amd64.deb ...\n", "Unpacking postgresql-14 (14.11-0ubuntu0.22.04.1) ...\n", "Selecting previously unselected package postgresql.\n", "Preparing to unpack .../11-postgresql_14+238_all.deb ...\n", "Unpacking postgresql (14+238) ...\n", "Selecting previously unselected package sysstat.\n", "Preparing to unpack .../12-sysstat_12.5.2-2ubuntu0.2_amd64.deb ...\n", "Unpacking sysstat (12.5.2-2ubuntu0.2) ...\n", "Setting up logrotate (3.19.0-1ubuntu1.1) ...\n", "Created symlink /etc/systemd/system/timers.target.wants/logrotate.timer → /lib/systemd/system/logrotate.timer.\n", "Setting up libcommon-sense-perl:amd64 (3.75-2build1) ...\n", "Setting up ssl-cert (1.1.2) ...\n", "debconf: unable to initialize frontend: Dialog\n", "debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)\n", "debconf: falling back to frontend: Readline\n", "Setting up libtypes-serialiser-perl (1.01-1) ...\n", "Setting up libjson-perl (4.04000-1) ...\n", "Setting up netbase (6.3) ...\n", "Setting up sysstat (12.5.2-2ubuntu0.2) ...\n", "debconf: unable to initialize frontend: Dialog\n", "debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)\n", "debconf: falling back to frontend: Readline\n", "\n", "Creating config file /etc/default/sysstat with new version\n", "update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar (sar) in auto mode\n", "Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-collect.timer → /lib/systemd/system/sysstat-collect.timer.\n", "Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-summary.timer → /lib/systemd/system/sysstat-summary.timer.\n", "Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /lib/systemd/system/sysstat.service.\n", "Setting up postgresql-client-common (238) ...\n", "Setting up libjson-xs-perl (4.030-1build3) ...\n", "Setting up postgresql-client-14 (14.11-0ubuntu0.22.04.1) ...\n", "update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode\n", "Setting up postgresql-common (238) ...\n", "debconf: unable to initialize frontend: Dialog\n", "debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)\n", "debconf: falling back to frontend: Readline\n", "Adding user postgres to group ssl-cert\n", "\n", "Creating config file /etc/postgresql-common/createcluster.conf with new version\n", "Building PostgreSQL dictionaries from installed myspell/hunspell packages...\n", "Removing obsolete dictionary files:\n", "Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service.\n", "Setting up postgresql-14 (14.11-0ubuntu0.22.04.1) ...\n", "debconf: unable to initialize frontend: Dialog\n", "debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)\n", "debconf: falling back to frontend: Readline\n", "Creating new PostgreSQL cluster 14/main ...\n", "/usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions\n", "The files belonging to this database system will be owned by user \"postgres\".\n", "This user must also own the server process.\n", "\n", "The database cluster will be initialized with locale \"en_US.UTF-8\".\n", "The default database encoding has accordingly been set to \"UTF8\".\n", "The default text search configuration will be set to \"english\".\n", "\n", "Data page checksums are disabled.\n", "\n", "fixing permissions on existing directory /var/lib/postgresql/14/main ... ok\n", "creating subdirectories ... ok\n", "selecting dynamic shared memory implementation ... posix\n", "selecting default max_connections ... 100\n", "selecting default shared_buffers ... 128MB\n", "selecting default time zone ... Etc/UTC\n", "creating configuration files ... ok\n", "running bootstrap script ... ok\n", "performing post-bootstrap initialization ... ok\n", "syncing data to disk ... ok\n", "update-alternatives: using /usr/share/postgresql/14/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode\n", "invoke-rc.d: could not determine current runlevel\n", "invoke-rc.d: policy-rc.d denied execution of start.\n", "Setting up postgresql (14+238) ...\n", "Processing triggers for man-db (2.10.2-1) ...\n", " * Starting PostgreSQL 14 database server\n", " ...done.\n", "ALTER ROLE\n" ] } ] }, { "cell_type": "markdown", "source": [ "Создаем базу, пользователя и предоставляем нужные права.\n" ], "metadata": { "id": "CMzQ-qUD75-m" } }, { "cell_type": "code", "source": [ "!sudo -u postgres psql -U postgres -c \"CREATE DATABASE dvdrental;\" # CREATE DATABASE\n", "!sudo -u postgres psql -U postgres -c \"create user root with encrypted password 'mypass';\" # CREATE ROLE\n", "!sudo -u postgres psql -U postgres -c \"GRANT postgres TO root;\" # GRANT ROLE\n", "!sudo -u postgres psql -U postgres -c \"grant all privileges on database dvdrental to root;\" # GRANT" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "rYX41roSXjN-", "outputId": "50c12463-3fa2-4465-a61c-1f31e0f5c4e4" }, "execution_count": null, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "CREATE DATABASE\n", "CREATE ROLE\n", "GRANT ROLE\n", "GRANT\n" ] } ] }, { "cell_type": "code", "source": [ "# создаем базу из резервной копии\n", "!wget https://stepik.org/media/attachments/lesson/1107866/dvdrental.tar\n", "!sudo pg_restore -U root -d dvdrental /content/dvdrental.tar" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "BQoWz9ZJXjLZ", "outputId": "a46139e6-0c66-4a53-e46b-dd7d94d13cb2" }, "execution_count": null, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "--2024-05-08 23:23:52-- https://stepik.org/media/attachments/lesson/1107866/dvdrental.tar\n", "Resolving stepik.org (stepik.org)... 178.248.239.111\n", "Connecting to stepik.org (stepik.org)|178.248.239.111|:443... connected.\n", "HTTP request sent, awaiting response... 200 OK\n", "Length: 2835456 (2.7M) [application/x-tar]\n", "Saving to: ‘dvdrental.tar’\n", "\n", "dvdrental.tar 100%[===================>] 2.70M 3.47MB/s in 0.8s \n", "\n", "2024-05-08 23:23:53 (3.47 MB/s) - ‘dvdrental.tar’ saved [2835456/2835456]\n", "\n" ] } ] }, { "cell_type": "code", "source": [ "from langchain_community.utilities import SQLDatabase\n", "\n", "# подключимся к базе\n", "db = SQLDatabase.from_uri(\"postgresql+psycopg2://root:mypass@localhost:5432/dvdrental\")\n", "print(db.dialect)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "eZdef16iXjIh", "outputId": "5d60aa29-c160-434d-9e6d-6fb329530dcd" }, "execution_count": null, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "postgresql\n" ] } ] }, { "cell_type": "markdown", "source": [ "Создаем агента и вручаем ему инструменты" ], "metadata": { "id": "6hbw9CbFCVCZ" } }, { "cell_type": "code", "source": [ "from langchain_community.agent_toolkits import create_sql_agent\n", "from langchain.agents.agent_toolkits import SQLDatabaseToolkit\n", "\n", "toolkit = SQLDatabaseToolkit(db=db, llm=llm)\n", "\n", "agent_executor = create_sql_agent(llm,\n", " toolkit=toolkit,\n", " verbose=False) # мы не хотим видеть промежуточные шаги" ], "metadata": { "id": "1LBYMk_hakoE" }, "execution_count": null, "outputs": [] }, { "cell_type": "code", "source": [ "# Загружаем датасет с вопросами к базе\n", "import pandas as pd\n", "df = pd.read_csv(\"https://stepik.org/media/attachments/lesson/1107866/rental_dvd.csv\")" ], "metadata": { "id": "weiMzxz5aklR" }, "execution_count": null, "outputs": [] }, { "cell_type": "code", "source": [ "answers = [] # Список, где будем хранить ответы модели\n", "\n", "for text_input in tqdm(df['question']):\n", " answer = agent_executor.invoke({'input': text_input})\n", " answers.append(answer['output']) # Добавляем ответ в список\n", " #break # Для отладки. Уберите, когда убедитесь, что на одном примере работает" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "uWDnC-Uiakez", "outputId": "dc8ddccf-9bf4-404a-d4b8-09cd7982f981" }, "execution_count": null, "outputs": [ { "output_type": "stream", "name": "stderr", "text": [ "100%|██████████| 5/5 [00:45<00:00, 9.13s/it]\n" ] } ] }, { "cell_type": "code", "source": [ "df['answer'] = answers # Создаём новый столбец из ответов модели" ], "metadata": { "id": "xHDAt0_3wrRi" }, "execution_count": null, "outputs": [] }, { "cell_type": "code", "source": [ "df" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "Cezh8BalEioR", "outputId": "3559669b-589a-4f11-82cb-bf21efdaeffb" }, "execution_count": null, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " question \\\n", "0 Какой e-mail у клиента Enrique Forsythe? \n", "1 Фильмы с каким рейтингом преобладают в коллекции? \n", "2 Название самого короткого фильма с актером Joh... \n", "3 Из какой страны сотрудник Mike Hillyer? Ответ ... \n", "4 Какой средний рейтинг (rental_rate) фильмов, к... \n", "\n", " answer \n", "0 enrique.forsythe@sakilacustomer.org \n", "1 Фильмы с рейтингом \"PG-13\" преобладают в колле... \n", "2 The shortest film with actor Johnny Lollobrigi... \n", "3 Канада \n", "4 $2.91 " ], "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", "
questionanswer
0Какой e-mail у клиента Enrique Forsythe?enrique.forsythe@sakilacustomer.org
1Фильмы с каким рейтингом преобладают в коллекции?Фильмы с рейтингом \"PG-13\" преобладают в колле...
2Название самого короткого фильма с актером Joh...The shortest film with actor Johnny Lollobrigi...
3Из какой страны сотрудник Mike Hillyer? Ответ ...Канада
4Какой средний рейтинг (rental_rate) фильмов, к...$2.91
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", " \n", " \n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "df", "summary": "{\n \"name\": \"df\",\n \"rows\": 5,\n \"fields\": [\n {\n \"column\": \"question\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 5,\n \"samples\": [\n \"\\u0424\\u0438\\u043b\\u044c\\u043c\\u044b \\u0441 \\u043a\\u0430\\u043a\\u0438\\u043c \\u0440\\u0435\\u0439\\u0442\\u0438\\u043d\\u0433\\u043e\\u043c \\u043f\\u0440\\u0435\\u043e\\u0431\\u043b\\u0430\\u0434\\u0430\\u044e\\u0442 \\u0432 \\u043a\\u043e\\u043b\\u043b\\u0435\\u043a\\u0446\\u0438\\u0438?\",\n \"\\u041a\\u0430\\u043a\\u043e\\u0439 \\u0441\\u0440\\u0435\\u0434\\u043d\\u0438\\u0439 \\u0440\\u0435\\u0439\\u0442\\u0438\\u043d\\u0433 (rental_rate) \\u0444\\u0438\\u043b\\u044c\\u043c\\u043e\\u0432, \\u043a\\u043e\\u0442\\u043e\\u0440\\u044b\\u0435 \\u0434\\u043b\\u044f\\u0442\\u0441\\u044f \\u043c\\u0435\\u043d\\u044c\\u0448\\u0435 \\u0447\\u0430\\u0441\\u0430?\",\n \"\\u041d\\u0430\\u0437\\u0432\\u0430\\u043d\\u0438\\u0435 \\u0441\\u0430\\u043c\\u043e\\u0433\\u043e \\u043a\\u043e\\u0440\\u043e\\u0442\\u043a\\u043e\\u0433\\u043e \\u0444\\u0438\\u043b\\u044c\\u043c\\u0430 \\u0441 \\u0430\\u043a\\u0442\\u0435\\u0440\\u043e\\u043c Johnny Lollobrigida.\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"answer\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 5,\n \"samples\": [\n \"\\u0424\\u0438\\u043b\\u044c\\u043c\\u044b \\u0441 \\u0440\\u0435\\u0439\\u0442\\u0438\\u043d\\u0433\\u043e\\u043c \\\"PG-13\\\" \\u043f\\u0440\\u0435\\u043e\\u0431\\u043b\\u0430\\u0434\\u0430\\u044e\\u0442 \\u0432 \\u043a\\u043e\\u043b\\u043b\\u0435\\u043a\\u0446\\u0438\\u0438.\",\n \"$2.91\",\n \"The shortest film with actor Johnny Lollobrigida is \\\"Chamber Italian\\\" with a length of 117 minutes.\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" } }, "metadata": {}, "execution_count": 68 } ] }, { "cell_type": "code", "source": [ "df.to_csv('step_9_solution.csv', index=False) # Сохраняем файл, отправляем на Stepik, получаем баллы :)" ], "metadata": { "id": "xWZe_a59dG3K" }, "execution_count": null, "outputs": [] } ] }