revise_meta.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "revise_meta.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyN0Eks5phQTGaWVOrymoS+3",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/miotomita/meta/blob/main/revise_meta.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "uvZeC60RfLKy"
      },
      "source": [
        "import pandas as pd"
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4jLIhGeItwBa"
      },
      "source": [
        "countries = pd.read_csv('https://raw.githubusercontent.com/miotomita/meta/main/countries_meta.csv')"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "KQ8m3nf5wb3C"
      },
      "source": [
        "追加"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0_NzB9bi4_uN"
      },
      "source": [
        "OWID"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4RDeBMnZvILk"
      },
      "source": [
        "sub = pd.read_csv('https://raw.githubusercontent.com/owid/covid-19-data/master/scripts/input/owid/subnational_population_2020.csv')"
      ],
      "execution_count": 83,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2TjpBkw0vIPL"
      },
      "source": [
        "sub = sub.loc[~sub.iso_code.isin(countries.code_OWID)].rename(columns={'location':'name_full','iso_code':'code_OWID','population':'population_OWID','source':'population_source'})"
      ],
      "execution_count": 84,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jbIKhAZb0GdK"
      },
      "source": [
        "sub['code_3digit'] = sub.code_OWID\n",
        "sub['population_agg'] = sub.population_OWID\n",
        "sub['name_short'] = sub.name_full"
      ],
      "execution_count": 85,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NCFYQxLO0GmM"
      },
      "source": [
        "sub['source'] = 'OWID'"
      ],
      "execution_count": 86,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CYLEI4ukxtcN"
      },
      "source": [
        "sub[['sovereignty_code','sovereignty_code_NK','region','sovereignty_name_NK','region_ja','category']]= countries.loc[countries.code_3digit=='GBR',['sovereignty_code','sovereignty_code_NK','region','sovereignty_name_NK','region_ja','category']].iloc[0].to_list()"
      ],
      "execution_count": 87,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CLhoD9FI3iwj"
      },
      "source": [
        "sub['name_ja'] = sub.code_OWID.map({'OWID_ENG':'イングランド', 'OWID_SCT':'スコットランド', 'OWID_WLS':'ウェールズ', 'OWID_NIR':'北アイルランド'})"
      ],
      "execution_count": 88,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9ODWHGC54YKA"
      },
      "source": [
        "sub['notes'] = 'subnational area of GBR'"
      ],
      "execution_count": 95,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 329
        },
        "id": "c47gZg3w2cVN",
        "outputId": "9afab75c-ba88-41f8-ebf0-2a75444c5040"
      },
      "source": [
        "sub"
      ],
      "execution_count": 96,
      "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>name_full</th>\n",
              "      <th>code_OWID</th>\n",
              "      <th>population_OWID</th>\n",
              "      <th>population_source</th>\n",
              "      <th>code_3digit</th>\n",
              "      <th>population_agg</th>\n",
              "      <th>name_short</th>\n",
              "      <th>source</th>\n",
              "      <th>sovereignty_code</th>\n",
              "      <th>sovereignty_code_NK</th>\n",
              "      <th>region</th>\n",
              "      <th>sovereignty_name_NK</th>\n",
              "      <th>region_ja</th>\n",
              "      <th>category</th>\n",
              "      <th>name_ja</th>\n",
              "      <th>notes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>England</td>\n",
              "      <td>OWID_ENG</td>\n",
              "      <td>56550000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>OWID_ENG</td>\n",
              "      <td>56550000</td>\n",
              "      <td>England</td>\n",
              "      <td>OWID</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>Europe</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>country_area</td>\n",
              "      <td>イングランド</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Scotland</td>\n",
              "      <td>OWID_SCT</td>\n",
              "      <td>5466000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>OWID_SCT</td>\n",
              "      <td>5466000</td>\n",
              "      <td>Scotland</td>\n",
              "      <td>OWID</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>Europe</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>country_area</td>\n",
              "      <td>スコットランド</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Wales</td>\n",
              "      <td>OWID_WLS</td>\n",
              "      <td>3170000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>OWID_WLS</td>\n",
              "      <td>3170000</td>\n",
              "      <td>Wales</td>\n",
              "      <td>OWID</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>Europe</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>country_area</td>\n",
              "      <td>ウェールズ</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Northern Ireland</td>\n",
              "      <td>OWID_NIR</td>\n",
              "      <td>1896000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>OWID_NIR</td>\n",
              "      <td>1896000</td>\n",
              "      <td>Northern Ireland</td>\n",
              "      <td>OWID</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>Europe</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>country_area</td>\n",
              "      <td>北アイルランド</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          name_full code_OWID  ...  name_ja                    notes\n",
              "0           England  OWID_ENG  ...   イングランド  subnational area of GBR\n",
              "1          Scotland  OWID_SCT  ...  スコットランド  subnational area of GBR\n",
              "2             Wales  OWID_WLS  ...    ウェールズ  subnational area of GBR\n",
              "3  Northern Ireland  OWID_NIR  ...  北アイルランド  subnational area of GBR\n",
              "\n",
              "[4 rows x 16 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 96
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fNbcLzk02g-6"
      },
      "source": [
        "countries = countries.append(sub).reset_index(drop=True)"
      ],
      "execution_count": 99,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cpcEW8V45Mal"
      },
      "source": [
        "countries[['UN','WB','MOFA','EU','vac_data']] = False"
      ],
      "execution_count": 102,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 462
        },
        "id": "7zy2hLH6wbEh",
        "outputId": "262d53a5-7bc6-4246-9008-013a91de06d5"
      },
      "source": [
        "countries.loc[countries.name_full.str.contains('England|Scotland|Wales|Northern Ireland')]"
      ],
      "execution_count": 103,
      "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>code_3digit</th>\n",
              "      <th>code_2digit</th>\n",
              "      <th>code_FT</th>\n",
              "      <th>ISO3</th>\n",
              "      <th>ISO2</th>\n",
              "      <th>code_GENC</th>\n",
              "      <th>code_GENC_2</th>\n",
              "      <th>FIPS</th>\n",
              "      <th>code_OWID</th>\n",
              "      <th>numeric</th>\n",
              "      <th>numeric_UN_M49</th>\n",
              "      <th>code_MOFA</th>\n",
              "      <th>sovereignty_code</th>\n",
              "      <th>sovereignty_code_NK</th>\n",
              "      <th>name_full</th>\n",
              "      <th>name_short</th>\n",
              "      <th>region</th>\n",
              "      <th>name_ja</th>\n",
              "      <th>name_ja_NK</th>\n",
              "      <th>sovereignty_name_NK</th>\n",
              "      <th>region_ja</th>\n",
              "      <th>name_MOFA</th>\n",
              "      <th>region_MOFA</th>\n",
              "      <th>name_ISO</th>\n",
              "      <th>name_UN</th>\n",
              "      <th>name_WB</th>\n",
              "      <th>name_FIPS</th>\n",
              "      <th>name_GENC_short</th>\n",
              "      <th>name_GENC_full</th>\n",
              "      <th>name_CIA</th>\n",
              "      <th>name_FT</th>\n",
              "      <th>category</th>\n",
              "      <th>population_agg</th>\n",
              "      <th>population_source</th>\n",
              "      <th>population_WB_2020</th>\n",
              "      <th>population_WB_2019</th>\n",
              "      <th>population_UN_2021</th>\n",
              "      <th>population_UN_2020</th>\n",
              "      <th>population_CIA</th>\n",
              "      <th>update_CIA</th>\n",
              "      <th>population_FT</th>\n",
              "      <th>population_OWID</th>\n",
              "      <th>region_UN</th>\n",
              "      <th>subregion_UN</th>\n",
              "      <th>subregion2_UN</th>\n",
              "      <th>region_WB</th>\n",
              "      <th>income_WB</th>\n",
              "      <th>UN</th>\n",
              "      <th>WB</th>\n",
              "      <th>MOFA</th>\n",
              "      <th>EU</th>\n",
              "      <th>vac_data</th>\n",
              "      <th>lat_nikkei</th>\n",
              "      <th>long_nikkei</th>\n",
              "      <th>notes</th>\n",
              "      <th>source</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>99</th>\n",
              "      <td>GBR</td>\n",
              "      <td>GB</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GB</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GB</td>\n",
              "      <td>UK</td>\n",
              "      <td>GBR</td>\n",
              "      <td>826.0</td>\n",
              "      <td>826.0</td>\n",
              "      <td>44.0</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>The United Kingdom of Great Britain and Northe...</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>Europe</td>\n",
              "      <td>英国</td>\n",
              "      <td>英国</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>英国（グレートブリテン及び北アイルランド連合王国）</td>\n",
              "      <td>欧州</td>\n",
              "      <td>United Kingdom of Great Britain and Northern I...</td>\n",
              "      <td>United Kingdom of Great Britain and Northern I...</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>United Kingdom of Great Britain and Northern I...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>country_area</td>\n",
              "      <td>67215293.0</td>\n",
              "      <td>World Bank,2020</td>\n",
              "      <td>67215293.0</td>\n",
              "      <td>66836327.0</td>\n",
              "      <td>68207114.0</td>\n",
              "      <td>67886004.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>66796807.0</td>\n",
              "      <td>68207114.0</td>\n",
              "      <td>Europe</td>\n",
              "      <td>Northern Europe</td>\n",
              "      <td>Northern Europe</td>\n",
              "      <td>Europe &amp; Central Asia</td>\n",
              "      <td>High income</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>55.378051</td>\n",
              "      <td>-3.435973</td>\n",
              "      <td>Code taken from Great Britain (from official n...</td>\n",
              "      <td>iso_code.csv</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>360</th>\n",
              "      <td>OWID_ENG</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>OWID_ENG</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>England</td>\n",
              "      <td>England</td>\n",
              "      <td>Europe</td>\n",
              "      <td>イングランド</td>\n",
              "      <td>NaN</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>country_area</td>\n",
              "      <td>56550000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>56550000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "      <td>OWID</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>361</th>\n",
              "      <td>OWID_SCT</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>OWID_SCT</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>Scotland</td>\n",
              "      <td>Scotland</td>\n",
              "      <td>Europe</td>\n",
              "      <td>スコットランド</td>\n",
              "      <td>NaN</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>country_area</td>\n",
              "      <td>5466000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5466000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "      <td>OWID</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>362</th>\n",
              "      <td>OWID_WLS</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>OWID_WLS</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>Wales</td>\n",
              "      <td>Wales</td>\n",
              "      <td>Europe</td>\n",
              "      <td>ウェールズ</td>\n",
              "      <td>NaN</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>country_area</td>\n",
              "      <td>3170000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3170000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "      <td>OWID</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>363</th>\n",
              "      <td>OWID_NIR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>OWID_NIR</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>GBR</td>\n",
              "      <td>GBR</td>\n",
              "      <td>Northern Ireland</td>\n",
              "      <td>Northern Ireland</td>\n",
              "      <td>Europe</td>\n",
              "      <td>北アイルランド</td>\n",
              "      <td>NaN</td>\n",
              "      <td>英国</td>\n",
              "      <td>欧州</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>country_area</td>\n",
              "      <td>1896000</td>\n",
              "      <td>https://www.ons.gov.uk/peoplepopulationandcomm...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1896000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>subnational area of GBR</td>\n",
              "      <td>OWID</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    code_3digit  ...        source\n",
              "99          GBR  ...  iso_code.csv\n",
              "360    OWID_ENG  ...          OWID\n",
              "361    OWID_SCT  ...          OWID\n",
              "362    OWID_WLS  ...          OWID\n",
              "363    OWID_NIR  ...          OWID\n",
              "\n",
              "[5 rows x 56 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 103
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "OaxgThBp45gB"
      },
      "source": [
        "修正"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pYNRuK6-x4-C"
      },
      "source": [
        "countries.loc[countries.code_3digit.str.contains('OWID'),'code_OWID'] = countries.loc[countries.code_3digit.str.contains('OWID'),'code_3digit']"
      ],
      "execution_count": 109,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 69
        },
        "id": "Yc89reuh4RQB",
        "outputId": "85febc42-a6e9-4487-d600-1f2205a6e130"
      },
      "source": [
        "countries.loc[countries.code_3digit.str.contains('OWID')&countries.code_OWID.isna()]"
      ],
      "execution_count": 110,
      "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>code_3digit</th>\n",
              "      <th>code_2digit</th>\n",
              "      <th>code_FT</th>\n",
              "      <th>ISO3</th>\n",
              "      <th>ISO2</th>\n",
              "      <th>code_GENC</th>\n",
              "      <th>code_GENC_2</th>\n",
              "      <th>FIPS</th>\n",
              "      <th>code_OWID</th>\n",
              "      <th>numeric</th>\n",
              "      <th>numeric_UN_M49</th>\n",
              "      <th>code_MOFA</th>\n",
              "      <th>sovereignty_code</th>\n",
              "      <th>sovereignty_code_NK</th>\n",
              "      <th>name_full</th>\n",
              "      <th>name_short</th>\n",
              "      <th>region</th>\n",
              "      <th>name_ja</th>\n",
              "      <th>name_ja_NK</th>\n",
              "      <th>sovereignty_name_NK</th>\n",
              "      <th>region_ja</th>\n",
              "      <th>name_MOFA</th>\n",
              "      <th>region_MOFA</th>\n",
              "      <th>name_ISO</th>\n",
              "      <th>name_UN</th>\n",
              "      <th>name_WB</th>\n",
              "      <th>name_FIPS</th>\n",
              "      <th>name_GENC_short</th>\n",
              "      <th>name_GENC_full</th>\n",
              "      <th>name_CIA</th>\n",
              "      <th>name_FT</th>\n",
              "      <th>category</th>\n",
              "      <th>population_agg</th>\n",
              "      <th>population_source</th>\n",
              "      <th>population_WB_2020</th>\n",
              "      <th>population_WB_2019</th>\n",
              "      <th>population_UN_2021</th>\n",
              "      <th>population_UN_2020</th>\n",
              "      <th>population_CIA</th>\n",
              "      <th>update_CIA</th>\n",
              "      <th>population_FT</th>\n",
              "      <th>population_OWID</th>\n",
              "      <th>region_UN</th>\n",
              "      <th>subregion_UN</th>\n",
              "      <th>subregion2_UN</th>\n",
              "      <th>region_WB</th>\n",
              "      <th>income_WB</th>\n",
              "      <th>UN</th>\n",
              "      <th>WB</th>\n",
              "      <th>MOFA</th>\n",
              "      <th>EU</th>\n",
              "      <th>vac_data</th>\n",
              "      <th>lat_nikkei</th>\n",
              "      <th>long_nikkei</th>\n",
              "      <th>notes</th>\n",
              "      <th>source</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "Empty DataFrame\n",
              "Columns: [code_3digit, code_2digit, code_FT, ISO3, ISO2, code_GENC, code_GENC_2, FIPS, code_OWID, numeric, numeric_UN_M49, code_MOFA, sovereignty_code, sovereignty_code_NK, name_full, name_short, region, name_ja, name_ja_NK, sovereignty_name_NK, region_ja, name_MOFA, region_MOFA, name_ISO, name_UN, name_WB, name_FIPS, name_GENC_short, name_GENC_full, name_CIA, name_FT, category, population_agg, population_source, population_WB_2020, population_WB_2019, population_UN_2021, population_UN_2020, population_CIA, update_CIA, population_FT, population_OWID, region_UN, subregion_UN, subregion2_UN, region_WB, income_WB, UN, WB, MOFA, EU, vac_data, lat_nikkei, long_nikkei, notes, source]\n",
              "Index: []"
            ]
          },
          "metadata": {},
          "execution_count": 110
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DkMSsaRIu7eq"
      },
      "source": [
        "countries.to_csv('countries_meta_r.csv')"
      ],
      "execution_count": 113,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gzGS93OI6JOs"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}