Python check_column_namesの例

コード例 #1

def validate_pm_non_exhaust_yeti_format_traffic_data(filename):

    data = pd.read_csv(filename)

    check_separator_is_comma(filename)
    check_column_names(filename, data, ["LinkID", "DayType", "Dir", "Hour"])
    check_does_not_contain_nan(filename, data)

コード例 #2

def validate_yeti_format_vehicle_data(filename):

    data = pd.read_csv(filename)

    check_separator_is_comma(filename)
    check_column_names(filename, data, ["VehicleName", "VehicleCategory", "NumberOfAxles"])
    check_categories_are_correct(filename, data, "VehicleCategory", [str(cat) for cat in VehicleCategory])
    check_does_not_contain_nan(filename, data[["VehicleName", "VehicleCategory"]])

コード例 #3

def validate_veh_mapping(filename):

    data = pd.read_csv(filename)

    check_separator_is_comma(filename)
    check_column_names(filename, data, [
        "VehCat", "Fuel", "VehSegment", "EuroStandard", "Technology", "VehName"
    ])

コード例 #4

def validate_yeti_format_hbefa_emission_factor_data(filename):

    data = pd.read_csv(filename)

    check_separator_is_comma(filename)
    check_column_names(filename, data, ["VehicleName", "Pollutant", "TrafficSituation", "EF"])
    check_does_not_contain_nan(filename, data)
    check_categories_are_correct(filename, data, "Pollutant", [str(poll) for poll in PollutantType])

コード例 #5

def validate_yeti_format_link_data(filename):

    data = pd.read_csv(filename)

    check_separator_is_comma(filename)
    check_column_names(filename, data, ["LinkID", "Length", "AreaType", "RoadType", "MaxSpeed"])
    check_categories_are_correct(filename, data, "AreaType", ["AreaType.Urban", "AreaType.Rural"])
    check_does_not_contain_nan(filename, data)
    check_column_values_above_zero(filename, data, ["MaxSpeed", "Length"])

コード例 #6

def validate_yeti_format_traffic_data(filename):

    data = pd.read_csv(filename)

    check_separator_is_comma(filename)
    check_column_names(filename, data, ["LinkID", "DayType", "Dir", "Hour", "LOS1Percentage",
                                        "LOS2Percentage", "LOS3Percentage", "LOS4Percentage"])
    check_are_perc_columns(filename, data, ["LOS1Percentage", "LOS2Percentage",
                                            "LOS3Percentage", "LOS4Percentage"])
    check_does_not_contain_nan(filename, data)

コード例 #7

def validate_cold_ef_table(filename):

    data = pd.read_csv(filename)

    check_separator_is_comma(filename)
    check_column_names(filename, data, [
        "VehSegment", "Pollutant", "MinSpeed", "MaxSpeed", "MinTemp",
        "MaxTemp", "A", "B", "C"
    ])
    check_categories_are_correct(filename, data, "Pollutant",
                                 ["CO", "NOx", "VOC"])
    check_categories_are_correct(
        filename, data, "VehSegment",
        ["Mini", "Small", "Medium", "Large-SUV-Executive"])