This is a simple Python program that calculates the total pay1 (hourly pay + per diem) for each line in a flight attendant bid packet. It then ranks the lines according to total pay (from greatest to least).
It uses pandas to read in data from Excel. It then creates an class instance for each line in the bid packet and calculates the total pay for each line. The line objects are then sorted by total pay (from greatest to least) and converted back into a pandas DataFrame. The sorted DataFrame is formatted and saved as an HTML file which is then converted into a PDF document using pdfkit.
class Line
Attributes:
line_number (int): The monthly bid line number.
credit (int): The total credit hours for the line.
tafb (int): The 'time away from base' for the line.
crew (int): The number of crew positions for the line.
position (str): The position, FMP or FA, to bid for the line.
pay_credit (float): The hourly pay + purser pay + international (Central America) pay, for the line.
per_diem (float): The per diem pay for the line.
pay_total (float): The total pay value for the line (hourly + per diem).
class PurserLine
Child of class Line.
Attributes:
Inherits from parent class.
Sets position attribute to "FMP".
class FALine
Child of class Line.
Attributes:
Inherits from parent class.
Sets position attribute to "Any FA".
- iMac Pro
- 10-core Intel Xenon Processor
- 64 GB RAM (2666 MHz DDR4)
- Radeon Pro Vega 56 8 GB
- PyCharm
- Python 3.7
- pandas 1.0.5
- pdfkit 0.6.1
1 Total Pay does not include Trip Rig Time pay or Wide Body Purser pay . ↩