Spaces:
Sleeping
Sleeping
File size: 5,392 Bytes
ef02bce |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 |
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import os\n",
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"C:\\Users\\wipar\\AppData\\Local\\Temp\\ipykernel_16160\\3701237280.py:1: DtypeWarning: Columns (77,84) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" raw_airport_dataset = pd.read_csv(os.path.join(\"data_cleaning/flight_data_raw/2021/On_Time_Reporting_Carrier_On_Time_Performance_(1987_present)_2021_1.csv\"))\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"Year int64\n",
"Quarter int64\n",
"Month int64\n",
"DayofMonth int64\n",
"DayOfWeek int64\n",
" ... \n",
"Div5TotalGTime float64\n",
"Div5LongestGTime float64\n",
"Div5WheelsOff float64\n",
"Div5TailNum float64\n",
"Unnamed: 109 float64\n",
"Length: 110, dtype: object\n"
]
}
],
"source": [
"raw_airport_dataset = pd.read_csv(os.path.join(\"data_cleaning/flight_data_raw/2021/On_Time_Reporting_Carrier_On_Time_Performance_(1987_present)_2021_1.csv\"))\n",
"\n",
"print(raw_airport_dataset.dtypes)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Time object\n",
"Origin object\n",
"Dest object\n",
"Carrier object\n",
"Cancelled bool\n",
"CancellationReason object\n",
"Delayed bool\n",
"DepDelayMinutes float64\n",
"CarrierDelay float64\n",
"WeatherDelay float64\n",
"NASDelay float64\n",
"SecurityDelay float64\n",
"LateAircraftDelay float64\n",
"dtype: object\n"
]
}
],
"source": [
"clean_airport_dataset = pd.read_csv(os.path.join(\"data_cleaning/flight_data_with_time/2021/On_Time_Reporting_Carrier_On_Time_Performance_(1987_present)_2021_1.csv\"))\n",
"\n",
"print(clean_airport_dataset.dtypes)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"station object\n",
"valid object\n",
"tmpf object\n",
"dwpf object\n",
"relh object\n",
"drct object\n",
"sknt object\n",
"p01i object\n",
"alti float64\n",
"mslp object\n",
"vsby object\n",
"gust object\n",
"skyc1 object\n",
"skyc2 object\n",
"skyc3 object\n",
"skyc4 object\n",
"skyl1 object\n",
"skyl2 object\n",
"skyl3 object\n",
"skyl4 object\n",
"wxcodes object\n",
"ice_accretion_1hr object\n",
"ice_accretion_3hr object\n",
"ice_accretion_6hr object\n",
"peak_wind_gust object\n",
"peak_wind_drct object\n",
"peak_wind_time object\n",
"feel object\n",
"metar object\n",
"snowdepth object\n",
"dtype: object\n"
]
}
],
"source": [
"raw_weather_dataset = pd.read_csv(os.path.join(\"data_cleaning/weather_raw/ATL.csv\"))\n",
"\n",
"print(raw_weather_dataset.dtypes)"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Time object\n",
"Origin object\n",
"Temperature float64\n",
"Feels_Like_Temperature float64\n",
"Altimeter_Pressure float64\n",
"Sea_Level_Pressure float64\n",
"Visibility float64\n",
"Wind_Speed float64\n",
"Wind_Gust float64\n",
"Precipitation float64\n",
"Ice_Accretion_3hr float64\n",
"dtype: object\n"
]
}
],
"source": [
"combined_weather_dataset = pd.read_csv(os.path.join(\"data_cleaning/combined_weather.csv\"))\n",
"\n",
"print(combined_weather_dataset.dtypes)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.11.9"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
|