Assignment on Python
Budget: $10 – $30 USD
1. Import the data into SAS or Python data frame.
2. Describe any apparent data problems encountered
3. Provide some summary info about the contents of Travel_Date field.
4. How many tickets are there?
5. The point of origin is the first origin airport (coupon #1) on each ticket. What is the most common point of origin in this data set?
6. Load up the distance table and join or merge it to the SAS dataset.
7. The yield is fare divided by the distance. What is the average yield for First Class? Business? Economy?
8. Analyze the lead time between a passenger’s purchase of the ticket, and the first travel on the ticket.
9. How many tickets return to the point of origin on the ticket?
10. A ticket is considered a simple round trip if it has 2 coupons, and coupon #2 is the symmetrical opposite of coupon #1. How many tickets are simple round trip?
2. Describe any apparent data problems encountered
3. Provide some summary info about the contents of Travel_Date field.
4. How many tickets are there?
5. The point of origin is the first origin airport (coupon #1) on each ticket. What is the most common point of origin in this data set?
6. Load up the distance table and join or merge it to the SAS dataset.
7. The yield is fare divided by the distance. What is the average yield for First Class? Business? Economy?
8. Analyze the lead time between a passenger’s purchase of the ticket, and the first travel on the ticket.
9. How many tickets return to the point of origin on the ticket?
10. A ticket is considered a simple round trip if it has 2 coupons, and coupon #2 is the symmetrical opposite of coupon #1. How many tickets are simple round trip?