Part01-Cleaning-Data.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Part01-Cleaning-Data.ipynb","provenance":[],"collapsed_sections":[]},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","metadata":{"id":"uEDN7h4_kccE"},"source":["## Business Problems:\n","\n","## Business Problem Statement for Machine Learning\n","**How to segment the customers at Olist marketplace so we can divide customers based on their shopping behaviour?**\n","- Value\t: Customer Segmentation\n","- Goals\t: Divide customers based on their shopping behaviour\n","\n","## Business Problem Statement for Analytics\n","**What kind of treatment for each cluster to increase retention rate customer?**\n","- Value\t: Give treatment for each cluster\n","- Goals\t: Increase retention rate customer\n"]},{"cell_type":"code","metadata":{"id":"gY66j-lnhIZc"},"source":["# Data\n","import pandas as pd\n","import datetime as dt"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"qr_q9DB9BtiS","executionInfo":{"status":"ok","timestamp":1633361330365,"user_tz":-420,"elapsed":523,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"50aa45bb-31e1-4350-fedc-f96754e6b549"},"source":["from google.colab import drive\n","drive.mount('/content/drive')"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"]}]},{"cell_type":"markdown","metadata":{"id":"dq5nztX0G19D"},"source":["# Data Understanding:\n","- Data mengenai perusahaan *E-commerce* di Brazil, yaitu perusahaan *Olist*\n","- Data ini diambil dari tahun 2016 - 2018 dan disebarkan secara public di <a href = \"https://www.kaggle.com/olistbr/brazilian-ecommerce\">Kaggle</a> pada tahun 2018 bulan September\n","- Data-data yang ada berisi tentang transaksi *customer* dan *seller*\n","- Karena yang ingin dilakukan adalah *customer segmentation* maka hanya akan diambil data yang mengenai *customer* saja\n","- Ada 116584 data transaksi"]},{"cell_type":"markdown","metadata":{"id":"VydjEu0PpcgD"},"source":["### Merge Data:\n","Dikarenakan data yang berhubungan dengan transaksi *customer* terpisah-pisah, hal pertama yang harus dilakukan adalah mengabungkan data-data tersebut.\n","\n","<p> <p>\n","<figure>\n","  <center><img src = \"https://i.imgur.com/HRhd2Y0.png\" alt =\"Scheme Data Table\" width = 700; height = 500></center>\n","  <figcaption align = \"center\">Gambar 1. <em>Scheme Data</em> </figcaption>\n","</figure>\n","<p> <p>"]},{"cell_type":"code","metadata":{"id":"QB5lkUHbDOU_"},"source":["# Read data yang dibutuhkan\n","olist_order = pd.read_csv('/content/drive/MyDrive/Project Purwadhika/Dataset/olist_orders_dataset.csv')\n","olist_item = pd.read_csv('/content/drive/MyDrive/Project Purwadhika/Dataset/olist_order_items_dataset.csv')\n","olist_payment = pd.read_csv('/content/drive/MyDrive/Project Purwadhika/Dataset/olist_order_payments_dataset.csv')\n","olist_product = pd.read_csv('/content/drive/MyDrive/Project Purwadhika/Dataset/olist_products_dataset.csv')\n","olist_customer = pd.read_csv('/content/drive/MyDrive/Project Purwadhika/Dataset/olist_customers_dataset.csv')\n","olist_review = pd.read_csv('/content/drive/MyDrive/Project Purwadhika/Dataset/olist_order_reviews_dataset.csv')\n","olist_translate = pd.read_csv('/content/drive/MyDrive/Project Purwadhika/Dataset/product_category_name_translation.csv')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":292},"id":"xnNjBWLiFr5y","executionInfo":{"status":"ok","timestamp":1633361333242,"user_tz":-420,"elapsed":1134,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"731471dc-a957-4883-9eeb-602e19ab7432"},"source":["# Merge data menjadi satu \n","df_olist = pd.merge(olist_order, olist_item, on='order_id', how='left')\n","df_olist = pd.merge(df_olist, olist_product, on='product_id', how='inner')\n","df_olist = pd.merge(df_olist, olist_payment, on='order_id', how = 'left')\n","df_olist = pd.merge(df_olist, olist_review, on='order_id', how='left')\n","df_olist = pd.merge(df_olist, olist_customer, on='customer_id', how='right')\n","df_olist = pd.merge(df_olist, olist_translate, on='product_category_name', how='inner')\n","\n","df_olist.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>order_id</th>\n","      <th>customer_id</th>\n","      <th>order_status</th>\n","      <th>order_purchase_timestamp</th>\n","      <th>order_approved_at</th>\n","      <th>order_delivered_carrier_date</th>\n","      <th>order_delivered_customer_date</th>\n","      <th>order_estimated_delivery_date</th>\n","      <th>order_item_id</th>\n","      <th>product_id</th>\n","      <th>seller_id</th>\n","      <th>shipping_limit_date</th>\n","      <th>price</th>\n","      <th>freight_value</th>\n","      <th>product_category_name</th>\n","      <th>product_name_lenght</th>\n","      <th>product_description_lenght</th>\n","      <th>product_photos_qty</th>\n","      <th>product_weight_g</th>\n","      <th>product_length_cm</th>\n","      <th>product_height_cm</th>\n","      <th>product_width_cm</th>\n","      <th>payment_sequential</th>\n","      <th>payment_type</th>\n","      <th>payment_installments</th>\n","      <th>payment_value</th>\n","      <th>review_id</th>\n","      <th>review_score</th>\n","      <th>review_comment_title</th>\n","      <th>review_comment_message</th>\n","      <th>review_creation_date</th>\n","      <th>review_answer_timestamp</th>\n","      <th>customer_unique_id</th>\n","      <th>customer_zip_code_prefix</th>\n","      <th>customer_city</th>\n","      <th>customer_state</th>\n","      <th>product_category_name_english</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>00e7ee1b050b8499577073aeb2a297a1</td>\n","      <td>06b8999e2fba1a1fbc88172c00ba8bc7</td>\n","      <td>delivered</td>\n","      <td>2017-05-16 15:05:35</td>\n","      <td>2017-05-16 15:22:12</td>\n","      <td>2017-05-23 10:47:57</td>\n","      <td>2017-05-25 10:35:35</td>\n","      <td>2017-06-05 00:00:00</td>\n","      <td>1.0</td>\n","      <td>a9516a079e37a9c9c36b9b78b10169e8</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2017-05-22 15:22:12</td>\n","      <td>124.99</td>\n","      <td>21.88</td>\n","      <td>moveis_escritorio</td>\n","      <td>41.0</td>\n","      <td>1141.0</td>\n","      <td>1.0</td>\n","      <td>8683.0</td>\n","      <td>54.0</td>\n","      <td>64.0</td>\n","      <td>31.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>2.0</td>\n","      <td>146.87</td>\n","      <td>88b8b52d46df026a9d1ad2136a59b30b</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2017-05-26 00:00:00</td>\n","      <td>2017-05-30 22:34:40</td>\n","      <td>861eff4711a542e4b93843c6dd7febb0</td>\n","      <td>14409</td>\n","      <td>franca</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>b2059ed67ce144a36e2aa97d2c9e9ad2</td>\n","      <td>4e7b3e00288586ebd08712fdd0374a03</td>\n","      <td>delivered</td>\n","      <td>2018-05-19 16:07:45</td>\n","      <td>2018-05-20 16:19:10</td>\n","      <td>2018-06-11 14:31:00</td>\n","      <td>2018-06-14 17:58:51</td>\n","      <td>2018-06-13 00:00:00</td>\n","      <td>1.0</td>\n","      <td>bd07b66896d6f1494f5b86251848ced7</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2018-06-05 16:19:10</td>\n","      <td>139.94</td>\n","      <td>17.79</td>\n","      <td>moveis_escritorio</td>\n","      <td>55.0</td>\n","      <td>955.0</td>\n","      <td>1.0</td>\n","      <td>8267.0</td>\n","      <td>52.0</td>\n","      <td>52.0</td>\n","      <td>17.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>7.0</td>\n","      <td>157.73</td>\n","      <td>5ad6695d76ee186dc473c42706984d87</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2018-06-15 00:00:00</td>\n","      <td>2018-06-15 12:10:59</td>\n","      <td>060e732b5b29e8181a18229c7b0b2b5e</td>\n","      <td>1151</td>\n","      <td>sao paulo</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>951670f92359f4fe4a63112aa7306eba</td>\n","      <td>b2b6027bc5c5109e529d4dc6358b12c3</td>\n","      <td>delivered</td>\n","      <td>2018-03-13 16:06:38</td>\n","      <td>2018-03-13 17:29:19</td>\n","      <td>2018-03-27 23:22:42</td>\n","      <td>2018-03-28 16:04:25</td>\n","      <td>2018-04-10 00:00:00</td>\n","      <td>1.0</td>\n","      <td>a5647c44af977b148e0a3a4751a09e2e</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2018-03-27 16:31:16</td>\n","      <td>149.94</td>\n","      <td>23.36</td>\n","      <td>moveis_escritorio</td>\n","      <td>48.0</td>\n","      <td>1066.0</td>\n","      <td>1.0</td>\n","      <td>12160.0</td>\n","      <td>56.0</td>\n","      <td>51.0</td>\n","      <td>28.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>1.0</td>\n","      <td>173.30</td>\n","      <td>059a801bb31f6aab2266e672cab87bc5</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2018-03-29 00:00:00</td>\n","      <td>2018-04-02 18:36:47</td>\n","      <td>259dac757896d24d7702b9acbbff3f3c</td>\n","      <td>8775</td>\n","      <td>mogi das cruzes</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>997fd4b37386d10b57d4ac8cdec011a6</td>\n","      <td>4c06b42fbf7b97ab10779cda5549cd1c</td>\n","      <td>delivered</td>\n","      <td>2018-07-08 09:59:19</td>\n","      <td>2018-07-08 10:30:15</td>\n","      <td>2018-07-25 15:12:00</td>\n","      <td>2018-08-08 19:42:53</td>\n","      <td>2018-08-16 00:00:00</td>\n","      <td>1.0</td>\n","      <td>8ed094bfe076c568f6bb10feada3f75d</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2018-07-26 10:30:15</td>\n","      <td>199.98</td>\n","      <td>115.77</td>\n","      <td>moveis_escritorio</td>\n","      <td>43.0</td>\n","      <td>1128.0</td>\n","      <td>1.0</td>\n","      <td>16133.0</td>\n","      <td>63.0</td>\n","      <td>59.0</td>\n","      <td>25.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>6.0</td>\n","      <td>315.75</td>\n","      <td>2518803238cabbf63564593e4a8fc52d</td>\n","      <td>1.0</td>\n","      <td>Nada de produto</td>\n","      <td>Ainda não recebi o produto. Sendo assim, não p...</td>\n","      <td>2018-08-09 00:00:00</td>\n","      <td>2018-08-14 11:40:54</td>\n","      <td>07d190f123147d9e89d4b922543d7948</td>\n","      <td>65075</td>\n","      <td>sao luis</td>\n","      <td>MA</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>b63fff1ef8b6201df68bb611ee41129e</td>\n","      <td>8276de07ef25225d412b8462d73f8664</td>\n","      <td>delivered</td>\n","      <td>2017-04-02 22:15:27</td>\n","      <td>2017-04-04 05:55:19</td>\n","      <td>2017-04-13 16:28:06</td>\n","      <td>2017-05-02 13:53:25</td>\n","      <td>2017-05-08 00:00:00</td>\n","      <td>1.0</td>\n","      <td>aba86c093ccdbac75b09111d57e50004</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2017-04-17 05:55:19</td>\n","      <td>129.60</td>\n","      <td>16.61</td>\n","      <td>moveis_escritorio</td>\n","      <td>41.0</td>\n","      <td>154.0</td>\n","      <td>1.0</td>\n","      <td>2600.0</td>\n","      <td>40.0</td>\n","      <td>45.0</td>\n","      <td>39.0</td>\n","      <td>1.0</td>\n","      <td>boleto</td>\n","      <td>1.0</td>\n","      <td>146.21</td>\n","      <td>84467f1766775ba4c14fc25b3ca67905</td>\n","      <td>4.0</td>\n","      <td>NaN</td>\n","      <td>A crítica é à entrega, pois por se tratar dos ...</td>\n","      <td>2017-05-03 00:00:00</td>\n","      <td>2017-05-03 21:06:33</td>\n","      <td>332cf4e83e16004ba7dca932ce82475b</td>\n","      <td>90010</td>\n","      <td>porto alegre</td>\n","      <td>RS</td>\n","      <td>office_furniture</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                           order_id  ... product_category_name_english\n","0  00e7ee1b050b8499577073aeb2a297a1  ...              office_furniture\n","1  b2059ed67ce144a36e2aa97d2c9e9ad2  ...              office_furniture\n","2  951670f92359f4fe4a63112aa7306eba  ...              office_furniture\n","3  997fd4b37386d10b57d4ac8cdec011a6  ...              office_furniture\n","4  b63fff1ef8b6201df68bb611ee41129e  ...              office_furniture\n","\n","[5 rows x 37 columns]"]},"metadata":{},"execution_count":50}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"xSNSsKFBOFJX","executionInfo":{"status":"ok","timestamp":1633361333243,"user_tz":-420,"elapsed":28,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"76514832-48e8-4523-ab3f-1f3abd257779"},"source":["print(\"Jumlah row yang dimiliki: \", len(df_olist))"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Jumlah row yang dimiliki:  116584\n"]}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"CqdmXB4ZJi5r","executionInfo":{"status":"ok","timestamp":1633361333244,"user_tz":-420,"elapsed":22,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"3dcd12a8-97ec-49b2-a69b-dd32c577275e"},"source":["df_olist.columns"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["Index(['order_id', 'customer_id', 'order_status', 'order_purchase_timestamp',\n","       'order_approved_at', 'order_delivered_carrier_date',\n","       'order_delivered_customer_date', 'order_estimated_delivery_date',\n","       'order_item_id', 'product_id', 'seller_id', 'shipping_limit_date',\n","       'price', 'freight_value', 'product_category_name',\n","       'product_name_lenght', 'product_description_lenght',\n","       'product_photos_qty', 'product_weight_g', 'product_length_cm',\n","       'product_height_cm', 'product_width_cm', 'payment_sequential',\n","       'payment_type', 'payment_installments', 'payment_value', 'review_id',\n","       'review_score', 'review_comment_title', 'review_comment_message',\n","       'review_creation_date', 'review_answer_timestamp', 'customer_unique_id',\n","       'customer_zip_code_prefix', 'customer_city', 'customer_state',\n","       'product_category_name_english'],\n","      dtype='object')"]},"metadata":{},"execution_count":52}]},{"cell_type":"markdown","metadata":{"id":"SVv6wrxBsPG5"},"source":["### Drop columns:\n","Setelah penggabungan data dari beberapa tables, kami akan menghapus beberapa column yang tidak ada kaitannya dengan transaksi *behavior* dari *customer* "]},{"cell_type":"code","metadata":{"id":"g0ERvy_iKqwD"},"source":["df_olist_clean = df_olist.drop(columns=['order_status', 'order_approved_at', 'order_delivered_customer_date', 'order_delivered_carrier_date', 'order_delivered_customer_date', \n","                                  'order_estimated_delivery_date', 'seller_id', 'shipping_limit_date','product_category_name', 'product_name_lenght', \n","                                  'product_description_lenght', 'product_weight_g', 'product_length_cm', 'product_height_cm', 'product_width_cm',\n","                                  'payment_installments','review_id', 'review_comment_title', 'review_comment_message', 'review_creation_date', \n","                                  'review_answer_timestamp', 'customer_id'])"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"0WV4SZVpJ8BI","colab":{"base_uri":"https://localhost:8080/","height":241},"executionInfo":{"status":"ok","timestamp":1633361333247,"user_tz":-420,"elapsed":20,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"bbc80ff5-bdf5-4072-e2be-134c6d045cd5"},"source":["df_olist_clean.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>order_id</th>\n","      <th>order_purchase_timestamp</th>\n","      <th>order_item_id</th>\n","      <th>product_id</th>\n","      <th>price</th>\n","      <th>freight_value</th>\n","      <th>product_photos_qty</th>\n","      <th>payment_sequential</th>\n","      <th>payment_type</th>\n","      <th>payment_value</th>\n","      <th>review_score</th>\n","      <th>customer_unique_id</th>\n","      <th>customer_zip_code_prefix</th>\n","      <th>customer_city</th>\n","      <th>customer_state</th>\n","      <th>product_category_name_english</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>00e7ee1b050b8499577073aeb2a297a1</td>\n","      <td>2017-05-16 15:05:35</td>\n","      <td>1.0</td>\n","      <td>a9516a079e37a9c9c36b9b78b10169e8</td>\n","      <td>124.99</td>\n","      <td>21.88</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>146.87</td>\n","      <td>4.0</td>\n","      <td>861eff4711a542e4b93843c6dd7febb0</td>\n","      <td>14409</td>\n","      <td>franca</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>b2059ed67ce144a36e2aa97d2c9e9ad2</td>\n","      <td>2018-05-19 16:07:45</td>\n","      <td>1.0</td>\n","      <td>bd07b66896d6f1494f5b86251848ced7</td>\n","      <td>139.94</td>\n","      <td>17.79</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>157.73</td>\n","      <td>5.0</td>\n","      <td>060e732b5b29e8181a18229c7b0b2b5e</td>\n","      <td>1151</td>\n","      <td>sao paulo</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>951670f92359f4fe4a63112aa7306eba</td>\n","      <td>2018-03-13 16:06:38</td>\n","      <td>1.0</td>\n","      <td>a5647c44af977b148e0a3a4751a09e2e</td>\n","      <td>149.94</td>\n","      <td>23.36</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>173.30</td>\n","      <td>5.0</td>\n","      <td>259dac757896d24d7702b9acbbff3f3c</td>\n","      <td>8775</td>\n","      <td>mogi das cruzes</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>997fd4b37386d10b57d4ac8cdec011a6</td>\n","      <td>2018-07-08 09:59:19</td>\n","      <td>1.0</td>\n","      <td>8ed094bfe076c568f6bb10feada3f75d</td>\n","      <td>199.98</td>\n","      <td>115.77</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>315.75</td>\n","      <td>1.0</td>\n","      <td>07d190f123147d9e89d4b922543d7948</td>\n","      <td>65075</td>\n","      <td>sao luis</td>\n","      <td>MA</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>b63fff1ef8b6201df68bb611ee41129e</td>\n","      <td>2017-04-02 22:15:27</td>\n","      <td>1.0</td>\n","      <td>aba86c093ccdbac75b09111d57e50004</td>\n","      <td>129.60</td>\n","      <td>16.61</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>boleto</td>\n","      <td>146.21</td>\n","      <td>4.0</td>\n","      <td>332cf4e83e16004ba7dca932ce82475b</td>\n","      <td>90010</td>\n","      <td>porto alegre</td>\n","      <td>RS</td>\n","      <td>office_furniture</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                           order_id  ... product_category_name_english\n","0  00e7ee1b050b8499577073aeb2a297a1  ...              office_furniture\n","1  b2059ed67ce144a36e2aa97d2c9e9ad2  ...              office_furniture\n","2  951670f92359f4fe4a63112aa7306eba  ...              office_furniture\n","3  997fd4b37386d10b57d4ac8cdec011a6  ...              office_furniture\n","4  b63fff1ef8b6201df68bb611ee41129e  ...              office_furniture\n","\n","[5 rows x 16 columns]"]},"metadata":{},"execution_count":54}]},{"cell_type":"markdown","metadata":{"id":"Ve4VdLLVORy0"},"source":["## Attribute Information:\n","<table>\n","  <tr>\n","    <th>Attribute</th>\n","    <th>Data Type</th>\n","    <th>Description</th>\n","    <th>Unit Analysis</th>\n","  </tr>\n","  <tr>\n","    <td>order_id</td>\n","    <td>object</td>\n","    <td>Unik ID dari order</td>\n","    <td>Setiap baris merepresentasikan ID order yang yang muncul ketika customer\n","    melakukan order</td>\n","  </tr>\n","  <tr>\n","    <td>order_purchase_stamp</td>\n","    <td>datetime64[s]</td>\n","    <td>Waktu pembelian customer</td>\n","    <td>Setiap baris merepresentasikan waktu ketika customer melakukan order</td>\n","  </tr>\n","  <tr>\n","    <td>order_item_id</td>\n","    <td>float64</td>\n","    <td>Jumlah barang per-order</td>\n","    <td>Setiap baris merepresentasikan jumlah barang yang dibeli customer dalam sekali order</td>\n","  </tr>\n","  <tr>\n","    <td>product_id</td>\n","    <td>object</td>\n","    <td>ID dari sebuah product</td>\n","    <td>Setiap baris merepresentasikan ID dari sebuah product yang diorder oleh customer</td>\n","  </tr>\n","  <tr>\n","    <td>price</td>\n","    <td>float64</td>\n","    <td>Harga dari sebuah product</td>\n","    <td>Setiap baris merepresentasikan harga dari sebuah product yang diorder oleh customer</td>\n","  </tr>\n","  <tr>\n","    <td>freight_value</td>\n","    <td>float64</td>\n","    <td>Nilai pengiriman product</td>\n","    <td>Setiap baris merepresentasikan nilai pengirim dari sebuah product yang diorder oleh customer. Apabila item lebih dari 1, nilainya dipisah</td>\n","  </tr>\n","  <tr>\n","    <td>product_photo_qty</td>\n","    <td>float64</td>\n","    <td>Jumlah foto sebuah product</td>\n","    <td>Setiap baris merepresentasikan jumlah foto dari sebuah product yang diiklankan</td>\n","  </tr>\n","  <tr>\n","    <td>payment_sequential</td>\n","    <td>float64</td>\n","    <td>Jumlah payment method</td>\n","    <td>Setiap baris merepresentasikan jumlah metode payment yang dilakukan oleh customer. Customer dapat membayar sebuah transaksi lebih dari 1 metode</td>\n","  </tr>\n","  <tr>\n","    <td>payment_type</td>\n","    <td>object</td>\n","    <td>Metode pembayaran</td>\n","    <td>Setiap baris merepresentasikan metode yang digunakan customer dalam membayar sebuah transaksi</td>\n","  </tr>\n","  <tr>\n","    <td>payment_value</td>\n","    <td>float64</td>\n","    <td>Nilai Transaksi</td>\n","    <td>Setiap baris merepresentasikan nilai transaksi yang harus dibayar customer</td>\n","  </tr>\n","  <tr>\n","    <td>review_score</td>\n","    <td>float64</td>\n","    <td>Tingkat kepuasan customer</td>\n","    <td>Setiap baris merepresentasikan tingkat kepuasan customer dalam bertransaksi, nilainya dari 1 - 5</td>\n","  </tr>\n","  <tr>\n","    <td>customer_unique_id</td>\n","    <td>object</td>\n","    <td>Unik ID dari customer</td>\n","    <td>Setiap baris merepresentasikan ID customer yang melakukan\n","    order</td>\n","  </tr>\n","  <tr>\n","    <td>customer_zip_code_prefix</td>\n","    <td>int64</td>\n","    <td>Kode pos dari customer</td>\n","    <td>Setiap baris merepresentasikan kode pos dari tempat tinggal customer, namun hanya 5 kode awal</td>\n","  </tr>\n","  <tr>\n","    <td>customer_city</td>\n","    <td>object</td>\n","    <td>Nama kota dari customer</td>\n","    <td>Setiap baris merepresentasikan nama kota tempat tinggal customer</td>\n","  </tr>\n","  <tr>\n","    <td>customer_state</td>\n","    <td>object</td>\n","    <td>Negara Bagian customer</td>\n","    <td>Setiap baris merepresentasikan negara bagian dari tempat tinggal customer</td>\n","  </tr>\n","  <tr>\n","    <td>product_category_name_english</td>\n","    <td>object</td>\n","    <td>Kategori product</td>\n","    <td>Setiap baris merepresentasikan nama kategori dari sebuah product dalam Bahasa Inggris</td>\n","  </tr>\n","  <tr>\n","    <td>month_order</td>\n","    <td>object</td>\n","    <td>Nama bulan order dilakukan</td>\n","    <td>Setiap baris merepresentasikan nama bulan dari tanggal pembelian dilakukan</td>\n","  </tr>\n","  <tr>\n","    <td>weekday_order</td>\n","    <td>object</td>\n","    <td>Nama hari order dilakukan</td>\n","    <td>Setiap baris merepresentasikan nama hari dari tanggal pembelian dilakukan</td>\n","  </tr>\n","  <tr>\n","    <td>month_year_order</td>\n","    <td>period[M]</td>\n","    <td>Tahun dan bulan pembelian</td>\n","    <td>Setiap baris merepresentasikan tahun dan bulan dari tanggal pembelian dilakukan</td>\n","  </tr>\n","\n","</table>"]},{"cell_type":"markdown","metadata":{"id":"_QonEuTeH1qM"},"source":["# Preprocessing Part 1:"]},{"cell_type":"markdown","metadata":{"id":"CCua7Ljk_oWy"},"source":["### Handling Missing Value:"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"oiGvW5mmyN2w","executionInfo":{"status":"ok","timestamp":1633361333248,"user_tz":-420,"elapsed":19,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"fad5ed01-0867-4826-b2f9-fe485684cf96"},"source":["df_olist_clean.isnull().sum()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["order_id                         0\n","order_purchase_timestamp         0\n","order_item_id                    0\n","product_id                       0\n","price                            0\n","freight_value                    0\n","product_photos_qty               0\n","payment_sequential               3\n","payment_type                     3\n","payment_value                    3\n","review_score                     0\n","customer_unique_id               0\n","customer_zip_code_prefix         0\n","customer_city                    0\n","customer_state                   0\n","product_category_name_english    0\n","dtype: int64"]},"metadata":{},"execution_count":55}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":213},"id":"Fm5P70kQ_LQi","executionInfo":{"status":"ok","timestamp":1633361333751,"user_tz":-420,"elapsed":17,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"8fa79ce2-41b9-4a32-f0a8-78d7b5a0f909"},"source":["df_olist_clean[df_olist_clean['payment_type'].isnull()]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>order_id</th>\n","      <th>order_purchase_timestamp</th>\n","      <th>order_item_id</th>\n","      <th>product_id</th>\n","      <th>price</th>\n","      <th>freight_value</th>\n","      <th>product_photos_qty</th>\n","      <th>payment_sequential</th>\n","      <th>payment_type</th>\n","      <th>payment_value</th>\n","      <th>review_score</th>\n","      <th>customer_unique_id</th>\n","      <th>customer_zip_code_prefix</th>\n","      <th>customer_city</th>\n","      <th>customer_state</th>\n","      <th>product_category_name_english</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>51505</th>\n","      <td>bfbd0f9bdef84302105ad712db648a6c</td>\n","      <td>2016-09-15 12:16:38</td>\n","      <td>1.0</td>\n","      <td>5a6b04657a4c5ee34285d1e4619a96b4</td>\n","      <td>44.99</td>\n","      <td>2.83</td>\n","      <td>1.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>830d5b7aaa3b6f1e9ad63703bec97d23</td>\n","      <td>14600</td>\n","      <td>sao joaquim da barra</td>\n","      <td>SP</td>\n","      <td>health_beauty</td>\n","    </tr>\n","    <tr>\n","      <th>51506</th>\n","      <td>bfbd0f9bdef84302105ad712db648a6c</td>\n","      <td>2016-09-15 12:16:38</td>\n","      <td>2.0</td>\n","      <td>5a6b04657a4c5ee34285d1e4619a96b4</td>\n","      <td>44.99</td>\n","      <td>2.83</td>\n","      <td>1.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>830d5b7aaa3b6f1e9ad63703bec97d23</td>\n","      <td>14600</td>\n","      <td>sao joaquim da barra</td>\n","      <td>SP</td>\n","      <td>health_beauty</td>\n","    </tr>\n","    <tr>\n","      <th>51507</th>\n","      <td>bfbd0f9bdef84302105ad712db648a6c</td>\n","      <td>2016-09-15 12:16:38</td>\n","      <td>3.0</td>\n","      <td>5a6b04657a4c5ee34285d1e4619a96b4</td>\n","      <td>44.99</td>\n","      <td>2.83</td>\n","      <td>1.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>1.0</td>\n","      <td>830d5b7aaa3b6f1e9ad63703bec97d23</td>\n","      <td>14600</td>\n","      <td>sao joaquim da barra</td>\n","      <td>SP</td>\n","      <td>health_beauty</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                               order_id  ... product_category_name_english\n","51505  bfbd0f9bdef84302105ad712db648a6c  ...                 health_beauty\n","51506  bfbd0f9bdef84302105ad712db648a6c  ...                 health_beauty\n","51507  bfbd0f9bdef84302105ad712db648a6c  ...                 health_beauty\n","\n","[3 rows x 16 columns]"]},"metadata":{},"execution_count":56}]},{"cell_type":"markdown","metadata":{"id":"DnFUU97hhVCq"},"source":["Column \"payment_sequential\", \"payment_type\", dan \"payment_value\" terdapat 3 data yang *missing value*. *Missing value* pada column tersebut tergolong dalam *Missing Value Completely at Random (MCAR)* yang artinya *missing data* yang terjadi benar-benar secara *random* dan tidak berkaitan dengan variable lain maupun dirinya sendiri. Kemungkinan hal ini terjadi karena adanya kesalahan dalam meng-*input* data. Untuk mengatasi hal tersebut, kami memutuskan untuk men-*drop* ketiga data tersebut dikarenakan jumlah data yang kami punya juga cukup besar. "]},{"cell_type":"code","metadata":{"id":"4yf583aIBgBA"},"source":["df_olist_clean.dropna(inplace = True)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"umvB3gO1B-Of","executionInfo":{"status":"ok","timestamp":1633361333754,"user_tz":-420,"elapsed":17,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"676b3e1f-edb3-4d43-d28d-646e55f50bf5"},"source":["df_olist_clean.isnull().sum()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["order_id                         0\n","order_purchase_timestamp         0\n","order_item_id                    0\n","product_id                       0\n","price                            0\n","freight_value                    0\n","product_photos_qty               0\n","payment_sequential               0\n","payment_type                     0\n","payment_value                    0\n","review_score                     0\n","customer_unique_id               0\n","customer_zip_code_prefix         0\n","customer_city                    0\n","customer_state                   0\n","product_category_name_english    0\n","dtype: int64"]},"metadata":{},"execution_count":58}]},{"cell_type":"markdown","metadata":{"id":"3ZeUJJqF_qKM"},"source":["### Handling Duplicate Value:\n","Proses selanjutnya adalah kita melihat apakah data yang sudah kita *clean* ada data yang *duplicate* atau tidak."]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"YVBgo_O3zWrK","executionInfo":{"status":"ok","timestamp":1633361333755,"user_tz":-420,"elapsed":15,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"24d5525e-1dac-4442-e8ab-11a77aec64ac"},"source":["df_olist_clean.duplicated().sum()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["414"]},"metadata":{},"execution_count":59}]},{"cell_type":"code","metadata":{"id":"EmLFdACDz2jn","colab":{"base_uri":"https://localhost:8080/","height":258},"executionInfo":{"status":"ok","timestamp":1633361334065,"user_tz":-420,"elapsed":321,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"89e62f19-1031-42b0-df72-ef876e91f10c"},"source":["df_olist_clean[df_olist_clean.duplicated()].head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>order_id</th>\n","      <th>order_purchase_timestamp</th>\n","      <th>order_item_id</th>\n","      <th>product_id</th>\n","      <th>price</th>\n","      <th>freight_value</th>\n","      <th>product_photos_qty</th>\n","      <th>payment_sequential</th>\n","      <th>payment_type</th>\n","      <th>payment_value</th>\n","      <th>review_score</th>\n","      <th>customer_unique_id</th>\n","      <th>customer_zip_code_prefix</th>\n","      <th>customer_city</th>\n","      <th>customer_state</th>\n","      <th>product_category_name_english</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>53</th>\n","      <td>5040757d4e06a4be96d3827b860b4e7c</td>\n","      <td>2017-10-20 23:02:08</td>\n","      <td>1.0</td>\n","      <td>f80214fd7d681d1dcf12b3acaf4f0da7</td>\n","      <td>196.99</td>\n","      <td>56.66</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>253.65</td>\n","      <td>5.0</td>\n","      <td>8746f1ba2e19bcf8bc03a946a0923d78</td>\n","      <td>83511</td>\n","      <td>almirante tamandare</td>\n","      <td>PR</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>1254</th>\n","      <td>cb5b7fb63c0add7098c025cb737df02e</td>\n","      <td>2018-02-25 17:37:04</td>\n","      <td>1.0</td>\n","      <td>2b7aa376a6e728560bddb5558cc48e89</td>\n","      <td>116.99</td>\n","      <td>17.26</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>boleto</td>\n","      <td>134.25</td>\n","      <td>5.0</td>\n","      <td>a982bd0fec12d781fecd9f1e17cb81bf</td>\n","      <td>48967</td>\n","      <td>nucleo residencial pilar</td>\n","      <td>BA</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>2706</th>\n","      <td>712cb14ddeca38aaeb49dea61f811018</td>\n","      <td>2018-02-27 15:22:01</td>\n","      <td>1.0</td>\n","      <td>a2a61ecd4e916c3ff787c137d23957bb</td>\n","      <td>47.20</td>\n","      <td>16.60</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>63.80</td>\n","      <td>5.0</td>\n","      <td>3a5b0d10ee72cefb504df217532a4e6a</td>\n","      <td>33400</td>\n","      <td>lagoa santa</td>\n","      <td>MG</td>\n","      <td>housewares</td>\n","    </tr>\n","    <tr>\n","      <th>2930</th>\n","      <td>9de38c42ea4d33af19aac6c4d6c4b146</td>\n","      <td>2018-06-12 16:12:29</td>\n","      <td>1.0</td>\n","      <td>259bd66612b61aa4e82ce3cde9272bbc</td>\n","      <td>25.00</td>\n","      <td>12.84</td>\n","      <td>5.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>37.84</td>\n","      <td>5.0</td>\n","      <td>68215d6b5740453cc6029d69bd017f68</td>\n","      <td>12515</td>\n","      <td>guaratingueta</td>\n","      <td>SP</td>\n","      <td>housewares</td>\n","    </tr>\n","    <tr>\n","      <th>3383</th>\n","      <td>cba44aa41766f6210b875f576a4241e4</td>\n","      <td>2018-07-16 18:10:36</td>\n","      <td>1.0</td>\n","      <td>5d2d01b64b76916f0cbe74e407041187</td>\n","      <td>36.40</td>\n","      <td>15.36</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>51.76</td>\n","      <td>5.0</td>\n","      <td>564df947eb9192d7e1613b1b957cb192</td>\n","      <td>71680</td>\n","      <td>brasilia</td>\n","      <td>DF</td>\n","      <td>housewares</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                              order_id  ... product_category_name_english\n","53    5040757d4e06a4be96d3827b860b4e7c  ...              office_furniture\n","1254  cb5b7fb63c0add7098c025cb737df02e  ...              office_furniture\n","2706  712cb14ddeca38aaeb49dea61f811018  ...                    housewares\n","2930  9de38c42ea4d33af19aac6c4d6c4b146  ...                    housewares\n","3383  cba44aa41766f6210b875f576a4241e4  ...                    housewares\n","\n","[5 rows x 16 columns]"]},"metadata":{},"execution_count":60}]},{"cell_type":"markdown","metadata":{"id":"CU5ULDigkFFx"},"source":["Dari hasil diatas, ditemukan ada 414 data yang memiliki nilai yang benar-benar sama. Pada umumnya, *duplicate value* perlu dihapus, namun sebelum dihapus kami akan melakukan pengecekan pada data yang belum diproses untuk mengetahui apakah data yang *duplicate* ini memiliki arti atau tidak."]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":261},"id":"zIrppB-yAcde","executionInfo":{"status":"ok","timestamp":1633361334780,"user_tz":-420,"elapsed":718,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"1642f665-83ad-457c-9bf0-09e44ab637ef"},"source":["df_olist[(df_olist['order_id'] == \"5040757d4e06a4be96d3827b860b4e7c\") | (df_olist['order_id'] == \"cb5b7fb63c0add7098c025cb737df02e\")]"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>order_id</th>\n","      <th>customer_id</th>\n","      <th>order_status</th>\n","      <th>order_purchase_timestamp</th>\n","      <th>order_approved_at</th>\n","      <th>order_delivered_carrier_date</th>\n","      <th>order_delivered_customer_date</th>\n","      <th>order_estimated_delivery_date</th>\n","      <th>order_item_id</th>\n","      <th>product_id</th>\n","      <th>seller_id</th>\n","      <th>shipping_limit_date</th>\n","      <th>price</th>\n","      <th>freight_value</th>\n","      <th>product_category_name</th>\n","      <th>product_name_lenght</th>\n","      <th>product_description_lenght</th>\n","      <th>product_photos_qty</th>\n","      <th>product_weight_g</th>\n","      <th>product_length_cm</th>\n","      <th>product_height_cm</th>\n","      <th>product_width_cm</th>\n","      <th>payment_sequential</th>\n","      <th>payment_type</th>\n","      <th>payment_installments</th>\n","      <th>payment_value</th>\n","      <th>review_id</th>\n","      <th>review_score</th>\n","      <th>review_comment_title</th>\n","      <th>review_comment_message</th>\n","      <th>review_creation_date</th>\n","      <th>review_answer_timestamp</th>\n","      <th>customer_unique_id</th>\n","      <th>customer_zip_code_prefix</th>\n","      <th>customer_city</th>\n","      <th>customer_state</th>\n","      <th>product_category_name_english</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>52</th>\n","      <td>5040757d4e06a4be96d3827b860b4e7c</td>\n","      <td>0db6ca6d0557c5b2358816e1ed450384</td>\n","      <td>delivered</td>\n","      <td>2017-10-20 23:02:08</td>\n","      <td>2017-10-20 23:14:10</td>\n","      <td>2017-10-27 22:22:26</td>\n","      <td>2017-11-06 22:24:38</td>\n","      <td>2017-11-21 00:00:00</td>\n","      <td>1.0</td>\n","      <td>f80214fd7d681d1dcf12b3acaf4f0da7</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2017-10-31 23:14:10</td>\n","      <td>196.99</td>\n","      <td>56.66</td>\n","      <td>moveis_escritorio</td>\n","      <td>45.0</td>\n","      <td>1156.0</td>\n","      <td>1.0</td>\n","      <td>12250.0</td>\n","      <td>63.0</td>\n","      <td>58.0</td>\n","      <td>24.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>10.0</td>\n","      <td>253.65</td>\n","      <td>afd9b3d196f0acd81d79d8ccd79c2430</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2017-10-31 00:00:00</td>\n","      <td>2017-11-04 21:12:29</td>\n","      <td>8746f1ba2e19bcf8bc03a946a0923d78</td>\n","      <td>83511</td>\n","      <td>almirante tamandare</td>\n","      <td>PR</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>53</th>\n","      <td>5040757d4e06a4be96d3827b860b4e7c</td>\n","      <td>0db6ca6d0557c5b2358816e1ed450384</td>\n","      <td>delivered</td>\n","      <td>2017-10-20 23:02:08</td>\n","      <td>2017-10-20 23:14:10</td>\n","      <td>2017-10-27 22:22:26</td>\n","      <td>2017-11-06 22:24:38</td>\n","      <td>2017-11-21 00:00:00</td>\n","      <td>1.0</td>\n","      <td>f80214fd7d681d1dcf12b3acaf4f0da7</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2017-10-31 23:14:10</td>\n","      <td>196.99</td>\n","      <td>56.66</td>\n","      <td>moveis_escritorio</td>\n","      <td>45.0</td>\n","      <td>1156.0</td>\n","      <td>1.0</td>\n","      <td>12250.0</td>\n","      <td>63.0</td>\n","      <td>58.0</td>\n","      <td>24.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>10.0</td>\n","      <td>253.65</td>\n","      <td>46abf3ea0b2710ad41390fdb79c32d84</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2017-11-07 00:00:00</td>\n","      <td>2017-11-10 20:07:48</td>\n","      <td>8746f1ba2e19bcf8bc03a946a0923d78</td>\n","      <td>83511</td>\n","      <td>almirante tamandare</td>\n","      <td>PR</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>1253</th>\n","      <td>cb5b7fb63c0add7098c025cb737df02e</td>\n","      <td>7e2d8e10c5c9339ad1492ad76452465f</td>\n","      <td>delivered</td>\n","      <td>2018-02-25 17:37:04</td>\n","      <td>2018-02-27 04:31:06</td>\n","      <td>2018-03-01 21:36:54</td>\n","      <td>2018-03-19 16:46:35</td>\n","      <td>2018-04-12 00:00:00</td>\n","      <td>1.0</td>\n","      <td>2b7aa376a6e728560bddb5558cc48e89</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2018-03-13 03:51:50</td>\n","      <td>116.99</td>\n","      <td>17.26</td>\n","      <td>moveis_escritorio</td>\n","      <td>59.0</td>\n","      <td>1296.0</td>\n","      <td>1.0</td>\n","      <td>13388.0</td>\n","      <td>54.0</td>\n","      <td>47.0</td>\n","      <td>28.0</td>\n","      <td>1.0</td>\n","      <td>boleto</td>\n","      <td>1.0</td>\n","      <td>134.25</td>\n","      <td>167b40b617e650de2c473d70baae2e65</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>entrega no prazo correto produto em otima qual...</td>\n","      <td>2018-03-16 00:00:00</td>\n","      <td>2018-03-19 16:37:49</td>\n","      <td>a982bd0fec12d781fecd9f1e17cb81bf</td>\n","      <td>48967</td>\n","      <td>nucleo residencial pilar</td>\n","      <td>BA</td>\n","      <td>office_furniture</td>\n","    </tr>\n","    <tr>\n","      <th>1254</th>\n","      <td>cb5b7fb63c0add7098c025cb737df02e</td>\n","      <td>7e2d8e10c5c9339ad1492ad76452465f</td>\n","      <td>delivered</td>\n","      <td>2018-02-25 17:37:04</td>\n","      <td>2018-02-27 04:31:06</td>\n","      <td>2018-03-01 21:36:54</td>\n","      <td>2018-03-19 16:46:35</td>\n","      <td>2018-04-12 00:00:00</td>\n","      <td>1.0</td>\n","      <td>2b7aa376a6e728560bddb5558cc48e89</td>\n","      <td>7c67e1448b00f6e969d365cea6b010ab</td>\n","      <td>2018-03-13 03:51:50</td>\n","      <td>116.99</td>\n","      <td>17.26</td>\n","      <td>moveis_escritorio</td>\n","      <td>59.0</td>\n","      <td>1296.0</td>\n","      <td>1.0</td>\n","      <td>13388.0</td>\n","      <td>54.0</td>\n","      <td>47.0</td>\n","      <td>28.0</td>\n","      <td>1.0</td>\n","      <td>boleto</td>\n","      <td>1.0</td>\n","      <td>134.25</td>\n","      <td>a334abcb91df2132f817e0ae76ee5d55</td>\n","      <td>5.0</td>\n","      <td>NaN</td>\n","      <td>produto em perfeito de otima qualidade e em pe...</td>\n","      <td>2018-03-20 00:00:00</td>\n","      <td>2018-03-23 15:59:14</td>\n","      <td>a982bd0fec12d781fecd9f1e17cb81bf</td>\n","      <td>48967</td>\n","      <td>nucleo residencial pilar</td>\n","      <td>BA</td>\n","      <td>office_furniture</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                              order_id  ... product_category_name_english\n","52    5040757d4e06a4be96d3827b860b4e7c  ...              office_furniture\n","53    5040757d4e06a4be96d3827b860b4e7c  ...              office_furniture\n","1253  cb5b7fb63c0add7098c025cb737df02e  ...              office_furniture\n","1254  cb5b7fb63c0add7098c025cb737df02e  ...              office_furniture\n","\n","[4 rows x 37 columns]"]},"metadata":{},"execution_count":61}]},{"cell_type":"markdown","metadata":{"id":"78d356WNknQk"},"source":["Hasil pengecekan menunjukan bahwa data yang *duplicate* terjadi karena adanya *customer* yang memberikan 2 *review* terhadap transaksi yang sama. Berdasarkan pengecekan tersebut, kami memutuskan untuk menghapus data yang *duplicate* karena transaksi yang terjadi sebenarnya sama."]},{"cell_type":"code","metadata":{"id":"yE2OwyAp_zDP"},"source":["df_olist_clean = df_olist_clean.drop_duplicates()"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"T_yfDF5EUBvA"},"source":["### Casting Data Types dan Feature Engineering:\n","*Formating Data Types* dilakukan untuk memastikan bahwa *data types* yang kami punya sesuai dengan yang seharusnya. Apabila tidak sesuai, maka *data types* dari sebuah *columns* harus diubah. Selain itu, *Formatting Data Types* juga digunakan untuk memastikan bahwa value dari *data categorical* sudah konsisten, tidak ada nama yang memiliki arti yang sama, namun *categorical*-nya berbeda"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"KhQJo9H3UJAz","executionInfo":{"status":"ok","timestamp":1633361335335,"user_tz":-420,"elapsed":10,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"cfd0a571-d24c-4fc8-98ae-de0359c8247b"},"source":["# Cek tipe data tiap column\n","df_olist_clean.dtypes"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["order_id                          object\n","order_purchase_timestamp          object\n","order_item_id                    float64\n","product_id                        object\n","price                            float64\n","freight_value                    float64\n","product_photos_qty               float64\n","payment_sequential               float64\n","payment_type                      object\n","payment_value                    float64\n","review_score                     float64\n","customer_unique_id                object\n","customer_zip_code_prefix           int64\n","customer_city                     object\n","customer_state                    object\n","product_category_name_english     object\n","dtype: object"]},"metadata":{},"execution_count":63}]},{"cell_type":"markdown","metadata":{"id":"YNI4JpTUoZAo"},"source":["Dari hasil pengecekan, *columns* \"order_purchase_timestamp\" akan lebih baik apabila *data types*-nya diubah menjadi *datetime*. Selain mengubah *data types*, kami juga menambahkan beberapa *column* baru dari hasil ekstraksi *column* \"order_purchase_timestamp\" yang kemungkinan dapat digunakan pada proses *EDA*"]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":241},"id":"l2LIZhZ2JUoy","executionInfo":{"status":"ok","timestamp":1633361335921,"user_tz":-420,"elapsed":593,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"997d0b1d-19c6-449a-c211-34d79828f9cd"},"source":["# Convert type data tanggal jadi datetime\n","df_olist_clean['order_purchase_timestamp'] = pd.to_datetime(df_olist_clean['order_purchase_timestamp'])\n","df_olist_clean['order_purchase_timestamp'].dt.strftime('%Y-%m-%d')\n","\n","df_olist_clean['month_order'] = df_olist_clean['order_purchase_timestamp'].dt.month_name()\n","df_olist_clean['weekday_order'] = df_olist_clean['order_purchase_timestamp'].dt.day_name()\n","df_olist_clean['month_year_order'] = df_olist_clean['order_purchase_timestamp'].dt.to_period('M')\n","df_olist_clean['date_order'] = df_olist_clean['order_purchase_timestamp'].dt.day\n","\n","df_olist_clean.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>order_id</th>\n","      <th>order_purchase_timestamp</th>\n","      <th>order_item_id</th>\n","      <th>product_id</th>\n","      <th>price</th>\n","      <th>freight_value</th>\n","      <th>product_photos_qty</th>\n","      <th>payment_sequential</th>\n","      <th>payment_type</th>\n","      <th>payment_value</th>\n","      <th>review_score</th>\n","      <th>customer_unique_id</th>\n","      <th>customer_zip_code_prefix</th>\n","      <th>customer_city</th>\n","      <th>customer_state</th>\n","      <th>product_category_name_english</th>\n","      <th>month_order</th>\n","      <th>weekday_order</th>\n","      <th>month_year_order</th>\n","      <th>date_order</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>00e7ee1b050b8499577073aeb2a297a1</td>\n","      <td>2017-05-16 15:05:35</td>\n","      <td>1.0</td>\n","      <td>a9516a079e37a9c9c36b9b78b10169e8</td>\n","      <td>124.99</td>\n","      <td>21.88</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>146.87</td>\n","      <td>4.0</td>\n","      <td>861eff4711a542e4b93843c6dd7febb0</td>\n","      <td>14409</td>\n","      <td>franca</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","      <td>May</td>\n","      <td>Tuesday</td>\n","      <td>2017-05</td>\n","      <td>16</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>b2059ed67ce144a36e2aa97d2c9e9ad2</td>\n","      <td>2018-05-19 16:07:45</td>\n","      <td>1.0</td>\n","      <td>bd07b66896d6f1494f5b86251848ced7</td>\n","      <td>139.94</td>\n","      <td>17.79</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>157.73</td>\n","      <td>5.0</td>\n","      <td>060e732b5b29e8181a18229c7b0b2b5e</td>\n","      <td>1151</td>\n","      <td>sao paulo</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","      <td>May</td>\n","      <td>Saturday</td>\n","      <td>2018-05</td>\n","      <td>19</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>951670f92359f4fe4a63112aa7306eba</td>\n","      <td>2018-03-13 16:06:38</td>\n","      <td>1.0</td>\n","      <td>a5647c44af977b148e0a3a4751a09e2e</td>\n","      <td>149.94</td>\n","      <td>23.36</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>173.30</td>\n","      <td>5.0</td>\n","      <td>259dac757896d24d7702b9acbbff3f3c</td>\n","      <td>8775</td>\n","      <td>mogi das cruzes</td>\n","      <td>SP</td>\n","      <td>office_furniture</td>\n","      <td>March</td>\n","      <td>Tuesday</td>\n","      <td>2018-03</td>\n","      <td>13</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>997fd4b37386d10b57d4ac8cdec011a6</td>\n","      <td>2018-07-08 09:59:19</td>\n","      <td>1.0</td>\n","      <td>8ed094bfe076c568f6bb10feada3f75d</td>\n","      <td>199.98</td>\n","      <td>115.77</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>credit_card</td>\n","      <td>315.75</td>\n","      <td>1.0</td>\n","      <td>07d190f123147d9e89d4b922543d7948</td>\n","      <td>65075</td>\n","      <td>sao luis</td>\n","      <td>MA</td>\n","      <td>office_furniture</td>\n","      <td>July</td>\n","      <td>Sunday</td>\n","      <td>2018-07</td>\n","      <td>8</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>b63fff1ef8b6201df68bb611ee41129e</td>\n","      <td>2017-04-02 22:15:27</td>\n","      <td>1.0</td>\n","      <td>aba86c093ccdbac75b09111d57e50004</td>\n","      <td>129.60</td>\n","      <td>16.61</td>\n","      <td>1.0</td>\n","      <td>1.0</td>\n","      <td>boleto</td>\n","      <td>146.21</td>\n","      <td>4.0</td>\n","      <td>332cf4e83e16004ba7dca932ce82475b</td>\n","      <td>90010</td>\n","      <td>porto alegre</td>\n","      <td>RS</td>\n","      <td>office_furniture</td>\n","      <td>April</td>\n","      <td>Sunday</td>\n","      <td>2017-04</td>\n","      <td>2</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                           order_id  ... date_order\n","0  00e7ee1b050b8499577073aeb2a297a1  ...         16\n","1  b2059ed67ce144a36e2aa97d2c9e9ad2  ...         19\n","2  951670f92359f4fe4a63112aa7306eba  ...         13\n","3  997fd4b37386d10b57d4ac8cdec011a6  ...          8\n","4  b63fff1ef8b6201df68bb611ee41129e  ...          2\n","\n","[5 rows x 20 columns]"]},"metadata":{},"execution_count":64}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"HSxgRev9UMCT","executionInfo":{"status":"ok","timestamp":1633361335925,"user_tz":-420,"elapsed":34,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"bc8d2aea-2131-476e-9699-abfedd5ee9c5"},"source":["df_olist_clean.dtypes"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["order_id                                 object\n","order_purchase_timestamp         datetime64[ns]\n","order_item_id                           float64\n","product_id                               object\n","price                                   float64\n","freight_value                           float64\n","product_photos_qty                      float64\n","payment_sequential                      float64\n","payment_type                             object\n","payment_value                           float64\n","review_score                            float64\n","customer_unique_id                       object\n","customer_zip_code_prefix                  int64\n","customer_city                            object\n","customer_state                           object\n","product_category_name_english            object\n","month_order                              object\n","weekday_order                            object\n","month_year_order                      period[M]\n","date_order                                int64\n","dtype: object"]},"metadata":{},"execution_count":65}]},{"cell_type":"markdown","metadata":{"id":"nfamXQYaVn_r"},"source":["### Inconsisten Variable:\n","Untuk memastikan bahwa data categorical nilainya konsisten, kami akan mengecek data-data categorical yang kami punya. Data Categorical yang kami punya adalah \"payment_type\", \"customer_city\", \"customer_state\", \"product_category_name_english\""]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"LBu5C7zZV7Az","executionInfo":{"status":"ok","timestamp":1633361335926,"user_tz":-420,"elapsed":33,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"9cc6160f-f756-44d5-8731-848dcba5dc47"},"source":["# Cek categorical data\n","categorical_data = [\"payment_type\", \"customer_city\", \"customer_state\", \"product_category_name_english\"]\n","\n","for i in categorical_data:\n","  print(f\"Unique Value dari {i}\")\n","  print(sorted(df_olist_clean[i].unique()))\n","  print('\\n')"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Unique Value dari payment_type\n","['boleto', 'credit_card', 'debit_card', 'voucher']\n","\n","\n","Unique Value dari customer_city\n","['abadia dos dourados', 'abadiania', 'abaete', 'abaetetuba', 'abaiara', 'abaira', 'abare', 'abatia', 'abdon batista', 'abelardo luz', 'abrantes', 'abre campo', 'abreu e lima', 'acaiaca', 'acailandia', 'acajutiba', 'acarau', 'acari', 'acegua', 'acopiara', 'acreuna', 'acu', 'acucena', 'adamantina', 'adhemar de barros', 'adolfo', 'adrianopolis', 'adustina', 'afogados da ingazeira', 'afonso claudio', 'afranio', 'agisse', 'agrolandia', 'agronomica', 'agua boa', 'agua branca', 'agua clara', 'agua comprida', 'agua doce', 'agua doce do norte', 'agua fria de goias', 'agua limpa', 'agua nova', 'agua preta', 'agua santa', 'aguai', 'aguas belas', 'aguas claras', 'aguas da prata', 'aguas de lindoia', 'aguas de santa barbara', 'aguas de sao pedro', 'aguas formosas', 'aguas frias', 'aguas lindas de goias', 'aguas mornas', 'aguas vermelhas', 'agudo', 'agudos', 'aguia branca', 'aimores', 'aiuaba', 'aiuruoca', 'ajapi', 'ajuricaba', 'alagoa', 'alagoa grande', 'alagoa nova', 'alagoinha', 'alagoinhas', 'alambari', 'alcantara', 'alcinopolis', 'alcobaca', 'alegre', 'alegrete', 'alegrete do piaui', 'alegria', 'alem paraiba', 'alexandra', 'alexandria', 'alexandrita', 'alexania', 'alfenas', 'alfredo chaves', 'alfredo marcondes', 'alfredo vasconcelos', 'alfredo wagner', 'alhandra', 'alianca', 'alianca do tocantins', 'almas', 'almenara', 'almino afonso', 'almirante tamandare', 'almirante tamandare do sul', 'alpercata', 'alpestre', 'alpinopolis', 'alta floresta', \"alta floresta d'oeste\", 'altamira', 'altamira do parana', 'altaneira', 'alterosa', 'altinho', 'altinopolis', 'alto alegre', 'alto alegre do iguacu', 'alto alegre do maranhao', 'alto alegre do pindare', 'alto araguaia', 'alto boa vista', 'alto caparao', 'alto do rodrigues', 'alto garcas', 'alto horizonte', 'alto jequitiba', 'alto paraiso', 'alto paraiso de goias', 'alto parana', 'alto parnaiba', 'alto piquiri', 'alto rio doce', 'alto rio novo', 'alto santo', 'alto sao joao', 'alto taquari', 'altonia', 'altos', 'aluminio', 'alvarenga', 'alvares florence', 'alvares machado', 'alvaro de carvalho', 'alvinopolis', 'alvorada', \"alvorada d'oeste\", 'alvorada do gurgueia', 'alvorada do norte', 'amambai', 'amanari', 'amapa do maranhao', 'amapora', 'amaraji', 'amarante', 'amargosa', 'amelia rodrigues', 'america dourada', 'americana', 'americano do brasil', 'americo brasiliense', 'americo de campos', 'ametista do sul', 'amontada', 'amparo', 'amparo da serra', 'ampere', 'anadia', 'anage', 'analandia', 'ananas', 'ananindeua', 'anapolis', 'anastacio', 'anaurilandia', 'anchieta', 'andarai', 'andira', 'andorinha', 'andradas', 'andradina', 'andre da rocha', 'andrelandia', 'andrequice', 'angatuba', 'angelica', 'angelina', 'angelo frechiani', 'angical', 'angical do piaui', 'angicos', 'angra dos reis', 'anguera', 'angulo', 'angustura', 'anhandui', 'anhembi', 'anhumas', 'anicuns', 'anita garibaldi', 'anitapolis', 'anta', 'anta gorda', 'antonina', 'antonina do norte', 'antonio cardoso', 'antonio carlos', 'antonio goncalves', 'antonio martins', 'antonio pereira', 'antonio prado', 'antonio prado de minas', 'antunes', 'aparecida', \"aparecida d'oeste\", 'aparecida de goiania', 'aparecida de monte alto', 'aparecida de sao manuel', 'aparecida do rio negro', 'aparecida do taboado', 'aperibe', 'apiaca', 'apiacas', 'apiai', 'apiuna', 'apodi', 'apora', 'apore', 'apuarema', 'apucarana', 'apuiares', 'aquidaba', 'aquidauana', 'aquiraz', 'aracaju', 'aracariguama', 'aracati', 'aracatu', 'aracatuba', 'arace', 'araci', 'aracitaba', 'aracoiaba', 'aracoiaba da serra', 'aracruz', 'aracuai', 'aragarcas', 'aragoiania', 'araguacu', 'araguaia', 'araguaina', 'araguana', 'araguapaz', 'araguari', 'araguatins', 'aramari', 'arame', 'aramina', 'arandu', 'arantina', 'arapei', 'arapiraca', 'arapoema', 'araponga', 'arapongas', 'arapora', 'arapoti', 'arapua', 'araputanga', 'araquari', 'arara', 'ararangua', 'araraquara', 'araras', 'arari', 'ararica', 'araripe', 'araripina', 'araruama', 'araruna', 'arataca', 'aratiba', 'aratuba', 'araucaria', 'araujos', 'araxa', 'arceburgo', 'arcos', 'arcoverde', 'areado', 'areal', 'arealva', 'areia', 'areia branca', 'areia branca dos assis', 'areial', 'areias', 'areiopolis', 'arembepe', 'arenapolis', 'arenopolis', 'aribice', 'arinos', 'aripuana', 'ariquemes', 'ariranha', 'armacao dos buzios', 'armazem', 'arneiroz', 'aroeiras', 'arraial d ajuda', \"arraial d'ajuda\", 'arraial do cabo', 'arraias', 'arroio do meio', 'arroio do sal', 'arroio do tigre', 'arroio dos ratos', 'arroio grande', 'arroio trinta', 'arrozal', 'artur nogueira', 'aruana', 'aruja', 'arvoredo', 'arvorezinha', 'ascurra', 'assai', 'assare', 'assis', 'assis chateaubriand', 'assuncao', 'astolfo dutra', 'astorga', 'atalaia', 'atalanta', 'ataleia', 'atibaia', 'atilio vivacqua', 'augustinopolis', 'augusto correa', 'augusto pestana', 'aurea', 'auriflama', 'aurilandia', 'aurora', 'aurora do para', 'avai', 'avanhandava', 'avare', 'avelar', 'avelino lopes', 'azurita', 'bacabal', 'bacaxa', 'bacuri', 'bady bassitt', 'baependi', 'bage', 'baguari', 'baianopolis', 'baixa grande', 'baixa grande do ribeiro', 'baixo guandu', 'balbinos', 'baldim', 'balneario arroio do silva', 'balneario barra do sul', 'balneario camboriu', 'balneario gaivota', 'balneario picarras', 'balneario pinhal', 'balneario rincao', 'balsa nova', 'balsamo', 'balsas', 'bambui', 'banabuiu', 'bananal', 'bananeiras', 'bandeira', 'bandeira do sul', 'bandeirantes', \"bandeirantes d'oeste\", 'bandeirantes do tocantins', 'banzae', 'barao', 'barao ataliba nogueira', 'barao de cocais', 'barao de cotegipe', 'barao de juparana', 'barao do triunfo', 'barauna', 'barbacena', 'barbalha', 'barbosa ferraz', 'barcarena', 'bariri', 'barra', 'barra bonita', 'barra da estiva', 'barra de guabiraba', 'barra de santa rosa', 'barra de santo antonio', 'barra de sao francisco', 'barra de sao joao', 'barra de sao miguel', 'barra do bugres', 'barra do choca', 'barra do corda', 'barra do garcas', 'barra do jacare', 'barra do mendes', 'barra do pirai', 'barra do ribeiro', 'barra do rio azul', 'barra do tarrachil', 'barra do turvo', 'barra dos coqueiros', 'barra longa', 'barra mansa', 'barra velha', 'barracao', 'barras', 'barreira', 'barreiras', 'barreirinhas', 'barreiros', 'barretos', 'barrinha', 'barro', 'barro alto', 'barro preto', 'barrocas', 'barrolandia', 'barros cassal', 'barroso', 'barueri', 'bastos', 'bataguassu', 'bataipora', 'batalha', 'batatais', 'bataypora', 'baturite', 'bauru', 'bayeux', 'bebedouro', 'beberibe', 'bela cruz', 'bela vista', 'bela vista de goias', 'bela vista de minas', 'bela vista do maranhao', 'bela vista do paraiso', 'belem', 'belem do sao francisco', 'belford roxo', 'belmonte', 'belo campo', 'belo horizonte', 'belo jardim', 'belo oriente', 'belo vale', 'bemposta', 'benedito leite', 'benedito novo', 'benevides', 'bento de abreu', 'bento goncalves', 'bequimao', 'berilo', 'berizal', 'bernardino de campos', 'bertioga', 'bertolinia', 'bertopolis', 'betim', 'bezerros', 'bias fortes', 'bicas', 'biguacu', 'bilac', 'birigui', 'biritiba-mirim', 'biritinga', 'bituruna', 'blumenau', 'boa esperanca', 'boa esperanca do iguacu', 'boa esperanca do sul', 'boa ventura', 'boa viagem', 'boa vista', 'boa vista da aparecida', 'boa vista das missoes', 'boa vista do burica', 'boa vista do cadeado', 'boa vista do gurupi', 'boa vista do sul', 'boca da mata', 'bocaina', 'bocaiuva', 'bocaiuva do sul', 'bodo', 'bodoco', 'bodoquena', 'bofete', 'boituva', 'bom conselho', 'bom despacho', 'bom jardim', 'bom jardim de goias', 'bom jardim de minas', 'bom jesus', 'bom jesus da lapa', 'bom jesus da penha', 'bom jesus da serra', 'bom jesus das selvas', 'bom jesus do amparo', 'bom jesus do araguaia', 'bom jesus do galho', 'bom jesus do itabapoana', 'bom jesus do norte', 'bom jesus do querendo', 'bom jesus do sul', 'bom jesus do tocantins', 'bom jesus dos perdoes', 'bom principio', 'bom repouso', 'bom retiro', 'bom retiro do sul', 'bom sucesso', 'bombinhas', 'bonfim', 'bonfim paulista', 'bonfinopolis', 'bonfinopolis de minas', 'boninal', 'bonito', 'bonito de minas', 'bonito de santa fe', 'boqueirao do leao', 'boquim', 'boquira', 'bora', 'boraceia', 'borborema', 'borda da mata', 'borrazopolis', 'bossoroca', 'botelho', 'botelhos', 'botucatu', 'botupora', 'botuvera', 'braco do norte', 'braco do rio', 'braganca', 'braganca paulista', 'bras pires', 'brasil novo', 'brasilandia', 'brasilandia de minas', 'brasileia', 'brasilia', 'brasilia de minas', 'brasopolis', 'brauna', 'braunas', 'brazabrantes', 'brazopolis', 'brejetuba', 'brejo', 'brejo bonito', 'brejo da madre de deus', 'brejo do cruz', 'brejo dos santos', 'brejo grande', 'brejo santo', 'brejoes', 'brejolandia', 'breu branco', 'breves', 'britania', 'brodowski', 'brotas', 'brotas de macaubas', 'brumadinho', 'brumado', 'brusque', 'bueno brandao', 'buenopolis', 'buenos aires', 'buerarema', 'bugre', 'buique', 'buri', 'buritama', 'buriti', 'buriti alegre', 'buriti do tocantins', 'buriti dos lopes', 'buriticupu', 'buritirama', 'buritis', 'buritizal', 'buritizeiro', 'butia', 'caarapo', 'cabaceiras do paraguacu', 'cabeceira grande', 'cabeceiras', 'cabedelo', 'cabixi', 'cabo de santo agostinho', 'cabo frio', 'cabo verde', 'cabralia paulista', 'cabreuva', 'cabrobo', 'cacador', 'cacapava', 'cacapava do sul', 'cacaulandia', 'cacequi', 'caceres', 'cachoeira', 'cachoeira alta', 'cachoeira da prata', 'cachoeira de minas', 'cachoeira de pajeu', 'cachoeira do brumado', 'cachoeira do campo', 'cachoeira do sul', 'cachoeira dourada', 'cachoeira paulista', 'cachoeiras de macacu', 'cachoeirinha', 'cachoeiro de itapemirim', 'cacimbinhas', 'cacoal', 'caconde', 'cacu', 'cacule', 'caem', 'caetanopolis', 'caete', 'caetes', 'caetite', 'cafeara', 'cafelandia', 'caiana', 'caiaponia', 'caibate', 'caibi', 'caicara do norte', 'caico', 'caieiras', 'cairu', 'caiua', 'cajamar', 'cajapio', 'cajari', 'cajati', 'cajazeiras', 'cajobi', 'cajueiro', 'cajuri', 'cajuru', 'calcado', 'caldas', 'caldas brandao', 'caldas do jorro', 'caldas novas', 'caldeirao grande', 'caldeirao grande do piaui', 'california', 'california da barra', 'calmon', 'camacan', 'camacari', 'camacho', 'camamu', 'camanducaia', 'camapua', 'camaqua', 'camaragibe', 'cambara', 'cambara do sul', 'cambe', 'cambiasca', 'cambira', 'camboriu', 'cambuci', 'cambui', 'cambuquira', 'cameta', 'camocim', 'camocim de sao felix', 'campanario', 'campanha', 'campestre', 'campestre da serra', 'campestre do maranhao', 'campina da lagoa', 'campina das missoes', 'campina do monte alegre', 'campina grande', 'campina grande do sul', 'campina verde', 'campinacu', 'campinapolis', 'campinas', 'campinas do sul', 'campinorte', 'campo alegre', 'campo alegre de goias', 'campo alegre de lourdes', 'campo alegre de minas', 'campo alegre do fidalgo', 'campo azul', 'campo belo', 'campo bom', 'campo bonito', 'campo do brito', 'campo do meio', 'campo do tenente', 'campo ere', 'campo florido', 'campo formoso', 'campo grande', 'campo grande do piaui', 'campo largo', 'campo limpo paulista', 'campo magro', 'campo maior', 'campo mourao', 'campo novo', 'campo novo do parecis', 'campo verde', 'campos altos', 'campos belos', 'campos borges', 'campos de julio', 'campos do jordao', 'campos dos goytacazes', 'campos gerais', 'campos novos', 'campos sales', 'campos verdes', 'camutanga', 'canaa', 'canaa dos carajas', 'cananeia', 'canapi', 'canapolis', 'canarana', 'canavieiras', 'candeal', 'candeias', 'candeias do jamari', 'candelaria', 'candido de abreu', 'candido godoi', 'candido mendes', 'candido mota', 'candido rodrigues', 'candido sales', 'candiota', 'candoi', 'canela', 'canelinha', 'cangucu', 'canhotinho', 'caninde', 'caninde de sao francisco', 'canitar', 'canoas', 'canoinhas', 'cansancao', 'cantagalo', 'cantanhede', 'canto do buriti', 'canudos', 'capanema', 'capao bonito', 'capao da canoa', 'capao da porteira', 'capao do cipo', 'capao do leao', 'caparao', 'capela', 'capela de santana', 'capela do alto', 'capela do alto alegre', 'capela nova', 'capelinha', 'capetinga', 'capim branco', 'capim grosso', 'capinopolis', 'capinzal', 'capinzal do norte', 'capistrano', 'capitao', 'capitao andrade', 'capitao eneas', 'capitao leonidas marques', 'capitao poco', 'capitolio', 'capivari', 'capivari de baixo', 'capivari do sul', 'capoeiras', 'caputira', 'caracol', 'caraguatatuba', 'carai', 'caraiba', 'caraibas', 'carajas', 'carambei', 'carandai', 'carangola', 'carapebus', 'carapicuiba', 'caratinga', 'caraubas', 'caravelas', 'carazinho', 'carbonita', 'cardoso', 'cardoso moreira', 'careacu', 'cariacica', 'caridade', 'carinhanha', 'carire', 'cariri do tocantins', 'caririacu', 'carius', 'carlinda', 'carlopolis', 'carlos barbosa', 'carlos chagas', 'carmesia', 'carmo', 'carmo da cachoeira', 'carmo da mata', 'carmo de minas', 'carmo do cajuru', 'carmo do paranaiba', 'carmo do rio claro', 'carmo do rio verde', 'carmolandia', 'carmopolis', 'carmopolis de minas', 'carnaiba do sertao', 'carnauba dos dantas', 'carnaubais', 'carnaubal', 'carneirinho', 'carolina', 'carpina', 'carrancas', 'caruaru', 'carutapera', 'carvalhopolis', 'casa branca', 'casa nova', 'casca', 'cascalho rico', 'cascavel', 'caseiros', 'casimiro de abreu', 'cassia', 'cassia dos coqueiros', 'cassilandia', 'castanhal', 'castanheira', 'castanheiras', 'castelandia', 'castelo', 'castelo do piaui', 'castilho', 'castro', 'castro alves', 'cataguases', 'catalao', 'catanduva', 'catanduvas', 'catarina', 'catas altas', 'catende', 'catigua', 'catole do rocha', 'catu', 'catu de abrantes', 'catuipe', 'caturama', 'caucaia', 'cavalcante', 'caxambu', 'caxambu do sul', 'caxias', 'caxias do sul', 'ceara-mirim', 'cedral', 'cedro', 'cedro de sao joao', 'cedro do abaete', 'ceilandia', 'celina', 'celso ramos', 'centenario', 'centenario do sul', 'central', 'central de santa helena', 'centralina', 'centro novo do maranhao', 'cerejeiras', 'ceres', 'cerqueira cesar', 'cerquilho', 'cerrito', 'cerro azul', 'cerro grande', 'cerro grande do sul', 'cerro largo', 'cerro negro', 'cesario lange', 'ceu azul', 'cezarina', 'cha de alegria', 'cha grande', 'chacara', 'chale', 'chapada', 'chapada do norte', 'chapada dos guimaraes', 'chapada gaucha', 'chapadao do ceu', 'chapadao do lageado', 'chapadao do sul', 'chapadinha', 'chapeco', 'charqueada', 'charqueadas', 'charrua', 'chaval', 'chavantes', 'chaveslandia', 'chiapetta', 'chopinzinho', 'chorozinho', 'chorrocho', 'chui', 'cianorte', 'cicero dantas', 'cidade gaucha', 'cidade ocidental', 'cidelandia', 'cidreira', 'cipo', 'cipo-guacu', 'ciriaco', 'claraval', 'claro dos pocoes', 'claudia', 'claudio', 'clementina', 'clevelandia', 'coaraci', 'coari', 'cocais', 'cocal', 'cocal do sul', 'cocalinho', 'cocalzinho de goias', 'cocos', 'codo', 'coelho neto', 'coimbra', 'coite do noia', 'colatina', 'colider', 'colina', 'colinas', 'colinas do tocantins', 'colmeia', 'colniza', 'colombia', 'colombo', 'colonia castrolanda', 'colonia jordaozinho', 'colonia leopoldina', 'colonia vitoria', 'colorado', 'colorado do oeste', 'coluna', 'combinado', 'comendador levy gasparian', 'comercinho', 'comodoro', 'conceicao', 'conceicao da aparecida', 'conceicao da barra', 'conceicao da feira', 'conceicao da ibitipoca', 'conceicao das alagoas', 'conceicao das pedras', 'conceicao de macabu', 'conceicao do almeida', 'conceicao do araguaia', 'conceicao do caninde', 'conceicao do castelo', 'conceicao do coite', 'conceicao do formoso', 'conceicao do jacuipe', 'conceicao do mato dentro', 'conceicao do para', 'conceicao do rio verde', 'conceicao do tocantins', 'conceicao dos ouros', 'conchal', 'conchas', 'concordia', 'concordia do para', 'condado', 'conde', 'condeuba', 'condor', 'confins', 'confresa', 'congonhal', 'congonhas', 'congonhinhas', 'conquista', \"conquista d'oeste\", 'conrado', 'conselheiro lafaiete', 'conselheiro mairinck', 'conselheiro pena', 'conservatoria', 'constantina', 'contagem', 'contenda', 'coqueiro baixo', 'coqueiros do sul', 'coracao de jesus', 'coracao de maria', 'corbelia', 'cordeiro', 'cordeiropolis', 'cordeiros', 'coreau', 'coremas', 'corguinho', 'coribe', 'corinto', 'cornelio procopio', 'coroaci', 'coroados', 'coroata', 'coromandel', 'coronel domingos soares', 'coronel fabriciano', 'coronel freitas', 'coronel joao pessoa', 'coronel joao sa', 'coronel macedo', 'coronel martins', 'coronel murta', 'coronel pacheco', 'coronel sapucaia', 'coronel vivida', 'corrego danta', 'corrego do ouro', 'corrego fundo', 'correia pinto', 'corrente', 'correntes', 'correntina', 'cortes', 'corumba', 'corumba de goias', 'corumbaiba', 'corumbatai', 'corumbatai do sul', 'corupa', 'coruripe', 'cosmopolis', 'cosmorama', 'costa marques', 'costa rica', 'cotegipe', 'cotia', 'cotipora', 'cotriguacu', 'couto de magalhaes', 'coxilha', 'coxim', 'crateus', 'crato', 'cravinhos', 'cravolandia', 'criciuma', 'crisolita', 'crisopolis', 'crissiumal', 'cristais', 'cristais paulista', 'cristal', 'cristalandia', 'cristalia', 'cristalina', 'cristiano otoni', 'cristina', 'cristinapolis', 'cristopolis', 'crixas', 'croata', 'crominia', 'crucilandia', 'cruz', 'cruz alta', 'cruz das almas', 'cruz machado', 'cruzalia', 'cruzeiro', 'cruzeiro da fortaleza', 'cruzeiro do iguacu', 'cruzeiro do oeste', 'cruzeiro do sul', 'cruzilia', 'cubatao', 'cubati', 'cuiaba', 'cuite', 'cuite velho', 'cujubim', 'cumari', 'cumaru', 'cunha', 'cunha pora', 'cupira', 'curaca', 'curitiba', 'curitibanos', 'curiuva', 'currais novos', 'curral de cima', 'curralinho', 'curuca', 'cururupu', 'curvelandia', 'curvelo', 'custodia', 'damianopolis', 'dario meira', 'datas', 'david canabarro', 'delfim moreira', 'delfinopolis', 'delmiro gouveia', 'demerval lobao', 'denise', 'deodapolis', 'deputado irapuan pinheiro', 'descalvado', 'descoberto', 'desembargador otoni', 'desterro', 'desterro de entre rios', 'desterro do melo', 'dezesseis de novembro', 'diadema', \"diamante d'oeste\", 'diamante do norte', 'diamantina', 'diamantino', 'dianopolis', 'dias d avila', \"dias d'avila\", 'diogo de vasconcelos', 'dionisio', 'dionisio cerqueira', 'diorama', 'divinesia', 'divino', 'divino das laranjeiras', 'divino de sao lourenco', 'divinolandia', 'divinolandia de minas', 'divinopolis', 'divinopolis de goias', 'divinopolis do tocantins', 'divisa alegre', 'divisa nova', 'dobrada', 'doce grande', 'dois corregos', 'dois irmaos', 'dois irmaos do buriti', 'dois riachos', 'dois vizinhos', 'dom aquino', 'dom basilio', 'dom cavati', 'dom eliseu', 'dom feliciano', 'dom joaquim', 'dom macedo costa', 'dom pedrito', 'dom pedro', 'dom silverio', 'dom vicoso', 'domiciano ribeiro', 'domingos martins', 'dona emma', 'dona euzebia', 'dona francisca', 'dores de campos', 'dores de guanhaes', 'dores do indaia', 'dores do rio preto', 'dormentes', 'douradina', 'dourado', 'dourados', 'doutor camargo', 'doutor ulysses', 'doverlandia', 'dracena', 'duartina', 'duas barras', 'duere', 'dumont', 'duque de caxias', 'durande', 'echapora', 'ecoporanga', 'edeia', 'eldorado', 'eldorado do sul', 'elias fausto', 'eliseu martins', 'elisiario', 'elisio medrado', 'eloi mendes', 'embauba', 'embu', 'embu das artes', 'embu-guacu', 'emilianopolis', 'encantado', 'encruzilhada do sul', 'eneas marques', 'engenheiro balduino', 'engenheiro beltrao', 'engenheiro coelho', 'engenheiro navarro', 'engenheiro passos', 'engenheiro paulo de frontin', 'entre folhas', 'entre rios', 'entre rios de minas', 'entre rios do oeste', 'entre-ijuis', 'epitaciolandia', 'erebango', 'erechim', 'erere', 'erico cardoso', 'erval grande', 'ervalia', 'escada', 'esmeralda', 'esmeraldas', 'espera feliz', 'esperanca', 'esperantina', 'esperantinopolis', 'espigao', 'espigao alto do iguacu', 'espigao do oeste', 'espinosa', 'espirito santo do pinhal', 'espirito santo do turvo', 'esplanada', 'espumoso', 'estacao', 'estancia', 'estancia velha', 'esteio', 'estevao de araujo', 'estiva', 'estiva gerbi', 'estreito', 'estrela', 'estrela d oeste', \"estrela d'oeste\", 'estrela do indaia', 'estrela do norte', 'estrela do sul', 'estrela velha', 'euclides da cunha', 'euclides da cunha paulista', 'eugenio de castro', 'eugenopolis', 'eunapolis', 'eusebio', 'ewbank da camara', 'extrema', 'extremoz', 'fagundes', 'farol', 'farroupilha', 'fartura', 'fatima', 'fatima do sul', 'faxinal', 'faxinal dos guedes', 'faxinalzinho', 'fazenda nova', 'fazenda rio grande', 'fazenda vilanova', 'feira de santana', 'feira nova', 'felicio dos santos', 'felisburgo', 'felixlandia', 'feliz', 'feliz deserto', 'feliz natal', 'fenix', 'fernando prestes', 'fernandopolis', 'fernao', 'ferraz de vasconcelos', 'ferreiros', 'ferros', 'fervedouro', 'figueira', \"figueiropolis d'oeste\", 'filadelfia', 'firminopolis', 'flor da serra do sul', 'flora rica', 'florai', 'florania', 'floreal', 'flores', 'flores da cunha', 'flores de goias', 'floresta', 'floresta do araguaia', 'florestal', 'florestopolis', 'floriano', 'florianopolis', 'florida', 'florida paulista', 'florinia', 'fonseca', 'fontoura xavier', 'formiga', 'formigueiro', 'formosa', 'formosa da serra negra', 'formosa do oeste', 'formosa do rio preto', 'formoso', 'formoso do araguaia', 'forquilha', 'forquilhinha', 'fortaleza', 'fortaleza dos valos', 'fortim', 'fortuna', 'foz do iguacu', 'foz do jordao', 'fragosos', 'fraiburgo', 'franca', 'francisco badaro', 'francisco beltrao', 'francisco dantas', 'francisco dumont', 'francisco morato', 'francisco sa', 'francisco santos', 'franco da rocha', 'frecheirinha', 'frederico westphalen', 'frei gaspar', 'frei inocencio', 'frei lagonegro', 'frei martinho', 'frei rogerio', 'fronteira', 'fronteiras', 'fruta de leite', 'frutal', 'frutuoso gomes', 'fundao', 'gabriel monteiro', 'galia', 'galinhos', 'galvao', 'gameleira', 'gameleiras', 'gandu', 'garanhuns', 'garca', 'garibaldi', 'garopaba', 'garrafao do norte', 'garruchos', 'garuva', 'gaspar', 'gastao vidigal', 'gaucha do norte', 'gaurama', 'gaviao peixoto', 'general camara', 'general carneiro', 'general maynard', 'general salgado', 'gentio do ouro', 'getulina', 'getulio vargas', 'gilbues', 'girau do ponciano', 'girua', 'glaura', 'glicerio', 'gloria de dourados', 'gloria do goita', 'glorinha', 'godoy moreira', 'goiabeira', 'goiana', 'goianapolis', 'goiandira', 'goianesia', 'goianesia do para', 'goiania', 'goianinha', 'goianira', 'goianorte', 'goias', 'goiatuba', 'goioere', 'goitacazes', 'goncalves', 'goncalves dias', 'gongogi', 'gouveia', 'governador celso ramos', 'governador dix-sept rosado', 'governador eugenio barros', 'governador lindenberg', 'governador mangabeira', 'governador portela', 'governador valadares', 'graccho cardoso', 'grajau', 'gramado', 'gramado dos loureiros', 'gramado xavier', 'grandes rios', 'granja', 'grao mogol', 'grao para', 'gravata', 'gravatai', 'gravatal', 'groairas', 'grupiara', 'guabiju', 'guabiruba', 'guacui', 'guadalupe', 'guaiba', 'guaicara', 'guaira', 'guairaca', 'guaiuba', 'guajara-mirim', 'guamare', 'guamiranga', 'guanambi', 'guanhaes', 'guape', 'guapiacu', 'guapiara', 'guapimirim', 'guapirama', 'guapo', 'guapore', 'guara', 'guarabira', 'guaracai', 'guaraci', 'guaraciaba', 'guaraciaba do norte', 'guarai', 'guaramirim', 'guaranesia', 'guarani', 'guarani das missoes', 'guaraniacu', 'guaranta', 'guaranta do norte', 'guarapari', 'guarapua', 'guarapuava', 'guaraquecaba', 'guarara', 'guararapes', 'guararema', 'guaratinga', 'guaratingueta', 'guaratuba', 'guarda-mor', 'guarei', 'guariba', 'guariroba', 'guaruja', 'guaruja do sul', 'guarulhos', 'guassusse', 'guatapara', 'guaxupe', 'guia lopes da laguna', 'guidoval', 'guimaraes', 'guimarania', 'guinda', 'guiricema', 'gurupi', 'guzolandia', 'heliopolis', 'herculandia', 'herval', \"herval d'oeste\", 'herveiras', 'hidreletrica tucurui', 'hidrolandia', 'hidrolina', 'holambra', 'holambra ii', 'horizonte', 'horizontina', 'hortolandia', 'hulha negra', 'humaita', 'humberto de campos', 'humildes', 'iacanga', 'iaciara', 'iacri', 'iacu', 'iapu', 'iaras', 'iati', 'ibaiti', 'ibarama', 'ibate', 'ibateguara', 'ibatiba', 'ibema', 'ibertioga', 'ibia', 'ibiaca', 'ibiai', 'ibiajara', 'ibiam', 'ibiapina', 'ibiara', 'ibiassuce', 'ibicarai', 'ibicare', 'ibicoara', 'ibicuitinga', 'ibimirim', 'ibipeba', 'ibipitanga', 'ibipora', 'ibira', 'ibiracatu', 'ibiraci', 'ibiracu', 'ibiraiaras', 'ibiraja', 'ibirama', 'ibirapua', 'ibirarema', 'ibirataia', 'ibirite', 'ibiruba', 'ibitiara', 'ibitinga', 'ibitioca', 'ibitira', 'ibitita', 'ibitiuva', 'ibiuna', 'ibotirama', 'icapui', 'icara', 'icarai de minas', 'icaraima', 'icatu', 'icem', 'ichu', 'ico', 'iconha', 'ielmo marinho', 'iepe', 'igaci', 'igapora', 'igaracu do tiete', 'igarapava', 'igarape', 'igarape-acu', 'igarape-miri', 'igarassu', 'igarata', 'igaratinga', 'igrapiuna', 'igreja nova', 'igrejinha', 'iguaba grande', 'iguai', 'iguape', 'iguaracu', 'iguatama', 'iguatu', 'ijui', 'ilha comprida', 'ilha de itamaraca', 'ilha dos valadares', 'ilha grande', 'ilha solteira', 'ilhabela', 'ilheus', 'ilhota', 'ilicinea', 'ilopolis', 'imaculada', 'imbau', 'imbe', 'imbe de minas', 'imbituba', 'imbituva', 'imbuia', 'imigrante', 'imperatriz', 'inacio martins', 'inaciolandia', 'inaja', 'inconfidentes', 'indaial', 'indaiatuba', 'independencia', 'indiana', 'indianopolis', 'indiapora', 'indiara', 'indiaroba', 'inga', 'ingai', 'inhambupe', 'inhapi', 'inhapim', 'inhauma', 'inhuma', 'inhumas', 'inimutaba', 'inocencia', 'inubia paulista', 'iomere', 'ipaba', 'ipameri', 'ipanema', 'ipaporanga', 'ipatinga', 'ipaumirim', 'ipaussu', 'ipe', 'ipecaeta', 'ipero', 'ipiabas', 'ipiacu', 'ipiau', 'ipigua', 'ipira', 'ipiranga', 'ipiranga de goias', 'ipiranga do norte', 'ipiranga do sul', 'ipixuna do para', 'ipojuca', 'ipora', 'ipora do oeste', 'ipu', 'ipua', 'ipubi', 'ipueira', 'ipueiras', 'ipuiuna', 'ipumirim', 'ipupiara', 'iracema', 'iracemapolis', 'irai', 'irai de minas', 'iramaia', 'irani', 'irape', 'irapua', 'irapuru', 'iraquara', 'irara', 'irati', 'iraucuba', 'irece', 'iretama', 'irineopolis', 'irupi', 'isaias coelho', 'ita', 'itaara', 'itabaiana', 'itabaianinha', 'itabatan', 'itabela', 'itabera', 'itaberaba', 'itaberai', 'itabi', 'itabira', 'itabirinha', 'itabirito', 'itaborai', 'itabuna', 'itacarambi', 'itacare', 'itacoatiara', 'itacurussa', 'itagi', 'itagiba', 'itagimirim', 'itaguacu', 'itaguacu da bahia', 'itaguai', 'itaguaje', 'itaguara', 'itaguari', 'itaguaru', 'itai', 'itaicaba', 'itaiopolis', 'itaipava', 'itaipulandia', 'itaitinga', 'itaituba', 'itaja', 'itajai', 'itajobi', 'itaju', 'itaju do colonia', 'itajuba', 'itajuipe', 'italva', 'itamaraju', 'itamarandiba', 'itamari', 'itambacuri', 'itambaraca', 'itambe', 'itamira', 'itamogi', 'itamonte', 'itanhaem', 'itanhandu', 'itanhanga', 'itanhem', 'itanhomi', 'itaobim', 'itaoca', 'itaocara', 'itapaci', 'itapage', 'itapagipe', 'itapaje', 'itaparica', 'itape', 'itapecerica', 'itapecerica da serra', 'itapecuru mirim', \"itapejara d'oeste\", 'itapema', 'itapemirim', 'itaperucu', 'itaperuna', 'itapetim', 'itapetinga', 'itapetininga', 'itapeva', 'itapevi', 'itapicuru', 'itapipoca', 'itapira', 'itapiranga', 'itapirapua', 'itapirapua paulista', 'itapissuma', 'itapitanga', 'itapiuna', 'itapoa', 'itapolis', 'itapora', 'itaporanga', \"itaporanga d'ajuda\", 'itapui', 'itapura', 'itapuranga', 'itaquaquecetuba', 'itaqui', 'itaquirai', 'itaquitinga', 'itarana', 'itarantim', 'itarare', 'itarema', 'itariri', 'itatiaia', 'itatiaiucu', 'itatiba', 'itatiba do sul', 'itatim', 'itatinga', 'itau', 'itau de minas', 'itauba', 'itaueira', 'itauna', 'itinga', 'itiquira', 'itirapina', 'itirucu', 'itiuba', 'itobi', 'itororo', 'itu', 'ituacu', 'itubera', 'itueta', 'ituiutaba', 'itumbiara', 'itupeva', 'itupiranga', 'ituporanga', 'iturama', 'itutinga', 'ituverava', 'iuna', 'ivai', 'ivaipora', 'ivate', 'ivinhema', 'ivora', 'ivoti', 'jaboatao dos guararapes', 'jabora', 'jaborandi', 'jaboti', 'jaboticabal', 'jaboticatubas', 'jacaraci', 'jacare', 'jacareacanga', 'jacarei', 'jacarezinho', 'jaci', 'jaciara', 'jacigua', 'jacinto', 'jacinto machado', 'jacobina', 'jacui', 'jacuipe', 'jacuizinho', 'jacunda', 'jacupiranga', 'jacutinga', 'jaguapita', 'jaguaquara', 'jaguarao', 'jaguare', 'jaguarembe', 'jaguari', 'jaguariaiva', 'jaguaribara', 'jaguaribe', 'jaguariuna', 'jaguaruana', 'jaguaruna', 'jaiba', 'jales', 'jamaica', 'jamapara', 'jambeiro', 'jampruca', 'janauba', 'jandaia', 'jandaia do sul', 'jandaira', 'jandira', 'janduis', 'janiopolis', 'januaria', 'japaraiba', 'japaratuba', 'japeri', 'japi', 'japira', 'japoata', 'japuiba', 'japura', 'jaqueira', 'jaquirana', 'jaragua', 'jaragua do sul', 'jaraguari', 'jardim', 'jardim abc de goias', 'jardim alegre', 'jardim de piranhas', 'jardim do serido', 'jardim olinda', 'jardinopolis', 'jari', 'jarinu', 'jaru', 'jatai', 'jatauba', 'jatoba', 'jau', 'jaua', 'jaupaci', 'jauru', 'jeceaba', 'jenipapo de minas', 'jequeri', 'jequia da praia', 'jequie', 'jequitai', 'jequitiba', 'jequitinhonha', 'jeremoabo', 'jerico', 'jeriquara', 'jeronimo monteiro', 'jesuania', 'jesuitas', 'jesupolis', 'ji-parana', 'jijoca de jericoacoara', 'jiquirica', 'joacaba', 'joaima', 'joanopolis', 'joao alfredo', 'joao camara', 'joao dourado', 'joao lisboa', 'joao monlevade', 'joao neiva', 'joao pessoa', 'joao pinheiro', 'joao ramalho', 'joaquim nabuco', 'joaquim pires', 'joaquim tavora', 'joinville', 'jordania', 'jose boiteux', 'jose bonifacio', 'jose da penha', 'jose de freitas', 'joselandia', 'joviania', 'juara', 'juatuba', 'juazeiro', 'juazeiro do norte', 'jucas', 'jucurucu', 'jucurutu', 'juina', 'juiz de fora', 'julio de castilhos', 'julio mesquita', 'jumirim', 'junco do serido', 'jundiai', 'jundiai do sul', 'junqueiro', 'junqueiropolis', 'jupi', 'juquia', 'juquitiba', 'juranda', 'jurema', 'juripiranga', 'juru', 'juruaia', 'juruena', 'juruti', 'juscimeira', 'jussara', 'jussari', 'jussiape', 'juti', 'juvenilia', 'kalore', 'ladainha', 'ladario', 'lagarto', 'lages', 'lago da pedra', 'lago verde', 'lagoa', \"lagoa d'anta\", 'lagoa da canoa', 'lagoa da confusao', 'lagoa da prata', 'lagoa de sao francisco', 'lagoa de velhos', 'lagoa do carro', 'lagoa do mato', 'lagoa do ouro', 'lagoa do piaui', 'lagoa dos gatos', 'lagoa dos patos', 'lagoa dos tres cantos', 'lagoa dourada', 'lagoa formosa', 'lagoa grande', 'lagoa nova', 'lagoa real', 'lagoa salgada', 'lagoa santa', 'lagoa vermelha', 'lagoao', 'lagoinha', 'laguna', 'laje do muriae', 'lajeado', 'lajeado grande', 'lajedo', 'lajinha', 'lamarao', 'lambari', 'lamim', 'lapa', 'laranja da terra', 'laranjal', 'laranjal do jari', 'laranjal paulista', 'laranjeiras do sul', 'laurentino', 'lauro de freitas', 'lauro muller', 'lavinia', 'lavras', 'lavras da mangabeira', 'lavras do sul', 'lavrinhas', 'leandro ferreira', 'lebon regis', 'leme', 'lencois', 'lencois paulista', 'leoberto leal', 'leopoldina', 'leopoldo de bulhoes', 'leopolis', 'liberato salzano', 'liberdade', 'lima duarte', 'limeira', 'limeira do oeste', 'limoeiro', 'limoeiro do norte', 'lindoeste', 'lindoia', 'lindoia do sul', 'lindolfo collor', 'linhares', 'lins', 'livramento', 'livramento de nossa senhora', 'loanda', 'lobato', 'londrina', 'lontras', 'lorena', 'loreto', 'lourdes', 'louveira', 'lucas do rio verde', 'lucelia', 'lucena', 'lucianopolis', 'luis antonio', 'luis correia', 'luis eduardo magalhaes', 'luisburgo', 'luiz alves', 'luiziana', 'luiziania', 'luizlandia do oeste', 'luminarias', 'lunardelli', 'lupercio', 'lupionopolis', 'lutecia', 'luz', 'luziania', 'luziapolis', 'luzilandia', 'macae', 'macaiba', 'macambara', 'macambira', 'macapa', 'macaparana', 'macatuba', 'macau', 'macaubal', 'macaubas', 'macedonia', 'maceio', 'machacalis', 'machadinho', \"machadinho d'oeste\", 'machado', 'machados', 'macieira', 'macuco', 'macuco de minas', 'madalena', 'madre de deus', 'madre de deus de minas', \"mae d'agua\", 'mae do rio', 'mafra', 'magalhaes de almeida', 'magda', 'mage', 'maioba', 'maiquinique', 'mairi', 'mairinque', 'mairipora', 'major porto', 'major vieira', 'malacacheta', 'malhador', 'mallet', 'mamanguape', 'mambai', 'mambore', 'mamonas', 'mampituba', 'manaira', 'manaus', 'mandaguacu', 'mandaguari', 'mandirituba', 'manduri', 'manfrinopolis', 'manga', 'mangaratiba', 'mangueirinha', 'manhuacu', 'manhumirim', 'manoel ribas', 'manoel urbano', 'manoel viana', 'mansidao', 'mantena', 'mantenopolis', 'maquine', 'mar de espanha', 'mar vermelho', 'mara rosa', 'maraba', 'maracacume', 'maracai', 'maracaju', 'maracana', 'maracanau', 'maracas', 'maragogi', 'maragogipe', 'maranguape', 'maranhaozinho', 'marataizes', 'marau', 'maravilha', 'maravilhas', 'marcelino vieira', 'marco', 'marcos parente', 'marechal candido rondon', 'marechal deodoro', 'marechal floriano', 'mari', 'maria da fe', 'marialva', 'mariana', 'mariano moro', 'mariapolis', 'maribondo', 'marica', 'mariental', 'marilac', 'marilandia', 'marilandia do sul', 'marilena', 'marilia', 'mariluz', 'maringa', 'marinopolis', 'mario campos', 'mariopolis', 'maripa', 'maristela', 'marituba', 'marmeleiro', 'marques de souza', 'martinesia', 'martinho campos', 'martinopolis', 'martins', 'martins soares', 'mascote', 'massape', 'massaranduba', 'mata', 'mata de sao joao', 'mata grande', 'mata roma', 'mata verde', 'matao', 'matelandia', 'materlandia', 'mateus leme', 'matias barbosa', 'matias olimpio', 'matinhos', 'matipo', 'mato leitao', 'mato rico', 'mato verde', 'matoes', 'matoes do norte', 'matozinhos', 'matrincha', 'matriz de camaragibe', 'matupa', 'matutina', 'maua', 'maua da serra', 'maurilandia', 'mauriti', 'maximiliano de almeida', 'medeiros', 'medeiros neto', 'medianeira', 'medicilandia', 'medina', 'meleiro', 'mendes', 'mendes pimentel', 'mendonca', 'mercedes', 'merces', 'meridiano', 'meruoca', 'mesquita', 'messias targino', 'miguel calmon', 'miguel pereira', 'miguelopolis', 'milagres', 'milha', 'mimoso de goias', 'mimoso do sul', 'minacu', 'minas do leao', 'minas novas', 'minduri', 'mineiros', 'mineiros do tiete', 'ministro andreazza', 'mira estrela', 'miracatu', 'miracema', 'miradouro', 'miraguai', 'mirai', 'miraima', 'miranda', 'miranda do norte', 'mirandiba', 'mirandopolis', 'miranorte', 'mirante da serra', 'mirante do paranapanema', 'mirassol', \"mirassol d'oeste\", 'miravania', 'mirinzal', 'missal', 'missao velha', 'missi', 'mocajuba', 'mococa', 'moeda', 'moema', 'mogi das cruzes', 'mogi mirim', 'mogi-guacu', 'mogi-mirim', 'moju', 'mojui dos campos', 'mombaca', 'mombuca', 'moncao', 'moncoes', 'mondai', 'mongagua', 'monnerat', 'monsenhor paulo', 'monsenhor tabosa', 'montadas', 'montalvania', 'montanha', 'montanhas', 'montauri', 'monte alegre', 'monte alegre de minas', 'monte alegre de sergipe', 'monte alegre do sul', 'monte alto', 'monte alverne', 'monte aprazivel', 'monte azul', 'monte azul paulista', 'monte belo', 'monte belo do sul', 'monte bonito', 'monte carlo', 'monte carmelo', 'monte castelo', 'monte formoso', 'monte gordo', 'monte mor', 'monte santo', 'monte santo de minas', 'monte siao', 'monte verde', 'monteiropolis', 'montenegro', 'montes claros', 'montezuma', 'montividiu do norte', 'morada nova', 'morada nova de minas', 'moreilandia', 'moreira sales', 'moreno', 'morpara', 'morretes', 'morrinhos', 'morro agudo', 'morro agudo de goias', 'morro da fumaca', 'morro da garca', 'morro de sao paulo', 'morro do chapeu', 'morro do ferro', 'morro do pilar', 'morro grande', 'morro redondo', 'morro reuter', 'morro vermelho', 'morungaba', 'mossamedes', 'mossoro', 'mostardas', 'motuca', 'mozarlandia', 'mucambo', 'mucuge', 'mucuri', 'mucurici', 'mundo novo', 'munhoz', 'munhoz de melo', 'muniz freire', 'muquem do sao francisco', 'muqui', 'muriae', 'murici', 'muritiba', 'murucupi', 'murutinga do sul', 'mussurepe', 'mutuipe', 'mutum', 'mutum parana', 'mutunopolis', 'muzambinho', 'nacip raydan', 'nantes', 'nanuque', 'nao-me-toque', 'narandiba', 'natal', 'natercia', 'natividade', 'natividade da serra', 'navegantes', 'navirai', 'nazare', 'nazare da mata', 'nazare paulista', 'nazareno', 'nazario', 'neopolis', 'nepomuceno', 'neropolis', 'neves paulista', 'nhandeara', 'nilopolis', 'nipoa', 'niquelandia', 'niteroi', 'nobres', 'nonoai', 'nortelandia', 'nossa senhora da gloria', 'nossa senhora das dores', 'nossa senhora das gracas', 'nossa senhora de caravaggio', 'nossa senhora de lourdes', 'nossa senhora do o', 'nossa senhora do remedio', 'nossa senhora do socorro', 'nova alvorada', 'nova alvorada do sul', 'nova america', 'nova america da colina', 'nova andradina', 'nova araca', 'nova aurora', 'nova bandeirantes', 'nova bassano', 'nova boa vista', \"nova brasilandia d'oeste\", 'nova brescia', 'nova campina', 'nova canaa', 'nova canaa do norte', 'nova canaa paulista', 'nova cantu', 'nova crixas', 'nova cruz', 'nova era', 'nova erechim', 'nova esperanca', 'nova esperanca do piria', 'nova esperanca do sudoeste', 'nova esperanca do sul', 'nova europa', 'nova fatima', 'nova floresta', 'nova friburgo', 'nova granada', 'nova guarita', 'nova guataporanga', 'nova hartz', 'nova iguacu', 'nova independencia', 'nova ipixuna', 'nova itaberaba', 'nova lacerda', 'nova laranjeiras', 'nova lima', 'nova londrina', 'nova luzitania', 'nova mamore', 'nova monte verde', 'nova mutum', 'nova odessa', 'nova olimpia', 'nova olinda', 'nova olinda do maranhao', 'nova padua', 'nova palma', 'nova petropolis', 'nova ponte', 'nova prata', 'nova prata do iguacu', 'nova redencao', 'nova resende', 'nova roma', 'nova roma do sul', 'nova russas', 'nova santa barbara', 'nova santa rita', 'nova santa rosa', 'nova serrana', 'nova soure', 'nova timboteua', 'nova trento', 'nova ubirata', 'nova venecia', 'nova veneza', 'nova vicosa', 'nova xavantina', 'novais', 'novo barreiro', 'novo brasil', 'novo cabrais', 'novo cruzeiro', 'novo gama', 'novo hamburgo', 'novo horizonte', 'novo itacolomi', 'novo jardim', 'novo lino', 'novo machado', 'novo mundo', 'novo oriente', 'novo oriente de minas', 'novo oriente do piaui', 'novo planalto', 'novo progresso', 'novo repartimento', 'novo sao joaquim', 'nucleo residencial pilar', 'nuporanga', 'ocara', 'ocaucu', 'oeiras', 'oeiras do para', 'oiapoque', 'olaria', 'oleo', \"olho d'agua das cunhas\", \"olho d'agua das flores\", \"olhos d'agua\", 'olimpia', 'olinda', 'olindina', 'oliveira', 'oliveira dos brejinhos', 'onda verde', 'oriente', 'orindiuva', 'orizania', 'orizona', 'orlandia', 'orleans', 'orobo', 'oroco', 'oros', 'ortigueira', 'osasco', 'oscar bressane', 'osorio', 'osvaldo cruz', 'osvaldo kroeff', 'otacilio costa', 'ourem', 'ouricuri', 'ourilandia do norte', 'ourinhos', 'ourizona', 'ouro', 'ouro branco', 'ouro fino', 'ouro preto', 'ouro preto do oeste', 'ouro verde', 'ouro verde de goias', 'ouro verde de minas', 'ouro verde do oeste', 'ouroeste', 'ouvidor', 'pacaembu', 'pacaja', 'pacajus', 'pacatuba', 'paco do lumiar', 'pacoti', 'pacotuba', 'pacuja', 'padre bernardo', 'padre carvalho', 'padre gonzales', 'padre paraiso', 'paial', 'paicandu', 'paineiras', 'pains', 'paiva', 'palestina', 'palhano', 'palhoca', 'palma', 'palma sola', 'palmares', 'palmares do sul', 'palmares paulista', 'palmas', 'palmeira', 'palmeira d oeste', \"palmeira d'oeste\", 'palmeira das missoes', 'palmeira dos indios', 'palmeiras', 'palmeiras de goias', 'palmeirinha', 'palminopolis', 'palmital', 'palmitinho', 'palmitos', 'palmopolis', 'palotina', 'panambi', 'pancas', 'panelas', 'panorama', 'pantano grande', 'papagaios', 'papanduva', 'papucaia', 'para de minas', 'paracambi', 'paracatu', 'paracuru', 'paragominas', 'paraguacu', 'paraguacu paulista', 'parai', 'paraiba do sul', 'paraibano', 'paraibuna', 'paraipaba', 'paraiso', 'paraiso das aguas', 'paraiso do norte', 'paraiso do sul', 'paraiso do tocantins', 'paraisopolis', 'paraju', 'parambu', 'paramirim', 'parana', 'paranacity', 'paranagua', 'paranaiba', 'paranaiguara', 'paranaita', 'paranapanema', 'paranapoema', 'paranapua', 'paranatinga', 'paranavai', 'paranhos', 'paraopeba', 'parapua', 'parati', 'paraty', 'parauapebas', 'parauna', 'pardinho', 'pareci novo', 'parelhas', 'paripiranga', 'paripueira', 'pariquera-acu', 'parisi', 'parnaiba', 'parnamirim', 'parnarama', 'parobe', 'passa quatro', 'passa tempo', 'passa tres', 'passagem', 'passagem franca', 'passira', 'passo de camaragibe', 'passo de torres', 'passo fundo', 'passos', 'passos maia', 'pastos bons', 'patis', 'pato bragado', 'pato branco', 'patos', 'patos de minas', 'patrocinio', 'patrocinio do muriae', 'patrocinio paulista', 'patu', 'paty do alferes', 'pau brasil', \"pau d'arco\", 'pau dos ferros', 'paudalho', 'paula candido', 'paula freitas', 'pauliceia', 'paulinia', 'paulino neves', 'paulista', 'paulistana', 'paulistania', 'paulo afonso', 'paulo de faria', 'paulo frontin', 'paulo jacinto', 'paulo lopes', 'pavao', 'peabiru', 'pecanha', 'pederneiras', 'pedra', 'pedra azul', 'pedra bela', 'pedra branca', 'pedra do indaia', 'pedra lavrada', 'pedra menina', 'pedra preta', 'pedralva', 'pedranopolis', 'pedrao', 'pedras altas', 'pedras de fogo', 'pedregulho', 'pedreira', 'pedreiras', 'pedrinhas paulista', 'pedrinopolis', 'pedro afonso', 'pedro canario', 'pedro de toledo', 'pedro gomes', 'pedro ii', 'pedro leopoldo', 'pedro osorio', 'pedro velho', 'peixe', 'peixoto de azevedo', 'pejucara', 'pelotas', 'penaforte', 'penapolis', 'pendencias', 'penedo', 'penha', 'pentecoste', 'pequi', 'pequizeiro', 'perdigao', 'perdizes', 'perdoes', 'pereira barreto', 'pereiras', 'pereiro', 'periquito', 'peritiba', 'perobal', 'perola', \"perola d'oeste\", 'perola independente', 'perpetuo socorro', 'peruibe', 'pescador', 'pesqueira', 'petrolandia', 'petrolina', 'petropolis', 'piacabucu', 'piacatu', 'piacu', 'pianco', 'piao', 'piata', 'piau', 'picada cafe', 'picarra', 'picarras', 'picos', 'picui', 'piedade', 'piedade de caratinga', 'piedade do rio grande', 'piedade dos gerais', 'pien', 'pilao arcado', 'pilar', 'pilar do sul', 'pimenta', 'pimenta bueno', 'pimenteiras', 'pindai', 'pindamonhangaba', 'pindare mirim', 'pindoba', 'pindobacu', 'pindorama', 'pindorama do tocantins', 'pindoretama', 'pinhais', 'pinhal da serra', 'pinhalao', 'pinhalzinho', 'pinhao', 'pinheiral', 'pinheiro', 'pinheiro machado', 'pinheiros', 'pinhotiba', 'pintadas', 'pinto bandeira', 'pio ix', 'pio xii', 'piquerobi', 'piquete', 'piracaia', 'piracanjuba', 'piracema', 'piracicaba', 'piracuruca', 'pirai', 'pirai do norte', 'pirai do sul', 'piraju', 'pirajuba', 'pirajui', 'pirambu', 'piranga', 'pirangi', 'piranguinho', 'piranhas', 'pirapetinga', 'pirapo', 'pirapora', 'pirapora do bom jesus', 'pirapozinho', 'piraquara', 'pirassununga', 'piratini', 'piratininga', 'piratuba', 'pirauba', 'pirenopolis', 'pires do rio', 'pires ferreira', 'piripa', 'piripiri', 'piritiba', 'pirpirituba', 'pitanga', 'pitanga de estrada', 'pitangueiras', 'pitangui', 'pitimbu', 'pium', 'piuma', 'piumhi', 'piumhii', 'placas', 'planaltina', 'planaltina de goias', 'planaltina do parana', 'planaltino', 'planalto', 'planura', 'poa', 'pocao', 'pocao de pedras', 'pocinhos', 'poco de pedra', 'poco fundo', 'poco redondo', 'poco verde', 'pocoes', 'pocoes de paineiras', 'pocos de caldas', 'pocrane', 'pojuca', 'polo petroquimico de triunfo', 'poloni', 'pombal', 'pombos', 'pomerode', 'pompeia', 'pompeu', 'pongai', 'ponta grossa', 'ponta pora', 'pontal', 'pontal do parana', 'pontalina', 'pontalinda', 'pontao', 'ponte alta do norte', 'ponte nova', 'ponte serrada', 'pontes e lacerda', 'pontes gestal', 'ponto belo', 'ponto do marambaia', 'ponto dos volantes', 'ponto novo', 'populina', 'porangaba', 'porangatu', 'porciuncula', 'porecatu', 'portalegre', 'portao', 'porteiras', 'porteirinha', 'portela', 'portelandia', 'porto acre', 'porto alegre', 'porto alegre do norte', 'porto amazonas', 'porto belo', 'porto calvo', 'porto de pedras', 'porto dos gauchos', 'porto esperidiao', 'porto estrela', 'porto feliz', 'porto ferreira', 'porto firme', 'porto franco', 'porto grande', 'porto lucena', 'porto murtinho', 'porto nacional', 'porto real', 'porto rico', 'porto seguro', 'porto trombetas', 'porto uniao', 'porto velho', 'porto xavier', 'posse', 'posto da mata', 'pote', 'potengi', 'potim', 'potiragua', 'potirendaba', 'pouso alegre', 'pouso alto', 'pouso novo', 'pouso redondo', 'poxoreu', 'prado', 'pradopolis', 'prados', 'praia grande', 'praia norte', 'pranchita', 'prata', 'pratapolis', 'presidente alves', 'presidente bernardes', 'presidente castello branco', 'presidente dutra', 'presidente epitacio', 'presidente getulio', 'presidente janio quadros', 'presidente juscelino', 'presidente kennedy', 'presidente kubitschek', 'presidente lucena', 'presidente medici', 'presidente nereu', 'presidente olegario', 'presidente prudente', 'presidente tancredo neves', 'presidente venceslau', 'primavera', 'primavera do leste', 'primeiro de maio', 'princesa isabel', 'progresso', 'promissao', 'propria', 'protasio alves', 'prudencio thomaz', 'prudente de morais', 'prudentopolis', 'pugmil', 'pureza', 'purilandia', 'putinga', 'puxinana', 'quadra', 'quarai', 'quata', 'quatigua', 'quatis', 'quatituba', 'quatro barras', 'quatro bocas', 'quatro pontes', 'quedas do iguacu', 'queimadas', 'queimados', 'queiroz', 'queixada', 'queluz', 'querencia', 'querencia do norte', 'quevedos', 'quijingue', 'quilombo', 'quilometro 14 do mutum', 'quinta do sol', 'quintana', 'quipapa', 'quirinopolis', 'quissama', 'quitandinha', 'quixabeira', 'quixada', 'quixelo', 'quixeramobim', 'quixere', 'rafard', 'rainha do mar', 'rancharia', 'rancho alegre', \"rancho alegre d'oeste\", 'rancho queimado', 'raposo', 'raposos', 'raul soares', 'ravena', 'realeza', 'reboucas', 'rechan', 'recife', 'recreio', 'redencao', 'redencao da serra', 'redencao do gurgueia', 'redentora', 'regeneracao', 'regente feijo', 'reginopolis', 'registro', 'remanso', 'remigio', 'renascenca', 'reriutaba', 'resende', 'resende costa', 'reserva', 'reserva do cabacal', 'reserva do iguacu', 'resplendor', 'ressaquinha', 'restinga seca', 'retirolandia', 'riachao das neves', 'riachao do jacuipe', 'riachinho', 'riacho da cruz', 'riacho das almas', 'riacho de santana', 'riacho de santo antonio', 'riacho dos machados', 'riachuelo', 'rianapolis', 'ribas do rio pardo', 'ribeira', 'ribeira do amparo', 'ribeira do pombal', 'ribeirao', 'ribeirao bonito', 'ribeirao branco', 'ribeirao cascalheira', 'ribeirao claro', 'ribeirao das neves', 'ribeirao do pinhal', 'ribeirao do sul', 'ribeirao pires', 'ribeirao preto', 'ribeirao vermelho', 'ribeiraozinho', 'ribeiro junqueira', 'ribeiropolis', 'rifaina', 'rincao', 'rinopolis', 'rio acima', 'rio azul', 'rio bananal', 'rio bonito', 'rio bonito do iguacu', 'rio branco', 'rio branco do sul', 'rio brilhante', 'rio casca', 'rio claro', 'rio das antas', 'rio das flores', 'rio das ostras', 'rio das pedras', 'rio de contas', 'rio de janeiro', 'rio do antonio', 'rio do campo', 'rio do oeste', 'rio do pires', 'rio do sul', 'rio doce', 'rio dos cedros', 'rio dos indios', 'rio espera', 'rio formoso', 'rio fortuna', 'rio grande', 'rio grande da serra', 'rio grande do piaui', 'rio largo', 'rio manso', 'rio maria', 'rio negrinho', 'rio negro', 'rio novo', 'rio novo do sul', 'rio paranaiba', 'rio pardo', 'rio pardo de minas', 'rio piracicaba', 'rio pomba', 'rio preto', 'rio real', 'rio rufino', 'rio tinto', 'rio verde', 'riolandia', 'riqueza', 'ritapolis', 'riversul', 'roca sales', 'rodeio', 'rodeio bonito', 'rodeiro', 'rodelas', 'rodolfo fernandes', 'rolandia', 'rolante', 'rolim de moura', 'romaria', 'romelandia', 'roncador', 'ronda alta', 'rondon', 'rondon do para', 'rondonopolis', 'roque gonzales', 'rosana', 'rosario', 'rosario do ivai', 'rosario do sul', 'roseira', 'rubelita', 'rubiacea', 'rubiataba', 'rubim', 'rubineia', 'russas', 'ruy barbosa', 'sabara', 'sabaudia', 'sabino', 'sabinopolis', 'saboeiro', 'sacra familia do tingua', 'sacramento', 'sales', 'sales oliveira', 'salesopolis', 'salgado filho', 'salgueiro', 'salinas', 'salinas da margarida', 'salmourao', 'saloa', 'salobro', 'saltinho', 'salto', 'salto da divisa', 'salto de pirapora', 'salto do ceu', 'salto do itarare', 'salto do jacui', 'salto do lontra', 'salto grande', 'salto veloso', 'salvador', 'salvador do sul', 'sambaiba', 'sananduva', 'sanclerlandia', 'sandolandia', 'sanga puita', 'sangao', 'sanharo', 'santa adelia', 'santa albertina', 'santa amelia', 'santa barbara', 'santa barbara d oeste', \"santa barbara d'oeste\", 'santa barbara do para', 'santa barbara do sul', 'santa branca', 'santa brigida', 'santa cecilia', 'santa cecilia do pavao', \"santa clara d'oeste\", 'santa clara do sul', 'santa cruz', 'santa cruz cabralia', 'santa cruz da conceicao', 'santa cruz das palmeiras', 'santa cruz de goias', 'santa cruz de minas', 'santa cruz de monte castelo', 'santa cruz de salinas', 'santa cruz do capibaribe', 'santa cruz do piaui', 'santa cruz do prata', 'santa cruz do rio pardo', 'santa cruz do sul', 'santa cruz do timbo', 'santa ernestina', 'santa fe', 'santa fe de goias', 'santa fe de minas', 'santa fe do sul', 'santa filomena', 'santa gertrudes', 'santa helena', 'santa helena de goias', 'santa helena de minas', 'santa ines', 'santa isabel', 'santa isabel do ivai', 'santa isabel do para', 'santa isabel do rio preto', 'santa izabel do oeste', 'santa juliana', 'santa leopoldina', 'santa lucia', 'santa luzia', 'santa luzia do norte', 'santa luzia do parua', 'santa margarida', 'santa maria', 'santa maria da boa vista', 'santa maria da serra', 'santa maria da vitoria', 'santa maria de itabira', 'santa maria de jetiba', 'santa maria do herval', 'santa maria do para', 'santa maria do salto', 'santa maria do suacui', 'santa maria madalena', 'santa mariana', 'santa mercedes', 'santa monica', 'santa quiteria', 'santa quiteria do maranhao', 'santa rita', \"santa rita d'oeste\", 'santa rita da floresta', 'santa rita de caldas', 'santa rita de jacutinga', 'santa rita de minas', 'santa rita do araguaia', 'santa rita do ibitipoca', 'santa rita do itueto', 'santa rita do passa quatro', 'santa rita do sapucai', 'santa rosa', 'santa rosa de lima', 'santa rosa de viterbo', 'santa rosa do sul', 'santa salete', 'santa teresa', 'santa teresinha', 'santa tereza do oeste', 'santa terezinha', 'santa terezinha de itaipu', 'santa vitoria', 'santa vitoria do palmar', 'santaluz', 'santana', 'santana da boa vista', 'santana da vargem', 'santana de parnaiba', 'santana de pirapama', 'santana do acarau', 'santana do araguaia', 'santana do capivari', 'santana do cariri', 'santana do deserto', 'santana do ipanema', 'santana do itarare', 'santana do jacare', 'santana do livramento', 'santana do manhuacu', 'santana do mundau', 'santana do paraiso', 'santana do serido', 'santana do sobrado', 'santana dos montes', 'santanesia', 'santarem', 'santiago', 'santo amaro', 'santo amaro da imperatriz', 'santo amaro das brotas', 'santo amaro de campos', 'santo anastacio', 'santo andre', 'santo angelo', 'santo antonio', 'santo antonio da alegria', 'santo antonio da patrulha', 'santo antonio da platina', 'santo antonio das missoes', 'santo antonio das queimadas', 'santo antonio de goias', 'santo antonio de jesus', 'santo antonio de padua', 'santo antonio de posse', 'santo antonio do amparo', 'santo antonio do aracangua', 'santo antonio do aventureiro', 'santo antonio do caiua', 'santo antonio do canaa', 'santo antonio do descoberto', 'santo antonio do grama', 'santo antonio do itambe', 'santo antonio do jacinto', 'santo antonio do jardim', 'santo antonio do leste', 'santo antonio do leverger', 'santo antonio do monte', 'santo antonio do palma', 'santo antonio do pinhal', 'santo antonio do planalto', 'santo antonio do rio abaixo', 'santo antonio do sudoeste', 'santo antonio do taua', 'santo antonio dos campos', 'santo augusto', 'santo cristo', 'santo eduardo', 'santo estevao', 'santo expedito', 'santo expedito do sul', 'santo hipolito', 'santo inacio', 'santos', 'santos dumont', 'sao benedito', 'sao benedito do rio preto', 'sao benedito do sul', 'sao bentinho', 'sao bento', 'sao bento abade', 'sao bento do sapucai', 'sao bento do sul', 'sao bento do una', 'sao bernardino', 'sao bernardo', 'sao bernardo do campo', 'sao bonifacio', 'sao borja', 'sao bras', 'sao bras do suacui', 'sao caetano do sul', 'sao carlos', 'sao carlos do ivai', 'sao clemente', 'sao cristovao', 'sao cristovao do sul', 'sao desiderio', 'sao domingos', 'sao domingos das dores', 'sao domingos do araguaia', 'sao domingos do maranhao', 'sao domingos do norte', 'sao domingos do prata', 'sao felipe', 'sao felix', 'sao felix de minas', 'sao felix do araguaia', 'sao felix do coribe', 'sao felix do xingu', 'sao fernando', 'sao fidelis', 'sao francisco', 'sao francisco de assis', 'sao francisco de itabapoana', 'sao francisco de paula', 'sao francisco do brejao', 'sao francisco do conde', 'sao francisco do gloria', 'sao francisco do guapore', 'sao francisco do humaita', 'sao francisco do sul', 'sao gabriel', 'sao gabriel da palha', 'sao gabriel do oeste', 'sao geraldo', 'sao geraldo da piedade', 'sao geraldo do baguari', 'sao goncalo', 'sao goncalo do abaete', 'sao goncalo do amarante', 'sao goncalo do para', 'sao goncalo do rio abaixo', 'sao goncalo do rio das pedras', 'sao goncalo do rio preto', 'sao goncalo do sapucai', 'sao gotardo', 'sao jeronimo', 'sao joao', 'sao joao batista', 'sao joao batista do gloria', \"sao joao d'alianca\", 'sao joao da barra', 'sao joao da boa vista', 'sao joao da mata', 'sao joao da parauna', 'sao joao da ponte', 'sao joao da urtiga', 'sao joao das missoes', 'sao joao de iracema', 'sao joao de meriti', 'sao joao de petropolis', 'sao joao de pirabas', 'sao joao del rei', 'sao joao do itaperiu', 'sao joao do ivai', 'sao joao do manhuacu', 'sao joao do manteninha', 'sao joao do oriente', 'sao joao do paraiso', 'sao joao do piaui', 'sao joao do sabugi', 'sao joao do sobrado', 'sao joao do sul', 'sao joao do triunfo', 'sao joao dos patos', 'sao joao evangelista', 'sao joao nepomuceno', 'sao joaquim', 'sao joaquim da barra', 'sao joaquim de bicas', 'sao joaquim do monte', 'sao jorge', \"sao jorge d'oeste\", 'sao jorge do ivai', 'sao jorge do oeste', 'sao jorge do patrocinio', 'sao jose', 'sao jose da barra', 'sao jose da bela vista', 'sao jose da boa vista', 'sao jose da coroa grande', 'sao jose da laje', 'sao jose da lapa', 'sao jose da tapera', 'sao jose da vitoria', 'sao jose de mipibu', 'sao jose de ribamar', 'sao jose de uba', 'sao jose do barreiro', 'sao jose do belmonte', 'sao jose do calcado', 'sao jose do campestre', 'sao jose do cedro', 'sao jose do cerrito', 'sao jose do divino', 'sao jose do egito', 'sao jose do goiabal', 'sao jose do hortencio', 'sao jose do inhacora', 'sao jose do norte', 'sao jose do ouro', 'sao jose do piaui', 'sao jose do ribeirao', 'sao jose do rio claro', 'sao jose do rio pardo', 'sao jose do rio preto', 'sao jose do serido', 'sao jose do turvo', 'sao jose do vale do rio preto', 'sao jose do xingu', 'sao jose dos campos', 'sao jose dos cordeiros', 'sao jose dos pinhais', 'sao jose dos quatro marcos', 'sao leopoldo', 'sao lourenco', 'sao lourenco da mata', 'sao lourenco da serra', 'sao lourenco do oeste', 'sao lourenco do piaui', 'sao lourenco do sul', 'sao ludgero', 'sao luis', 'sao luis de montes belos', 'sao luis do curu', 'sao luis do paraitinga', 'sao luis do quitunde', 'sao luiz do norte', 'sao luiz gonzaga', 'sao mamede', 'sao manuel', 'sao marcos', 'sao martinho', 'sao mateus', 'sao mateus de minas', 'sao mateus do maranhao', 'sao mateus do sul', 'sao miguel', 'sao miguel arcanjo', 'sao miguel das matas', 'sao miguel do aleixo', 'sao miguel do anta', 'sao miguel do araguaia', 'sao miguel do cambui', 'sao miguel do gostoso', 'sao miguel do guama', 'sao miguel do guapore', 'sao miguel do iguacu', 'sao miguel do oeste', 'sao miguel do tapuio', 'sao miguel dos campos', 'sao patricio', 'sao paulo', 'sao paulo das missoes', 'sao paulo do potengi', 'sao pedro', 'sao pedro da agua branca', 'sao pedro da aldeia', 'sao pedro da uniao', 'sao pedro de alcantara', 'sao pedro do butia', 'sao pedro do iguacu', 'sao pedro do ivai', 'sao pedro do sul', 'sao pedro do turvo', 'sao pedro dos ferros', 'sao rafael', 'sao raimundo nonato', 'sao romao', 'sao roque', 'sao roque de minas', 'sao roque do canaa', 'sao sebastiao', 'sao sebastiao da amoreira', 'sao sebastiao da boa vista', 'sao sebastiao da grama', 'sao sebastiao da serra', 'sao sebastiao de campos', 'sao sebastiao do alto', 'sao sebastiao do cai', 'sao sebastiao do maranhao', 'sao sebastiao do paraiba', 'sao sebastiao do paraiso', 'sao sebastiao do passe', 'sao sebastiao do rio verde', 'sao sepe', 'sao simao', 'sao thome das letras', 'sao tiago', 'sao tomas de aquino', 'sao tome', 'sao valentim', 'sao vendelino', 'sao vicente', 'sao vicente ferrer', 'sao vitor', 'sape', 'sapeacu', 'sapezal', 'sapiranga', 'sapopema', 'sapucai-mirim', 'sapucaia', 'sapucaia do sul', 'saquarema', 'sarandi', 'sarapui', 'sardoa', 'sarutaia', 'sarzedo', 'satiro dias', 'satuba', 'satubinha', 'saubara', 'saudade do iguacu', 'saudades', 'saude', 'schroeder', 'seabra', 'seara', 'sebastiao leal', 'seberi', 'sede alvorada', 'segredo', 'selbach', 'senador amaral', 'senador canedo', 'senador cortes', 'senador firmino', 'senador guiomard', 'senador jose porfirio', 'senador la rocque', 'senador modestino goncalves', 'senador pompeu', 'senador salgado filho', 'senges', 'senhor do bonfim', 'senhora de oliveira', 'senhora dos remedios', 'sento se', 'serafina correa', 'sericita', 'seringueiras', 'serio', 'seropedica', 'serra', 'serra azul', 'serra azul de minas', 'serra bonita', 'serra branca', 'serra de sao bento', 'serra do ramalho', 'serra do salitre', 'serra dos aimores', 'serra dos dourados', 'serra dourada', 'serra negra', 'serra talhada', 'serrana', 'serrania', 'serranopolis', 'serranopolis de minas', 'serranopolis do iguacu', 'serrinha', 'serrita', 'serro', 'serrolandia', 'sertania', 'sertanopolis', 'sertao', 'sertao santana', 'sertaozinho', 'sete barras', 'sete de setembro', 'sete lagoas', 'setubinha', 'severiano melo', 'severinia', 'sideropolis', 'sidrolandia', 'silva jardim', 'silvania', 'silvano', 'silvanopolis', 'silveira carvalho', 'silveira martins', 'silveiras', 'silvianopolis', 'simao dias', 'simao pereira', 'simoes filho', 'simolandia', 'simonesia', 'simplicio mendes', 'sinimbu', 'sinop', 'siqueira campos', 'siriji', 'sirinhaem', 'sitio do quinto', 'sitio novo', 'sitio novo do tocantins', 'sobradinho', 'sobral', 'sobralia', 'socorro', 'solanea', 'soledade', 'soledade de minas', 'solonopole', 'sombrio', 'sonora', 'sooretama', 'sorocaba', 'sorriso', 'sousa', 'sucesso', 'sucupira do norte', 'sud mennucci', 'sulina', 'sumare', 'sume', 'sumidouro', 'surubim', 'suzanapolis', 'suzano', 'tabapora', 'tabapua', 'tabatinga', 'tabira', 'taboao da serra', 'tabocas do brejo velho', 'taboquinhas', 'tabuleiro', 'tabuleiro do norte', 'tacaratu', 'taciba', 'tacuru', 'taguai', 'taguatinga', 'taiacu', 'tailandia', 'taio', 'taiobeiras', 'taiuva', 'tamandare', 'tamarana', 'tambau', 'tamboara', 'tanabi', 'tangara', 'tangara da serra', 'tangua', 'tanhacu', \"tanque d'arca\", 'tanque novo', 'taparuba', 'tapejara', 'tapera', 'taperuaba', 'tapes', 'tapinas', 'tapirai', 'tapiramuta', 'tapiratiba', 'tapurah', 'taquara', 'taquaracu de minas', 'taquarana', 'taquari', 'taquaritinga', 'taquaritinga do norte', 'taquarituba', 'taquarivai', 'taquarucu do sul', 'tarabai', 'taruma', 'tarumirim', 'tatui', 'taua', 'taubate', 'tavares', 'tecainda', 'teixeira', 'teixeira de freitas', 'teixeira soares', 'teixeiras', 'tejupa', 'telemaco borba', 'telha', 'tenente ananias', 'tenente portela', 'teodoro sampaio', 'teofilandia', 'teofilo otoni', 'teolandia', 'teotonio vilela', 'terenos', 'teresina', 'teresina de goias', 'teresopolis', 'terezinha', 'termas de ibira', 'terra boa', 'terra de areia', 'terra nova', 'terra nova do norte', 'terra rica', 'terra roxa', 'teutonia', 'tiangua', 'tibagi', 'tibau do sul', 'tiete', 'tijucas', 'timbauba', 'timbe do sul', 'timbo', 'timburi', 'timon', 'timoteo', 'tiradentes', 'tiradentes do sul', 'tiros', 'tobias barreto', 'tocantinopolis', 'tocantins', 'tocos', 'tocos do moji', 'toledo', 'tomar do geru', 'tomazina', 'tombos', 'tome-acu', 'toritama', 'toropi', 'torres', 'torrinha', 'trabiju', 'tracuateua', 'tracunhaem', 'traipu', 'trairi', 'trajano de moraes', 'tramandai', 'trancoso', 'travessao', 'travesseiro', 'tremembe', 'tres arroios', 'tres barras', 'tres cachoeiras', 'tres coracoes', 'tres coroas', 'tres de maio', 'tres forquilhas', 'tres fronteiras', 'tres irmaos', 'tres lagoas', 'tres marias', 'tres passos', 'tres pontas', 'tres rios', 'treviso', 'treze tilias', 'trindade', 'trindade do sul', 'triunfo', 'trombas', 'trombudo central', 'tubarao', 'tucano', 'tucuma', 'tucunduva', 'tucurui', 'tuiuti', 'tumiritinga', 'tunapolis', 'tunas do parana', 'tupa', 'tupaciguara', 'tupancireta', 'tupandi', 'tuparece', 'tuparendi', 'tuparetama', 'tupassi', 'tupi paulista', 'turmalina', 'tururu', 'turvania', 'turvo', 'turvolandia', 'tutoia', 'uaua', 'uba', 'ubai', 'ubaira', 'ubaitaba', 'ubajara', 'ubaporanga', 'ubata', 'ubatuba', 'uberaba', 'uberlandia', 'ubirajara', 'ubirata', 'uchoa', 'uibai', 'uirauna', 'ulianopolis', 'umbauba', 'umburanas', 'umburatiba', 'umuarama', 'una', 'unai', 'uniao', 'uniao da serra', 'uniao da vitoria', 'uniao de minas', 'uniao do oeste', 'uniao do sul', 'unistalda', 'upanema', 'urai', 'urandi', 'urania', 'urbano santos', 'uruacu', 'uruana', 'uruana de minas', 'uruara', 'urubici', 'uruburetama', 'urucania', 'urucuca', 'urucui', 'urucuia', 'urucurituba', 'uruguaiana', 'uruoca', 'urupa', 'urupes', 'urussanga', 'urutai', 'utinga', 'vacaria', 'valao do barro', 'vale do sol', 'vale real', 'valenca', 'valenca do piaui', 'valente', 'valentim gentil', 'valinhos', 'valparaiso', 'valparaiso de goias', 'vanini', 'vargeao', 'vargem', 'vargem alegre', 'vargem alta', 'vargem bonita', 'vargem grande', 'vargem grande do rio pardo', 'vargem grande do soturno', 'vargem grande do sul', 'vargem grande paulista', 'varginha', 'varjao de minas', 'varjota', 'varre-sai', 'varzea', 'varzea alegre', 'varzea da palma', 'varzea do poco', 'varzea grande', 'varzea nova', 'varzea paulista', 'varzedo', 'varzelandia', 'vassouras', 'vazante', 'venancio aires', 'venda branca', 'venda nova do imigrante', 'ventania', 'venturosa', 'vera', 'vera cruz', 'vera cruz do oeste', 'veranopolis', 'vere', 'vereda', 'verissimo', 'vermelho', 'vermelho novo', 'vertentes', 'vespasiano', 'vespasiano correa', 'viamao', 'viana', 'vianopolis', 'vicencia', 'vicentina', 'vicentinopolis', 'vicosa', 'vicosa do ceara', 'victor graeff', 'videira', 'vieiras', 'vigia', 'vila bela da santissima trindade', 'vila dos cabanos', 'vila flor', 'vila flores', 'vila langaro', 'vila muriqui', 'vila nelita', 'vila nova', 'vila nova do sul', 'vila pereira', 'vila reis', 'vila rica', 'vila valerio', 'vila velha', 'vilhena', 'vinhedo', 'viradouro', 'virgem da lapa', 'virginia', 'virginopolis', 'virgolandia', 'visconde de maua', 'visconde do rio branco', 'viseu', 'vista alegre', 'vista alegre do alto', 'vitoria', 'vitoria da conquista', 'vitoria das missoes', 'vitoria de santo antao', 'vitoria do jari', 'vitoria do mearim', 'vitorino', 'vitorino freire', 'vitorinos', 'volta grande', 'volta redonda', 'votorantim', 'votuporanga', 'wagner', 'wanderley', 'wenceslau braz', 'wenceslau guimaraes', 'werneck', 'witmarsum', 'xambioa', 'xambre', 'xangri-la', 'xanxere', 'xapuri', 'xavantina', 'xaxim', 'xexeu', 'xinguara', 'xique-xique', 'zacarias', 'ze doca', 'zortea']\n","\n","\n","Unique Value dari customer_state\n","['AC', 'AL', 'AM', 'AP', 'BA', 'CE', 'DF', 'ES', 'GO', 'MA', 'MG', 'MS', 'MT', 'PA', 'PB', 'PE', 'PI', 'PR', 'RJ', 'RN', 'RO', 'RR', 'RS', 'SC', 'SE', 'SP', 'TO']\n","\n","\n","Unique Value dari product_category_name_english\n","['agro_industry_and_commerce', 'air_conditioning', 'art', 'arts_and_craftmanship', 'audio', 'auto', 'baby', 'bed_bath_table', 'books_general_interest', 'books_imported', 'books_technical', 'cds_dvds_musicals', 'christmas_supplies', 'cine_photo', 'computers', 'computers_accessories', 'consoles_games', 'construction_tools_construction', 'construction_tools_lights', 'construction_tools_safety', 'cool_stuff', 'costruction_tools_garden', 'costruction_tools_tools', 'diapers_and_hygiene', 'drinks', 'dvds_blu_ray', 'electronics', 'fashio_female_clothing', 'fashion_bags_accessories', 'fashion_childrens_clothes', 'fashion_male_clothing', 'fashion_shoes', 'fashion_sport', 'fashion_underwear_beach', 'fixed_telephony', 'flowers', 'food', 'food_drink', 'furniture_bedroom', 'furniture_decor', 'furniture_living_room', 'furniture_mattress_and_upholstery', 'garden_tools', 'health_beauty', 'home_appliances', 'home_appliances_2', 'home_comfort_2', 'home_confort', 'home_construction', 'housewares', 'industry_commerce_and_business', 'kitchen_dining_laundry_garden_furniture', 'la_cuisine', 'luggage_accessories', 'market_place', 'music', 'musical_instruments', 'office_furniture', 'party_supplies', 'perfumery', 'pet_shop', 'security_and_services', 'signaling_and_security', 'small_appliances', 'small_appliances_home_oven_and_coffee', 'sports_leisure', 'stationery', 'tablets_printing_image', 'telephony', 'toys', 'watches_gifts']\n","\n","\n"]}]},{"cell_type":"markdown","metadata":{"id":"9Xiquw0aY0Jr"},"source":["Bila diperhatikan, pada column \"product_category_name_english\" ada nilai yang memiliki 2 versi penamaan, seperti \"home_appliances\" dan \"home_appliances_2\", \"home_confort\" dan \"home_comfort_2\" sehingga kedua kategori tersebut akan dibuat sama."]},{"cell_type":"code","metadata":{"id":"ZA_2HvHTYz9P"},"source":["def format_val(x):\n","  if x == 'home_appliances_2':\n","    return \"home_appliances\"\n","  elif x == 'home_confort':\n","    return \"home_comfort\"\n","  elif x == \"home_comfort_2\":\n","    return \"home_comfort\"\n","  \n","  return x\n","\n","df_olist_clean['product_category_name_english'] = df_olist_clean['product_category_name_english'].apply(format_val)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"WWNgsznFaNJr","executionInfo":{"status":"ok","timestamp":1633361335927,"user_tz":-420,"elapsed":27,"user":{"displayName":"Muhammad Ariq Budipraja","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14GhRfaLZiHDMR_-dRkE9lM51oYVjEw6psZxsIYx-hQ=s64","userId":"04715157585198945865"}},"outputId":"73934092-3c3c-41a5-90d9-0cb89097bbb3"},"source":["print(\"Unique value dari product_category_name_english:\\n\")\n","print(sorted(df_olist_clean['product_category_name_english'].unique()))"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Unique value dari product_category_name_english:\n","\n","['agro_industry_and_commerce', 'air_conditioning', 'art', 'arts_and_craftmanship', 'audio', 'auto', 'baby', 'bed_bath_table', 'books_general_interest', 'books_imported', 'books_technical', 'cds_dvds_musicals', 'christmas_supplies', 'cine_photo', 'computers', 'computers_accessories', 'consoles_games', 'construction_tools_construction', 'construction_tools_lights', 'construction_tools_safety', 'cool_stuff', 'costruction_tools_garden', 'costruction_tools_tools', 'diapers_and_hygiene', 'drinks', 'dvds_blu_ray', 'electronics', 'fashio_female_clothing', 'fashion_bags_accessories', 'fashion_childrens_clothes', 'fashion_male_clothing', 'fashion_shoes', 'fashion_sport', 'fashion_underwear_beach', 'fixed_telephony', 'flowers', 'food', 'food_drink', 'furniture_bedroom', 'furniture_decor', 'furniture_living_room', 'furniture_mattress_and_upholstery', 'garden_tools', 'health_beauty', 'home_appliances', 'home_comfort', 'home_construction', 'housewares', 'industry_commerce_and_business', 'kitchen_dining_laundry_garden_furniture', 'la_cuisine', 'luggage_accessories', 'market_place', 'music', 'musical_instruments', 'office_furniture', 'party_supplies', 'perfumery', 'pet_shop', 'security_and_services', 'signaling_and_security', 'small_appliances', 'small_appliances_home_oven_and_coffee', 'sports_leisure', 'stationery', 'tablets_printing_image', 'telephony', 'toys', 'watches_gifts']\n"]}]},{"cell_type":"markdown","metadata":{"id":"maafnGcMCB6b"},"source":["# Save Data:\n","Setelah proses membersihkan data yang missing dan duplicate, kami akan menyimpan data tersebut agar dapat digunakan kembali. Pembersihan outlier akan dilakukan pada step EDA karena untuk mendeteksi outlier kami perlu melakukan explorasi datanya terlebih dahulu agar kami tidak sembarangan menghapus outlier"]},{"cell_type":"code","metadata":{"id":"to1WNm1gAGil"},"source":["df_olist_clean.to_csv('/content/drive/MyDrive/Project Purwadhika/data_outlist_clean.csv', index = False, date_format = '%Y-%m-%d')"],"execution_count":null,"outputs":[]}]}