데이터 관리를 연습하기 위한 샘플 데이터

다음 코드를 실행해서
> install.packages("nycflights13")

설치합니다.

NYC 공항에서 출발하는 비행기 데이터입니다.
다음 테이블을 포함합니다.

airlines
airports
flights
planes
weather

데이터를 불러옵시다.
> data("airlines")
> data("airports")
> data("flights")
> data("planes")
> data("weather")

airlines

• carrier
• name

airports

• faa - FAA 공항 코드
• name - 공항 이름
• lat - 위도
• lon - 경도
• tz - 타임존
• dat - daylight savings time zone /A=US DST, U=Unknown, N=no dat
• tzone - IANA time zone

planes

• tailnum - Tail number
• year - Year manufactured
• type - Type of plane
• manufacturer,model - Manufacturer and model
• engines,seats - Number of engines and seats
• speed - Average cruising speed in mph
• engine - Type of engine

weather

• origin - Orign. FOREIGN KEY /airports$faa
• year,month,day,hour - Time of recording
• temp,dewp - Temperature and dewpoint in F
• humid - Relative humidity
• wind_dir,wind_speed,wind_gust - Wind direction (in degrees), speed and gust speed (in mph)
• precip - Preciptation, in inches
• pressure - Sea level pressure in millibars
• visib - Visibility in miles
• time_hour - Date and hour of the recording as a POSIXct date

flights

NYC를 떠나는 비행기의 데이터

• year,month,day - 출발일자
• dep_time,arr_time - 실제 출발 도착 시각
• sched_dep_time,sched_arr_time - 예정된 출발 도착 시각
• dep_delay,arr_delay - 도착 출발 지연(분), 음수이면 일찍
• hour,minute - Time of scheduled departure broken into hour and minutes.
• carrier - Two letter carrier abbreviation. FOREIGN KEY /airlines$carrier
• tailnum - Plane tail number. FOREIGN KEY /planes$tailnum
• flight - Flight number
• origin,dest - Origin and destination. FOREIGN KEY /airports$faa
• air_time - Amount of time spent in the air, in minutes
• distance - Distance between airports, in miles
• time_hour - Scheduled date and hour of the flight as a POSIXct date. Along with origin, can be used to join flights data to weather data.