DataFrame 연결
Polars로 하는 데이터 변환
Liam Brannigan
Data Scientist & Polars Contributor
레스토랑 앱으로 돌아가기
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 |
연결
연결
런던 중심 데이터
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 |
런던 남부 데이터
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 |
$$
- 수직 연결: DataFrame을 위아래로 쌓기
수직 연결
reviews = pl.concat( )
수직 연결
reviews = pl.concat([central, south] )
수직 연결
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 |
수직 연결
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 |
누락 열이 있는 세 번째 배치
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 |
수직 연결 실패
pl.concat([central, south, north], how="vertical")
ShapeError: unable to append to a DataFrame of width 4 with a DataFrame of width 3
대각 연결
pl.concat([central, south, north], how="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 |
수평 연결
cuisine = pl.read_csv("cuisine.csv")
shape: (7, 1)
| cuisine |
| --- |
| str |
|----------|
| burgers |
| burgers |
| coffee |
| ... |
| chicken |
- 수평 연결: DataFrame을 좌우로 나란히 배치
수평 연결
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 |
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 |
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 |
연습해 봅시다!
Polars로 하는 데이터 변환
