vDataFrame.flat_vmap

In [ ]:
vDataFrame.flat_vmap(vmap_col: list = [], 
                     limit: int = 100,
                     exclude_columns: list = [],)

Flatten the selected VMap. A new vDataFrame is returned.

⚠ Warning : This function might have a long runtime and can make your vDataFrame less performant. It makes many calls to the MAPLOOKUP function, which can be slow if your VMap is large.

Parameters

Name Type Optional Description
vmap_col
list
✓
 List of VMap columns to flatten.
limit
int
✓
 Maximum number of keys to consider for each VMap. Only the most occurent keys are used.
exclude_columns
list
✓
 List of VMap columns to exclude.

Returns

vDataFrame : object with the flattened VMaps.

Example

In [1]:
from verticapy.utilities import read_json
laliga = read_json("laliga/*.json")
display(laliga)
123
referee.country.id
Int
Abc
referee.country.name
Varchar(20)
123
stadium.id
Int
123
stadium.country.id
Int
123
referee.id
Int
Abc
stadium.name
Varchar(64)
Abc
stadium.country.name
Varchar(26)
Abc
referee.name
Varchar(46)
Abc
Vmap(384)
Abc
Vmap(378)
123
metadata.xy_fidelity_version
Int
Abc
season.season_name
Varchar(20)
📅
metadata.data_version
Date
📅
match_date
Date
Abc
home_team.home_team_name
Varchar(40)
123
home_team.home_team_id
Int
Abc
home_team.home_team_group
Varchar(20)
123
home_score
Int
Abc
competition_stage.name
Varchar(28)
123
competition.competition_id
Int
Abc
away_team.country.name
Varchar(20)
📅
kick_off
Time
Abc
home_team.home_team_gender
Varchar(20)
123
home_team.country.id
Int
Abc
competition.competition_name
Varchar(20)
Abc
away_team.away_team_name
Varchar(38)
Abc
away_team.away_team_gender
Varchar(20)
123
season.season_id
Int
123
match_week
Int
Abc
match_status
Varchar(20)
📅
last_updated
Timestamp
Abc
home_team.country.name
Varchar(20)
123
competition_stage.id
Int
123
away_team.country.id
Int
Abc
away_team.away_team_group
Varchar(20)
123
away_score
Int
123
metadata.shot_fidelity_version
Int
123
match_id
Int
Abc
competition.country_name
Varchar(20)
123
away_team.away_team_id
Int
1[null][null][null][null][null][null][null][null]22014/20152000-01-012015-04-25Espanyol214[null]0Regular Season11Spain16:00:00male214La LigaBarcelonamale2633available2019-12-16 23:09:16.168756Spain1214[null]22266531Spain217
2[null][null][null][null][null][null][null][null]22014/20152000-01-012015-02-21Barcelona217[null]0Regular Season11Spain16:00:00male214La LigaMálagamale2624available2019-12-16 23:09:16.168756Spain1214[null]12266148Spain223
3[null][null][null][null][null][null][null][null]22014/20152000-01-012015-02-15Barcelona217[null]5Regular Season11Spain17:00:00male214La LigaLevantemale2623available2019-12-16 23:09:16.168756Spain1214[null]02266741Spain221
4[null][null][null][null][null][null][null][null]22014/20152000-01-012014-09-24Málaga223[null]0Regular Season11Spain22:00:00male214La LigaBarcelonamale265available2019-12-16 23:09:16.168756Spain1214[null]02266838Spain217
5[null][null][null][null][null][null][null][null]22014/20152000-01-012014-10-25Real Madrid220[null]3Regular Season11Spain18:00:00male214La LigaBarcelonamale269available2019-12-16 23:09:16.168756Spain1214[null]12267085Spain217
6[null][null][null][null][null][null][null][null]22014/20152000-01-012014-09-27Barcelona217[null]6Regular Season11Spain18:00:00male214La LigaGranadamale266available2019-12-16 23:09:16.168756Spain1214[null]02266117Spain1049
7[null][null][null][null][null][null][null][null]22014/20152000-01-012014-11-08Almería403[null]1Regular Season11Spain16:00:00male214La LigaBarcelonamale2611available2019-12-16 23:09:16.168756Spain1214[null]22267499Spain217
8[null][null][null][null][null][null][null][null]22014/20152000-01-012014-11-22Barcelona217[null]5Regular Season11Spain20:00:00male214La LigaSevillamale2612available2019-12-16 23:09:16.168756Spain1214[null]12265835Spain213
9[null][null][null][null][null][null][null][null]22014/20152000-01-012014-12-20Barcelona217[null]5Regular Season11Spain16:00:00male214La LigaCórdobamale2616available2019-12-16 23:09:16.168756Spain1214[null]02266846Spain373
10[null][null][null][null][null][null][null][null]22014/20152000-01-012014-08-31Villarreal222[null]0Regular Season11Spain19:00:00male214La LigaBarcelonamale262available2019-12-16 23:09:16.168756Spain1214[null]12266406Spain217
11[null][null][null][null][null][null][null][null]22015/20162000-01-012016-04-23Barcelona217[null]6Regular Season11Spain20:30:00male214La LigaSporting Gijónmale2735available2019-12-16 23:09:16.168756Spain1214[null]02265944Spain1041
12[null][null][null][null][null][null][null][null]22015/20162000-01-012016-04-20Deportivo La Coruna219[null]0Regular Season11Spain20:00:00male214La LigaBarcelonamale2734available2019-12-16 23:09:16.168756Spain1214[null]82266310Spain217
13[null][null][null][null][null][null][null][null]22015/20162000-01-012015-09-23Celta Vigo209[null]4Regular Season11Spain20:00:00male214La LigaBarcelonamale275available2019-12-16 23:09:16.168756Spain1214[null]12266467Spain217
14[null][null][null][null][null][null][null][null]22015/20162000-01-012015-11-21Real Madrid220[null]0Regular Season11Spain18:15:00male214La LigaBarcelonamale2712available2019-12-16 23:09:16.168756Spain1214[null]42266424Spain217
15[null][null][null][null][null][null][null][null]22015/20162000-01-012016-02-17Sporting Gijón1041[null]1Regular Season11Spain18:30:00male214La LigaBarcelonamale2716available2019-12-16 23:09:16.168756Spain1214[null]32266815Spain217
16[null][null][null][null][null][null][null][null]22015/20162000-01-012015-09-26Barcelona217[null]2Regular Season11Spain16:00:00male214La LigaLas Palmasmale276available2019-12-16 23:09:16.168756Spain1214[null]12267611Spain208
17[null][null][null][null][null][null][null][null]22015/20162000-01-012016-01-17Barcelona217[null]6Regular Season11Spain20:30:00male214La LigaAthletic Bilbaomale2720available2019-12-16 23:09:16.168756Spain1214[null]02266149Spain215
18[null][null][null][null][null][null][null][null]22012/20132000-01-012012-12-01Barcelona217[null]5Regular Season11Spain20:00:00male214La LigaAthletic Bilbaomale2414available2019-12-16 23:09:16.168756Spain1214[null]1270263Spain215
19[null][null][null][null][null][null][null][null]22012/20132000-01-012012-11-17Barcelona217[null]3Regular Season11Spain20:00:00male214La LigaReal Zaragozamale2412available2019-12-16 23:09:16.168756Spain1214[null]1270309Spain395
20[null][null][null][null][null][null][null][null]22012/20132000-01-012012-11-25Levante221[null]0Regular Season11Spain21:00:00male214La LigaBarcelonamale2413available2019-12-16 23:09:16.168756Spain1214[null]4270280Spain217
21[null][null][null][null][null][null][null][null]22012/20132000-01-012013-01-19Real Sociedad210[null]3Regular Season11Spain18:00:00male214La LigaBarcelonamale2420available2019-12-16 23:09:16.168756Spain1214[null]2270287Spain217
22[null][null][null][null][null][null][null][null]22012/20132000-01-012013-03-30Celta Vigo209[null]2Regular Season11Spain18:00:00male214La LigaBarcelonamale2429available2019-12-16 23:09:16.168756Spain1214[null]2270256Spain217
23[null][null][null][null][null][null][null][null]22012/20132000-01-012013-03-02Real Madrid220[null]2Regular Season11Spain16:00:00male214La LigaBarcelonamale2426available2019-12-16 23:09:16.168756Spain1214[null]1270272Spain217
24[null][null][null][null][null][null][null][null]22012/20132000-01-012012-11-03Barcelona217[null]3Regular Season11Spain18:00:00male214La LigaCelta Vigomale2410available2019-12-16 23:09:16.168756Spain1214[null]1270308Spain209
25[null][null][null][null][null][null][null][null]22012/20132000-01-012013-02-03Valencia207[null]1Regular Season11Spain19:00:00male214La LigaBarcelonamale2422available2019-12-16 23:09:16.168756Spain1214[null]1270282Spain217
26[null][null][null][null][null][null][null][null]22012/20132000-01-012012-09-02Barcelona217[null]1Regular Season11Spain21:30:00male214La LigaValenciamale243available2019-12-16 23:09:16.168756Spain1214[null]0270286Spain207
27[null][null][null][null][null][null][null][null]22012/20132000-01-012012-11-11Mallorca1043[null]2Regular Season11Spain17:50:00male214La LigaBarcelonamale2411available2019-12-16 23:09:16.168756Spain1214[null]42266724Spain217
28[null][null][null][null][null][null][null][null]22008/20092000-01-012008-10-25Barcelona217[null]5Regular Season11Spain22:00:00male214La LigaAlmeríamale418available2019-12-16 23:09:16.168756Spain1214[null]0269232Spain403
29[null][null][null][null][null][null][null][null]22008/20092000-01-012008-11-01Málaga223[null]1Regular Season11Spain20:00:00male214La LigaBarcelonamale419available2019-12-16 23:09:16.168756Spain1214[null]4269235Spain217
30[null][null][null][null][null][null][null][null]22008/20092000-01-012008-11-29Sevilla213[null]0Regular Season11Spain22:00:00male214La LigaBarcelonamale4113available2019-12-16 23:09:16.168756Spain1214[null]3269171Spain217
31[null][null][null][null][null][null][null][null]22008/20092000-01-012009-02-14Real Betis218[null]2Regular Season11Spain20:00:00male214La LigaBarcelonamale4123available2019-12-16 23:09:16.168756Spain1214[null]2269195Spain217
32[null][null][null][null][null][null][null][null]22008/20092000-01-012008-09-13Barcelona217[null]1Regular Season11Spain20:00:00male214La LigaRacing Santandermale412available2019-12-16 23:09:16.168756Spain1214[null]1269215Spain1217
33[null][null][null][null][null][null][null][null]22009/20102000-01-012009-12-05Deportivo La Coruna219[null]1Regular Season11Spain22:00:00male214La LigaBarcelonamale2113available2019-12-16 23:09:16.168756Spain1214[null]3269218Spain217
34[null][null][null][null][null][null][null][null]22009/20102000-01-012010-01-10Tenerife627[null]0Regular Season11Spain21:00:00male214La LigaBarcelonamale2117available2019-12-16 23:09:16.168756Spain1214[null]5269219Spain217
35[null][null][null][null][null][null][null][null]22009/20102000-01-012010-03-21Real Zaragoza395[null]2Regular Season11Spain21:00:00male214La LigaBarcelonamale2127available2019-12-16 23:09:16.168756Spain1214[null]4269227Spain217
36[null][null][null][null][null][null][null][null]22009/20102000-01-012010-04-24Barcelona217[null]3Regular Season11Spain18:00:00male214La LigaXerezmale2134available2019-12-16 23:09:16.168756Spain1214[null]1269214Spain1219
37[null][null][null][null][null][null][null][null]22009/20102000-01-012010-04-03Barcelona217[null]4Regular Season11Spain20:00:00male214La LigaAthletic Bilbaomale2130available2019-12-16 23:09:16.168756Spain1214[null]1269247Spain215
38[null][null][null][null][null][null][null][null]22009/20102000-01-012010-04-10Real Madrid220[null]0Regular Season11Spain22:00:00male214La LigaBarcelonamale2131available2019-12-16 23:09:16.168756Spain1214[null]2269259Spain217
39[null][null][null][null][null][null][null][null]22005/20062000-01-012005-10-01Barcelona217[null]2Regular Season11Spain20:00:00male214La LigaReal Zaragozamale386available2019-12-16 23:09:16.168756Spain1214[null]2268317Spain395
40[null][null][null][null][null][null][null][null]22005/20062000-01-012005-12-17Cádiz552[null]1Regular Season11Spain22:00:00male214La LigaBarcelonamale3816available2019-12-16 23:09:16.168756Spain1214[null]3268322Spain217
41[null][null][null][null][null][null][null][null]22005/20062000-01-012005-11-06Getafe216[null]1Regular Season11Spain21:00:00male214La LigaBarcelonamale3810available2019-12-16 23:09:16.168756Spain1214[null]3268339Spain217
42[null][null][null][null][null][null][null][null]22013/20142000-01-012014-03-16Barcelona217[null]7Regular Season11Spain17:00:00male214La LigaOsasunamale2528available2019-12-16 23:09:16.168756Spain1214[null]02266074Spain422
43[null][null][null][null][null][null][null][null]22013/20142000-01-012013-11-01Barcelona217[null]1Regular Season11Spain21:00:00male214La LigaEspanyolmale2512available2019-12-16 23:09:16.168756Spain1214[null]0270283Spain214
44[null][null][null][null][null][null][null][null]22013/20142000-01-012014-03-02Barcelona217[null]4Regular Season11Spain21:00:00male214La LigaAlmeríamale2526available2019-12-16 23:09:16.168756Spain1214[null]12266066Spain403
45[null][null][null][null][null][null][null][null]22006/20072000-01-012007-04-07Real Zaragoza395[null]1Regular Season11Spain20:00:00male214La LigaBarcelonamale3929available2019-12-16 23:09:16.168756Spain1214[null]0269179Spain217
46[null][null][null][null][null][null][null][null]22006/20072000-01-012007-04-22Villarreal222[null]2Regular Season11Spain21:00:00male214La LigaBarcelonamale3931available2019-12-16 23:09:16.168756Spain1214[null]0269155Spain217
47[null][null][null][null][null][null][null][null]22006/20072000-01-012006-08-28Celta Vigo209[null]2Regular Season11Spain21:00:00male214La LigaBarcelonamale391available2019-12-16 23:09:16.168756Spain1214[null]3268326Spain217
48[null][null][null][null][null][null][null][null]22006/20072000-01-012006-10-22Real Madrid220[null]2Regular Season11Spain21:00:00male214La LigaBarcelonamale397available2019-12-16 23:09:16.168756Spain1214[null]0268330Spain217
49[null][null][null][null][null][null][null][null]22006/20072000-01-012006-11-12Barcelona217[null]3Regular Season11Spain21:00:00male214La LigaReal Zaragozamale3910available2019-12-16 23:09:16.168756Spain1214[null]1268331Spain395
50[null][null][null][null][null][null][null][null]22006/20072000-01-012006-09-24Barcelona217[null]1Regular Season11Spain21:00:00male214La LigaValenciamale394available2019-12-16 23:09:16.168756Spain1214[null]1268328Spain207
51[null][null][null][null][null][null][null][null]22006/20072000-01-012007-03-10Barcelona217[null]3Regular Season11Spain22:00:00male214La LigaReal Madridmale3926available2019-12-16 23:09:16.168756Spain1214[null]3268335Spain220
52[null][null][null][null][null][null][null][null]22010/20112000-01-012011-04-09Barcelona217[null]3Regular Season11Spain20:00:00male214La LigaAlmeríamale2231available2019-12-16 23:09:16.168756Spain1214[null]1269305Spain403
53[null][null][null][null][null][null][null][null]22010/20112000-01-012010-10-03Barcelona217[null]1Regular Season11Spain19:00:00male214La LigaMallorcamale226available2019-12-16 23:09:16.168756Spain1214[null]1269236Spain1043
54[null][null][null][null][null][null][null][null]22010/20112000-01-012011-02-12Sporting Gijón1041[null]1Regular Season11Spain20:00:00male214La LigaBarcelonamale2223available2019-12-16 23:09:16.168756Spain1214[null]1269248Spain217
55[null][null][null][null][null][null][null][null]22010/20112000-01-012011-04-30Real Sociedad210[null]2Regular Season11Spain20:00:00male214La LigaBarcelonamale2234available2019-12-16 23:09:16.168756Spain1214[null]1269246Spain217
56[null][null][null][null][null][null][null][null]22010/20112000-01-012010-09-19Atlético Madrid212[null]1Regular Season11Spain19:00:00male214La LigaBarcelonamale223available2019-12-16 23:09:16.168756Spain1214[null]2269269Spain217
57[null][null][null][null][null][null][null][null]22010/20112000-01-012010-12-18Espanyol214[null]1Regular Season11Spain20:00:00male214La LigaBarcelonamale2216available2019-12-16 23:09:16.168756Spain1214[null]5269275Spain217
58[null][null][null][null][null][null][null][null]22010/20112000-01-012011-01-08Deportivo La Coruna219[null]0Regular Season11Spain22:00:00male214La LigaBarcelonamale2218available2019-12-16 23:09:16.168756Spain1214[null]4269280Spain217
59[null][null][null][null][null][null][null][null]22010/20112000-01-012010-09-11Barcelona217[null]0Regular Season11Spain18:00:00male214La LigaHérculesmale222available2019-12-16 23:09:16.168756Spain1214[null]2269287Spain1218
60[null][null][null][null][null][null][null][null]22010/20112000-01-012011-03-13Sevilla213[null]1Regular Season11Spain21:00:00male214La LigaBarcelonamale2228available2019-12-16 23:09:16.168756Spain1214[null]1269291Spain217
61[null][null][null][null][null][null][null][null]22010/20112000-01-012011-01-22Barcelona217[null]3Regular Season11Spain20:00:00male214La LigaRacing Santandermale2220available2019-12-16 23:09:16.168756Spain1214[null]0269295Spain1217
62[null][null][null][null][null][null][null][null]22010/20112000-01-012011-04-16Real Madrid220[null]1Regular Season11Spain22:00:00male214La LigaBarcelonamale2232available2020-04-09 13:13:49.345111Spain1214[null]1269245Spain217
63[null][null][null][null][null][null][null][null]22011/20122000-01-012012-02-04Barcelona217[null]2Regular Season11Spain22:00:00male214La LigaReal Sociedadmale2322available2019-12-16 23:09:16.168756Spain1214[null]1269316Spain210
64[null][null][null][null][null][null][null][null]22011/20122000-01-012012-03-24Mallorca1043[null]0Regular Season11Spain18:00:00male214La LigaBarcelonamale2330available2019-12-16 23:09:16.168756Spain1214[null]2269325Spain217
65[null][null][null][null][null][null][null][null]22011/20122000-01-012012-04-21Barcelona217[null]1Regular Season11Spain20:00:00male214La LigaReal Madridmale2335available2019-12-16 23:09:16.168756Spain1214[null]2269324Spain220
66[null][null][null][null][null][null][null][null]22011/20122000-01-012012-05-02Barcelona217[null]4Regular Season11Spain20:00:00male214La LigaMálagamale2320available2019-12-16 23:09:16.168756Spain1214[null]1269340Spain223
67[null][null][null][null][null][null][null][null]22011/20122000-01-012012-05-05Barcelona217[null]4Regular Season11Spain21:00:00male214La LigaEspanyolmale2337available2019-12-16 23:09:16.168756Spain1214[null]0269320Spain214
68[null][null][null][null][null][null][null][null]22011/20122000-01-012012-05-12Real Betis218[null]2Regular Season11Spain22:00:00male214La LigaBarcelonamale2338available2019-12-16 23:09:16.168756Spain1214[null]2269319Spain217
69[null][null][null][null][null][null][null][null]22011/20122000-01-012011-10-02Sporting Gijón1041[null]0Regular Season11Spain20:00:00male214La LigaBarcelonamale237available2019-12-16 23:09:16.168756Spain1214[null]1269265Spain217
70[null][null][null][null][null][null][null][null]22011/20122000-01-012011-08-29Barcelona217[null]5Regular Season11Spain21:00:00male214La LigaVillarrealmale232available2019-12-16 23:09:16.168756Spain1214[null]0269268Spain222
71[null][null][null][null][null][null][null][null]22011/20122000-01-012011-12-10Real Madrid220[null]1Regular Season11Spain22:00:00male214La LigaBarcelonamale2316available2019-12-16 23:09:16.168756Spain1214[null]3269334Spain217
72[null][null][null][null][null][null][null][null]22011/20122000-01-012011-11-06Athletic Bilbao215[null]2Regular Season11Spain20:00:00male214La LigaBarcelonamale2312available2019-12-16 23:09:16.168756Spain1214[null]2269330Spain217
73[null][null][null][null][null][null][null][null]22011/20122000-01-012012-04-10Barcelona217[null]4Regular Season11Spain21:00:00male214La LigaGetafemale2333available2019-12-16 23:09:16.168756Spain1214[null]0269343Spain216
74[null][null][null][null][null][null][null][null]22007/20082000-01-012007-10-20Villarreal222[null]3Regular Season11Spain20:00:00male214La LigaBarcelonamale408available2019-12-16 23:09:16.168756Spain1214[null]1268364Spain217
75[null][null][null][null][null][null][null][null]22007/20082000-01-012007-11-01Real Valladolid901[null]1Regular Season11Spain22:00:00male214La LigaBarcelonamale4010available2019-12-16 23:09:16.168756Spain1214[null]1268363Spain217
76[null][null][null][null][null][null][null][null]22007/20082000-01-012007-10-07Barcelona217[null]3Regular Season11Spain17:00:00male214La LigaAtlético Madridmale407available2019-12-16 23:09:16.168756Spain1214[null]0269144Spain212
77[null][null][null][null][null][null][null][null]22007/20082000-01-012007-09-29Levante221[null]1Regular Season11Spain22:00:00male214La LigaBarcelonamale406available2019-12-16 23:09:16.168756Spain1214[null]4269151Spain217
78[null][null][null][null][null][null][null][null]22007/20082000-01-012007-09-02Barcelona217[null]3Regular Season11Spain19:00:00male214La LigaAthletic Bilbaomale402available2019-12-16 23:09:16.168756Spain1214[null]1269169Spain215
79[null][null][null][null][null][null][null][null]22007/20082000-01-012007-12-09Barcelona217[null]2Regular Season11Spain21:00:00male214La LigaDeportivo La Corunamale4015available2019-12-16 23:09:16.168756Spain1214[null]1269170Spain219
80[null][null][null][null][null][null][null][null]22007/20082000-01-012008-01-20Barcelona217[null]1Regular Season11Spain21:00:00male214La LigaRacing Santandermale4020available2019-12-16 23:09:16.168756Spain1214[null]0269173Spain1217
81[null][null][null][null][null][null][null][null]22007/20082000-01-012008-05-17Real Murcia1230[null]3Regular Season11Spain22:00:00male214La LigaBarcelonamale4038available2019-12-16 23:09:16.168756Spain1214[null]5269186Spain217
82[null][null][null][null][null][null][null][null]22007/20082000-01-012007-11-24Barcelona217[null]3Regular Season11Spain20:00:00male214La LigaRecreativo Huelvamale4013available2019-12-16 23:09:16.168756Spain1214[null]0269184Spain1220
83[null][null]3422141008Camp NouSpainClos Gómez22016/20172000-01-012017-04-05Barcelona217[null]3Regular Season11Spain19:30:00male214La LigaSevillamale230available2019-12-16 23:09:16.168756Spain1214[null]02266280Spain213
84112Italy342214207Camp NouSpainJuan Martínez[null]2018/20192000-01-012019-02-16Barcelona217[null]1Regular Season11Spain20:45:00male214La LigaReal Valladolidmale424available2019-12-16 23:09:16.168756Spain1214[null]0216182Spain901
85112Italy342214208Camp NouSpainAlejandro Hernández22016/20172000-01-012017-05-21Barcelona217[null]4Regular Season11Spain20:00:00male214La LigaEibarmale238available2019-12-16 23:09:16.168756Spain1214[null]22267432Spain322
86112Italy342214208Camp NouSpainAlejandro Hernández22016/20172000-01-012017-03-19Barcelona217[null]4Regular Season11Spain20:45:00male214La LigaValenciamale228available2019-12-16 23:09:16.168756Spain1214[null]22266440Spain207
87112Italy342214209Camp NouSpainMario Melero[null]2018/2019[null]2018-09-02Barcelona217[null]8Regular Season11Spain18:30:00male214La LigaHuescamale43available2019-12-16 23:09:16.168756Spain1214[null]2215973Spain902
88112Italy342214215Camp NouSpainRicardo De Burgos[null]2018/2019[null]2019-01-20Barcelona217[null]3Regular Season11Spain20:45:00male214La LigaLeganésmale420available2019-12-16 23:09:16.168756Spain1214[null]1216136Spain205
89112Italy342214220Camp NouSpainJosé Sánchez22016/20172000-01-012017-05-06Barcelona217[null]4Regular Season11Spain18:30:00male214La LigaVillarrealmale236available2019-12-16 23:09:16.168756Spain1214[null]12266952Spain222
90112Italy342214220Camp NouSpainJosé Sánchez22016/20172000-01-012017-03-01Barcelona217[null]6Regular Season11Spain19:30:00male214La LigaSporting Gijónmale225available2019-12-16 23:09:16.168756Spain1214[null]12265952Spain1041
91112Italy342214224Camp NouSpainJosé Munuera[null]2017/2018[null]2017-10-01Barcelona217[null]3Regular Season11Spain16:15:00male214La LigaLas Palmasmale17available2019-12-16 23:09:16.168756Spain1214[null]029636Spain208
92112Italy342214224Camp NouSpainJosé Munuera22016/20172000-01-012017-04-26Barcelona217[null]7Regular Season11Spain19:30:00male214La LigaOsasunamale234available2019-12-16 23:09:16.168756Spain1214[null]12267101Spain422
93112Italy343214220Estadi Municipal de MontiliviSpainJosé Sánchez[null]2017/2018[null]2017-09-23Girona211[null]0Regular Season11Spain20:45:00male214La LigaBarcelonamale16available2019-12-16 23:09:16.168756Spain1214[null]329620Spain217
94112Italy352214217Estadio Benito VillamarínSpainSantiago Jaime[null]2017/20182000-01-012018-01-21Real Betis218[null]0Regular Season11Spain20:45:00male214La LigaBarcelonamale120available2019-12-16 23:09:16.168756Spain1214[null]529765Spain217
95112Italy353214208Estadio Santiago BernabéuSpainAlejandro Hernández22016/20172000-01-012017-04-23Real Madrid220[null]2Regular Season11Spain20:45:00male214La LigaBarcelonamale233available2019-12-16 23:09:16.168756Spain1214[null]32267569Spain217
96112Italy353214220Estadio Santiago BernabéuSpainJosé Sánchez[null]2017/20182000-01-012017-12-23Real Madrid220[null]0Regular Season11Spain13:00:00male214La LigaBarcelonamale117available2019-12-16 23:09:16.168756Spain1214[null]329736Spain217
97112Italy355214221Estadio Municipal de ButarqueSpainAlberto Undiano[null]2017/2018[null]2017-11-18Leganés205[null]0Regular Season11Spain16:15:00male214La LigaBarcelonamale112available2019-12-16 23:09:16.168756Spain1214[null]329682Spain217
98112Italy622214215Estadio Municipal José ZorrillaSpainRicardo De Burgos[null]2018/2019[null]2018-08-25Real Valladolid901[null]0Regular Season11Spain22:15:00male214La LigaBarcelonamale42available2019-12-16 23:09:16.168756Spain1214[null]1215956Spain217
99112Italy653214222Abanca-BalaídosSpainDavid Fernández[null]2017/20182000-01-012018-04-17Celta Vigo209[null]2Regular Season11Spain21:00:00male214La LigaBarcelonamale133available2019-12-16 23:09:16.168756Spain1214[null]229889Spain217
100214Spain342214407Camp NouSpainCarlos Velasco Carballo22009/20102000-01-012009-10-03Barcelona217[null]1Regular Season11Spain20:00:00male214La LigaAlmeríamale216available2019-12-16 23:09:16.168756Spain1214[null]0269256Spain403
Rows: 1-100 | Columns: 40
In [2]:
laliga[["home_team.managers"]].flat_vmap(vmap_col = "home_team.managers")
Out[2]:
Abc
Vmap(378)
Abc
home_team.managers.0.id
Long varchar(378)
Abc
Long varchar(378)
Abc
Long varchar(378)
Abc
home_team.managers.0.nickname
Long varchar(378)
Abc
home_team.managers.0.dob
Long varchar(378)
Abc
home_team.managers.0.country.id
Long varchar(378)
1576Sergio[null]214
2793Luis Enrique[null]214
3793Luis Enrique[null]214
4188Javi Gracia1970-05-01214
5414[null][null]112
6793Luis Enrique[null]214
7673Francisco 1978-06-17214
8793Luis Enrique[null]214
9793Luis Enrique[null]214
10211Marcelino1965-08-14214
11793Luis Enrique[null]214
123157Víctor Sánchez[null]214
13385Eduardo Berizzo[null]11
14148Rafael Benítez[null]214
15187Abelardo[null]214
16793Luis Enrique[null]214
17793Luis Enrique[null]214
18[null][null][null][null]
19[null][null][null][null]
20[null][null][null][null]
21[null][null][null][null]
22[null][null][null][null]
23[null][null][null][null]
24[null][null][null][null]
25[null][null][null][null]
26[null][null][null][null]
27[null][null][null][null]
28[null][null][null][null]
29[null][null][null][null]
301621Manolo Jiménez1964-01-26214
31[null][null][null][null]
3236Pep Guardiola[null]214
334519Miguel Ángel Lotina[null]214
341606José Luis Oltra[null]214
35[null][null][null][null]
3636Pep Guardiola[null]214
3736Pep Guardiola[null]214
38733Manuel Pellegrini[null]45
39[null][null][null][null]
40[null][null][null][null]
41[null][null][null][null]
42163Gerardo Martino1962-11-2011
43163Gerardo Martino1962-11-2011
44[null][null][null][null]
45[null][null][null][null]
46[null][null][null][null]
47[null][null][null][null]
48[null][null][null][null]
49[null][null][null][null]
50[null][null][null][null]
51[null][null][null][null]
52[null][null][null][null]
53[null][null][null][null]
54[null][null][null][null]
55[null][null][null][null]
56236Quique Sánchez Flores[null]214
5781Mauricio Pochettino[null]11
584519Miguel Ángel Lotina[null]214
59[null][null][null][null]
60[null][null][null][null]
61[null][null][null][null]
62383José Mourinho[null]183
6336Pep Guardiola[null]214
64[null][null][null][null]
6536Pep Guardiola[null]214
6636Pep Guardiola[null]214
6736Pep Guardiola[null]214
6857Pepe Mel[null]214
69[null][null][null][null]
7036Pep Guardiola[null]214
71383José Mourinho[null]183
72269Marcelo Bielsa[null]11
7336Pep Guardiola[null]214
74[null][null][null][null]
75[null][null][null][null]
76[null][null][null][null]
77[null][null][null][null]
78[null][null][null][null]
79[null][null][null][null]
80[null][null][null][null]
81[null][null][null][null]
82[null][null][null][null]
83793Luis Enrique[null]214
84227Ernesto Valverde[null]214
85793Luis Enrique[null]214
86793Luis Enrique[null]214
87227Ernesto Valverde[null]214
88227Ernesto Valverde[null]214
89793Luis Enrique[null]214
90793Luis Enrique[null]214
91227Ernesto Valverde[null]214
92793Luis Enrique[null]214
93234Pablo Machín[null]214
94620Eder Sarabia[null]214
9556[null][null]78
9656[null][null]78
9784Asier Garitano[null]214
98576Sergio[null]214
99208Juan Carlos Unzué[null]214
100[null][null][null][null]
Rows: 1-100 | Columns: 7