Main Content

convertedTable

Create converted table from truth data

Since R2025a

    Description

    cTable = convertedTable(importer,source) returns a converted table based on the source input. The truth log structures are useful for metric evaluation.

    example

    [cTable,info] = convertedTable(importer,source) also returns info, which contains the platform IDs and class IDs mapping tables.

    Examples

    collapse all

    Loads a saved truth TrackingTruthDataImporter object and displays the object properties. For more information on the creation of the TrackingTruthDataImporter object, see the Import Data Using Tracking Data Importer App example.

    load truthImporterFile.mat;
    truthImporter
    truthImporter = 
    TrackingTruthDataImporter with configurations:
    
    Converter Name: FlightLog1
    Input File Format: spreadsheet
    Input Data Information: 
            Category:  Flight Log
          Frame Type:  Local NED
    
    Elements and Mapping: 
         State Element     Unit       Original Column     Unit(Format)                         
         -------------     ------     ---------------     -------------------------------------     
         Date Time         sec        time                datetime string(dd-MMM-yyyy HH:mm:ss)
         Latitude          degree     latitude            degree                               
         Longitude         degree     longitude           degree                               
         Altitude          m          altitude            ft                                   
         Speed             m/s        speed               mi/h                                 
         Course            degree     course              degree                               
         Climb Rate        m/s        climbrate           ft/m                                 
    
    Output Data Information: 
          Coordinate Type:  Cartesian
               Frame Type:  ECEF
    
    Usage: 
          trackingScenarioRecording:  Export as a trackingScenarioRecording object for playing and metric evaluation
                           truthlog:  Export as a truth log structure for metric evaluation
                         tuningData:  Export as a tuning data structure for tracking filter turning
                     convertedTable:  Export converted table
    
    

    Apply the truthImporter object to a flight log named LAToBostonFlightLog.xlsx, to get a convertedTable.

    convertedTable(truthImporter,"LAToBostonFlightLog.xlsx")
    ans=592×7 table
             Date Time         Latitude(degree)    Longitude(degree)    Altitude(m)    Speed(m/s)    Course(degree)    Climb Rate(m/s)
        ___________________    ________________    _________________    ___________    __________    ______________    _______________
    
        2024-10-01 00:00:00         33.947              -118.43           67.455          83.15         -99.005            5.1484     
        2024-10-01 00:00:16         33.945              -118.45           134.76         89.408         -97.281            2.9937     
        2024-10-01 00:00:32         33.944              -118.46           171.94          105.5         -95.453            2.8752     
        2024-10-01 00:00:48         33.942              -118.48           232.27         116.68         -92.076            3.9885     
        2024-10-01 00:01:05         33.941              -118.51           304.33         127.41         -99.498            4.2966     
        2024-10-01 00:01:21         33.935              -118.53              374         131.88         -123.79            5.0531     
        2024-10-01 00:01:39         33.917              -118.54           483.17         136.35         -162.69            5.2546     
        2024-10-01 00:01:56         33.897              -118.55           562.15         141.26          177.73            4.9735     
        2024-10-01 00:02:23         33.862              -118.54           708.45         146.63          171.51            5.6726     
        2024-10-01 00:02:53          33.82              -118.53           887.31         147.52          173.27            4.9681     
        2024-10-01 00:03:23         33.782              -118.53           1015.1         152.89          175.96            2.3517     
        2024-10-01 00:03:53         33.738              -118.52           1063.8         174.35          170.01            2.3006     
        2024-10-01 00:04:09         33.711              -118.51           1119.5          189.1           151.5            3.6634     
        2024-10-01 00:04:27         33.689              -118.49           1189.2         200.72          126.51            4.2575     
        2024-10-01 00:04:48         33.672              -118.45           1289.1         207.87          110.37            4.1762     
        2024-10-01 00:05:23         33.653              -118.37           1416.8         215.47          101.94            3.7983     
          ⋮
    
    

    Input Arguments

    collapse all

    Tracking truth data importer, specified as a TrackingTruthDataImporter object. You can use the Tracking Data Importer app to create these objects.

    Data source to read, specified as a string scalar representing the path to a data file, or as a MATLAB table or timetable from workspace.

    For details on the exact format requirements for the file or table, see the display of the importer object.

    Example: "./flight_log.csv"

    Output Arguments

    collapse all

    Converted table, returned as a table.

    Platform IDs and class IDs mapping information, returned as a structure that contains two fields:

    • PlatformIDMapping — Mapping relationship between platform IDs in the source and exported platform IDs, returned as a dictionary object.

    • ClassIDMapping — Mapping relationship between class IDs in the source and exported class IDs, returned as a dictionary object.

    Version History

    Introduced in R2025a