task2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "cars = pd.read_csv('samochody1tys.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>160000.0</td>\n",
       "      <td>75900.0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>149000.0</td>\n",
       "      <td>70900.0</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>9800.0</td>\n",
       "      <td>Opolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>11900.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>49900.0</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>995</td>\n",
       "      <td>995</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>159</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2387.0</td>\n",
       "      <td>182000.0</td>\n",
       "      <td>33900.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>996</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>42700.0</td>\n",
       "      <td>25400.0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>997</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Modus</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>168111.0</td>\n",
       "      <td>10900.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>998</td>\n",
       "      <td>Audi</td>\n",
       "      <td>A3 8L</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>226500.0</td>\n",
       "      <td>5400.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>999</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>XC 60 I</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>13617.0</td>\n",
       "      <td>136900.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       marka        model  rok_produkcji rodzaj_silnika  \\\n",
       "0      0      Nissan  X-Trail III         2014.0         Diesel   \n",
       "1      1         BMW       X1 E84         2012.0         Diesel   \n",
       "2      2        Opel     Zafira A         2004.0    Benzyna+CNG   \n",
       "3      3     Hyundai        i10 I         2008.0        Benzyna   \n",
       "4      4  Volkswagen           CC         2010.0         Diesel   \n",
       "..   ...         ...          ...            ...            ...   \n",
       "995  995  Alfa Romeo          159         2009.0         Diesel   \n",
       "996  996       Škoda     Fabia II         2012.0        Benzyna   \n",
       "997  997     Renault        Modus         2004.0        Benzyna   \n",
       "998  998        Audi        A3 8L         2000.0        Benzyna   \n",
       "999  999       Volvo      XC 60 I         2016.0         Diesel   \n",
       "\n",
       "     pojemnosc_silnika  przebieg      cena     wojewodztwo  \n",
       "0               1600.0  160000.0   75900.0    Dolnośląskie  \n",
       "1               2000.0  149000.0   70900.0  Świętokrzyskie  \n",
       "2               1600.0   99000.0    9800.0        Opolskie  \n",
       "3               1100.0   93000.0   11900.0         Łódzkie  \n",
       "4               1968.0  127428.0   49900.0   Wielkopolskie  \n",
       "..                 ...       ...       ...             ...  \n",
       "995             2387.0  182000.0   33900.0     Małopolskie  \n",
       "996             1200.0   42700.0   25400.0       Lubelskie  \n",
       "997             1200.0  168111.0   10900.0         Łódzkie  \n",
       "998             1595.0  226500.0    5400.0     Małopolskie  \n",
       "999             1969.0   13617.0  136900.0     Małopolskie  \n",
       "\n",
       "[1000 rows x 9 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wyswietlenie DataFrame cars\n",
    "cars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                     int64\n",
       "marka                 object\n",
       "model                 object\n",
       "rok_produkcji        float64\n",
       "rodzaj_silnika        object\n",
       "pojemnosc_silnika    float64\n",
       "przebieg             float64\n",
       "cena                 float64\n",
       "wojewodztwo           object\n",
       "dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wyswietlenie typow kazdej kolumny\n",
    "cars.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>160000.0</td>\n",
       "      <td>75900.0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>149000.0</td>\n",
       "      <td>70900.0</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>9800.0</td>\n",
       "      <td>Opolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>11900.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>49900.0</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id       marka        model  rok_produkcji rodzaj_silnika  \\\n",
       "0   0      Nissan  X-Trail III         2014.0         Diesel   \n",
       "1   1         BMW       X1 E84         2012.0         Diesel   \n",
       "2   2        Opel     Zafira A         2004.0    Benzyna+CNG   \n",
       "3   3     Hyundai        i10 I         2008.0        Benzyna   \n",
       "4   4  Volkswagen           CC         2010.0         Diesel   \n",
       "\n",
       "   pojemnosc_silnika  przebieg     cena     wojewodztwo  \n",
       "0             1600.0  160000.0  75900.0    Dolnośląskie  \n",
       "1             2000.0  149000.0  70900.0  Świętokrzyskie  \n",
       "2             1600.0   99000.0   9800.0        Opolskie  \n",
       "3             1100.0   93000.0  11900.0         Łódzkie  \n",
       "4             1968.0  127428.0  49900.0   Wielkopolskie  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wyswietlenie pierwszych x rekordow\n",
    "cars.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>995</td>\n",
       "      <td>995</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>159</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2387.0</td>\n",
       "      <td>182000.0</td>\n",
       "      <td>33900.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>996</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>42700.0</td>\n",
       "      <td>25400.0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>997</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Modus</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>168111.0</td>\n",
       "      <td>10900.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>998</td>\n",
       "      <td>Audi</td>\n",
       "      <td>A3 8L</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>226500.0</td>\n",
       "      <td>5400.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>999</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>XC 60 I</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>13617.0</td>\n",
       "      <td>136900.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       marka     model  rok_produkcji rodzaj_silnika  \\\n",
       "995  995  Alfa Romeo       159         2009.0         Diesel   \n",
       "996  996       Škoda  Fabia II         2012.0        Benzyna   \n",
       "997  997     Renault     Modus         2004.0        Benzyna   \n",
       "998  998        Audi     A3 8L         2000.0        Benzyna   \n",
       "999  999       Volvo   XC 60 I         2016.0         Diesel   \n",
       "\n",
       "     pojemnosc_silnika  przebieg      cena  wojewodztwo  \n",
       "995             2387.0  182000.0   33900.0  Małopolskie  \n",
       "996             1200.0   42700.0   25400.0    Lubelskie  \n",
       "997             1200.0  168111.0   10900.0      Łódzkie  \n",
       "998             1595.0  226500.0    5400.0  Małopolskie  \n",
       "999             1969.0   13617.0  136900.0  Małopolskie  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wyswietlenie ostatnich x rekordow\n",
    "cars.tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=1000, step=1)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wyswietlanie zakresu indexow\n",
    "cars.index\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'marka', 'model', 'rok_produkcji', 'rodzaj_silnika',\n",
       "       'pojemnosc_silnika', 'przebieg', 'cena', 'wojewodztwo'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wyswietlanie kolumn\n",
    "cars.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0, 'Nissan', 'X-Trail III', ..., 160000.0, 75900.0,\n",
       "        'Dolnośląskie'],\n",
       "       [1, 'BMW', 'X1 E84', ..., 149000.0, 70900.0, 'Świętokrzyskie'],\n",
       "       [2, 'Opel', 'Zafira A', ..., 99000.0, 9800.0, 'Opolskie'],\n",
       "       ...,\n",
       "       [997, 'Renault', 'Modus', ..., 168111.0, 10900.0, 'Łódzkie'],\n",
       "       [998, 'Audi', 'A3 8L', ..., 226500.0, 5400.0, 'Małopolskie'],\n",
       "       [999, 'Volvo', 'XC 60 I', ..., 13617.0, 136900.0, 'Małopolskie']],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#reprezentacja DataFrame za pomoca NumPy, ktory sprawdzi typ danych kolumn i sprowadzi je do jednego,\n",
    "#wspolnego typu - w tym przypadku Object\n",
    "cars.to_numpy()"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>count</td>\n",
       "      <td>1000.000000</td>\n",
       "      <td>1000.000000</td>\n",
       "      <td>1000.000000</td>\n",
       "      <td>1000.000000</td>\n",
       "      <td>1000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>mean</td>\n",
       "      <td>499.500000</td>\n",
       "      <td>2009.009000</td>\n",
       "      <td>2040.065000</td>\n",
       "      <td>132556.677000</td>\n",
       "      <td>51942.181000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>std</td>\n",
       "      <td>288.819436</td>\n",
       "      <td>5.907946</td>\n",
       "      <td>6014.545066</td>\n",
       "      <td>90094.944138</td>\n",
       "      <td>70057.918015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>min</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1979.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>650.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25%</td>\n",
       "      <td>249.750000</td>\n",
       "      <td>2005.000000</td>\n",
       "      <td>1500.000000</td>\n",
       "      <td>51750.000000</td>\n",
       "      <td>14900.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50%</td>\n",
       "      <td>499.500000</td>\n",
       "      <td>2009.000000</td>\n",
       "      <td>1800.000000</td>\n",
       "      <td>149000.000000</td>\n",
       "      <td>27250.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75%</td>\n",
       "      <td>749.250000</td>\n",
       "      <td>2014.000000</td>\n",
       "      <td>2000.000000</td>\n",
       "      <td>193000.000000</td>\n",
       "      <td>58900.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>max</td>\n",
       "      <td>999.000000</td>\n",
       "      <td>2017.000000</td>\n",
       "      <td>191000.000000</td>\n",
       "      <td>647000.000000</td>\n",
       "      <td>616000.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                id  rok_produkcji  pojemnosc_silnika       przebieg  \\\n",
       "count  1000.000000    1000.000000        1000.000000    1000.000000   \n",
       "mean    499.500000    2009.009000        2040.065000  132556.677000   \n",
       "std     288.819436       5.907946        6014.545066   90094.944138   \n",
       "min       0.000000    1979.000000           1.000000       1.000000   \n",
       "25%     249.750000    2005.000000        1500.000000   51750.000000   \n",
       "50%     499.500000    2009.000000        1800.000000  149000.000000   \n",
       "75%     749.250000    2014.000000        2000.000000  193000.000000   \n",
       "max     999.000000    2017.000000      191000.000000  647000.000000   \n",
       "\n",
       "                cena  \n",
       "count    1000.000000  \n",
       "mean    51942.181000  \n",
       "std     70057.918015  \n",
       "min       650.000000  \n",
       "25%     14900.000000  \n",
       "50%     27250.000000  \n",
       "75%     58900.000000  \n",
       "max    616000.000000  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#zwrocenie podstawowej statystyki naszych danych\n",
    "cars.describe()"
   ]
  },
  {
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>990</th>\n",
       "      <th>991</th>\n",
       "      <th>992</th>\n",
       "      <th>993</th>\n",
       "      <th>994</th>\n",
       "      <th>995</th>\n",
       "      <th>996</th>\n",
       "      <th>997</th>\n",
       "      <th>998</th>\n",
       "      <th>999</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>id</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>990</td>\n",
       "      <td>991</td>\n",
       "      <td>992</td>\n",
       "      <td>993</td>\n",
       "      <td>994</td>\n",
       "      <td>995</td>\n",
       "      <td>996</td>\n",
       "      <td>997</td>\n",
       "      <td>998</td>\n",
       "      <td>999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>marka</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>Seat</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>...</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>Chevrolet</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Audi</td>\n",
       "      <td>Volvo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>model</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>CC</td>\n",
       "      <td>500</td>\n",
       "      <td>X-Trail I</td>\n",
       "      <td>Toledo II</td>\n",
       "      <td>CC</td>\n",
       "      <td>Juke</td>\n",
       "      <td>...</td>\n",
       "      <td>Klasa S W126</td>\n",
       "      <td>Cruze</td>\n",
       "      <td>Clio IV</td>\n",
       "      <td>Tipo II</td>\n",
       "      <td>Bravo II</td>\n",
       "      <td>159</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>Modus</td>\n",
       "      <td>A3 8L</td>\n",
       "      <td>XC 60 I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>rok_produkcji</td>\n",
       "      <td>2014</td>\n",
       "      <td>2012</td>\n",
       "      <td>2004</td>\n",
       "      <td>2008</td>\n",
       "      <td>2010</td>\n",
       "      <td>2014</td>\n",
       "      <td>2004</td>\n",
       "      <td>2000</td>\n",
       "      <td>2014</td>\n",
       "      <td>2016</td>\n",
       "      <td>...</td>\n",
       "      <td>1986</td>\n",
       "      <td>2010</td>\n",
       "      <td>2017</td>\n",
       "      <td>2017</td>\n",
       "      <td>2007</td>\n",
       "      <td>2009</td>\n",
       "      <td>2012</td>\n",
       "      <td>2004</td>\n",
       "      <td>2000</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>rodzaj_silnika</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Elektryczny</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>...</td>\n",
       "      <td>Benzyna+LPG</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>Diesel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>pojemnosc_silnika</td>\n",
       "      <td>1600</td>\n",
       "      <td>2000</td>\n",
       "      <td>1600</td>\n",
       "      <td>1100</td>\n",
       "      <td>1968</td>\n",
       "      <td>1</td>\n",
       "      <td>2200</td>\n",
       "      <td>1800</td>\n",
       "      <td>1968</td>\n",
       "      <td>1197</td>\n",
       "      <td>...</td>\n",
       "      <td>2600</td>\n",
       "      <td>1598</td>\n",
       "      <td>898</td>\n",
       "      <td>1400</td>\n",
       "      <td>1910</td>\n",
       "      <td>2387</td>\n",
       "      <td>1200</td>\n",
       "      <td>1200</td>\n",
       "      <td>1595</td>\n",
       "      <td>1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>przebieg</td>\n",
       "      <td>160000</td>\n",
       "      <td>149000</td>\n",
       "      <td>99000</td>\n",
       "      <td>93000</td>\n",
       "      <td>127428</td>\n",
       "      <td>36800</td>\n",
       "      <td>174000</td>\n",
       "      <td>140700</td>\n",
       "      <td>52000</td>\n",
       "      <td>18000</td>\n",
       "      <td>...</td>\n",
       "      <td>336000</td>\n",
       "      <td>7560</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>217200</td>\n",
       "      <td>182000</td>\n",
       "      <td>42700</td>\n",
       "      <td>168111</td>\n",
       "      <td>226500</td>\n",
       "      <td>13617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>cena</td>\n",
       "      <td>75900</td>\n",
       "      <td>70900</td>\n",
       "      <td>9800</td>\n",
       "      <td>11900</td>\n",
       "      <td>49900</td>\n",
       "      <td>74200</td>\n",
       "      <td>23200</td>\n",
       "      <td>8150</td>\n",
       "      <td>97000</td>\n",
       "      <td>56900</td>\n",
       "      <td>...</td>\n",
       "      <td>21500</td>\n",
       "      <td>21900</td>\n",
       "      <td>58000</td>\n",
       "      <td>47350</td>\n",
       "      <td>18900</td>\n",
       "      <td>33900</td>\n",
       "      <td>25400</td>\n",
       "      <td>10900</td>\n",
       "      <td>5400</td>\n",
       "      <td>136900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>wojewodztwo</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "      <td>Opolskie</td>\n",
       "      <td>Łódzkie</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "      <td>Śląskie</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "      <td>Pomorskie</td>\n",
       "      <td>Pomorskie</td>\n",
       "      <td>Mazowieckie</td>\n",
       "      <td>...</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "      <td>Warmińsko-mazurskie</td>\n",
       "      <td>Śląskie</td>\n",
       "      <td>Mazowieckie</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "      <td>Małopolskie</td>\n",
       "      <td>Lubelskie</td>\n",
       "      <td>Łódzkie</td>\n",
       "      <td>Małopolskie</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 1000 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            0               1            2        3    \\\n",
       "id                            0               1            2        3   \n",
       "marka                    Nissan             BMW         Opel  Hyundai   \n",
       "model               X-Trail III          X1 E84     Zafira A    i10 I   \n",
       "rok_produkcji              2014            2012         2004     2008   \n",
       "rodzaj_silnika           Diesel          Diesel  Benzyna+CNG  Benzyna   \n",
       "pojemnosc_silnika          1600            2000         1600     1100   \n",
       "przebieg                 160000          149000        99000    93000   \n",
       "cena                      75900           70900         9800    11900   \n",
       "wojewodztwo        Dolnośląskie  Świętokrzyskie     Opolskie  Łódzkie   \n",
       "\n",
       "                             4            5             6          7    \\\n",
       "id                             4            5             6          7   \n",
       "marka                 Volkswagen         Fiat        Nissan       Seat   \n",
       "model                         CC          500     X-Trail I  Toledo II   \n",
       "rok_produkcji               2010         2014          2004       2000   \n",
       "rodzaj_silnika            Diesel  Elektryczny        Diesel    Benzyna   \n",
       "pojemnosc_silnika           1968            1          2200       1800   \n",
       "przebieg                  127428        36800        174000     140700   \n",
       "cena                       49900        74200         23200       8150   \n",
       "wojewodztwo        Wielkopolskie      Śląskie  Dolnośląskie  Pomorskie   \n",
       "\n",
       "                          8            9    ...             990  \\\n",
       "id                          8            9  ...             990   \n",
       "marka              Volkswagen       Nissan  ...   Mercedes-Benz   \n",
       "model                      CC         Juke  ...    Klasa S W126   \n",
       "rok_produkcji            2014         2016  ...            1986   \n",
       "rodzaj_silnika         Diesel      Benzyna  ...     Benzyna+LPG   \n",
       "pojemnosc_silnika        1968         1197  ...            2600   \n",
       "przebieg                52000        18000  ...          336000   \n",
       "cena                    97000        56900  ...           21500   \n",
       "wojewodztwo         Pomorskie  Mazowieckie  ...  Świętokrzyskie   \n",
       "\n",
       "                                   991      992          993             994  \\\n",
       "id                                 991      992          993             994   \n",
       "marka                        Chevrolet  Renault         Fiat            Fiat   \n",
       "model                            Cruze  Clio IV      Tipo II        Bravo II   \n",
       "rok_produkcji                     2010     2017         2017            2007   \n",
       "rodzaj_silnika                 Benzyna  Benzyna      Benzyna          Diesel   \n",
       "pojemnosc_silnika                 1598      898         1400            1910   \n",
       "przebieg                          7560        1            2          217200   \n",
       "cena                             21900    58000        47350           18900   \n",
       "wojewodztwo        Warmińsko-mazurskie  Śląskie  Mazowieckie  Świętokrzyskie   \n",
       "\n",
       "                           995        996      997          998          999  \n",
       "id                         995        996      997          998          999  \n",
       "marka               Alfa Romeo      Škoda  Renault         Audi        Volvo  \n",
       "model                      159   Fabia II    Modus        A3 8L      XC 60 I  \n",
       "rok_produkcji             2009       2012     2004         2000         2016  \n",
       "rodzaj_silnika          Diesel    Benzyna  Benzyna      Benzyna       Diesel  \n",
       "pojemnosc_silnika         2387       1200     1200         1595         1969  \n",
       "przebieg                182000      42700   168111       226500        13617  \n",
       "cena                     33900      25400    10900         5400       136900  \n",
       "wojewodztwo        Małopolskie  Lubelskie  Łódzkie  Małopolskie  Małopolskie  \n",
       "\n",
       "[9 rows x 1000 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#transpozycja danych\n",
    "cars.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>wojewodztwo</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>model</th>\n",
       "      <th>marka</th>\n",
       "      <th>id</th>\n",
       "      <th>cena</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>160000.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>0</td>\n",
       "      <td>75900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>149000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>BMW</td>\n",
       "      <td>1</td>\n",
       "      <td>70900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Opolskie</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>Opel</td>\n",
       "      <td>2</td>\n",
       "      <td>9800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Łódzkie</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>3</td>\n",
       "      <td>11900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>CC</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>4</td>\n",
       "      <td>49900.0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>995</td>\n",
       "      <td>Małopolskie</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>182000.0</td>\n",
       "      <td>2387.0</td>\n",
       "      <td>159</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>995</td>\n",
       "      <td>33900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>Lubelskie</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>42700.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>996</td>\n",
       "      <td>25400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>Łódzkie</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>168111.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>Modus</td>\n",
       "      <td>Renault</td>\n",
       "      <td>997</td>\n",
       "      <td>10900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>Małopolskie</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>226500.0</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>A3 8L</td>\n",
       "      <td>Audi</td>\n",
       "      <td>998</td>\n",
       "      <td>5400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>Małopolskie</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>13617.0</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>XC 60 I</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>999</td>\n",
       "      <td>136900.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        wojewodztwo  rok_produkcji rodzaj_silnika  przebieg  \\\n",
       "0      Dolnośląskie         2014.0         Diesel  160000.0   \n",
       "1    Świętokrzyskie         2012.0         Diesel  149000.0   \n",
       "2          Opolskie         2004.0    Benzyna+CNG   99000.0   \n",
       "3           Łódzkie         2008.0        Benzyna   93000.0   \n",
       "4     Wielkopolskie         2010.0         Diesel  127428.0   \n",
       "..              ...            ...            ...       ...   \n",
       "995     Małopolskie         2009.0         Diesel  182000.0   \n",
       "996       Lubelskie         2012.0        Benzyna   42700.0   \n",
       "997         Łódzkie         2004.0        Benzyna  168111.0   \n",
       "998     Małopolskie         2000.0        Benzyna  226500.0   \n",
       "999     Małopolskie         2016.0         Diesel   13617.0   \n",
       "\n",
       "     pojemnosc_silnika        model       marka   id      cena  \n",
       "0               1600.0  X-Trail III      Nissan    0   75900.0  \n",
       "1               2000.0       X1 E84         BMW    1   70900.0  \n",
       "2               1600.0     Zafira A        Opel    2    9800.0  \n",
       "3               1100.0        i10 I     Hyundai    3   11900.0  \n",
       "4               1968.0           CC  Volkswagen    4   49900.0  \n",
       "..                 ...          ...         ...  ...       ...  \n",
       "995             2387.0          159  Alfa Romeo  995   33900.0  \n",
       "996             1200.0     Fabia II       Škoda  996   25400.0  \n",
       "997             1200.0        Modus     Renault  997   10900.0  \n",
       "998             1595.0        A3 8L        Audi  998    5400.0  \n",
       "999             1969.0      XC 60 I       Volvo  999  136900.0  \n",
       "\n",
       "[1000 rows x 9 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#sortowanie danych wzgledem kolumn - ascencind=False ustawia sortowanie malejaco\n",
    "cars.sort_index(axis=1, ascending=False)"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>546</td>\n",
       "      <td>546</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>up!</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>999.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>41400.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>836</td>\n",
       "      <td>836</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Clio IV</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>42000.0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>141</td>\n",
       "      <td>141</td>\n",
       "      <td>Suzuki</td>\n",
       "      <td>Baleno</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43700.0</td>\n",
       "      <td>Śląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>508</td>\n",
       "      <td>508</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>Tipo II</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1368.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>44900.0</td>\n",
       "      <td>Pomorskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>774</td>\n",
       "      <td>774</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Meriva II</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>48700.0</td>\n",
       "      <td>Śląskie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>Klasa E W210</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2148.0</td>\n",
       "      <td>362653.0</td>\n",
       "      <td>8900.0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>989</td>\n",
       "      <td>989</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Seria 5 E39</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2926.0</td>\n",
       "      <td>404000.0</td>\n",
       "      <td>14900.0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>971</td>\n",
       "      <td>971</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>Klasa E W211</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2685.0</td>\n",
       "      <td>441000.0</td>\n",
       "      <td>16900.0</td>\n",
       "      <td>Lubuskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>243</td>\n",
       "      <td>243</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>Multivan</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>503000.0</td>\n",
       "      <td>13900.0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>238</td>\n",
       "      <td>238</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>W124 (1984-1993)</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>647000.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>Zachodniopomorskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id          marka             model  rok_produkcji rodzaj_silnika  \\\n",
       "546  546     Volkswagen               up!         2017.0        Benzyna   \n",
       "836  836        Renault           Clio IV         2017.0        Benzyna   \n",
       "141  141         Suzuki            Baleno         2017.0        Benzyna   \n",
       "508  508           Fiat           Tipo II         2017.0        Benzyna   \n",
       "774  774           Opel         Meriva II         2017.0        Benzyna   \n",
       "..   ...            ...               ...            ...            ...   \n",
       "82    82  Mercedes-Benz      Klasa E W210         2000.0         Diesel   \n",
       "989  989            BMW       Seria 5 E39         2002.0         Diesel   \n",
       "971  971  Mercedes-Benz      Klasa E W211         2003.0         Diesel   \n",
       "243  243     Volkswagen          Multivan         1994.0         Diesel   \n",
       "238  238  Mercedes-Benz  W124 (1984-1993)         1991.0         Diesel   \n",
       "\n",
       "     pojemnosc_silnika  przebieg     cena         wojewodztwo  \n",
       "546              999.0       1.0  41400.0             Łódzkie  \n",
       "836             1200.0       1.0  42000.0         Mazowieckie  \n",
       "141             1200.0       1.0  43700.0             Śląskie  \n",
       "508             1368.0       1.0  44900.0           Pomorskie  \n",
       "774             1400.0       1.0  48700.0             Śląskie  \n",
       "..                 ...       ...      ...                 ...  \n",
       "82              2148.0  362653.0   8900.0           Lubelskie  \n",
       "989             2926.0  404000.0  14900.0        Dolnośląskie  \n",
       "971             2685.0  441000.0  16900.0            Lubuskie  \n",
       "243             2400.0  503000.0  13900.0         Mazowieckie  \n",
       "238             1997.0  647000.0   4000.0  Zachodniopomorskie  \n",
       "\n",
       "[1000 rows x 9 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#sortowanie danych na podstawie wartosci - parametr 'by' przyjmuje str albo liste str\n",
    "cars.sort_values(by=['przebieg','cena'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          Nissan\n",
       "1             BMW\n",
       "2            Opel\n",
       "3         Hyundai\n",
       "4      Volkswagen\n",
       "          ...    \n",
       "995    Alfa Romeo\n",
       "996         Škoda\n",
       "997       Renault\n",
       "998          Audi\n",
       "999         Volvo\n",
       "Name: marka, Length: 1000, dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wybranie pojedynczej kolumny\n",
    "cars['marka']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>160000.0</td>\n",
       "      <td>75900.0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>149000.0</td>\n",
       "      <td>70900.0</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>9800.0</td>\n",
       "      <td>Opolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>11900.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>49900.0</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>895</td>\n",
       "      <td>895</td>\n",
       "      <td>Ford</td>\n",
       "      <td>Focus Mk2</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1560.0</td>\n",
       "      <td>149000.0</td>\n",
       "      <td>20900.0</td>\n",
       "      <td>Śląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>896</td>\n",
       "      <td>896</td>\n",
       "      <td>Kia</td>\n",
       "      <td>Cee'd I</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>181000.0</td>\n",
       "      <td>21900.0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>897</td>\n",
       "      <td>897</td>\n",
       "      <td>Suzuki</td>\n",
       "      <td>Grand Vitara II</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1870.0</td>\n",
       "      <td>146100.0</td>\n",
       "      <td>32600.0</td>\n",
       "      <td>Śląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>898</td>\n",
       "      <td>898</td>\n",
       "      <td>Ford</td>\n",
       "      <td>S-Max I</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>172000.0</td>\n",
       "      <td>45900.0</td>\n",
       "      <td>Podkarpackie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>899</td>\n",
       "      <td>899</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>500L</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>54850.0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>900 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       marka            model  rok_produkcji rodzaj_silnika  \\\n",
       "0      0      Nissan      X-Trail III         2014.0         Diesel   \n",
       "1      1         BMW           X1 E84         2012.0         Diesel   \n",
       "2      2        Opel         Zafira A         2004.0    Benzyna+CNG   \n",
       "3      3     Hyundai            i10 I         2008.0        Benzyna   \n",
       "4      4  Volkswagen               CC         2010.0         Diesel   \n",
       "..   ...         ...              ...            ...            ...   \n",
       "895  895        Ford        Focus Mk2         2008.0         Diesel   \n",
       "896  896         Kia          Cee'd I         2009.0        Benzyna   \n",
       "897  897      Suzuki  Grand Vitara II         2008.0         Diesel   \n",
       "898  898        Ford          S-Max I         2010.0         Diesel   \n",
       "899  899        Fiat             500L         2017.0        Benzyna   \n",
       "\n",
       "     pojemnosc_silnika  przebieg     cena     wojewodztwo  \n",
       "0               1600.0  160000.0  75900.0    Dolnośląskie  \n",
       "1               2000.0  149000.0  70900.0  Świętokrzyskie  \n",
       "2               1600.0   99000.0   9800.0        Opolskie  \n",
       "3               1100.0   93000.0  11900.0         Łódzkie  \n",
       "4               1968.0  127428.0  49900.0   Wielkopolskie  \n",
       "..                 ...       ...      ...             ...  \n",
       "895             1560.0  149000.0  20900.0         Śląskie  \n",
       "896             1400.0  181000.0  21900.0     Mazowieckie  \n",
       "897             1870.0  146100.0  32600.0         Śląskie  \n",
       "898             2000.0  172000.0  45900.0    Podkarpackie  \n",
       "899             1400.0       5.0  54850.0     Mazowieckie  \n",
       "\n",
       "[900 rows x 9 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wybranie poszczegolnej ilosc rekordow\n",
    "cars[0:900]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                               4\n",
       "marka                   Volkswagen\n",
       "model                           CC\n",
       "rok_produkcji                 2010\n",
       "rodzaj_silnika              Diesel\n",
       "pojemnosc_silnika             1968\n",
       "przebieg                    127428\n",
       "cena                         49900\n",
       "wojewodztwo          Wielkopolskie\n",
       "Name: 4, dtype: object"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wybranie konkretnego rekordu\n",
    "cars.iloc[4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>160000.0</td>\n",
       "      <td>75900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>149000.0</td>\n",
       "      <td>70900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>9800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>11900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>49900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>500</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>36800.0</td>\n",
       "      <td>74200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail I</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>174000.0</td>\n",
       "      <td>23200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>Seat</td>\n",
       "      <td>Toledo II</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>140700.0</td>\n",
       "      <td>8150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>52000.0</td>\n",
       "      <td>97000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>Juke</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>56900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>Toyota</td>\n",
       "      <td>Corolla Seria</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>26415.0</td>\n",
       "      <td>53000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Seria 5 E39</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>254900.0</td>\n",
       "      <td>17500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>Jetta A6</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>59000.0</td>\n",
       "      <td>59900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>Audi</td>\n",
       "      <td>A1</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>39999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Seria 3 E90</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>246000.0</td>\n",
       "      <td>27999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>Citroën</td>\n",
       "      <td>C4 Picasso I</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>181658.0</td>\n",
       "      <td>16900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>Ford</td>\n",
       "      <td>Mondeo Mk3</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>7200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>Klasa E W213</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>258709.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>Tiguan II</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>128900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>GLK GLK</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>89000.0</td>\n",
       "      <td>89000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>Honda</td>\n",
       "      <td>CR-V IV</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>111600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>Klasa E W213</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>292800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>Chevrolet</td>\n",
       "      <td>Captiva</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>219000.0</td>\n",
       "      <td>24999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>V50</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>170000.0</td>\n",
       "      <td>26900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>S40 II</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>232000.0</td>\n",
       "      <td>19999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Seria 3 E46</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>218000.0</td>\n",
       "      <td>16800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>S60 I</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>228000.0</td>\n",
       "      <td>12600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Seria 5 E39</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>215000.0</td>\n",
       "      <td>17900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>Toyota</td>\n",
       "      <td>Avensis III</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>179000.0</td>\n",
       "      <td>34900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Insignia A</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>179000.0</td>\n",
       "      <td>31900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>Ford</td>\n",
       "      <td>Ranger</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>164000.0</td>\n",
       "      <td>55000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>Doblo I</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>208000.0</td>\n",
       "      <td>8700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>Suzuki</td>\n",
       "      <td>SX4 S-Cross</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>73900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33</td>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>CLA CLA</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>194900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>34</td>\n",
       "      <td>Citroën</td>\n",
       "      <td>Xsara II</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>216005.0</td>\n",
       "      <td>4699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>35</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Espace IV</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>134000.0</td>\n",
       "      <td>21900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>36</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X5 F15</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>266800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>37</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Octavia III</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>11563.0</td>\n",
       "      <td>124900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>38</td>\n",
       "      <td>Ford</td>\n",
       "      <td>Focus Mk2</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>161000.0</td>\n",
       "      <td>13990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>39</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira B</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>132870.0</td>\n",
       "      <td>25900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>40</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Meriva I</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>204000.0</td>\n",
       "      <td>7000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41</td>\n",
       "      <td>Audi</td>\n",
       "      <td>A3 8P</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>140910.0</td>\n",
       "      <td>21999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>42</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>Qashqai II</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>91200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>43</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>XC 60</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>158600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Kangoo I</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>124000.0</td>\n",
       "      <td>15600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>45</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>XC 60 I</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>20900.0</td>\n",
       "      <td>158000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>46</td>\n",
       "      <td>Honda</td>\n",
       "      <td>Civic VIII</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>200000.0</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>47</td>\n",
       "      <td>Ford</td>\n",
       "      <td>S-Max I</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>183000.0</td>\n",
       "      <td>47900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>48</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Laguna III</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>163641.0</td>\n",
       "      <td>18900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>49</td>\n",
       "      <td>Peugeot</td>\n",
       "      <td>207</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>125123.0</td>\n",
       "      <td>13900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Scenic I</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>244529.0</td>\n",
       "      <td>5400.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            marka          model  rok_produkcji  przebieg      cena\n",
       "0          Nissan    X-Trail III         2014.0  160000.0   75900.0\n",
       "1             BMW         X1 E84         2012.0  149000.0   70900.0\n",
       "2            Opel       Zafira A         2004.0   99000.0    9800.0\n",
       "3         Hyundai          i10 I         2008.0   93000.0   11900.0\n",
       "4      Volkswagen             CC         2010.0  127428.0   49900.0\n",
       "5            Fiat            500         2014.0   36800.0   74200.0\n",
       "6          Nissan      X-Trail I         2004.0  174000.0   23200.0\n",
       "7            Seat      Toledo II         2000.0  140700.0    8150.0\n",
       "8      Volkswagen             CC         2014.0   52000.0   97000.0\n",
       "9          Nissan           Juke         2016.0   18000.0   56900.0\n",
       "10         Toyota  Corolla Seria         2015.0   26415.0   53000.0\n",
       "11            BMW    Seria 5 E39         2002.0  254900.0   17500.0\n",
       "12     Volkswagen       Jetta A6         2014.0   59000.0   59900.0\n",
       "13           Audi             A1         2011.0   90000.0   39999.0\n",
       "14            BMW    Seria 3 E90         2008.0  246000.0   27999.0\n",
       "15        Citroën   C4 Picasso I         2007.0  181658.0   16900.0\n",
       "16           Ford     Mondeo Mk3         2003.0  180000.0    7200.0\n",
       "17  Mercedes-Benz   Klasa E W213         2017.0       5.0  258709.0\n",
       "18     Volkswagen      Tiguan II         2017.0       5.0  128900.0\n",
       "19  Mercedes-Benz        GLK GLK         2012.0   89000.0   89000.0\n",
       "20          Honda        CR-V IV         2017.0       5.0  111600.0\n",
       "21  Mercedes-Benz   Klasa E W213         2017.0       2.0  292800.0\n",
       "22      Chevrolet        Captiva         2006.0  219000.0   24999.0\n",
       "23          Volvo            V50         2011.0  170000.0   26900.0\n",
       "24          Volvo         S40 II         2008.0  232000.0   19999.0\n",
       "25            BMW    Seria 3 E46         2001.0  218000.0   16800.0\n",
       "26          Volvo          S60 I         2003.0  228000.0   12600.0\n",
       "27            BMW    Seria 5 E39         2001.0  215000.0   17900.0\n",
       "28         Toyota    Avensis III         2009.0  179000.0   34900.0\n",
       "29           Opel     Insignia A         2010.0  179000.0   31900.0\n",
       "30           Ford         Ranger         2011.0  164000.0   55000.0\n",
       "31           Fiat        Doblo I         2002.0  208000.0    8700.0\n",
       "32         Suzuki    SX4 S-Cross         2017.0       1.0   73900.0\n",
       "33  Mercedes-Benz        CLA CLA         2017.0     500.0  194900.0\n",
       "34        Citroën       Xsara II         2002.0  216005.0    4699.0\n",
       "35        Renault      Espace IV         2008.0  134000.0   21900.0\n",
       "36            BMW         X5 F15         2017.0       1.0  266800.0\n",
       "37          Škoda    Octavia III         2016.0   11563.0  124900.0\n",
       "38           Ford      Focus Mk2         2006.0  161000.0   13990.0\n",
       "39           Opel       Zafira B         2010.0  132870.0   25900.0\n",
       "40           Opel       Meriva I         2004.0  204000.0    7000.0\n",
       "41           Audi          A3 8P         2004.0  140910.0   21999.0\n",
       "42         Nissan     Qashqai II         2017.0      10.0   91200.0\n",
       "43          Volvo          XC 60         2017.0       1.0  158600.0\n",
       "44        Renault       Kangoo I         2007.0  124000.0   15600.0\n",
       "45          Volvo        XC 60 I         2016.0   20900.0  158000.0\n",
       "46          Honda     Civic VIII         1997.0  200000.0    2500.0\n",
       "47           Ford        S-Max I         2012.0  183000.0   47900.0\n",
       "48        Renault     Laguna III         2007.0  163641.0   18900.0\n",
       "49        Peugeot            207         2007.0  125123.0   13900.0\n",
       "50        Renault       Scenic I         2003.0  244529.0    5400.0"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#zwrocenie konkretnej ilosci rekordow oraz wybranych kolumn\n",
    "cars.loc[0:50,['marka','model','rok_produkcji','przebieg','cena']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Scenic I</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1870.0</td>\n",
       "      <td>244529.0</td>\n",
       "      <td>5400.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>51</td>\n",
       "      <td>51</td>\n",
       "      <td>Audi</td>\n",
       "      <td>A6 C6</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2700.0</td>\n",
       "      <td>257000.0</td>\n",
       "      <td>26800.0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>Mini</td>\n",
       "      <td>Clubman</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>122700.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53</td>\n",
       "      <td>53</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Seria 5 F10</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>25135.0</td>\n",
       "      <td>159900.0</td>\n",
       "      <td>Pomorskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>BMW</td>\n",
       "      <td>Seria 3 E90</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>2979.0</td>\n",
       "      <td>76000.0</td>\n",
       "      <td>32800.0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>495</td>\n",
       "      <td>495</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Clio III</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>15800.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>496</td>\n",
       "      <td>496</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Astra H</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>96000.0</td>\n",
       "      <td>38500.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>497</td>\n",
       "      <td>497</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>Brava</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>136000.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>Śląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>498</td>\n",
       "      <td>498</td>\n",
       "      <td>Subaru</td>\n",
       "      <td>Impreza GD</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>141000.0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>499</td>\n",
       "      <td>499</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X4</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>254000.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>450 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id    marka        model  rok_produkcji rodzaj_silnika  \\\n",
       "50    50  Renault     Scenic I         2003.0         Diesel   \n",
       "51    51     Audi        A6 C6         2006.0         Diesel   \n",
       "52    52     Mini      Clubman         2016.0         Diesel   \n",
       "53    53      BMW  Seria 5 F10         2016.0         Diesel   \n",
       "54    54      BMW  Seria 3 E90         2008.0        Benzyna   \n",
       "..   ...      ...          ...            ...            ...   \n",
       "495  495  Renault     Clio III         2008.0        Benzyna   \n",
       "496  496     Opel      Astra H         2010.0        Benzyna   \n",
       "497  497     Fiat        Brava         1998.0        Benzyna   \n",
       "498  498   Subaru   Impreza GD         2004.0        Benzyna   \n",
       "499  499      BMW           X4         2017.0         Diesel   \n",
       "\n",
       "     pojemnosc_silnika  przebieg      cena  wojewodztwo  \n",
       "50              1870.0  244529.0    5400.0  Małopolskie  \n",
       "51              2700.0  257000.0   26800.0  Mazowieckie  \n",
       "52              1995.0    8000.0  122700.0      Łódzkie  \n",
       "53              1995.0   25135.0  159900.0    Pomorskie  \n",
       "54              2979.0   76000.0   32800.0  Mazowieckie  \n",
       "..                 ...       ...       ...          ...  \n",
       "495             1200.0  102000.0   15800.0      Łódzkie  \n",
       "496             1600.0   96000.0   38500.0  Małopolskie  \n",
       "497             1400.0  136000.0     900.0      Śląskie  \n",
       "498             1600.0  141000.0    8000.0      Łódzkie  \n",
       "499             1995.0       2.0  254000.0  Małopolskie  \n",
       "\n",
       "[450 rows x 9 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#wybranie przedzialu rekordow\n",
    "cars.iloc[50:500]"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>9800.0</td>\n",
       "      <td>Opolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>11900.0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>49900.0</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>500</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Elektryczny</td>\n",
       "      <td>1.0</td>\n",
       "      <td>36800.0</td>\n",
       "      <td>74200.0</td>\n",
       "      <td>Śląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>52000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>Pomorskie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>991</td>\n",
       "      <td>991</td>\n",
       "      <td>Chevrolet</td>\n",
       "      <td>Cruze</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1598.0</td>\n",
       "      <td>7560.0</td>\n",
       "      <td>21900.0</td>\n",
       "      <td>Warmińsko-mazurskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>992</td>\n",
       "      <td>992</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Clio IV</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>898.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>58000.0</td>\n",
       "      <td>Śląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>993</td>\n",
       "      <td>993</td>\n",
       "      <td>Fiat</td>\n",
       "      <td>Tipo II</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>47350.0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>996</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>42700.0</td>\n",
       "      <td>25400.0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>999</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>XC 60 I</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>13617.0</td>\n",
       "      <td>136900.0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>420 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       marka     model  rok_produkcji rodzaj_silnika  \\\n",
       "2      2        Opel  Zafira A         2004.0    Benzyna+CNG   \n",
       "3      3     Hyundai     i10 I         2008.0        Benzyna   \n",
       "4      4  Volkswagen        CC         2010.0         Diesel   \n",
       "5      5        Fiat       500         2014.0    Elektryczny   \n",
       "8      8  Volkswagen        CC         2014.0         Diesel   \n",
       "..   ...         ...       ...            ...            ...   \n",
       "991  991   Chevrolet     Cruze         2010.0        Benzyna   \n",
       "992  992     Renault   Clio IV         2017.0        Benzyna   \n",
       "993  993        Fiat   Tipo II         2017.0        Benzyna   \n",
       "996  996       Škoda  Fabia II         2012.0        Benzyna   \n",
       "999  999       Volvo   XC 60 I         2016.0         Diesel   \n",
       "\n",
       "     pojemnosc_silnika  przebieg      cena          wojewodztwo  \n",
       "2               1600.0   99000.0    9800.0             Opolskie  \n",
       "3               1100.0   93000.0   11900.0              Łódzkie  \n",
       "4               1968.0  127428.0   49900.0        Wielkopolskie  \n",
       "5                  1.0   36800.0   74200.0              Śląskie  \n",
       "8               1968.0   52000.0   97000.0            Pomorskie  \n",
       "..                 ...       ...       ...                  ...  \n",
       "991             1598.0    7560.0   21900.0  Warmińsko-mazurskie  \n",
       "992              898.0       1.0   58000.0              Śląskie  \n",
       "993             1400.0       2.0   47350.0          Mazowieckie  \n",
       "996             1200.0   42700.0   25400.0            Lubelskie  \n",
       "999             1969.0   13617.0  136900.0          Małopolskie  \n",
       "\n",
       "[420 rows x 9 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#zwrocenie rekordow na podstawie wyrazen logicznych\n",
    "cars[cars.przebieg < 130000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Opolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>995</td>\n",
       "      <td>995</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>159</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2387.0</td>\n",
       "      <td>182000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>996</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>42700.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>997</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Modus</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>168111.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>998</td>\n",
       "      <td>Audi</td>\n",
       "      <td>A3 8L</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>226500.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>999</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>XC 60 I</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>13617.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       marka        model  rok_produkcji rodzaj_silnika  \\\n",
       "0      0      Nissan  X-Trail III         2014.0         Diesel   \n",
       "1      1         BMW       X1 E84         2012.0         Diesel   \n",
       "2      2        Opel     Zafira A         2004.0    Benzyna+CNG   \n",
       "3      3     Hyundai        i10 I         2008.0        Benzyna   \n",
       "4      4  Volkswagen           CC         2010.0         Diesel   \n",
       "..   ...         ...          ...            ...            ...   \n",
       "995  995  Alfa Romeo          159         2009.0         Diesel   \n",
       "996  996       Škoda     Fabia II         2012.0        Benzyna   \n",
       "997  997     Renault        Modus         2004.0        Benzyna   \n",
       "998  998        Audi        A3 8L         2000.0        Benzyna   \n",
       "999  999       Volvo      XC 60 I         2016.0         Diesel   \n",
       "\n",
       "     pojemnosc_silnika  przebieg  cena     wojewodztwo  \n",
       "0                  0.0       0.0     0    Dolnośląskie  \n",
       "1               2000.0       0.0     0  Świętokrzyskie  \n",
       "2               1600.0   99000.0     0        Opolskie  \n",
       "3               1100.0   93000.0     0         Łódzkie  \n",
       "4               1968.0  127428.0     0   Wielkopolskie  \n",
       "..                 ...       ...   ...             ...  \n",
       "995             2387.0  182000.0     0     Małopolskie  \n",
       "996             1200.0   42700.0     0       Lubelskie  \n",
       "997             1200.0  168111.0     0         Łódzkie  \n",
       "998             1595.0  226500.0     0     Małopolskie  \n",
       "999             1969.0   13617.0     0     Małopolskie  \n",
       "\n",
       "[1000 rows x 9 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#ustawianie wartosci w kolumnie za pomoca NumPy\n",
    "cars.loc[:,'cena'] = np.array([0] * len(cars))\n",
    "cars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BMW</td>\n",
       "      <td>X1 E84</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Świętokrzyskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Opel</td>\n",
       "      <td>Zafira A</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna+CNG</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Opolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Hyundai</td>\n",
       "      <td>i10 I</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>CC</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1968.0</td>\n",
       "      <td>127428.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>995</td>\n",
       "      <td>995</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>159</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2387.0</td>\n",
       "      <td>182000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>996</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>42700.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>997</td>\n",
       "      <td>Renault</td>\n",
       "      <td>Modus</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>168111.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Łódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>998</td>\n",
       "      <td>Audi</td>\n",
       "      <td>A3 8L</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>226500.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>999</td>\n",
       "      <td>Volvo</td>\n",
       "      <td>XC 60 I</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1969.0</td>\n",
       "      <td>13617.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       marka        model  rok_produkcji rodzaj_silnika  \\\n",
       "0      0      Nissan  X-Trail III         2014.0         Diesel   \n",
       "1      1         BMW       X1 E84         2012.0         Diesel   \n",
       "2      2        Opel     Zafira A         2004.0    Benzyna+CNG   \n",
       "3      3     Hyundai        i10 I         2008.0        Benzyna   \n",
       "4      4  Volkswagen           CC         2010.0         Diesel   \n",
       "..   ...         ...          ...            ...            ...   \n",
       "995  995  Alfa Romeo          159         2009.0         Diesel   \n",
       "996  996       Škoda     Fabia II         2012.0        Benzyna   \n",
       "997  997     Renault        Modus         2004.0        Benzyna   \n",
       "998  998        Audi        A3 8L         2000.0        Benzyna   \n",
       "999  999       Volvo      XC 60 I         2016.0         Diesel   \n",
       "\n",
       "     pojemnosc_silnika  przebieg  cena     wojewodztwo  \n",
       "0                  0.0       0.0     0    Dolnośląskie  \n",
       "1               2000.0       0.0     0  Świętokrzyskie  \n",
       "2               1600.0   99000.0     0        Opolskie  \n",
       "3               1100.0   93000.0     0         Łódzkie  \n",
       "4               1968.0  127428.0     0   Wielkopolskie  \n",
       "..                 ...       ...   ...             ...  \n",
       "995             2387.0  182000.0     0     Małopolskie  \n",
       "996             1200.0   42700.0     0       Lubelskie  \n",
       "997             1200.0  168111.0     0         Łódzkie  \n",
       "998             1595.0  226500.0     0     Małopolskie  \n",
       "999             1969.0   13617.0     0     Małopolskie  \n",
       "\n",
       "[1000 rows x 9 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#usuwanie kolumn, ktora posiadaja brakujace dane (w naszym wypadku nic nie zostanie usuniete)\n",
    "cars.dropna(how='any')\n",
    "#cars.fillna(value=...) - w tym miejscu moglibysmy uzupelnic nasze brakujace dane\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        402.8\n",
       "1        802.6\n",
       "2      20521.2\n",
       "3      19222.2\n",
       "4      26282.0\n",
       "        ...   \n",
       "995    37478.2\n",
       "996     9381.6\n",
       "997    34462.4\n",
       "998    46218.6\n",
       "999     3720.2\n",
       "Length: 1000, dtype: float64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#zwrocenie sredniej danych\n",
    "cars.mean()\n",
    "#mozemy tez sprecyzowac, z ktorej osi chcemy pobrac nasze statystyki\n",
    "cars.mean(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Nissan</td>\n",
       "      <td>X-Trail III</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NissanBMW</td>\n",
       "      <td>X-Trail IIIX1 E84</td>\n",
       "      <td>4026.0</td>\n",
       "      <td>DieselDiesel</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>NissanBMWOpel</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira A</td>\n",
       "      <td>6030.0</td>\n",
       "      <td>DieselDieselBenzyna+CNG</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>NissanBMWOpelHyundai</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira Ai10 I</td>\n",
       "      <td>8038.0</td>\n",
       "      <td>DieselDieselBenzyna+CNGBenzyna</td>\n",
       "      <td>4700.0</td>\n",
       "      <td>192000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskieŁódzkie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>NissanBMWOpelHyundaiVolkswagen</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira Ai10 ICC</td>\n",
       "      <td>10048.0</td>\n",
       "      <td>DieselDieselBenzyna+CNGBenzynaDiesel</td>\n",
       "      <td>6668.0</td>\n",
       "      <td>319428.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>995</td>\n",
       "      <td>495510</td>\n",
       "      <td>NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...</td>\n",
       "      <td>2000977.0</td>\n",
       "      <td>DieselDieselBenzyna+CNGBenzynaDieselElektryczn...</td>\n",
       "      <td>2032501.0</td>\n",
       "      <td>131796749.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>496506</td>\n",
       "      <td>NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...</td>\n",
       "      <td>2002989.0</td>\n",
       "      <td>DieselDieselBenzyna+CNGBenzynaDieselElektryczn...</td>\n",
       "      <td>2033701.0</td>\n",
       "      <td>131839449.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>497503</td>\n",
       "      <td>NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...</td>\n",
       "      <td>2004993.0</td>\n",
       "      <td>DieselDieselBenzyna+CNGBenzynaDieselElektryczn...</td>\n",
       "      <td>2034901.0</td>\n",
       "      <td>132007560.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>498501</td>\n",
       "      <td>NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...</td>\n",
       "      <td>2006993.0</td>\n",
       "      <td>DieselDieselBenzyna+CNGBenzynaDieselElektryczn...</td>\n",
       "      <td>2036496.0</td>\n",
       "      <td>132234060.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>499500</td>\n",
       "      <td>NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...</td>\n",
       "      <td>X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...</td>\n",
       "      <td>2009009.0</td>\n",
       "      <td>DieselDieselBenzyna+CNGBenzynaDieselElektryczn...</td>\n",
       "      <td>2038465.0</td>\n",
       "      <td>132247677.0</td>\n",
       "      <td>0</td>\n",
       "      <td>DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                                              marka  \\\n",
       "0         0                                             Nissan   \n",
       "1         1                                          NissanBMW   \n",
       "2         3                                      NissanBMWOpel   \n",
       "3         6                               NissanBMWOpelHyundai   \n",
       "4        10                     NissanBMWOpelHyundaiVolkswagen   \n",
       "..      ...                                                ...   \n",
       "995  495510  NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...   \n",
       "996  496506  NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...   \n",
       "997  497503  NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...   \n",
       "998  498501  NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...   \n",
       "999  499500  NissanBMWOpelHyundaiVolkswagenFiatNissanSeatVo...   \n",
       "\n",
       "                                                 model  rok_produkcji  \\\n",
       "0                                          X-Trail III         2014.0   \n",
       "1                                    X-Trail IIIX1 E84         4026.0   \n",
       "2                            X-Trail IIIX1 E84Zafira A         6030.0   \n",
       "3                       X-Trail IIIX1 E84Zafira Ai10 I         8038.0   \n",
       "4                     X-Trail IIIX1 E84Zafira Ai10 ICC        10048.0   \n",
       "..                                                 ...            ...   \n",
       "995  X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...      2000977.0   \n",
       "996  X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...      2002989.0   \n",
       "997  X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...      2004993.0   \n",
       "998  X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...      2006993.0   \n",
       "999  X-Trail IIIX1 E84Zafira Ai10 ICC500X-Trail ITo...      2009009.0   \n",
       "\n",
       "                                        rodzaj_silnika  pojemnosc_silnika  \\\n",
       "0                                               Diesel                0.0   \n",
       "1                                         DieselDiesel             2000.0   \n",
       "2                              DieselDieselBenzyna+CNG             3600.0   \n",
       "3                       DieselDieselBenzyna+CNGBenzyna             4700.0   \n",
       "4                 DieselDieselBenzyna+CNGBenzynaDiesel             6668.0   \n",
       "..                                                 ...                ...   \n",
       "995  DieselDieselBenzyna+CNGBenzynaDieselElektryczn...          2032501.0   \n",
       "996  DieselDieselBenzyna+CNGBenzynaDieselElektryczn...          2033701.0   \n",
       "997  DieselDieselBenzyna+CNGBenzynaDieselElektryczn...          2034901.0   \n",
       "998  DieselDieselBenzyna+CNGBenzynaDieselElektryczn...          2036496.0   \n",
       "999  DieselDieselBenzyna+CNGBenzynaDieselElektryczn...          2038465.0   \n",
       "\n",
       "        przebieg  cena                                        wojewodztwo  \n",
       "0            0.0     0                                       Dolnośląskie  \n",
       "1            0.0     0                         DolnośląskieŚwiętokrzyskie  \n",
       "2        99000.0     0                 DolnośląskieŚwiętokrzyskieOpolskie  \n",
       "3       192000.0     0          DolnośląskieŚwiętokrzyskieOpolskieŁódzkie  \n",
       "4       319428.0     0  DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...  \n",
       "..           ...   ...                                                ...  \n",
       "995  131796749.0     0  DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...  \n",
       "996  131839449.0     0  DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...  \n",
       "997  132007560.0     0  DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...  \n",
       "998  132234060.0     0  DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...  \n",
       "999  132247677.0     0  DolnośląskieŚwiętokrzyskieOpolskieŁódzkieWielk...  \n",
       "\n",
       "[1000 rows x 9 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#zwrocenie lacznej sumy naszych danych - do kazdego n rekordu, dodawane sa wartosci z rekordu n-1\n",
    "cars.apply(np.cumsum)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>id</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>marka</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",
       "      <td>Alfa Romeo</td>\n",
       "      <td>2583</td>\n",
       "      <td>10017.0</td>\n",
       "      <td>10187.0</td>\n",
       "      <td>1031000.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Audi</td>\n",
       "      <td>33819</td>\n",
       "      <td>140642.0</td>\n",
       "      <td>151369.0</td>\n",
       "      <td>10262448.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BMW</td>\n",
       "      <td>34521</td>\n",
       "      <td>132576.0</td>\n",
       "      <td>149663.0</td>\n",
       "      <td>9613004.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Chevrolet</td>\n",
       "      <td>6166</td>\n",
       "      <td>22066.0</td>\n",
       "      <td>29449.0</td>\n",
       "      <td>1651121.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Chrysler</td>\n",
       "      <td>532</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>2736.0</td>\n",
       "      <td>112070.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Citroën</td>\n",
       "      <td>19053</td>\n",
       "      <td>80299.0</td>\n",
       "      <td>64257.0</td>\n",
       "      <td>6536047.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Dacia</td>\n",
       "      <td>1983</td>\n",
       "      <td>10071.0</td>\n",
       "      <td>6636.0</td>\n",
       "      <td>238818.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Daewoo</td>\n",
       "      <td>906</td>\n",
       "      <td>3996.0</td>\n",
       "      <td>2591.0</td>\n",
       "      <td>321500.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Daihatsu</td>\n",
       "      <td>919</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>105060.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Dodge</td>\n",
       "      <td>3493</td>\n",
       "      <td>10042.0</td>\n",
       "      <td>10615.0</td>\n",
       "      <td>687500.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Fiat</td>\n",
       "      <td>19667</td>\n",
       "      <td>66284.0</td>\n",
       "      <td>49071.0</td>\n",
       "      <td>4394379.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Ford</td>\n",
       "      <td>28730</td>\n",
       "      <td>118562.0</td>\n",
       "      <td>102996.0</td>\n",
       "      <td>8070220.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Honda</td>\n",
       "      <td>12181</td>\n",
       "      <td>50261.0</td>\n",
       "      <td>42545.0</td>\n",
       "      <td>2179568.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Hyundai</td>\n",
       "      <td>13750</td>\n",
       "      <td>62378.0</td>\n",
       "      <td>49574.0</td>\n",
       "      <td>2381919.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Infiniti</td>\n",
       "      <td>294</td>\n",
       "      <td>4030.0</td>\n",
       "      <td>7396.0</td>\n",
       "      <td>123396.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Jaguar</td>\n",
       "      <td>1040</td>\n",
       "      <td>4010.0</td>\n",
       "      <td>4967.0</td>\n",
       "      <td>464050.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Jeep</td>\n",
       "      <td>2357</td>\n",
       "      <td>12048.0</td>\n",
       "      <td>14600.0</td>\n",
       "      <td>665004.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Kia</td>\n",
       "      <td>12883</td>\n",
       "      <td>50274.0</td>\n",
       "      <td>42334.0</td>\n",
       "      <td>3387697.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Lancia</td>\n",
       "      <td>436</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>1248.0</td>\n",
       "      <td>135800.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Land Rover</td>\n",
       "      <td>2296</td>\n",
       "      <td>10072.0</td>\n",
       "      <td>12996.0</td>\n",
       "      <td>227931.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Lexus</td>\n",
       "      <td>4258</td>\n",
       "      <td>14056.0</td>\n",
       "      <td>20480.0</td>\n",
       "      <td>1011160.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Ligier</td>\n",
       "      <td>548</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>505.0</td>\n",
       "      <td>49000.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Maserati</td>\n",
       "      <td>726</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Mazda</td>\n",
       "      <td>10544</td>\n",
       "      <td>42160.0</td>\n",
       "      <td>39175.0</td>\n",
       "      <td>3188937.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Mercedes-Benz</td>\n",
       "      <td>29910</td>\n",
       "      <td>118397.0</td>\n",
       "      <td>158961.0</td>\n",
       "      <td>9449417.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Mini</td>\n",
       "      <td>6218</td>\n",
       "      <td>22105.0</td>\n",
       "      <td>19076.0</td>\n",
       "      <td>935310.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Mitsubishi</td>\n",
       "      <td>7627</td>\n",
       "      <td>36175.0</td>\n",
       "      <td>30380.0</td>\n",
       "      <td>2331122.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Nissan</td>\n",
       "      <td>17612</td>\n",
       "      <td>66328.0</td>\n",
       "      <td>51462.0</td>\n",
       "      <td>3505594.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Opel</td>\n",
       "      <td>51995</td>\n",
       "      <td>210872.0</td>\n",
       "      <td>176233.0</td>\n",
       "      <td>14753003.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Peugeot</td>\n",
       "      <td>21050</td>\n",
       "      <td>82371.0</td>\n",
       "      <td>65635.0</td>\n",
       "      <td>5127316.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Pontiac</td>\n",
       "      <td>68</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>3100.0</td>\n",
       "      <td>199000.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Porsche</td>\n",
       "      <td>516</td>\n",
       "      <td>4024.0</td>\n",
       "      <td>7800.0</td>\n",
       "      <td>214300.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Renault</td>\n",
       "      <td>29870</td>\n",
       "      <td>118552.0</td>\n",
       "      <td>94252.0</td>\n",
       "      <td>7590843.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Saab</td>\n",
       "      <td>1292</td>\n",
       "      <td>6018.0</td>\n",
       "      <td>194885.0</td>\n",
       "      <td>628000.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Seat</td>\n",
       "      <td>9122</td>\n",
       "      <td>40172.0</td>\n",
       "      <td>32143.0</td>\n",
       "      <td>2740050.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Smart</td>\n",
       "      <td>391</td>\n",
       "      <td>4008.0</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>169000.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SsangYong</td>\n",
       "      <td>1746</td>\n",
       "      <td>6035.0</td>\n",
       "      <td>6097.0</td>\n",
       "      <td>300045.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Subaru</td>\n",
       "      <td>498</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>141000.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Suzuki</td>\n",
       "      <td>6858</td>\n",
       "      <td>32119.0</td>\n",
       "      <td>26616.0</td>\n",
       "      <td>1637890.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Toyota</td>\n",
       "      <td>25209</td>\n",
       "      <td>98476.0</td>\n",
       "      <td>82911.0</td>\n",
       "      <td>5530591.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Volkswagen</td>\n",
       "      <td>45406</td>\n",
       "      <td>184889.0</td>\n",
       "      <td>165272.0</td>\n",
       "      <td>12530409.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Volvo</td>\n",
       "      <td>12070</td>\n",
       "      <td>48195.0</td>\n",
       "      <td>47520.0</td>\n",
       "      <td>4227080.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Škoda</td>\n",
       "      <td>18357</td>\n",
       "      <td>72392.0</td>\n",
       "      <td>55707.0</td>\n",
       "      <td>3400038.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  id  rok_produkcji  pojemnosc_silnika    przebieg  cena\n",
       "marka                                                                   \n",
       "Alfa Romeo      2583        10017.0            10187.0   1031000.0     0\n",
       "Audi           33819       140642.0           151369.0  10262448.0     0\n",
       "BMW            34521       132576.0           149663.0   9613004.0     0\n",
       "Chevrolet       6166        22066.0            29449.0   1651121.0     0\n",
       "Chrysler         532         2002.0             2736.0    112070.0     0\n",
       "Citroën        19053        80299.0            64257.0   6536047.0     0\n",
       "Dacia           1983        10071.0             6636.0    238818.0     0\n",
       "Daewoo           906         3996.0             2591.0    321500.0     0\n",
       "Daihatsu         919         2007.0             1595.0    105060.0     0\n",
       "Dodge           3493        10042.0            10615.0    687500.0     0\n",
       "Fiat           19667        66284.0            49071.0   4394379.0     0\n",
       "Ford           28730       118562.0           102996.0   8070220.0     0\n",
       "Honda          12181        50261.0            42545.0   2179568.0     0\n",
       "Hyundai        13750        62378.0            49574.0   2381919.0     0\n",
       "Infiniti         294         4030.0             7396.0    123396.0     0\n",
       "Jaguar          1040         4010.0             4967.0    464050.0     0\n",
       "Jeep            2357        12048.0            14600.0    665004.0     0\n",
       "Kia            12883        50274.0            42334.0   3387697.0     0\n",
       "Lancia           436         2007.0             1248.0    135800.0     0\n",
       "Land Rover      2296        10072.0            12996.0    227931.0     0\n",
       "Lexus           4258        14056.0            20480.0   1011160.0     0\n",
       "Ligier           548         2007.0              505.0     49000.0     0\n",
       "Maserati         726         2016.0               30.0        40.0     0\n",
       "Mazda          10544        42160.0            39175.0   3188937.0     0\n",
       "Mercedes-Benz  29910       118397.0           158961.0   9449417.0     0\n",
       "Mini            6218        22105.0            19076.0    935310.0     0\n",
       "Mitsubishi      7627        36175.0            30380.0   2331122.0     0\n",
       "Nissan         17612        66328.0            51462.0   3505594.0     0\n",
       "Opel           51995       210872.0           176233.0  14753003.0     0\n",
       "Peugeot        21050        82371.0            65635.0   5127316.0     0\n",
       "Pontiac           68         1994.0             3100.0    199000.0     0\n",
       "Porsche          516         4024.0             7800.0    214300.0     0\n",
       "Renault        29870       118552.0            94252.0   7590843.0     0\n",
       "Saab            1292         6018.0           194885.0    628000.0     0\n",
       "Seat            9122        40172.0            32143.0   2740050.0     0\n",
       "Smart            391         4008.0             1800.0    169000.0     0\n",
       "SsangYong       1746         6035.0             6097.0    300045.0     0\n",
       "Subaru           498         2004.0             1600.0    141000.0     0\n",
       "Suzuki          6858        32119.0            26616.0   1637890.0     0\n",
       "Toyota         25209        98476.0            82911.0   5530591.0     0\n",
       "Volkswagen     45406       184889.0           165272.0  12530409.0     0\n",
       "Volvo          12070        48195.0            47520.0   4227080.0     0\n",
       "Škoda          18357        72392.0            55707.0   3400038.0     0"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#grupowanie wedlug podanej kolumny - mozemy grupowac po wiekszej ilosci kolumn, przesylajac je jako liste\n",
    "cars.groupby('marka').sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>id</th>\n",
       "      <th>marka</th>\n",
       "      <th>model</th>\n",
       "      <th>rok_produkcji</th>\n",
       "      <th>rodzaj_silnika</th>\n",
       "      <th>pojemnosc_silnika</th>\n",
       "      <th>przebieg</th>\n",
       "      <th>cena</th>\n",
       "      <th>wojewodztwo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>370</td>\n",
       "      <td>370</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>159</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>190000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Mazowieckie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>300</td>\n",
       "      <td>300</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>147</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>200000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>705</td>\n",
       "      <td>705</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>Spider</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>Benzyna+LPG</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>175000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>213</td>\n",
       "      <td>213</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>156</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>284000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Lubelskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>995</td>\n",
       "      <td>995</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>159</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>2387.0</td>\n",
       "      <td>182000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>313</td>\n",
       "      <td>313</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>146000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Pomorskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>733</td>\n",
       "      <td>733</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Octavia II</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>38246.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Wielkopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>978</td>\n",
       "      <td>978</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia II</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Diesel</td>\n",
       "      <td>1598.0</td>\n",
       "      <td>70776.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Dolnośląskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>346</td>\n",
       "      <td>346</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Fabia I</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1390.0</td>\n",
       "      <td>182315.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Małopolskie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>319</td>\n",
       "      <td>319</td>\n",
       "      <td>Škoda</td>\n",
       "      <td>Octavia II</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Benzyna</td>\n",
       "      <td>1595.0</td>\n",
       "      <td>157000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Lubuskie</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id       marka       model  rok_produkcji rodzaj_silnika  \\\n",
       "370  370  Alfa Romeo         159         2007.0         Diesel   \n",
       "300  300  Alfa Romeo         147         2002.0        Benzyna   \n",
       "705  705  Alfa Romeo      Spider         1995.0    Benzyna+LPG   \n",
       "213  213  Alfa Romeo         156         2004.0         Diesel   \n",
       "995  995  Alfa Romeo         159         2009.0         Diesel   \n",
       "..   ...         ...         ...            ...            ...   \n",
       "313  313       Škoda    Fabia II         2013.0         Diesel   \n",
       "733  733       Škoda  Octavia II         2010.0        Benzyna   \n",
       "978  978       Škoda    Fabia II         2014.0         Diesel   \n",
       "346  346       Škoda     Fabia I         2002.0        Benzyna   \n",
       "319  319       Škoda  Octavia II         2006.0        Benzyna   \n",
       "\n",
       "     pojemnosc_silnika  przebieg  cena    wojewodztwo  \n",
       "370             1900.0  190000.0     0    Mazowieckie  \n",
       "300             2000.0  200000.0     0      Lubelskie  \n",
       "705             2000.0  175000.0     0    Małopolskie  \n",
       "213             1900.0  284000.0     0      Lubelskie  \n",
       "995             2387.0  182000.0     0    Małopolskie  \n",
       "..                 ...       ...   ...            ...  \n",
       "313             1600.0  146000.0     0      Pomorskie  \n",
       "733             1200.0   38246.0     0  Wielkopolskie  \n",
       "978             1598.0   70776.0     0   Dolnośląskie  \n",
       "346             1390.0  182315.0     0    Małopolskie  \n",
       "319             1595.0  157000.0     0       Lubuskie  \n",
       "\n",
       "[1000 rows x 9 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#sortowanie wedlug podanej kolumny\n",
    "cars.sort_values(by=\"marka\")"
   ]
  },
  {
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}