import polars as pl
# Download data from tresorit; plug and play
df = pl.read_parquet("data/aisdk-2024-1h.parquet")
print(f"Shape of data: {df.shape}")
df.head(2)Shape of data: (26953310, 26)| MMSI | # Timestamp | Type of mobile | Latitude | Longitude | Navigational status | ROT | SOG | COG | Heading | IMO | Callsign | Name | Ship type | Cargo type | Width | Length | Type of position fixing device | Draught | Destination | ETA | Data source type | A | B | C | D |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| str | datetime[μs] | str | f64 | f64 | str | f64 | f64 | f64 | f64 | str | str | str | str | str | f64 | f64 | str | f64 | str | datetime[μs] | str | f64 | f64 | f64 | f64 |
| "205246000" | 2024-01-01 00:00:00 | "Class A" | 56.702297 | 8.219783 | "Under way using engine" | 0.0 | 0.0 | 199.0 | 227.0 | "Unknown" | "Unknown" | "Z510 DENNIS" | "Undefined" | null | 9.0 | 38.0 | "Undefined" | null | "Unknown" | null | "AIS" | 10.0 | 28.0 | 4.0 | 5.0 |
| "205246000" | 2024-01-01 01:00:00 | "Class A" | 56.702277 | 8.219765 | "Under way using engine" | 0.0 | 0.0 | 26.0 | 227.0 | "9215969" | "OPUF" | "Z510 DENNIS" | "Fishing" | null | 9.0 | 38.0 | "GPS" | null | "FISHING GROUNDS" | null | "AIS" | 10.0 | 28.0 | 4.0 | 5.0 |
