jiroCalc-01.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#__author__ = \"Admin GGCS\"\n",
    "#__copyright__ = \"Copyright 2019\"\n",
    "#__license__ = \"MIT\"\n",
    "#__version__ = \"1.0.0\"\n",
    "#__maintainer__ = \"Admin GGCS\"\n",
    "#__website__ = \"ggcs.io"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 0 Setup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1 データの準備"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.1 CSVから読み込み"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>食品番号</th>\n",
       "      <th>食品名</th>\n",
       "      <th>エネルギー（kcal）</th>\n",
       "      <th>たんぱく質</th>\n",
       "      <th>脂   質</th>\n",
       "      <th>飽和脂肪酸</th>\n",
       "      <th>炭水化物</th>\n",
       "      <th>カリウム</th>\n",
       "      <th>カルシウム</th>\n",
       "      <th>ビタミンB1</th>\n",
       "      <th>ビタミンB2</th>\n",
       "      <th>ビタミンC</th>\n",
       "      <th>食塩相当量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01047</td>\n",
       "      <td>こむぎ　［中華めん類］　中華めん　生</td>\n",
       "      <td>281</td>\n",
       "      <td>8.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>(0.28)</td>\n",
       "      <td>55.7</td>\n",
       "      <td>350</td>\n",
       "      <td>21</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.02</td>\n",
       "      <td>(0)</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06061</td>\n",
       "      <td>（キャベツ類）　キャベツ　結球葉　生</td>\n",
       "      <td>23</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.02</td>\n",
       "      <td>5.2</td>\n",
       "      <td>200</td>\n",
       "      <td>43</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.03</td>\n",
       "      <td>41</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06287</td>\n",
       "      <td>（もやし類）　だいずもやし　生</td>\n",
       "      <td>37</td>\n",
       "      <td>3.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.20</td>\n",
       "      <td>2.3</td>\n",
       "      <td>160</td>\n",
       "      <td>23</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.07</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11119</td>\n",
       "      <td>＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生</td>\n",
       "      <td>253</td>\n",
       "      <td>17.1</td>\n",
       "      <td>19.2</td>\n",
       "      <td>7.26</td>\n",
       "      <td>0.1</td>\n",
       "      <td>300</td>\n",
       "      <td>4</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.23</td>\n",
       "      <td>2</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14006</td>\n",
       "      <td>（植物油脂類）　調合油</td>\n",
       "      <td>921</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>10.97</td>\n",
       "      <td>0</td>\n",
       "      <td>Tr</td>\n",
       "      <td>Tr</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>(0)</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>14016</td>\n",
       "      <td>（動物脂類）　ラード</td>\n",
       "      <td>941</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>39.29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17007</td>\n",
       "      <td>＜調味料類＞（しょうゆ類）こいくちしょうゆ</td>\n",
       "      <td>71</td>\n",
       "      <td>7.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-</td>\n",
       "      <td>10.1</td>\n",
       "      <td>390</td>\n",
       "      <td>29</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0</td>\n",
       "      <td>14.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17024</td>\n",
       "      <td>＜調味料類＞（だし類）鳥がらだし</td>\n",
       "      <td>7</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.06</td>\n",
       "      <td>Tr</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.09</td>\n",
       "      <td>(0)</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17025</td>\n",
       "      <td>＜調味料類＞（だし類）中華だし</td>\n",
       "      <td>3</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-</td>\n",
       "      <td>Tr</td>\n",
       "      <td>90</td>\n",
       "      <td>3</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17026</td>\n",
       "      <td>＜調味料類＞（だし類）洋風だし</td>\n",
       "      <td>6</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-</td>\n",
       "      <td>0.3</td>\n",
       "      <td>110</td>\n",
       "      <td>5</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    食品番号                           食品名  エネルギー（kcal）  たんぱく質  脂   質   飽和脂肪酸  \\\n",
       "0  01047           こむぎ　［中華めん類］　中華めん　生　          281    8.6    1.2  (0.28)   \n",
       "1  06061          （キャベツ類）　キャベツ　結球葉　生　　           23    1.3    0.2    0.02   \n",
       "2  06287             （もやし類）　だいずもやし　生　　           37    3.7    1.5    0.20   \n",
       "3  11119  ＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生　          253   17.1   19.2    7.26   \n",
       "4  14006                （植物油脂類）　調合油　　　          921    0.0  100.0   10.97   \n",
       "5  14016                 （動物脂類）　ラード　　　          941    0.0  100.0   39.29   \n",
       "6  17007      ＜調味料類＞（しょうゆ類）こいくちしょうゆ　　　           71    7.7    0.0       -   \n",
       "7  17024           ＜調味料類＞（だし類）鳥がらだし　　　            7    1.1    0.2    0.06   \n",
       "8  17025            ＜調味料類＞（だし類）中華だし　　　            3    0.8    0.0       -   \n",
       "9  17026            ＜調味料類＞（だし類）洋風だし　　　            6    1.3    0.0       -   \n",
       "\n",
       "   炭水化物 カリウム カルシウム  ビタミンB1  ビタミンB2 ビタミンC  食塩相当量  \n",
       "0  55.7  350    21    0.02    0.02   (0)    1.0  \n",
       "1   5.2  200    43    0.04    0.03    41    0.0  \n",
       "2   2.3  160    23    0.09    0.07     5    0.0  \n",
       "3   0.1  300     4    0.63    0.23     2    0.1  \n",
       "4     0   Tr    Tr    0.00    0.00   (0)    0.0  \n",
       "5     0    0     0    0.00    0.00     0    0.0  \n",
       "6  10.1  390    29    0.05    0.17     0   14.5  \n",
       "7    Tr   65     2    0.02    0.09   (0)    0.1  \n",
       "8    Tr   90     3    0.15    0.03     0    0.1  \n",
       "9   0.3  110     5    0.02    0.05     0    0.5  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#元データ読み込み\n",
    "raw_df = pd.read_csv(\n",
    "    'jiro-nutrition-facts.csv', header = 8, \n",
    "    #必要な列を読み込む\n",
    "    usecols = ['食品番号','食品名','エネルギー（kcal）','たんぱく質','脂   質','炭水化物','カリウム','カルシウム','ビタミンB1','ビタミンB2','ビタミンC','飽和脂肪酸','食塩相当量'],\n",
    "    #以下の２項目は現段階でデータ型を明示しておいたほうが何かと都合が良い。\n",
    "    dtype = {'食品番号': str, '食品名': str}\n",
    ")\n",
    "\n",
    "#雰囲気を確認するとこんな感じ\n",
    "#お掃除の方針\n",
    "#→カッコに入った数値、i.e. (0.28)とか(0)とか、は、推定値を表すので、カッコを外して算入することにしたい。\n",
    "#→Trや - は 0.0 にしておいた方が安心（NaNにするとあとで面倒くさいので）。\n",
    "raw_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1.2 お掃除"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>食品番号</th>\n",
       "      <th>食品名</th>\n",
       "      <th>エネルギー（kcal）</th>\n",
       "      <th>たんぱく質</th>\n",
       "      <th>脂   質</th>\n",
       "      <th>飽和脂肪酸</th>\n",
       "      <th>炭水化物</th>\n",
       "      <th>カリウム</th>\n",
       "      <th>カルシウム</th>\n",
       "      <th>ビタミンB1</th>\n",
       "      <th>ビタミンB2</th>\n",
       "      <th>ビタミンC</th>\n",
       "      <th>食塩相当量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01047</td>\n",
       "      <td>こむぎ　［中華めん類］　中華めん　生</td>\n",
       "      <td>281.0</td>\n",
       "      <td>8.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.28</td>\n",
       "      <td>55.7</td>\n",
       "      <td>350.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06061</td>\n",
       "      <td>（キャベツ類）　キャベツ　結球葉　生</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.02</td>\n",
       "      <td>5.2</td>\n",
       "      <td>200.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.03</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06287</td>\n",
       "      <td>（もやし類）　だいずもやし　生</td>\n",
       "      <td>37.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.20</td>\n",
       "      <td>2.3</td>\n",
       "      <td>160.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.07</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11119</td>\n",
       "      <td>＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生</td>\n",
       "      <td>253.0</td>\n",
       "      <td>17.1</td>\n",
       "      <td>19.2</td>\n",
       "      <td>7.26</td>\n",
       "      <td>0.1</td>\n",
       "      <td>300.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.23</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14006</td>\n",
       "      <td>（植物油脂類）　調合油</td>\n",
       "      <td>921.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>10.97</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>14016</td>\n",
       "      <td>（動物脂類）　ラード</td>\n",
       "      <td>941.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>39.29</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17007</td>\n",
       "      <td>＜調味料類＞（しょうゆ類）こいくちしょうゆ</td>\n",
       "      <td>71.0</td>\n",
       "      <td>7.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.1</td>\n",
       "      <td>390.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17024</td>\n",
       "      <td>＜調味料類＞（だし類）鳥がらだし</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17025</td>\n",
       "      <td>＜調味料類＞（だし類）中華だし</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17026</td>\n",
       "      <td>＜調味料類＞（だし類）洋風だし</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.3</td>\n",
       "      <td>110.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    食品番号                           食品名  エネルギー（kcal）  たんぱく質  脂   質  飽和脂肪酸  \\\n",
       "0  01047           こむぎ　［中華めん類］　中華めん　生　        281.0    8.6    1.2   0.28   \n",
       "1  06061          （キャベツ類）　キャベツ　結球葉　生　　         23.0    1.3    0.2   0.02   \n",
       "2  06287             （もやし類）　だいずもやし　生　　         37.0    3.7    1.5   0.20   \n",
       "3  11119  ＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生　        253.0   17.1   19.2   7.26   \n",
       "4  14006                （植物油脂類）　調合油　　　        921.0    0.0  100.0  10.97   \n",
       "5  14016                 （動物脂類）　ラード　　　        941.0    0.0  100.0  39.29   \n",
       "6  17007      ＜調味料類＞（しょうゆ類）こいくちしょうゆ　　　         71.0    7.7    0.0   0.00   \n",
       "7  17024           ＜調味料類＞（だし類）鳥がらだし　　　          7.0    1.1    0.2   0.06   \n",
       "8  17025            ＜調味料類＞（だし類）中華だし　　　          3.0    0.8    0.0   0.00   \n",
       "9  17026            ＜調味料類＞（だし類）洋風だし　　　          6.0    1.3    0.0   0.00   \n",
       "\n",
       "   炭水化物   カリウム  カルシウム  ビタミンB1  ビタミンB2  ビタミンC  食塩相当量  \n",
       "0  55.7  350.0   21.0    0.02    0.02    0.0    1.0  \n",
       "1   5.2  200.0   43.0    0.04    0.03   41.0    0.0  \n",
       "2   2.3  160.0   23.0    0.09    0.07    5.0    0.0  \n",
       "3   0.1  300.0    4.0    0.63    0.23    2.0    0.1  \n",
       "4   0.0    0.0    0.0    0.00    0.00    0.0    0.0  \n",
       "5   0.0    0.0    0.0    0.00    0.00    0.0    0.0  \n",
       "6  10.1  390.0   29.0    0.05    0.17    0.0   14.5  \n",
       "7   0.0   65.0    2.0    0.02    0.09    0.0    0.1  \n",
       "8   0.0   90.0    3.0    0.15    0.03    0.0    0.1  \n",
       "9   0.3  110.0    5.0    0.02    0.05    0.0    0.5  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#数値のカッコを外し、文字は 0 に。\n",
    "clean_df = raw_df.replace(\n",
    "    ['\\((\\d+\\.*\\d*)\\)', '\\(Tr\\)', 'Tr', '-'], \n",
    "    [r'\\1', 0.0, 0.0, 0.0], regex=True)\n",
    "#データタイプを float に揃えておく（これをやっておかないとあとの計算で原因不意の error でハマることが多い。）\n",
    "clean_df.iloc[:,2:] = clean_df.iloc[:,2:].astype(float)\n",
    "\n",
    "#確認\n",
    "clean_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10 entries, 0 to 9\n",
      "Data columns (total 13 columns):\n",
      "食品番号           10 non-null object\n",
      "食品名            10 non-null object\n",
      "エネルギー（kcal）    10 non-null float64\n",
      "たんぱく質          10 non-null float64\n",
      "脂   質          10 non-null float64\n",
      "飽和脂肪酸          10 non-null float64\n",
      "炭水化物           10 non-null float64\n",
      "カリウム           10 non-null float64\n",
      "カルシウム          10 non-null float64\n",
      "ビタミンB1         10 non-null float64\n",
      "ビタミンB2         10 non-null float64\n",
      "ビタミンC          10 non-null float64\n",
      "食塩相当量          10 non-null float64\n",
      "dtypes: float64(11), object(2)\n",
      "memory usage: 1.1+ KB\n"
     ]
    }
   ],
   "source": [
    "#様子を見る　→ 良さげ\n",
    "clean_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#ダメだった時の犯人探し用\n",
    "#for i in range(0, clean_df.shape[0]):\n",
    "#    for j in  range(1,clean_df.shape[1]):\n",
    "#        print(i,j, clean_df.iloc[i,j], type(clean_df.iloc[i,j]))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2 計算"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2.1 計算用に空のDataframeを作る"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "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>食品番号</th>\n",
       "      <th>食品名</th>\n",
       "      <th>食材重量(100g)</th>\n",
       "      <th>エネルギー（kcal）</th>\n",
       "      <th>たんぱく質</th>\n",
       "      <th>脂   質</th>\n",
       "      <th>飽和脂肪酸</th>\n",
       "      <th>炭水化物</th>\n",
       "      <th>カリウム</th>\n",
       "      <th>カルシウム</th>\n",
       "      <th>ビタミンB1</th>\n",
       "      <th>ビタミンB2</th>\n",
       "      <th>ビタミンC</th>\n",
       "      <th>食塩相当量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01047</td>\n",
       "      <td>こむぎ　［中華めん類］　中華めん　生</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06061</td>\n",
       "      <td>（キャベツ類）　キャベツ　結球葉　生</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06287</td>\n",
       "      <td>（もやし類）　だいずもやし　生</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11119</td>\n",
       "      <td>＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14006</td>\n",
       "      <td>（植物油脂類）　調合油</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>14016</td>\n",
       "      <td>（動物脂類）　ラード</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17007</td>\n",
       "      <td>＜調味料類＞（しょうゆ類）こいくちしょうゆ</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17024</td>\n",
       "      <td>＜調味料類＞（だし類）鳥がらだし</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17025</td>\n",
       "      <td>＜調味料類＞（だし類）中華だし</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17026</td>\n",
       "      <td>＜調味料類＞（だし類）洋風だし</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    食品番号                           食品名  食材重量(100g)  エネルギー（kcal）  たんぱく質  脂   質  \\\n",
       "0  01047           こむぎ　［中華めん類］　中華めん　生　         0.0          0.0    0.0    0.0   \n",
       "1  06061          （キャベツ類）　キャベツ　結球葉　生　　         0.0          0.0    0.0    0.0   \n",
       "2  06287             （もやし類）　だいずもやし　生　　         0.0          0.0    0.0    0.0   \n",
       "3  11119  ＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生　         0.0          0.0    0.0    0.0   \n",
       "4  14006                （植物油脂類）　調合油　　　         0.0          0.0    0.0    0.0   \n",
       "5  14016                 （動物脂類）　ラード　　　         0.0          0.0    0.0    0.0   \n",
       "6  17007      ＜調味料類＞（しょうゆ類）こいくちしょうゆ　　　         0.0          0.0    0.0    0.0   \n",
       "7  17024           ＜調味料類＞（だし類）鳥がらだし　　　         0.0          0.0    0.0    0.0   \n",
       "8  17025            ＜調味料類＞（だし類）中華だし　　　         0.0          0.0    0.0    0.0   \n",
       "9  17026            ＜調味料類＞（だし類）洋風だし　　　         0.0          0.0    0.0    0.0   \n",
       "\n",
       "   飽和脂肪酸  炭水化物  カリウム  カルシウム  ビタミンB1  ビタミンB2  ビタミンC  食塩相当量  \n",
       "0    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "1    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "2    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "3    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "4    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "5    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "6    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "7    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "8    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  \n",
       "9    0.0   0.0   0.0    0.0     0.0     0.0    0.0    0.0  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#新たに calc_df を作る　← clean_df をcopy()して改造する方針。\n",
    "calc_df = clean_df.copy()\n",
    "#2列目の右に「食材重量(100g)」欄を挿入。初期値は 0.0\n",
    "calc_df.insert(2,'食材重量(100g)', 0.0)\n",
    "#全体的に数値はすべて 0.0 で初期化しておく。\n",
    "calc_df.iloc[:,2:] = 0.0\n",
    "\n",
    "#確認\n",
    "calc_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.2 食材重量を設定"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#食材重量設定の例\n",
    "\n",
    "#めん重量設定（100g 単位）\n",
    "calc_df.iloc[0,2] = 2.8 #めん\n",
    "#キャベツ重量設定（100g 単位）\n",
    "calc_df.iloc[1,2] = 0.4 #キャベツ\n",
    "#もやし重量設定（100g 単位）\n",
    "calc_df.iloc[2,2] = 0.3 #もやし\n",
    "#ぶた重量設定（100g 単位）\n",
    "calc_df.iloc[3,2] = 1.1 #ぶた\n",
    "#植物油脂重量設定（100g 単位）\n",
    "calc_df.iloc[4,2] = 0.0 #植物油脂\n",
    "#動物脂類重量設定（100g 単位）\n",
    "calc_df.iloc[5,2] = 0.2936 #動物脂類\n",
    "#しょうゆ重量設定（100g 単位）\n",
    "calc_df.iloc[6,2] = 0.0 #しょうゆ\n",
    "#鳥がらだし量設定（100g 単位）\n",
    "calc_df.iloc[7,2] = 0.0 #鳥がらだし\n",
    "#中華だし重量設定（100g 単位）\n",
    "calc_df.iloc[8,2] = 0.0 #中華だし\n",
    "#洋風だし重量設定（100g 単位）\n",
    "calc_df.iloc[9,2] = 2.0 #洋風だし"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.3 計算"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "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>食品番号</th>\n",
       "      <th>食品名</th>\n",
       "      <th>食材重量(100g)</th>\n",
       "      <th>エネルギー（kcal）</th>\n",
       "      <th>たんぱく質</th>\n",
       "      <th>脂   質</th>\n",
       "      <th>飽和脂肪酸</th>\n",
       "      <th>炭水化物</th>\n",
       "      <th>カリウム</th>\n",
       "      <th>カルシウム</th>\n",
       "      <th>ビタミンB1</th>\n",
       "      <th>ビタミンB2</th>\n",
       "      <th>ビタミンC</th>\n",
       "      <th>食塩相当量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01047</td>\n",
       "      <td>こむぎ　［中華めん類］　中華めん　生</td>\n",
       "      <td>2.8000</td>\n",
       "      <td>786.8000</td>\n",
       "      <td>24.08</td>\n",
       "      <td>3.36</td>\n",
       "      <td>0.784000</td>\n",
       "      <td>155.96</td>\n",
       "      <td>980.0</td>\n",
       "      <td>58.8</td>\n",
       "      <td>0.056</td>\n",
       "      <td>0.056</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06061</td>\n",
       "      <td>（キャベツ類）　キャベツ　結球葉　生</td>\n",
       "      <td>0.4000</td>\n",
       "      <td>9.2000</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.008000</td>\n",
       "      <td>2.08</td>\n",
       "      <td>80.0</td>\n",
       "      <td>17.2</td>\n",
       "      <td>0.016</td>\n",
       "      <td>0.012</td>\n",
       "      <td>16.4</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06287</td>\n",
       "      <td>（もやし類）　だいずもやし　生</td>\n",
       "      <td>0.3000</td>\n",
       "      <td>11.1000</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.060000</td>\n",
       "      <td>0.69</td>\n",
       "      <td>48.0</td>\n",
       "      <td>6.9</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.021</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11119</td>\n",
       "      <td>＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生</td>\n",
       "      <td>1.1000</td>\n",
       "      <td>278.3000</td>\n",
       "      <td>18.81</td>\n",
       "      <td>21.12</td>\n",
       "      <td>7.986000</td>\n",
       "      <td>0.11</td>\n",
       "      <td>330.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>0.693</td>\n",
       "      <td>0.253</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14006</td>\n",
       "      <td>（植物油脂類）　調合油</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>14016</td>\n",
       "      <td>（動物脂類）　ラード</td>\n",
       "      <td>0.2936</td>\n",
       "      <td>276.2776</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.36</td>\n",
       "      <td>11.535544</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17007</td>\n",
       "      <td>＜調味料類＞（しょうゆ類）こいくちしょうゆ</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17024</td>\n",
       "      <td>＜調味料類＞（だし類）鳥がらだし</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17025</td>\n",
       "      <td>＜調味料類＞（だし類）中華だし</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17026</td>\n",
       "      <td>＜調味料類＞（だし類）洋風だし</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>2.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.60</td>\n",
       "      <td>220.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.040</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    食品番号                           食品名  食材重量(100g)  エネルギー（kcal）  たんぱく質  脂   質  \\\n",
       "0  01047           こむぎ　［中華めん類］　中華めん　生　      2.8000     786.8000  24.08   3.36   \n",
       "1  06061          （キャベツ類）　キャベツ　結球葉　生　　      0.4000       9.2000   0.52   0.08   \n",
       "2  06287             （もやし類）　だいずもやし　生　　      0.3000      11.1000   1.11   0.45   \n",
       "3  11119  ＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生　      1.1000     278.3000  18.81  21.12   \n",
       "4  14006                （植物油脂類）　調合油　　　      0.0000       0.0000   0.00   0.00   \n",
       "5  14016                 （動物脂類）　ラード　　　      0.2936     276.2776   0.00  29.36   \n",
       "6  17007      ＜調味料類＞（しょうゆ類）こいくちしょうゆ　　　      0.0000       0.0000   0.00   0.00   \n",
       "7  17024           ＜調味料類＞（だし類）鳥がらだし　　　      0.0000       0.0000   0.00   0.00   \n",
       "8  17025            ＜調味料類＞（だし類）中華だし　　　      0.0000       0.0000   0.00   0.00   \n",
       "9  17026            ＜調味料類＞（だし類）洋風だし　　　      2.0000      12.0000   2.60   0.00   \n",
       "\n",
       "       飽和脂肪酸    炭水化物   カリウム  カルシウム  ビタミンB1  ビタミンB2  ビタミンC  食塩相当量  \n",
       "0   0.784000  155.96  980.0   58.8   0.056   0.056    0.0   2.80  \n",
       "1   0.008000    2.08   80.0   17.2   0.016   0.012   16.4   0.00  \n",
       "2   0.060000    0.69   48.0    6.9   0.027   0.021    1.5   0.00  \n",
       "3   7.986000    0.11  330.0    4.4   0.693   0.253    2.2   0.11  \n",
       "4   0.000000    0.00    0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "5  11.535544    0.00    0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "6   0.000000    0.00    0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "7   0.000000    0.00    0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "8   0.000000    0.00    0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "9   0.000000    0.60  220.0   10.0   0.040   0.100    0.0   1.00  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#表計算操作（一行ずつ計算。ちょっと頭悪そう…）\n",
    "for k in range(calc_df.shape[0]):\n",
    "    calc_df.iloc[k,3:] = clean_df.iloc[k,2:] * calc_df.iloc[k,2]\n",
    "    \n",
    "#確認 → 良さげ :)\n",
    "calc_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "エネルギー（kcal）    1373.677600\n",
       "たんぱく質            47.120000\n",
       "脂   質            54.370000\n",
       "飽和脂肪酸            20.373544\n",
       "炭水化物            159.440000\n",
       "カリウム           1658.000000\n",
       "カルシウム            97.300000\n",
       "ビタミンB1            0.832000\n",
       "ビタミンB2            0.442000\n",
       "ビタミンC            20.100000\n",
       "食塩相当量             3.910000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#項目ごとの合計値を確認\n",
    "calc_df.iloc[:,3:].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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>食品番号</th>\n",
       "      <th>食品名</th>\n",
       "      <th>食材重量(100g)</th>\n",
       "      <th>エネルギー（kcal）</th>\n",
       "      <th>たんぱく質</th>\n",
       "      <th>脂   質</th>\n",
       "      <th>飽和脂肪酸</th>\n",
       "      <th>炭水化物</th>\n",
       "      <th>カリウム</th>\n",
       "      <th>カルシウム</th>\n",
       "      <th>ビタミンB1</th>\n",
       "      <th>ビタミンB2</th>\n",
       "      <th>ビタミンC</th>\n",
       "      <th>食塩相当量</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01047</td>\n",
       "      <td>こむぎ　［中華めん類］　中華めん　生</td>\n",
       "      <td>2.8000</td>\n",
       "      <td>786.8000</td>\n",
       "      <td>24.08</td>\n",
       "      <td>3.36</td>\n",
       "      <td>0.784000</td>\n",
       "      <td>155.96</td>\n",
       "      <td>980.0</td>\n",
       "      <td>58.8</td>\n",
       "      <td>0.056</td>\n",
       "      <td>0.056</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06061</td>\n",
       "      <td>（キャベツ類）　キャベツ　結球葉　生</td>\n",
       "      <td>0.4000</td>\n",
       "      <td>9.2000</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.008000</td>\n",
       "      <td>2.08</td>\n",
       "      <td>80.0</td>\n",
       "      <td>17.2</td>\n",
       "      <td>0.016</td>\n",
       "      <td>0.012</td>\n",
       "      <td>16.4</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06287</td>\n",
       "      <td>（もやし類）　だいずもやし　生</td>\n",
       "      <td>0.3000</td>\n",
       "      <td>11.1000</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.060000</td>\n",
       "      <td>0.69</td>\n",
       "      <td>48.0</td>\n",
       "      <td>6.9</td>\n",
       "      <td>0.027</td>\n",
       "      <td>0.021</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11119</td>\n",
       "      <td>＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生</td>\n",
       "      <td>1.1000</td>\n",
       "      <td>278.3000</td>\n",
       "      <td>18.81</td>\n",
       "      <td>21.12</td>\n",
       "      <td>7.986000</td>\n",
       "      <td>0.11</td>\n",
       "      <td>330.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>0.693</td>\n",
       "      <td>0.253</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14006</td>\n",
       "      <td>（植物油脂類）　調合油</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>14016</td>\n",
       "      <td>（動物脂類）　ラード</td>\n",
       "      <td>0.2936</td>\n",
       "      <td>276.2776</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.36</td>\n",
       "      <td>11.535544</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17007</td>\n",
       "      <td>＜調味料類＞（しょうゆ類）こいくちしょうゆ</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17024</td>\n",
       "      <td>＜調味料類＞（だし類）鳥がらだし</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17025</td>\n",
       "      <td>＜調味料類＞（だし類）中華だし</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>17026</td>\n",
       "      <td>＜調味料類＞（だし類）洋風だし</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>2.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.60</td>\n",
       "      <td>220.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.040</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>合計</td>\n",
       "      <td>6.8936</td>\n",
       "      <td>1373.6776</td>\n",
       "      <td>47.12</td>\n",
       "      <td>54.37</td>\n",
       "      <td>20.373544</td>\n",
       "      <td>159.44</td>\n",
       "      <td>1658.0</td>\n",
       "      <td>97.3</td>\n",
       "      <td>0.832</td>\n",
       "      <td>0.442</td>\n",
       "      <td>20.1</td>\n",
       "      <td>3.91</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     食品番号                           食品名  食材重量(100g)  エネルギー（kcal）  たんぱく質  \\\n",
       "0   01047           こむぎ　［中華めん類］　中華めん　生　      2.8000     786.8000  24.08   \n",
       "1   06061          （キャベツ類）　キャベツ　結球葉　生　　      0.4000       9.2000   0.52   \n",
       "2   06287             （もやし類）　だいずもやし　生　　      0.3000      11.1000   1.11   \n",
       "3   11119  ＜畜肉類＞ぶた　［大型種肉］　かたロース　脂身つき　生　      1.1000     278.3000  18.81   \n",
       "4   14006                （植物油脂類）　調合油　　　      0.0000       0.0000   0.00   \n",
       "5   14016                 （動物脂類）　ラード　　　      0.2936     276.2776   0.00   \n",
       "6   17007      ＜調味料類＞（しょうゆ類）こいくちしょうゆ　　　      0.0000       0.0000   0.00   \n",
       "7   17024           ＜調味料類＞（だし類）鳥がらだし　　　      0.0000       0.0000   0.00   \n",
       "8   17025            ＜調味料類＞（だし類）中華だし　　　      0.0000       0.0000   0.00   \n",
       "9   17026            ＜調味料類＞（だし類）洋風だし　　　      2.0000      12.0000   2.60   \n",
       "10    NaN                            合計      6.8936    1373.6776  47.12   \n",
       "\n",
       "    脂   質      飽和脂肪酸    炭水化物    カリウム  カルシウム  ビタミンB1  ビタミンB2  ビタミンC  食塩相当量  \n",
       "0    3.36   0.784000  155.96   980.0   58.8   0.056   0.056    0.0   2.80  \n",
       "1    0.08   0.008000    2.08    80.0   17.2   0.016   0.012   16.4   0.00  \n",
       "2    0.45   0.060000    0.69    48.0    6.9   0.027   0.021    1.5   0.00  \n",
       "3   21.12   7.986000    0.11   330.0    4.4   0.693   0.253    2.2   0.11  \n",
       "4    0.00   0.000000    0.00     0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "5   29.36  11.535544    0.00     0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "6    0.00   0.000000    0.00     0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "7    0.00   0.000000    0.00     0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "8    0.00   0.000000    0.00     0.0    0.0   0.000   0.000    0.0   0.00  \n",
       "9    0.00   0.000000    0.60   220.0   10.0   0.040   0.100    0.0   1.00  \n",
       "10  54.37  20.373544  159.44  1658.0   97.3   0.832   0.442   20.1   3.91  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#合計の行を calc_df の最後に無理やり（calc_df.iloc[:,3:].sum()）加えて summary_df を作る。\n",
    "summary_df = calc_df.append(calc_df.sum(), ignore_index=True)\n",
    "#それだけだとカッコ悪いのでちょっと整える。\n",
    "summary_df.iloc[10,[0,1]] = (np.nan, '合計')\n",
    "#確認\n",
    "summary_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# CSVに保存"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "summary_df.to_csv('jiroCalc-sumary.csv')\n",
    "os.system('open .')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}