Menggabungkan DataFrame
Transformasi Data dengan Polars
Liam Brannigan
Data Scientist & Polars Contributor
Kembali ke aplikasi restoran
shape: (4, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|------------------|-------------|--------|-------|
| 7burgers | Wakey Wakey | 4.2 | 15 |
| Bang Bang Burger | Forest Rd. | 3.8 | 12 |
| Costa Coffee | City Point | 4.5 | 8 |
| The Queens Head | Denman St. | 4.7 | 25 |
Konkatenasi
Konkatenasi
Data London pusat
import polars as pl
central = pl.read_csv("restaurants_central.csv")
shape: (4, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|------------------|-------------|--------|-------|
| 7burgers | Wakey Wakey | 4.2 | 15 |
| Bang Bang Burger | Forest Rd. | 3.8 | 12 |
| Costa Coffee | City Point | 4.5 | 8 |
| The Queens Head | Denman St. | 4.7 | 25 |
Data London selatan
south = pl.read_csv("restaurants_south.csv")
shape: (3, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|----------------|----------------|--------|-------|
| Pizzeria Bella | Bermondsey St. | 3.5 | 18 |
| Costa Coffee | Waterloo | 4.1 | 8 |
| Nando's | Brixton Rd. | 4.0 | 20 |
$$
- Konkatenasi vertikal — menumpuk DataFrame satu di atas yang lain
Konkatenasi vertikal
reviews = pl.concat( )
Konkatenasi vertikal
reviews = pl.concat([central, south] )
Konkatenasi vertikal
reviews = pl.concat([central, south], how="vertical")
shape: (7, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|------------------|----------------|--------|-------|
| 7burgers | Wakey Wakey | 4.2 | 15 |
| Bang Bang Burger | Forest Rd. | 3.8 | 12 |
| Costa Coffee | City Point | 4.5 | 8 |
| The Queens Head | Denman St. | 4.7 | 25 |
| Pizzeria Bella | Bermondsey St. | 3.5 | 18 |
| Costa Coffee | Waterloo | 4.1 | 8 |
| Nando's | Brixton Rd. | 4.0 | 20 |
Konkatenasi vertikal
reviews = pl.read_csv("restaurants*.csv")
shape: (7, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|------------------|----------------|--------|-------|
| 7burgers | Wakey Wakey | 4.2 | 15 |
| Bang Bang Burger | Forest Rd. | 3.8 | 12 |
| Costa Coffee | City Point | 4.5 | 8 |
| The Queens Head | Denman St. | 4.7 | 25 |
| Pizzeria Bella | Bermondsey St. | 3.5 | 18 |
| Costa Coffee | Waterloo | 4.1 | 8 |
| Nando's | Brixton Rd. | 4.0 | 20 |
Batch ketiga dengan data hilang
north = pl.read_csv("north.csv")
shape: (2, 3)
| business | location | review |
| --- | --- | --- |
| str | str | f64 |
|----------- |---------------|--------|
| Pig & Butcher | Liverpool Rd. | 3.2 |
| The Castle | Angle | 4.4 |
Konkatenasi vertikal gagal
pl.concat([central, south, north], how="vertical")
ShapeError: unable to append to a DataFrame of width 4 with a DataFrame of width 3
Konkatenasi diagonal
pl.concat([central, south, north], how="diagonal")
Konkatenasi diagonal
pl.concat([central, south, north], how="diagonal")
shape: (9, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|------------------|---------------------|--------|-------|
| 7burgers | Wakey Wakey | 4.2 | 15 |
| ... | ... | ... | ... |
| Nando's | Brixton Rd. | 4.0 | 20 |
| Pig & Butcher | Liverpool Rd. | 3.2 | null |
| The Castle | Angle | 4.4 | null |
Konkatenasi horizontal
cuisine = pl.read_csv("cuisine.csv")
shape: (7, 1)
| cuisine |
| --- |
| str |
|----------|
| burgers |
| burgers |
| coffee |
| ... |
| chicken |
- Konkatenasi horizontal — menempatkan DataFrame berdampingan
Konkatenasi horizontal
pl.concat([reviews, cuisine], how="horizontal")
shape: (7, 5)
| business | location | review | price | cuisine |
| --- | --- | --- | --- | --- |
| str | str | f64 | i64 | str |
|------------------|----------------|--------|-------|----------|
| 7burgers | Wakey Wakey | 4.2 | 15 | burgers |
| Bang Bang Burger | Forest Rd. | 3.8 | 12 | burgers |
| Costa Coffee | City Point | 4.5 | 8 | coffee |
| The Queens Head | Denman St. | 4.7 | 25 | pub_food |
| Pizzeria Bella | Bermondsey St. | 3.5 | 18 | pizza |
| Costa Coffee | Waterloo | 4.1 | 8 | coffee |
| Nando's | Brixton Rd. | 4.0 | 20 | chicken |
Menambahkan dengan extend
new_listing = pl.DataFrame({
"business": ["Wagamama"],
"location": ["Soho"],
"review": [4.3],
"price": [16]
})
shape: (1, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|------------------|--------------|--------|-------|
| Wagamama | Soho | 4.3 | 16 |
Menambahkan dengan extend
reviews.extend(new_listing)
shape: (8, 4)
| business | location | review | price |
| --- | --- | --- | --- |
| str | str | f64 | i64 |
|------------------|----------------|--------|-------|
| 7burgers | Wakey Wakey | 4.2 | 15 |
| ... | ... | ... | ... |
| Nando's | Brixton Rd. | 4.0 | 20 |
| Wagamama | Soho | 4.3 | 16 |
Ayo berlatih!
Transformasi Data dengan Polars
