data_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['P1', 'P2', 'P3', 'P4', 'P5', 'P6', 'P7', 'B1', 'B2', 'B3',\n",
       "       ...\n",
       "       'B165', 'B166', 'B167', 'C1', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6'],\n",
       "      dtype='object', length=181)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"./data_055.csv\", encoding='cp949')\n",
    "new_df = pd.DataFrame();\n",
    "\n",
    "# 현재 데이터셋의 칼럼 유형\n",
    "df.keys()"
   ]
  },
  {
   "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>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P7</th>\n",
       "      <th>B1</th>\n",
       "      <th>B2</th>\n",
       "      <th>B3</th>\n",
       "      <th>...</th>\n",
       "      <th>B165</th>\n",
       "      <th>B166</th>\n",
       "      <th>B167</th>\n",
       "      <th>C1</th>\n",
       "      <th>E1</th>\n",
       "      <th>E2</th>\n",
       "      <th>E3</th>\n",
       "      <th>E4</th>\n",
       "      <th>E5</th>\n",
       "      <th>E6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4350000</td>\n",
       "      <td>210</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11111111110</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>1100000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M</td>\n",
       "      <td>50대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>580000</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111110111111</td>\n",
       "      <td>10000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1950000</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>1101101111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111101101111</td>\n",
       "      <td>101101101111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>F</td>\n",
       "      <td>60대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43000000</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M</td>\n",
       "      <td>30대_후</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4910000</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473225</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_초</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>650000</td>\n",
       "      <td>30</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>10001001100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111101</td>\n",
       "      <td>10111111100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473226</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4790000</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>110110000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111110</td>\n",
       "      <td>111111111000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473227</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1650000</td>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>100100011</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473228</th>\n",
       "      <td>M</td>\n",
       "      <td>60대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1340000</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>100101000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>110101111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473229</th>\n",
       "      <td>F</td>\n",
       "      <td>50대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>750000</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11001001000</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>473230 rows × 181 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       P1     P2  P3  P4  P5  P6   P7  B1  B2  B3  ...  B165  B166      B167  \\\n",
       "0       M  20대_후   1   1   0   0  A은행   0   0   0  ...     0     0   4350000   \n",
       "1       M  50대_후   1   0   0   0  A은행   0   0   0  ...     0     0    580000   \n",
       "2       M  40대_후   1   1   0   0  A은행   0   0   0  ...     0     0   1950000   \n",
       "3       F  60대_초   1   1   0   0  A은행   0   0   0  ...     0     0  43000000   \n",
       "4       M  30대_후   0   1   0   0  B은행   0   0   0  ...     0     0   4910000   \n",
       "...    ..    ...  ..  ..  ..  ..  ...  ..  ..  ..  ...   ...   ...       ...   \n",
       "473225  F  40대_초   0   1   0   1  B은행   0   0   0  ...     0     0    650000   \n",
       "473226  M  20대_후   1   1   0   0  A은행   0   0   0  ...     0     0   4790000   \n",
       "473227  F  40대_후   1   1   1   0  B은행   0   0   0  ...     0     0   1650000   \n",
       "473228  M  60대_후   1   1   1   0  A은행   0   0   0  ...     0     0   1340000   \n",
       "473229  F  50대_초   1   0   0   0  B은행   0   0   0  ...     0     0    750000   \n",
       "\n",
       "         C1            E1            E2           E3  E4            E5  \\\n",
       "0       210             0             0  11111111110   0  111111111111   \n",
       "1        40             0             0            0   0  111110111111   \n",
       "2        50             0    1101101111            0   0  111101101111   \n",
       "3        50             0             0            0   0  111111111111   \n",
       "4        40             0  111111111111            0   0  111111111111   \n",
       "...     ...           ...           ...          ...  ..           ...   \n",
       "473225   30  111111111111   10001001100            0   0  111111111101   \n",
       "473226   50             0  110110000000            0   0  111111111110   \n",
       "473227   60             0     100100011            0   0  111111111111   \n",
       "473228   50             0     100101000            0   0  111111111111   \n",
       "473229   30             0          1000            0   0   11001001000   \n",
       "\n",
       "                  E6  \n",
       "0         1100000000  \n",
       "1        10000000000  \n",
       "2       101101101111  \n",
       "3       111111111111  \n",
       "4       111111111111  \n",
       "...              ...  \n",
       "473225   10111111100  \n",
       "473226  111111111000  \n",
       "473227  111111111111  \n",
       "473228  110101111111  \n",
       "473229          1000  \n",
       "\n",
       "[473230 rows x 181 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 새로운 데이터셋의 칼럼 유형\n",
    "# P1, P2, Age(int형으로 전환 -> 오름차순 정렬), P3, P4, P5, P6, P7, 총가계지출, 식료품비, 주거비, 가구/가사용품비, 의류/신발비, 보건의료비, 교양오락비, 교통/통신비, 교육비, 세금, 자가소비액, 기타, E1, E2, E3, E4, E5, E6\n",
    "\n",
    "new_df = pd.DataFrame();\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P7</th>\n",
       "      <th>E1</th>\n",
       "      <th>E2</th>\n",
       "      <th>E3</th>\n",
       "      <th>E4</th>\n",
       "      <th>E5</th>\n",
       "      <th>E6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11111111110</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>1100000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M</td>\n",
       "      <td>50대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111110111111</td>\n",
       "      <td>10000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>1101101111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111101101111</td>\n",
       "      <td>101101101111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>F</td>\n",
       "      <td>60대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M</td>\n",
       "      <td>30대_후</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473225</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_초</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>B은행</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>10001001100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111101</td>\n",
       "      <td>10111111100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473226</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>110110000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111110</td>\n",
       "      <td>111111111000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473227</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>100100011</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473228</th>\n",
       "      <td>M</td>\n",
       "      <td>60대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>100101000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>110101111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473229</th>\n",
       "      <td>F</td>\n",
       "      <td>50대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11001001000</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>473230 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       P1     P2  P3  P4  P5  P6   P7            E1            E2  \\\n",
       "0       M  20대_후   1   1   0   0  A은행             0             0   \n",
       "1       M  50대_후   1   0   0   0  A은행             0             0   \n",
       "2       M  40대_후   1   1   0   0  A은행             0    1101101111   \n",
       "3       F  60대_초   1   1   0   0  A은행             0             0   \n",
       "4       M  30대_후   0   1   0   0  B은행             0  111111111111   \n",
       "...    ..    ...  ..  ..  ..  ..  ...           ...           ...   \n",
       "473225  F  40대_초   0   1   0   1  B은행  111111111111   10001001100   \n",
       "473226  M  20대_후   1   1   0   0  A은행             0  110110000000   \n",
       "473227  F  40대_후   1   1   1   0  B은행             0     100100011   \n",
       "473228  M  60대_후   1   1   1   0  A은행             0     100101000   \n",
       "473229  F  50대_초   1   0   0   0  B은행             0          1000   \n",
       "\n",
       "                 E3  E4            E5            E6  \n",
       "0       11111111110   0  111111111111    1100000000  \n",
       "1                 0   0  111110111111   10000000000  \n",
       "2                 0   0  111101101111  101101101111  \n",
       "3                 0   0  111111111111  111111111111  \n",
       "4                 0   0  111111111111  111111111111  \n",
       "...             ...  ..           ...           ...  \n",
       "473225            0   0  111111111101   10111111100  \n",
       "473226            0   0  111111111110  111111111000  \n",
       "473227            0   0  111111111111  111111111111  \n",
       "473228            0   0  111111111111  110101111111  \n",
       "473229            0   0   11001001000          1000  \n",
       "\n",
       "[473230 rows x 13 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 기존 데이터셋 copy\n",
    "new_df = df[['P1', 'P2', 'P3', 'P4', 'P5', 'P6', 'P7', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6']].copy()\n",
    "\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['P1', 'P2', 'P3', 'P4', 'P5', 'P6', 'P7', 'E1', 'E2', 'E3', 'E4', 'E5',\n",
      "       'E6', 'Age'],\n",
      "      dtype='object')\n"
     ]
    },
    {
     "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>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P7</th>\n",
       "      <th>E1</th>\n",
       "      <th>E2</th>\n",
       "      <th>E3</th>\n",
       "      <th>E4</th>\n",
       "      <th>E5</th>\n",
       "      <th>E6</th>\n",
       "      <th>Age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11111111110</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>1100000000</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M</td>\n",
       "      <td>50대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111110111111</td>\n",
       "      <td>10000000000</td>\n",
       "      <td>59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>1101101111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111101101111</td>\n",
       "      <td>101101101111</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>F</td>\n",
       "      <td>60대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>60.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M</td>\n",
       "      <td>30대_후</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>39.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473225</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_초</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>B은행</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>10001001100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111101</td>\n",
       "      <td>10111111100</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473226</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>110110000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111110</td>\n",
       "      <td>111111111000</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473227</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>100100011</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473228</th>\n",
       "      <td>M</td>\n",
       "      <td>60대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>100101000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>110101111111</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473229</th>\n",
       "      <td>F</td>\n",
       "      <td>50대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11001001000</td>\n",
       "      <td>1000</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>473230 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       P1     P2  P3  P4  P5  P6   P7            E1            E2  \\\n",
       "0       M  20대_후   1   1   0   0  A은행             0             0   \n",
       "1       M  50대_후   1   0   0   0  A은행             0             0   \n",
       "2       M  40대_후   1   1   0   0  A은행             0    1101101111   \n",
       "3       F  60대_초   1   1   0   0  A은행             0             0   \n",
       "4       M  30대_후   0   1   0   0  B은행             0  111111111111   \n",
       "...    ..    ...  ..  ..  ..  ..  ...           ...           ...   \n",
       "473225  F  40대_초   0   1   0   1  B은행  111111111111   10001001100   \n",
       "473226  M  20대_후   1   1   0   0  A은행             0  110110000000   \n",
       "473227  F  40대_후   1   1   1   0  B은행             0     100100011   \n",
       "473228  M  60대_후   1   1   1   0  A은행             0     100101000   \n",
       "473229  F  50대_초   1   0   0   0  B은행             0          1000   \n",
       "\n",
       "                 E3  E4            E5            E6   Age  \n",
       "0       11111111110   0  111111111111    1100000000  29.0  \n",
       "1                 0   0  111110111111   10000000000  59.0  \n",
       "2                 0   0  111101101111  101101101111  49.0  \n",
       "3                 0   0  111111111111  111111111111  60.0  \n",
       "4                 0   0  111111111111  111111111111  39.0  \n",
       "...             ...  ..           ...           ...   ...  \n",
       "473225            0   0  111111111101   10111111100  40.0  \n",
       "473226            0   0  111111111110  111111111000  29.0  \n",
       "473227            0   0  111111111111  111111111111  49.0  \n",
       "473228            0   0  111111111111  110101111111  69.0  \n",
       "473229            0   0   11001001000          1000  50.0  \n",
       "\n",
       "[473230 rows x 14 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 고객 이용 연령층\n",
    "# new_df에 Age 칼럼 추가: ex. 20대_초 -> 20, 20대_후 -> 29\n",
    "early_20s = 0\n",
    "lately_20s = 0\n",
    "early_30s = 0\n",
    "lately_30s = 0\n",
    "early_40s = 0\n",
    "lately_40s = 0\n",
    "early_50s = 0\n",
    "lately_50s = 0\n",
    "early_60s = 0\n",
    "lately_60s = 0\n",
    "else_thing = 0\n",
    "\n",
    "for i in df.index.tolist():\n",
    "    if (df.loc[i, \"P2\"] == \"20대_초\"):\n",
    "        new_df.loc[i, \"Age\"] = 20\n",
    "    elif (df.loc[i, \"P2\"] == \"20대_후\"):\n",
    "        new_df.loc[i, \"Age\"] = 29\n",
    "    elif (df.loc[i, \"P2\"] == \"30대_초\"):\n",
    "        new_df.loc[i, \"Age\"] = 30\n",
    "    elif (df.loc[i, \"P2\"] == \"30대_후\"):\n",
    "        new_df.loc[i, \"Age\"] = 39\n",
    "    elif (df.loc[i, \"P2\"] == \"40대_초\"):\n",
    "        new_df.loc[i, \"Age\"] = 40\n",
    "    elif (df.loc[i, \"P2\"] == \"40대_후\"):\n",
    "        new_df.loc[i, \"Age\"] = 49\n",
    "    elif (df.loc[i, \"P2\"] == \"50대_초\"):\n",
    "        new_df.loc[i, \"Age\"] = 50\n",
    "    elif (df.loc[i, \"P2\"] == \"50대_후\"):\n",
    "        new_df.loc[i, \"Age\"] = 59\n",
    "    elif (df.loc[i, \"P2\"] == \"60대_초\"):\n",
    "        new_df.loc[i, \"Age\"] = 60\n",
    "    elif (df.loc[i, \"P2\"] == \"60대_후\"):\n",
    "        new_df.loc[i, \"Age\"] = 69  \n",
    "        \n",
    "print(new_df.keys())\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P7</th>\n",
       "      <th>E1</th>\n",
       "      <th>E2</th>\n",
       "      <th>E3</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>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11111111110</td>\n",
       "      <td>...</td>\n",
       "      <td>1190000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>717000.0</td>\n",
       "      <td>31000.0</td>\n",
       "      <td>250000.0</td>\n",
       "      <td>925000.0</td>\n",
       "      <td>78000.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>M</td>\n",
       "      <td>50대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>188000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>159000.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>1000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>1101101111</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>291000.0</td>\n",
       "      <td>260000.0</td>\n",
       "      <td>13000.0</td>\n",
       "      <td>237000.0</td>\n",
       "      <td>523000.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>F</td>\n",
       "      <td>60대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42985000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M</td>\n",
       "      <td>30대_후</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>943000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473225</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_초</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>B은행</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>10001001100</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150000.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>473226</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>110110000000</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>126000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>82000.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>292000.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>473227</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>100100011</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>253000.0</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>172000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>164000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473228</th>\n",
       "      <td>M</td>\n",
       "      <td>60대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>0</td>\n",
       "      <td>100101000</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>193000.0</td>\n",
       "      <td>82000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>234000.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>473229</th>\n",
       "      <td>F</td>\n",
       "      <td>50대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>0</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>52000.0</td>\n",
       "      <td>92000.0</td>\n",
       "      <td>314000.0</td>\n",
       "      <td>87000.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",
       "<p>473230 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       P1     P2  P3  P4  P5  P6   P7            E1            E2  \\\n",
       "0       M  20대_후   1   1   0   0  A은행             0             0   \n",
       "1       M  50대_후   1   0   0   0  A은행             0             0   \n",
       "2       M  40대_후   1   1   0   0  A은행             0    1101101111   \n",
       "3       F  60대_초   1   1   0   0  A은행             0             0   \n",
       "4       M  30대_후   0   1   0   0  B은행             0  111111111111   \n",
       "...    ..    ...  ..  ..  ..  ..  ...           ...           ...   \n",
       "473225  F  40대_초   0   1   0   1  B은행  111111111111   10001001100   \n",
       "473226  M  20대_후   1   1   0   0  A은행             0  110110000000   \n",
       "473227  F  40대_후   1   1   1   0  B은행             0     100100011   \n",
       "473228  M  60대_후   1   1   1   0  A은행             0     100101000   \n",
       "473229  F  50대_초   1   0   0   0  B은행             0          1000   \n",
       "\n",
       "                 E3  ...       식료품비  가구/가사용품비    의류/신발비     보건의료비     교양오락비  \\\n",
       "0       11111111110  ...  1190000.0       0.0  717000.0   31000.0  250000.0   \n",
       "1                 0  ...   188000.0       0.0  159000.0       0.0       0.0   \n",
       "2                 0  ...   117000.0       0.0  291000.0  260000.0   13000.0   \n",
       "3                 0  ...    14000.0       0.0       0.0       0.0    2000.0   \n",
       "4                 0  ...        0.0       0.0       0.0    6000.0       0.0   \n",
       "...             ...  ...        ...       ...       ...       ...       ...   \n",
       "473225            0  ...     9000.0       0.0       0.0   50000.0       0.0   \n",
       "473226            0  ...   126000.0       0.0  125000.0   82000.0  117000.0   \n",
       "473227            0  ...   253000.0   20000.0  172000.0       0.0   25000.0   \n",
       "473228            0  ...   193000.0   82000.0   36000.0       0.0       0.0   \n",
       "473229            0  ...   105000.0   52000.0   92000.0  314000.0   87000.0   \n",
       "\n",
       "          교통/통신비       교육비          세금  자가소비액  기타소비지출  \n",
       "0       925000.0   78000.0         0.0    0.0     0.0  \n",
       "1            0.0       0.0         0.0    0.0  1000.0  \n",
       "2       237000.0  523000.0         0.0    0.0     0.0  \n",
       "3            0.0       0.0  42985000.0    0.0     0.0  \n",
       "4       943000.0       0.0     15000.0    0.0     0.0  \n",
       "...          ...       ...         ...    ...     ...  \n",
       "473225  150000.0       0.0         0.0    0.0     0.0  \n",
       "473226  292000.0       0.0         0.0    0.0     0.0  \n",
       "473227  164000.0       0.0     53000.0    0.0  1000.0  \n",
       "473228  234000.0       0.0         0.0    0.0     0.0  \n",
       "473229       0.0       0.0         0.0    0.0     0.0  \n",
       "\n",
       "[473230 rows x 24 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in df.index.tolist():\n",
    "    # 총가계지출\n",
    "    new_df.loc[i, \"총가계지출\"] = df.loc[i, 'B1':'B166'].sum()\n",
    "    # 식료품비\n",
    "    new_df.loc[i, \"식료품비\"] = df.loc[i, ['B20', 'B22', 'B23', 'B24', 'B25', 'B26', 'B27', 'B29', 'B30', 'B31', 'B32', 'B35', 'B36', 'B37', 'B38', 'B39', 'B40', 'B41', 'B42']].sum()\n",
    "    # 가구/가사용품비\n",
    "    new_df.loc[i, '가구/가사용품비'] = df.loc[i, ['B43', 'B44', 'B45', 'B46', 'B47', 'B48', 'B49', 'B50', 'B52', 'B53', 'B55', 'B56', 'B67', 'B74']].sum()\n",
    "    # 의류/신발비\n",
    "    new_df.loc[i, '의류/신발비'] = df.loc[i, ['B13', 'B14', 'B15', 'B16', 'B17', 'B18', 'B19', 'B21', 'B63', 'B64', 'B65', 'B56', 'B66', 'B68', 'B69', 'B70', 'B71', 'B72', 'B73']].sum()\n",
    "    # 보건의료비\n",
    "    new_df.loc[i, '보건의료비'] = df.loc[i, ['B106', 'B107', 'B139', 'B140', 'B141', 'B142', 'B143', 'B144', 'B145', 'B146', 'B147', 'B148', 'B149']].sum()\n",
    "    # 교양오락비\n",
    "    new_df.loc[i, '교양오락비'] = df.loc[i, ['B1', 'B2', 'B3', 'B4', 'B5', 'B6', 'B79', 'B80', 'B81', 'B82', 'B83', 'B84', 'B85', 'B86', 'B87', 'B88', 'B89', 'B90', 'B91', 'B97', 'B98', 'B99', 'B100', 'B101', 'B102', 'B103', 'B104', 'B105', 'B120', 'B121', 'B123', 'B137', 'B138', 'B152', 'B153', 'B154']].sum()\n",
    "    # 교통/통신비\n",
    "    new_df.loc[i, '교통/통신비'] = df.loc[i, ['B7', 'B8', 'B9', 'B10', 'B11', 'B61', 'B62', 'B159', 'B157', 'B158', 'B161', 'B162', 'B164', 'B165', 'B166']].sum()\n",
    "    # 교육비\n",
    "    new_df.loc[i, '교육비'] = df.loc[i, ['B58', 'B59', 'B60', 'B94', 'B108', 'B122', 'B155', 'B160', 'B156']].sum()\n",
    "    # 세금\n",
    "    new_df.loc[i, '세금'] = df.loc[i, ['B12']].sum()\n",
    "    # 자가소비액(농축산 + 어업)\n",
    "    new_df.loc[i, '자가소비액'] = df.loc[i, ['B28']].sum()\n",
    "    # 기타소비지출\n",
    "    new_df.loc[i, '기타소비지출'] = df.loc[i, ['B129', 'B130', 'B131', 'B132', 'B150', 'B151', 'B163']].sum()\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['P1', 'P2', 'P3', 'P4', 'P5', 'P6', 'P7', 'E1', 'E2', 'E3', 'E4', 'E5',\n",
       "       'E6', '총가계지출', '식료품비', '가구/가사용품비', '의류/신발비', '보건의료비', '교양오락비', '교통/통신비',\n",
       "       '교육비', '세금', '자가소비액', '기타소비지출'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>P1</th>\n",
       "      <th>P2</th>\n",
       "      <th>P3</th>\n",
       "      <th>P4</th>\n",
       "      <th>P5</th>\n",
       "      <th>P6</th>\n",
       "      <th>P7</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>E1</th>\n",
       "      <th>E2</th>\n",
       "      <th>E3</th>\n",
       "      <th>E4</th>\n",
       "      <th>E5</th>\n",
       "      <th>E6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>4090000</td>\n",
       "      <td>1190000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>78000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11111111110</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>1100000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M</td>\n",
       "      <td>50대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>500000</td>\n",
       "      <td>188000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111110111111</td>\n",
       "      <td>10000000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>1750000</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>523000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1101101111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111101101111</td>\n",
       "      <td>101101101111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>F</td>\n",
       "      <td>60대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>43001000</td>\n",
       "      <td>14000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42985000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M</td>\n",
       "      <td>30대_후</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>4911000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473225</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_초</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>B은행</td>\n",
       "      <td>575000</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>0.0</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>111111111111</td>\n",
       "      <td>10001001100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111101</td>\n",
       "      <td>10111111100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473226</th>\n",
       "      <td>M</td>\n",
       "      <td>20대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>796000</td>\n",
       "      <td>126000.0</td>\n",
       "      <td>0.0</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</td>\n",
       "      <td>110110000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111110</td>\n",
       "      <td>111111111000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473227</th>\n",
       "      <td>F</td>\n",
       "      <td>40대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>1322000</td>\n",
       "      <td>253000.0</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>100100011</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>111111111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473228</th>\n",
       "      <td>M</td>\n",
       "      <td>60대_후</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>A은행</td>\n",
       "      <td>1122000</td>\n",
       "      <td>193000.0</td>\n",
       "      <td>82000.0</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</td>\n",
       "      <td>100101000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111111111111</td>\n",
       "      <td>110101111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473229</th>\n",
       "      <td>F</td>\n",
       "      <td>50대_초</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B은행</td>\n",
       "      <td>650000</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>52000.0</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</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11001001000</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>473230 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       P1     P2  P3  P4  P5  P6   P7     총가계지출       식료품비  가구/가사용품비  ...  \\\n",
       "0       M  20대_후   1   1   0   0  A은행   4090000  1190000.0       0.0  ...   \n",
       "1       M  50대_후   1   0   0   0  A은행    500000   188000.0       0.0  ...   \n",
       "2       M  40대_후   1   1   0   0  A은행   1750000   117000.0       0.0  ...   \n",
       "3       F  60대_초   1   1   0   0  A은행  43001000    14000.0       0.0  ...   \n",
       "4       M  30대_후   0   1   0   0  B은행   4911000        0.0       0.0  ...   \n",
       "...    ..    ...  ..  ..  ..  ..  ...       ...        ...       ...  ...   \n",
       "473225  F  40대_초   0   1   0   1  B은행    575000     9000.0       0.0  ...   \n",
       "473226  M  20대_후   1   1   0   0  A은행    796000   126000.0       0.0  ...   \n",
       "473227  F  40대_후   1   1   1   0  B은행   1322000   253000.0   20000.0  ...   \n",
       "473228  M  60대_후   1   1   1   0  A은행   1122000   193000.0   82000.0  ...   \n",
       "473229  F  50대_초   1   0   0   0  B은행    650000   105000.0   52000.0  ...   \n",
       "\n",
       "             교육비          세금  자가소비액  기타소비지출            E1            E2  \\\n",
       "0        78000.0         0.0    0.0     0.0             0             0   \n",
       "1            0.0         0.0    0.0  1000.0             0             0   \n",
       "2       523000.0         0.0    0.0     0.0             0    1101101111   \n",
       "3            0.0  42985000.0    0.0     0.0             0             0   \n",
       "4            0.0     15000.0    0.0     0.0             0  111111111111   \n",
       "...          ...         ...    ...     ...           ...           ...   \n",
       "473225       0.0         0.0    0.0     0.0  111111111111   10001001100   \n",
       "473226       0.0         0.0    0.0     0.0             0  110110000000   \n",
       "473227       0.0     53000.0    0.0  1000.0             0     100100011   \n",
       "473228       0.0         0.0    0.0     0.0             0     100101000   \n",
       "473229       0.0         0.0    0.0     0.0             0          1000   \n",
       "\n",
       "                 E3  E4            E5            E6  \n",
       "0       11111111110   0  111111111111    1100000000  \n",
       "1                 0   0  111110111111   10000000000  \n",
       "2                 0   0  111101101111  101101101111  \n",
       "3                 0   0  111111111111  111111111111  \n",
       "4                 0   0  111111111111  111111111111  \n",
       "...             ...  ..           ...           ...  \n",
       "473225            0   0  111111111101   10111111100  \n",
       "473226            0   0  111111111110  111111111000  \n",
       "473227            0   0  111111111111  111111111111  \n",
       "473228            0   0  111111111111  110101111111  \n",
       "473229            0   0   11001001000          1000  \n",
       "\n",
       "[473230 rows x 24 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 컬럼 순서 바꾸기\n",
    "new_df = new_df[['P1', 'P2', 'P3', 'P4', 'P5', 'P6', 'P7', '총가계지출', '식료품비', '가구/가사용품비', '의류/신발비', '보건의료비', '교양오락비', '교통/통신비', '교육비', '세금', '자가소비액', '기타소비지출', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6']]\n",
    "\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_df.to_csv(\"temp.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.3 64-bit",
   "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.10.3"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "fb4569285eef3a3450cb62085a5b1e0da4bce0af555edc33dcf29baf3acc1368"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}