04_06_Pandas_IO.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Input and Output\n",
    "\n",
    "This notebook is the reference code for getting input and output, pandas can read a variety of file types using its pd.read_ methods. Let's take a look at the most common data types: \n",
    "\n",
    "Nézzük meg mit tud beolvasni és kimenteni a pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## CSV\n",
    "\n",
    "### CSV Input"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>c1</th>\n",
       "      <th>c2</th>\n",
       "      <th>c3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.080589</td>\n",
       "      <td>1.086458</td>\n",
       "      <td>0.134393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-1.942756</td>\n",
       "      <td>1.136514</td>\n",
       "      <td>0.786556</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         c1        c2        c3\n",
       "0  0.080589  1.086458  0.134393\n",
       "1 -1.942756  1.136514  0.786556"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('files\\example2.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### CSV Output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>c1</th>\n",
       "      <th>c2</th>\n",
       "      <th>c3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>a</th>\n",
       "      <td>0.663481</td>\n",
       "      <td>-1.622241</td>\n",
       "      <td>-0.702429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b</th>\n",
       "      <td>0.054538</td>\n",
       "      <td>-1.029219</td>\n",
       "      <td>-0.485685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         c1        c2        c3\n",
       "a  0.663481 -1.622241 -0.702429\n",
       "b  0.054538 -1.029219 -0.485685"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "example2 = pd.DataFrame(data=np.random.randn(2,3),index = ['a','b'], columns = ['c1','c2','c3'])\n",
    "example2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "example2.to_csv('files\\example2.csv',index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Excel\n",
    "Pandas can read and write excel files, keep in mind, this only imports data. Not formulas or images, having images or macros may cause this read_excel method to crash. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Excel Input"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>c1</th>\n",
       "      <th>c2</th>\n",
       "      <th>c3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.080589</td>\n",
       "      <td>1.086458</td>\n",
       "      <td>0.134393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-1.942756</td>\n",
       "      <td>1.136514</td>\n",
       "      <td>0.786556</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         c1        c2        c3\n",
       "0  0.080589  1.086458  0.134393\n",
       "1 -1.942756  1.136514  0.786556"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_excel('files\\Excel_Sample.xlsx',sheet_name='Sheet1')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Excel Output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('files\\Excel_Sample.xlsx',sheet_name='Sheet1')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "____"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating a pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Év</th>\n",
       "      <th>Negyed</th>\n",
       "      <th>Típus</th>\n",
       "      <th>Vevő</th>\n",
       "      <th>Darab</th>\n",
       "      <th>Ár (Ft)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Courier</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>12</td>\n",
       "      <td>9500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Courier</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>10</td>\n",
       "      <td>9500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Courier</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>4</td>\n",
       "      <td>9500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Courier</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>2</td>\n",
       "      <td>9500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>5</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>5</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>1</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>4</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>10</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>1</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>9</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>12</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>9</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>7</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1999</td>\n",
       "      <td>1. negyedév</td>\n",
       "      <td>Semperit</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>1</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Courier</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>8</td>\n",
       "      <td>9500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>3</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>8</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>6</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>6</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>6</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>1</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>12</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>3</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>1</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>8</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>5</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>9</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>10</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1999</td>\n",
       "      <td>2. negyedév</td>\n",
       "      <td>Semperit</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>8</td>\n",
       "      <td>8900</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>13</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>13</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>1</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>3</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>7</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>2</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>3</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>6</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>13</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Semperit</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>2</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>2000</td>\n",
       "      <td>3. negyedév</td>\n",
       "      <td>Semperit</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>4</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Courier</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>5</td>\n",
       "      <td>9500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>4</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>6</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>11</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>11</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>8</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Firestone</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>3</td>\n",
       "      <td>18800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>6</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>10</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Goodyear</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>5</td>\n",
       "      <td>16400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>7</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Michelin</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>13</td>\n",
       "      <td>20200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>A-cég</td>\n",
       "      <td>8</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>B-cég</td>\n",
       "      <td>11</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>7</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Pirelli</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>13</td>\n",
       "      <td>13700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Semperit</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>12</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Semperit</td>\n",
       "      <td>C-cég</td>\n",
       "      <td>8</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>2000</td>\n",
       "      <td>4. negyedév</td>\n",
       "      <td>Semperit</td>\n",
       "      <td>D-cég</td>\n",
       "      <td>11</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>142 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Év       Negyed      Típus   Vevő  Darab  Ár (Ft)\n",
       "0    1999  1. negyedév    Courier  D-cég     12     9500\n",
       "1    1999  1. negyedév    Courier  A-cég     10     9500\n",
       "2    1999  1. negyedév    Courier  B-cég      4     9500\n",
       "3    1999  1. negyedév    Courier  C-cég      2     9500\n",
       "4    1999  1. negyedév   Goodyear  C-cég      5    16400\n",
       "5    1999  1. negyedév   Goodyear  C-cég      5    16400\n",
       "6    1999  1. negyedév   Goodyear  D-cég      1    16400\n",
       "7    1999  1. negyedév   Michelin  A-cég      4    20200\n",
       "8    1999  1. negyedév   Michelin  B-cég     10    20200\n",
       "9    1999  1. negyedév   Michelin  D-cég      1    20200\n",
       "10   1999  1. negyedév    Pirelli  D-cég      9    13700\n",
       "11   1999  1. negyedév    Pirelli  C-cég     12    13700\n",
       "12   1999  1. negyedév    Pirelli  D-cég      9    13700\n",
       "13   1999  1. negyedév    Pirelli  C-cég      7    13700\n",
       "14   1999  1. negyedév   Semperit  D-cég      1     8900\n",
       "15   1999  2. negyedév    Courier  A-cég      8     9500\n",
       "16   1999  2. negyedév  Firestone  B-cég      3    18800\n",
       "17   1999  2. negyedév  Firestone  B-cég      8    18800\n",
       "18   1999  2. negyedév  Firestone  C-cég      6    18800\n",
       "19   1999  2. negyedév  Firestone  B-cég      6    18800\n",
       "20   1999  2. negyedév   Goodyear  D-cég      6    16400\n",
       "21   1999  2. negyedév   Goodyear  A-cég      1    16400\n",
       "22   1999  2. negyedév   Goodyear  A-cég     12    16400\n",
       "23   1999  2. negyedév   Michelin  C-cég      3    20200\n",
       "24   1999  2. negyedév    Pirelli  D-cég      1    13700\n",
       "25   1999  2. negyedév    Pirelli  C-cég      8    13700\n",
       "26   1999  2. negyedév    Pirelli  D-cég      5    13700\n",
       "27   1999  2. negyedév    Pirelli  A-cég      9    13700\n",
       "28   1999  2. negyedév    Pirelli  B-cég     10    13700\n",
       "29   1999  2. negyedév   Semperit  B-cég      8     8900\n",
       "..    ...          ...        ...    ...    ...      ...\n",
       "112  2000  3. negyedév  Firestone  C-cég     13    18800\n",
       "113  2000  3. negyedév  Firestone  D-cég     13    18800\n",
       "114  2000  3. negyedév   Goodyear  C-cég      1    16400\n",
       "115  2000  3. negyedév   Goodyear  B-cég      3    16400\n",
       "116  2000  3. negyedév   Goodyear  A-cég      7    16400\n",
       "117  2000  3. negyedév   Michelin  C-cég      2    20200\n",
       "118  2000  3. negyedév   Michelin  C-cég      3    20200\n",
       "119  2000  3. negyedév   Michelin  A-cég      6    20200\n",
       "120  2000  3. negyedév    Pirelli  A-cég     13    13700\n",
       "121  2000  3. negyedév   Semperit  D-cég      2     8900\n",
       "122  2000  3. negyedév   Semperit  A-cég      4     8900\n",
       "123  2000  4. negyedév    Courier  B-cég      5     9500\n",
       "124  2000  4. negyedév  Firestone  B-cég      4    18800\n",
       "125  2000  4. negyedév  Firestone  A-cég      6    18800\n",
       "126  2000  4. negyedév  Firestone  A-cég     11    18800\n",
       "127  2000  4. negyedév  Firestone  C-cég     11    18800\n",
       "128  2000  4. negyedév  Firestone  B-cég      8    18800\n",
       "129  2000  4. negyedév  Firestone  C-cég      3    18800\n",
       "130  2000  4. negyedév   Goodyear  C-cég      6    16400\n",
       "131  2000  4. negyedév   Goodyear  A-cég     10    16400\n",
       "132  2000  4. negyedév   Goodyear  C-cég      5    16400\n",
       "133  2000  4. negyedév   Michelin  C-cég      7    20200\n",
       "134  2000  4. negyedév   Michelin  A-cég     13    20200\n",
       "135  2000  4. negyedév    Pirelli  A-cég      8    13700\n",
       "136  2000  4. negyedév    Pirelli  B-cég     11    13700\n",
       "137  2000  4. negyedév    Pirelli  D-cég      7    13700\n",
       "138  2000  4. negyedév    Pirelli  C-cég     13    13700\n",
       "139  2000  4. negyedév   Semperit  D-cég     12     8900\n",
       "140  2000  4. negyedév   Semperit  C-cég      8     8900\n",
       "141  2000  4. negyedév   Semperit  D-cég     11     8900\n",
       "\n",
       "[142 rows x 6 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ex = pd.read_excel('files\\pelda_41.xls')\n",
    "ex"
   ]
  },
  {
   "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>Típus</th>\n",
       "      <th>Courier</th>\n",
       "      <th>Firestone</th>\n",
       "      <th>Goodyear</th>\n",
       "      <th>Michelin</th>\n",
       "      <th>Pirelli</th>\n",
       "      <th>Semperit</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vevő</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>A-cég</th>\n",
       "      <td>30</td>\n",
       "      <td>50</td>\n",
       "      <td>40</td>\n",
       "      <td>45</td>\n",
       "      <td>63</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B-cég</th>\n",
       "      <td>15</td>\n",
       "      <td>63</td>\n",
       "      <td>21</td>\n",
       "      <td>53</td>\n",
       "      <td>46</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C-cég</th>\n",
       "      <td>22</td>\n",
       "      <td>61</td>\n",
       "      <td>52</td>\n",
       "      <td>34</td>\n",
       "      <td>40</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>D-cég</th>\n",
       "      <td>48</td>\n",
       "      <td>60</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>53</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Típus  Courier  Firestone  Goodyear  Michelin  Pirelli  Semperit\n",
       "Vevő                                                            \n",
       "A-cég       30         50        40        45       63        20\n",
       "B-cég       15         63        21        53       46        32\n",
       "C-cég       22         61        52        34       40        73\n",
       "D-cég       48         60        23        18       53        26"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ex.pivot_table(values ='Darab',index = 'Vevő',columns = 'Típus',aggfunc = 'sum')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}