Python cell_convert示例

示例#1

文件： test_cell.py 项目： pierredittgen/frictionless-py

def test_step_cell_convert():
    source = Resource(path="data/transform.csv")
    source.infer()
    source.schema.get_field("id").type = "string"
    source.schema.get_field("population").type = "string"
    target = transform(
        source,
        steps=[
            steps.cell_convert(value="n/a"),
        ],
    )
    assert target.schema == source.schema
    assert target.read_rows() == [
        {
            "id": "n/a",
            "name": "n/a",
            "population": "n/a"
        },
        {
            "id": "n/a",
            "name": "n/a",
            "population": "n/a"
        },
        {
            "id": "n/a",
            "name": "n/a",
            "population": "n/a"
        },
    ]

示例#2

文件： test_cell.py 项目： pierredittgen/frictionless-py

def test_step_cell_convert_with_field_name():
    source = Resource(path="data/transform.csv")
    source.infer()
    target = transform(
        source,
        steps=[
            steps.cell_convert(value="n/a", field_name="name"),
        ],
    )
    assert target.schema == source.schema
    assert target.read_rows() == [
        {
            "id": 1,
            "name": "n/a",
            "population": 83
        },
        {
            "id": 2,
            "name": "n/a",
            "population": 66
        },
        {
            "id": 3,
            "name": "n/a",
            "population": 47
        },
    ]

示例#3

文件： test_cell_convert.py 项目： frictionlessdata/frictionless-py

def test_step_cell_convert():
    source = Resource(path="data/transform.csv")
    target = transform(
        source,
        steps=[
            steps.field_update(name="id", type="string"),
            steps.field_update(name="population", type="string"),
            steps.cell_convert(value="n/a"),
        ],
    )
    assert target.schema == {
        "fields": [
            {
                "name": "id",
                "type": "string"
            },
            {
                "name": "name",
                "type": "string"
            },
            {
                "name": "population",
                "type": "string"
            },
        ]
    }
    assert target.read_rows() == [
        {
            "id": "n/a",
            "name": "n/a",
            "population": "n/a"
        },
        {
            "id": "n/a",
            "name": "n/a",
            "population": "n/a"
        },
        {
            "id": "n/a",
            "name": "n/a",
            "population": "n/a"
        },
    ]

示例#4

def test_step_cell_convert_with_field_name():
    source = Resource(path="data/transform.csv")
    target = transform(
        source,
        steps=[
            steps.cell_convert(value="n/a", field_name="name"),
        ],
    )
    assert target.schema == {
        "fields": [
            {"name": "id", "type": "integer"},
            {"name": "name", "type": "string"},
            {"name": "population", "type": "integer"},
        ]
    }
    assert target.read_rows() == [
        {"id": 1, "name": "n/a", "population": 83},
        {"id": 2, "name": "n/a", "population": 66},
        {"id": 3, "name": "n/a", "population": 47},
    ]