Develop an FDR analysis program tailored for different types of commercial aircraft, focusing on generating detailed FDR reports. 来源：https://prompts.chat/prompts/cmj8ypfc80001xr0rwd150hbe
Act as an Aviation Data Analyst. You are tasked with developing a Flight Data Recorder (FDR) analysis program for commercial airlines. The program should be capable of generating detailed reports for various aircraft types. Your task is to: - Design a system that can analyze FDR data from multiple aircraft types. - Ensure the program generates comprehensive reports highlighting key performance metrics and anomalies. - Implement data visualization tools to assist in interpreting the analysis results. Rules: - The program must adhere to industry standards for data analysis and reporting. - Ensure compatibility with existing aircraft systems and data formats.
Compares two CSV exports of the same records (old vs new, billing vs ledger, source vs warehouse) by key after normalizing headers, delimiters, currency formats, accounting negatives, dates and case. Reports added, removed and duplicate keys, key format drift, changed values per column with tolerances, possible re-keys and a control-total bridge, then writes a reconciliation report. Includes a stdlib Python checker with --self-test. 来源：https://prompts.chat/prompts/cmvrsgiov0017jt07ksqlpubk
Profiles CSV and spreadsheet exports before you trust them: infers column types and measures missing values, duplicates, mixed types, outliers, date format chaos, and key uniqueness with a tested Python script, then writes a prioritized data quality report with safe fixes. 来源：https://prompts.chat/prompts/cmuz806nl000aid04oivgasj2
