Working with Complex Data Types & VMaps#
Setup#
In order to work with complex data types in VerticaPy, you’ll need to complete the following three setup tasks:
Import relevant libraries:
[1]:
import verticapy as vp
Connect to Vertica:
[ ]:
vp.new_connection({"host": "10.211.55.14",
"port": "5433",
"database": "testdb",
"password": "XxX",
"user": "dbadmin"},
name = "Vertica_New_Connection")
Check your VerticaPy version to make sure you have access to the right functions:
[2]:
vp.__version__
[2]:
'0.11.0'
You can make it easier to keep track of your work by creating a custom schema: Note: Because some tables are repeated in this demonstration, tables with the same names are dropped.
[3]:
vp.drop("complex_vmap_test", method = "schema")
vp.create_schema("complex_vmap_test")
[3]:
True
We also set the path to our data:
[ ]:
path= "/home/dbadmin/"
You can download the demo datasets by clicking here.
Loading Complex Data#
There are two ways to load a nested data file:
Load directly using read_json. In this case, you will need to use an additional parameter to identify all the data types. The function loads the data using flex tables and VMaps (Native Vertica MAPS, which are flexible but not optimally performant).
Load using read_file. The function preidcts the complex data structure.
Let’s try both:
[4]:
import verticapy as vp
data = vp.read_json(path + "laliga/2008.json",
schema = "public",
ingest_local = False,
use_complex_dt = True,)
[4]:
 | 123 away_scoreInt | 🛠 Row(away_team_gender varchar(80),away_team_group varchar(80),away_team_id int,away_team_name varchar(80),country row(id int,name | 🛠 Row(competition_id int,competition_name varchar(80),country_name varchar(80)) | 🛠 Row(id int,name varchar(80)) | 123 home_scoreInt | 🛠 Row(country row(id int,name varchar(80)),home_team_gender varchar(80),home_team_group varchar(80),home_team_id int,home_team_nam | 📅 kick_offTime | 📅 last_updatedDate | 📅 match_dateDate | 123 match_idInt | Abc match_statusVarchar(80) | 123 match_weekInt | 🛠 Row(data_version date,shot_fidelity_version int,xy_fidelity_version int) | 🛠 Row(season_id int,season_name varchar(80)) |
| 1 | 0 | 1 | 19:00:00 | 2019-12-16 | 2008-08-31 | 69147 | available | 1 | ||||||
| 2 | 0 | 2 | 20:00:00 | 2019-12-16 | 2009-03-07 | 69216 | available | 26 | ||||||
| 3 | 0 | 2 | 20:00:00 | 2019-12-16 | 2009-04-11 | 69222 | available | 30 | ||||||
| 4 | 0 | 5 | 20:00:00 | 2019-12-16 | 2009-01-17 | 69183 | available | 19 | ||||||
| 5 | 0 | 5 | 22:00:00 | 2019-12-16 | 2008-10-25 | 69232 | available | 8 | ||||||
| 6 | 0 | 6 | 19:00:00 | 2019-12-16 | 2009-03-22 | 69142 | available | 28 | ||||||
| 7 | 1 | 0 | 20:00:00 | 2019-12-16 | 2009-04-04 | 69273 | available | 29 | ||||||
| 8 | 2 | 0 | 21:00:00 | 2019-12-16 | 2008-11-16 | 69285 | available | 11 | ||||||
| 9 | 2 | 1 | 17:00:00 | 2019-12-16 | 2009-02-01 | 69209 | available | 21 | ||||||
| 10 | 4 | 1 | 20:00:00 | 2019-12-16 | 2008-11-01 | 69235 | available | 9 | ||||||
| 11 | 6 | 1 | 21:00:00 | 2019-12-16 | 2008-09-21 | 69138 | available | 3 | ||||||
| 12 | 1 | 4 | 22:00:00 | 2019-12-16 | 2009-01-24 | 69189 | available | 20 | ||||||
| 13 | 1 | 6 | 22:00:00 | 2019-12-16 | 2008-10-04 | 69212 | available | 6 | ||||||
| 14 | 2 | 0 | 21:03:00 | 2019-12-16 | 2009-03-15 | 69177 | available | 27 | ||||||
| 15 | 2 | 3 | 20:00:00 | 2019-12-16 | 2008-09-24 | 69207 | available | 4 | ||||||
| 16 | 3 | 2 | 21:00:00 | 2019-12-16 | 2009-01-11 | 69230 | available | 18 | ||||||
| 17 | 0 | 2 | 22:00:00 | 2019-12-16 | 2008-12-13 | 69225 | available | 15 | ||||||
| 18 | 0 | 6 | 22:00:00 | 2019-12-16 | 2008-11-08 | 69279 | available | 10 | ||||||
| 19 | 1 | 1 | 20:00:00 | 2019-12-16 | 2008-09-13 | 69215 | available | 2 | ||||||
| 20 | 1 | 3 | 19:00:00 | 2019-12-16 | 2009-02-08 | 69231 | available | 22 | ||||||
| 21 | 2 | 1 | 20:00:00 | 2019-12-16 | 2009-02-21 | 69139 | available | 24 | ||||||
| 22 | 2 | 2 | 20:00:00 | 2019-12-16 | 2009-02-14 | 69195 | available | 23 | ||||||
| 23 | 2 | 2 | 22:00:00 | 2019-12-16 | 2009-04-25 | 69251 | available | 33 | ||||||
| 24 | 3 | 0 | 22:00:00 | 2019-12-16 | 2008-11-29 | 69171 | available | 13 | ||||||
| 25 | 3 | 3 | 19:03:00 | 2019-12-16 | 2009-05-10 | 69217 | available | 35 | ||||||
| 26 | 3 | 4 | 19:00:00 | 2019-12-16 | 2009-03-01 | 69185 | available | 25 | ||||||
| 27 | 0 | 4 | 22:00:00 | 2019-12-16 | 2008-12-06 | 69149 | available | 14 | ||||||
| 28 | 1 | 0 | 20:00:00 | 2019-12-16 | 2009-04-18 | 69223 | available | 31 | ||||||
| 29 | 2 | 1 | 19:00:00 | 2019-12-16 | 2008-12-21 | 69228 | available | 16 | ||||||
| 30 | 2 | 1 | 22:00:00 | 2019-12-16 | 2008-09-27 | 69211 | available | 5 | ||||||
| 31 | 6 | 2 | 20:00:00 | 2019-12-16 | 2009-05-02 | 69249 | available | 34 |
Rows: 1-31 | Columns: 14
Similar to the use of read_json above, we can use read_file to ingest the complex data directly:
[6]:
data = vp.read_file(path = path + "laliga/2005.json",
ingest_local = False,
schema = "complex_vmap_test",)
data
[6]:
| 123 away_scoreInt | 🛠 Row(away_team_gender varchar(80),away_team_group varchar(80),away_team_id int,away_team_name varchar(80),country row(id int,name | 🛠 Row(competition_id int,competition_name varchar(80),country_name varchar(80)) | 🛠 Row(id int,name varchar(80)) | 123 home_scoreInt | 🛠 Row(country row(id int,name varchar(80)),home_team_gender varchar(80),home_team_group varchar(80),home_team_id int,home_team_nam | 📅 kick_offTime | 📅 last_updatedDate | 📅 match_dateDate | 123 match_idInt | Abc match_statusVarchar(80) | 123 match_weekInt | 🛠 Row(data_version date,shot_fidelity_version int,xy_fidelity_version int) | 🛠 Row(season_id int,season_name varchar(80)) |
| 1 | 0 | 3 | 22:00:00 | 2019-12-16 | 2005-10-22 | 68318 | available | 8 | ||||||
| 2 | 1 | 2 | 19:00:00 | 2019-12-16 | 2006-01-15 | 68342 | available | 19 | ||||||
| 3 | 1 | 5 | 22:00:00 | 2019-12-16 | 2006-02-18 | 69172 | available | 24 | ||||||
| 4 | 3 | 1 | 21:00:00 | 2019-12-16 | 2005-11-06 | 68339 | available | 10 | ||||||
| 5 | 0 | 2 | 19:00:00 | 2019-12-16 | 2006-01-22 | 68324 | available | 20 | ||||||
| 6 | 0 | 2 | 20:30:00 | 2019-12-16 | 2005-10-26 | 69164 | available | 11 | ||||||
| 7 | 1 | 2 | 21:00:00 | 2020-02-27 | 2005-12-11 | 68321 | available | 15 | ||||||
| 8 | 2 | 1 | 22:00:00 | 2019-12-16 | 2006-01-07 | 68348 | available | 18 | ||||||
| 9 | 2 | 2 | 20:00:00 | 2019-12-16 | 2005-10-01 | 68317 | available | 6 | ||||||
| 10 | 3 | 1 | 22:00:00 | 2019-12-16 | 2005-12-17 | 68322 | available | 16 | ||||||
| 11 | 0 | 2 | 21:00:00 | 2019-12-16 | 2005-12-20 | 68323 | available | 17 | ||||||
| 12 | 2 | 0 | 22:00:00 | 2019-12-16 | 2006-02-25 | 68351 | available | 25 | ||||||
| 13 | 3 | 0 | 20:00:00 | 2019-12-16 | 2005-11-19 | 68319 | available | 12 | ||||||
| 14 | 3 | 1 | 19:00:00 | 2019-12-16 | 2006-02-05 | 68350 | available | 22 | ||||||
| 15 | 1 | 4 | 21:00:00 | 2019-12-16 | 2005-11-27 | 68354 | available | 13 | ||||||
| 16 | 2 | 0 | 19:00:00 | 2019-12-16 | 2005-12-04 | 68320 | available | 14 | ||||||
| 17 | 3 | 0 | 19:00:00 | 2019-12-16 | 2006-01-29 | 68325 | available | 21 |
Rows: 1-17 | Columns: 14
We can also use the handy ‘genSQL’ parameter to generate (but not execute) the SQL needed to create the final relation: Note: This is a great way to customize the data ingestion or alter the final relation types.
[9]:
sql = vp.read_file(path = path + "laliga/2005.json",
schema = "complex_vmap_test",
table_name = "laliga_2005",
genSQL = True,
varchar_varbinary_length = 60,
ingest_local = False,
dtype = {"away_score": "float"})
for query in sql:
print(query)
CREATE TABLE "complex_vmap_test"."laliga_2005"("away_score" float, "away_team" Row("away_team_gender" varchar(60), "away_team_group" varchar(60), "away_team_id" int, "away_team_name" varchar(60), "country" Row("id" int, "name" varchar(60))), "competition" Row("competition_id" int, "competition_name" varchar(60), "country_name" varchar(60)), "competition_stage" Row("id" int, "name" varchar(60)), "home_score" int, "home_team" Row("country" Row("id" int, "name" varchar(60)), "home_team_gender" varchar(60), "home_team_group" varchar(60), "home_team_id" int, "home_team_name" varchar(60)), "kick_off" time, "last_updated" date, "match_date" date, "match_id" int, "match_status" varchar(60), "match_week" int, "metadata" Row("data_version" date, "shot_fidelity_version" int, "xy_fidelity_version" int), "season" Row("season_id" int, "season_name" varchar(60)))
copy "complex_vmap_test"."laliga_2005" from '/scratch_b/qa/ericsson/laliga/2005.json' PARSER FJsonParser()
Feature Exploration#
In the generated SQL from the above example, we can see that the away_team column is a ROW type with a complex structure consisting of many sub-columns. We can convert this column into a JSON and view its contents:
[7]:
data["competition_stage"].astype("json")
[7]:
| 123 away_scoreInt | 🛠 Row(away_team_gender varchar(80),away_team_group varchar(80),away_team_id int,away_team_name varchar(80),country row(id int,name | 🛠 Row(competition_id int,competition_name varchar(80),country_name varchar(80)) | Abc competition_stageVarchar | 123 home_scoreInt | 🛠 Row(country row(id int,name varchar(80)),home_team_gender varchar(80),home_team_group varchar(80),home_team_id int,home_team_nam | 📅 kick_offTime | 📅 last_updatedDate | 📅 match_dateDate | 123 match_idInt | Abc match_statusVarchar(80) | 123 match_weekInt | 🛠 Row(data_version date,shot_fidelity_version int,xy_fidelity_version int) | 🛠 Row(season_id int,season_name varchar(80)) |
| 1 | 0 | {"id":1,"name":"Regular Season"} | 2 | 19:00:00 | 2019-12-16 | 2006-01-22 | 68324 | available | 20 | |||||
| 2 | 0 | {"id":1,"name":"Regular Season"} | 2 | 20:30:00 | 2019-12-16 | 2005-10-26 | 69164 | available | 11 | |||||
| 3 | 0 | {"id":1,"name":"Regular Season"} | 2 | 21:00:00 | 2019-12-16 | 2005-12-20 | 68323 | available | 17 | |||||
| 4 | 0 | {"id":1,"name":"Regular Season"} | 3 | 22:00:00 | 2019-12-16 | 2005-10-22 | 68318 | available | 8 | |||||
| 5 | 1 | {"id":1,"name":"Regular Season"} | 2 | 19:00:00 | 2019-12-16 | 2006-01-15 | 68342 | available | 19 | |||||
| 6 | 1 | {"id":1,"name":"Regular Season"} | 2 | 21:00:00 | 2020-02-27 | 2005-12-11 | 68321 | available | 15 | |||||
| 7 | 1 | {"id":1,"name":"Regular Season"} | 4 | 21:00:00 | 2019-12-16 | 2005-11-27 | 68354 | available | 13 | |||||
| 8 | 1 | {"id":1,"name":"Regular Season"} | 5 | 22:00:00 | 2019-12-16 | 2006-02-18 | 69172 | available | 24 | |||||
| 9 | 2 | {"id":1,"name":"Regular Season"} | 0 | 19:00:00 | 2019-12-16 | 2005-12-04 | 68320 | available | 14 | |||||
| 10 | 2 | {"id":1,"name":"Regular Season"} | 0 | 22:00:00 | 2019-12-16 | 2006-02-25 | 68351 | available | 25 | |||||
| 11 | 2 | {"id":1,"name":"Regular Season"} | 1 | 22:00:00 | 2019-12-16 | 2006-01-07 | 68348 | available | 18 | |||||
| 12 | 2 | {"id":1,"name":"Regular Season"} | 2 | 20:00:00 | 2019-12-16 | 2005-10-01 | 68317 | available | 6 | |||||
| 13 | 3 | {"id":1,"name":"Regular Season"} | 0 | 19:00:00 | 2019-12-16 | 2006-01-29 | 68325 | available | 21 | |||||
| 14 | 3 | {"id":1,"name":"Regular Season"} | 0 | 20:00:00 | 2019-12-16 | 2005-11-19 | 68319 | available | 12 | |||||
| 15 | 3 | {"id":1,"name":"Regular Season"} | 1 | 19:00:00 | 2019-12-16 | 2006-02-05 | 68350 | available | 22 | |||||
| 16 | 3 | {"id":1,"name":"Regular Season"} | 1 | 21:00:00 | 2019-12-16 | 2005-11-06 | 68339 | available | 10 | |||||
| 17 | 3 | {"id":1,"name":"Regular Season"} | 1 | 22:00:00 | 2019-12-16 | 2005-12-17 | 68322 | available | 16 |
Rows: 1-17 | Columns: 14
As with a normal vDataFrame, we can easily extract the values from the sub-columns:
[8]:
data["away_team"]["away_team_gender"]
[8]:
| Abc away_team_genderVarchar(80) |
| 1 | male |
| 2 | male |
| 3 | male |
| 4 | male |
| 5 | male |
| 6 | male |
| 7 | male |
| 8 | male |
| 9 | male |
| 10 | male |
| 11 | male |
| 12 | male |
| 13 | male |
| 14 | male |
| 15 | male |
| 16 | male |
| 17 | male |
Rows: 17 | Column: away_team_gender | Type: Varchar(80)
We can view any nested data structure by index:
[9]:
data["competition"]["competition_id"]
[9]:
| 123 competition_idInteger |
| 1 | 11 |
| 2 | 11 |
| 3 | 11 |
| 4 | 11 |
| 5 | 11 |
| 6 | 11 |
| 7 | 11 |
| 8 | 11 |
| 9 | 11 |
| 10 | 11 |
| 11 | 11 |
| 12 | 11 |
| 13 | 11 |
| 14 | 11 |
| 15 | 11 |
| 16 | 11 |
| 17 | 11 |
Rows: 17 | Column: competition_id | Type: Integer
These nested structures can be used to create features:
[10]:
data["name_home"] = data["home_team"]["home_team_name"]
We can even flatten the nested structure inside a json file, either flattening the entire file or just particular columns:
[17]:
data = vp.read_json(path = path + "laliga/2008.json",
table_name = "laliga_flat",
schema = "complex_vmap_test",
ingest_local = False,
flatten_maps = True,)
data
The table "complex_vmap_test"."laliga_flat" has been successfully created.
[17]:
| Abc Vmap(368) | Abc Vmap(378) | Abc season.season_nameVarchar(20) | 123 season.season_idInt | 123 metadata.xy_fidelity_versionInt | 123 metadata.shot_fidelity_versionInt | 📅 metadata.data_versionDate | 123 match_weekInt | Abc match_statusVarchar(20) | 123 match_idInt | 📅 match_dateDate | 📅 last_updatedTimestamp | 📅 kick_offTime | Abc home_team.home_team_nameVarchar(34) | 123 home_team.home_team_idInt | Abc home_team.home_team_groupVarchar(20) | Abc home_team.home_team_genderVarchar(20) | Abc home_team.country.nameVarchar(20) | 123 home_team.country.idInt | 123 home_scoreInt | Abc competition_stage.nameVarchar(28) | 123 competition_stage.idInt | Abc competition.country_nameVarchar(20) | Abc competition.competition_nameVarchar(20) | 123 competition.competition_idInt | Abc away_team.country.nameVarchar(20) | 123 away_team.country.idInt | Abc away_team.away_team_nameVarchar(38) | 123 away_team.away_team_idInt | Abc away_team.away_team_groupVarchar(20) | Abc away_team.away_team_genderVarchar(20) | 123 away_scoreInt |
| 1 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 1 | available | 69147 | 2008-08-31 | 2019-12-16 23:09:16.168756 | 19:00:00 | Numancia | 444 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 0 | ||
| 2 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 2 | available | 69215 | 2008-09-13 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Racing Santander | 1217 | [null] | male | 1 | ||
| 3 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 3 | available | 69138 | 2008-09-21 | 2019-12-16 23:09:16.168756 | 21:00:00 | Sporting Gijón | 1041 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | ||
| 4 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 4 | available | 69207 | 2008-09-24 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Betis | 218 | [null] | male | 2 | ||
| 5 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 5 | available | 69211 | 2008-09-27 | 2019-12-16 23:09:16.168756 | 22:00:00 | Espanyol | 214 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | ||
| 6 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 6 | available | 69212 | 2008-10-04 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Atlético Madrid | 212 | [null] | male | 1 | ||
| 7 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 8 | available | 69232 | 2008-10-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Almería | 403 | [null] | male | 0 | ||
| 8 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 9 | available | 69235 | 2008-11-01 | 2019-12-16 23:09:16.168756 | 20:00:00 | Málaga | 223 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 4 | ||
| 9 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 10 | available | 69279 | 2008-11-08 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Valladolid | 901 | [null] | male | 0 | ||
| 10 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 11 | available | 69285 | 2008-11-16 | 2019-12-16 23:09:16.168756 | 21:00:00 | Recreativo Huelva | 1220 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | ||
| 11 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 13 | available | 69171 | 2008-11-29 | 2019-12-16 23:09:16.168756 | 22:00:00 | Sevilla | 213 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | ||
| 12 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 14 | available | 69149 | 2008-12-06 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Valencia | 207 | [null] | male | 0 | ||
| 13 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 15 | available | 69225 | 2008-12-13 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Madrid | 220 | [null] | male | 0 | ||
| 14 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 16 | available | 69228 | 2008-12-21 | 2019-12-16 23:09:16.168756 | 19:00:00 | Villarreal | 222 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | ||
| 15 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 18 | available | 69230 | 2009-01-11 | 2019-12-16 23:09:16.168756 | 21:00:00 | Osasuna | 422 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | ||
| 16 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 19 | available | 69183 | 2009-01-17 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Deportivo La Coruna | 219 | [null] | male | 0 | ||
| 17 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 20 | available | 69189 | 2009-01-24 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Numancia | 444 | [null] | male | 1 | ||
| 18 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 21 | available | 69209 | 2009-02-01 | 2019-12-16 23:09:16.168756 | 17:00:00 | Racing Santander | 1217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | ||
| 19 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 22 | available | 69231 | 2009-02-08 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Sporting Gijón | 1041 | [null] | male | 1 | ||
| 20 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 23 | available | 69195 | 2009-02-14 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Betis | 218 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | ||
| 21 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 24 | available | 69139 | 2009-02-21 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Espanyol | 214 | [null] | male | 2 | ||
| 22 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 25 | available | 69185 | 2009-03-01 | 2019-12-16 23:09:16.168756 | 19:00:00 | Atlético Madrid | 212 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | ||
| 23 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 26 | available | 69216 | 2009-03-07 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Athletic Bilbao | 215 | [null] | male | 0 | ||
| 24 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 27 | available | 69177 | 2009-03-15 | 2019-12-16 23:09:16.168756 | 21:03:00 | Almería | 403 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | ||
| 25 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 28 | available | 69142 | 2009-03-22 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Málaga | 223 | [null] | male | 0 | ||
| 26 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 29 | available | 69273 | 2009-04-04 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Valladolid | 901 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | ||
| 27 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 30 | available | 69222 | 2009-04-11 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Recreativo Huelva | 1220 | [null] | male | 0 | ||
| 28 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 31 | available | 69223 | 2009-04-18 | 2019-12-16 23:09:16.168756 | 20:00:00 | Getafe | 216 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | ||
| 29 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 33 | available | 69251 | 2009-04-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Valencia | 207 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | ||
| 30 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 34 | available | 69249 | 2009-05-02 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Madrid | 220 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | ||
| 31 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 35 | available | 69217 | 2009-05-10 | 2019-12-16 23:09:16.168756 | 19:03:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Villarreal | 222 | [null] | male | 3 |
Rows: 1-31 | Columns: 32
We can see that all the columns from the JSON file have been flattened and multiple columns have been created for each sub-column. This causes some loss in data structure, but makes it easy to see the data and to use it for model building.
It is important to note that the data type of certain columns (home_team.managers) is now VMap, and not the ROW type that we saw in the above cells. Even though both are used to capture nested data, there is in a subtle difference between the two.
VMap: More flexible as it stores the data as a string of maps, allowing the ingestion of data in varying shapes. The shape is not fixed and new keys can easily be handled. This is a great option when we don’t know the structure in advance, or if the structure changes over time.
Row: More rigid because the dictionaries, including all the data types, are fixed when they are defined. Newly parsed keys are ignored. But because of it’s rigid structure, it is much more performant than VMaps. They are best used when the file structure is known in advance.
To deconvolve the nested structure, we can use the ‘flatten_arrays’ parameter in order to make the output strictly formatted. However, it can be an expensive process.
[19]:
vp.drop("complex_vmap_test.laliga_flat")
data = vp.read_json(path = path + "laliga/2008.json",
table_name = "laliga_flat",
schema = "complex_vmap_test",
ingest_local = False,
flatten_arrays=True,)
data
The table "complex_vmap_test"."laliga_flat" has been successfully created.
[19]:
| Abc home_team.managers.0.nicknameVarchar(42) | Abc home_team.managers.0.nameVarchar(64) | 123 home_team.managers.0.idInt | 📅 home_team.managers.0.dobDate | Abc Varchar(20) | 123 home_team.managers.0.country.idInt | Abc away_team.managers.0.nicknameVarchar(42) | Abc Varchar(72) | 123 away_team.managers.0.idInt | 📅 away_team.managers.0.dobDate | Abc Varchar(20) | 123 away_team.managers.0.country.idInt | Abc season.season_nameVarchar(20) | 123 season.season_idInt | 123 metadata.xy_fidelity_versionInt | 123 metadata.shot_fidelity_versionInt | 📅 metadata.data_versionDate | 123 match_weekInt | Abc match_statusVarchar(20) | 123 match_idInt | 📅 match_dateDate | 📅 last_updatedTimestamp | 📅 kick_offTime | Abc home_team.home_team_nameVarchar(34) | 123 home_team.home_team_idInt | Abc home_team.home_team_groupVarchar(20) | Abc home_team.home_team_genderVarchar(20) | Abc home_team.country.nameVarchar(20) | 123 home_team.country.idInt | 123 home_scoreInt | Abc competition_stage.nameVarchar(28) | 123 competition_stage.idInt | Abc competition.country_nameVarchar(20) | Abc competition.competition_nameVarchar(20) | 123 competition.competition_idInt | Abc away_team.country.nameVarchar(20) | 123 away_team.country.idInt | Abc away_team.away_team_nameVarchar(38) | 123 away_team.away_team_idInt | Abc away_team.away_team_groupVarchar(20) | Abc away_team.away_team_genderVarchar(20) | 123 away_scoreInt |
| 1 | José Luis Mendilibar | José Luis Mendilibar Etxebarria | 221 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 29 | available | 69273 | 2009-04-04 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Valladolid | 901 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | |||
| 2 | Juan Muñiz | Juan Ramón López Muñiz | 2 | 1968-11-02 | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 21 | available | 69209 | 2009-02-01 | 2019-12-16 23:09:16.168756 | 17:00:00 | Racing Santander | 1217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 3 | Juande Ramos | Juan de la Cruz Ramos Cano | 3899 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 34 | available | 69249 | 2009-05-02 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Madrid | 220 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | |||
| 4 | Lucas Alcaraz | Luis Lucas Alcaraz González | 1612 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 11 | available | 69285 | 2008-11-16 | 2019-12-16 23:09:16.168756 | 21:00:00 | Recreativo Huelva | 1220 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 5 | Manolo Jiménez | Manuel Enrique Jiménez Jiménez | 1621 | 1964-01-26 | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 13 | available | 69171 | 2008-11-29 | 2019-12-16 23:09:16.168756 | 22:00:00 | Sevilla | 213 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 6 | Manuel Pellegrini | Manuel Luis Pellegrini Ripamonti | 733 | [null] | 45 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 16 | available | 69228 | 2008-12-21 | 2019-12-16 23:09:16.168756 | 19:00:00 | Villarreal | 222 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 7 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Javier Aguirre | 3196 | [null] | 147 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 6 | available | 69212 | 2008-10-04 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Atlético Madrid | 212 | [null] | male | 1 | |||
| 8 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Joaquín Caparrós | 497 | 1955-10-13 | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 26 | available | 69216 | 2009-03-07 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Athletic Bilbao | 215 | [null] | male | 0 | |||
| 9 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | José Luis Mendilibar | 221 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 10 | available | 69279 | 2008-11-08 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Valladolid | 901 | [null] | male | 0 | |||
| 10 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Juan Muñiz | 2 | 1968-11-02 | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 2 | available | 69215 | 2008-09-13 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Racing Santander | 1217 | [null] | male | 1 | |||
| 11 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Juande Ramos | 3899 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 15 | available | 69225 | 2008-12-13 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Madrid | 220 | [null] | male | 0 | |||
| 12 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Lucas Alcaraz | 1612 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 30 | available | 69222 | 2009-04-11 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Recreativo Huelva | 1220 | [null] | male | 0 | |||
| 13 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Manuel Pellegrini | 733 | [null] | 45 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 35 | available | 69217 | 2009-05-10 | 2019-12-16 23:09:16.168756 | 19:03:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Villarreal | 222 | [null] | male | 3 | |||
| 14 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Mauricio Pochettino | 81 | [null] | 11 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 24 | available | 69139 | 2009-02-21 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Espanyol | 214 | [null] | male | 2 | |||
| 15 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Miguel Ángel Lotina | 4519 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 19 | available | 69183 | 2009-01-17 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Deportivo La Coruna | 219 | [null] | male | 0 | |||
| 16 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Unai Emery | 21 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 14 | available | 69149 | 2008-12-06 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Valencia | 207 | [null] | male | 0 | |||
| 17 | Unai Emery | Unai Emery Etxegoien | 21 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 33 | available | 69251 | 2009-04-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Valencia | 207 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 18 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 28 | available | 69142 | 2009-03-22 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Málaga | 223 | [null] | male | 0 | |||
| 19 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 1 | available | 69147 | 2008-08-31 | 2019-12-16 23:09:16.168756 | 19:00:00 | Numancia | 444 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 0 | |||
| 20 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 3 | available | 69138 | 2008-09-21 | 2019-12-16 23:09:16.168756 | 21:00:00 | Sporting Gijón | 1041 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | |||
| 21 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 20 | available | 69189 | 2009-01-24 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Numancia | 444 | [null] | male | 1 | |||
| 22 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 31 | available | 69223 | 2009-04-18 | 2019-12-16 23:09:16.168756 | 20:00:00 | Getafe | 216 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | |||
| 23 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 25 | available | 69185 | 2009-03-01 | 2019-12-16 23:09:16.168756 | 19:00:00 | Atlético Madrid | 212 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 24 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 27 | available | 69177 | 2009-03-15 | 2019-12-16 23:09:16.168756 | 21:03:00 | Almería | 403 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 25 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 22 | available | 69231 | 2009-02-08 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Sporting Gijón | 1041 | [null] | male | 1 | |||
| 26 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 23 | available | 69195 | 2009-02-14 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Betis | 218 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 27 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 18 | available | 69230 | 2009-01-11 | 2019-12-16 23:09:16.168756 | 21:00:00 | Osasuna | 422 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 28 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 4 | available | 69207 | 2008-09-24 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Betis | 218 | [null] | male | 2 | |||
| 29 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 9 | available | 69235 | 2008-11-01 | 2019-12-16 23:09:16.168756 | 20:00:00 | Málaga | 223 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 4 | |||
| 30 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 8 | available | 69232 | 2008-10-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Almería | 403 | [null] | male | 0 | |||
| 31 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 5 | available | 69211 | 2008-09-27 | 2019-12-16 23:09:16.168756 | 22:00:00 | Espanyol | 214 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
Rows: 1-31 | Columns: 42
We can even convert columns into other formats, such as string:
[20]:
data["home_team.managers.0.nickname"].astype(str)
[20]:
| Abc home_team.managers.0.nicknameVarchar | Abc home_team.managers.0.nameVarchar(64) | 123 home_team.managers.0.idInt | 📅 home_team.managers.0.dobDate | Abc Varchar(20) | 123 home_team.managers.0.country.idInt | Abc away_team.managers.0.nicknameVarchar(42) | Abc Varchar(72) | 123 away_team.managers.0.idInt | 📅 away_team.managers.0.dobDate | Abc Varchar(20) | 123 away_team.managers.0.country.idInt | Abc season.season_nameVarchar(20) | 123 season.season_idInt | 123 metadata.xy_fidelity_versionInt | 123 metadata.shot_fidelity_versionInt | 📅 metadata.data_versionDate | 123 match_weekInt | Abc match_statusVarchar(20) | 123 match_idInt | 📅 match_dateDate | 📅 last_updatedTimestamp | 📅 kick_offTime | Abc home_team.home_team_nameVarchar(34) | 123 home_team.home_team_idInt | Abc home_team.home_team_groupVarchar(20) | Abc home_team.home_team_genderVarchar(20) | Abc home_team.country.nameVarchar(20) | 123 home_team.country.idInt | 123 home_scoreInt | Abc competition_stage.nameVarchar(28) | 123 competition_stage.idInt | Abc competition.country_nameVarchar(20) | Abc competition.competition_nameVarchar(20) | 123 competition.competition_idInt | Abc away_team.country.nameVarchar(20) | 123 away_team.country.idInt | Abc away_team.away_team_nameVarchar(38) | 123 away_team.away_team_idInt | Abc away_team.away_team_groupVarchar(20) | Abc away_team.away_team_genderVarchar(20) | 123 away_scoreInt |
| 1 | José Luis Mendilibar | José Luis Mendilibar Etxebarria | 221 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 29 | available | 69273 | 2009-04-04 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Valladolid | 901 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | |||
| 2 | Juan Muñiz | Juan Ramón López Muñiz | 2 | 1968-11-02 | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 21 | available | 69209 | 2009-02-01 | 2019-12-16 23:09:16.168756 | 17:00:00 | Racing Santander | 1217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 3 | Juande Ramos | Juan de la Cruz Ramos Cano | 3899 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 34 | available | 69249 | 2009-05-02 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Madrid | 220 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | |||
| 4 | Lucas Alcaraz | Luis Lucas Alcaraz González | 1612 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 11 | available | 69285 | 2008-11-16 | 2019-12-16 23:09:16.168756 | 21:00:00 | Recreativo Huelva | 1220 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 5 | Manolo Jiménez | Manuel Enrique Jiménez Jiménez | 1621 | 1964-01-26 | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 13 | available | 69171 | 2008-11-29 | 2019-12-16 23:09:16.168756 | 22:00:00 | Sevilla | 213 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 6 | Manuel Pellegrini | Manuel Luis Pellegrini Ripamonti | 733 | [null] | 45 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 16 | available | 69228 | 2008-12-21 | 2019-12-16 23:09:16.168756 | 19:00:00 | Villarreal | 222 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 7 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Javier Aguirre | 3196 | [null] | 147 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 6 | available | 69212 | 2008-10-04 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Atlético Madrid | 212 | [null] | male | 1 | |||
| 8 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Joaquín Caparrós | 497 | 1955-10-13 | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 26 | available | 69216 | 2009-03-07 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Athletic Bilbao | 215 | [null] | male | 0 | |||
| 9 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | José Luis Mendilibar | 221 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 10 | available | 69279 | 2008-11-08 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Valladolid | 901 | [null] | male | 0 | |||
| 10 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Juan Muñiz | 2 | 1968-11-02 | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 2 | available | 69215 | 2008-09-13 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Racing Santander | 1217 | [null] | male | 1 | |||
| 11 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Juande Ramos | 3899 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 15 | available | 69225 | 2008-12-13 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Madrid | 220 | [null] | male | 0 | |||
| 12 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Lucas Alcaraz | 1612 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 30 | available | 69222 | 2009-04-11 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Recreativo Huelva | 1220 | [null] | male | 0 | |||
| 13 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Manuel Pellegrini | 733 | [null] | 45 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 35 | available | 69217 | 2009-05-10 | 2019-12-16 23:09:16.168756 | 19:03:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Villarreal | 222 | [null] | male | 3 | |||
| 14 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Mauricio Pochettino | 81 | [null] | 11 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 24 | available | 69139 | 2009-02-21 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Espanyol | 214 | [null] | male | 2 | |||
| 15 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Miguel Ángel Lotina | 4519 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 19 | available | 69183 | 2009-01-17 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Deportivo La Coruna | 219 | [null] | male | 0 | |||
| 16 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Unai Emery | 21 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 14 | available | 69149 | 2008-12-06 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Valencia | 207 | [null] | male | 0 | |||
| 17 | Unai Emery | Unai Emery Etxegoien | 21 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 33 | available | 69251 | 2009-04-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Valencia | 207 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 18 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 28 | available | 69142 | 2009-03-22 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Málaga | 223 | [null] | male | 0 | |||
| 19 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 1 | available | 69147 | 2008-08-31 | 2019-12-16 23:09:16.168756 | 19:00:00 | Numancia | 444 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 0 | |||
| 20 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 3 | available | 69138 | 2008-09-21 | 2019-12-16 23:09:16.168756 | 21:00:00 | Sporting Gijón | 1041 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | |||
| 21 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 20 | available | 69189 | 2009-01-24 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Numancia | 444 | [null] | male | 1 | |||
| 22 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 31 | available | 69223 | 2009-04-18 | 2019-12-16 23:09:16.168756 | 20:00:00 | Getafe | 216 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | |||
| 23 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 25 | available | 69185 | 2009-03-01 | 2019-12-16 23:09:16.168756 | 19:00:00 | Atlético Madrid | 212 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 24 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 27 | available | 69177 | 2009-03-15 | 2019-12-16 23:09:16.168756 | 21:03:00 | Almería | 403 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 25 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 22 | available | 69231 | 2009-02-08 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Sporting Gijón | 1041 | [null] | male | 1 | |||
| 26 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 23 | available | 69195 | 2009-02-14 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Betis | 218 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 27 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 18 | available | 69230 | 2009-01-11 | 2019-12-16 23:09:16.168756 | 21:00:00 | Osasuna | 422 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 28 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 4 | available | 69207 | 2008-09-24 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Betis | 218 | [null] | male | 2 | |||
| 29 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 9 | available | 69235 | 2008-11-01 | 2019-12-16 23:09:16.168756 | 20:00:00 | Málaga | 223 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 4 | |||
| 30 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 8 | available | 69232 | 2008-10-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Almería | 403 | [null] | male | 0 | |||
| 31 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 5 | available | 69211 | 2008-09-27 | 2019-12-16 23:09:16.168756 | 22:00:00 | Espanyol | 214 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
Rows: 1-31 | Columns: 42
Or integer:
[47]:
data["match_week"].astype(int)
[47]:
| Abc home_team.managers.0.nicknameVarchar | Abc home_team.managers.0.nameVarchar(64) | 123 home_team.managers.0.idInt | 📅 home_team.managers.0.dobDate | Abc Varchar(20) | 123 home_team.managers.0.country.idInt | Abc away_team.managers.0.nicknameVarchar(42) | Abc Varchar(72) | 123 away_team.managers.0.idInt | 📅 away_team.managers.0.dobDate | Abc Varchar(20) | 123 away_team.managers.0.country.idInt | Abc season.season_nameVarchar(20) | 123 season.season_idInt | 123 metadata.xy_fidelity_versionInt | 123 metadata.shot_fidelity_versionInt | 📅 metadata.data_versionDate | 123 match_weekInt | Abc match_statusVarchar(20) | 123 match_idInt | 📅 match_dateDate | 📅 last_updatedTimestamp | 📅 kick_offTime | Abc home_team.home_team_nameVarchar(34) | 123 home_team.home_team_idInt | Abc home_team.home_team_groupVarchar(20) | Abc home_team.home_team_genderVarchar(20) | Abc home_team.country.nameVarchar(20) | 123 home_team.country.idInt | 123 home_scoreInt | Abc competition_stage.nameVarchar(28) | 123 competition_stage.idInt | Abc competition.country_nameVarchar(20) | Abc competition.competition_nameVarchar(20) | 123 competition.competition_idInt | Abc away_team.country.nameVarchar(20) | 123 away_team.country.idInt | Abc away_team.away_team_nameVarchar(38) | 123 away_team.away_team_idInt | Abc away_team.away_team_groupVarchar(20) | Abc away_team.away_team_genderVarchar(20) | 123 away_scoreInt |
| 1 | José Luis Mendilibar | José Luis Mendilibar Etxebarria | 221 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 29 | available | 69273 | 2009-04-04 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Valladolid | 901 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | |||
| 2 | Juan Muñiz | Juan Ramón López Muñiz | 2 | 1968-11-02 | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 21 | available | 69209 | 2009-02-01 | 2019-12-16 23:09:16.168756 | 17:00:00 | Racing Santander | 1217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 3 | Juande Ramos | Juan de la Cruz Ramos Cano | 3899 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 34 | available | 69249 | 2009-05-02 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Madrid | 220 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | |||
| 4 | Lucas Alcaraz | Luis Lucas Alcaraz González | 1612 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 11 | available | 69285 | 2008-11-16 | 2019-12-16 23:09:16.168756 | 21:00:00 | Recreativo Huelva | 1220 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 5 | Manolo Jiménez | Manuel Enrique Jiménez Jiménez | 1621 | 1964-01-26 | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 13 | available | 69171 | 2008-11-29 | 2019-12-16 23:09:16.168756 | 22:00:00 | Sevilla | 213 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 6 | Manuel Pellegrini | Manuel Luis Pellegrini Ripamonti | 733 | [null] | 45 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 16 | available | 69228 | 2008-12-21 | 2019-12-16 23:09:16.168756 | 19:00:00 | Villarreal | 222 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 7 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Javier Aguirre | 3196 | [null] | 147 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 6 | available | 69212 | 2008-10-04 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Atlético Madrid | 212 | [null] | male | 1 | |||
| 8 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Joaquín Caparrós | 497 | 1955-10-13 | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 26 | available | 69216 | 2009-03-07 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Athletic Bilbao | 215 | [null] | male | 0 | |||
| 9 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | José Luis Mendilibar | 221 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 10 | available | 69279 | 2008-11-08 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Valladolid | 901 | [null] | male | 0 | |||
| 10 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Juan Muñiz | 2 | 1968-11-02 | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 2 | available | 69215 | 2008-09-13 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Racing Santander | 1217 | [null] | male | 1 | |||
| 11 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Juande Ramos | 3899 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 15 | available | 69225 | 2008-12-13 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Madrid | 220 | [null] | male | 0 | |||
| 12 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Lucas Alcaraz | 1612 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 30 | available | 69222 | 2009-04-11 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Recreativo Huelva | 1220 | [null] | male | 0 | |||
| 13 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Manuel Pellegrini | 733 | [null] | 45 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 35 | available | 69217 | 2009-05-10 | 2019-12-16 23:09:16.168756 | 19:03:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Villarreal | 222 | [null] | male | 3 | |||
| 14 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Mauricio Pochettino | 81 | [null] | 11 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 24 | available | 69139 | 2009-02-21 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Espanyol | 214 | [null] | male | 2 | |||
| 15 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Miguel Ángel Lotina | 4519 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 19 | available | 69183 | 2009-01-17 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Deportivo La Coruna | 219 | [null] | male | 0 | |||
| 16 | Pep Guardiola | Josep Guardiola i Sala | 36 | [null] | 214 | Unai Emery | 21 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 14 | available | 69149 | 2008-12-06 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Valencia | 207 | [null] | male | 0 | |||
| 17 | Unai Emery | Unai Emery Etxegoien | 21 | [null] | 214 | Pep Guardiola | 36 | [null] | 214 | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 33 | available | 69251 | 2009-04-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Valencia | 207 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 18 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 28 | available | 69142 | 2009-03-22 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 6 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Málaga | 223 | [null] | male | 0 | |||
| 19 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 1 | available | 69147 | 2008-08-31 | 2019-12-16 23:09:16.168756 | 19:00:00 | Numancia | 444 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 0 | |||
| 20 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 3 | available | 69138 | 2008-09-21 | 2019-12-16 23:09:16.168756 | 21:00:00 | Sporting Gijón | 1041 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 6 | |||
| 21 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 20 | available | 69189 | 2009-01-24 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Numancia | 444 | [null] | male | 1 | |||
| 22 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 31 | available | 69223 | 2009-04-18 | 2019-12-16 23:09:16.168756 | 20:00:00 | Getafe | 216 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 1 | |||
| 23 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 25 | available | 69185 | 2009-03-01 | 2019-12-16 23:09:16.168756 | 19:00:00 | Atlético Madrid | 212 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 24 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 27 | available | 69177 | 2009-03-15 | 2019-12-16 23:09:16.168756 | 21:03:00 | Almería | 403 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 25 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 22 | available | 69231 | 2009-02-08 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Sporting Gijón | 1041 | [null] | male | 1 | |||
| 26 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 23 | available | 69195 | 2009-02-14 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Betis | 218 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 | |||
| 27 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 18 | available | 69230 | 2009-01-11 | 2019-12-16 23:09:16.168756 | 21:00:00 | Osasuna | 422 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 | |||
| 28 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 4 | available | 69207 | 2008-09-24 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Betis | 218 | [null] | male | 2 | |||
| 29 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 9 | available | 69235 | 2008-11-01 | 2019-12-16 23:09:16.168756 | 20:00:00 | Málaga | 223 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 4 | |||
| 30 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 8 | available | 69232 | 2008-10-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Almería | 403 | [null] | male | 0 | |||
| 31 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2008/2009 | 41 | 2 | 2 | 2000-01-01 | 5 | available | 69211 | 2008-09-27 | 2019-12-16 23:09:16.168756 | 22:00:00 | Espanyol | 214 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
Rows: 1-31 | Columns: 42
It is also possible to:
Cast str to array
Cast complex data types to json str
Cast str to VMAPs
And much more…
Multiple File Ingestion#
If we have multiple files with the same extension, we can easily ingest them using the “*” operator:
[7]:
data = vp.read_file(path = path + "laliga/*.json",
table_name = "laliga_all",
ingest_local = False,
schema = "complex_vmap_test",)
data
[7]:
| 123 away_scoreInt | 🛠 Row(away_team_gender varchar(80),away_team_group varchar(80),away_team_id int,away_team_name varchar(80),country row(id int,name | 🛠 Row(competition_id int,competition_name varchar(80),country_name varchar(80)) | 🛠 Row(id int,name varchar(80)) | 123 home_scoreInt | 🛠 Row(country row(id int,name varchar(80)),home_team_gender varchar(80),home_team_group varchar(80),home_team_id int,home_team_nam | 📅 kick_offTime | 📅 last_updatedDate | 📅 match_dateDate | 123 match_idInt | Abc match_statusVarchar(80) | 123 match_weekInt | 🛠 Row(data_version date,shot_fidelity_version int,xy_fidelity_version int) | 🛠 Row(season_id int,season_name varchar(80)) |
| 1 | 0 | 0 | 19:00:00 | 2019-12-16 | 2014-05-11 | 266201 | available | 37 | ||||||
| 2 | 0 | 0 | 20:00:00 | 2019-12-16 | 2013-10-19 | 266462 | available | 9 | ||||||
| 3 | 0 | 0 | 22:00:00 | 2019-12-16 | 2011-10-22 | 69329 | available | 9 | ||||||
| 4 | 0 | 0 | 22:00:00 | 2019-12-16 | 2012-01-28 | 69338 | available | 21 | ||||||
| 5 | 0 | 1 | 19:00:00 | 2019-12-16 | 2008-08-31 | 69147 | available | 1 | ||||||
| 6 | 0 | 1 | 20:30:00 | 2019-12-16 | 2015-08-29 | 267422 | available | 2 | ||||||
| 7 | 0 | 1 | 20:45:00 | 2019-12-16 | 2016-10-29 | 267058 | available | 10 | ||||||
| 8 | 0 | 1 | 20:45:00 | 2019-12-16 | 2019-04-27 | 16289 | available | 35 | ||||||
| 9 | 0 | 1 | 21:00:00 | 2019-12-16 | 2013-11-01 | 70283 | available | 12 | ||||||
| 10 | 0 | 1 | 21:30:00 | 2019-12-16 | 2012-09-02 | 70286 | available | 3 | ||||||
| 11 | 0 | 2 | 16:15:00 | 2020-04-21 | 2019-03-30 | 16231 | available | 29 | ||||||
| 12 | 0 | 2 | 20:00:00 | 2019-12-16 | 2009-03-07 | 69216 | available | 26 | ||||||
| 13 | 0 | 2 | 20:00:00 | 2019-12-16 | 2009-04-11 | 69222 | available | 30 | ||||||
| 14 | 0 | 2 | 20:00:00 | 2019-12-16 | 2011-04-23 | 69271 | available | 33 | ||||||
| 15 | 0 | 2 | 20:45:00 | 2019-12-16 | 2019-04-06 | 16248 | available | 31 | ||||||
| 16 | 0 | 3 | 19:00:00 | 2019-12-16 | 2010-03-14 | 69224 | available | 26 | ||||||
| 17 | 0 | 3 | 20:00:00 | 2019-12-16 | 2007-11-24 | 69184 | available | 13 | ||||||
| 18 | 0 | 3 | 20:00:00 | 2019-12-16 | 2014-10-18 | 265896 | available | 8 | ||||||
| 19 | 0 | 3 | 22:00:00 | 2019-12-16 | 2005-10-22 | 68318 | available | 8 | ||||||
| 20 | 0 | 3 | 22:00:00 | 2019-12-16 | 2011-02-05 | 69276 | available | 22 | ||||||
| 21 | 0 | 4 | 21:00:00 | 2019-12-16 | 2011-11-29 | 69332 | available | 17 | ||||||
| 22 | 0 | 4 | 21:00:00 | 2019-12-16 | 2012-04-10 | 69343 | available | 33 | ||||||
| 23 | 0 | 5 | 16:15:00 | 2019-12-16 | 2017-01-14 | 267395 | available | 18 | ||||||
| 24 | 0 | 5 | 20:00:00 | 2019-12-16 | 2009-01-17 | 69183 | available | 19 | ||||||
| 25 | 0 | 5 | 20:45:00 | 2019-12-16 | 2017-03-04 | 266299 | available | 26 | ||||||
| 26 | 0 | 5 | 21:00:00 | 2019-12-16 | 2010-12-12 | 69302 | available | 15 | ||||||
| 27 | 0 | 5 | 22:00:00 | 2019-12-16 | 2008-10-25 | 69232 | available | 8 | ||||||
| 28 | 0 | 6 | 16:00:00 | 2019-12-16 | 2016-03-12 | 266498 | available | 29 | ||||||
| 29 | 0 | 6 | 19:00:00 | 2019-12-16 | 2008-05-04 | 69141 | available | 35 | ||||||
| 30 | 0 | 6 | 19:00:00 | 2019-12-16 | 2009-03-22 | 69142 | available | 28 | ||||||
| 31 | 0 | 7 | 17:00:00 | 2019-12-16 | 2014-03-16 | 266074 | available | 28 | ||||||
| 32 | 1 | 0 | 19:00:00 | 2019-12-16 | 2014-08-31 | 266406 | available | 2 | ||||||
| 33 | 1 | 0 | 20:00:00 | 2019-12-16 | 2009-04-04 | 69273 | available | 29 | ||||||
| 34 | 1 | 0 | 20:00:00 | 2019-12-16 | 2011-10-25 | 69318 | available | 10 | ||||||
| 35 | 1 | 0 | 20:00:00 | 2019-12-16 | 2014-11-01 | 267301 | available | 10 | ||||||
| 36 | 1 | 0 | 20:15:00 | 2019-12-16 | 2016-08-28 | 266892 | available | 2 | ||||||
| 37 | 1 | 0 | 20:45:00 | 2019-12-16 | 2019-03-02 | 16196 | available | 26 | ||||||
| 38 | 1 | 0 | 21:00:00 | 2019-12-16 | 2014-11-30 | 266560 | available | 13 | ||||||
| 39 | 1 | 0 | 21:00:00 | 2019-12-16 | 2015-04-05 | 266929 | available | 29 | ||||||
| 40 | 1 | 1 | 16:15:00 | 2019-12-16 | 2016-12-03 | 267076 | available | 14 | ||||||
| 41 | 1 | 1 | 19:00:00 | 2019-12-16 | 2007-05-13 | 69162 | available | 34 | ||||||
| 42 | 1 | 1 | 20:30:00 | 2019-12-16 | 2015-12-05 | 267274 | available | 14 | ||||||
| 43 | 1 | 1 | 20:45:00 | 2019-12-16 | 2018-11-24 | 16073 | available | 13 | ||||||
| 44 | 1 | 1 | 22:00:00 | 2020-04-09 | 2011-04-16 | 69245 | available | 32 | ||||||
| 45 | 1 | 2 | 16:00:00 | 2019-12-16 | 2015-09-26 | 267611 | available | 6 | ||||||
| 46 | 1 | 2 | 18:00:00 | 2019-12-16 | 2013-10-26 | 70293 | available | 10 | ||||||
| 47 | 1 | 2 | 19:00:00 | 2019-12-16 | 2006-01-15 | 68342 | available | 19 | ||||||
| 48 | 1 | 2 | 20:00:00 | 2019-12-16 | 2010-02-06 | 69240 | available | 21 | ||||||
| 49 | 0 | 0 | 16:00:00 | 2019-12-16 | 2016-01-02 | 266670 | available | 18 | ||||||
| 50 | 0 | 0 | 20:00:00 | 2019-12-16 | 2008-04-19 | 68359 | available | 33 | ||||||
| 51 | 0 | 0 | 20:00:00 | 2019-12-16 | 2014-01-11 | 265830 | available | 19 | ||||||
| 52 | 0 | 0 | 22:00:00 | 2019-12-16 | 2009-10-17 | 69252 | available | 7 | ||||||
| 53 | 0 | 1 | 16:15:00 | 2019-12-16 | 2018-03-04 | 9837 | available | 27 | ||||||
| 54 | 0 | 1 | 19:00:00 | 2019-12-16 | 2007-04-15 | 69159 | available | 30 | ||||||
| 55 | 0 | 1 | 19:00:00 | 2019-12-16 | 2007-04-29 | 69156 | available | 32 | ||||||
| 56 | 0 | 1 | 20:00:00 | 2019-12-16 | 2007-04-07 | 69179 | available | 29 | ||||||
| 57 | 0 | 1 | 21:00:00 | 2019-12-16 | 2008-01-20 | 69173 | available | 20 | ||||||
| 58 | 0 | 1 | 21:00:00 | 2019-12-16 | 2015-01-04 | 266240 | available | 17 | ||||||
| 59 | 0 | 2 | 16:15:00 | 2019-12-16 | 2018-03-18 | 9855 | available | 29 | ||||||
| 60 | 0 | 2 | 18:30:00 | 2019-12-16 | 2018-12-02 | 16079 | available | 14 | ||||||
| 61 | 0 | 2 | 18:30:00 | 2019-12-16 | 2018-12-22 | 16109 | available | 17 | ||||||
| 62 | 0 | 2 | 19:00:00 | 2019-12-16 | 2005-05-01 | 68316 | available | 34 | ||||||
| 63 | 0 | 2 | 20:15:00 | 2020-02-26 | 2017-08-20 | 9575 | available | 1 | ||||||
| 64 | 0 | 2 | 20:45:00 | 2019-12-16 | 2017-04-08 | 267590 | available | 31 | ||||||
| 65 | 0 | 2 | 20:45:00 | 2019-12-16 | 2017-10-21 | 9650 | available | 9 | ||||||
| 66 | 0 | 2 | 21:00:00 | 2019-12-16 | 2005-12-20 | 68323 | available | 17 | ||||||
| 67 | 0 | 2 | 21:00:00 | 2019-12-16 | 2006-10-22 | 68330 | available | 7 | ||||||
| 68 | 0 | 3 | 16:15:00 | 2019-12-16 | 2017-02-04 | 266874 | available | 21 | ||||||
| 69 | 0 | 3 | 19:30:00 | 2019-12-16 | 2017-04-05 | 266280 | available | 30 | ||||||
| 70 | 0 | 3 | 20:00:00 | 2019-12-16 | 2011-10-15 | 69293 | available | 8 | ||||||
| 71 | 0 | 3 | 21:00:00 | 2019-12-16 | 2007-02-25 | 68333 | available | 24 | ||||||
| 72 | 0 | 4 | 16:00:00 | 2019-12-16 | 2015-11-28 | 266885 | available | 13 | ||||||
| 73 | 0 | 4 | 16:00:00 | 2019-12-16 | 2016-01-09 | 266620 | available | 19 | ||||||
| 74 | 0 | 4 | 19:00:00 | 2019-12-16 | 2013-01-06 | 266433 | available | 18 | ||||||
| 75 | 0 | 4 | 20:00:00 | 2019-12-16 | 2004-12-04 | 68314 | available | 14 | ||||||
| 76 | 0 | 4 | 22:00:00 | 2019-12-16 | 2008-12-06 | 69149 | available | 14 | ||||||
| 77 | 0 | 5 | 16:00:00 | 2019-12-16 | 2014-12-20 | 266846 | available | 16 | ||||||
| 78 | 0 | 5 | 17:00:00 | 2019-12-16 | 2015-02-15 | 266741 | available | 23 | ||||||
| 79 | 0 | 5 | 17:00:00 | 2019-12-16 | 2016-05-08 | 265958 | available | 37 | ||||||
| 80 | 0 | 5 | 20:00:00 | 2019-12-16 | 2011-10-29 | 69314 | available | 11 | ||||||
| 81 | 0 | 5 | 21:00:00 | 2019-12-16 | 2011-08-29 | 69268 | available | 2 | ||||||
| 82 | 0 | 5 | 22:00:00 | 2019-12-16 | 2010-10-30 | 69289 | available | 9 | ||||||
| 83 | 0 | 7 | 19:00:00 | 2019-12-16 | 2013-08-18 | 70277 | available | 1 | ||||||
| 84 | 1 | 0 | 16:00:00 | 2019-12-16 | 2015-02-21 | 266148 | available | 24 | ||||||
| 85 | 1 | 0 | 18:30:00 | 2019-12-16 | 2015-08-23 | 266236 | available | 1 | ||||||
| 86 | 1 | 0 | 20:00:00 | 2019-12-16 | 2009-04-18 | 69223 | available | 31 | ||||||
| 87 | 1 | 0 | 20:00:00 | 2019-12-16 | 2010-03-27 | 69298 | available | 29 | ||||||
| 88 | 1 | 0 | 22:00:00 | 2019-12-16 | 2011-03-02 | 69274 | available | 26 | ||||||
| 89 | 1 | 0 | 22:00:00 | 2019-12-16 | 2011-04-02 | 69304 | available | 30 | ||||||
| 90 | 1 | 1 | 19:00:00 | 2019-12-16 | 2008-01-27 | 69181 | available | 21 | ||||||
| 91 | 1 | 1 | 19:00:00 | 2019-12-16 | 2010-10-03 | 69236 | available | 6 | ||||||
| 92 | 1 | 1 | 19:00:00 | 2019-12-16 | 2013-02-03 | 70282 | available | 22 | ||||||
| 93 | 1 | 1 | 20:00:00 | 2019-12-16 | 2011-05-11 | 69272 | available | 36 | ||||||
| 94 | 1 | 1 | 20:45:00 | 2019-12-16 | 2017-01-08 | 266477 | available | 17 | ||||||
| 95 | 1 | 1 | 22:00:00 | 2019-12-16 | 2008-02-09 | 69146 | available | 23 | ||||||
| 96 | 1 | 1 | 22:00:00 | 2019-12-16 | 2016-09-21 | 267220 | available | 5 | ||||||
| 97 | 1 | 2 | 20:00:00 | 2019-12-16 | 2004-12-21 | 68315 | available | 17 | ||||||
| 98 | 1 | 2 | 20:00:00 | 2019-12-16 | 2011-04-30 | 69246 | available | 34 | ||||||
| 99 | 1 | 3 | 18:00:00 | 2019-12-16 | 2012-11-03 | 70308 | available | 10 | ||||||
| 100 | 1 | 3 | 18:00:00 | 2019-12-16 | 2014-10-25 | 267085 | available | 9 |
Rows: 1-100 | Columns: 14
We can also do this for other file types. For example, csv:
[44]:
data = vp.read_csv(path = path + "*.csv",
table_name = "cities_all",
schema = "complex_vmap_test",
ingest_local = False,
insert = True)
data
[44]:
| Abc nameVarchar(38) | Abc Varchar(90) |
| 1 | Abidjan | |
| 2 | Abidjan | |
| 3 | Abu Dhabi | |
| 4 | Abu Dhabi | |
| 5 | Abuja | |
| 6 | Abuja | |
| 7 | Accra | |
| 8 | Accra | |
| 9 | Addis Ababa | |
| 10 | Addis Ababa | |
| 11 | Algiers | |
| 12 | Algiers | |
| 13 | Amman | |
| 14 | Amman | |
| 15 | Amsterdam | |
| 16 | Amsterdam | |
| 17 | Andorra | |
| 18 | Andorra | |
| 19 | Ankara | |
| 20 | Ankara | |
| 21 | Antananarivo | |
| 22 | Antananarivo | |
| 23 | Apia | |
| 24 | Apia | |
| 25 | Ashgabat | |
| 26 | Ashgabat | |
| 27 | Asmara | |
| 28 | Asmara | |
| 29 | Astana | |
| 30 | Astana | |
| 31 | Asuncion | |
| 32 | Asuncion | |
| 33 | Athens | |
| 34 | Athens | |
| 35 | Baghdad | |
| 36 | Baghdad | |
| 37 | Baku | |
| 38 | Baku | |
| 39 | Bamako | |
| 40 | Bamako | |
| 41 | Bandar Seri Begawan | |
| 42 | Bandar Seri Begawan | |
| 43 | Bangkok | |
| 44 | Bangkok | |
| 45 | Bangui | |
| 46 | Bangui | |
| 47 | Banjul | |
| 48 | Banjul | |
| 49 | Basseterre | |
| 50 | Basseterre | |
| 51 | Beijing | |
| 52 | Beijing | |
| 53 | Beirut | |
| 54 | Beirut | |
| 55 | Belgrade | |
| 56 | Belgrade | |
| 57 | Belmopan | |
| 58 | Belmopan | |
| 59 | Berlin | |
| 60 | Berlin | |
| 61 | Bern | |
| 62 | Bern | |
| 63 | Bishkek | |
| 64 | Bishkek | |
| 65 | Bissau | |
| 66 | Bissau | |
| 67 | Bloemfontein | |
| 68 | Bloemfontein | |
| 69 | Bogota | |
| 70 | Bogota | |
| 71 | Brasilia | |
| 72 | Brasilia | |
| 73 | Bratislava | |
| 74 | Bratislava | |
| 75 | Brazzaville | |
| 76 | Brazzaville | |
| 77 | Bridgetown | |
| 78 | Bridgetown | |
| 79 | Brussels | |
| 80 | Brussels | |
| 81 | Bucharest | |
| 82 | Bucharest | |
| 83 | Budapest | |
| 84 | Budapest | |
| 85 | Buenos Aires | |
| 86 | Buenos Aires | |
| 87 | Bujumbura | |
| 88 | Bujumbura | |
| 89 | Cairo | |
| 90 | Cairo | |
| 91 | Canberra | |
| 92 | Canberra | |
| 93 | Cape Town | |
| 94 | Cape Town | |
| 95 | Caracas | |
| 96 | Caracas | |
| 97 | Castries | |
| 98 | Castries | |
| 99 | Chisinau | |
| 100 | Chisinau |
Rows: 1-100 | Columns: 2
Because we had copies of the same file, we can see that there are two records of each line. The ease of “*” allows us to ingest all the files in a particular folder.
Materialize#
When we do not materialize a table, it automatically becomes a flextable:
[3]:
data = vp.read_json(path = path + "laliga/*.json",
table_name = "laliga_verticapy_test_json",
schema = "complex_vmap_test",
ingest_local = False,
materialize = False,)
data
[3]:
| 123 referee.country.idInteger | Abc referee.country.nameVarchar(20) | 123 stadium.country.idInteger | 123 referee.idInteger | 123 stadium.idInteger | Abc stadium.nameVarchar(64) | Abc stadium.country.nameVarchar(26) | Abc referee.nameVarchar(46) | Abc Vmap(384) | Abc Vmap(378) | 123 metadata.xy_fidelity_versionInteger | 📅 kick_offTime | Abc home_team.home_team_genderVarchar(20) | 123 home_team.country.idInteger | Abc competition.competition_nameVarchar(20) | Abc away_team.away_team_nameVarchar(38) | Abc away_team.away_team_genderVarchar(20) | Abc season.season_nameVarchar(20) | 📅 metadata.data_versionDate | 📅 match_dateDate | Abc home_team.home_team_nameVarchar(40) | 123 home_team.home_team_idInteger | Abc home_team.home_team_groupVarchar(20) | 123 home_scoreInteger | Abc competition_stage.nameVarchar(28) | 123 competition.competition_idInteger | Abc away_team.country.nameVarchar(20) | 123 season.season_idInteger | 123 match_weekInteger | Abc match_statusVarchar(20) | 📅 last_updatedTimestamp | Abc home_team.country.nameVarchar(20) | 123 competition_stage.idInteger | 123 away_team.country.idInteger | Abc away_team.away_team_groupVarchar(20) | 123 away_scoreInteger | 123 metadata.shot_fidelity_versionInteger | 123 match_idInteger | Abc competition.country_nameVarchar(20) | 123 away_team.away_team_idInteger |
| 1 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Getafe | male | 2004/2005 | 1.1.0 | 2005-04-17 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 37 | 32 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68352 | Spain | 216 | ||
| 2 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2004/2005 | 1.1.0 | 2004-10-16 | Espanyol | 214 | [null] | 0 | Regular Season | 11 | Spain | 37 | 7 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68353 | Spain | 217 | ||
| 3 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Albacete | male | 2004/2005 | 1.1.0 | 2005-05-01 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 37 | 34 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68316 | Spain | 608 | ||
| 4 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Levante | male | 2004/2005 | 1.1.0 | 2004-12-21 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 37 | 17 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68315 | Spain | 221 | ||
| 5 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Málaga | male | 2004/2005 | 1.1.0 | 2004-12-04 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | 37 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68314 | Spain | 223 | ||
| 6 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Osasuna | male | 2004/2005 | 1.1.0 | 2004-10-24 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 37 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68313 | Spain | 422 | ||
| 7 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2004/2005 | 1.1.0 | 2004-12-11 | Albacete | 608 | [null] | 1 | Regular Season | 11 | Spain | 37 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69153 | Spain | 217 | ||
| 8 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2005/2006 | 1.1.0 | 2005-11-27 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | 38 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68354 | Spain | 1217 | ||
| 9 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2006-02-25 | Real Zaragoza | 395 | [null] | 0 | Regular Season | 11 | Spain | 38 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68351 | Spain | 217 | ||
| 10 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Atlético Madrid | male | 2005/2006 | 1.1.0 | 2006-02-05 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | 38 | 22 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68350 | Spain | 212 | ||
| 11 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2005/2006 | 1.1.0 | 2006-01-15 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 38 | 19 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68342 | Spain | 215 | ||
| 12 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Sevilla | male | 2005/2006 | 1.1.0 | 2005-12-11 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 38 | 15 | available | 2020-02-27T12:19:39.458017 | Spain | 1 | 214 | [null] | 1 | 2 | 68321 | Spain | 213 | ||
| 13 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2006-01-07 | Espanyol | 214 | [null] | 1 | Regular Season | 11 | Spain | 38 | 18 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68348 | Spain | 217 | ||
| 14 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-11-06 | Getafe | 216 | [null] | 1 | Regular Season | 11 | Spain | 38 | 10 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68339 | Spain | 217 | ||
| 15 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-11-19 | Real Madrid | 220 | [null] | 0 | Regular Season | 11 | Spain | 38 | 12 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68319 | Spain | 217 | ||
| 16 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Osasuna | male | 2005/2006 | 1.1.0 | 2005-10-22 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 38 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68318 | Spain | 422 | ||
| 17 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2006-01-29 | Mallorca | 1043 | [null] | 0 | Regular Season | 11 | Spain | 38 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68325 | Spain | 217 | ||
| 18 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-12-17 | Cádiz | 552 | [null] | 1 | Regular Season | 11 | Spain | 38 | 16 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68322 | Spain | 217 | ||
| 19 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Real Zaragoza | male | 2005/2006 | 1.1.0 | 2005-10-01 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 38 | 6 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68317 | Spain | 395 | ||
| 20 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Betis | male | 2005/2006 | 1.1.0 | 2006-02-18 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | 38 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69172 | Spain | 218 | ||
| 21 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:30:00.000 | male | 214 | La Liga | Málaga | male | 2005/2006 | 1.1.0 | 2005-10-26 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 38 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69164 | Spain | 223 | ||
| 22 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Deportivo Alavés | male | 2005/2006 | 1.1.0 | 2006-01-22 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 38 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68324 | Spain | 206 | ||
| 23 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Celta Vigo | male | 2005/2006 | 1.1.0 | 2005-12-20 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 38 | 17 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68323 | Spain | 209 | ||
| 24 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-12-04 | Villarreal | 222 | [null] | 0 | Regular Season | 11 | Spain | 38 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68320 | Spain | 217 | ||
| 25 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Recreativo Huelva | male | 2007/2008 | 1.1.0 | 2007-11-24 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 40 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69184 | Spain | 1220 | ||
| 26 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Zaragoza | male | 2007/2008 | 1.1.0 | 2007-09-26 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | 40 | 5 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69143 | Spain | 395 | ||
| 27 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-05-17 | Real Murcia | 1230 | [null] | 3 | Regular Season | 11 | Spain | 40 | 38 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 5 | 2 | 69186 | Spain | 217 | ||
| 28 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-02-16 | Real Zaragoza | 395 | [null] | 1 | Regular Season | 11 | Spain | 40 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69182 | Spain | 217 | ||
| 29 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Osasuna | male | 2007/2008 | 1.1.0 | 2008-02-03 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | 40 | 22 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69187 | Spain | 422 | ||
| 30 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-01-27 | Athletic Bilbao | 215 | [null] | 1 | Regular Season | 11 | Spain | 40 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69181 | Spain | 217 | ||
| 31 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-11-10 | Getafe | 216 | [null] | 2 | Regular Season | 11 | Spain | 40 | 12 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69178 | Spain | 217 | ||
| 32 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-08-26 | Racing Santander | 1217 | [null] | 0 | Regular Season | 11 | Spain | 40 | 1 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69180 | Spain | 217 | ||
| 33 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2007/2008 | 1.1.0 | 2008-01-20 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | 40 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69173 | Spain | 1217 | ||
| 34 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Sevilla | male | 2007/2008 | 1.1.0 | 2007-09-22 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 40 | 4 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69148 | Spain | 213 | ||
| 35 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Valencia | male | 2007/2008 | 1.1.0 | 2008-05-04 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | 40 | 35 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69141 | Spain | 207 | ||
| 36 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-12-15 | Valencia | 207 | [null] | 0 | Regular Season | 11 | Spain | 40 | 16 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69145 | Spain | 217 | ||
| 37 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-05-07 | Real Madrid | 220 | [null] | 4 | Regular Season | 11 | Spain | 40 | 36 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68361 | Spain | 217 | ||
| 38 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Levante | male | 2007/2008 | 1.1.0 | 2008-02-24 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | 40 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68360 | Spain | 221 | ||
| 39 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Deportivo La Coruna | male | 2007/2008 | 1.1.0 | 2007-12-09 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 40 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69170 | Spain | 219 | ||
| 40 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2007/2008 | 1.1.0 | 2007-09-02 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 40 | 2 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69169 | Spain | 215 | ||
| 41 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Real Betis | male | 2007/2008 | 1.1.0 | 2007-11-04 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 40 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69166 | Spain | 218 | ||
| 42 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Almería | male | 2007/2008 | 1.1.0 | 2007-10-28 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 40 | 9 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69158 | Spain | 403 | ||
| 43 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-09-29 | Levante | 221 | [null] | 1 | Regular Season | 11 | Spain | 40 | 6 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 4 | 2 | 69151 | Spain | 217 | ||
| 44 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-02-09 | Sevilla | 213 | [null] | 1 | Regular Season | 11 | Spain | 40 | 23 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69146 | Spain | 217 | ||
| 45 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 17:00:00.000 | male | 214 | La Liga | Atlético Madrid | male | 2007/2008 | 1.1.0 | 2007-10-07 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 40 | 7 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69144 | Spain | 212 | ||
| 46 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Mallorca | male | 2007/2008 | 1.1.0 | 2008-05-11 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 40 | 37 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68366 | Spain | 1043 | ||
| 47 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Espanyol | male | 2007/2008 | 1.1.0 | 2008-04-19 | Barcelona | 217 | [null] | 0 | Regular Season | 11 | Spain | 40 | 33 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68359 | Spain | 214 | ||
| 48 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-04-12 | Recreativo Huelva | 1220 | [null] | 2 | Regular Season | 11 | Spain | 40 | 32 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68358 | Spain | 217 | ||
| 49 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-03-01 | Atlético Madrid | 212 | [null] | 4 | Regular Season | 11 | Spain | 40 | 26 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68365 | Spain | 217 | ||
| 50 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-12-01 | Espanyol | 214 | [null] | 1 | Regular Season | 11 | Spain | 40 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68356 | Spain | 217 | ||
| 51 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-11-01 | Real Valladolid | 901 | [null] | 1 | Regular Season | 11 | Spain | 40 | 10 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68363 | Spain | 217 | ||
| 52 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-10-20 | Villarreal | 222 | [null] | 3 | Regular Season | 11 | Spain | 40 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68364 | Spain | 217 | ||
| 53 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-11-16 | Recreativo Huelva | 1220 | [null] | 0 | Regular Season | 11 | Spain | 41 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69285 | Spain | 217 | ||
| 54 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Valladolid | male | 2008/2009 | 1.1.0 | 2008-11-08 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | 41 | 10 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69279 | Spain | 901 | ||
| 55 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-04-25 | Valencia | 207 | [null] | 2 | Regular Season | 11 | Spain | 41 | 33 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69251 | Spain | 217 | ||
| 56 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-05-02 | Real Madrid | 220 | [null] | 2 | Regular Season | 11 | Spain | 41 | 34 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 6 | 2 | 69249 | Spain | 217 | ||
| 57 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Real Betis | male | 2008/2009 | 1.1.0 | 2008-09-24 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 41 | 4 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69207 | Spain | 218 | ||
| 58 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2008/2009 | 1.1.0 | 2008-09-13 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | 41 | 2 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69215 | Spain | 1217 | ||
| 59 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-02-14 | Real Betis | 218 | [null] | 2 | Regular Season | 11 | Spain | 41 | 23 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69195 | Spain | 217 | ||
| 60 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Numancia | male | 2008/2009 | 1.1.0 | 2009-01-24 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | 41 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69189 | Spain | 444 | ||
| 61 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:03:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-03-15 | Almería | 403 | [null] | 0 | Regular Season | 11 | Spain | 41 | 27 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69177 | Spain | 217 | ||
| 62 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-03-01 | Atlético Madrid | 212 | [null] | 4 | Regular Season | 11 | Spain | 41 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69185 | Spain | 217 | ||
| 63 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Deportivo La Coruna | male | 2008/2009 | 1.1.0 | 2009-01-17 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | 41 | 19 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69183 | Spain | 219 | ||
| 64 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-11-29 | Sevilla | 213 | [null] | 0 | Regular Season | 11 | Spain | 41 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69171 | Spain | 217 | ||
| 65 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Valencia | male | 2008/2009 | 1.1.0 | 2008-12-06 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | 41 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69149 | Spain | 207 | ||
| 66 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-08-31 | Numancia | 444 | [null] | 1 | Regular Season | 11 | Spain | 41 | 1 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69147 | Spain | 217 | ||
| 67 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Málaga | male | 2008/2009 | 1.1.0 | 2009-03-22 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | 41 | 28 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69142 | Spain | 223 | ||
| 68 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Espanyol | male | 2008/2009 | 1.1.0 | 2009-02-21 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | 41 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69139 | Spain | 214 | ||
| 69 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-09-21 | Sporting Gijón | 1041 | [null] | 1 | Regular Season | 11 | Spain | 41 | 3 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 6 | 2 | 69138 | Spain | 217 | ||
| 70 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-12-21 | Villarreal | 222 | [null] | 1 | Regular Season | 11 | Spain | 41 | 16 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69228 | Spain | 217 | ||
| 71 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:03:00.000 | male | 214 | La Liga | Villarreal | male | 2008/2009 | 1.1.0 | 2009-05-10 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 41 | 35 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69217 | Spain | 222 | ||
| 72 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-04-18 | Getafe | 216 | [null] | 0 | Regular Season | 11 | Spain | 41 | 31 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69223 | Spain | 217 | ||
| 73 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Recreativo Huelva | male | 2008/2009 | 1.1.0 | 2009-04-11 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 41 | 30 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69222 | Spain | 1220 | ||
| 74 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-04-04 | Real Valladolid | 901 | [null] | 0 | Regular Season | 11 | Spain | 41 | 29 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69273 | Spain | 217 | ||
| 75 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2008/2009 | 1.1.0 | 2009-03-07 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 41 | 26 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69216 | Spain | 215 | ||
| 76 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Sporting Gijón | male | 2008/2009 | 1.1.0 | 2009-02-08 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 41 | 22 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69231 | Spain | 1041 | ||
| 77 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 17:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-02-01 | Racing Santander | 1217 | [null] | 1 | Regular Season | 11 | Spain | 41 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69209 | Spain | 217 | ||
| 78 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-01-11 | Osasuna | 422 | [null] | 2 | Regular Season | 11 | Spain | 41 | 18 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69230 | Spain | 217 | ||
| 79 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Madrid | male | 2008/2009 | 1.1.0 | 2008-12-13 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 41 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69225 | Spain | 220 | ||
| 80 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-11-01 | Málaga | 223 | [null] | 1 | Regular Season | 11 | Spain | 41 | 9 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 4 | 2 | 69235 | Spain | 217 | ||
| 81 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Almería | male | 2008/2009 | 1.1.0 | 2008-10-25 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | 41 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69232 | Spain | 403 | ||
| 82 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Atlético Madrid | male | 2008/2009 | 1.1.0 | 2008-10-04 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | 41 | 6 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69212 | Spain | 212 | ||
| 83 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-09-27 | Espanyol | 214 | [null] | 1 | Regular Season | 11 | Spain | 41 | 5 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69211 | Spain | 217 | ||
| 84 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-04-16 | Real Madrid | 220 | [null] | 1 | Regular Season | 11 | Spain | 22 | 32 | available | 2020-04-09T13:13:49.345111 | Spain | 1 | 214 | [null] | 1 | 2 | 69245 | Spain | 217 | ||
| 85 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Getafe | male | 2010/2011 | 1.1.0 | 2011-03-19 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 22 | 29 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69303 | Spain | 216 | ||
| 86 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Real Sociedad | male | 2010/2011 | 1.1.0 | 2010-12-12 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | 22 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69302 | Spain | 210 | ||
| 87 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2010-11-20 | Almería | 403 | [null] | 0 | Regular Season | 11 | Spain | 22 | 12 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 8 | 2 | 69306 | Spain | 217 | ||
| 88 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Villarreal | male | 2010/2011 | 1.1.0 | 2010-11-13 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 22 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69308 | Spain | 222 | ||
| 89 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Real Madrid | male | 2010/2011 | 1.1.0 | 2010-11-29 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | 22 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69299 | Spain | 220 | ||
| 90 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Real Zaragoza | male | 2010/2011 | 1.1.0 | 2011-03-05 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | 22 | 27 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69300 | Spain | 395 | ||
| 91 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2010/2011 | 1.1.0 | 2011-01-22 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | 22 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69295 | Spain | 1217 | ||
| 92 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-01-29 | Hércules | 1218 | [null] | 0 | Regular Season | 11 | Spain | 22 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69296 | Spain | 217 | ||
| 93 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-03-13 | Sevilla | 213 | [null] | 1 | Regular Season | 11 | Spain | 22 | 28 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69291 | Spain | 217 | ||
| 94 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Sevilla | male | 2010/2011 | 1.1.0 | 2010-10-30 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | 22 | 9 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69289 | Spain | 213 | ||
| 95 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2010-08-29 | Racing Santander | 1217 | [null] | 0 | Regular Season | 11 | Spain | 22 | 1 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69286 | Spain | 217 | ||
| 96 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 18:00:00.000 | male | 214 | La Liga | Hércules | male | 2010/2011 | 1.1.0 | 2010-09-11 | Barcelona | 217 | [null] | 0 | Regular Season | 11 | Spain | 22 | 2 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69287 | Spain | 1218 | ||
| 97 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-03-02 | Valencia | 207 | [null] | 0 | Regular Season | 11 | Spain | 22 | 26 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69274 | Spain | 217 | ||
| 98 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-02-26 | Mallorca | 1043 | [null] | 0 | Regular Season | 11 | Spain | 22 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69283 | Spain | 217 | ||
| 99 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2010/2011 | 1.1.0 | 2011-02-20 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | 22 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69282 | Spain | 215 | ||
| 100 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Málaga | male | 2010/2011 | 1.1.0 | 2011-01-16 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | 22 | 19 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69278 | Spain | 223 |
Rows: 1-100 | Columns: 40
Some of the columns are VMAPs:
[11]:
managers = ["away_team.managers", "home_team.managers"]
for m in managers:
print(data[m].isvmap())
True
True
We can easily flatten the VMaps virtual columns by using the vDataFrame.flat_vmap method:
[5]:
data.flat_vmap(managers).drop(managers)
[5]:
| Abc referee.country.idLong varchar(130000) | Abc referee.country.nameLong varchar(130000) | Abc stadium.country.idLong varchar(130000) | Abc referee.idLong varchar(130000) | Abc stadium.idLong varchar(130000) | Abc stadium.nameLong varchar(130000) | Abc stadium.country.nameLong varchar(130000) | Abc referee.nameLong varchar(130000) | Abc metadata.xy_fidelity_versionLong varchar(130000) | Abc kick_offLong varchar(130000) | Abc home_team.home_team_genderLong varchar(130000) | Abc home_team.country.idLong varchar(130000) | Abc competition.competition_nameLong varchar(130000) | Abc away_team.away_team_nameLong varchar(130000) | Abc away_team.away_team_genderLong varchar(130000) | Abc season.season_nameLong varchar(130000) | Abc metadata.data_versionLong varchar(130000) | Abc match_dateLong varchar(130000) | Abc home_team.home_team_nameLong varchar(130000) | Abc home_team.home_team_idLong varchar(130000) | Abc home_team.home_team_groupLong varchar(130000) | Abc home_scoreLong varchar(130000) | Abc competition_stage.nameLong varchar(130000) | Abc competition.competition_idLong varchar(130000) | Abc away_team.country.nameLong varchar(130000) | ... | Abc season.season_idLong varchar(130000) | Abc match_weekLong varchar(130000) | Abc match_statusLong varchar(130000) | Abc last_updatedLong varchar(130000) | Abc home_team.country.nameLong varchar(130000) | Abc competition_stage.idLong varchar(130000) | Abc away_team.country.idLong varchar(130000) | Abc away_team.away_team_groupLong varchar(130000) | Abc away_scoreLong varchar(130000) | Abc metadata.shot_fidelity_versionLong varchar(130000) | Abc match_idLong varchar(130000) | Abc competition.country_nameLong varchar(130000) | Abc away_team.away_team_idLong varchar(130000) | Abc Long varchar(130000) | Abc away_team.managers.0.idLong varchar(130000) | Abc Long varchar(130000) | Abc away_team.managers.0.nicknameLong varchar(130000) | Abc away_team.managers.0.dobLong varchar(130000) | Abc away_team.managers.0.country.idLong varchar(130000) | Abc home_team.managers.0.idLong varchar(130000) | Abc Long varchar(130000) | Abc Long varchar(130000) | Abc home_team.managers.0.nicknameLong varchar(130000) | Abc home_team.managers.0.dobLong varchar(130000) | Abc home_team.managers.0.country.idLong varchar(130000) |
| 1 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Getafe | male | 2004/2005 | 1.1.0 | 2005-04-17 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 37 | 32 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68352 | Spain | 216 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 2 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2004/2005 | 1.1.0 | 2004-10-16 | Espanyol | 214 | [null] | 0 | Regular Season | 11 | Spain | ... | 37 | 7 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68353 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 3 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Albacete | male | 2004/2005 | 1.1.0 | 2005-05-01 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 37 | 34 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68316 | Spain | 608 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 4 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Levante | male | 2004/2005 | 1.1.0 | 2004-12-21 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 37 | 17 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68315 | Spain | 221 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 5 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Málaga | male | 2004/2005 | 1.1.0 | 2004-12-04 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | ... | 37 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68314 | Spain | 223 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 6 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Osasuna | male | 2004/2005 | 1.1.0 | 2004-10-24 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 37 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68313 | Spain | 422 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 7 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2004/2005 | 1.1.0 | 2004-12-11 | Albacete | 608 | [null] | 1 | Regular Season | 11 | Spain | ... | 37 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69153 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 8 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2005/2006 | 1.1.0 | 2005-11-27 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | ... | 38 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68354 | Spain | 1217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 9 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2006-02-25 | Real Zaragoza | 395 | [null] | 0 | Regular Season | 11 | Spain | ... | 38 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68351 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 10 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Atlético Madrid | male | 2005/2006 | 1.1.0 | 2006-02-05 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | ... | 38 | 22 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68350 | Spain | 212 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 11 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2005/2006 | 1.1.0 | 2006-01-15 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 38 | 19 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68342 | Spain | 215 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 12 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Sevilla | male | 2005/2006 | 1.1.0 | 2005-12-11 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 38 | 15 | available | 2020-02-27T12:19:39.458017 | Spain | 1 | 214 | [null] | 1 | 2 | 68321 | Spain | 213 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 13 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2006-01-07 | Espanyol | 214 | [null] | 1 | Regular Season | 11 | Spain | ... | 38 | 18 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68348 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 14 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-11-06 | Getafe | 216 | [null] | 1 | Regular Season | 11 | Spain | ... | 38 | 10 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68339 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 15 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-11-19 | Real Madrid | 220 | [null] | 0 | Regular Season | 11 | Spain | ... | 38 | 12 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68319 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 16 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Osasuna | male | 2005/2006 | 1.1.0 | 2005-10-22 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 38 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68318 | Spain | 422 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 17 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2006-01-29 | Mallorca | 1043 | [null] | 0 | Regular Season | 11 | Spain | ... | 38 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68325 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 18 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-12-17 | Cádiz | 552 | [null] | 1 | Regular Season | 11 | Spain | ... | 38 | 16 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68322 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 19 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Real Zaragoza | male | 2005/2006 | 1.1.0 | 2005-10-01 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 38 | 6 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68317 | Spain | 395 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 20 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Betis | male | 2005/2006 | 1.1.0 | 2006-02-18 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | ... | 38 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69172 | Spain | 218 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 21 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:30:00.000 | male | 214 | La Liga | Málaga | male | 2005/2006 | 1.1.0 | 2005-10-26 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 38 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69164 | Spain | 223 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 22 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Deportivo Alavés | male | 2005/2006 | 1.1.0 | 2006-01-22 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 38 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68324 | Spain | 206 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 23 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Celta Vigo | male | 2005/2006 | 1.1.0 | 2005-12-20 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 38 | 17 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68323 | Spain | 209 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 24 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2005/2006 | 1.1.0 | 2005-12-04 | Villarreal | 222 | [null] | 0 | Regular Season | 11 | Spain | ... | 38 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68320 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 25 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Recreativo Huelva | male | 2007/2008 | 1.1.0 | 2007-11-24 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 40 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69184 | Spain | 1220 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 26 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Zaragoza | male | 2007/2008 | 1.1.0 | 2007-09-26 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | ... | 40 | 5 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69143 | Spain | 395 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 27 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-05-17 | Real Murcia | 1230 | [null] | 3 | Regular Season | 11 | Spain | ... | 40 | 38 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 5 | 2 | 69186 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 28 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-02-16 | Real Zaragoza | 395 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69182 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 29 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Osasuna | male | 2007/2008 | 1.1.0 | 2008-02-03 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 22 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69187 | Spain | 422 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 30 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-01-27 | Athletic Bilbao | 215 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69181 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 31 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-11-10 | Getafe | 216 | [null] | 2 | Regular Season | 11 | Spain | ... | 40 | 12 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69178 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 32 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-08-26 | Racing Santander | 1217 | [null] | 0 | Regular Season | 11 | Spain | ... | 40 | 1 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69180 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 33 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2007/2008 | 1.1.0 | 2008-01-20 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69173 | Spain | 1217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 34 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Sevilla | male | 2007/2008 | 1.1.0 | 2007-09-22 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 40 | 4 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69148 | Spain | 213 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 35 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Valencia | male | 2007/2008 | 1.1.0 | 2008-05-04 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | ... | 40 | 35 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69141 | Spain | 207 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 36 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-12-15 | Valencia | 207 | [null] | 0 | Regular Season | 11 | Spain | ... | 40 | 16 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69145 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 37 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-05-07 | Real Madrid | 220 | [null] | 4 | Regular Season | 11 | Spain | ... | 40 | 36 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68361 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 38 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Levante | male | 2007/2008 | 1.1.0 | 2008-02-24 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | ... | 40 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68360 | Spain | 221 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 39 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Deportivo La Coruna | male | 2007/2008 | 1.1.0 | 2007-12-09 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 40 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69170 | Spain | 219 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 40 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2007/2008 | 1.1.0 | 2007-09-02 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 40 | 2 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69169 | Spain | 215 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 41 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Real Betis | male | 2007/2008 | 1.1.0 | 2007-11-04 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 40 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69166 | Spain | 218 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 42 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Almería | male | 2007/2008 | 1.1.0 | 2007-10-28 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 40 | 9 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69158 | Spain | 403 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 43 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-09-29 | Levante | 221 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 6 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 4 | 2 | 69151 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 44 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-02-09 | Sevilla | 213 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 23 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69146 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 45 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 17:00:00.000 | male | 214 | La Liga | Atlético Madrid | male | 2007/2008 | 1.1.0 | 2007-10-07 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 40 | 7 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69144 | Spain | 212 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 46 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Mallorca | male | 2007/2008 | 1.1.0 | 2008-05-11 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 40 | 37 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 68366 | Spain | 1043 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 47 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Espanyol | male | 2007/2008 | 1.1.0 | 2008-04-19 | Barcelona | 217 | [null] | 0 | Regular Season | 11 | Spain | ... | 40 | 33 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 68359 | Spain | 214 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 48 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-04-12 | Recreativo Huelva | 1220 | [null] | 2 | Regular Season | 11 | Spain | ... | 40 | 32 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68358 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 49 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2008-03-01 | Atlético Madrid | 212 | [null] | 4 | Regular Season | 11 | Spain | ... | 40 | 26 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 68365 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 50 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-12-01 | Espanyol | 214 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68356 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 51 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-11-01 | Real Valladolid | 901 | [null] | 1 | Regular Season | 11 | Spain | ... | 40 | 10 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68363 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 52 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2007/2008 | 1.1.0 | 2007-10-20 | Villarreal | 222 | [null] | 3 | Regular Season | 11 | Spain | ... | 40 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 68364 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 53 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-11-16 | Recreativo Huelva | 1220 | [null] | 0 | Regular Season | 11 | Spain | ... | 41 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69285 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 1612 | Lucas Alcaraz | [null] | 214 | ||||
| 54 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Valladolid | male | 2008/2009 | 1.1.0 | 2008-11-08 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | ... | 41 | 10 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69279 | Spain | 901 | 221 | José Luis Mendilibar | [null] | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 55 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-04-25 | Valencia | 207 | [null] | 2 | Regular Season | 11 | Spain | ... | 41 | 33 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69251 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 21 | Unai Emery | [null] | 214 | ||||
| 56 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-05-02 | Real Madrid | 220 | [null] | 2 | Regular Season | 11 | Spain | ... | 41 | 34 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 6 | 2 | 69249 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 3899 | Juande Ramos | [null] | 214 | ||||
| 57 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Real Betis | male | 2008/2009 | 1.1.0 | 2008-09-24 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 41 | 4 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69207 | Spain | 218 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 58 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2008/2009 | 1.1.0 | 2008-09-13 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 2 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69215 | Spain | 1217 | 2 | Juan Muñiz | 1968-11-02 | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 59 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-02-14 | Real Betis | 218 | [null] | 2 | Regular Season | 11 | Spain | ... | 41 | 23 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69195 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 60 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Numancia | male | 2008/2009 | 1.1.0 | 2009-01-24 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | ... | 41 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69189 | Spain | 444 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 61 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:03:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-03-15 | Almería | 403 | [null] | 0 | Regular Season | 11 | Spain | ... | 41 | 27 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69177 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 62 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-03-01 | Atlético Madrid | 212 | [null] | 4 | Regular Season | 11 | Spain | ... | 41 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69185 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 63 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Deportivo La Coruna | male | 2008/2009 | 1.1.0 | 2009-01-17 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | ... | 41 | 19 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69183 | Spain | 219 | 4519 | Miguel Ángel Lotina | [null] | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 64 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-11-29 | Sevilla | 213 | [null] | 0 | Regular Season | 11 | Spain | ... | 41 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69171 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 1621 | Manolo Jiménez | 1964-01-26 | 214 | ||||
| 65 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Valencia | male | 2008/2009 | 1.1.0 | 2008-12-06 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | ... | 41 | 14 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69149 | Spain | 207 | 21 | Unai Emery | [null] | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 66 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-08-31 | Numancia | 444 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 1 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69147 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 67 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Málaga | male | 2008/2009 | 1.1.0 | 2009-03-22 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | ... | 41 | 28 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69142 | Spain | 223 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 68 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Espanyol | male | 2008/2009 | 1.1.0 | 2009-02-21 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69139 | Spain | 214 | 81 | Mauricio Pochettino | [null] | 11 | 36 | Pep Guardiola | [null] | 214 | ||||
| 69 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-09-21 | Sporting Gijón | 1041 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 3 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 6 | 2 | 69138 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 70 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-12-21 | Villarreal | 222 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 16 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69228 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 733 | Manuel Pellegrini | [null] | 45 | ||||
| 71 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:03:00.000 | male | 214 | La Liga | Villarreal | male | 2008/2009 | 1.1.0 | 2009-05-10 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 41 | 35 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69217 | Spain | 222 | 733 | Manuel Pellegrini | [null] | 45 | 36 | Pep Guardiola | [null] | 214 | ||||
| 72 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-04-18 | Getafe | 216 | [null] | 0 | Regular Season | 11 | Spain | ... | 41 | 31 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69223 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 73 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Recreativo Huelva | male | 2008/2009 | 1.1.0 | 2009-04-11 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 41 | 30 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69222 | Spain | 1220 | 1612 | Lucas Alcaraz | [null] | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 74 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-04-04 | Real Valladolid | 901 | [null] | 0 | Regular Season | 11 | Spain | ... | 41 | 29 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69273 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 221 | José Luis Mendilibar | [null] | 214 | ||||
| 75 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2008/2009 | 1.1.0 | 2009-03-07 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 41 | 26 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69216 | Spain | 215 | 497 | Joaquín Caparrós | 1955-10-13 | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 76 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Sporting Gijón | male | 2008/2009 | 1.1.0 | 2009-02-08 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 41 | 22 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69231 | Spain | 1041 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 77 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 17:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-02-01 | Racing Santander | 1217 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69209 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 2 | Juan Muñiz | 1968-11-02 | 214 | ||||
| 78 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2009-01-11 | Osasuna | 422 | [null] | 2 | Regular Season | 11 | Spain | ... | 41 | 18 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69230 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 79 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Real Madrid | male | 2008/2009 | 1.1.0 | 2008-12-13 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 41 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69225 | Spain | 220 | 3899 | Juande Ramos | [null] | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 80 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-11-01 | Málaga | 223 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 9 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 4 | 2 | 69235 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 81 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Almería | male | 2008/2009 | 1.1.0 | 2008-10-25 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | ... | 41 | 8 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69232 | Spain | 403 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 82 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Atlético Madrid | male | 2008/2009 | 1.1.0 | 2008-10-04 | Barcelona | 217 | [null] | 6 | Regular Season | 11 | Spain | ... | 41 | 6 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69212 | Spain | 212 | 3196 | Javier Aguirre | [null] | 147 | 36 | Pep Guardiola | [null] | 214 | ||||
| 83 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2008/2009 | 1.1.0 | 2008-09-27 | Espanyol | 214 | [null] | 1 | Regular Season | 11 | Spain | ... | 41 | 5 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69211 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 84 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-04-16 | Real Madrid | 220 | [null] | 1 | Regular Season | 11 | Spain | ... | 22 | 32 | available | 2020-04-09T13:13:49.345111 | Spain | 1 | 214 | [null] | 1 | 2 | 69245 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 383 | José Mourinho | [null] | 183 | ||||
| 85 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Getafe | male | 2010/2011 | 1.1.0 | 2011-03-19 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 22 | 29 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69303 | Spain | 216 | 505 | Míchel | [null] | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 86 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Real Sociedad | male | 2010/2011 | 1.1.0 | 2010-12-12 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | ... | 22 | 15 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69302 | Spain | 210 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 87 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2010-11-20 | Almería | 403 | [null] | 0 | Regular Season | 11 | Spain | ... | 22 | 12 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 8 | 2 | 69306 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 88 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Villarreal | male | 2010/2011 | 1.1.0 | 2010-11-13 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 22 | 11 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69308 | Spain | 222 | 4201 | Juan Garrido | [null] | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 89 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Real Madrid | male | 2010/2011 | 1.1.0 | 2010-11-29 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | ... | 22 | 13 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69299 | Spain | 220 | 383 | José Mourinho | [null] | 183 | 36 | Pep Guardiola | [null] | 214 | ||||
| 90 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Real Zaragoza | male | 2010/2011 | 1.1.0 | 2011-03-05 | Barcelona | 217 | [null] | 1 | Regular Season | 11 | Spain | ... | 22 | 27 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69300 | Spain | 395 | 3196 | Javier Aguirre | [null] | 147 | 36 | Pep Guardiola | [null] | 214 | ||||
| 91 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Racing Santander | male | 2010/2011 | 1.1.0 | 2011-01-22 | Barcelona | 217 | [null] | 3 | Regular Season | 11 | Spain | ... | 22 | 20 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69295 | Spain | 1217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 92 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-01-29 | Hércules | 1218 | [null] | 0 | Regular Season | 11 | Spain | ... | 22 | 21 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69296 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 93 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-03-13 | Sevilla | 213 | [null] | 1 | Regular Season | 11 | Spain | ... | 22 | 28 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69291 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 94 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Sevilla | male | 2010/2011 | 1.1.0 | 2010-10-30 | Barcelona | 217 | [null] | 5 | Regular Season | 11 | Spain | ... | 22 | 9 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 0 | 2 | 69289 | Spain | 213 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 95 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 19:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2010-08-29 | Racing Santander | 1217 | [null] | 0 | Regular Season | 11 | Spain | ... | 22 | 1 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69286 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 96 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 18:00:00.000 | male | 214 | La Liga | Hércules | male | 2010/2011 | 1.1.0 | 2010-09-11 | Barcelona | 217 | [null] | 0 | Regular Season | 11 | Spain | ... | 22 | 2 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 2 | 2 | 69287 | Spain | 1218 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 97 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 22:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-03-02 | Valencia | 207 | [null] | 0 | Regular Season | 11 | Spain | ... | 22 | 26 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69274 | Spain | 217 | 36 | Pep Guardiola | [null] | 214 | 21 | Unai Emery | [null] | 214 | ||||
| 98 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 20:00:00.000 | male | 214 | La Liga | Barcelona | male | 2010/2011 | 1.1.0 | 2011-02-26 | Mallorca | 1043 | [null] | 0 | Regular Season | 11 | Spain | ... | 22 | 25 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 3 | 2 | 69283 | Spain | 217 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | ||||
| 99 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Athletic Bilbao | male | 2010/2011 | 1.1.0 | 2011-02-20 | Barcelona | 217 | [null] | 2 | Regular Season | 11 | Spain | ... | 22 | 24 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69282 | Spain | 215 | 497 | Joaquín Caparrós | 1955-10-13 | 214 | 36 | Pep Guardiola | [null] | 214 | ||||
| 100 | [null] | [null] | [null] | [null] | [null] | [null] | [null] | [null] | 2 | 21:00:00.000 | male | 214 | La Liga | Málaga | male | 2010/2011 | 1.1.0 | 2011-01-16 | Barcelona | 217 | [null] | 4 | Regular Season | 11 | Spain | ... | 22 | 19 | available | 2019-12-16T23:09:16.168756 | Spain | 1 | 214 | [null] | 1 | 2 | 69278 | Spain | 223 | 733 | Manuel Pellegrini | [null] | 45 | 36 | Pep Guardiola | [null] | 214 |
Rows: 1-100 | Columns: 50
To check for a flex table, we can use the following function:
[46]:
isflextable(table_name = "laliga_verticapy_test_json", schema = "complex_vmap_test")
[46]:
True
We can then manually materialize the flextable using the convenient vDataFrame.to_db method:
[47]:
data.to_db("complex_vmap_test.laliga_to_db")
[47]:
| Abc season.season_nameVarchar(20) | 123 season.season_idInteger | 123 metadata.xy_fidelity_versionInteger | 123 metadata.shot_fidelity_versionInteger | 📅 metadata.data_versionDate | 123 match_weekInteger | Abc match_statusVarchar(20) | 123 match_idInteger | 📅 match_dateDate | 📅 last_updatedTimestamp | 📅 kick_offTime | Abc home_team.home_team_nameVarchar(26) | 123 home_team.home_team_idInteger | Abc home_team.home_team_groupVarchar(20) | Abc home_team.home_team_genderVarchar(20) | Abc home_team.country.nameVarchar(20) | 123 home_team.country.idInteger | 123 home_scoreInteger | Abc competition_stage.nameVarchar(28) | 123 competition_stage.idInteger | Abc competition.country_nameVarchar(20) | Abc competition.competition_nameVarchar(20) | 123 competition.competition_idInteger | Abc away_team.country.nameVarchar(20) | 123 away_team.country.idInteger | Abc away_team.away_team_nameVarchar(34) | 123 away_team.away_team_idInteger | Abc away_team.away_team_groupVarchar(20) | Abc away_team.away_team_genderVarchar(20) | 123 away_scoreInteger |
| 1 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 13 | available | 68354 | 2005-11-27 | 2019-12-16T23:09:16.168756 | 21:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Racing Santander | 1217 | [null] | male | 1 |
| 2 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 25 | available | 68351 | 2006-02-25 | 2019-12-16T23:09:16.168756 | 22:00:00.000 | Real Zaragoza | 395 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
| 3 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 22 | available | 68350 | 2006-02-05 | 2019-12-16T23:09:16.168756 | 19:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Atlético Madrid | 212 | [null] | male | 3 |
| 4 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 19 | available | 68342 | 2006-01-15 | 2019-12-16T23:09:16.168756 | 19:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Athletic Bilbao | 215 | [null] | male | 1 |
| 5 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 15 | available | 68321 | 2005-12-11 | 2020-02-27T12:19:39.458017 | 21:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Sevilla | 213 | [null] | male | 1 |
| 6 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 18 | available | 68348 | 2006-01-07 | 2019-12-16T23:09:16.168756 | 22:00:00.000 | Espanyol | 214 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
| 7 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 10 | available | 68339 | 2005-11-06 | 2019-12-16T23:09:16.168756 | 21:00:00.000 | Getafe | 216 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 8 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 12 | available | 68319 | 2005-11-19 | 2019-12-16T23:09:16.168756 | 20:00:00.000 | Real Madrid | 220 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 9 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 8 | available | 68318 | 2005-10-22 | 2019-12-16T23:09:16.168756 | 22:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Osasuna | 422 | [null] | male | 0 |
| 10 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 21 | available | 68325 | 2006-01-29 | 2019-12-16T23:09:16.168756 | 19:00:00.000 | Mallorca | 1043 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 11 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 16 | available | 68322 | 2005-12-17 | 2019-12-16T23:09:16.168756 | 22:00:00.000 | Cádiz | 552 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 12 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 6 | available | 68317 | 2005-10-01 | 2019-12-16T23:09:16.168756 | 20:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Zaragoza | 395 | [null] | male | 2 |
| 13 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 24 | available | 69172 | 2006-02-18 | 2019-12-16T23:09:16.168756 | 22:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Betis | 218 | [null] | male | 1 |
| 14 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 11 | available | 69164 | 2005-10-26 | 2019-12-16T23:09:16.168756 | 20:30:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Málaga | 223 | [null] | male | 0 |
| 15 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 20 | available | 68324 | 2006-01-22 | 2019-12-16T23:09:16.168756 | 19:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Deportivo Alavés | 206 | [null] | male | 0 |
| 16 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 17 | available | 68323 | 2005-12-20 | 2019-12-16T23:09:16.168756 | 21:00:00.000 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Celta Vigo | 209 | [null] | male | 0 |
| 17 | 2005/2006 | 38 | 2 | 2 | 1.1.0 | 14 | available | 68320 | 2005-12-04 | 2019-12-16T23:09:16.168756 | 19:00:00.000 | Villarreal | 222 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
Rows: 1-17 | Columns: 30
Once we have stored the database, we can easily create a vDataFrame of the relation:
[49]:
data_new = vp.vDataFrame("complex_vmap_test.laliga_to_db")
data_new
[49]:
| Abc season.season_nameVarchar(20) | 123 season.season_idInt | 123 metadata.xy_fidelity_versionInt | 123 metadata.shot_fidelity_versionInt | 📅 metadata.data_versionDate | 123 match_weekInt | Abc match_statusVarchar(20) | 123 match_idInt | 📅 match_dateDate | 📅 last_updatedTimestamp | 📅 kick_offTime | Abc home_team.home_team_nameVarchar(26) | 123 home_team.home_team_idInt | Abc home_team.home_team_groupVarchar(20) | Abc home_team.home_team_genderVarchar(20) | Abc home_team.country.nameVarchar(20) | 123 home_team.country.idInt | 123 home_scoreInt | Abc competition_stage.nameVarchar(28) | 123 competition_stage.idInt | Abc competition.country_nameVarchar(20) | Abc competition.competition_nameVarchar(20) | 123 competition.competition_idInt | Abc away_team.country.nameVarchar(20) | 123 away_team.country.idInt | Abc away_team.away_team_nameVarchar(34) | 123 away_team.away_team_idInt | Abc away_team.away_team_groupVarchar(20) | Abc away_team.away_team_genderVarchar(20) | 123 away_scoreInt |
| 1 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 13 | available | 68354 | 2005-11-27 | 2019-12-16 23:09:16.168756 | 21:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 4 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Racing Santander | 1217 | [null] | male | 1 |
| 2 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 25 | available | 68351 | 2006-02-25 | 2019-12-16 23:09:16.168756 | 22:00:00 | Real Zaragoza | 395 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
| 3 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 22 | available | 68350 | 2006-02-05 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Atlético Madrid | 212 | [null] | male | 3 |
| 4 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 19 | available | 68342 | 2006-01-15 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Athletic Bilbao | 215 | [null] | male | 1 |
| 5 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 15 | available | 68321 | 2005-12-11 | 2020-02-27 12:19:39.458017 | 21:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Sevilla | 213 | [null] | male | 1 |
| 6 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 18 | available | 68348 | 2006-01-07 | 2019-12-16 23:09:16.168756 | 22:00:00 | Espanyol | 214 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
| 7 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 10 | available | 68339 | 2005-11-06 | 2019-12-16 23:09:16.168756 | 21:00:00 | Getafe | 216 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 8 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 12 | available | 68319 | 2005-11-19 | 2019-12-16 23:09:16.168756 | 20:00:00 | Real Madrid | 220 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 9 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 8 | available | 68318 | 2005-10-22 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 3 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Osasuna | 422 | [null] | male | 0 |
| 10 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 21 | available | 68325 | 2006-01-29 | 2019-12-16 23:09:16.168756 | 19:00:00 | Mallorca | 1043 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 11 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 16 | available | 68322 | 2005-12-17 | 2019-12-16 23:09:16.168756 | 22:00:00 | Cádiz | 552 | [null] | male | Spain | 214 | 1 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 3 |
| 12 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 6 | available | 68317 | 2005-10-01 | 2019-12-16 23:09:16.168756 | 20:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Zaragoza | 395 | [null] | male | 2 |
| 13 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 24 | available | 69172 | 2006-02-18 | 2019-12-16 23:09:16.168756 | 22:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 5 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Real Betis | 218 | [null] | male | 1 |
| 14 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 11 | available | 69164 | 2005-10-26 | 2019-12-16 23:09:16.168756 | 20:30:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Málaga | 223 | [null] | male | 0 |
| 15 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 20 | available | 68324 | 2006-01-22 | 2019-12-16 23:09:16.168756 | 19:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Deportivo Alavés | 206 | [null] | male | 0 |
| 16 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 17 | available | 68323 | 2005-12-20 | 2019-12-16 23:09:16.168756 | 21:00:00 | Barcelona | 217 | [null] | male | Spain | 214 | 2 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Celta Vigo | 209 | [null] | male | 0 |
| 17 | 2005/2006 | 38 | 2 | 2 | 2000-01-01 | 14 | available | 68320 | 2005-12-04 | 2019-12-16 23:09:16.168756 | 19:00:00 | Villarreal | 222 | [null] | male | Spain | 214 | 0 | Regular Season | 1 | Spain | La Liga | 11 | Spain | 214 | Barcelona | 217 | [null] | male | 2 |
Rows: 1-17 | Columns: 30
Transformations#
First, we load the dataset.
[55]:
data = vp.read_csv(path = path + "cities.csv",
schema = "complex_vmap_test",
table_name = "cities_transf",
ingest_local = False,)
data
[55]:
| Abc nameVarchar(38) | Abc Varchar(90) |
| 1 | Abidjan | |
| 2 | Abu Dhabi | |
| 3 | Abuja | |
| 4 | Accra | |
| 5 | Addis Ababa | |
| 6 | Algiers | |
| 7 | Amman | |
| 8 | Amsterdam | |
| 9 | Andorra | |
| 10 | Ankara | |
| 11 | Antananarivo | |
| 12 | Apia | |
| 13 | Ashgabat | |
| 14 | Asmara | |
| 15 | Astana | |
| 16 | Asuncion | |
| 17 | Athens | |
| 18 | Baghdad | |
| 19 | Baku | |
| 20 | Bamako | |
| 21 | Bandar Seri Begawan | |
| 22 | Bangkok | |
| 23 | Bangui | |
| 24 | Banjul | |
| 25 | Basseterre | |
| 26 | Beijing | |
| 27 | Beirut | |
| 28 | Belgrade | |
| 29 | Belmopan | |
| 30 | Berlin | |
| 31 | Bern | |
| 32 | Bishkek | |
| 33 | Bissau | |
| 34 | Bloemfontein | |
| 35 | Bogota | |
| 36 | Brasilia | |
| 37 | Bratislava | |
| 38 | Brazzaville | |
| 39 | Bridgetown | |
| 40 | Brussels | |
| 41 | Bucharest | |
| 42 | Budapest | |
| 43 | Buenos Aires | |
| 44 | Bujumbura | |
| 45 | Cairo | |
| 46 | Canberra | |
| 47 | Cape Town | |
| 48 | Caracas | |
| 49 | Castries | |
| 50 | Chisinau | |
| 51 | Colombo | |
| 52 | Conakry | |
| 53 | Cotonou | |
| 54 | Dakar | |
| 55 | Damascus | |
| 56 | Dar es Salaam | |
| 57 | Dhaka | |
| 58 | Dili | |
| 59 | Djibouti | |
| 60 | Doha | |
| 61 | Dublin | |
| 62 | Dushanbe | |
| 63 | Freetown | |
| 64 | Funafuti | |
| 65 | Gaborone | |
| 66 | Georgetown | |
| 67 | Guatemala | |
| 68 | Hanoi | |
| 69 | Harare | |
| 70 | Hargeysa | |
| 71 | Havana | |
| 72 | Helsinki | |
| 73 | Honiara | |
| 74 | Islamabad | |
| 75 | Jakarta | |
| 76 | Jerusalem | |
| 77 | Johannesburg | |
| 78 | Juba | |
| 79 | Kabul | |
| 80 | Kampala | |
| 81 | Kathmandu | |
| 82 | Khartoum | |
| 83 | Kiev | |
| 84 | Kigali | |
| 85 | Kingston | |
| 86 | Kingstown | |
| 87 | Kinshasa | |
| 88 | Kuala Lumpur | |
| 89 | Kuwait | |
| 90 | København | |
| 91 | La Paz | |
| 92 | Libreville | |
| 93 | Lilongwe | |
| 94 | Lima | |
| 95 | Lisbon | |
| 96 | Ljubljana | |
| 97 | Lome | |
| 98 | London | |
| 99 | Luanda | |
| 100 | Lusaka |
Rows: 1-100 | Columns: 2
Once we have data in the form of vDataFrame, we can readily convert it to a JSON file:
[56]:
data.to_json(path = "cities_json.json")
Now we can load the new JSON file and see the contents:
[62]:
data = read_json(path = "cities_json.json",
schema = "complex_vmap_test",
table_name = "cities_transf_test",
ingest_local = False,)
data
[62]:
| Abc Varchar(90) | Abc nameVarchar(38) |
| 1 | London | |
| 2 | Accra | |
| 3 | Ouagadougou | |
| 4 | Monrovia | |
| 5 | Freetown | |
| 6 | Conakry | |
| 7 | Bissau | |
| 8 | Nouakchott | |
| 9 | Banjul | |
| 10 | Dakar | |
| 11 | Apia | |
| 12 | Nukualofa | |
| 13 | Reykjavík | |
| 14 | Praia | |
| 15 | Madrid | |
| 16 | Abidjan | |
| 17 | Brasilia | |
| 18 | Yamoussoukro | |
| 19 | Paramaribo | |
| 20 | Montevideo | |
| 21 | Asuncion | |
| 22 | Georgetown | |
| 23 | Buenos Aires | |
| 24 | Bridgetown | |
| 25 | Dublin | |
| 26 | Rabat | |
| 27 | Castries | |
| 28 | Kingstown | |
| 29 | Roseau | |
| 30 | Port-of-Spain | |
| 31 | Saint George's | |
| 32 | Saint John's | |
| 33 | Basseterre | |
| 34 | Sucre | |
| 35 | Caracas | |
| 36 | La Paz | |
| 37 | Santo Domingo | |
| 38 | Santiago | |
| 39 | Port-au-Prince | |
| 40 | Bogota | |
| 41 | Ottawa | |
| 42 | Kingston | |
| 43 | Washington, D.C. | |
| 44 | Lima | |
| 45 | Nassau | |
| 46 | Quito | |
| 47 | Panama City | |
| 48 | Bamako | |
| 49 | Havana | |
| 50 | San Jose | |
| 51 | Managua | |
| 52 | Tegucigalpa | |
| 53 | Belmopan | |
| 54 | San Salvador | |
| 55 | Lisbon | |
| 56 | Guatemala | |
| 57 | Mexico City | |
| 58 | Lome | |
| 59 | Andorra | |
| 60 | Tunis | |
| 61 | Oslo | |
| 62 | Bangkok | |
| 63 | Kuala Lumpur | |
| 64 | Vientiane | |
| 65 | Singapore | |
| 66 | Phnom Penh | |
| 67 | Hanoi | |
| 68 | Jakarta | |
| 69 | Ulaanbaatar | |
| 70 | Yaounde | |
| 71 | Bandar Seri Begawan | |
| 72 | Beijing | |
| 73 | San Marino | |
| 74 | Vatican City | |
| 75 | Rome | |
| 76 | København | |
| 77 | Manila | |
| 78 | Taipei | |
| 79 | Dili | |
| 80 | Pyongyang | |
| 81 | Seoul | |
| 82 | Tripoli | |
| 83 | Luanda | |
| 84 | Berlin | |
| 85 | Melekeok | |
| 86 | Tokyo | |
| 87 | Prague | |
| 88 | Valletta | |
| 89 | Ljubljana | |
| 90 | Port Moresby | |
| 91 | Canberra | |
| 92 | Ndjamena | |
| 93 | Brazzaville | |
| 94 | Kinshasa | |
| 95 | Zagreb | |
| 96 | Palikir | |
| 97 | Honiara | |
| 98 | Vienna | |
| 99 | Port Vila | |
| 100 | Windhoek |
Rows: 1-100 | Columns: 2
We can even extract the JSON as string and edit it before saving it as a json file:
[ ]:
json_str = data.to_json()
Let’s look at the begining portion of the string:
[67]:
json_str[0:100]
[67]:
'[\n{"name": "Abidjan", "geometry": "POINT (-4.041994118507091 5.321942826098564)"},\n{"name": "Abu Dha'
We can edit a portion of the string and save it again. We’ll change the name of the first city from Abidjan to Janabid:
[68]:
json_str = json_str[:12] + 'JanAbid' + json_str[19:]
Now we can save this edited strings file:
[ ]:
out_file = open("cities_edited.json", "w")
out_file.write(json_str)
out_file.close()
If we look at the new file, we can see the updated changes:
[ ]:
data = vp.read_json(path = path + "cities_edited.json",
schema = "complex_vmap_test",
table_name = "cities_edit",
ingest_local = False,)
Let’s search for the changed name:
[89]:
data[data["name"] == "JanAbid"]
[89]:
| Abc Varchar(90) | Abc nameVarchar(38) |
| 1 | JanAbid |
Rows: 1-1 | Columns: 2
Now to clean everything up, we can drop our temporary schema:
[ ]:
vp.drop("complex_vmap_test", method = "schema")
Conclusion#
This new functionality not only make it easy to ingest complex data types in different formats, but it enables data wrangling like never before.
The new features provide increased flexibility while keeping the process and syntax simple. You can do all of the following in VerticaPy:
Ingest complex datasets.
Perform convenient column operations.
Switch data types.
Flatten columns and maps into array like structures.