import pandas as pd
d1 = {
"ingestDateTime": {
"value": 1549001510197
},
"messageDateTime": {
"value": 1549001508788
},
"latitude": {
"value": 41.32666
},
"longitude": {
"value": -73.82401
},
"altitude": {
"value": 34000
},
"groundSpeed": {
"value": 359
},
"verticalClimbRate": {
"value": -64.0
},
"squawkCode": {
"value": "3410"
},
"aircraftIdentifier": "A2B348",
"callSign": {
"value": "SKW3903"
},
"track": {
"value": 228.0
},
"alert": {
"value": 0
},
"emergency": {
},
"isOnGround": {
"value": 0
},
"faData": {
"value": {
"version": "2.7",
"summary": False,
"flights": {
"SKW3903-1548743144-airline-0646:0": {
"activityLog": {
"flights": [
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A3",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B4"
},
"aircraftType": "E170",
"aircraftTypeFriendly": "Embraer 170/175 (twin-jet)",
"flightId": "SKW3903-1548829541-airline-0357",
"takeoffTimes": {
"scheduled": 1549066740,
"estimated": 1549066740
},
"landingTimes": {
"scheduled": 1549076640,
"estimated": 1549076640
},
"gateDepartureTimes": {
"scheduled": 1549066140
},
"gateArrivalTimes": {
"scheduled": 1549077240
},
"ga": False,
"flightStatus": "",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190202/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A3",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B3"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548743144-airline-0646:0",
"takeoffTimes": {
"scheduled": 1548980340,
"estimated": 1548981543,
"actual": 1548981480
},
"landingTimes": {
"scheduled": 1548989640,
"estimated": 1548990600
},
"gateDepartureTimes": {
"scheduled": 1548979740,
"estimated": 1548980520,
"actual": 1548980460
},
"gateArrivalTimes": {
"scheduled": 1548990840,
"estimated": 1548991500
},
"ga": False,
"flightStatus": "airborne",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A1",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548656782-airline-0016:0",
"takeoffTimes": {
"scheduled": 1548893940,
"estimated": 1548906926,
"actual": 1548906900
},
"landingTimes": {
"scheduled": 1548903300,
"estimated": 1548916956,
"actual": 1548916920
},
"gateDepartureTimes": {
"scheduled": 1548893340,
"estimated": 1548903900,
"actual": 1548906300
},
"gateArrivalTimes": {
"scheduled": 1548904440,
"estimated": 1548917340,
"actual": 1548917160
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190131/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A11",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548570561-airline-0258:0",
"takeoffTimes": {
"scheduled": 1548807540,
"estimated": 1548806929,
"actual": 1548806880
},
"landingTimes": {
"scheduled": 1548816480,
"estimated": 1548816075,
"actual": 1548816060
},
"gateDepartureTimes": {
"scheduled": 1548805860,
"estimated": 1548806340,
"actual": 1548805860
},
"gateArrivalTimes": {
"scheduled": 1548816720,
"estimated": 1548816360,
"actual": 1548816360
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190130/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A8",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548483971-airline-0555:0",
"takeoffTimes": {
"scheduled": 1548721140,
"estimated": 1548721879,
"actual": 1548721860
},
"landingTimes": {
"scheduled": 1548730500,
"estimated": 1548731640,
"actual": 1548731640
},
"gateDepartureTimes": {
"scheduled": 1548720660,
"actual": 1548720660
},
"gateArrivalTimes": {
"scheduled": 1548730980,
"estimated": 1548732120,
"actual": 1548732120
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190129/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A8",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B3"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548397551-airline-0603:0",
"takeoffTimes": {
"scheduled": 1548634740,
"estimated": 1548635208,
"actual": 1548635160
},
"landingTimes": {
"scheduled": 1548644160,
"estimated": 1548645670,
"actual": 1548645660
},
"gateDepartureTimes": {
"scheduled": 1548634140,
"actual": 1548634140
},
"gateArrivalTimes": {
"scheduled": 1548645240,
"estimated": 1548646080,
"actual": 1548645900
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190128/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A7",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548224736-airline-0375:0",
"takeoffTimes": {
"scheduled": 1548461940,
"estimated": 1548462877,
"actual": 1548462840
},
"landingTimes": {
"scheduled": 1548473040,
"estimated": 1548472535,
"actual": 1548472500
},
"gateDepartureTimes": {
"scheduled": 1548461340,
"actual": 1548460920
},
"gateArrivalTimes": {
"scheduled": 1548472440,
"estimated": 1548472980,
"actual": 1548474060
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190126/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A4",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548138349-airline-0516:0",
"takeoffTimes": {
"scheduled": 1548375540,
"estimated": 1548390026,
"actual": 1548390000
},
"landingTimes": {
"scheduled": 1548386220,
"estimated": 1548400702,
"actual": 1548400680
},
"gateDepartureTimes": {
"scheduled": 1548374940,
"estimated": 1548389820,
"actual": 1548389100
},
"gateArrivalTimes": {
"scheduled": 1548386040,
"estimated": 1548401040,
"actual": 1548400860
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190125/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A6",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B2"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1548051980-airline-0128:0",
"takeoffTimes": {
"scheduled": 1548289140,
"estimated": 1548295505,
"actual": 1548295500
},
"landingTimes": {
"scheduled": 1548298380,
"estimated": 1548305520,
"actual": 1548305520
},
"gateDepartureTimes": {
"scheduled": 1548288540,
"estimated": 1548294900,
"actual": 1548294480
},
"gateArrivalTimes": {
"scheduled": 1548299640,
"estimated": 1548305820,
"actual": 1548305880
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190124/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A10",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1547965579-airline-0375",
"takeoffTimes": {
"scheduled": 1548202740,
"estimated": 1548202740
},
"landingTimes": {
"scheduled": 1548229620,
"estimated": 1548229620
},
"gateDepartureTimes": {
"scheduled": 1548202140,
"estimated": 1548202140
},
"gateArrivalTimes": {
"scheduled": 1548213240,
"estimated": 1548230220
},
"ga": False,
"flightStatus": "",
"cancelled": True,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190123/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A10",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B4"
},
"aircraftType": "E170",
"aircraftTypeFriendly": "Embraer 170/175 (twin-jet)",
"flightId": "SKW3903-1547879154-airline-0061",
"takeoffTimes": {
"scheduled": 1548116340,
"estimated": 1548116340
},
"landingTimes": {
"scheduled": 1548126240,
"estimated": 1548126240
},
"gateDepartureTimes": {
"scheduled": 1548115740
},
"gateArrivalTimes": {
"scheduled": 1548126840
},
"ga": False,
"flightStatus": "",
"cancelled": True,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190122/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A2",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1547792797-airline-0132:0",
"takeoffTimes": {
"scheduled": 1548029940,
"estimated": 1548035215,
"actual": 1548035160
},
"landingTimes": {
"scheduled": 1548039420,
"estimated": 1548044280,
"actual": 1548044280
},
"gateDepartureTimes": {
"scheduled": 1548032940,
"estimated": 1548032400,
"actual": 1548032940
},
"gateArrivalTimes": {
"scheduled": 1548043140,
"estimated": 1548044580,
"actual": 1548044940
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190121/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A6",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1547619946-airline-0367:0",
"takeoffTimes": {
"scheduled": 1547857140,
"estimated": 1547858025,
"actual": 1547857980
},
"landingTimes": {
"scheduled": 1547866080,
"estimated": 1547867616,
"actual": 1547867580
},
"gateDepartureTimes": {
"scheduled": 1547856540,
"actual": 1547856360
},
"gateArrivalTimes": {
"scheduled": 1547867640,
"estimated": 1547868000,
"actual": 1547868000
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190119/0019Z/KBOS/KBNA"
},
{
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A3",
"terminal": "A"
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B9"
},
"aircraftType": "E75L",
"aircraftTypeFriendly": "Embraer 175 (twin-jet)",
"flightId": "SKW3903-1547533576-airline-0461:0",
"takeoffTimes": {
"scheduled": 1547770740,
"estimated": 1547770540,
"actual": 1547770500
},
"landingTimes": {
"scheduled": 1547779020,
"estimated": 1547779463,
"actual": 1547779440
},
"gateDepartureTimes": {
"scheduled": 1547770140,
"actual": 1547769840
},
"gateArrivalTimes": {
"scheduled": 1547781240,
"estimated": 1547779740,
"actual": 1547779860
},
"ga": False,
"flightStatus": "arrived",
"cancelled": False,
"resultUnknown": False,
"diverted": False,
"adhoc": False,
"fruOverride": False,
"permaLink": "/live/flight/SKW3903/history/20190118/0019Z/KBOS/KBNA"
}
],
"additionalLogRowsAvailable": False
},
"adhoc": False,
"adhocAvailable": False,
"aircraft": {
"type": "E75L",
"canMessage": False,
"lifeguard": False,
"heavy": False,
"friendlyType": "Embraer 175 (twin-jet)"
},
"airline": {
"fullName": "SkyWest Airlines",
"shortName": "SkyWest",
"icao": "SKW",
"iata": "OO",
"callsign": "SkyWest",
"url": "https://www.skywest.com/"
},
"altitude": 340,
"averageDelays": {
"departure": 2787,
"arrival": 3428
},
"blocked": False,
"blockedForUser": False,
"cabinInfo": {
},
"cancelled": False,
"codeShare": {
"ident": "SKW3903",
"displayIdent": "SKW3903",
"iataIdent": "OO3903",
"airline": {
"fullName": "SkyWest Airlines",
"shortName": "SkyWest",
"icao": "SKW",
"iata": "OO",
"callsign": "SkyWest",
"url": "https://www.skywest.com/"
},
"friendlyIdent": "SkyWest 3903",
"thumbnail": {
"imageUrl": "https://e1.flightcdn.com/images/airline_logos/90p/SKW.png",
"linkUrl": "/live/fleet/SKW"
},
"links": {
"permanent": "/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA",
"staticMap": "/ajax/flight/map/SKW3903/20190201/0019Z/KBOS/KBNA/",
"trackLog": "/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA/tracklog",
"flightHistory": "/live/flight/SKW3903/history",
"buyFlightHistory": "/live/flight/SKW3903/history/buy",
"reportInaccuracies": "/live/report/SKW3903/history/20190201/0019Z/KBOS/KBNA",
"facebook": "https://facebook.com/sharer.php?u\u003dhttps://flightaware.com/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA",
"twitter": "https://twitter.com/intent/tweet?url\u003dhttps://flightaware.com/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA\u0026via\u003dFlightAware"
}
},
"destination": {
"TZ": ":America/Chicago",
"isValidAirportCode": True,
"iata": "BNA",
"friendlyName": "Nashville Intl",
"friendlyLocation": "Nashville, TN",
"coord": [
-86.6782,
36.1245
],
"icao": "KBNA",
"gate": "B3"
},
"displayIdent": "SKW3903",
"distance": {
"elapsed": 99,
"remaining": 720
},
"diverted": False,
"flightId": "SKW3903-1548743144-airline-0646:0",
"flightPlan": {
"speed": 434,
"altitude": 340,
"route": "BLZZR4 BLZZR BAF Q406 BWZ J6 YOCKY GROAT PASLY4",
"directDistance": 819,
"plannedDistance": 876,
"departure": 1548980340,
"ete": 9300,
"fuelBurn": {
"gallons": 1100,
"pounds": 7300
}
},
"flightStatus": "airborne",
"friendlyIdent": "SkyWest 3903",
"fruOverride": False,
"ga": False,
"gateArrivalTimes": {
"scheduled": 1548990840,
"estimated": 1548991500
},
"gateDepartureTimes": {
"scheduled": 1548979740,
"estimated": 1548980520,
"actual": 1548980460
},
"globalIdent": False,
"globalScheduledFBO": False,
"globalServices": {
},
"groundspeed": 348,
"heading": 245,
"historical": False,
"iataIdent": "OO3903",
"icon": "airliner",
"ident": "SKW3903",
"inboundFlight": {
"flightId": "SKW4130-1548743144-airline-0373:0",
"linkUrl": "/live/flight/id/SKW4130-1548743144-airline-0373%3a0"
},
"landingTimes": {
"scheduled": 1548989640,
"estimated": 1548990600
},
"links": {
"permanent": "/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA",
"staticMap": "/ajax/flight/map/SKW3903/20190201/0019Z/KBOS/KBNA/",
"trackLog": "/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA/tracklog",
"flightHistory": "/live/flight/SKW3903/history",
"buyFlightHistory": "/live/flight/SKW3903/history/buy",
"reportInaccuracies": "/live/report/SKW3903/history/20190201/0019Z/KBOS/KBNA",
"facebook": "https://facebook.com/sharer.php?u\u003dhttps://flightaware.com/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA",
"twitter": "https://twitter.com/intent/tweet?url\u003dhttps://flightaware.com/live/flight/SKW3903/history/20190201/0019Z/KBOS/KBNA\u0026via\u003dFlightAware"
},
"myAlerts": {
"editAlert": "",
"advancedAlert": "/account/manage/alerts/0/add?m_ident\u003dSKW3903;date_start\u003d2019-01-31;date_end\u003d2019-01-31"
},
"origin": {
"TZ": ":America/New_York",
"isValidAirportCode": True,
"iata": "BOS",
"friendlyName": "Boston Logan Intl",
"friendlyLocation": "Boston, MA",
"coord": [
-71.0064,
42.3629
],
"icao": "KBOS",
"gate": "A3",
"terminal": "A"
},
"redactedTail": True,
"relatedThumbnails": [
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/f04ef671bb7d267e16f97f98dd8f3f39313d139d",
"target": "/photos/view/1340700-9150990a95bfd8fd9500d188cdff13cc3145decb"
},
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/cfdaba2896395cf3fa160f64261085160bfc2a0d",
"target": "/photos/view/241789-d4fe6dae0d2fa2524e562902cbff9e631f37c217"
},
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/99de55b4252c7c19866fe6b1f8b0b8db67f64a03",
"target": "/photos/view/563408-65ee80b97f33e4ad1a31dce6c5a3e0cd207070ef"
},
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/cfd644610766e436c978aace5ed80fdb19fb0f5b",
"target": "/photos/view/8960915-5ecee772a461a361a3029a83b5b0a6ff88e701a3"
},
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/10308ba47c37b1fe9a0f5e051aab1f7899d18eaf",
"target": "/photos/view/563408-15e328ab8c93e6bf29505fa1420c9d0cd93a3496"
},
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/4d51a251380d65ad8e2a21bb141e2ed799bf5f72",
"target": "/photos/view/241789-7692d885d75a2484a9bf4e0e54bc15001256ad44"
},
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/4f0f6eee8da1b704e231dc4fd992065304c271ac",
"target": "/photos/view/563408-456cd61dc775b60b0aeeafb5e2b4ea40c855510a"
},
{
"thumbnail": "https://photos-e1.flightcdn.com/photos/retriever/faf8c7a54ca4cca5518101bf4fea091964bbe01e",
"target": "/photos/view/7885580-7a499c561f97eba9a5395e361181ca50356186f6"
}
],
"resultUnknown": False,
"showSurfaceTimes": False,
"takeoffTimes": {
"scheduled": 1548980340,
"estimated": 1548981543,
"actual": 1548981480
},
"thumbnail": {
"imageUrl": "https://e1.flightcdn.com/images/airline_logos/90p/SKW.png",
"linkUrl": "/live/fleet/SKW"
},
"timestamp": 1548983074,
"track": [
{
"timestamp": 1548981543,
"coord": [
-71.0154,
42.3549
],
"alt": 5,
"gs": 136,
"type": "",
"isolated": False
},
{
"timestamp": 1548981553,
"coord": [
-71.0166,
42.3494
],
"alt": 8,
"gs": 141,
"type": "",
"isolated": False
},
{
"timestamp": 1548981561,
"coord": [
-71.0166,
42.3444
],
"alt": 11,
"gs": 149,
"type": "",
"isolated": False
},
{
"timestamp": 1548981567,
"coord": [
-71.0154,
42.3399
],
"alt": 13,
"gs": 159,
"type": "",
"isolated": False
},
{
"timestamp": 1548981572,
"coord": [
-71.0131,
42.3359
],
"alt": 14,
"gs": 170,
"type": "",
"isolated": False
},
{
"timestamp": 1548981578,
"coord": [
-71.0099,
42.3323
],
"alt": 15,
"gs": 181,
"type": "",
"isolated": False
},
{
"timestamp": 1548981583,
"coord": [
-71.0056,
42.3291
],
"alt": 17,
"gs": 192,
"type": "",
"isolated": False
},
{
"timestamp": 1548981588,
"coord": [
-71.0007,
42.3261
],
"alt": 18,
"gs": 201,
"type": "",
"isolated": False
},
{
"timestamp": 1548981594,
"coord": [
-70.9953,
42.3231
],
"alt": 19,
"gs": 208,
"type": "",
"isolated": False
},
{
"timestamp": 1548981599,
"coord": [
-70.9896,
42.3201
],
"alt": 21,
"gs": 213,
"type": "",
"isolated": False
},
{
"timestamp": 1548981604,
"coord": [
-70.9835,
42.3172
],
"alt": 23,
"gs": 216,
"type": "",
"isolated": False
},
{
"timestamp": 1548981610,
"coord": [
-70.9773,
42.3145
],
"alt": 25,
"gs": 221,
"type": "",
"isolated": False
},
{
"timestamp": 1548981615,
"coord": [
-70.9710,
42.3120
],
"alt": 27,
"gs": 226,
"type": "",
"isolated": False
},
{
"timestamp": 1548981620,
"coord": [
-70.9641,
42.3100
],
"alt": 29,
"gs": 231,
"type": "",
"isolated": False
},
{
"timestamp": 1548981626,
"coord": [
-70.9564,
42.3087
],
"alt": 30,
"gs": 237,
"type": "",
"isolated": False
},
{
"timestamp": 1548981632,
"coord": [
-70.9477,
42.3080
],
"alt": 32,
"gs": 244,
"type": "",
"isolated": False
},
{
"timestamp": 1548981638,
"coord": [
-70.9373,
42.3082
],
"alt": 34,
"gs": 250,
"type": "",
"isolated": False
},
{
"timestamp": 1548981646,
"coord": [
-70.9243,
42.3096
],
"alt": 37,
"gs": 257,
"type": "",
"isolated": False
},
{
"timestamp": 1548981656,
"coord": [
-70.9087,
42.3122
],
"alt": 40,
"gs": 264,
"type": "",
"isolated": False
},
{
"timestamp": 1548981686,
"coord": [
-70.8594,
42.3231
],
"alt": 55,
"gs": 275,
"type": "",
"isolated": False
},
{
"timestamp": 1548981698,
"coord": [
-70.8398,
42.3264
],
"alt": 60,
"gs": 279,
"type": "",
"isolated": False
},
{
"timestamp": 1548981707,
"coord": [
-70.8238,
42.3284
],
"alt": 64,
"gs": 283,
"type": "",
"isolated": False
},
{
"timestamp": 1548981715,
"coord": [
-70.8114,
42.3291
],
"alt": 67,
"gs": 287,
"type": "",
"isolated": False
},
{
"timestamp": 1548981721,
"coord": [
-70.8010,
42.3288
],
"alt": 69,
"gs": 289,
"type": "",
"isolated": False
},
{
"timestamp": 1548981727,
"coord": [
-70.7910,
42.3276
],
"alt": 72,
"gs": 292,
"type": "",
"isolated": False
},
{
"timestamp": 1548981733,
"coord": [
-70.7814,
42.3256
],
"alt": 74,
"gs": 295,
"type": "",
"isolated": False
},
{
"timestamp": 1548981738,
"coord": [
-70.7717,
42.3229
],
"alt": 77,
"gs": 297,
"type": "",
"isolated": False
},
{
"timestamp": 1548981744,
"coord": [
-70.7618,
42.3197
],
"alt": 79,
"gs": 298,
"type": "",
"isolated": False
},
{
"timestamp": 1548981750,
"coord": [
-70.7517,
42.3160
],
"alt": 81,
"gs": 299,
"type": "",
"isolated": False
},
{
"timestamp": 1548981755,
"coord": [
-70.7420,
42.3117
],
"alt": 83,
"gs": 299,
"type": "",
"isolated": False
},
{
"timestamp": 1548981761,
"coord": [
-70.7337,
42.3067
],
"alt": 86,
"gs": 297,
"type": "",
"isolated": False
},
{
"timestamp": 1548981767,
"coord": [
-70.7266,
42.3011
],
"alt": 88,
"gs": 294,
"type": "",
"isolated": False
},
{
"timestamp": 1548981773,
"coord": [
-70.7209,
42.2950
],
"alt": 90,
"gs": 290,
"type": "",
"isolated": False
},
{
"timestamp": 1548981779,
"coord": [
-70.7167,
42.2886
],
"alt": 92,
"gs": 286,
"type": "",
"isolated": False
},
{
"timestamp": 1548981784,
"coord": [
-70.7141,
42.2819
],
"alt": 95,
"gs": 281,
"type": "",
"isolated": False
},
{
"timestamp": 1548981789,
"coord": [
-70.7127,
42.2755
],
"alt": 97,
"gs": 277,
"type": "",
"isolated": False
},
{
"timestamp": 1548981795,
"coord": [
-70.7122,
42.2698
],
"alt": 99,
"gs": 273,
"type": "",
"isolated": False
},
{
"timestamp": 1548981800,
"coord": [
-70.7126,
42.2649
],
"alt": 101,
"gs": 270,
"type": "",
"isolated": False
},
{
"timestamp": 1548981805,
"coord": [
-70.7144,
42.2599
],
"alt": 102,
"gs": 267,
"type": "",
"isolated": False
},
{
"timestamp": 1548981811,
"coord": [
-70.7179,
42.2539
],
"alt": 104,
"gs": 265,
"type": "",
"isolated": False
},
{
"timestamp": 1548981817,
"coord": [
-70.7232,
42.2470
],
"alt": 105,
"gs": 263,
"type": "",
"isolated": False
},
{
"timestamp": 1548981822,
"coord": [
-70.7296,
42.2403
],
"alt": 106,
"gs": 261,
"type": "",
"isolated": False
},
{
"timestamp": 1548981828,
"coord": [
-70.7364,
42.2349
],
"alt": 107,
"gs": 261,
"type": "",
"isolated": False
},
{
"timestamp": 1548981833,
"coord": [
-70.7438,
42.2309
],
"alt": 108,
"gs": 261,
"type": "",
"isolated": False
},
{
"timestamp": 1548981838,
"coord": [
-70.7516,
42.2279
],
"alt": 110,
"gs": 261,
"type": "",
"isolated": False
},
{
"timestamp": 1548981844,
"coord": [
-70.7600,
42.2256
],
"alt": 111,
"gs": 263,
"type": "",
"isolated": False
},
{
"timestamp": 1548981850,
"coord": [
-70.7690,
42.2242
],
"alt": 112,
"gs": 265,
"type": "",
"isolated": False
},
{
"timestamp": 1548981857,
"coord": [
-70.7804,
42.2233
],
"alt": 114,
"gs": 269,
"type": "",
"isolated": False
},
{
"timestamp": 1548981866,
"coord": [
-70.7962,
42.2227
],
"alt": 116,
"gs": 274,
"type": "",
"isolated": False
},
{
"timestamp": 1548981879,
"coord": [
-70.8163,
42.2223
],
"alt": 119,
"gs": 281,
"type": "",
"isolated": False
},
{
"timestamp": 1548981903,
"coord": [
-70.8613,
42.2220
],
"alt": 127,
"gs": 286,
"type": "",
"isolated": False
},
{
"timestamp": 1548981920,
"coord": [
-70.8910,
42.2214
],
"alt": 133,
"gs": 288,
"type": "",
"isolated": False
},
{
"timestamp": 1548981943,
"coord": [
-70.9336,
42.2197
],
"alt": 140,
"gs": 292,
"type": "",
"isolated": False
},
{
"timestamp": 1548981961,
"coord": [
-70.9646,
42.2186
],
"alt": 147,
"gs": 292,
"type": "",
"isolated": False
},
{
"timestamp": 1548981977,
"coord": [
-70.9931,
42.2181
],
"alt": 152,
"gs": 294,
"type": "",
"isolated": False
},
{
"timestamp": 1548981995,
"coord": [
-71.0244,
42.2176
],
"alt": 158,
"gs": 297,
"type": "",
"isolated": False
},
{
"timestamp": 1548982012,
"coord": [
-71.0584,
42.2169
],
"alt": 163,
"gs": 296,
"type": "",
"isolated": False
},
{
"timestamp": 1548982042,
"coord": [
-71.1137,
42.2151
],
"alt": 172,
"gs": 297,
"type": "",
"isolated": False
},
{
"timestamp": 1548982058,
"coord": [
-71.1395,
42.2143
],
"alt": 178,
"gs": 296,
"type": "",
"isolated": False
},
{
"timestamp": 1548982088,
"coord": [
-71.2018,
42.2123
],
"alt": 187,
"gs": 298,
"type": "",
"isolated": False
},
{
"timestamp": 1548982113,
"coord": [
-71.2483,
42.2111
],
"alt": 194,
"gs": 298,
"type": "",
"isolated": False
},
{
"timestamp": 1548982148,
"coord": [
-71.3113,
42.2094
],
"alt": 205,
"gs": 293,
"type": "",
"isolated": False
},
{
"timestamp": 1548982168,
"coord": [
-71.3440,
42.2085
],
"alt": 211,
"gs": 291,
"type": "",
"isolated": False
},
{
"timestamp": 1548982187,
"coord": [
-71.3836,
42.2074
],
"alt": 215,
"gs": 294,
"type": "",
"isolated": False
},
{
"timestamp": 1548982206,
"coord": [
-71.4166,
42.2064
],
"alt": 218,
"gs": 295,
"type": "",
"isolated": False
},
{
"timestamp": 1548982222,
"coord": [
-71.4453,
42.2057
],
"alt": 222,
"gs": 297,
"type": "",
"isolated": False
},
{
"timestamp": 1548982240,
"coord": [
-71.4792,
42.2046
],
"alt": 225,
"gs": 298,
"type": "",
"isolated": False
},
{
"timestamp": 1548982269,
"coord": [
-71.5294,
42.2031
],
"alt": 230,
"gs": 302,
"type": "",
"isolated": False
},
{
"timestamp": 1548982285,
"coord": [
-71.5626,
42.2022
],
"alt": 232,
"gs": 304,
"type": "",
"isolated": False
},
{
"timestamp": 1548982308,
"coord": [
-71.6063,
42.2009
],
"alt": 237,
"gs": 306,
"type": "",
"isolated": False
},
{
"timestamp": 1548982329,
"coord": [
-71.6460,
42.1997
],
"alt": 241,
"gs": 306,
"type": "",
"isolated": False
},
{
"timestamp": 1548982345,
"coord": [
-71.6769,
42.1987
],
"alt": 244,
"gs": 307,
"type": "",
"isolated": False
},
{
"timestamp": 1548982366,
"coord": [
-71.7167,
42.1975
],
"alt": 248,
"gs": 309,
"type": "",
"isolated": False
},
{
"timestamp": 1548982377,
"coord": [
-71.7393,
42.1955
],
"alt": 249,
"gs": 312,
"type": "",
"isolated": False
},
{
"timestamp": 1548982386,
"coord": [
-71.7571,
42.1933
],
"alt": 250,
"gs": 314,
"type": "",
"isolated": False
},
{
"timestamp": 1548982393,
"coord": [
-71.7699,
42.1910
],
"alt": 251,
"gs": 317,
"type": "",
"isolated": False
},
{
"timestamp": 1548982401,
"coord": [
-71.7854,
42.1867
],
"alt": 252,
"gs": 319,
"type": "",
"isolated": False
},
{
"timestamp": 1548982415,
"coord": [
-71.8108,
42.1787
],
"alt": 254,
"gs": 321,
"type": "",
"isolated": False
},
{
"timestamp": 1548982434,
"coord": [
-71.8463,
42.1670
],
"alt": 257,
"gs": 324,
"type": "",
"isolated": False
},
{
"timestamp": 1548982464,
"coord": [
-71.9006,
42.1486
],
"alt": 262,
"gs": 325,
"type": "",
"isolated": False
},
{
"timestamp": 1548982502,
"coord": [
-71.9680,
42.1258
],
"alt": 269,
"gs": 326,
"type": "",
"isolated": False
},
{
"timestamp": 1548982524,
"coord": [
-72.0054,
42.1132
],
"alt": 273,
"gs": 328,
"type": "",
"isolated": False
},
{
"timestamp": 1548982562,
"coord": [
-72.0798,
42.0880
],
"alt": 279,
"gs": 328,
"type": "",
"isolated": False
},
{
"timestamp": 1548982600,
"coord": [
-72.1518,
42.0635
],
"alt": 284,
"gs": 332,
"type": "",
"isolated": False
},
{
"timestamp": 1548982630,
"coord": [
-72.2069,
42.0447
],
"alt": 288,
"gs": 334,
"type": "",
"isolated": False
},
{
"timestamp": 1548982651,
"coord": [
-72.2465,
42.0312
],
"alt": 291,
"gs": 337,
"type": "",
"isolated": False
},
{
"timestamp": 1548982681,
"coord": [
-72.3066,
42.0106
],
"alt": 295,
"gs": 340,
"type": "",
"isolated": False
},
{
"timestamp": 1548982711,
"coord": [
-72.3635,
41.9911
],
"alt": 300,
"gs": 342,
"type": "",
"isolated": False
},
{
"timestamp": 1548982741,
"coord": [
-72.4196,
41.9718
],
"alt": 304,
"gs": 344,
"type": "",
"isolated": False
},
{
"timestamp": 1548982771,
"coord": [
-72.4787,
41.9515
],
"alt": 309,
"gs": 342,
"type": "",
"isolated": False
},
{
"timestamp": 1548982801,
"coord": [
-72.5354,
41.9319
],
"alt": 314,
"gs": 342,
"type": "",
"isolated": False
},
{
"timestamp": 1548982831,
"coord": [
-72.5936,
41.9117
],
"alt": 318,
"gs": 342,
"type": "",
"isolated": False
},
{
"timestamp": 1548982861,
"coord": [
-72.6516,
41.8917
],
"alt": 321,
"gs": 345,
"type": "",
"isolated": False
},
{
"timestamp": 1548982891,
"coord": [
-72.7085,
41.8719
],
"alt": 327,
"gs": 344,
"type": "",
"isolated": False
},
{
"timestamp": 1548982911,
"coord": [
-72.7490,
41.8579
],
"alt": 330,
"gs": 342,
"type": "",
"isolated": False
},
{
"timestamp": 1548982931,
"coord": [
-72.7816,
41.8465
],
"alt": 331,
"gs": 344,
"type": "",
"isolated": False
},
{
"timestamp": 1548982970,
"coord": [
-72.8628,
41.8182
],
"alt": 335,
"gs": 345,
"type": "",
"isolated": False
},
{
"timestamp": 1548983010,
"coord": [
-72.9394,
41.7914
],
"alt": 339,
"gs": 348,
"type": "",
"isolated": False
},
{
"timestamp": 1548983045,
"coord": [
-73.0080,
41.7674
],
"alt": 340,
"gs": 349,
"type": "",
"isolated": False
},
{
"timestamp": 1548983074,
"coord": [
-73.0636,
41.7478
],
"alt": 340,
"gs": 348,
"type": "",
"isolated": False
}
],
"updateType": "",
"waypoints": [
[
-71.0100,
42.3600
],
[
-70.9700,
42.4400
],
[
-70.9700,
42.4400
],
[
-70.9400,
42.4400
],
[
-70.9400,
42.4400
],
[
-70.9100,
42.4500
],
[
-70.8500,
42.4600
],
[
-70.8400,
42.4600
],
[
-70.8400,
42.4600
],
[
-70.7600,
42.4300
],
[
-70.7500,
42.4200
],
[
-70.7500,
42.4000
],
[
-70.7500,
42.3900
],
[
-70.7300,
42.3000
],
[
-70.7700,
42.2800
],
[
-70.8300,
42.2400
],
[
-70.9500,
42.2000
],
[
-70.9700,
42.2000
],
[
-70.9700,
42.2000
],
[
-71.1900,
42.2000
],
[
-71.3300,
42.2100
],
[
-71.5100,
42.2100
],
[
-71.6000,
42.2100
],
[
-71.7600,
42.2200
],
[
-71.8600,
42.2100
],
[
-72.0600,
42.2000
],
[
-72.1200,
42.2000
],
[
-72.1700,
42.1900
],
[
-72.4900,
42.1800
],
[
-72.6000,
42.1700
],
[
-72.7200,
42.1600
],
[
-72.8000,
42.1200
],
[
-72.9000,
42.0600
],
[
-72.9900,
42.0000
],
[
-73.0700,
41.9600
],
[
-73.0900,
41.9300
],
[
-73.3200,
41.6600
],
[
-73.8000,
41.3400
],
[
-73.9100,
41.2700
],
[
-74.1000,
41.1400
],
[
-74.8200,
40.8000
],
[
-75.0800,
40.6800
],
[
-75.4000,
40.5400
],
[
-75.6400,
40.4200
],
[
-75.7900,
40.3600
],
[
-75.8300,
40.3400
],
[
-76.2900,
40.1200
],
[
-76.4800,
40.0300
],
[
-76.7000,
39.9300
],
[
-77.2300,
39.6800
],
[
-77.3100,
39.6500
],
[
-77.8500,
39.3900
],
[
-78.3800,
39.1800
],
[
-78.8600,
38.9800
],
[
-79.2000,
38.8400
],
[
-80.1700,
38.6600
],
[
-80.6100,
38.5800
],
[
-81.7700,
38.3500
],
[
-82.3200,
38.1900
],
[
-83.0300,
37.9900
],
[
-84.1600,
37.6500
],
[
-84.4300,
37.4600
],
[
-84.5100,
37.4000
],
[
-84.5200,
37.3900
],
[
-84.7300,
37.2400
],
[
-84.8000,
37.1900
],
[
-85.0000,
37.0500
],
[
-85.1000,
36.9700
],
[
-85.1600,
36.9300
],
[
-85.3900,
36.7600
],
[
-85.4000,
36.7500
],
[
-85.5300,
36.6900
],
[
-85.6500,
36.6300
],
[
-85.7900,
36.5700
],
[
-85.9200,
36.5100
],
[
-85.9700,
36.4800
],
[
-86.0000,
36.4700
],
[
-86.0400,
36.4500
],
[
-86.1000,
36.4200
],
[
-86.1700,
36.3900
],
[
-86.3300,
36.3100
],
[
-86.4600,
36.2400
],
[
-86.5000,
36.2200
],
[
-86.5200,
36.2200
],
[
-86.5300,
36.1800
],
[
-86.5400,
36.1700
],
[
-86.5400,
36.1500
],
[
-86.5600,
36.1100
],
[
-86.6100,
36.1100
],
[
-86.6800,
36.1200
]
]
}
}
}
}
}
ListOfJSON = [d1]
trackList=[]
columns = ['aircraftIdentifier','callSign','altitude','longitude','latitude','timestamp','groundSpeed','track','squawkCode','verticalClimbRate','aircraftType']
table = pd.DataFrame()
fa='faData'
a='value'
b='flights'
def getTrackData(data):
aircraftIdentifier = data['aircraftIdentifier']
for c in data[fa][a][b]:
call_Sign = c.split('-')
callSign = call_Sign[0]
aircraftType = data[fa][a][b][c]['aircraft']['type']
if type(data[fa][a][b][c]) == dict:
if 'track' in data[fa][a][b][c]:
j=0
for x in data[fa][a][b][c]['track']:
x['aircraftIdentifier'] = aircraftIdentifier +"_"+str(j)
x['callSign']=callSign+"_"+str(j)
x['longitude'] = x['coord'][0]
x['latitude'] = x['coord'][1]
x['aircraftType'] = aircraftType
j=j+1
trackList.append(data[fa][a][b][c]['track'])
for json in ListOfJSON:
getTrackData(json)
for x in trackList:
temp = pd.DataFrame(x)
table = table.append(temp,ignore_index=True)
table.drop(['coord','isolated','type'], axis=1, inplace=True)
table.rename(columns={'alt': 'altitude', 'gs': 'groundSpeed'}, inplace=True)
table['squawkCode']=""
table['track']=""
table['verticalClimbRate']=""
table = table.reindex_axis(columns, axis=1)
print(table)
# Discussion 4
# Precondition
def get_last(a):
return a[-1]
a = ['first item', 'second item', 'third item']
b = 'abcd'
print("## Precondition ##")
print("Output with list type argument: ", get_last(a))
print("Output with string type argument: ", get_last(b))
print()
# Postcondition
def get_last(a):
return a[2]
a = ['first item', 'second item', 'third item']
b = ['first item', 'second item', 'third item', 'fourth item']
print("## Postcondition ##")
print("Last item of list a: ", get_last(a))
print("Last item of list b: ", get_last(b))
# Unintended output
def get_second_item(a):
return a[1]
a = ['first item', ['list item'], 'third item']
b = ['first item', 'second item', 'third item']
concatinated_string1 = '"'+get_second_item(b)+'"'+' is a second item of list b'
print()
print(concatinated_string1)
print()
concatinated_string2 = '"'+get_second_item(a)+'"'+' is a second item of list a'
print(concatinated_string2)
print ("daisy"+"chain")
text = "tYpiNg"
print ("In capitals: "+text.upper())
print ("Lower case: "+text.lower())
print ("Tidied: "+text.capitalize())
print("Area of a rectangle")
length = float(input("250cm:\n"))
width = float(input("375cm:\n"))
area = round(length * width,1)
print("Area is",area,"cm square.")
print("angle of a triangle")
b = float(input("Enter b in degrees:\n"))
c = int(input("Enter c in degrees:\n"))
a = round(180-b-c,3)
print("Angle is",a,"degrees.")
print("Area of a triangle")
a = int(input("Enter a in degrees:\n"))
b = int(input("Enter b in degrees:\n"))
angle = round(length * width,1)
print("Angle is",area,"degrees.")
#Adventure Game Jason Peck
import random
print("You are lost underground in a maze of tunnels.")
dangerTunnel = random.randint(1,2)
tunnelChoice = int(input("Choose tunnel 1 or tunnel 2: "))
print("You chose tunnel ", tunnelChoice)
if tunnelChoice == dangerTunnel:
print("You entered a tunnel with a dragon. Watch out!")
else:
print("You entered an empty tunnel. You are safe for now.”)
# Hello World program in Python
print ("Hello World!");
#List Creation and append
num=[]
num.append(35)
num.append(12.5)
num.append("Hello")
print(num)
#Input and output
name=input("Enter Your Name""\n")
print(name)
num1=int(input("Enter First Number""\n"))
num2=int(input("Enter Second Number""\n"))
Multiplication=num1*num2
print("Result of Multiplication is:",Multiplication)
#Selection If, Elif, Else
num3=int(input("Enter a Number""\n"))
if(num3>10):
print("Entered number is greater than 10""\n")
elif(num3<10):
print("Entered Number is less than 10""\n")
else:
print("Entered Number is 10""\n")
We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy. Accept Learn more
