การ Subset DataFrame

Introduction to Polars

Liam Brannigan

Data Scientist and Polars Contributor

การเลือกแถว

rentals[0]

shape: (1, 8)
| name      | type    | price | bedrooms | doubles | singles | review | beach |
| ---       | ---     | ---   | ---      | ---     | ---     | ---    | ---   |
| str       | str     | i64   | i64      | i64     | i64     | f64    | bool  |
|-----------|---------|-------|----------|---------|---------|--------|-------|
| Seashells | Cottage | 540   | 4        | 2       | 2       | 8.7    | true  |

การเลือกแถว

rentals[-1]

shape: (1, 8)
| name                | type    | price | bedrooms | doubles | singles | review | beach |
| ---                 | ---     | ---   | ---      | ---     | ---     | ---    | ---   |
| str                 | str     | i64   | i64      | i64     | i64     | f64    | bool  |
|---------------------|---------|-------|----------|---------|---------|--------|-------|
| Tehidy Holiday Park | Cottage | 637   | 4        | 2       | 4       | 9.0    | false |

การเลือกแถวแบบช่วง

rentals[1:3]

shape: (2, 8)
| name      | type    | price | bedrooms | doubles | singles | review | beach |
| ---       | ---     | ---   | ---      | ---     | ---     | ---    | ---   |
| str       | str     | i64   | i64      | i64     | i64     | f64    | bool  |
|-----------|---------|-------|----------|---------|---------|--------|-------|
| Seashells | Cottage | 540   | 4        | 2       | 2       | 8.7    | true  |
| Lake view | Cottage | 714   | 3        | 1       | 4       | 9.2    | true  |

การสร้าง Series จากคอลัมน์ของ DataFrame

rentals["name"]

shape: (2,)
Series: 'name' [str]
[
    "Waves"
    "Seashells"
]

การใส่คอลัมน์เดียวใน [] จะได้ Series
Series มีประโยชน์สำหรับการแสดงผลข้อมูล

การเลือกหลายคอลัมน์ด้วย brackets

rentals[["name", "price"]]

shape: (5, 2)
| name        | price |
| ---         | ---   |
| str         | i64   |
|-------------|-------|
| Waves       | 540   |
| Seashells   | 540   |
| Lake view   | 714   |
| Piran View  | 775   |
| Palma Villa | 1772  |

การเลือกแถวและคอลัมน์

rentals[:3, ["name", "price"]]

shape: (3, 2)
| name      | price |
| ---       | ---   |
| str       | i64   |
|-----------|-------|
| Waves     | 540   |
| Seashells | 540   |
| Lake view | 714   |

การ Subset คอลัมน์ด้วย .select()

rentals.select("name", "price")

shape: (3, 2)
| name        | price |
| ---         | ---   |
| str         | i64   |
|-------------|-------|
| Waves       | 540   |
| Seashells   | 540   |
| Lake view   | 714   |

df.select(["name", "price"])

ใช้ brackets หรือ select?

rentals.select("name","price")

shape: (3, 2)
| name        | price |
| ---         | ---   |
| str         | i64   |
|-------------|-------|
| Waves       | 540   |
| Seashells   | 540   |
| Lake view   | 714   |

.select() รองรับการปรับประสิทธิภาพ

rentals[["name","price"]]

shape: (3, 2)
| name        | price |
| ---         | ---   |
| str         | i64   |
|-------------|-------|
| Waves       | 540   |
| Seashells   | 540   |
| Lake view   | 714   |

มาฝึกกันเถอะ!

Introduction to Polars