35、交通运输数据建模与分析

交通运输数据建模与分析

1. 乘客信息与航班维度

1.1 乘客概况

乘客概况数据包含了多个关键信息，如层级、家乡机场、俱乐部会员状态和终身里程数等。以下是部分示例数据：
| Key | Tier | Home Airport | Club Membership | Lifetime Mileage |
| — | — | — | — | — |
| 1 | Basic | ATL | Non - Member | Under 100,000 miles |
| 2 | Basic | ATL | Club Member | Under 100,000 miles |
| 3 | Basic | BOS | Non - Member | Under 100,000 miles |
| 789 | MidTier | ATL | Non - Member | 100,000 - 499,999 miles |
| 790 | MidTier | ATL | Club Member | 100,000 - 499,999 miles |
| 791 | MidTier | BOS | Non - Member | 100,000 - 499,999 miles |
| 2468 | WarriorTier | ATL | Club Member | 1,000,000 - 1,999,999 miles |
| 2469 | WarriorTier | ATL | Club Member | 2,000,000 - 2,999,999 miles |
| 2470 | WarriorTier