728x90
- .head(x)를 이용하여 데이터프레임의 맨 윗부분 x개 데이터 보기
- .head( ) 처럼 괄호 안을 비워놓으면 맨 윗부분 5개의 데이터를 가져온다.
# 데이터프레임의 맨 윗부분 5개의 데이터를 가져오세요.
reviews
country description designation points price province region_1 region_2 variety winery
0 US This tremendous 100% varietal wine hails from ... Martha's Vineyard 96 235.0 California Napa Valley Napa Cabernet Sauvignon Heitz
1 Spain Ripe aromas of fig, blackberry and cassis are ... Carodorum Selección Especial Reserva 96 110.0 Northern Spain Toro NaN Tinta de Toro Bodega Carmen Rodríguez
2 US Mac Watson honors the memory of a wine once ma... Special Selected Late Harvest 96 90.0 California Knights Valley Sonoma Sauvignon Blanc Macauley
3 US This spent 20 months in 30% new French oak, an... Reserve 96 65.0 Oregon Willamette Valley Willamette Valley Pinot Noir Ponzi
4 France This is the top wine from La Bégude, named aft... La Brûlade 95 66.0 Provence Bandol NaN Provence red blend Domaine de la Bégude
... ... ... ... ... ... ... ... ... ... ...
150925 Italy Many people feel Fiano represents southern Ita... NaN 91 20.0 Southern Italy Fiano di Avellino NaN White Blend Feudi di San Gregorio
150926 France Offers an intriguing nose with ginger, lime an... Cuvée Prestige 91 27.0 Champagne Champagne NaN Champagne Blend H.Germain
150927 Italy This classic example comes from a cru vineyard... Terre di Dora 91 20.0 Southern Italy Fiano di Avellino NaN White Blend Terredora
150928 France A perfect salmon shade, with scents of peaches... Grand Brut Rosé 90 52.0 Champagne Champagne NaN Champagne Blend Gosset
150929 Italy More Pinot Grigios should taste like this. A r... NaN 90 15.0 Northeastern Italy Alto Adige NaN Pinot Grigio Alois Lageder
150930 rows × 10 columns
reviews.head( )
country description designation points price province region_1 region_2 variety winery
0 US This tremendous 100% varietal wine hails from ... Martha's Vineyard 96 235.0 California Napa Valley Napa Cabernet Sauvignon Heitz
1 Spain Ripe aromas of fig, blackberry and cassis are ... Carodorum Selección Especial Reserva 96 110.0 Northern Spain Toro NaN Tinta de Toro Bodega Carmen Rodríguez
2 US Mac Watson honors the memory of a wine once ma... Special Selected Late Harvest 96 90.0 California Knights Valley Sonoma Sauvignon Blanc Macauley
3 US This spent 20 months in 30% new French oak, an... Reserve 96 65.0 Oregon Willamette Valley Willamette Valley Pinot Noir Ponzi
4 France This is the top wine from La Bégude, named aft... La Brûlade 95 66.0 Provence Bandol NaN Provence red blend Domaine de la Bégude
# 맨 윗부분 2개를 가져오세요. ( 가져오고 싶은 개수만큼 괄호 안에 넣어준다.)
reviews.head(2)
country description designation points price province region_1 region_2 variety winery
0 US This tremendous 100% varietal wine hails from ... Martha's Vineyard 96 235.0 California Napa Valley Napa Cabernet Sauvignon Heitz
1 Spain Ripe aromas of fig, blackberry and cassis are ... Carodorum Selección Especial Reserva 96 110.0 Northern Spain Toro NaN Tinta de Toro Bodega Carmen Rodríguez
- .tail(x)를 이용하여 데이터프레임의 맨 윗부분 x개 데이터 보기
- .tail( ) 처럼 괄호 안을 비워놓으면 맨 윗부분 5개의 데이터를 가져온다.
# 데이터프레임의 맨 끝 데이터 5개를 확인하는 방법
reviews.tail()
country description designation points price province region_1 region_2 variety winery
150925 Italy Many people feel Fiano represents southern Ita... NaN 91 20.0 Southern Italy Fiano di Avellino NaN White Blend Feudi di San Gregorio
150926 France Offers an intriguing nose with ginger, lime an... Cuvée Prestige 91 27.0 Champagne Champagne NaN Champagne Blend H.Germain
150927 Italy This classic example comes from a cru vineyard... Terre di Dora 91 20.0 Southern Italy Fiano di Avellino NaN White Blend Terredora
150928 France A perfect salmon shade, with scents of peaches... Grand Brut Rosé 90 52.0 Champagne Champagne NaN Champagne Blend Gosset
150929 Italy More Pinot Grigios should taste like this. A r... NaN 90 15.0 Northeastern Italy Alto Adige NaN Pinot Grigio Alois Lageder
# 데이터프레임의 맨 끝 데이터 3개를 확인하는 방법(가져오고 싶은 개수만큼 괄호 안에 숫자를 써준다.)
reviews.tail(3)
country description designation points price province region_1 region_2 variety winery
150927 Italy This classic example comes from a cru vineyard... Terre di Dora 91 20.0 Southern Italy Fiano di Avellino NaN White Blend Terredora
150928 France A perfect salmon shade, with scents of peaches... Grand Brut Rosé 90 52.0 Champagne Champagne NaN Champagne Blend Gosset
150929 Italy More Pinot Grigios should taste like this. A r... NaN 90 15.0 Northeastern Italy Alto Adige NaN Pinot Grigio Alois Lageder
데이터 안에 숫자로 된 컬럼의 통계치 확인하기
- 데이터 안에 숫자로 된 컬럼의 통계치를 확인하는 방법은 describe( ) 을 이용한다.
# reviews 안에 있는 데이터에서 숫자로 된 컬럼의 통계치를 확인하라.
reviews.describe( )
points price
count 150930.000000 137235.000000
mean 87.888418 33.131482
std 3.222392 36.322536
min 80.000000 4.000000
25% 86.000000 16.000000
50% 88.000000 24.000000
75% 90.000000 40.000000
max 100.000000 2300.000000
# count = 비어있는 데이터의 개수
# mean = 평균
# std = 표준편차
# min = 최솟값
# max = 최댓값
# 25% = 4분의 1값
# 50% = 중앙값
# 75% = 4분의 3값728x90
'python > pandas' 카테고리의 다른 글
| pandas - 카테고리별 데이터( Categorical Data ) (0) | 2022.11.24 |
|---|---|
| pandas - 비어있는 데이터(NaN) 확인 및 처리하는 방법'method=' ' ffill ' ' bfill ' (0) | 2022.11.24 |
| pandas - reivews로 파일 읽기 (0) | 2022.11.24 |
| pandas - column의 값을 index로 만들기와 인덱스 초기화 (0) | 2022.11.24 |
| pandas - index 변경 (0) | 2022.11.24 |
