# Naimportujeme potřebné knihovny
import numpy as np
import pandas as pd
from plotly.offline import iplot, init_notebook_mode
import plotly.graph_objs as go
# Následující řádek je potřebný pro vykreslení grafu v Jupyter Notebooku
init_notebook_mode()
houses = pd.read_csv('housing.csv')
houses.head()
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolArea | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 60 | RL | 65.0 | 8450 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Normal | 208500 |
1 | 2 | 20 | RL | 80.0 | 9600 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 5 | 2007 | WD | Normal | 181500 |
2 | 3 | 60 | RL | 68.0 | 11250 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 223500 |
3 | 4 | 70 | RL | 60.0 | 9550 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2006 | WD | Abnorml | 140000 |
4 | 5 | 60 | RL | 84.0 | 14260 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 12 | 2008 | WD | Normal | 250000 |
5 rows × 81 columns
Vyberte domy, které splňuji všechny podmínky:
LotAreaMeters
)LotShape
)YearBuilt
)SalePrice
)Kolik je domů, které splňují všechny podmínky?
Kolik je domů, které splňují alespoň jednu podmínku?
houses['LotAreaMeters'] = houses.LotArea/0.09290304
houses[
(houses.LotAreaMeters > 1000) &
(houses.LotShape == 'Reg') &
(houses.YearBuilt >= 2000) &
(houses.SalePrice <= 150000)
]
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | LotAreaMeters | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145 | 146 | 160 | RM | 24.0 | 2522 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2006 | WD | Normal | 130000 | 27146.582071 |
148 | 149 | 20 | RL | 63.0 | 7500 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2008 | WD | Normal | 141000 | 80729.328125 |
193 | 194 | 160 | RM | 24.0 | 2522 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2006 | WD | Normal | 130000 | 27146.582071 |
200 | 201 | 20 | RM | 80.0 | 8546 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 3 | 2010 | WD | Normal | 140000 | 91988.378421 |
203 | 204 | 120 | RM | NaN | 4438 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 1 | 2008 | WD | Normal | 149000 | 47770.234429 |
472 | 473 | 180 | RM | 35.0 | 3675 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 6 | 2008 | WD | Normal | 148000 | 39557.370781 |
578 | 579 | 160 | FV | 34.0 | 3604 | Pave | Pave | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Abnorml | 146000 | 38793.133142 |
593 | 594 | 120 | RM | NaN | 4435 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2009 | WD | Normal | 140000 | 47737.942698 |
613 | 614 | 20 | RL | 70.0 | 8402 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 12 | 2007 | New | Partial | 147000 | 90438.375321 |
690 | 691 | 120 | RM | NaN | 4426 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2008 | WD | Normal | 141000 | 47641.067504 |
721 | 722 | 120 | RM | NaN | 4426 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2010 | WD | Normal | 143000 | 47641.067504 |
811 | 812 | 120 | RM | NaN | 4438 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 6 | 2008 | ConLD | Normal | 144500 | 47770.234429 |
829 | 830 | 160 | FV | 24.0 | 2544 | Pave | Pave | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 7 | 2006 | WD | Normal | 147400 | 27383.388100 |
850 | 851 | 120 | RM | 36.0 | 4435 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 11 | 2007 | WD | Normal | 131500 | 47737.942698 |
1088 | 1089 | 160 | RM | 24.0 | 2522 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2006 | WD | Normal | 137500 | 27146.582071 |
1238 | 1239 | 20 | RL | 63.0 | 13072 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 3 | 2006 | WD | Abnorml | 142500 | 140705.836967 |
1297 | 1298 | 180 | RM | 35.0 | 3675 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 6 | 2006 | New | Partial | 140000 | 39557.370781 |
1304 | 1305 | 160 | RM | 32.0 | 3363 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2006 | WD | Normal | 130000 | 36199.030731 |
1324 | 1325 | 20 | RL | 75.0 | 9986 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 2 | 2007 | New | Partial | 147000 | 107488.409421 |
1364 | 1365 | 160 | FV | 30.0 | 3180 | Pave | Pave | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2006 | WD | Abnorml | 144152 | 34229.235125 |
1368 | 1369 | 120 | RM | NaN | 4435 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 6 | 2009 | WD | Normal | 144000 | 47737.942698 |
1422 | 1423 | 120 | RM | 37.0 | 4435 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 3 | 2008 | WD | Normal | 136500 | 47737.942698 |
1441 | 1442 | 120 | RM | NaN | 4426 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2008 | WD | Normal | 149300 | 47641.067504 |
1452 | 1453 | 180 | RM | 35.0 | 3675 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2006 | WD | Normal | 145000 | 39557.370781 |
1453 | 1454 | 20 | RL | 90.0 | 17217 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 7 | 2006 | WD | Abnorml | 84500 | 185322.245644 |
25 rows × 82 columns
houses[
(houses.LotAreaMeters > 1000) |
(houses.LotShape == 'Reg') |
(houses.YearBuilt >= 2000) |
(houses.SalePrice <= 150000)
]
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | LotAreaMeters | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 60 | RL | 65.0 | 8450 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Normal | 208500 | 90955.043021 |
1 | 2 | 20 | RL | 80.0 | 9600 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2007 | WD | Normal | 181500 | 103333.540000 |
2 | 3 | 60 | RL | 68.0 | 11250 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 223500 | 121093.992188 |
3 | 4 | 70 | RL | 60.0 | 9550 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 2 | 2006 | WD | Abnorml | 140000 | 102795.344480 |
4 | 5 | 60 | RL | 84.0 | 14260 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 12 | 2008 | WD | Normal | 250000 | 153493.362542 |
5 | 6 | 50 | RL | 85.0 | 14115 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | MnPrv | Shed | 700 | 10 | 2009 | WD | Normal | 143000 | 151932.595532 |
6 | 7 | 20 | RL | 75.0 | 10084 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 8 | 2007 | WD | Normal | 307000 | 108543.272642 |
7 | 8 | 60 | RL | NaN | 10382 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | Shed | 350 | 11 | 2009 | WD | Normal | 200000 | 111750.917946 |
8 | 9 | 50 | RM | 51.0 | 6120 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2008 | WD | Abnorml | 129900 | 65875.131750 |
9 | 10 | 190 | RL | 50.0 | 7420 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 1 | 2008 | WD | Normal | 118000 | 79868.215292 |
10 | 11 | 20 | RL | 70.0 | 11200 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Normal | 129500 | 120555.796667 |
11 | 12 | 60 | RL | 85.0 | 11924 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 7 | 2006 | New | Partial | 345000 | 128348.867809 |
12 | 13 | 20 | RL | NaN | 12968 | Pave | NaN | IR2 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 144000 | 139586.390284 |
13 | 14 | 20 | RL | 91.0 | 10652 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 8 | 2007 | New | Partial | 279500 | 114657.173759 |
14 | 15 | 20 | RL | NaN | 10920 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | GdWo | NaN | 0 | 5 | 2008 | WD | Normal | 157000 | 117541.901750 |
15 | 16 | 45 | RM | 51.0 | 6120 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | GdPrv | NaN | 0 | 7 | 2007 | WD | Normal | 132000 | 65875.131750 |
16 | 17 | 20 | RL | NaN | 11241 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | Shed | 700 | 3 | 2010 | WD | Normal | 149000 | 120997.116994 |
17 | 18 | 90 | RL | 72.0 | 10791 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | Shed | 500 | 10 | 2006 | WD | Normal | 90000 | 116153.357307 |
18 | 19 | 20 | RL | 66.0 | 13695 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 6 | 2008 | WD | Normal | 159000 | 147411.753157 |
19 | 20 | 20 | RL | 70.0 | 7560 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | MnPrv | NaN | 0 | 5 | 2009 | COD | Abnorml | 139000 | 81375.162750 |
20 | 21 | 60 | RL | 101.0 | 14215 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 11 | 2006 | New | Partial | 325300 | 153008.986574 |
21 | 22 | 45 | RM | 57.0 | 7449 | Pave | Grvl | Reg | Bnk | AllPub | ... | NaN | GdPrv | NaN | 0 | 6 | 2007 | WD | Normal | 139400 | 80180.368694 |
22 | 23 | 20 | RL | 75.0 | 9742 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 230000 | 104862.015280 |
23 | 24 | 120 | RM | 44.0 | 4224 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 6 | 2007 | WD | Normal | 129900 | 45466.757600 |
24 | 25 | 20 | RL | NaN | 8246 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | MnPrv | NaN | 0 | 5 | 2010 | WD | Normal | 154000 | 88759.205296 |
25 | 26 | 20 | RL | 110.0 | 14230 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 7 | 2009 | WD | Normal | 256300 | 153170.445230 |
26 | 27 | 20 | RL | 60.0 | 7200 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2010 | WD | Normal | 134800 | 77500.155000 |
27 | 28 | 20 | RL | 98.0 | 11478 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2010 | WD | Normal | 306000 | 123548.163763 |
28 | 29 | 20 | RL | 47.0 | 16321 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 12 | 2006 | WD | Normal | 207500 | 175677.781911 |
29 | 30 | 30 | RM | 60.0 | 6324 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2008 | WD | Normal | 68500 | 68070.969475 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
1430 | 1431 | 60 | RL | 60.0 | 21930 | Pave | NaN | IR3 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 7 | 2006 | WD | Normal | 192140 | 236052.555438 |
1431 | 1432 | 120 | RL | NaN | 4928 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 10 | 2009 | WD | Normal | 143750 | 53044.550534 |
1432 | 1433 | 30 | RL | 60.0 | 10800 | Pave | Grvl | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 8 | 2007 | WD | Normal | 64500 | 116250.232500 |
1433 | 1434 | 60 | RL | 93.0 | 10261 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2008 | WD | Normal | 186500 | 110448.484786 |
1434 | 1435 | 20 | RL | 80.0 | 17400 | Pave | NaN | Reg | Low | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2006 | WD | Normal | 160000 | 187292.041251 |
1435 | 1436 | 20 | RL | 80.0 | 8400 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | GdPrv | NaN | 0 | 7 | 2008 | COD | Abnorml | 174000 | 90416.847500 |
1436 | 1437 | 20 | RL | 60.0 | 9000 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | GdWo | NaN | 0 | 5 | 2007 | WD | Normal | 120500 | 96875.193750 |
1437 | 1438 | 20 | RL | 96.0 | 12444 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 11 | 2008 | New | Partial | 394617 | 133946.101226 |
1438 | 1439 | 20 | RM | 90.0 | 7407 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | MnPrv | NaN | 0 | 4 | 2010 | WD | Normal | 149700 | 79728.284457 |
1439 | 1440 | 60 | RL | 80.0 | 11584 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 11 | 2007 | WD | Normal | 197000 | 124689.138267 |
1440 | 1441 | 70 | RL | 79.0 | 11526 | Pave | NaN | IR1 | Bnk | AllPub | ... | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 191000 | 124064.831463 |
1441 | 1442 | 120 | RM | NaN | 4426 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2008 | WD | Normal | 149300 | 47641.067504 |
1442 | 1443 | 60 | FV | 85.0 | 11003 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2009 | WD | Normal | 310000 | 118435.306315 |
1443 | 1444 | 30 | RL | NaN | 8854 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2009 | WD | Normal | 121000 | 95303.662830 |
1444 | 1445 | 20 | RL | 63.0 | 8500 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 11 | 2007 | WD | Normal | 179600 | 91493.238542 |
1445 | 1446 | 85 | RL | 70.0 | 8400 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2007 | WD | Normal | 129000 | 90416.847500 |
1446 | 1447 | 20 | RL | NaN | 26142 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2010 | WD | Normal | 157900 | 281390.146114 |
1447 | 1448 | 60 | RL | 80.0 | 10000 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 12 | 2007 | WD | Normal | 240000 | 107639.104167 |
1448 | 1449 | 50 | RL | 70.0 | 11767 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | GdWo | NaN | 0 | 5 | 2007 | WD | Normal | 112000 | 126658.933873 |
1449 | 1450 | 180 | RM | 21.0 | 1533 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 8 | 2006 | WD | Abnorml | 92000 | 16501.074669 |
1450 | 1451 | 90 | RL | 60.0 | 9000 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 9 | 2009 | WD | Normal | 136000 | 96875.193750 |
1451 | 1452 | 20 | RL | 78.0 | 9262 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2009 | New | Partial | 287090 | 99695.338280 |
1452 | 1453 | 180 | RM | 35.0 | 3675 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2006 | WD | Normal | 145000 | 39557.370781 |
1453 | 1454 | 20 | RL | 90.0 | 17217 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 7 | 2006 | WD | Abnorml | 84500 | 185322.245644 |
1454 | 1455 | 20 | FV | 62.0 | 7500 | Pave | Pave | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 10 | 2009 | WD | Normal | 185000 | 80729.328125 |
1455 | 1456 | 60 | RL | 62.0 | 7917 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 8 | 2007 | WD | Normal | 175000 | 85217.878769 |
1456 | 1457 | 20 | RL | 85.0 | 13175 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | MnPrv | NaN | 0 | 2 | 2010 | WD | Normal | 210000 | 141814.519740 |
1457 | 1458 | 70 | RL | 66.0 | 9042 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | GdPrv | Shed | 2500 | 5 | 2010 | WD | Normal | 266500 | 97327.277988 |
1458 | 1459 | 20 | RL | 68.0 | 9717 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 4 | 2010 | WD | Normal | 142125 | 104592.917519 |
1459 | 1460 | 20 | RL | 75.0 | 9937 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 6 | 2008 | WD | Normal | 147500 | 106960.977811 |
1460 rows × 82 columns
Seskupte řádky dle druhu střechy (RoofStyle
) a stavu exteriéru (ExterCond
) a zobrazte minimální a maximální cenu a počet nemovitostí.
houses.groupby(['RoofStyle', 'ExterCond']).SalePrice.agg(['min', 'max', 'count'])
min | max | count | ||
---|---|---|---|---|
RoofStyle | ExterCond | |||
Flat | Gd | 129000 | 274970 | 4 |
TA | 82000 | 256000 | 9 | |
Gable | Ex | 325000 | 325000 | 1 |
Fa | 39300 | 169500 | 22 | |
Gd | 68400 | 475000 | 116 | |
Po | 76500 | 76500 | 1 | |
TA | 34900 | 755000 | 1001 | |
Gambrel | Ex | 161000 | 161000 | 1 |
Fa | 40000 | 81000 | 2 | |
Gd | 103600 | 107400 | 2 | |
TA | 125000 | 259500 | 6 | |
Hip | Ex | 118000 | 118000 | 1 |
Fa | 55000 | 140000 | 4 | |
Gd | 82500 | 625000 | 23 | |
TA | 55993 | 745000 | 258 | |
Mansard | Gd | 242000 | 242000 | 1 |
TA | 100000 | 265979 | 6 | |
Shed | TA | 190000 | 260000 | 2 |
Vytvořte seznam, kde každý prvek bude ve formátu: 'Cena (CZK): {:.0f}, Plocha (m^2): {:.0f}'
.
Pro vytvoření ceny v korunách, počítejte s kurzem 22.55 CZK.
text = []
for i, row in houses.iterrows():
text.append('Cena (CZK): {:.0f}, Plocha (m^2): {:.0f}'.format(row.SalePrice * 22.55, row.LotAreaMeters))
text
['Cena (CZK): 4701675, Plocha (m^2): 90955', 'Cena (CZK): 4092825, Plocha (m^2): 103334', 'Cena (CZK): 5039925, Plocha (m^2): 121094', 'Cena (CZK): 3157000, Plocha (m^2): 102795', 'Cena (CZK): 5637500, Plocha (m^2): 153493', 'Cena (CZK): 3224650, Plocha (m^2): 151933', 'Cena (CZK): 6922850, Plocha (m^2): 108543', 'Cena (CZK): 4510000, Plocha (m^2): 111751', 'Cena (CZK): 2929245, Plocha (m^2): 65875', 'Cena (CZK): 2660900, Plocha (m^2): 79868', 'Cena (CZK): 2920225, Plocha (m^2): 120556', 'Cena (CZK): 7779750, Plocha (m^2): 128349', 'Cena (CZK): 3247200, Plocha (m^2): 139586', 'Cena (CZK): 6302725, Plocha (m^2): 114657', 'Cena (CZK): 3540350, Plocha (m^2): 117542', 'Cena (CZK): 2976600, Plocha (m^2): 65875', 'Cena (CZK): 3359950, Plocha (m^2): 120997', 'Cena (CZK): 2029500, Plocha (m^2): 116153', 'Cena (CZK): 3585450, Plocha (m^2): 147412', 'Cena (CZK): 3134450, Plocha (m^2): 81375', 'Cena (CZK): 7335515, Plocha (m^2): 153009', 'Cena (CZK): 3143470, Plocha (m^2): 80180', 'Cena (CZK): 5186500, Plocha (m^2): 104862', 'Cena (CZK): 2929245, Plocha (m^2): 45467', 'Cena (CZK): 3472700, Plocha (m^2): 88759', 'Cena (CZK): 5779565, Plocha (m^2): 153170', 'Cena (CZK): 3039740, Plocha (m^2): 77500', 'Cena (CZK): 6900300, Plocha (m^2): 123548', 'Cena (CZK): 4679125, Plocha (m^2): 175678', 'Cena (CZK): 1544675, Plocha (m^2): 68071', 'Cena (CZK): 902000, Plocha (m^2): 91493', 'Cena (CZK): 3367842, Plocha (m^2): 91967', 'Cena (CZK): 4056745, Plocha (m^2): 118930', 'Cena (CZK): 3732025, Plocha (m^2): 113581', 'Cena (CZK): 6257625, Plocha (m^2): 78716', 'Cena (CZK): 6967950, Plocha (m^2): 144430', 'Cena (CZK): 3269750, Plocha (m^2): 116885', 'Cena (CZK): 3450150, Plocha (m^2): 91838', 'Cena (CZK): 2457950, Plocha (m^2): 85272', 'Cena (CZK): 1849100, Plocha (m^2): 65014', 'Cena (CZK): 3608000, Plocha (m^2): 93194', 'Cena (CZK): 3833500, Plocha (m^2): 181964', 'Cena (CZK): 3247200, Plocha (m^2): 98813', 'Cena (CZK): 2937138, Plocha (m^2): 99028', 'Cena (CZK): 3179550, Plocha (m^2): 85519', 'Cena (CZK): 7213745, Plocha (m^2): 82430', 'Cena (CZK): 5404919, Plocha (m^2): 138015', 'Cena (CZK): 5630735, Plocha (m^2): 119436', 'Cena (CZK): 2548150, Plocha (m^2): 47964', 'Cena (CZK): 2863850, Plocha (m^2): 83334', 'Cena (CZK): 3991350, Plocha (m^2): 149285', 'Cena (CZK): 2581975, Plocha (m^2): 67167', 'Cena (CZK): 2480500, Plocha (m^2): 91192', 'Cena (CZK): 8681750, Plocha (m^2): 541113', 'Cena (CZK): 2931500, Plocha (m^2): 76790', 'Cena (CZK): 4070275, Plocha (m^2): 109523', 'Cena (CZK): 3889875, Plocha (m^2): 28471', 'Cena (CZK): 4431075, Plocha (m^2): 125346', 'Cena (CZK): 9894489, Plocha (m^2): 147272', 'Cena (CZK): 2816495, Plocha (m^2): 77500', 'Cena (CZK): 3562900, Plocha (m^2): 140706', 'Cena (CZK): 2277550, Plocha (m^2): 77500', 'Cena (CZK): 4566375, Plocha (m^2): 69341', 'Cena (CZK): 3157000, Plocha (m^2): 110868', 'Cena (CZK): 4949725, Plocha (m^2): 100912', 'Cena (CZK): 7148350, Plocha (m^2): 103237', 'Cena (CZK): 4059000, Plocha (m^2): 214202', 'Cena (CZK): 5096300, Plocha (m^2): 114797', 'Cena (CZK): 1804000, Plocha (m^2): 49600', 'Cena (CZK): 5073750, Plocha (m^2): 167842', 'Cena (CZK): 5502200, Plocha (m^2): 146938', 'Cena (CZK): 2920225, Plocha (m^2): 81795', 'Cena (CZK): 4171750, Plocha (m^2): 109157', 'Cena (CZK): 3267495, Plocha (m^2): 109792', 'Cena (CZK): 2421870, Plocha (m^2): 62323', 'Cena (CZK): 2052050, Plocha (m^2): 17179', 'Cena (CZK): 3061162, Plocha (m^2): 91224', 'Cena (CZK): 2863850, Plocha (m^2): 92946', 'Cena (CZK): 3078075, Plocha (m^2): 116013', 'Cena (CZK): 2480500, Plocha (m^2): 112375', 'Cena (CZK): 4363425, Plocha (m^2): 139931', 'Cena (CZK): 3461425, Plocha (m^2): 48438', 'Cena (CZK): 5524750, Plocha (m^2): 109856', 'Cena (CZK): 2852575, Plocha (m^2): 95713', 'Cena (CZK): 3799675, Plocha (m^2): 91816', 'Cena (CZK): 5863000, Plocha (m^2): 172858', 'Cena (CZK): 3923700, Plocha (m^2): 128209', 'Cena (CZK): 3709475, Plocha (m^2): 42528', 'Cena (CZK): 1916750, Plocha (m^2): 91170', 'Cena (CZK): 2787180, Plocha (m^2): 86865', 'Cena (CZK): 2478245, Plocha (m^2): 77500', 'Cena (CZK): 2223430, Plocha (m^2): 91493', 'Cena (CZK): 3686925, Plocha (m^2): 143806', 'Cena (CZK): 3019445, Plocha (m^2): 77500', 'Cena (CZK): 4617112, Plocha (m^2): 100503', 'Cena (CZK): 4171750, Plocha (m^2): 105110', 'Cena (CZK): 4825700, Plocha (m^2): 110481', 'Cena (CZK): 2136612, Plocha (m^2): 117553', 'Cena (CZK): 1871650, Plocha (m^2): 114367', 'Cena (CZK): 2907822, Plocha (m^2): 100320', 'Cena (CZK): 4622750, Plocha (m^2): 114130', 'Cena (CZK): 4013900, Plocha (m^2): 99093', 'Cena (CZK): 2682638, Plocha (m^2): 75541', 'Cena (CZK): 4485195, Plocha (m^2): 111966', 'Cena (CZK): 3822225, Plocha (m^2): 83506', 'Cena (CZK): 5637500, Plocha (m^2): 100912', 'Cena (CZK): 2255000, Plocha (m^2): 116250', 'Cena (CZK): 2593250, Plocha (m^2): 64583', 'Cena (CZK): 2593250, Plocha (m^2): 91493', 'Cena (CZK): 4284500, Plocha (m^2): 126487', 'Cena (CZK): 3087095, Plocha (m^2): 102526', 'Cena (CZK): 4059000, Plocha (m^2): 83420', 'Cena (CZK): 8658524, Plocha (m^2): 107262', 'Cena (CZK): 4893350, Plocha (m^2): 226042', 'Cena (CZK): 5851725, Plocha (m^2): 78135', 'Cena (CZK): 3968800, Plocha (m^2): 34767', 'Cena (CZK): 3134450, Plocha (m^2): 125034', 'Cena (CZK): 3495250, Plocha (m^2): 91881', 'Cena (CZK): 7216000, Plocha (m^2): 133214', 'Cena (CZK): 3697974, Plocha (m^2): 91073', 'Cena (CZK): 4059000, Plocha (m^2): 230918', 'Cena (CZK): 2255000, Plocha (m^2): 65229', 'Cena (CZK): 3066800, Plocha (m^2): 101870', 'Cena (CZK): 3470445, Plocha (m^2): 84949', 'Cena (CZK): 4081550, Plocha (m^2): 183449', 'Cena (CZK): 1905475, Plocha (m^2): 72979', 'Cena (CZK): 2886400, Plocha (m^2): 53045', 'Cena (CZK): 1961850, Plocha (m^2): 47232', 'Cena (CZK): 3495250, Plocha (m^2): 81698', 'Cena (CZK): 3382500, Plocha (m^2): 96585', 'Cena (CZK): 5096300, Plocha (m^2): 152848', 'Cena (CZK): 5502200, Plocha (m^2): 131578', 'Cena (CZK): 3399412, Plocha (m^2): 79524', 'Cena (CZK): 4961000, Plocha (m^2): 73765', 'Cena (CZK): 4059000, Plocha (m^2): 111245', 'Cena (CZK): 3923700, Plocha (m^2): 111945', 'Cena (CZK): 3224650, Plocha (m^2): 111460', 'Cena (CZK): 3856050, Plocha (m^2): 119156', 'Cena (CZK): 5186500, Plocha (m^2): 97586', 'Cena (CZK): 5220325, Plocha (m^2): 166044', 'Cena (CZK): 2593250, Plocha (m^2): 113021', 'Cena (CZK): 5863000, Plocha (m^2): 125346', 'Cena (CZK): 3743300, Plocha (m^2): 91709', 'Cena (CZK): 4600200, Plocha (m^2): 111245', 'Cena (CZK): 2818750, Plocha (m^2): 97952', 'Cena (CZK): 2931500, Plocha (m^2): 27147', 'Cena (CZK): 2367750, Plocha (m^2): 65875', 'Cena (CZK): 5017375, Plocha (m^2): 102311', 'Cena (CZK): 3179550, Plocha (m^2): 80729', 'Cena (CZK): 2593250, Plocha (m^2): 67167', 'Cena (CZK): 2751100, Plocha (m^2): 111471', 'Cena (CZK): 8397665, Plocha (m^2): 149521', 'Cena (CZK): 4284500, Plocha (m^2): 159338', 'Cena (CZK): 5299250, Plocha (m^2): 145313', 'Cena (CZK): 2818750, Plocha (m^2): 122063', 'Cena (CZK): 1781450, Plocha (m^2): 103334', 'Cena (CZK): 2469225, Plocha (m^2): 77500', 'Cena (CZK): 6077225, Plocha (m^2): 129199', 'Cena (CZK): 5747995, Plocha (m^2): 135109', 'Cena (CZK): 7216000, Plocha (m^2): 208583', 'Cena (CZK): 3664375, Plocha (m^2): 119695', 'Cena (CZK): 9301875, Plocha (m^2): 147336', 'Cena (CZK): 4961000, Plocha (m^2): 131126', 'Cena (CZK): 2327160, Plocha (m^2): 59202', 'Cena (CZK): 3427600, Plocha (m^2): 58125', 'Cena (CZK): 2875125, Plocha (m^2): 108780', 'Cena (CZK): 4284500, Plocha (m^2): 115260', 'Cena (CZK): 7342821, Plocha (m^2): 113688', 'Cena (CZK): 4137925, Plocha (m^2): 88738', 'Cena (CZK): 5141400, Plocha (m^2): 179424', 'Cena (CZK): 2897675, Plocha (m^2): 133020', 'Cena (CZK): 4848250, Plocha (m^2): 341969', 'Cena (CZK): 5389450, Plocha (m^2): 57113', 'Cena (CZK): 3675650, Plocha (m^2): 109760', 'Cena (CZK): 4149200, Plocha (m^2): 133645', 'Cena (CZK): 5479650, Plocha (m^2): 135787', 'Cena (CZK): 4758050, Plocha (m^2): 107951', 'Cena (CZK): 3889875, Plocha (m^2): 146927', 'Cena (CZK): 11316424, Plocha (m^2): 187540', 'Cena (CZK): 2255000, Plocha (m^2): 91709', 'Cena (CZK): 3991350, Plocha (m^2): 22787', 'Cena (CZK): 4512255, Plocha (m^2): 81677', 'Cena (CZK): 2706000, Plocha (m^2): 97521', 'Cena (CZK): 4510000, Plocha (m^2): 122988', 'Cena (CZK): 2863850, Plocha (m^2): 80062', 'Cena (CZK): 10711250, Plocha (m^2): 247032', 'Cena (CZK): 3901150, Plocha (m^2): 107069', 'Cena (CZK): 3044250, Plocha (m^2): 112052', 'Cena (CZK): 3457749, Plocha (m^2): 75541', 'Cena (CZK): 6449300, Plocha (m^2): 52991', 'Cena (CZK): 7103250, Plocha (m^2): 113775', 'Cena (CZK): 4149200, Plocha (m^2): 80428', 'Cena (CZK): 4329600, Plocha (m^2): 97058', 'Cena (CZK): 2931500, Plocha (m^2): 27147', 'Cena (CZK): 2863850, Plocha (m^2): 77285', 'Cena (CZK): 3348675, Plocha (m^2): 24542', 'Cena (CZK): 7032714, Plocha (m^2): 101353', 'Cena (CZK): 5299250, Plocha (m^2): 273608', 'Cena (CZK): 2345200, Plocha (m^2): 59417', 'Cena (CZK): 6198995, Plocha (m^2): 103237', 'Cena (CZK): 3157000, Plocha (m^2): 91988', 'Cena (CZK): 3867325, Plocha (m^2): 108985', 'Cena (CZK): 2525600, Plocha (m^2): 75347', 'Cena (CZK): 3359950, Plocha (m^2): 47770', 'Cena (CZK): 2480500, Plocha (m^2): 37674', 'Cena (CZK): 4070275, Plocha (m^2): 127563', 'Cena (CZK): 3244945, Plocha (m^2): 147175', 'Cena (CZK): 3179550, Plocha (m^2): 134474', 'Cena (CZK): 6246350, Plocha (m^2): 154613', 'Cena (CZK): 3269750, Plocha (m^2): 88802', 'Cena (CZK): 2209900, Plocha (m^2): 60321', 'Cena (CZK): 4194300, Plocha (m^2): 112160', 'Cena (CZK): 5697889, Plocha (m^2): 93000', 'Cena (CZK): 3517800, Plocha (m^2): 146045', 'Cena (CZK): 3647462, Plocha (m^2): 117327', 'Cena (CZK): 3031848, Plocha (m^2): 107758', 'Cena (CZK): 4735500, Plocha (m^2): 90955', 'Cena (CZK): 2412850, Plocha (m^2): 106627', 'Cena (CZK): 7024325, Plocha (m^2): 168563', 'Cena (CZK): 3771262, Plocha (m^2): 32399', 'Cena (CZK): 4620495, Plocha (m^2): 96768', 'Cena (CZK): 4510000, Plocha (m^2): 86843', 'Cena (CZK): 4056745, Plocha (m^2): 123516', 'Cena (CZK): 2187350, Plocha (m^2): 113021', 'Cena (CZK): 8709938, Plocha (m^2): 145011', 'Cena (CZK): 2525600, Plocha (m^2): 18083', 'Cena (CZK): 6539500, Plocha (m^2): 107101', 'Cena (CZK): 2390300, Plocha (m^2): 20118', 'Cena (CZK): 2818750, Plocha (m^2): 91719', 'Cena (CZK): 4340875, Plocha (m^2): 34251', 'Cena (CZK): 3337400, Plocha (m^2): 94292', 'Cena (CZK): 9087650, Plocha (m^2): 162944', 'Cena (CZK): 2130975, Plocha (m^2): 18083', 'Cena (CZK): 2890910, Plocha (m^2): 114636', 'Cena (CZK): 4882075, Plocha (m^2): 84507', 'Cena (CZK): 2018225, Plocha (m^2): 18083', 'Cena (CZK): 4183025, Plocha (m^2): 94432', 'Cena (CZK): 4385975, Plocha (m^2): 101751', 'Cena (CZK): 7170900, Plocha (m^2): 129490', 'Cena (CZK): 2548150, Plocha (m^2): 94087', 'Cena (CZK): 5919375, Plocha (m^2): 96875', 'Cena (CZK): 2491775, Plocha (m^2): 41764', 'Cena (CZK): 1781450, Plocha (m^2): 53820', 'Cena (CZK): 2706000, Plocha (m^2): 115841', 'Cena (CZK): 4622750, Plocha (m^2): 95584', 'Cena (CZK): 5445825, Plocha (m^2): 111945', 'Cena (CZK): 3089350, Plocha (m^2): 98404', 'Cena (CZK): 3157000, Plocha (m^2): 121740', 'Cena (CZK): 4059000, Plocha (m^2): 121815', 'Cena (CZK): 6246350, Plocha (m^2): 1711462', 'Cena (CZK): 1725075, Plocha (m^2): 57587', 'Cena (CZK): 5299250, Plocha (m^2): 51129', 'Cena (CZK): 3901150, Plocha (m^2): 90051', 'Cena (CZK): 3562900, Plocha (m^2): 100643', 'Cena (CZK): 3269750, Plocha (m^2): 90417', 'Cena (CZK): 5186500, Plocha (m^2): 94055', 'Cena (CZK): 4679125, Plocha (m^2): 94626', 'Cena (CZK): 4961000, Plocha (m^2): 94873', 'Cena (CZK): 5220325, Plocha (m^2): 133849', 'Cena (CZK): 2187350, Plocha (m^2): 136723', 'Cena (CZK): 3968800, Plocha (m^2): 207700', 'Cena (CZK): 6223800, Plocha (m^2): 103204', 'Cena (CZK): 3405050, Plocha (m^2): 91181', 'Cena (CZK): 2931500, Plocha (m^2): 59202', 'Cena (CZK): 1646150, Plocha (m^2): 56317', 'Cena (CZK): 3957525, Plocha (m^2): 130136', 'Cena (CZK): 4171750, Plocha (m^2): 120631', 'Cena (CZK): 4047725, Plocha (m^2): 90417', 'Cena (CZK): 2717275, Plocha (m^2): 74271', 'Cena (CZK): 3337400, Plocha (m^2): 85218', 'Cena (CZK): 5998300, Plocha (m^2): 115475', 'Cena (CZK): 5445825, Plocha (m^2): 420912', 'Cena (CZK): 6539500, Plocha (m^2): 126627', 'Cena (CZK): 3134450, Plocha (m^2): 103334', 'Cena (CZK): 2807475, Plocha (m^2): 89491', 'Cena (CZK): 4622750, Plocha (m^2): 78189', 'Cena (CZK): 4532550, Plocha (m^2): 98985', 'Cena (CZK): 3179550, Plocha (m^2): 206000', 'Cena (CZK): 9364970, Plocha (m^2): 155539', 'Cena (CZK): 4329600, Plocha (m^2): 107693', 'Cena (CZK): 5152675, Plocha (m^2): 121492', 'Cena (CZK): 4171750, Plocha (m^2): 77500', 'Cena (CZK): 4679125, Plocha (m^2): 54498', 'Cena (CZK): 5515730, Plocha (m^2): 103463', 'Cena (CZK): 4040960, Plocha (m^2): 86240', 'Cena (CZK): 3713985, Plocha (m^2): 45757', 'Cena (CZK): 3585450, Plocha (m^2): 105336', 'Cena (CZK): 1984400, Plocha (m^2): 87457', 'Cena (CZK): 2751100, Plocha (m^2): 105691', 'Cena (CZK): 3463116, Plocha (m^2): 93969', 'Cena (CZK): 5259336, Plocha (m^2): 168035', 'Cena (CZK): 3064545, Plocha (m^2): 61214', 'Cena (CZK): 2954050, Plocha (m^2): 122805', 'Cena (CZK): 5299250, Plocha (m^2): 179316', 'Cena (CZK): 3765850, Plocha (m^2): 103334', 'Cena (CZK): 3213375, Plocha (m^2): 85433', 'Cena (CZK): 3427600, Plocha (m^2): 147573', 'Cena (CZK): 5389450, Plocha (m^2): 79642', 'Cena (CZK): 3946250, Plocha (m^2): 125938', 'Cena (CZK): 3574175, Plocha (m^2): 150695', 'Cena (CZK): 3540350, Plocha (m^2): 169532', 'Cena (CZK): 6020850, Plocha (m^2): 174655', 'Cena (CZK): 4622750, Plocha (m^2): 147509', 'Cena (CZK): 3380245, Plocha (m^2): 105486', 'Cena (CZK): 6652250, Plocha (m^2): 197905', 'Cena (CZK): 6898045, Plocha (m^2): 111794', 'Cena (CZK): 5073750, Plocha (m^2): 145033', 'Cena (CZK): 2018225, Plocha (m^2): 85250', 'Cena (CZK): 1860375, Plocha (m^2): 132848', 'Cena (CZK): 8118000, Plocha (m^2): 133236', 'Cena (CZK): 3734280, Plocha (m^2): 82721', 'Cena (CZK): 2976600, Plocha (m^2): 86111', 'Cena (CZK): 2703745, Plocha (m^2): 83959', 'Cena (CZK): 8456250, Plocha (m^2): 2316878', 'Cena (CZK): 4013900, Plocha (m^2): 103334', 'Cena (CZK): 4250675, Plocha (m^2): 83905', 'Cena (CZK): 5863000, Plocha (m^2): 139985', 'Cena (CZK): 6088500, Plocha (m^2): 96875', 'Cena (CZK): 5863000, Plocha (m^2): 106563', 'Cena (CZK): 4228125, Plocha (m^2): 151933', 'Cena (CZK): 7726600, Plocha (m^2): 175010', 'Cena (CZK): 7982700, Plocha (m^2): 130233', 'Cena (CZK): 6787550, Plocha (m^2): 111729', 'Cena (CZK): 2845246, Plocha (m^2): 62646', 'Cena (CZK): 5457100, Plocha (m^2): 121363', 'Cena (CZK): 1961850, Plocha (m^2): 53820', 'Cena (CZK): 7306200, Plocha (m^2): 116745', 'Cena (CZK): 3275388, Plocha (m^2): 124861', 'Cena (CZK): 4836975, Plocha (m^2): 127961', 'Cena (CZK): 1758900, Plocha (m^2): 68911', 'Cena (CZK): 2683450, Plocha (m^2): 114356', 'Cena (CZK): 3134450, Plocha (m^2): 88006', 'Cena (CZK): 6404200, Plocha (m^2): 114689', 'Cena (CZK): 4667850, Plocha (m^2): 88243', 'Cena (CZK): 4329600, Plocha (m^2): 97327', 'Cena (CZK): 5162822, Plocha (m^2): 1772385', 'Cena (CZK): 8510956, Plocha (m^2): 152385', 'Cena (CZK): 4825700, Plocha (m^2): 98328', 'Cena (CZK): 4566375, Plocha (m^2): 152256', 'Cena (CZK): 3495250, Plocha (m^2): 133472', 'Cena (CZK): 4575395, Plocha (m^2): 152751', 'Cena (CZK): 1849100, Plocha (m^2): 90417', 'Cena (CZK): 1973125, Plocha (m^2): 91967', 'Cena (CZK): 5998300, Plocha (m^2): 95250', 'Cena (CZK): 1916750, Plocha (m^2): 27900', 'Cena (CZK): 3161510, Plocha (m^2): 69266', 'Cena (CZK): 3416325, Plocha (m^2): 137477', 'Cena (CZK): 3551625, Plocha (m^2): 189445', 'Cena (CZK): 3472700, Plocha (m^2): 26350', 'Cena (CZK): 9857823, Plocha (m^2): 219917', 'Cena (CZK): 7172276, Plocha (m^2): 84174', 'Cena (CZK): 4284500, Plocha (m^2): 56737', 'Cena (CZK): 2142250, Plocha (m^2): 97779', 'Cena (CZK): 2388045, Plocha (m^2): 91709', 'Cena (CZK): 3157000, Plocha (m^2): 90417', 'Cena (CZK): 4002625, Plocha (m^2): 121083', 'Cena (CZK): 3901150, Plocha (m^2): 99545', 'Cena (CZK): 3021700, Plocha (m^2): 45467', 'Cena (CZK): 2931500, Plocha (m^2): 74594', 'Cena (CZK): 6314000, Plocha (m^2): 129285', 'Cena (CZK): 3517800, Plocha (m^2): 81160', 'Cena (CZK): 3269750, Plocha (m^2): 98425', 'Cena (CZK): 4476175, Plocha (m^2): 78587', 'Cena (CZK): 2660900, Plocha (m^2): 18083', 'Cena (CZK): 4284500, Plocha (m^2): 202362', 'Cena (CZK): 3314850, Plocha (m^2): 115066', 'Cena (CZK): 3585450, Plocha (m^2): 102257', 'Cena (CZK): 3720750, Plocha (m^2): 98490', 'Cena (CZK): 2976600, Plocha (m^2): 83959', 'Cena (CZK): 3653100, Plocha (m^2): 105809', 'Cena (CZK): 3887620, Plocha (m^2): 87414', 'Cena (CZK): 3031442, Plocha (m^2): 184278', 'Cena (CZK): 2818750, Plocha (m^2): 77231', 'Cena (CZK): 2773650, Plocha (m^2): 114463', 'Cena (CZK): 4949725, Plocha (m^2): 88264', 'Cena (CZK): 1375550, Plocha (m^2): 107854', 'Cena (CZK): 3337400, Plocha (m^2): 95218', 'Cena (CZK): 7667000, Plocha (m^2): 119942', 'Cena (CZK): 8894442, Plocha (m^2): 122644', 'Cena (CZK): 4036450, Plocha (m^2): 87435', 'Cena (CZK): 2863850, Plocha (m^2): 53820', 'Cena (CZK): 4233762, Plocha (m^2): 77500', 'Cena (CZK): 4814425, Plocha (m^2): 99512', 'Cena (CZK): 1713800, Plocha (m^2): 96875', 'Cena (CZK): 5412000, Plocha (m^2): 571639', 'Cena (CZK): 4329600, Plocha (m^2): 34251', 'Cena (CZK): 1826550, Plocha (m^2): 90524', 'Cena (CZK): 2818750, Plocha (m^2): 77500', 'Cena (CZK): 4307050, Plocha (m^2): 100987', 'Cena (CZK): 9606300, Plocha (m^2): 134269', 'Cena (CZK): 2683450, Plocha (m^2): 90471', 'Cena (CZK): 4848250, Plocha (m^2): 131417', 'Cena (CZK): 2401575, Plocha (m^2): 89760', 'Cena (CZK): 2255000, Plocha (m^2): 80148', 'Cena (CZK): 2457950, Plocha (m^2): 109081', 'Cena (CZK): 2908950, Plocha (m^2): 103021', 'Cena (CZK): 2773650, Plocha (m^2): 77500', 'Cena (CZK): 3822225, Plocha (m^2): 81698', 'Cena (CZK): 1510850, Plocha (m^2): 96520', 'Cena (CZK): 5434550, Plocha (m^2): 87457', 'Cena (CZK): 5536025, Plocha (m^2): 161060', 'Cena (CZK): 3720524, Plocha (m^2): 94367', 'Cena (CZK): 2435400, Plocha (m^2): 109792', 'Cena (CZK): 5817900, Plocha (m^2): 130136', 'Cena (CZK): 3788400, Plocha (m^2): 111557', 'Cena (CZK): 3382500, Plocha (m^2): 107542', 'Cena (CZK): 2593250, Plocha (m^2): 112806', 'Cena (CZK): 3991350, Plocha (m^2): 167659', 'Cena (CZK): 6314000, Plocha (m^2): 152352', 'Cena (CZK): 7661362, Plocha (m^2): 116250', 'Cena (CZK): 1353000, Plocha (m^2): 103021', 'Cena (CZK): 3269750, Plocha (m^2): 372969', 'Cena (CZK): 5006100, Plocha (m^2): 47393', 'Cena (CZK): 2593250, Plocha (m^2): 96445', 'Cena (CZK): 5141400, Plocha (m^2): 120857', 'Cena (CZK): 4084572, Plocha (m^2): 95788', 'Cena (CZK): 3371225, Plocha (m^2): 84432', 'Cena (CZK): 5389450, Plocha (m^2): 241327', 'Cena (CZK): 2841300, Plocha (m^2): 87834', 'Cena (CZK): 3202100, Plocha (m^2): 90955', 'Cena (CZK): 4652065, Plocha (m^2): 75993', 'Cena (CZK): 4848250, Plocha (m^2): 179058', 'Cena (CZK): 2548150, Plocha (m^2): 234115', 'Cena (CZK): 7103250, Plocha (m^2): 99028', 'Cena (CZK): 3134450, Plocha (m^2): 96875', 'Cena (CZK): 3044250, Plocha (m^2): 36360', 'Cena (CZK): 6201250, Plocha (m^2): 137778', 'Cena (CZK): 2458130, Plocha (m^2): 92494', 'Cena (CZK): 4406270, Plocha (m^2): 72786', 'Cena (CZK): 3946250, Plocha (m^2): 123322', 'Cena (CZK): 1925770, Plocha (m^2): 18083', 'Cena (CZK): 1801745, Plocha (m^2): 60127', 'Cena (CZK): 2762375, Plocha (m^2): 20667', 'Cena (CZK): 4081550, Plocha (m^2): 116670', 'Cena (CZK): 1826550, Plocha (m^2): 20344', 'Cena (CZK): 4780600, Plocha (m^2): 114819', 'Cena (CZK): 2615800, Plocha (m^2): 47361', 'Cena (CZK): 2683450, Plocha (m^2): 64583', 'Cena (CZK): 2037392, Plocha (m^2): 46070', 'Cena (CZK): 2480500, Plocha (m^2): 132977', 'Cena (CZK): 12515250, Plocha (m^2): 166098', 'Cena (CZK): 2660900, Plocha (m^2): 130329', 'Cena (CZK): 3673395, Plocha (m^2): 67167', 'Cena (CZK): 3889875, Plocha (m^2): 42216', 'Cena (CZK): 4735500, Plocha (m^2): 94184', 'Cena (CZK): 2875125, Plocha (m^2): 106078', 'Cena (CZK): 4284500, Plocha (m^2): 177518', 'Cena (CZK): 4507745, Plocha (m^2): 120706', 'Cena (CZK): 2694725, Plocha (m^2): 92570', 'Cena (CZK): 2706000, Plocha (m^2): 64583', 'Cena (CZK): 2480500, Plocha (m^2): 61182', 'Cena (CZK): 6314000, Plocha (m^2): 761665', 'Cena (CZK): 4600200, Plocha (m^2): 100137', 'Cena (CZK): 4735500, Plocha (m^2): 96875', 'Cena (CZK): 4239400, Plocha (m^2): 100072', 'Cena (CZK): 3957525, Plocha (m^2): 103334', 'Cena (CZK): 2209900, Plocha (m^2): 49202', 'Cena (CZK): 5772800, Plocha (m^2): 572931', 'Cena (CZK): 3630550, Plocha (m^2): 54896', 'Cena (CZK): 2480500, Plocha (m^2): 75509', 'Cena (CZK): 5940459, Plocha (m^2): 86154', 'Cena (CZK): 3495250, Plocha (m^2): 77500', 'Cena (CZK): 1406737, Plocha (m^2): 89136', 'Cena (CZK): 4255185, Plocha (m^2): 129038', 'Cena (CZK): 2796200, Plocha (m^2): 90740', 'Cena (CZK): 4030587, Plocha (m^2): 33067', 'Cena (CZK): 3765850, Plocha (m^2): 114399', 'Cena (CZK): 3303575, Plocha (m^2): 102042', 'Cena (CZK): 5637500, Plocha (m^2): 123010', 'Cena (CZK): 4216850, Plocha (m^2): 100007', 'Cena (CZK): 4780600, Plocha (m^2): 73410', 'Cena (CZK): 4284500, Plocha (m^2): 128650', 'Cena (CZK): 3337400, Plocha (m^2): 39557', 'Cena (CZK): 9922000, Plocha (m^2): 161211', 'Cena (CZK): 5660050, Plocha (m^2): 57372', 'Cena (CZK): 2987875, Plocha (m^2): 91278', 'Cena (CZK): 4710695, Plocha (m^2): 141276', 'Cena (CZK): 8569000, Plocha (m^2): 147390', 'Cena (CZK): 6697350, Plocha (m^2): 114496', 'Cena (CZK): 2017571, Plocha (m^2): 63776', 'Cena (CZK): 7351300, Plocha (m^2): 172578', 'Cena (CZK): 8433700, Plocha (m^2): 127509', 'Cena (CZK): 3495250, Plocha (m^2): 26910', 'Cena (CZK): 3698200, Plocha (m^2): 48438', 'Cena (CZK): 2987875, Plocha (m^2): 83506', 'Cena (CZK): 3314850, Plocha (m^2): 103334', 'Cena (CZK): 3517800, Plocha (m^2): 110750', 'Cena (CZK): 3946250, Plocha (m^2): 131783', 'Cena (CZK): 3608000, Plocha (m^2): 116250', 'Cena (CZK): 1939300, Plocha (m^2): 16426', 'Cena (CZK): 2593250, Plocha (m^2): 28686', 'Cena (CZK): 2999150, Plocha (m^2): 102150', 'Cena (CZK): 3896302, Plocha (m^2): 167680', 'Cena (CZK): 3495250, Plocha (m^2): 85369', 'Cena (CZK): 2058815, Plocha (m^2): 62258', 'Cena (CZK): 786995, Plocha (m^2): 84809', 'Cena (CZK): 9696500, Plocha (m^2): 136616', 'Cena (CZK): 4149200, Plocha (m^2): 98167', 'Cena (CZK): 2931500, Plocha (m^2): 83959', 'Cena (CZK): 2706000, Plocha (m^2): 81106', 'Cena (CZK): 2548150, Plocha (m^2): 20344', 'Cena (CZK): 5112085, Plocha (m^2): 105519', 'Cena (CZK): 3157000, Plocha (m^2): 98705', 'Cena (CZK): 6516950, Plocha (m^2): 167939', 'Cena (CZK): 3314850, Plocha (m^2): 24843', 'Cena (CZK): 2807475, Plocha (m^2): 81763', 'Cena (CZK): 4848250, Plocha (m^2): 102838', 'Cena (CZK): 4697165, Plocha (m^2): 84626', 'Cena (CZK): 3630550, Plocha (m^2): 103334', 'Cena (CZK): 2807475, Plocha (m^2): 103334', 'Cena (CZK): 3718495, Plocha (m^2): 156712', 'Cena (CZK): 4570096, Plocha (m^2): 73108', 'Cena (CZK): 2929245, Plocha (m^2): 97952', 'Cena (CZK): 3021700, Plocha (m^2): 98888', 'Cena (CZK): 2176075, Plocha (m^2): 114033', 'Cena (CZK): 9084516, Plocha (m^2): 131535', 'Cena (CZK): 3562900, Plocha (m^2): 112461', 'Cena (CZK): 5975750, Plocha (m^2): 109878', 'Cena (CZK): 4758050, Plocha (m^2): 102591', 'Cena (CZK): 5276700, Plocha (m^2): 117520', 'Cena (CZK): 2395938, Plocha (m^2): 116250', 'Cena (CZK): 3382500, Plocha (m^2): 129038', 'Cena (CZK): 3585450, Plocha (m^2): 53820', 'Cena (CZK): 4166112, Plocha (m^2): 431568', 'Cena (CZK): 7120162, Plocha (m^2): 126874', 'Cena (CZK): 3968800, Plocha (m^2): 80729', 'Cena (CZK): 2976600, Plocha (m^2): 143160', 'Cena (CZK): 10063186, Plocha (m^2): 160899', 'Cena (CZK): 1939300, Plocha (m^2): 97930', 'Cena (CZK): 4524071, Plocha (m^2): 351635', 'Cena (CZK): 3946250, Plocha (m^2): 109792', 'Cena (CZK): 2886400, Plocha (m^2): 66252', 'Cena (CZK): 2424125, Plocha (m^2): 77500', 'Cena (CZK): 886215, Plocha (m^2): 53820', 'Cena (CZK): 4013900, Plocha (m^2): 97478', 'Cena (CZK): 2424125, Plocha (m^2): 75347', 'Cena (CZK): 4239400, Plocha (m^2): 96057', 'Cena (CZK): 2508688, Plocha (m^2): 137078', 'Cena (CZK): 3562900, Plocha (m^2): 124355', 'Cena (CZK): 6133600, Plocha (m^2): 122956', 'Cena (CZK): 7103250, Plocha (m^2): 157164', 'Cena (CZK): 5592400, Plocha (m^2): 118403', 'Cena (CZK): 4808788, Plocha (m^2): 109146', 'Cena (CZK): 2999150, Plocha (m^2): 43680', 'Cena (CZK): 4051446, Plocha (m^2): 184106', 'Cena (CZK): 5163950, Plocha (m^2): 148940', 'Cena (CZK): 4735500, Plocha (m^2): 94044', 'Cena (CZK): 2920225, Plocha (m^2): 77974', 'Cena (CZK): 2818750, Plocha (m^2): 88641', 'Cena (CZK): 5930650, Plocha (m^2): 100912', 'Cena (CZK): 3157000, Plocha (m^2): 43518', 'Cena (CZK): 2536875, Plocha (m^2): 64583', 'Cena (CZK): 5761525, Plocha (m^2): 119975', 'Cena (CZK): 2435400, Plocha (m^2): 94475', 'Cena (CZK): 6404200, Plocha (m^2): 114367', 'Cena (CZK): 2548150, Plocha (m^2): 68674', 'Cena (CZK): 3179550, Plocha (m^2): 159844', 'Cena (CZK): 2435400, Plocha (m^2): 118834', 'Cena (CZK): 3946250, Plocha (m^2): 235428', 'Cena (CZK): 5276700, Plocha (m^2): 34401', 'Cena (CZK): 2739825, Plocha (m^2): 122074', 'Cena (CZK): 3833500, Plocha (m^2): 107747', 'Cena (CZK): 2435400, Plocha (m^2): 149694', 'Cena (CZK): 4171750, Plocha (m^2): 234438', 'Cena (CZK): 6043400, Plocha (m^2): 143655', 'Cena (CZK): 2886400, Plocha (m^2): 73819', 'Cena (CZK): 7328750, Plocha (m^2): 120534', 'Cena (CZK): 4825700, Plocha (m^2): 109480', 'Cena (CZK): 7139330, Plocha (m^2): 132687', 'Cena (CZK): 3065898, Plocha (m^2): 75692', 'Cena (CZK): 3215630, Plocha (m^2): 141018', 'Cena (CZK): 2706000, Plocha (m^2): 78921', 'Cena (CZK): 5062475, Plocha (m^2): 141642', 'Cena (CZK): 3833500, Plocha (m^2): 107284', 'Cena (CZK): 3134450, Plocha (m^2): 113021', 'Cena (CZK): 2672175, Plocha (m^2): 91278', 'Cena (CZK): 3269750, Plocha (m^2): 67727', 'Cena (CZK): 3709475, Plocha (m^2): 126767', 'Cena (CZK): 3292300, Plocha (m^2): 38793', 'Cena (CZK): 2965325, Plocha (m^2): 130782', 'Cena (CZK): 4101845, Plocha (m^2): 156992', 'Cena (CZK): 5711757, Plocha (m^2): 136745', 'Cena (CZK): 2672175, Plocha (m^2): 127455', 'Cena (CZK): 7328750, Plocha (m^2): 145313', 'Cena (CZK): 2999150, Plocha (m^2): 65875', 'Cena (CZK): 8341245, Plocha (m^2): 123171', 'Cena (CZK): 2931500, Plocha (m^2): 110513', 'Cena (CZK): 3089350, Plocha (m^2): 94077', 'Cena (CZK): 3224650, Plocha (m^2): 270120', 'Cena (CZK): 1792725, Plocha (m^2): 97952', 'Cena (CZK): 4192045, Plocha (m^2): 89556', 'Cena (CZK): 10191472, Plocha (m^2): 145076', 'Cena (CZK): 3111900, Plocha (m^2): 71042', 'Cena (CZK): 3157000, Plocha (m^2): 47738', 'Cena (CZK): 2480500, Plocha (m^2): 86004', 'Cena (CZK): 7193450, Plocha (m^2): 121654', 'Cena (CZK): 2582065, Plocha (m^2): 38750', 'Cena (CZK): 4379233, Plocha (m^2): 42216', 'Cena (CZK): 4904625, Plocha (m^2): 139759', 'Cena (CZK): 3405050, Plocha (m^2): 20990', 'Cena (CZK): 6201250, Plocha (m^2): 117617', 'Cena (CZK): 3179550, Plocha (m^2): 96875', 'Cena (CZK): 4961000, Plocha (m^2): 108080', 'Cena (CZK): 3405050, Plocha (m^2): 34251', 'Cena (CZK): 4983550, Plocha (m^2): 137810', 'Cena (CZK): 4622750, Plocha (m^2): 146389', 'Cena (CZK): 3427600, Plocha (m^2): 134161', 'Cena (CZK): 5073750, Plocha (m^2): 83959', 'Cena (CZK): 8097705, Plocha (m^2): 130975', 'Cena (CZK): 2672175, Plocha (m^2): 85498', 'Cena (CZK): 7058150, Plocha (m^2): 118941', 'Cena (CZK): 3337400, Plocha (m^2): 111891', 'Cena (CZK): 5896825, Plocha (m^2): 127929', 'Cena (CZK): 3314850, Plocha (m^2): 90438', 'Cena (CZK): 1702525, Plocha (m^2): 16049', 'Cena (CZK): 3100625, Plocha (m^2): 94722', 'Cena (CZK): 4131160, Plocha (m^2): 84615', 'Cena (CZK): 2379025, Plocha (m^2): 77791', 'Cena (CZK): 7099033, Plocha (m^2): 125873', 'Cena (CZK): 6877750, Plocha (m^2): 131793', 'Cena (CZK): 1510850, Plocha (m^2): 88781', 'Cena (CZK): 5412000, Plocha (m^2): 116250', 'Cena (CZK): 3044250, Plocha (m^2): 76036', 'Cena (CZK): 3799675, Plocha (m^2): 22787', 'Cena (CZK): 3724132, Plocha (m^2): 111945', 'Cena (CZK): 3608000, Plocha (m^2): 107639', 'Cena (CZK): 3154745, Plocha (m^2): 132848', 'Cena (CZK): 3450150, Plocha (m^2): 103334', 'Cena (CZK): 3044250, Plocha (m^2): 124926', 'Cena (CZK): 3799675, Plocha (m^2): 97090', 'Cena (CZK): 2796200, Plocha (m^2): 96875', 'Cena (CZK): 4724225, Plocha (m^2): 49406', 'Cena (CZK): 1860375, Plocha (m^2): 128091', 'Cena (CZK): 3143470, Plocha (m^2): 99566', 'Cena (CZK): 3247200, Plocha (m^2): 75121', 'Cena (CZK): 4510000, Plocha (m^2): 117284', 'Cena (CZK): 1353000, Plocha (m^2): 65875', 'Cena (CZK): 2097150, Plocha (m^2): 64583', 'Cena (CZK): 1916750, Plocha (m^2): 94475', 'Cena (CZK): 5965851, Plocha (m^2): 42862', 'Cena (CZK): 6178700, Plocha (m^2): 136454', 'Cena (CZK): 5096300, Plocha (m^2): 75886', 'Cena (CZK): 7779750, Plocha (m^2): 149188', 'Cena (CZK): 3427600, Plocha (m^2): 116175', 'Cena (CZK): 8363299, Plocha (m^2): 98888', 'Cena (CZK): 3230288, Plocha (m^2): 113344', 'Cena (CZK): 2216665, Plocha (m^2): 77500', 'Cena (CZK): 3495250, Plocha (m^2): 112504', 'Cena (CZK): 3495250, Plocha (m^2): 82882', 'Cena (CZK): 1905475, Plocha (m^2): 20839', 'Cena (CZK): 4644172, Plocha (m^2): 87457', 'Cena (CZK): 2435400, Plocha (m^2): 97779', 'Cena (CZK): 4307050, Plocha (m^2): 94184', 'Cena (CZK): 3044250, Plocha (m^2): 111084', 'Cena (CZK): 7892500, Plocha (m^2): 112343', 'Cena (CZK): 1984400, Plocha (m^2): 18083', 'Cena (CZK): 3281025, Plocha (m^2): 107714', 'Cena (CZK): 3359950, Plocha (m^2): 77500', 'Cena (CZK): 2198625, Plocha (m^2): 188401', 'Cena (CZK): 3765850, Plocha (m^2): 106961', 'Cena (CZK): 4462645, Plocha (m^2): 133300', 'Cena (CZK): 9065100, Plocha (m^2): 501480', 'Cena (CZK): 2480500, Plocha (m^2): 145959', 'Cena (CZK): 3100625, Plocha (m^2): 107768', 'Cena (CZK): 9538650, Plocha (m^2): 224923', 'Cena (CZK): 5197775, Plocha (m^2): 120491', 'Cena (CZK): 2908950, Plocha (m^2): 198594', 'Cena (CZK): 4363425, Plocha (m^2): 87457', 'Cena (CZK): 3788400, Plocha (m^2): 152578', 'Cena (CZK): 3100625, Plocha (m^2): 124861', 'Cena (CZK): 3912425, Plocha (m^2): 92925', 'Cena (CZK): 2336180, Plocha (m^2): 71354', 'Cena (CZK): 3720750, Plocha (m^2): 121094', 'Cena (CZK): 5806625, Plocha (m^2): 155452', 'Cena (CZK): 3157000, Plocha (m^2): 99028', 'Cena (CZK): 3348675, Plocha (m^2): 24639', 'Cena (CZK): 1961850, Plocha (m^2): 103334', 'Cena (CZK): 2469225, Plocha (m^2): 97112', 'Cena (CZK): 8399875, Plocha (m^2): 127488', 'Cena (CZK): 2897675, Plocha (m^2): 107047', 'Cena (CZK): 3224650, Plocha (m^2): 86240', 'Cena (CZK): 3595237, Plocha (m^2): 48438', 'Cena (CZK): 3901150, Plocha (m^2): 31075', 'Cena (CZK): 6426750, Plocha (m^2): 121072', 'Cena (CZK): 4983550, Plocha (m^2): 180511', 'Cena (CZK): 4679125, Plocha (m^2): 54487', 'Cena (CZK): 5138581, Plocha (m^2): 109867', 'Cena (CZK): 3355440, Plocha (m^2): 54950', 'Cena (CZK): 8839600, Plocha (m^2): 87069', 'Cena (CZK): 4390485, Plocha (m^2): 81558', 'Cena (CZK): 3179550, Plocha (m^2): 47641', 'Cena (CZK): 17025250, Plocha (m^2): 231801', 'Cena (CZK): 7554250, Plocha (m^2): 281778', 'Cena (CZK): 2446224, Plocha (m^2): 58125', 'Cena (CZK): 3190825, Plocha (m^2): 65875', 'Cena (CZK): 3968800, Plocha (m^2): 148660', 'Cena (CZK): 2006950, Plocha (m^2): 64583', 'Cena (CZK): 2784925, Plocha (m^2): 69104', 'Cena (CZK): 3123175, Plocha (m^2): 90955', 'Cena (CZK): 4419800, Plocha (m^2): 46091', 'Cena (CZK): 7046875, Plocha (m^2): 154258', 'Cena (CZK): 3157000, Plocha (m^2): 103334', 'Cena (CZK): 8161273, Plocha (m^2): 133882', 'Cena (CZK): 3157000, Plocha (m^2): 82129', 'Cena (CZK): 4803150, Plocha (m^2): 90417', 'Cena (CZK): 1240250, Plocha (m^2): 60278', 'Cena (CZK): 6810100, Plocha (m^2): 1239454', 'Cena (CZK): 5727700, Plocha (m^2): 67167', 'Cena (CZK): 4048627, Plocha (m^2): 97069', 'Cena (CZK): 2478245, Plocha (m^2): 77091', 'Cena (CZK): 1172600, Plocha (m^2): 44455', 'Cena (CZK): 2317599, Plocha (m^2): 93775', 'Cena (CZK): 4261950, Plocha (m^2): 50278', 'Cena (CZK): 2908950, Plocha (m^2): 106272', 'Cena (CZK): 2942775, Plocha (m^2): 145496', 'Cena (CZK): 3720750, Plocha (m^2): 109146', 'Cena (CZK): 3596725, Plocha (m^2): 116250', 'Cena (CZK): 3540350, Plocha (m^2): 107639', 'Cena (CZK): 7689550, Plocha (m^2): 113473', 'Cena (CZK): 2897675, Plocha (m^2): 106778', 'Cena (CZK): 6201250, Plocha (m^2): 70644', 'Cena (CZK): 3224650, Plocha (m^2): 47641', 'Cena (CZK): 2807475, Plocha (m^2): 87403', 'Cena (CZK): 3044250, Plocha (m^2): 87963', 'Cena (CZK): 7216000, Plocha (m^2): 143009', 'Cena (CZK): 2717275, Plocha (m^2): 74917', 'Cena (CZK): 5006100, Plocha (m^2): 233523', 'Cena (CZK): 4385975, Plocha (m^2): 78727', 'Cena (CZK): 2480500, Plocha (m^2): 123516', 'Cena (CZK): 2322650, Plocha (m^2): 67167', 'Cena (CZK): 5333075, Plocha (m^2): 58007', 'Cena (CZK): 4228125, Plocha (m^2): 103226', 'Cena (CZK): 5017375, Plocha (m^2): 122752', 'Cena (CZK): 2963070, Plocha (m^2): 107639', 'Cena (CZK): 2435400, Plocha (m^2): 96638', 'Cena (CZK): 3675650, Plocha (m^2): 116250', 'Cena (CZK): 2108425, Plocha (m^2): 91967', 'Cena (CZK): 5409745, Plocha (m^2): 112623', 'Cena (CZK): 4036450, Plocha (m^2): 116250', 'Cena (CZK): 4284500, Plocha (m^2): 100244', 'Cena (CZK): 2976600, Plocha (m^2): 103334', 'Cena (CZK): 3202100, Plocha (m^2): 72850', 'Cena (CZK): 4036450, Plocha (m^2): 90955', 'Cena (CZK): 3946250, Plocha (m^2): 138704', 'Cena (CZK): 4059000, Plocha (m^2): 58071', 'Cena (CZK): 6760490, Plocha (m^2): 96477', 'Cena (CZK): 5321800, Plocha (m^2): 94669', 'Cena (CZK): 5997826, Plocha (m^2): 125938', 'Cena (CZK): 5872020, Plocha (m^2): 114022', 'Cena (CZK): 2209900, Plocha (m^2): 90471', 'Cena (CZK): 2176075, Plocha (m^2): 94722', 'Cena (CZK): 3653100, Plocha (m^2): 83420', 'Cena (CZK): 4893350, Plocha (m^2): 99415', 'Cena (CZK): 6212525, Plocha (m^2): 110222', 'Cena (CZK): 3517800, Plocha (m^2): 85358', 'Cena (CZK): 3889875, Plocha (m^2): 34767', 'Cena (CZK): 4780600, Plocha (m^2): 115917', 'Cena (CZK): 3583195, Plocha (m^2): 125034', 'Cena (CZK): 4045470, Plocha (m^2): 24542', 'Cena (CZK): 6539500, Plocha (m^2): 131933', 'Cena (CZK): 2875125, Plocha (m^2): 97952', 'Cena (CZK): 2255000, Plocha (m^2): 74389', 'Cena (CZK): 4852760, Plocha (m^2): 93000', 'Cena (CZK): 7599350, Plocha (m^2): 101504', 'Cena (CZK): 6088500, Plocha (m^2): 102785', 'Cena (CZK): 5956177, Plocha (m^2): 157013', 'Cena (CZK): 4431075, Plocha (m^2): 112171', 'Cena (CZK): 3608000, Plocha (m^2): 134635', 'Cena (CZK): 4889674, Plocha (m^2): 97952', 'Cena (CZK): 12131900, Plocha (m^2): 575912', 'Cena (CZK): 3041995, Plocha (m^2): 78060', 'Cena (CZK): 2300100, Plocha (m^2): 95551', 'Cena (CZK): 2412850, Plocha (m^2): 84163', 'Cena (CZK): 2581975, Plocha (m^2): 109254', 'Cena (CZK): 8907250, Plocha (m^2): 153127', 'Cena (CZK): 3653100, Plocha (m^2): 48438', 'Cena (CZK): 4994825, Plocha (m^2): 120663', 'Cena (CZK): 3213375, Plocha (m^2): 143698', 'Cena (CZK): 3247200, Plocha (m^2): 90417', 'Cena (CZK): 3044250, Plocha (m^2): 113344', 'Cena (CZK): 3968800, Plocha (m^2): 84766', 'Cena (CZK): 3966545, Plocha (m^2): 76994', 'Cena (CZK): 4219105, Plocha (m^2): 175290', 'Cena (CZK): 3732025, Plocha (m^2): 97962', 'Cena (CZK): 2886400, Plocha (m^2): 67813', 'Cena (CZK): 3641825, Plocha (m^2): 105379', 'Cena (CZK): 3134450, Plocha (m^2): 116250', 'Cena (CZK): 5254150, Plocha (m^2): 109168', 'Cena (CZK): 2433145, Plocha (m^2): 64583', 'Cena (CZK): 4228125, Plocha (m^2): 131374', 'Cena (CZK): 3612510, Plocha (m^2): 34251', 'Cena (CZK): 3310340, Plocha (m^2): 121987', 'Cena (CZK): 6083764, Plocha (m^2): 106778', 'Cena (CZK): 5073750, Plocha (m^2): 98576', 'Cena (CZK): 4385975, Plocha (m^2): 116595', 'Cena (CZK): 3856050, Plocha (m^2): 90417', 'Cena (CZK): 3235925, Plocha (m^2): 88232', 'Cena (CZK): 2480500, Plocha (m^2): 82635', 'Cena (CZK): 10936750, Plocha (m^2): 145507', 'Cena (CZK): 3946250, Plocha (m^2): 77500', 'Cena (CZK): 4510000, Plocha (m^2): 137757', 'Cena (CZK): 2478245, Plocha (m^2): 51667', 'Cena (CZK): 4261950, Plocha (m^2): 88253', 'Cena (CZK): 13145139, Plocha (m^2): 149521', 'Cena (CZK): 2660900, Plocha (m^2): 96875', 'Cena (CZK): 5134184, Plocha (m^2): 132116', 'Cena (CZK): 3055525, Plocha (m^2): 104948', 'Cena (CZK): 5039925, Plocha (m^2): 230175', 'Cena (CZK): 3606872, Plocha (m^2): 144236', 'Cena (CZK): 2390300, Plocha (m^2): 87188', 'Cena (CZK): 4081550, Plocha (m^2): 109146', 'Cena (CZK): 3258475, Plocha (m^2): 47770', 'Cena (CZK): 1262642, Plocha (m^2): 93775', 'Cena (CZK): 3560645, Plocha (m^2): 104948', 'Cena (CZK): 2615800, Plocha (m^2): 88781', 'Cena (CZK): 5071495, Plocha (m^2): 130642', 'Cena (CZK): 3089350, Plocha (m^2): 122978', 'Cena (CZK): 6111050, Plocha (m^2): 142783', 'Cena (CZK): 3495250, Plocha (m^2): 94895', 'Cena (CZK): 5051200, Plocha (m^2): 68577', 'Cena (CZK): 4126650, Plocha (m^2): 77780', 'Cena (CZK): 2097150, Plocha (m^2): 64583', 'Cena (CZK): 5073750, Plocha (m^2): 133408', 'Cena (CZK): 3145725, Plocha (m^2): 106563', 'Cena (CZK): 5245130, Plocha (m^2): 120728', 'Cena (CZK): 8681750, Plocha (m^2): 159338', 'Cena (CZK): 2469225, Plocha (m^2): 65983', 'Cena (CZK): 4261950, Plocha (m^2): 91805', 'Cena (CZK): 4171750, Plocha (m^2): 308903', 'Cena (CZK): 3323870, Plocha (m^2): 27383', 'Cena (CZK): 3743300, Plocha (m^2): 128091', 'Cena (CZK): 3405050, Plocha (m^2): 34229', 'Cena (CZK): 5344350, Plocha (m^2): 102774', 'Cena (CZK): 3765850, Plocha (m^2): 107682', 'Cena (CZK): 3155872, Plocha (m^2): 84766', 'Cena (CZK): 2886400, Plocha (m^2): 103334', 'Cena (CZK): 3461425, Plocha (m^2): 87188', 'Cena (CZK): 2255000, Plocha (m^2): 18083', 'Cena (CZK): 3247200, Plocha (m^2): 102526', 'Cena (CZK): 2942775, Plocha (m^2): 126659', 'Cena (CZK): 3157000, Plocha (m^2): 130835', 'Cena (CZK): 3551625, Plocha (m^2): 112375', 'Cena (CZK): 3943995, Plocha (m^2): 97090', 'Cena (CZK): 3179550, Plocha (m^2): 86111', 'Cena (CZK): 3470445, Plocha (m^2): 136325', 'Cena (CZK): 3856050, Plocha (m^2): 179187', 'Cena (CZK): 4803150, Plocha (m^2): 100287', 'Cena (CZK): 3010425, Plocha (m^2): 167088', 'Cena (CZK): 5412000, Plocha (m^2): 490834', 'Cena (CZK): 4216850, Plocha (m^2): 103334', 'Cena (CZK): 2965325, Plocha (m^2): 47738', 'Cena (CZK): 4848250, Plocha (m^2): 34401', 'Cena (CZK): 3698200, Plocha (m^2): 76725', 'Cena (CZK): 3562900, Plocha (m^2): 130189', 'Cena (CZK): 3833500, Plocha (m^2): 192889', 'Cena (CZK): 2863850, Plocha (m^2): 74239', 'Cena (CZK): 3314850, Plocha (m^2): 118080', 'Cena (CZK): 3923700, Plocha (m^2): 87457', 'Cena (CZK): 3427600, Plocha (m^2): 111945', 'Cena (CZK): 5637500, Plocha (m^2): 118715', 'Cena (CZK): 4283372, Plocha (m^2): 82258', 'Cena (CZK): 2965325, Plocha (m^2): 125130', 'Cena (CZK): 3427600, Plocha (m^2): 104109', 'Cena (CZK): 2987875, Plocha (m^2): 85369', 'Cena (CZK): 5650579, Plocha (m^2): 93000', 'Cena (CZK): 3348675, Plocha (m^2): 94184', 'Cena (CZK): 5612695, Plocha (m^2): 114700', 'Cena (CZK): 2908950, Plocha (m^2): 75024', 'Cena (CZK): 3810950, Plocha (m^2): 158897', 'Cena (CZK): 5321800, Plocha (m^2): 106972', 'Cena (CZK): 2469225, Plocha (m^2): 71042', 'Cena (CZK): 4521275, Plocha (m^2): 94184', 'Cena (CZK): 2615800, Plocha (m^2): 95713', 'Cena (CZK): 2999150, Plocha (m^2): 130717', 'Cena (CZK): 1499575, Plocha (m^2): 61570', 'Cena (CZK): 6843406, Plocha (m^2): 96875', 'Cena (CZK): 2982238, Plocha (m^2): 272176', 'Cena (CZK): 7892500, Plocha (m^2): 95088', 'Cena (CZK): 3337400, Plocha (m^2): 126820', 'Cena (CZK): 3078075, Plocha (m^2): 75347', 'Cena (CZK): 3540350, Plocha (m^2): 75606', 'Cena (CZK): 4228125, Plocha (m^2): 148090', 'Cena (CZK): 4013900, Plocha (m^2): 103721', 'Cena (CZK): 2672175, Plocha (m^2): 66779', 'Cena (CZK): 2255000, Plocha (m^2): 76962', 'Cena (CZK): 7416695, Plocha (m^2): 55100', 'Cena (CZK): 3269750, Plocha (m^2): 90342', 'Cena (CZK): 3055525, Plocha (m^2): 177239', 'Cena (CZK): 6043400, Plocha (m^2): 170769', 'Cena (CZK): 3371225, Plocha (m^2): 130889', 'Cena (CZK): 2771395, Plocha (m^2): 86800', 'Cena (CZK): 3889875, Plocha (m^2): 120384', 'Cena (CZK): 3483975, Plocha (m^2): 90568', 'Cena (CZK): 3720750, Plocha (m^2): 142988', 'Cena (CZK): 2680248, Plocha (m^2): 75541', 'Cena (CZK): 3157000, Plocha (m^2): 75950', 'Cena (CZK): 2401575, Plocha (m^2): 94346', 'Cena (CZK): 3223590, Plocha (m^2): 75541', 'Cena (CZK): 13792865, Plocha (m^2): 139059', 'Cena (CZK): 3044250, Plocha (m^2): 75272', 'Cena (CZK): 2480500, Plocha (m^2): 79007', 'Cena (CZK): 3450150, Plocha (m^2): 93775', 'Cena (CZK): 4059000, Plocha (m^2): 84766', 'Cena (CZK): 5412000, Plocha (m^2): 159941', 'Cena (CZK): 2830025, Plocha (m^2): 66446', 'Cena (CZK): 2886400, Plocha (m^2): 106778', 'Cena (CZK): 5750250, Plocha (m^2): 145324', 'Cena (CZK): 5637500, Plocha (m^2): 123785', 'Cena (CZK): 2954050, Plocha (m^2): 95637', 'Cena (CZK): 3923700, Plocha (m^2): 135507', 'Cena (CZK): 3479465, Plocha (m^2): 124861', 'Cena (CZK): 3235925, Plocha (m^2): 99954', 'Cena (CZK): 1984400, Plocha (m^2): 65875', 'Cena (CZK): 3269750, Plocha (m^2): 67490', 'Cena (CZK): 3917679, Plocha (m^2): 32292', 'Cena (CZK): 1691250, Plocha (m^2): 21539', 'Cena (CZK): 796263, Plocha (m^2): 96875', 'Cena (CZK): 3044250, Plocha (m^2): 184493', 'Cena (CZK): 5366900, Plocha (m^2): 141276', 'Cena (CZK): 3980075, Plocha (m^2): 118715', 'Cena (CZK): 4532550, Plocha (m^2): 91084', 'Cena (CZK): 3290045, Plocha (m^2): 94475', 'Cena (CZK): 3833274, Plocha (m^2): 110190', 'Cena (CZK): 4352150, Plocha (m^2): 86240', 'Cena (CZK): 4679125, Plocha (m^2): 110222', 'Cena (CZK): 3946250, Plocha (m^2): 168035', 'Cena (CZK): 6426750, Plocha (m^2): 129156', 'Cena (CZK): 3968800, Plocha (m^2): 106563', 'Cena (CZK): 5333075, Plocha (m^2): 127423', 'Cena (CZK): 5006100, Plocha (m^2): 139995', 'Cena (CZK): 4532550, Plocha (m^2): 96068', 'Cena (CZK): 2649625, Plocha (m^2): 97952', 'Cena (CZK): 7216000, Plocha (m^2): 125615', 'Cena (CZK): 4284500, Plocha (m^2): 91353', 'Cena (CZK): 5457100, Plocha (m^2): 297622', 'Cena (CZK): 1801745, Plocha (m^2): 62700', 'Cena (CZK): 4169495, Plocha (m^2): 108533', 'Cena (CZK): 5705150, Plocha (m^2): 104141', 'Cena (CZK): 5407467, Plocha (m^2): 94292', 'Cena (CZK): 5511220, Plocha (m^2): 259303', 'Cena (CZK): 3402795, Plocha (m^2): 136056', 'Cena (CZK): 4825700, Plocha (m^2): 94238', 'Cena (CZK): 3382500, Plocha (m^2): 83001', 'Cena (CZK): 3224650, Plocha (m^2): 269098', 'Cena (CZK): 3100625, Plocha (m^2): 154731', 'Cena (CZK): 2816495, Plocha (m^2): 94938', 'Cena (CZK): 3224650, Plocha (m^2): 87866', 'Cena (CZK): 6088500, Plocha (m^2): 156464', 'Cena (CZK): 4340875, Plocha (m^2): 150759', 'Cena (CZK): 4453625, Plocha (m^2): 100750', 'Cena (CZK): 2908950, Plocha (m^2): 77500', 'Cena (CZK): 2703745, Plocha (m^2): 83959', 'Cena (CZK): 3019445, Plocha (m^2): 77500', 'Cena (CZK): 3878600, Plocha (m^2): 119210', 'Cena (CZK): 2875125, Plocha (m^2): 101181', 'Cena (CZK): 3269750, Plocha (m^2): 76811', 'Cena (CZK): 2796200, Plocha (m^2): 13993', 'Cena (CZK): 2976600, Plocha (m^2): 79868', 'Cena (CZK): 4171750, Plocha (m^2): 90955', 'Cena (CZK): 3495250, Plocha (m^2): 27685', 'Cena (CZK): 2627075, Plocha (m^2): 77576', 'Cena (CZK): 6133600, Plocha (m^2): 131610', 'Cena (CZK): 3495250, Plocha (m^2): 24843', 'Cena (CZK): 5389450, Plocha (m^2): 128338', 'Cena (CZK): 4845995, Plocha (m^2): 121804', 'Cena (CZK): 4034195, Plocha (m^2): 110190', 'Cena (CZK): 3608000, Plocha (m^2): 103334', 'Cena (CZK): 3044250, Plocha (m^2): 79545', 'Cena (CZK): 854645, Plocha (m^2): 63776', 'Cena (CZK): 3157000, Plocha (m^2): 111751', 'Cena (CZK): 3044250, Plocha (m^2): 116250', 'Cena (CZK): 3901150, Plocha (m^2): 24413', 'Cena (CZK): 2243725, Plocha (m^2): 84949', 'Cena (CZK): 4104100, Plocha (m^2): 125281', 'Cena (CZK): 3777125, Plocha (m^2): 122859', 'Cena (CZK): 3720750, Plocha (m^2): 28535', 'Cena (CZK): 1928025, Plocha (m^2): 63507', 'Cena (CZK): 4507745, Plocha (m^2): 46005', 'Cena (CZK): 2480500, Plocha (m^2): 101719', 'Cena (CZK): 3134450, Plocha (m^2): 94895', 'Cena (CZK): 4022920, Plocha (m^2): 130480', 'Cena (CZK): 7576800, Plocha (m^2): 131352', 'Cena (CZK): 3605632, Plocha (m^2): 34251', 'Cena (CZK): 5770545, Plocha (m^2): 121094', 'Cena (CZK): 2841300, Plocha (m^2): 108985', 'Cena (CZK): 2818750, Plocha (m^2): 117111', 'Cena (CZK): 2638350, Plocha (m^2): 57156', 'Cena (CZK): 8911580, Plocha (m^2): 109351', 'Cena (CZK): 4397250, Plocha (m^2): 129662', 'Cena (CZK): 4442350, Plocha (m^2): 87457', 'Cena (CZK): 7847400, Plocha (m^2): 101740', 'Cena (CZK): 3788400, Plocha (m^2): 190209', 'Cena (CZK): 4216850, Plocha (m^2): 105056', 'Cena (CZK): 3921445, Plocha (m^2): 95218', 'Cena (CZK): 7610625, Plocha (m^2): 134075', 'Cena (CZK): 2742080, Plocha (m^2): 50720', 'Cena (CZK): 3078075, Plocha (m^2): 114733', 'Cena (CZK): 4171750, Plocha (m^2): 126121', 'Cena (CZK): 2052050, Plocha (m^2): 105336', 'Cena (CZK): 4645300, Plocha (m^2): 72786', ...]
Budeme používat data o ceně nemovitostí z Kaggle.
Máte 2 soubory: data housing.csv
a popis dat housing_description.txt
.
Ukažte distribuci cen domů.
trace = go.Histogram(x=houses.SalePrice)
data = [trace]
layout = dict(title='Cena domů',
xaxis=dict(title='Cena domů')
)
fig = dict(data=data, layout=layout)
iplot(fig)
trace = go.Box(x=houses.SalePrice)
data = [trace]
layout = dict(title='Cena domů',
xaxis=dict(title='Cena domů')
)
fig = dict(data=data, layout=layout)
iplot(fig)
houses[houses.CentralAir == 'Y'].head()
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | LotAreaMeters | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 60 | RL | 65.0 | 8450 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Normal | 208500 | 90955.043021 |
1 | 2 | 20 | RL | 80.0 | 9600 | Pave | NaN | Reg | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 5 | 2007 | WD | Normal | 181500 | 103333.540000 |
2 | 3 | 60 | RL | 68.0 | 11250 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 223500 | 121093.992188 |
3 | 4 | 70 | RL | 60.0 | 9550 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 2 | 2006 | WD | Abnorml | 140000 | 102795.344480 |
4 | 5 | 60 | RL | 84.0 | 14260 | Pave | NaN | IR1 | Lvl | AllPub | ... | NaN | NaN | NaN | 0 | 12 | 2008 | WD | Normal | 250000 | 153493.362542 |
5 rows × 82 columns
houses.CentralAir.unique()
array(['Y', 'N'], dtype=object)
trace1 = go.Histogram(
x=houses[houses.CentralAir == 'Y'].SalePrice, opacity=0.5, name='Je ustřední klimatizace'
)
trace2 = go.Histogram(
x=houses[houses.CentralAir == 'N'].SalePrice, opacity=0.5, name='Není ustřední klimatizace'
)
data = [trace1, trace2]
layout = dict(title='Cena domů',
barmode='overlay',
xaxis=dict(title='Cena domů')
)
fig = dict(data=data, layout=layout)
iplot(fig)
trace = go.Box(y=houses.SalePrice, x=houses.CentralAir)
data = [trace]
layout = dict(title='Cena domů',
xaxis=dict(
title='Ustřední klimatizace',
tickvals=[0, 1],
ticktext=['Je', 'Není']
)
)
fig = dict(data=data, layout=layout)
iplot(fig)
Použijte data o nemovitostech z předešlého cvíčení.
WoodDeckSF
) a ceny domu.LotArea
).houses = pd.read_csv('housing.csv')
houses.head()
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolArea | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 60 | RL | 65.0 | 8450 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Normal | 208500 |
1 | 2 | 20 | RL | 80.0 | 9600 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 5 | 2007 | WD | Normal | 181500 |
2 | 3 | 60 | RL | 68.0 | 11250 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 223500 |
3 | 4 | 70 | RL | 60.0 | 9550 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2006 | WD | Abnorml | 140000 |
4 | 5 | 60 | RL | 84.0 | 14260 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 12 | 2008 | WD | Normal | 250000 |
5 rows × 81 columns
houses_woodeck = houses[houses.WoodDeckSF > 0]
trace = go.Scatter(
x=houses_woodeck.WoodDeckSF,
y=houses_woodeck.SalePrice,
mode='markers'
)
data = [trace]
layout = dict(title='Vztah ceny domu a plochy terasy',
xaxis=dict(title='Plocha terasy'),
yaxis=dict(title='Cena domu'),
hovermode='closest'
)
fig = dict(data=data, layout=layout)
iplot(fig)
houses.LotArea.describe()
count 1460.000000 mean 10516.828082 std 9981.264932 min 1300.000000 25% 7553.500000 50% 9478.500000 75% 11601.500000 max 215245.000000 Name: LotArea, dtype: float64
hover_text = []
for index, row in houses_woodeck.iterrows():
hover_text.append(('Cena: {}<br>' + 'Velikost pozemku: {} čtverečních stop').format(
row.SalePrice, row.LotArea)
)
trace = go.Scatter(
x=houses_woodeck.WoodDeckSF,
y=houses_woodeck.SalePrice,
mode='markers',
text=hover_text,
marker=dict(
# Nastavujeme velikost bubliny jako sloupec avail_seat_km_per_week dělený 10^8
size=houses_woodeck.LotArea,
sizemode='area',
sizeref=2.*max(houses_woodeck.LotArea)/(40.**2),
sizemin=4
)
)
data = [trace]
layout = dict(title='Vztah ceny domu a plochy terasy<br>Velikost bodů představuje velikost pozemku',
xaxis=dict(title='Plocha terasy'),
yaxis=dict(title='Cena domu'),
# Nasledující řádek specifikuje, že se má zobrazovat popisek nejblizšího ke kurzoru bodu
hovermode='closest'
)
fig = dict(data=data, layout=layout)
iplot(fig)
hover_text = []
for index, row in houses_woodeck.iterrows():
hover_text.append(('Cena: {}<br>' + 'Velikost pozemku: {} čtverečních stop').format(
row.SalePrice, row.LotArea)
)
trace = go.Scatter(
x=houses_woodeck.WoodDeckSF,
y=houses_woodeck.SalePrice,
mode='markers',
text=hover_text,
marker=dict(
# Nastavujeme velikost bubliny jako sloupec avail_seat_km_per_week dělený 10^8
size=houses_woodeck.LotArea,
sizemode='area',
)
)
data = [trace]
layout = dict(title='Vztah ceny domu a plochy terasy<br>Velikost bodů představuje velikost pozemku',
xaxis=dict(title='Plocha terasy'),
yaxis=dict(title='Cena domu'),
# Nasledující řádek specifikuje, že se má zobrazovat popisek nejblizšího ke kurzoru bodu
hovermode='closest'
)
fig = dict(data=data, layout=layout)
iplot(fig)
Použijte data o nemovitostech z předešlého cvičení.
Srovnejte
OverallCond
)houses.head()
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolArea | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 60 | RL | 65.0 | 8450 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Normal | 208500 |
1 | 2 | 20 | RL | 80.0 | 9600 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 5 | 2007 | WD | Normal | 181500 |
2 | 3 | 60 | RL | 68.0 | 11250 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 223500 |
3 | 4 | 70 | RL | 60.0 | 9550 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2006 | WD | Abnorml | 140000 |
4 | 5 | 60 | RL | 84.0 | 14260 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 12 | 2008 | WD | Normal | 250000 |
5 rows × 81 columns
houses.groupby('OverallCond').mean().SalePrice
OverallCond 1 61000.000000 2 141986.400000 3 101929.400000 4 120438.438596 5 203146.914738 6 153961.591270 7 158145.487805 8 155651.736111 9 216004.545455 Name: SalePrice, dtype: float64
trace = go.Bar(
x=houses.groupby('OverallCond').mean().SalePrice.index,
y=houses.groupby('OverallCond').mean().SalePrice,
marker=dict(
color='#7666f7',
line=dict(
width=1.5,
)
)
)
data = [trace]
layout = dict(title='Průměrná cena nemovitosti dle celkového stavu ',
# type='category' zobrazí všechny hodnoty na ose x
xaxis=dict(title='Celkový stav (nejhorší - nejlepší)', type='category'),
yaxis=dict(title='Cena, USD')
)
fig = dict(data=data, layout=layout)
iplot(fig)
trace = go.Box(
y=houses.SalePrice,
x=houses.OverallCond
)
data = [trace]
layout = dict(title='Průměrná cena nemovitosti dle celkového stavu',
xaxis=dict(title='Celkový stav (nejhorší - nejlepší)'),
yaxis=dict(title='Cena, USD')
)
fig = dict(data=data, layout=layout)
iplot(fig)
Použijte data o nemovitostech z předešlého cvičení.
LandSlope
)LotShape
)total = houses.groupby('LotShape').count().Id
gentle = (
houses[houses.LandSlope == 'Gtl'].groupby('LotShape').count().Id / total
).round(2)
moderate = (
houses[houses.LandSlope == 'Mod'].groupby('LotShape').count().Id / total
).round(2)
severe = (
houses[houses.LandSlope == 'Sev'].groupby('LotShape').count().Id / total
).round(2)
houses[houses.LandSlope == 'Gtl'].groupby('LotShape').size()
LotShape IR1 448 IR2 33 IR3 9 Reg 892 dtype: int64
houses.LandSlope.unique()
array(['Gtl', 'Mod', 'Sev'], dtype=object)
houses[houses.LandSlope == 'Low']
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolArea | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice |
---|
0 rows × 81 columns
gentle
LotShape IR1 0.93 IR2 0.80 IR3 0.90 Reg 0.96 Name: Id, dtype: float64
houses.groupby('LotShape').count()
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LandContour | Utilities | LotConfig | ... | PoolArea | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LotShape | |||||||||||||||||||||
IR1 | 484 | 484 | 484 | 317 | 484 | 484 | 11 | 484 | 484 | 484 | ... | 484 | 3 | 83 | 20 | 484 | 484 | 484 | 484 | 484 | 484 |
IR2 | 41 | 41 | 41 | 26 | 41 | 41 | 2 | 41 | 41 | 41 | ... | 41 | 0 | 3 | 2 | 41 | 41 | 41 | 41 | 41 | 41 |
IR3 | 10 | 10 | 10 | 7 | 10 | 10 | 1 | 10 | 10 | 10 | ... | 10 | 1 | 0 | 0 | 10 | 10 | 10 | 10 | 10 | 10 |
Reg | 925 | 925 | 925 | 851 | 925 | 925 | 77 | 925 | 925 | 925 | ... | 925 | 3 | 195 | 32 | 925 | 925 | 925 | 925 | 925 | 925 |
4 rows × 80 columns
trace1 = go.Bar(
x=gentle.index,
y=gentle,
name='Mírný',
marker=dict(
color='#66f777'
)
)
trace2 = go.Bar(
x=moderate.index,
y=moderate,
name='Střední',
marker=dict(
color='#f7c066'
)
)
trace3 = go.Bar(
x=severe.index,
y=severe,
name='Silný',
marker=dict(
color='#f77766'
)
)
data = [trace1, trace2, trace3]
layout = dict(title='Sklon pozemku dle tvaru pozemku',
xaxis=dict(title='Tvar pozemku', tickvals=[0, 1, 2, 3],
ticktext=['Trochu nepravidený', 'Mírně nepravidelný', 'Nepravidelný', 'Pravidelný']),
yaxis=dict(title='Podíl pozemků s různým sklonem'),
barmode='stack'
)
fig = go.Figure(data=data, layout=layout)
iplot(fig)
total = houses.groupby('LotShape').Id.count()
data = []
for slope in houses.LandSlope.unique():
data_sub = houses[houses.LandSlope == slope].groupby(
'LotShape'
).Id.count() / total
trace = go.Bar(
x=data_sub.index,
y=data_sub,
name=slope
)
data.append(trace)
data
[Bar({ 'name': 'Gtl', 'x': array(['IR1', 'IR2', 'IR3', 'Reg'], dtype=object), 'y': array([0.92561983, 0.80487805, 0.9 , 0.96432432]) }), Bar({ 'name': 'Mod', 'x': array(['IR1', 'IR2', 'IR3', 'Reg'], dtype=object), 'y': array([0.05991736, 0.12195122, nan, 0.03351351]) }), Bar({ 'name': 'Sev', 'x': array(['IR1', 'IR2', 'IR3', 'Reg'], dtype=object), 'y': array([0.01446281, 0.07317073, 0.1 , 0.00216216]) })]
total = houses.groupby('LotShape').Id.count()
data = []
for slope in houses.LandSlope.unique():
data_sub = houses[houses.LandSlope == slope].groupby(
'LotShape'
).Id.count() / total
trace = go.Bar(
x=data_sub.index,
y=data_sub,
name=slope
)
data.append(trace)
layout = dict(title='Sklon pozemku dle tvaru pozemku',
xaxis=dict(title='Tvar pozemku', tickvals=[0, 1, 2, 3],
ticktext=['Trochu nepravidený', 'Mírně nepravidelný', 'Nepravidelný', 'Pravidelný']),
yaxis=dict(title='Podíl pozemků s různým sklonem'),
barmode='stack'
)
fig = go.Figure(data=data, layout=layout)
iplot(fig)
trace1 = go.Bar(
x=gentle.index,
y=gentle,
name='Mírný',
marker=dict(
color='#66f777'
)
)
trace2 = go.Bar(
x=moderate.index,
y=moderate,
name='Střední',
marker=dict(
color='#f7c066'
)
)
trace3 = go.Bar(
x=severe.index,
y=severe,
name='Silný',
marker=dict(
color='#f77766'
)
)
data = [trace1, trace2, trace3]
layout = dict(title='Sklon pozemku dle tvaru pozemku',
xaxis=dict(title='Tvar pozemku', tickvals=[0, 1, 2, 3],
ticktext=['Trochu nepravidený', 'Mírně nepravidelný', 'Nepravidelný', 'Pravidelný']),
yaxis=dict(title='Podíl pozemků s různým sklonem'),
barmode='stack'
)
fig = go.Figure(data=data, layout=layout)
iplot(fig)
houses.groupby('LandSlope').count().Id
LandSlope Gtl 1382 Mod 65 Sev 13 Name: Id, dtype: int64
labels = ['Mírný', 'Střední', 'Silný']
values = houses.groupby('LandSlope').count().Id
colors = ['#66f777', '#f7c066', '#f77766']
# Použijeme go.Pie, kde specifikujeme popisky, hodnoty a barvy dilů
trace = go.Pie(labels=labels, values=values, marker=dict(colors=colors))
data = [trace]
layout = dict(title='Sklon pozemku')
fig = dict(data=data, layout=layout)
iplot(fig)
Budeme používat data o výskytu tuberkulózy ze světové zdravotnické organizace.
tuberculosis.csv
, popis dat.Czechia
)e_inc_num
)Slovakia
).tuberculosis = pd.read_csv('tuberculosis.csv')
tuberculosis.head()
country | iso2 | iso3 | iso_numeric | g_whoregion | year | e_pop_num | e_inc_100k | e_inc_100k_lo | e_inc_100k_hi | ... | e_mort_num | e_mort_num_lo | e_mort_num_hi | cfr | cfr_lo | cfr_hi | c_newinc_100k | c_cdr | c_cdr_lo | c_cdr_hi | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | Afghanistan | AF | AFG | 4 | EMR | 2000 | 20093756 | 190.0 | 123.0 | 271.0 | ... | 14000 | 7800 | 21000 | NaN | NaN | NaN | 35.0 | 19.0 | 13.0 | 29.0 |
1 | Afghanistan | AF | AFG | 4 | EMR | 2001 | 20966463 | 189.0 | 123.0 | 271.0 | ... | 13000 | 7500 | 20000 | NaN | NaN | NaN | 48.0 | 26.0 | 18.0 | 39.0 |
2 | Afghanistan | AF | AFG | 4 | EMR | 2002 | 21979923 | 189.0 | 122.0 | 270.0 | ... | 12000 | 7200 | 19000 | NaN | NaN | NaN | 63.0 | 33.0 | 23.0 | 51.0 |
3 | Afghanistan | AF | AFG | 4 | EMR | 2003 | 23064851 | 189.0 | 122.0 | 270.0 | ... | 13000 | 7700 | 20000 | NaN | NaN | NaN | 60.0 | 32.0 | 22.0 | 49.0 |
4 | Afghanistan | AF | AFG | 4 | EMR | 2004 | 24118979 | 189.0 | 122.0 | 270.0 | ... | 12000 | 7200 | 19000 | NaN | NaN | NaN | 76.0 | 40.0 | 28.0 | 62.0 |
5 rows × 47 columns
country = 'Czechia'
tuberculosis_sub = tuberculosis[tuberculosis.country == country]
trace = go.Scatter(
x=tuberculosis_sub.year,
y=tuberculosis_sub.e_inc_num,
mode='lines+markers'
)
data = [trace]
layout = dict(title='Incidence případů tuberkulózy - {}'.format(country),
xaxis=dict(title='Rok'),
yaxis=dict(title='Odhadovaný počet případů tuberkolózy')
)
fig = dict(data=data, layout=layout)
iplot(fig)
country1 = 'Czechia'
tuberculosis_sub1 = tuberculosis[tuberculosis.country == country1]
country2 = 'Slovakia'
tuberculosis_sub2 = tuberculosis[tuberculosis.country == country2]
trace1 = go.Scatter(
x=tuberculosis_sub1.year,
y=tuberculosis_sub1.e_inc_num,
mode='lines+markers',
name=country1
)
trace2 = go.Scatter(
x=tuberculosis_sub2.year,
y=tuberculosis_sub2.e_inc_num,
mode='lines+markers',
name=country2
)
data = [trace1, trace2]
layout = dict(title='Incidence případů tuberkulózy - {} a {}'.format(
country1, country2
),
xaxis=dict(title='Rok'),
yaxis=dict(title='Odhadovaný počet případů tuberkolózy')
)
fig = dict(data=data, layout=layout)
iplot(fig)
'Incidence případů tuberkulózy - {a} a {b}'.format(
a = country1, b = country2
)
'Incidence případů tuberkulózy - Czechia a Slovakia'
Použijte data o nemovitostech z předešlého cvičení.
YearBuilt
) v různých letechhouses.head()
Id | MSSubClass | MSZoning | LotFrontage | LotArea | Street | Alley | LotShape | LandContour | Utilities | ... | PoolArea | PoolQC | Fence | MiscFeature | MiscVal | MoSold | YrSold | SaleType | SaleCondition | SalePrice | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 60 | RL | 65.0 | 8450 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2008 | WD | Normal | 208500 |
1 | 2 | 20 | RL | 80.0 | 9600 | Pave | NaN | Reg | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 5 | 2007 | WD | Normal | 181500 |
2 | 3 | 60 | RL | 68.0 | 11250 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 9 | 2008 | WD | Normal | 223500 |
3 | 4 | 70 | RL | 60.0 | 9550 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 2 | 2006 | WD | Abnorml | 140000 |
4 | 5 | 60 | RL | 84.0 | 14260 | Pave | NaN | IR1 | Lvl | AllPub | ... | 0 | NaN | NaN | NaN | 0 | 12 | 2008 | WD | Normal | 250000 |
5 rows × 81 columns
houses.shape
(1460, 81)
trace = go.Scatter(
x=houses.groupby('YearBuilt').count().index,
y=houses.groupby('YearBuilt').count().SalePrice,
mode='lines+markers'
)
data = [trace]
layout = dict(title='Počet postavených nemovitostí',
xaxis=dict(title='Rok'),
yaxis=dict(title='Počet nemovitostí')
)
fig = dict(data=data, layout=layout)
iplot(fig)
Budeme používat data o výskytu tuberkulózy ze světové zdravotnické organizace.
tuberculosis.csv
, popis dat.e_mort_num
).z
).tuberculosis_2017 = tuberculosis[tuberculosis.year == 2017]
tuberculosis_2017.head()
country | iso2 | iso3 | iso_numeric | g_whoregion | year | e_pop_num | e_inc_100k | e_inc_100k_lo | e_inc_100k_hi | ... | e_mort_num | e_mort_num_lo | e_mort_num_hi | cfr | cfr_lo | cfr_hi | c_newinc_100k | c_cdr | c_cdr_lo | c_cdr_hi | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | Afghanistan | AF | AFG | 4 | EMR | 2017 | 35530081 | 189.0 | 122.0 | 270.0 | ... | 10000 | 6100 | 15000 | 0.16 | 0.08 | 0.26 | 131.0 | 70.0 | 49.0 | 110.0 |
35 | Albania | AL | ALB | 8 | EUR | 2017 | 2930187 | 20.0 | 17.0 | 23.0 | ... | 9 | 5 | 15 | 0.02 | 0.01 | 0.03 | 17.0 | 87.0 | 75.0 | 100.0 |
53 | Algeria | DZ | DZA | 12 | AFR | 2017 | 41318142 | 70.0 | 53.0 | 88.0 | ... | 3200 | 2100 | 4600 | 0.11 | 0.07 | 0.17 | 56.0 | 80.0 | 63.0 | 100.0 |
71 | American Samoa | AS | ASM | 16 | WPR | 2017 | 55641 | 10.0 | 8.8 | 12.0 | ... | 0 | 0 | 1 | 0.08 | 0.05 | 0.12 | 9.0 | 87.0 | 75.0 | 100.0 |
89 | Andorra | AD | AND | 20 | EUR | 2017 | 76965 | 1.5 | 1.3 | 1.7 | ... | 0 | 0 | 0 | NaN | NaN | NaN | 1.3 | 87.0 | 75.0 | 100.0 |
5 rows × 47 columns
tuberculosis_2017[tuberculosis_2017.e_mort_num == 0]
country | iso2 | iso3 | iso_numeric | g_whoregion | year | e_pop_num | e_inc_100k | e_inc_100k_lo | e_inc_100k_hi | ... | e_mort_num | e_mort_num_lo | e_mort_num_hi | cfr | cfr_lo | cfr_hi | c_newinc_100k | c_cdr | c_cdr_lo | c_cdr_hi | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71 | American Samoa | AS | ASM | 16 | WPR | 2017 | 55641 | 10.00 | 8.80 | 12.0 | ... | 0 | 0 | 1 | 0.08 | 0.05 | 0.12 | 9.00 | 87.0 | 75.0 | 100.0 |
89 | Andorra | AD | AND | 20 | EUR | 2017 | 76965 | 1.50 | 1.30 | 1.7 | ... | 0 | 0 | 0 | NaN | NaN | NaN | 1.30 | 87.0 | 75.0 | 100.0 |
143 | Antigua and Barbuda | AG | ATG | 28 | AMR | 2017 | 102012 | 1.10 | 0.96 | 1.3 | ... | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.98 | 87.0 | 75.0 | 100.0 |
413 | Bermuda | BM | BMU | 60 | AMR | 2017 | 61349 | 3.70 | 3.20 | 4.3 | ... | 0 | 0 | 0 | 0.08 | 0.05 | 0.12 | 3.30 | 87.0 | 75.0 | 100.0 |
457 | Bonaire, Saint Eustatius and Saba | BQ | BES | 535 | AMR | 2017 | 25398 | 3.10 | 2.60 | 3.5 | ... | 0 | 0 | 0 | 0.08 | 0.05 | 0.12 | NaN | NaN | NaN | NaN |
529 | British Virgin Islands | VG | VGB | 92 | AMR | 2017 | 31196 | 0.00 | 0.00 | 0.0 | ... | 0 | 0 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
691 | Cayman Islands | KY | CYM | 136 | AMR | 2017 | 61559 | 7.50 | 6.40 | 8.6 | ... | 0 | 0 | 0 | NaN | NaN | NaN | 6.50 | 87.0 | 75.0 | 100.0 |
871 | Cook Islands | CK | COK | 184 | WPR | 2017 | 17380 | 0.00 | 0.00 | 0.0 | ... | 0 | 0 | 0 | NaN | NaN | NaN | 0.00 | NaN | NaN | NaN |
1077 | Dominica | DM | DMA | 212 | AMR | 2017 | 73925 | 1.60 | 1.30 | 1.8 | ... | 0 | 0 | 0 | 0.39 | 0.32 | 0.45 | 1.40 | 87.0 | 75.0 | 100.0 |
1455 | Grenada | GD | GRD | 308 | AMR | 2017 | 107825 | 3.20 | 2.70 | 3.7 | ... | 0 | 0 | 0 | 0.05 | 0.03 | 0.07 | 2.80 | 87.0 | 75.0 | 100.0 |
1617 | Iceland | IS | ISL | 352 | EUR | 2017 | 335025 | 4.50 | 3.80 | 5.2 | ... | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 3.90 | 87.0 | 75.0 | 100.0 |
2247 | Monaco | MC | MCO | 492 | EUR | 2017 | 38695 | 0.00 | 0.00 | 0.0 | ... | 0 | 0 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
2296 | Montserrat | MS | MSR | 500 | AMR | 2017 | 5177 | 0.00 | 0.00 | 0.0 | ... | 0 | 0 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
2540 | Niue | NU | NIU | 570 | WPR | 2017 | 1618 | 71.00 | 61.00 | 82.0 | ... | 0 | 0 | 0 | 0.08 | 0.05 | 0.12 | 62.00 | 87.0 | 75.0 | 100.0 |
2900 | Saint Kitts and Nevis | KN | KNA | 659 | AMR | 2017 | 55345 | 2.10 | 1.80 | 2.4 | ... | 0 | 0 | 0 | 0.04 | 0.04 | 0.05 | 1.80 | 87.0 | 75.0 | 100.0 |
2972 | San Marino | SM | SMR | 674 | EUR | 2017 | 33400 | 0.00 | 0.00 | 0.0 | ... | 0 | 0 | 0 | NaN | NaN | NaN | 0.00 | NaN | NaN | NaN |
3062 | Seychelles | SC | SYC | 690 | AFR | 2017 | 94737 | 19.00 | 17.00 | 22.0 | ... | 0 | 0 | 0 | 0.01 | 0.01 | 0.02 | 17.00 | 87.0 | 75.0 | 100.0 |
3106 | Sint Maarten (Dutch part) | SX | SXM | 534 | AMR | 2017 | 40120 | 14.00 | 12.00 | 17.0 | ... | 0 | 0 | 1 | 0.08 | 0.05 | 0.12 | 12.00 | 87.0 | 75.0 | 100.0 |
3435 | Tokelau | TK | TKL | 772 | WPR | 2017 | 1300 | 0.00 | 0.00 | 0.0 | ... | 0 | 0 | 0 | NaN | NaN | NaN | 0.00 | NaN | NaN | NaN |
3543 | Turks and Caicos Islands | TC | TCA | 796 | AMR | 2017 | 35446 | 6.10 | 5.20 | 7.0 | ... | 0 | 0 | 0 | 0.12 | 0.08 | 0.16 | NaN | NaN | NaN | NaN |
3777 | Wallis and Futuna Islands | WF | WLF | 876 | WPR | 2017 | 11773 | 0.09 | 0.08 | 0.1 | ... | 0 | 0 | 0 | 0.08 | 0.05 | 0.12 | NaN | NaN | NaN | NaN |
21 rows × 47 columns
# Vytvoříme seznam popisků
text = []
for i, row in tuberculosis_2017.iterrows():
text.append(
'Stát: {}<br>Počet úmrtí na tuberkulózu: {}'.format(row.country, row.e_mort_num)
)
# Pro vykreslení použijeme typ choropleth
data = [ dict(
type='choropleth',
# Pro zobrazení použijeme hotovou barevnou škálu Jet
colorscale='Jet',
autocolorscale=False,
locations=tuberculosis_2017.iso3,
# Uděláme logaritmickou transformaci jenom u nenulových dat
z=np.log(tuberculosis_2017.e_mort_num+1),
text=text,
marker=dict(
line=dict (
color='rgb(255,255,255)',
width=2
) ),
# Popišeme legendu
colorbar=dict(
title='Počet úmrtí',
# Následující parametry nastavují poměr délky legendy k obrázku a její pozici
len=0.6,
y=0.65
)
) ]
# Pro vykreslení celého světu použijeme typ projekce Mercator
layout = dict(
autosize=False,
width=900,
height=1000,
title='Počet úmrtí na tuberkulózu',
geo=dict(
showframe=False,
showcoastlines=False,
projection=dict(
type='mercator'
)
)
)
fig = dict(data=data, layout=layout)
iplot(fig)
np.log(tuberculosis_2017.e_mort_num+1)
17 9.210440 35 2.302585 53 8.071219 71 0.000000 89 0.000000 107 10.239996 125 0.693147 143 0.000000 161 6.814543 179 3.970292 197 0.693147 215 4.094345 233 3.784190 251 6.781058 269 1.609438 287 2.302585 305 11.002117 323 1.386294 341 4.875197 359 4.330733 377 2.772589 395 7.313887 413 0.000000 431 4.795791 449 7.170888 457 0.000000 475 4.875197 493 7.090910 511 8.853808 529 0.000000 ... 3329 3.912023 3347 6.274762 3365 9.392745 3383 3.044522 3399 7.244942 3417 5.993961 3435 0.000000 3453 0.693147 3471 3.367296 3489 5.831882 3507 6.066108 3525 6.398595 3543 0.000000 3561 1.098612 3579 10.126671 3597 8.682877 3615 4.204693 3633 6.018593 3651 10.799596 3669 6.415097 3687 4.709530 3705 7.601402 3723 3.218876 3741 7.003974 3759 9.392745 3777 0.000000 3795 1.791759 3813 7.601402 3831 9.798183 3849 9.024131 Name: e_mort_num, Length: 216, dtype: float64
# Vytvoříme seznam popisků
text = []
for i, row in tuberculosis_2017.iterrows():
text.append(
'Stát: {}<br>Počet úmrtí na tuberkulózu: {}'.format(row.country, row.e_mort_num)
)
# Pro vykreslení použijeme typ choropleth
data = [ dict(
type='choropleth',
# Pro zobrazení použijeme hotovou barevnou škálu Jet
colorscale='Jet',
autocolorscale=False,
locations=tuberculosis_2017.iso3,
# Uděláme logaritmickou transformaci jenom u nenulových dat
z=tuberculosis_2017.e_mort_num,
text=text,
marker=dict(
line=dict (
color='rgb(255,255,255)',
width=2
) ),
# Popišeme legendu
colorbar=dict(
title='Počet úmrtí',
# Následující parametry nastavují poměr délky legendy k obrázku a její pozici
#len=0.6,
#y=0.65
)
) ]
# Pro vykreslení celého světu použijeme typ projekce Mercator
layout = dict(
autosize=False,
width=600,
height=800,
title='Počet úmrtí na tuberkulózu',
geo=dict(
showframe=False,
showcoastlines=False,
projection=dict(
type='mercator'
)
)
)
fig = dict(data=data, layout=layout)
iplot(fig)