Memperkenalkan lazy mode

Pengantar Polars

Liam Brannigan

Data Scientist & Polars Contributor

Eager mode

(
    pl.read_csv("vacation_rentals.csv")


)
  • Memuat CSV ke DataFrame

Lazy mode

Pengantar Polars

Eager mode

(
    pl.read_csv("vacation_rentals.csv")


)
  • Memuat CSV ke DataFrame

Lazy mode

(
    pl.scan_csv("vacation_rentals.csv")


)
  • Memulai rencana kueri
  • Membaca baris awal CSV
Pengantar Polars

Eager mode

(
    pl.read_csv("vacation_rentals.csv")


)
| name     | type    | ... | beach |
| ---      | ---     | ... | ---   |
| str      | str     | ... | bool  |
|----------|---------| ... |-------|
| Waves    | Cottage | ... | false |
| Seashell | Cottage | ... | true  |
| ...      | ...     | ... | ...   |

Lazy mode

(
    pl.scan_csv("vacation_rentals.csv")


)
naive plan: 

Csv SCAN [vacation_rentals.csv]
PROJECT */8 COLUMNS
Pengantar Polars

Eager mode

(
    pl.read_csv("vacation_rentals.csv")
    .select("name","price")

)

Lazy mode

Pengantar Polars

Eager mode

(
    pl.read_csv("vacation_rentals.csv")
    .select("name","price")

)

Lazy mode

(
    pl.scan_csv("vacation_rentals.csv")
    .select("name","price")

)
  • Memperbarui rencana kueri
  • Mengoptimalkan rencana kueri
Pengantar Polars

Rencana kueri teroptimasi

print(
    pl.scan_csv("vacation_rentals.csv")
    .select("name","price")
    .explain()
)
Csv SCAN [vacation_rentals.csv]

PROJECT 2/8 COLUMNS
  • Optimasi: projection pushdown
Pengantar Polars

Menjalankan kueri lazy

(
    pl.scan_csv("vacation_rentals.csv")
    .select("name","price")
    .collect()
)
shape: (49, 2)
| name      | price |
| ---       | ---   |
| str       | i64   |
|-----------|-------|
| Waves     | 540   |
| Seashells | 540   |
| ...       | ...   |
Pengantar Polars

Eager mode vs. lazy mode

(
    pl.read_csv("vacation_rentals.csv")
    .select("name","price")

)
  • Baris demi baris
(
    pl.scan_csv("vacation_rentals.csv")
    .select("name","price")
    .collect()
)
  • Seluruh kueri
Pengantar Polars

Eager mode vs. lazy mode

Beruang Polar berlari dan Beruang Polars tidur

  • langkah demi langkah: eager mode
  • debugging: eager mode
  • kinerja optimal: lazy mode
Pengantar Polars

Ayo berlatih!

Pengantar Polars

Preparing Video For Download...