Final_Amazon_Reviews_ETL.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Final_Amazon_Reviews_ETL.ipynb","provenance":[{"file_id":"1zUp0uAMnHQbRM_GOYeo1703NZk2s7Vvh","timestamp":1612753390569}],"collapsed_sections":[]},"kernelspec":{"display_name":"PythonData","language":"python","name":"pythondata"},"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.7.7"},"nteract":{"version":"0.12.3"}},"cells":[{"cell_type":"code","metadata":{"id":"V58rxea0HqSa","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1612744324243,"user_tz":360,"elapsed":34901,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"26f92b03-555f-4038-8bb8-f7a6ab72954b"},"source":["# Deliverable 1: Perform ETL on Amazon Product Reviews \n","import os\n","# Find the latest version of spark 2.0  from http://www-us.apache.org/dist/spark/ and enter as the spark version\n","# For example:\n","# spark_version = 'spark-3.0.0'\n","spark_version = 'spark-3.0.1'\n","os.environ['SPARK_VERSION']=spark_version\n","\n","# Install Spark and Java\n","!apt-get update\n","!apt-get install openjdk-11-jdk-headless -qq > /dev/null\n","!wget -q http://www-us.apache.org/dist/spark/$SPARK_VERSION/$SPARK_VERSION-bin-hadoop2.7.tgz\n","!tar xf $SPARK_VERSION-bin-hadoop2.7.tgz\n","!pip install -q findspark\n","\n","# Set Environment Variables\n","import os\n","os.environ[\"JAVA_HOME\"] = \"/usr/lib/jvm/java-11-openjdk-amd64\"\n","os.environ[\"SPARK_HOME\"] = f\"/content/{spark_version}-bin-hadoop2.7\"\n","\n","# Start a SparkSession\n","import findspark\n","findspark.init()"],"execution_count":null,"outputs":[{"output_type":"stream","text":["Hit:1 https://cloud.r-project.org/bin/linux/ubuntu bionic-cran40/ InRelease\n","Ign:2 https://developer.download.nvidia.com/compute/cuda/repos/ubuntu1804/x86_64  InRelease\n","Get:3 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]\n","Ign:4 https://developer.download.nvidia.com/compute/machine-learning/repos/ubuntu1804/x86_64  InRelease\n","Hit:5 https://developer.download.nvidia.com/compute/cuda/repos/ubuntu1804/x86_64  Release\n","Hit:6 https://developer.download.nvidia.com/compute/machine-learning/repos/ubuntu1804/x86_64  Release\n","Hit:7 http://archive.ubuntu.com/ubuntu bionic InRelease\n","Hit:8 http://ppa.launchpad.net/c2d4u.team/c2d4u4.0+/ubuntu bionic InRelease\n","Get:10 http://archive.ubuntu.com/ubuntu bionic-updates InRelease [88.7 kB]\n","Hit:12 http://ppa.launchpad.net/cran/libgit2/ubuntu bionic InRelease\n","Hit:13 http://ppa.launchpad.net/graphics-drivers/ppa/ubuntu bionic InRelease\n","Get:14 http://archive.ubuntu.com/ubuntu bionic-backports InRelease [74.6 kB]\n","Fetched 252 kB in 2s (110 kB/s)\n","Reading package lists... Done\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"_xKwTpATHqSe","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1612744326187,"user_tz":360,"elapsed":36829,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"0433056b-e7ff-4843-ae0b-82dc3f79c4d9"},"source":["# Download the Postgres driver that will allow Spark to interact with Postgres.\n","!wget https://jdbc.postgresql.org/download/postgresql-42.2.16.jar"],"execution_count":null,"outputs":[{"output_type":"stream","text":["--2021-02-08 00:32:03--  https://jdbc.postgresql.org/download/postgresql-42.2.16.jar\n","Resolving jdbc.postgresql.org (jdbc.postgresql.org)... 72.32.157.228, 2001:4800:3e1:1::228\n","Connecting to jdbc.postgresql.org (jdbc.postgresql.org)|72.32.157.228|:443... connected.\n","HTTP request sent, awaiting response... 200 OK\n","Length: 1002883 (979K) [application/java-archive]\n","Saving to: ‘postgresql-42.2.16.jar.3’\n","\n","postgresql-42.2.16. 100%[===================>] 979.38K  1.21MB/s    in 0.8s    \n","\n","2021-02-08 00:32:05 (1.21 MB/s) - ‘postgresql-42.2.16.jar.3’ saved [1002883/1002883]\n","\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"MMqDAjVS0KN9"},"source":["from pyspark.sql import SparkSession\n","spark = SparkSession.builder.appName(\"BigData-Challenge\").config(\"spark.driver.extraClassPath\",\"/content/postgresql-42.2.16.jar\").getOrCreate()"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"cyBsySGuY-9V"},"source":["### Load Amazon Data into Spark DataFrame"]},{"cell_type":"code","metadata":{"id":"CtCmBhQJY-9Z","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1612744351371,"user_tz":360,"elapsed":61998,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"834048f2-639d-4350-ec0a-597bb44b3ea3"},"source":["from pyspark import SparkFiles\n","url = \"https://s3.amazonaws.com/amazon-reviews-pds/tsv/amazon_reviews_us_Digital_Video_Games_v1_00.tsv.gz\"\n","spark.sparkContext.addFile(url)\n","df = spark.read.option(\"encoding\", \"UTF-8\").csv(SparkFiles.get(\"amazon_reviews_us_Digital_Video_Games_v1_00.tsv.gz\"), sep=\"\\t\", header=True, inferSchema=True)\n","df.show()"],"execution_count":null,"outputs":[{"output_type":"stream","text":["+-----------+-----------+--------------+----------+--------------+--------------------+-------------------+-----------+-------------+-----------+----+-----------------+--------------------+--------------------+-----------+\n","|marketplace|customer_id|     review_id|product_id|product_parent|       product_title|   product_category|star_rating|helpful_votes|total_votes|vine|verified_purchase|     review_headline|         review_body|review_date|\n","+-----------+-----------+--------------+----------+--------------+--------------------+-------------------+-----------+-------------+-----------+----+-----------------+--------------------+--------------------+-----------+\n","|         US|   21269168| RSH1OZ87OYK92|B013PURRZW|     603406193|Madden NFL 16 - X...|Digital_Video_Games|          2|            2|          3|   N|                N|A slight improvem...|I keep buying mad...| 2015-08-31|\n","|         US|     133437|R1WFOQ3N9BO65I|B00F4CEHNK|     341969535| Xbox Live Gift Card|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|             Awesome| 2015-08-31|\n","|         US|   45765011| R3YOOS71KM5M9|B00DNHLFQA|     951665344|Command & Conquer...|Digital_Video_Games|          5|            0|          0|   N|                Y|Hail to the great...|If you are preppi...| 2015-08-31|\n","|         US|     113118|R3R14UATT3OUFU|B004RMK5QG|     395682204|Playstation Plus ...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|             Perfect| 2015-08-31|\n","|         US|   22151364| RV2W9SGDNQA2C|B00G9BNLQE|     640460561|Saints Row IV - E...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|            Awesome!| 2015-08-31|\n","|         US|   22151364|R3CFKLIZ0I2KOB|B00IMIL498|     621922192|Double Dragon: Ne...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|            Awesome!| 2015-08-31|\n","|         US|   38426028|R1LRYU1V0T3O38|B00S00IJH8|     215163395|              Sims 4|Digital_Video_Games|          4|            0|          0|   N|                Y|i like the new sk...|i like the new sk...| 2015-08-31|\n","|         US|    6057518| R44QKV6FE5CJ2|B004RMK4BC|     384246568|Playstation Netwo...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|               Super| 2015-08-31|\n","|         US|   20715661|R2TX1KLPXXXNYS|B00K59HKIQ|     384246568|Playstation Netwo...|Digital_Video_Games|          5|            0|          0|   N|                Y|         Easy & Fast|Excellent, fast a...| 2015-08-31|\n","|         US|   26540306|R1JEEW4C6R89BA|B00K59HKIQ|     384246568|Playstation Netwo...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|                  Ok| 2015-08-31|\n","|         US|    8926809|R3B3UHK1FO0ERS|B004774IPU|     151985175|Sid Meier's Civil...|Digital_Video_Games|          1|            0|          0|   N|                N|I am still playin...|As has been writt...| 2015-08-31|\n","|         US|   31525534|R2GVSDHW513SS1|B002LIT9EC|     695277014|Build-a-lot 4: Po...|Digital_Video_Games|          5|            0|          0|   N|                Y|Probably the best...|Probably the best...| 2015-08-31|\n","|         US|   22151364|R1R1NT516PYT73|B008ALUBYQ|     112160022|       Borderlands 2|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|            Awesome!| 2015-08-31|\n","|         US|   22977584|R3K624QDQKENN9|B010KYDNDG|     835376637|Minecraft for PC/...|Digital_Video_Games|          4|            0|          0|   N|                Y|                 FUN|COOL BUT IT LAGES...| 2015-08-31|\n","|         US|   45765011| R1FOXH7PCJX3V|B008ALUBYQ|     112160022|       Borderlands 2|Digital_Video_Games|          1|            0|          2|   N|                Y|            One Star|Lames purchase I ...| 2015-08-31|\n","|         US|    2239522| RA1246M1OMDWC|B004RMK4P8|     384246568|Playstation Netwo...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|               Great| 2015-08-31|\n","|         US|   48805811|R2I9SXWB0PAEKQ|B004RMK5QG|     395682204|Playstation Plus ...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|          Awesome!!!| 2015-08-31|\n","|         US|   18646481|R3UGL544NA0G9C|B00BI16Z22|     552981447|Brink of Consciou...|Digital_Video_Games|          4|            0|          0|   N|                Y|       worth playing|pretty good but n...| 2015-08-31|\n","|         US|   10310935|R1CBA4Y92GVAVM|B004VSTQ2A|     232803743|Xbox Live Subscri...|Digital_Video_Games|          5|            0|          0|   N|                Y|          Five Stars|What can I say......| 2015-08-31|\n","|         US|    5587610|R24NEKNR01VEHU|B00GAC1D2G|     384246568|Playstation Netwo...|Digital_Video_Games|          5|            0|          0|   N|                Y|        Just amazing|Very fast to rece...| 2015-08-31|\n","+-----------+-----------+--------------+----------+--------------+--------------------+-------------------+-----------+-------------+-----------+----+-----------------+--------------------+--------------------+-----------+\n","only showing top 20 rows\n","\n"],"name":"stdout"}]},{"cell_type":"markdown","metadata":{"id":"2yUSe55VY-9t"},"source":["### Create DataFrames to match tables"]},{"cell_type":"code","metadata":{"id":"C8REmY1aY-9u"},"source":["from pyspark.sql.functions import to_date\n","# Read in the Review dataset as a DataFrame"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"B0TESUDRY-90","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1612744354869,"user_tz":360,"elapsed":65484,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"4e57cd38-7879-42d0-a662-61f04cbba9d6"},"source":["# Create the customers_table DataFrame\n","customers_df = df.groupby(\"customer_id\").agg({'customer_id': 'count'}).withColumnRenamed(\"count(customer_id)\", \"customer_count\")\n","customers_df.show(10)"],"execution_count":null,"outputs":[{"output_type":"stream","text":["+-----------+--------------+\n","|customer_id|customer_count|\n","+-----------+--------------+\n","|   26079415|             1|\n","|   12521601|             2|\n","|    4593696|             1|\n","|    1468259|             1|\n","|   38173350|             1|\n","|    3953141|             2|\n","|   20598424|             1|\n","|   46625306|             1|\n","|   47160828|             2|\n","|    1337034|             1|\n","+-----------+--------------+\n","only showing top 10 rows\n","\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"ODqUEIYQsnZq","executionInfo":{"status":"ok","timestamp":1612744359876,"user_tz":360,"elapsed":70484,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"325e478b-2026-4e54-d19b-089096f2ed35"},"source":["customers_df.count()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["113405"]},"metadata":{"tags":[]},"execution_count":7}]},{"cell_type":"code","metadata":{"id":"4FwXA6UvY-96","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1612744362534,"user_tz":360,"elapsed":73136,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"486e322d-e350-489a-8061-6b06c181fdf1"},"source":["# Create the products_table DataFrame and drop duplicates. \n","products_df = df.select(['product_id', 'product_title']).drop_duplicates(['product_id'])\n","products_df.show(10)"],"execution_count":null,"outputs":[{"output_type":"stream","text":["+----------+--------------------+\n","|product_id|       product_title|\n","+----------+--------------------+\n","|B001KC02UA|Happy Hour! [Down...|\n","|B002FGU06Q|Tradewinds Odysse...|\n","|B002MUB0N2|Word Harmony [Dow...|\n","|B002N5NAXY|Continental Cafe ...|\n","|B0030EFVA2|688I Hunter Kille...|\n","|B0030GG0XC|Super Jigsaw Pupp...|\n","|B0031561G8|Crazy Machines: N...|\n","|B0031RGGOI|Next Life [Download]|\n","|B0037HOOTQ|Death Track: Resu...|\n","|B003O68T1Y|Casino Island To ...|\n","+----------+--------------------+\n","only showing top 10 rows\n","\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"OEh4wDpLscbC","executionInfo":{"status":"ok","timestamp":1612744366047,"user_tz":360,"elapsed":76642,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"22384b8d-a2ef-4474-fc10-b836d54f0949"},"source":["products_df.count()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["7948"]},"metadata":{"tags":[]},"execution_count":9}]},{"cell_type":"code","metadata":{"id":"MkqyCuNQY-9-","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1612744366275,"user_tz":360,"elapsed":76863,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"a92d792b-62a5-438b-941e-56e73f6e62ae"},"source":["# Create the review_id_table DataFrame. \n","review_id_df = df.select(['review_id','customer_id','product_id', 'product_parent', to_date(\"review_date\", 'yyyy-MM-dd').alias(\"review_date\")])\n","review_id_df.show(10)"],"execution_count":null,"outputs":[{"output_type":"stream","text":["+--------------+-----------+----------+--------------+-----------+\n","|     review_id|customer_id|product_id|product_parent|review_date|\n","+--------------+-----------+----------+--------------+-----------+\n","| RSH1OZ87OYK92|   21269168|B013PURRZW|     603406193| 2015-08-31|\n","|R1WFOQ3N9BO65I|     133437|B00F4CEHNK|     341969535| 2015-08-31|\n","| R3YOOS71KM5M9|   45765011|B00DNHLFQA|     951665344| 2015-08-31|\n","|R3R14UATT3OUFU|     113118|B004RMK5QG|     395682204| 2015-08-31|\n","| RV2W9SGDNQA2C|   22151364|B00G9BNLQE|     640460561| 2015-08-31|\n","|R3CFKLIZ0I2KOB|   22151364|B00IMIL498|     621922192| 2015-08-31|\n","|R1LRYU1V0T3O38|   38426028|B00S00IJH8|     215163395| 2015-08-31|\n","| R44QKV6FE5CJ2|    6057518|B004RMK4BC|     384246568| 2015-08-31|\n","|R2TX1KLPXXXNYS|   20715661|B00K59HKIQ|     384246568| 2015-08-31|\n","|R1JEEW4C6R89BA|   26540306|B00K59HKIQ|     384246568| 2015-08-31|\n","+--------------+-----------+----------+--------------+-----------+\n","only showing top 10 rows\n","\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"eNh3Fk0vsKTk","executionInfo":{"status":"ok","timestamp":1612744367345,"user_tz":360,"elapsed":77926,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"b2009763-c767-4207-bfd8-9ab9412ed49c"},"source":["review_id_df.count()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["145431"]},"metadata":{"tags":[]},"execution_count":11}]},{"cell_type":"code","metadata":{"id":"lzMmkdKmY--D","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1612744367614,"user_tz":360,"elapsed":78188,"user":{"displayName":"Julie Pyle","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GgwK-ZsQZg06vAJJaL8rk7twbJ4h5WXmW603dBa9w=s64","userId":"01424704684608021156"}},"outputId":"004880cc-f271-4c25-8bab-2191fb761716"},"source":["# Create the vine_table DataFrame\n","vine_df = df.select(['review_id', 'star_rating','helpful_votes', 'total_votes', 'vine', 'verified_purchase'])\n","vine_df.show(10)"],"execution_count":null,"outputs":[{"output_type":"stream","text":["+--------------+-----------+-------------+-----------+----+-----------------+\n","|     review_id|star_rating|helpful_votes|total_votes|vine|verified_purchase|\n","+--------------+-----------+-------------+-----------+----+-----------------+\n","| RSH1OZ87OYK92|          2|            2|          3|   N|                N|\n","|R1WFOQ3N9BO65I|          5|            0|          0|   N|                Y|\n","| R3YOOS71KM5M9|          5|            0|          0|   N|                Y|\n","|R3R14UATT3OUFU|          5|            0|          0|   N|                Y|\n","| RV2W9SGDNQA2C|          5|            0|          0|   N|                Y|\n","|R3CFKLIZ0I2KOB|          5|            0|          0|   N|                Y|\n","|R1LRYU1V0T3O38|          4|            0|          0|   N|                Y|\n","| R44QKV6FE5CJ2|          5|            0|          0|   N|                Y|\n","|R2TX1KLPXXXNYS|          5|            0|          0|   N|                Y|\n","|R1JEEW4C6R89BA|          5|            0|          0|   N|                Y|\n","+--------------+-----------+-------------+-----------+----+-----------------+\n","only showing top 10 rows\n","\n"],"name":"stdout"}]},{"cell_type":"markdown","metadata":{"id":"jITZhLkmY--J"},"source":["### Connect to the AWS RDS instance and write each DataFrame to its table. "]},{"cell_type":"code","metadata":{"id":"7jiUvs1aY--L"},"source":["# Configure settings for RDS\n","mode = \"append\"\n","# jdbc_url=\"jdbc:postgresql://amazon-reviews.camjftkrswax.us-east-1.rds.amazonaws.com:5432/postgres\"\n","jdbc_url=\"jdbc:postgresql://dataviz.camjftkrswax.us-east-1.rds.amazonaws.com:5432/postgres\"\n","config = {\"user\":\"postgres\", \n","          \"password\": \"\", \n","          \"driver\":\"org.postgresql.Driver\"}"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"T2zgZ-aKY--Q"},"source":["# Write review_id_df to table in RDS\n","review_id_df.write.jdbc(url=jdbc_url, table='review_id_table', mode=mode, properties=config)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"1m3yzn-LY--U"},"source":["# Write products_df to table in RDS\n","# about 3 min\n","products_df.write.jdbc(url=jdbc_url, table='products_table', mode=mode, properties=config)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"KbXri15fY--Z"},"source":["# Write customers_df to table in RDS\n","# 5 min 14 s\n","customers_df.write.jdbc(url=jdbc_url, table='customers_table', mode=mode, properties=config)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"XdQknSHLY--e"},"source":["# Write vine_df to table in RDS\n","# 11 minutes\n","vine_df.write.jdbc(url=jdbc_url, table='vine_table', mode=mode, properties=config)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"Exuo6ebUsCqW"},"source":["# -- inside of pgAdmin\r\n","# -- Query database to check successful upload\r\n","# SELECT * FROM customers_table;\r\n","# SELECT * FROM products_table;\r\n","# SELECT * FROM review_id_table;\r\n","# SELECT * FROM vine_table;"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"SUBUYSy6esLq"},"source":[""],"execution_count":null,"outputs":[]}]}