ingredient_analysis.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"mount_file_id":"1u6EDNtBWMbBsEQe1HLmC-0mg5YNXEGHz","authorship_tag":"ABX9TyNEWYtnNJ0HLORTE+JKeQ3l"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","source":["from google.colab import drive\n","drive.mount('/content/drive')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"Ya1xDDEkRv-6","executionInfo":{"status":"ok","timestamp":1696583872947,"user_tz":-540,"elapsed":18129,"user":{"displayName":"신동혁","userId":"08556879536051936790"}},"outputId":"b57c6ee3-d26b-4a18-b63b-11831a8d2095"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Mounted at /content/drive\n"]}]},{"cell_type":"code","source":["import pandas as pd"],"metadata":{"id":"NJ2fqCzfSHrv"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["a = pd.read_csv(\"/content/drive/MyDrive/ingredient_analyze/ingredient_info.csv\", encoding='cp949')"],"metadata":{"id":"KXZ4JpIcSKgH","executionInfo":{"status":"ok","timestamp":1696584170768,"user_tz":-540,"elapsed":489,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":5,"outputs":[]},{"cell_type":"code","source":["a"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"i71E_JMgTBMn","executionInfo":{"status":"ok","timestamp":1696585887814,"user_tz":-540,"elapsed":25,"user":{"displayName":"신동혁","userId":"08556879536051936790"}},"outputId":"ecb3b3ab-f1c1-4419-fc83-9fa0550f4213"},"execution_count":42,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                     식품코드                       식품명 데이터구분코드   데이터구분명  식품기원코드  \\\n","0     R209-027074601-0000  소고기_한우(1+등급)_등심(윗등심살)_생것       R  원재료성 식품       2   \n","1     R209-027074701-0000   소고기_한우(1+등급)_사태(뒷사태)_생것       R  원재료성 식품       2   \n","2     R209-027074801-0000  소고기_한우(1+등급)_사태(뭉치사태)_생것       R  원재료성 식품       2   \n","3     R209-027074901-0000   소고기_한우(1+등급)_사태(상박살)_생것       R  원재료성 식품       2   \n","4     R209-027075001-0000  소고기_한우(1+등급)_사태(아롱사태)_생것       R  원재료성 식품       2   \n","...                   ...                       ...     ...      ...     ...   \n","3603  R211-715154001-0008        게류_붉은대게_육_생것_대표_8월       R  원재료성 식품       2   \n","3604  R211-715154301-0009        게류_붉은대게_알_생것_대표_9월       R  원재료성 식품       2   \n","3605  R220-027006001-0000                귀뚜라미_성충_생것       R  원재료성 식품       2   \n","3606  R101-001020101-0000              귀리_쌀귀리_도정_생것       R  원재료성 식품       1   \n","3607  R101-001010101-0000              귀리_겉귀리_도정_생것       R  원재료성 식품       1   \n","\n","     식품기원명  식품대분류코드        식품대분류명  대표식품코드 대표식품명  식품중분류코드    식품중분류명    식품소분류코드  \\\n","0      동물성        9            육류    9027   소고기   902707  한우(1+등급)   90270746   \n","1      동물성        9            육류    9027   소고기   902707  한우(1+등급)   90270747   \n","2      동물성        9            육류    9027   소고기   902707  한우(1+등급)   90270748   \n","3      동물성        9            육류    9027   소고기   902707  한우(1+등급)   90270749   \n","4      동물성        9            육류    9027   소고기   902707  한우(1+등급)   90270750   \n","...    ...      ...           ...     ...   ...      ...       ...        ...   \n","3603   동물성       11  어패류 및 기타 수산물   11715    게류  1171515      붉은대게  117151540   \n","3604   동물성       11  어패류 및 기타 수산물   11715    게류  1171515      붉은대게  117151543   \n","3605   동물성       20            기타   20027  귀뚜라미  2002700      해당없음  200270060   \n","3606   식물성        1            곡류    1001    귀리   100102       쌀귀리   10010201   \n","3607   식물성        1            곡류    1001    귀리   100101       겉귀리   10010101   \n","\n","        식품소분류명  식품세분류코드 식품세분류명 영양성분함량기준량  에너지(kcal)  수분(g)  단백질(g)  지방(g)  \\\n","0     등심(윗등심살)        1     생것      100g        339   54.6   16.98  28.45   \n","1      사태(뒷사태)        1     생것      100g        153   71.5   20.57   7.01   \n","2     사태(뭉치사태)        1     생것      100g        138   72.6   21.89   4.85   \n","3      사태(상박살)        1     생것      100g        211   66.8   20.12  13.38   \n","4     사태(아롱사태)        1     생것      100g        241   63.0   20.60  16.38   \n","...        ...      ...    ...       ...        ...    ...     ...    ...   \n","3603         육        1     생것      100g         66   84.2   10.88   2.14   \n","3604         알        1     생것      100g        143   69.9   16.78   4.42   \n","3605        성충        1     생것      100g        130   69.7   22.45   0.00   \n","3606        도정        1     생것      100g        388   11.6   11.14   8.90   \n","3607        도정        1     생것      100g        380   11.5   11.40   7.35   \n","\n","      회분(g)  탄수화물(g)  당류(g)  식이섬유(g)  칼슘(mg)  철(mg)  인(mg)  칼륨(mg)  나트륨(mg)  \\\n","0      0.70     0.00   0.00      0.0     4.0   2.38  134.0   237.0     41.0   \n","1      0.92     0.00   0.00      0.0     3.0   2.82  163.0   300.0     56.0   \n","2      0.99     0.00   0.00      0.0     3.0   2.89  185.0   323.0     48.0   \n","3      0.88     0.00   0.00      0.0     3.0   2.73  167.0   273.0     53.0   \n","4      0.80     0.00   0.00      0.0     4.0   2.56  159.0   235.0     62.0   \n","...     ...      ...    ...      ...     ...    ...    ...     ...      ...   \n","3603   2.78     0.05    NaN      NaN     NaN    NaN    NaN     NaN      NaN   \n","3604   1.43     7.45    NaN      NaN     NaN    NaN    NaN     NaN      NaN   \n","3605   1.47     3.39   0.00      3.1    85.0   1.23  310.0   323.0    121.0   \n","3606   1.70    66.66   0.91      8.1    61.0   4.31  409.0   405.0      1.0   \n","3607   2.00    67.71   0.32      NaN    80.0   2.93  308.0   458.0      0.0   \n","\n","      비타민 A(μg RAE)  레티놀(μg)  베타카로틴(μg)  티아민(mg)  리보플라빈(mg)  니아신(mg)  \\\n","0              12.0     12.0        0.0    0.043      0.150    2.159   \n","1               4.0      4.0        0.0    0.056      0.202    2.761   \n","2               3.0      3.0        0.0    0.060      0.182    3.078   \n","3               6.0      6.0        0.0    0.050      0.200    2.517   \n","4               5.0      5.0        0.0    0.048      0.169    2.292   \n","...             ...      ...        ...      ...        ...      ...   \n","3603            NaN      NaN        NaN      NaN        NaN      NaN   \n","3604            NaN      NaN        NaN      NaN        NaN      NaN   \n","3605            0.0      0.0        3.0    0.000      0.294    0.091   \n","3606            0.0      0.0        2.0    0.467      0.054    1.194   \n","3607            0.0      0.0        0.0    0.186      0.021      NaN   \n","\n","      비타민 C(mg)  비타민 D(μg)  콜레스테롤(mg)  포화지방산(g)  트랜스지방산(g)  폐기율(%)  출처코드  \\\n","0          1.07        0.0      79.54      9.31       0.55     0.0     1   \n","1          1.42        0.0      68.40      2.21       0.11     0.0     1   \n","2          0.91        0.0      52.06      1.38       0.06     0.0     1   \n","3          0.93        0.0      72.56      4.29       0.23     0.0     1   \n","4          0.93        0.0      79.45      5.05       0.22     0.0     1   \n","...         ...        ...        ...       ...        ...     ...   ...   \n","3603        NaN        NaN        NaN       NaN        NaN     NaN     2   \n","3604        NaN        NaN        NaN       NaN        NaN     NaN     2   \n","3605       0.00        0.0     159.10      1.20       0.12     0.0     1   \n","3606       0.00        0.0       0.00      1.45       0.01     0.0     1   \n","3607       0.00        NaN       0.00      1.14       0.00     0.0     1   \n","\n","                    출처명  원산지국코드 수입여부 데이터생성방법명 원산지국명 원산지역명  데이터생성방법코드  \\\n","0      농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","1      농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","2      농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","3      농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","4      농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","...                 ...     ...  ...      ...   ...   ...        ...   \n","3603  국립수산과학원(표준수산물성분표)   410.0    N       분석  대한민국    대표          1   \n","3604  국립수산과학원(표준수산물성분표)   410.0    N       분석  대한민국    대표          1   \n","3605   농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","3606   농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","3607   농촌진흥청(국가표준식품성분표)     NaN    N       분석  해당없음  해당없음          1   \n","\n","         데이터생성일자  생산·채취·포획월     데이터기준일자   제공기관코드          제공기관명  \n","0     2017-04-01        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","1     2017-04-01        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","2     2017-04-01        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","3     2017-04-01        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","4     2017-04-01        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","...          ...        ...         ...      ...            ...  \n","3603  2022-11-30        8.0  2023-07-07  1192266  해양수산부 국립수산과학원  \n","3604  2022-11-30        9.0  2023-07-07  1192266  해양수산부 국립수산과학원  \n","3605  2018-04-01        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","3606  2020-04-01        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","3607  2016-12-31        NaN  2023-06-26  1390802  농촌진흥청 국립농업과학원  \n","\n","[3608 rows x 55 columns]"],"text/html":["\n","  <div id=\"df-ee925576-e865-43ae-bffa-7dcdb9ddd7f5\" class=\"colab-df-container\">\n","    <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>데이터구분코드</th>\n","      <th>데이터구분명</th>\n","      <th>식품기원코드</th>\n","      <th>식품기원명</th>\n","      <th>식품대분류코드</th>\n","      <th>식품대분류명</th>\n","      <th>대표식품코드</th>\n","      <th>대표식품명</th>\n","      <th>식품중분류코드</th>\n","      <th>식품중분류명</th>\n","      <th>식품소분류코드</th>\n","      <th>식품소분류명</th>\n","      <th>식품세분류코드</th>\n","      <th>식품세분류명</th>\n","      <th>영양성분함량기준량</th>\n","      <th>에너지(kcal)</th>\n","      <th>수분(g)</th>\n","      <th>단백질(g)</th>\n","      <th>지방(g)</th>\n","      <th>회분(g)</th>\n","      <th>탄수화물(g)</th>\n","      <th>당류(g)</th>\n","      <th>식이섬유(g)</th>\n","      <th>칼슘(mg)</th>\n","      <th>철(mg)</th>\n","      <th>인(mg)</th>\n","      <th>칼륨(mg)</th>\n","      <th>나트륨(mg)</th>\n","      <th>비타민 A(μg RAE)</th>\n","      <th>레티놀(μg)</th>\n","      <th>베타카로틴(μg)</th>\n","      <th>티아민(mg)</th>\n","      <th>리보플라빈(mg)</th>\n","      <th>니아신(mg)</th>\n","      <th>비타민 C(mg)</th>\n","      <th>비타민 D(μg)</th>\n","      <th>콜레스테롤(mg)</th>\n","      <th>포화지방산(g)</th>\n","      <th>트랜스지방산(g)</th>\n","      <th>폐기율(%)</th>\n","      <th>출처코드</th>\n","      <th>출처명</th>\n","      <th>원산지국코드</th>\n","      <th>수입여부</th>\n","      <th>데이터생성방법명</th>\n","      <th>원산지국명</th>\n","      <th>원산지역명</th>\n","      <th>데이터생성방법코드</th>\n","      <th>데이터생성일자</th>\n","      <th>생산·채취·포획월</th>\n","      <th>데이터기준일자</th>\n","      <th>제공기관코드</th>\n","      <th>제공기관명</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>R209-027074601-0000</td>\n","      <td>소고기_한우(1+등급)_등심(윗등심살)_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>9</td>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","      <td>902707</td>\n","      <td>한우(1+등급)</td>\n","      <td>90270746</td>\n","      <td>등심(윗등심살)</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>339</td>\n","      <td>54.6</td>\n","      <td>16.98</td>\n","      <td>28.45</td>\n","      <td>0.70</td>\n","      <td>0.00</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>4.0</td>\n","      <td>2.38</td>\n","      <td>134.0</td>\n","      <td>237.0</td>\n","      <td>41.0</td>\n","      <td>12.0</td>\n","      <td>12.0</td>\n","      <td>0.0</td>\n","      <td>0.043</td>\n","      <td>0.150</td>\n","      <td>2.159</td>\n","      <td>1.07</td>\n","      <td>0.0</td>\n","      <td>79.54</td>\n","      <td>9.31</td>\n","      <td>0.55</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2017-04-01</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>R209-027074701-0000</td>\n","      <td>소고기_한우(1+등급)_사태(뒷사태)_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>9</td>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","      <td>902707</td>\n","      <td>한우(1+등급)</td>\n","      <td>90270747</td>\n","      <td>사태(뒷사태)</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>153</td>\n","      <td>71.5</td>\n","      <td>20.57</td>\n","      <td>7.01</td>\n","      <td>0.92</td>\n","      <td>0.00</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>3.0</td>\n","      <td>2.82</td>\n","      <td>163.0</td>\n","      <td>300.0</td>\n","      <td>56.0</td>\n","      <td>4.0</td>\n","      <td>4.0</td>\n","      <td>0.0</td>\n","      <td>0.056</td>\n","      <td>0.202</td>\n","      <td>2.761</td>\n","      <td>1.42</td>\n","      <td>0.0</td>\n","      <td>68.40</td>\n","      <td>2.21</td>\n","      <td>0.11</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2017-04-01</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>R209-027074801-0000</td>\n","      <td>소고기_한우(1+등급)_사태(뭉치사태)_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>9</td>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","      <td>902707</td>\n","      <td>한우(1+등급)</td>\n","      <td>90270748</td>\n","      <td>사태(뭉치사태)</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>138</td>\n","      <td>72.6</td>\n","      <td>21.89</td>\n","      <td>4.85</td>\n","      <td>0.99</td>\n","      <td>0.00</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>3.0</td>\n","      <td>2.89</td>\n","      <td>185.0</td>\n","      <td>323.0</td>\n","      <td>48.0</td>\n","      <td>3.0</td>\n","      <td>3.0</td>\n","      <td>0.0</td>\n","      <td>0.060</td>\n","      <td>0.182</td>\n","      <td>3.078</td>\n","      <td>0.91</td>\n","      <td>0.0</td>\n","      <td>52.06</td>\n","      <td>1.38</td>\n","      <td>0.06</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2017-04-01</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>R209-027074901-0000</td>\n","      <td>소고기_한우(1+등급)_사태(상박살)_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>9</td>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","      <td>902707</td>\n","      <td>한우(1+등급)</td>\n","      <td>90270749</td>\n","      <td>사태(상박살)</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>211</td>\n","      <td>66.8</td>\n","      <td>20.12</td>\n","      <td>13.38</td>\n","      <td>0.88</td>\n","      <td>0.00</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>3.0</td>\n","      <td>2.73</td>\n","      <td>167.0</td>\n","      <td>273.0</td>\n","      <td>53.0</td>\n","      <td>6.0</td>\n","      <td>6.0</td>\n","      <td>0.0</td>\n","      <td>0.050</td>\n","      <td>0.200</td>\n","      <td>2.517</td>\n","      <td>0.93</td>\n","      <td>0.0</td>\n","      <td>72.56</td>\n","      <td>4.29</td>\n","      <td>0.23</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2017-04-01</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>R209-027075001-0000</td>\n","      <td>소고기_한우(1+등급)_사태(아롱사태)_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>9</td>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","      <td>902707</td>\n","      <td>한우(1+등급)</td>\n","      <td>90270750</td>\n","      <td>사태(아롱사태)</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>241</td>\n","      <td>63.0</td>\n","      <td>20.60</td>\n","      <td>16.38</td>\n","      <td>0.80</td>\n","      <td>0.00</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>4.0</td>\n","      <td>2.56</td>\n","      <td>159.0</td>\n","      <td>235.0</td>\n","      <td>62.0</td>\n","      <td>5.0</td>\n","      <td>5.0</td>\n","      <td>0.0</td>\n","      <td>0.048</td>\n","      <td>0.169</td>\n","      <td>2.292</td>\n","      <td>0.93</td>\n","      <td>0.0</td>\n","      <td>79.45</td>\n","      <td>5.05</td>\n","      <td>0.22</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2017-04-01</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>3603</th>\n","      <td>R211-715154001-0008</td>\n","      <td>게류_붉은대게_육_생것_대표_8월</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>11</td>\n","      <td>어패류 및 기타 수산물</td>\n","      <td>11715</td>\n","      <td>게류</td>\n","      <td>1171515</td>\n","      <td>붉은대게</td>\n","      <td>117151540</td>\n","      <td>육</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>66</td>\n","      <td>84.2</td>\n","      <td>10.88</td>\n","      <td>2.14</td>\n","      <td>2.78</td>\n","      <td>0.05</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>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>2</td>\n","      <td>국립수산과학원(표준수산물성분표)</td>\n","      <td>410.0</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>대한민국</td>\n","      <td>대표</td>\n","      <td>1</td>\n","      <td>2022-11-30</td>\n","      <td>8.0</td>\n","      <td>2023-07-07</td>\n","      <td>1192266</td>\n","      <td>해양수산부 국립수산과학원</td>\n","    </tr>\n","    <tr>\n","      <th>3604</th>\n","      <td>R211-715154301-0009</td>\n","      <td>게류_붉은대게_알_생것_대표_9월</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>11</td>\n","      <td>어패류 및 기타 수산물</td>\n","      <td>11715</td>\n","      <td>게류</td>\n","      <td>1171515</td>\n","      <td>붉은대게</td>\n","      <td>117151543</td>\n","      <td>알</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>143</td>\n","      <td>69.9</td>\n","      <td>16.78</td>\n","      <td>4.42</td>\n","      <td>1.43</td>\n","      <td>7.45</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>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>2</td>\n","      <td>국립수산과학원(표준수산물성분표)</td>\n","      <td>410.0</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>대한민국</td>\n","      <td>대표</td>\n","      <td>1</td>\n","      <td>2022-11-30</td>\n","      <td>9.0</td>\n","      <td>2023-07-07</td>\n","      <td>1192266</td>\n","      <td>해양수산부 국립수산과학원</td>\n","    </tr>\n","    <tr>\n","      <th>3605</th>\n","      <td>R220-027006001-0000</td>\n","      <td>귀뚜라미_성충_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>2</td>\n","      <td>동물성</td>\n","      <td>20</td>\n","      <td>기타</td>\n","      <td>20027</td>\n","      <td>귀뚜라미</td>\n","      <td>2002700</td>\n","      <td>해당없음</td>\n","      <td>200270060</td>\n","      <td>성충</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>130</td>\n","      <td>69.7</td>\n","      <td>22.45</td>\n","      <td>0.00</td>\n","      <td>1.47</td>\n","      <td>3.39</td>\n","      <td>0.00</td>\n","      <td>3.1</td>\n","      <td>85.0</td>\n","      <td>1.23</td>\n","      <td>310.0</td>\n","      <td>323.0</td>\n","      <td>121.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>3.0</td>\n","      <td>0.000</td>\n","      <td>0.294</td>\n","      <td>0.091</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>159.10</td>\n","      <td>1.20</td>\n","      <td>0.12</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2018-04-01</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","    <tr>\n","      <th>3606</th>\n","      <td>R101-001020101-0000</td>\n","      <td>귀리_쌀귀리_도정_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>1</td>\n","      <td>식물성</td>\n","      <td>1</td>\n","      <td>곡류</td>\n","      <td>1001</td>\n","      <td>귀리</td>\n","      <td>100102</td>\n","      <td>쌀귀리</td>\n","      <td>10010201</td>\n","      <td>도정</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>388</td>\n","      <td>11.6</td>\n","      <td>11.14</td>\n","      <td>8.90</td>\n","      <td>1.70</td>\n","      <td>66.66</td>\n","      <td>0.91</td>\n","      <td>8.1</td>\n","      <td>61.0</td>\n","      <td>4.31</td>\n","      <td>409.0</td>\n","      <td>405.0</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>2.0</td>\n","      <td>0.467</td>\n","      <td>0.054</td>\n","      <td>1.194</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>0.00</td>\n","      <td>1.45</td>\n","      <td>0.01</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2020-04-01</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","    <tr>\n","      <th>3607</th>\n","      <td>R101-001010101-0000</td>\n","      <td>귀리_겉귀리_도정_생것</td>\n","      <td>R</td>\n","      <td>원재료성 식품</td>\n","      <td>1</td>\n","      <td>식물성</td>\n","      <td>1</td>\n","      <td>곡류</td>\n","      <td>1001</td>\n","      <td>귀리</td>\n","      <td>100101</td>\n","      <td>겉귀리</td>\n","      <td>10010101</td>\n","      <td>도정</td>\n","      <td>1</td>\n","      <td>생것</td>\n","      <td>100g</td>\n","      <td>380</td>\n","      <td>11.5</td>\n","      <td>11.40</td>\n","      <td>7.35</td>\n","      <td>2.00</td>\n","      <td>67.71</td>\n","      <td>0.32</td>\n","      <td>NaN</td>\n","      <td>80.0</td>\n","      <td>2.93</td>\n","      <td>308.0</td>\n","      <td>458.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.186</td>\n","      <td>0.021</td>\n","      <td>NaN</td>\n","      <td>0.00</td>\n","      <td>NaN</td>\n","      <td>0.00</td>\n","      <td>1.14</td>\n","      <td>0.00</td>\n","      <td>0.0</td>\n","      <td>1</td>\n","      <td>농촌진흥청(국가표준식품성분표)</td>\n","      <td>NaN</td>\n","      <td>N</td>\n","      <td>분석</td>\n","      <td>해당없음</td>\n","      <td>해당없음</td>\n","      <td>1</td>\n","      <td>2016-12-31</td>\n","      <td>NaN</td>\n","      <td>2023-06-26</td>\n","      <td>1390802</td>\n","      <td>농촌진흥청 국립농업과학원</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>3608 rows × 55 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ee925576-e865-43ae-bffa-7dcdb9ddd7f5')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-ee925576-e865-43ae-bffa-7dcdb9ddd7f5 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-ee925576-e865-43ae-bffa-7dcdb9ddd7f5');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-efce330b-4f1f-4827-a581-cedfe7bcacad\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-efce330b-4f1f-4827-a581-cedfe7bcacad')\"\n","            title=\"Suggest charts.\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-efce330b-4f1f-4827-a581-cedfe7bcacad button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":42}]},{"cell_type":"code","source":["selected_columns = a.iloc[:, [7,8,9]]"],"metadata":{"id":"Dz25wpN-Tq6q","executionInfo":{"status":"ok","timestamp":1696584787867,"user_tz":-540,"elapsed":292,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":16,"outputs":[]},{"cell_type":"code","source":["selected_columns"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"Onr7cOUvVGXC","executionInfo":{"status":"ok","timestamp":1696585874858,"user_tz":-540,"elapsed":14,"user":{"displayName":"신동혁","userId":"08556879536051936790"}},"outputId":"e1cb68dd-b092-4e39-82c8-02974f72d113"},"execution_count":41,"outputs":[{"output_type":"execute_result","data":{"text/plain":["            식품대분류명  대표식품코드 대표식품명\n","0               육류    9027   소고기\n","1               육류    9027   소고기\n","2               육류    9027   소고기\n","3               육류    9027   소고기\n","4               육류    9027   소고기\n","...            ...     ...   ...\n","3603  어패류 및 기타 수산물   11715    게류\n","3604  어패류 및 기타 수산물   11715    게류\n","3605            기타   20027  귀뚜라미\n","3606            곡류    1001    귀리\n","3607            곡류    1001    귀리\n","\n","[3608 rows x 3 columns]"],"text/html":["\n","  <div id=\"df-838cd031-6071-4ca7-87ae-24ca99f94224\" class=\"colab-df-container\">\n","    <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>대표식품명</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>육류</td>\n","      <td>9027</td>\n","      <td>소고기</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>3603</th>\n","      <td>어패류 및 기타 수산물</td>\n","      <td>11715</td>\n","      <td>게류</td>\n","    </tr>\n","    <tr>\n","      <th>3604</th>\n","      <td>어패류 및 기타 수산물</td>\n","      <td>11715</td>\n","      <td>게류</td>\n","    </tr>\n","    <tr>\n","      <th>3605</th>\n","      <td>기타</td>\n","      <td>20027</td>\n","      <td>귀뚜라미</td>\n","    </tr>\n","    <tr>\n","      <th>3606</th>\n","      <td>곡류</td>\n","      <td>1001</td>\n","      <td>귀리</td>\n","    </tr>\n","    <tr>\n","      <th>3607</th>\n","      <td>곡류</td>\n","      <td>1001</td>\n","      <td>귀리</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>3608 rows × 3 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-838cd031-6071-4ca7-87ae-24ca99f94224')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-838cd031-6071-4ca7-87ae-24ca99f94224 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-838cd031-6071-4ca7-87ae-24ca99f94224');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-3bb18ea6-6d4f-4086-a6e6-878f1077401b\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3bb18ea6-6d4f-4086-a6e6-878f1077401b')\"\n","            title=\"Suggest charts.\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-3bb18ea6-6d4f-4086-a6e6-878f1077401b button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":41}]},{"cell_type":"code","source":["sorted_columns = selected_columns.sort_values(by='식품대분류명')"],"metadata":{"id":"HXEjPJ0PVsdi","executionInfo":{"status":"ok","timestamp":1696584992627,"user_tz":-540,"elapsed":442,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":22,"outputs":[]},{"cell_type":"code","source":["pd.set_option('display.max_rows', 100)  # 최대 100개의 행까지만 보여주기\n","pd.set_option('display.max_columns', None)  # 모든 열 보여주기"],"metadata":{"id":"nEjbWOECWebh","executionInfo":{"status":"ok","timestamp":1696585228127,"user_tz":-540,"elapsed":306,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":28,"outputs":[]},{"cell_type":"code","source":["sorted_columns"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"-NzZa0htWJ1c","executionInfo":{"status":"ok","timestamp":1696585868361,"user_tz":-540,"elapsed":8,"user":{"displayName":"신동혁","userId":"08556879536051936790"}},"outputId":"379ba993-250c-46c5-c820-da1fad44ba91"},"execution_count":40,"outputs":[{"output_type":"execute_result","data":{"text/plain":["        식품대분류명  대표식품코드 대표식품명\n","1726  감자 및 전분류    2010  돼지감자\n","1748  감자 및 전분류    2001    감자\n","1749  감자 및 전분류    2001    감자\n","1750  감자 및 전분류    2001    감자\n","1751  감자 및 전분류    2001    감자\n","...        ...     ...   ...\n","3006       해조류   12827  모자반류\n","3005       해조류   12827  모자반류\n","3004       해조류   12827  모자반류\n","3002       해조류   12825   매생이\n","2162       해조류   12819  다시마류\n","\n","[3608 rows x 3 columns]"],"text/html":["\n","  <div id=\"df-72f688e1-8996-41af-909e-b1e369754324\" class=\"colab-df-container\">\n","    <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>대표식품명</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1726</th>\n","      <td>감자 및 전분류</td>\n","      <td>2010</td>\n","      <td>돼지감자</td>\n","    </tr>\n","    <tr>\n","      <th>1748</th>\n","      <td>감자 및 전분류</td>\n","      <td>2001</td>\n","      <td>감자</td>\n","    </tr>\n","    <tr>\n","      <th>1749</th>\n","      <td>감자 및 전분류</td>\n","      <td>2001</td>\n","      <td>감자</td>\n","    </tr>\n","    <tr>\n","      <th>1750</th>\n","      <td>감자 및 전분류</td>\n","      <td>2001</td>\n","      <td>감자</td>\n","    </tr>\n","    <tr>\n","      <th>1751</th>\n","      <td>감자 및 전분류</td>\n","      <td>2001</td>\n","      <td>감자</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>3006</th>\n","      <td>해조류</td>\n","      <td>12827</td>\n","      <td>모자반류</td>\n","    </tr>\n","    <tr>\n","      <th>3005</th>\n","      <td>해조류</td>\n","      <td>12827</td>\n","      <td>모자반류</td>\n","    </tr>\n","    <tr>\n","      <th>3004</th>\n","      <td>해조류</td>\n","      <td>12827</td>\n","      <td>모자반류</td>\n","    </tr>\n","    <tr>\n","      <th>3002</th>\n","      <td>해조류</td>\n","      <td>12825</td>\n","      <td>매생이</td>\n","    </tr>\n","    <tr>\n","      <th>2162</th>\n","      <td>해조류</td>\n","      <td>12819</td>\n","      <td>다시마류</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>3608 rows × 3 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-72f688e1-8996-41af-909e-b1e369754324')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-72f688e1-8996-41af-909e-b1e369754324 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-72f688e1-8996-41af-909e-b1e369754324');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-62eb88d9-35f3-42a9-a5ba-3489320d6a59\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-62eb88d9-35f3-42a9-a5ba-3489320d6a59')\"\n","            title=\"Suggest charts.\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-62eb88d9-35f3-42a9-a5ba-3489320d6a59 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":40}]},{"cell_type":"markdown","source":["현재 \"식품대분류명\"을 기준으로 정렬 완료 되었다."],"metadata":{"id":"UJXVfwJ1XKGQ"}},{"cell_type":"code","source":["sorted_columns_unique = sorted_columns.drop_duplicates() #\"식품대분류명\", \"대표식품코드\", \"대표식품명\" 열을 기준으로 중복이 제거된 상태로 출력"],"metadata":{"id":"PjgumWh1WwuD","executionInfo":{"status":"ok","timestamp":1696585453238,"user_tz":-540,"elapsed":310,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":30,"outputs":[]},{"cell_type":"code","source":["sorted_columns_unique"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"9Xr_6Re0X5np","executionInfo":{"status":"ok","timestamp":1696585856212,"user_tz":-540,"elapsed":21,"user":{"displayName":"신동혁","userId":"08556879536051936790"}},"outputId":"9a9df951-ec95-4c31-b64e-eabf65e14533"},"execution_count":39,"outputs":[{"output_type":"execute_result","data":{"text/plain":["        식품대분류명  대표식품코드     대표식품명\n","1726  감자 및 전분류    2010      돼지감자\n","1748  감자 및 전분류    2001        감자\n","678   감자 및 전분류    2006       고구마\n","663   감자 및 전분류    2005      으깬감자\n","1701  감자 및 전분류    2009  곤약(구약나물)\n","...        ...     ...       ...\n","2994       해조류   12815     꼬시래기류\n","2985       해조류   12811      갈래곰보\n","3001       해조류   12823       뜸부기\n","3020       해조류   12839        순채\n","3019       해조류   12837        석묵\n","\n","[716 rows x 3 columns]"],"text/html":["\n","  <div id=\"df-0ba8cf13-b8b5-425d-8adf-b0a764d1ffe4\" class=\"colab-df-container\">\n","    <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>대표식품명</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1726</th>\n","      <td>감자 및 전분류</td>\n","      <td>2010</td>\n","      <td>돼지감자</td>\n","    </tr>\n","    <tr>\n","      <th>1748</th>\n","      <td>감자 및 전분류</td>\n","      <td>2001</td>\n","      <td>감자</td>\n","    </tr>\n","    <tr>\n","      <th>678</th>\n","      <td>감자 및 전분류</td>\n","      <td>2006</td>\n","      <td>고구마</td>\n","    </tr>\n","    <tr>\n","      <th>663</th>\n","      <td>감자 및 전분류</td>\n","      <td>2005</td>\n","      <td>으깬감자</td>\n","    </tr>\n","    <tr>\n","      <th>1701</th>\n","      <td>감자 및 전분류</td>\n","      <td>2009</td>\n","      <td>곤약(구약나물)</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>2994</th>\n","      <td>해조류</td>\n","      <td>12815</td>\n","      <td>꼬시래기류</td>\n","    </tr>\n","    <tr>\n","      <th>2985</th>\n","      <td>해조류</td>\n","      <td>12811</td>\n","      <td>갈래곰보</td>\n","    </tr>\n","    <tr>\n","      <th>3001</th>\n","      <td>해조류</td>\n","      <td>12823</td>\n","      <td>뜸부기</td>\n","    </tr>\n","    <tr>\n","      <th>3020</th>\n","      <td>해조류</td>\n","      <td>12839</td>\n","      <td>순채</td>\n","    </tr>\n","    <tr>\n","      <th>3019</th>\n","      <td>해조류</td>\n","      <td>12837</td>\n","      <td>석묵</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>716 rows × 3 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0ba8cf13-b8b5-425d-8adf-b0a764d1ffe4')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-0ba8cf13-b8b5-425d-8adf-b0a764d1ffe4 button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-0ba8cf13-b8b5-425d-8adf-b0a764d1ffe4');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-51ca2d02-a16f-4d79-adc5-942d1d662c66\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-51ca2d02-a16f-4d79-adc5-942d1d662c66')\"\n","            title=\"Suggest charts.\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-51ca2d02-a16f-4d79-adc5-942d1d662c66 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":39}]},{"cell_type":"code","source":["selected_columns_2 = sorted_columns_unique.iloc[:, [0,2]]"],"metadata":{"id":"jHAawM4fY2mU","executionInfo":{"status":"ok","timestamp":1696586359295,"user_tz":-540,"elapsed":450,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":50,"outputs":[]},{"cell_type":"code","source":["# 행 번호 재설정\n","selected_columns_2.reset_index(drop=True, inplace=True)\n"],"metadata":{"id":"faXIpdXTa-wH","executionInfo":{"status":"ok","timestamp":1696586346144,"user_tz":-540,"elapsed":405,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":48,"outputs":[]},{"cell_type":"code","source":["selected_columns_2"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":423},"id":"4YR2MmL-bOtS","executionInfo":{"status":"ok","timestamp":1696586375230,"user_tz":-540,"elapsed":409,"user":{"displayName":"신동혁","userId":"08556879536051936790"}},"outputId":"f4b69921-2b98-4816-a2a5-1a96aa886059"},"execution_count":52,"outputs":[{"output_type":"execute_result","data":{"text/plain":["       식품대분류명     대표식품명\n","0    감자 및 전분류      돼지감자\n","1    감자 및 전분류        감자\n","2    감자 및 전분류       고구마\n","3    감자 및 전분류      으깬감자\n","4    감자 및 전분류  곤약(구약나물)\n","..        ...       ...\n","711       해조류     꼬시래기류\n","712       해조류      갈래곰보\n","713       해조류       뜸부기\n","714       해조류        순채\n","715       해조류        석묵\n","\n","[716 rows x 2 columns]"],"text/html":["\n","  <div id=\"df-38f8e9a5-0460-427a-aad3-d1d8e432509d\" class=\"colab-df-container\">\n","    <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","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>감자 및 전분류</td>\n","      <td>돼지감자</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>감자 및 전분류</td>\n","      <td>감자</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>감자 및 전분류</td>\n","      <td>고구마</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>감자 및 전분류</td>\n","      <td>으깬감자</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>감자 및 전분류</td>\n","      <td>곤약(구약나물)</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>711</th>\n","      <td>해조류</td>\n","      <td>꼬시래기류</td>\n","    </tr>\n","    <tr>\n","      <th>712</th>\n","      <td>해조류</td>\n","      <td>갈래곰보</td>\n","    </tr>\n","    <tr>\n","      <th>713</th>\n","      <td>해조류</td>\n","      <td>뜸부기</td>\n","    </tr>\n","    <tr>\n","      <th>714</th>\n","      <td>해조류</td>\n","      <td>순채</td>\n","    </tr>\n","    <tr>\n","      <th>715</th>\n","      <td>해조류</td>\n","      <td>석묵</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>716 rows × 2 columns</p>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-38f8e9a5-0460-427a-aad3-d1d8e432509d')\"\n","            title=\"Convert this dataframe to an interactive table.\"\n","            style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    .colab-df-buttons div {\n","      margin-bottom: 4px;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","    <script>\n","      const buttonEl =\n","        document.querySelector('#df-38f8e9a5-0460-427a-aad3-d1d8e432509d button.colab-df-convert');\n","      buttonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","      async function convertToInteractive(key) {\n","        const element = document.querySelector('#df-38f8e9a5-0460-427a-aad3-d1d8e432509d');\n","        const dataTable =\n","          await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                    [key], {});\n","        if (!dataTable) return;\n","\n","        const docLinkHtml = 'Like what you see? Visit the ' +\n","          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","          + ' to learn more about interactive tables.';\n","        element.innerHTML = '';\n","        dataTable['output_type'] = 'display_data';\n","        await google.colab.output.renderOutput(dataTable, element);\n","        const docLink = document.createElement('div');\n","        docLink.innerHTML = docLinkHtml;\n","        element.appendChild(docLink);\n","      }\n","    </script>\n","  </div>\n","\n","\n","<div id=\"df-4522e898-cd85-4744-a418-bcd0c71e87e2\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4522e898-cd85-4744-a418-bcd0c71e87e2')\"\n","            title=\"Suggest charts.\"\n","            style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-4522e898-cd85-4744-a418-bcd0c71e87e2 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":52}]},{"cell_type":"code","source":["selected_columns_2.to_csv('analyzed_ingredient.csv')"],"metadata":{"id":"eXcapNG-Z5xv","executionInfo":{"status":"ok","timestamp":1696586387859,"user_tz":-540,"elapsed":443,"user":{"displayName":"신동혁","userId":"08556879536051936790"}}},"execution_count":53,"outputs":[]}]}