{ "cells": [ { "cell_type": "code", "execution_count": 4, "id": "406253b7", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "\n", "df_orders = pd.read_csv(\"olist_orders_dataset.csv\")\n", "df_payments = pd.read_csv(\"olist_order_payments_dataset.csv\")\n", "df_customers = pd.read_csv(\"olist_customers_dataset.csv\")" ] }, { "cell_type": "code", "execution_count": null, "id": "6dccc6e8", "metadata": {}, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
order_idpayment_sequentialpayment_typepayment_installmentspayment_valuecustomer_idorder_statusorder_purchase_timestamporder_approved_atorder_delivered_carrier_dateorder_delivered_customer_dateorder_estimated_delivery_datecustomer_unique_idcustomer_zip_code_prefixcustomer_citycustomer_state
0b81ef226f3fe1789b1e8b2acac839d171credit_card899.330a8556ac6be836b46b3e89920d59291cdelivered2018-04-25 22:01:492018-04-25 22:15:092018-05-02 15:20:002018-05-09 17:36:512018-05-22 00:00:00708ab75d2a007f0564aedd11139c770839801teofilo otoniMG
1a9810da82917af2d9aefd1278f1dcfa01credit_card124.39f2c7fc58a9de810828715166c672f10adelivered2018-06-26 11:01:382018-06-26 11:18:582018-06-28 14:18:002018-06-29 20:32:092018-07-16 00:00:00a8b9d3a27068454b1c98cc67d4e31e6f2422sao pauloSP
225e8ea4e93396b6fa0d3dd708e76c1bd1credit_card165.7125b14b69de0b6e184ae6fe2755e478f9delivered2017-12-12 11:19:552017-12-14 09:52:342017-12-15 20:13:222017-12-18 17:24:412018-01-04 00:00:006f70c0b2f7552832ba46eb57b1c5651e2652sao pauloSP
3ba78997921bbcdc1373bb41e913ab9531credit_card8107.787a5d8efaaa1081f800628c30d2b0728fdelivered2017-12-06 12:04:062017-12-06 12:13:202017-12-07 20:28:282017-12-21 01:35:512018-01-04 00:00:0087695ed086ebd36f20404c82d20fca8736060juiz de foraMG
442fdf880ba16b47b59251dd489d4441a1credit_card2128.4515fd6fb8f8312dbb4674e4518d6fa3b3delivered2018-05-21 13:59:172018-05-21 16:14:412018-05-22 11:46:002018-06-01 21:44:532018-06-13 00:00:004291db0da71914754618cd789aebcd5618570conchasSP
...................................................
1038810406037ad97740d563a178ecc7a2075c1boleto1363.315d576cb2dfa3bc05612c392a1ee9c654delivered2018-03-08 16:57:232018-03-10 03:55:252018-03-12 18:19:362018-03-16 13:09:512018-04-04 00:00:00b6027ac07fb76ebca8c97b1887865aee12954atibaiaSP
1038827b905861d7c825891d6347454ea7863f1credit_card296.802079230c765a88530822a34a4cec2aa0delivered2017-08-18 09:45:352017-08-18 10:04:562017-08-18 18:04:242017-08-23 22:25:562017-09-12 00:00:0053b30ca78efb2b7efcd3f9e461587eb230210belo horizonteMG
10388332609bbb3dd69b3c066a6860554a77bf1credit_card147.77e4abb5057ec8cfda9759c0dc415a8188invoiced2017-11-18 17:27:142017-11-18 17:46:05NaNNaN2017-12-05 00:00:00d3c7da954a324253814096bcaf240e4e1519sao pauloSP
103884b8b61059626efa996a60be9bb9320e101credit_card5369.545d719b0d300663188169c6560e243f27delivered2018-08-07 23:26:132018-08-07 23:45:002018-08-09 11:46:002018-08-21 22:41:462018-08-24 00:00:00b84dc68f02f122a88d7e7bbd37b0620422733rio de janeiroRJ
10388528bbae6599b09d39ca406b747b6632b11boleto1191.584c7f868f43b5cff577b0becb8c8b7860delivered2017-12-05 08:18:352017-12-06 02:50:092017-12-08 00:51:472018-02-05 14:59:092017-12-29 00:00:00b1f51a4e19da3338e51fbcfabefad1bf23059rio de janeiroRJ
\n", "

103886 rows × 16 columns

\n", "
" ], "text/plain": [ " order_id payment_sequential payment_type \\\n", "0 b81ef226f3fe1789b1e8b2acac839d17 1 credit_card \n", "1 a9810da82917af2d9aefd1278f1dcfa0 1 credit_card \n", "2 25e8ea4e93396b6fa0d3dd708e76c1bd 1 credit_card \n", "3 ba78997921bbcdc1373bb41e913ab953 1 credit_card \n", "4 42fdf880ba16b47b59251dd489d4441a 1 credit_card \n", "... ... ... ... \n", "103881 0406037ad97740d563a178ecc7a2075c 1 boleto \n", "103882 7b905861d7c825891d6347454ea7863f 1 credit_card \n", "103883 32609bbb3dd69b3c066a6860554a77bf 1 credit_card \n", "103884 b8b61059626efa996a60be9bb9320e10 1 credit_card \n", "103885 28bbae6599b09d39ca406b747b6632b1 1 boleto \n", "\n", " payment_installments payment_value customer_id \\\n", "0 8 99.33 0a8556ac6be836b46b3e89920d59291c \n", "1 1 24.39 f2c7fc58a9de810828715166c672f10a \n", "2 1 65.71 25b14b69de0b6e184ae6fe2755e478f9 \n", "3 8 107.78 7a5d8efaaa1081f800628c30d2b0728f \n", "4 2 128.45 15fd6fb8f8312dbb4674e4518d6fa3b3 \n", "... ... ... ... \n", "103881 1 363.31 5d576cb2dfa3bc05612c392a1ee9c654 \n", "103882 2 96.80 2079230c765a88530822a34a4cec2aa0 \n", "103883 1 47.77 e4abb5057ec8cfda9759c0dc415a8188 \n", "103884 5 369.54 5d719b0d300663188169c6560e243f27 \n", "103885 1 191.58 4c7f868f43b5cff577b0becb8c8b7860 \n", "\n", " order_status order_purchase_timestamp order_approved_at \\\n", "0 delivered 2018-04-25 22:01:49 2018-04-25 22:15:09 \n", "1 delivered 2018-06-26 11:01:38 2018-06-26 11:18:58 \n", "2 delivered 2017-12-12 11:19:55 2017-12-14 09:52:34 \n", "3 delivered 2017-12-06 12:04:06 2017-12-06 12:13:20 \n", "4 delivered 2018-05-21 13:59:17 2018-05-21 16:14:41 \n", "... ... ... ... \n", "103881 delivered 2018-03-08 16:57:23 2018-03-10 03:55:25 \n", "103882 delivered 2017-08-18 09:45:35 2017-08-18 10:04:56 \n", "103883 invoiced 2017-11-18 17:27:14 2017-11-18 17:46:05 \n", "103884 delivered 2018-08-07 23:26:13 2018-08-07 23:45:00 \n", "103885 delivered 2017-12-05 08:18:35 2017-12-06 02:50:09 \n", "\n", " order_delivered_carrier_date order_delivered_customer_date \\\n", "0 2018-05-02 15:20:00 2018-05-09 17:36:51 \n", "1 2018-06-28 14:18:00 2018-06-29 20:32:09 \n", "2 2017-12-15 20:13:22 2017-12-18 17:24:41 \n", "3 2017-12-07 20:28:28 2017-12-21 01:35:51 \n", "4 2018-05-22 11:46:00 2018-06-01 21:44:53 \n", "... ... ... \n", "103881 2018-03-12 18:19:36 2018-03-16 13:09:51 \n", "103882 2017-08-18 18:04:24 2017-08-23 22:25:56 \n", "103883 NaN NaN \n", "103884 2018-08-09 11:46:00 2018-08-21 22:41:46 \n", "103885 2017-12-08 00:51:47 2018-02-05 14:59:09 \n", "\n", " order_estimated_delivery_date customer_unique_id \\\n", "0 2018-05-22 00:00:00 708ab75d2a007f0564aedd11139c7708 \n", "1 2018-07-16 00:00:00 a8b9d3a27068454b1c98cc67d4e31e6f \n", "2 2018-01-04 00:00:00 6f70c0b2f7552832ba46eb57b1c5651e \n", "3 2018-01-04 00:00:00 87695ed086ebd36f20404c82d20fca87 \n", "4 2018-06-13 00:00:00 4291db0da71914754618cd789aebcd56 \n", "... ... ... \n", "103881 2018-04-04 00:00:00 b6027ac07fb76ebca8c97b1887865aee \n", "103882 2017-09-12 00:00:00 53b30ca78efb2b7efcd3f9e461587eb2 \n", "103883 2017-12-05 00:00:00 d3c7da954a324253814096bcaf240e4e \n", "103884 2018-08-24 00:00:00 b84dc68f02f122a88d7e7bbd37b06204 \n", "103885 2017-12-29 00:00:00 b1f51a4e19da3338e51fbcfabefad1bf \n", "\n", " customer_zip_code_prefix customer_city customer_state \n", "0 39801 teofilo otoni MG \n", "1 2422 sao paulo SP \n", "2 2652 sao paulo SP \n", "3 36060 juiz de fora MG \n", "4 18570 conchas SP \n", "... ... ... ... \n", "103881 12954 atibaia SP \n", "103882 30210 belo horizonte MG \n", "103883 1519 sao paulo SP \n", "103884 22733 rio de janeiro RJ \n", "103885 23059 rio de janeiro RJ \n", "\n", "[103886 rows x 16 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = df_payments.merge(df_orders, left_on=\"order_id\", right_on=\"order_id\")\n", "\n", "df = df.merge(df_customers, left_on=\"customer_id\", right_on=\"customer_id\")\n", "\n", "df" ] } ], "metadata": { "kernelspec": { "display_name": ".venv (3.12.3)", "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.12.3" } }, "nbformat": 4, "nbformat_minor": 5 }