import csv
# Define the mapping from the old header to the new header
field_mapping = {
    'ms_today': 'Time(s)',
    'input_voltage': 'Voltage',
    'temp_mos_max': 'T-Mosfet',
    'temp_motor': 'T-Mot',
    'current_motor': 'I-Motor',
    'current_in': 'I-Battery',
    'duty_cycle': 'Duty%',
    'amp_hours_used': 'Ah',
    'amp_hours_charged': 'Ah Charged',
    'watt_hours_used': 'Wh',
    'watt_hours_charged': 'Wh Charged',
    'erpm': 'ERPM',
    'fault_code': 'Motor-Fault',
    'vesc_id': 'State(num)',
    'roll': 'Roll',
    'pitch': 'Pitch',
    'speed_meters_per_sec': 'Speed(mph)',
    'gnss_lat': 'GPS-Lat',
    'gnss_lon': 'GPS-Long',
    'gnss_hAcc': 'GPS-Accuracy',
    'gnss_alt': 'Altitude(m)',
    # Add other mappings as needed
}

# Define the new header order
new_header = ['Time(s)', 'State', 'Distance(mi)', 'Speed(mph)', 'Duty%', 'Voltage', 'I-Battery', 'I-Motor', 'I-FldWeak',
              'Requested Amps', 'Pitch', 'Roll', 'Setpoint', 'SP-ATR', 'SP-Carve', 'T-Mosfet', 'T-Mot', 'ADC1', 'ADC2',
              'Motor-Fault', 'Ah', 'Ah Charged', 'Wh', 'Wh Charged', 'ERPM', 'Altitude(m)', 'State(num)', 'True Pitch',
              'SP-TrqTlt', 'SP-BrkTlt', 'SP-Remote', 'T-Batt', 'I-Booster', 'GPS-Lat', 'GPS-Long', 'GPS-Accuracy']

def convert_file(input_file_path):
    output_file_path = input_file_path.replace('.csv', '_converted.csv').replace('.txt', '_converted.csv')

    with open(input_file_path, mode='r', newline='', encoding='utf-8') as infile, \
            open(output_file_path, mode='w', newline='', encoding='utf-8') as outfile:

        reader = csv.DictReader(infile, delimiter=';')
        writer = csv.DictWriter(outfile, fieldnames=new_header)

        # Write the new header to the output file
        writer.writeheader()

        for row in reader:
            # Create a new row with the new header and mapped data
            new_row = {new_field: row.get(old_field, '') for old_field, new_field in field_mapping.items()}

            # Scale the duty cycle by 100 if it exists in the row
            if 'Duty%' in new_row and new_row['Duty%']:
                try:
                    new_row['Duty%'] = float(new_row['Duty%']) * 100
                except ValueError:
                    new_row['Duty%'] = ''  # Handle cases where the value is not a number

            writer.writerow(new_row)

    print(f"Conversion completed successfully. Converted file saved as: {output_file_path}")

# Usage example
convert_file('2024-10-10_12-54-08.csv')```