topic Re: Combine rows within table based on if there is any data populated- Using Python in Python Questions

Combine rows within table based on if there is any data populated- Using Python

BrianneStafford1 — Wed, 26 Apr 2017 20:13:30 GMT

Basically I am focusing on 2 fields.

fields[0] = Apple

fields[1] = Grape

fields[2] = Pear

What I want in English:

If Apple has data and Pear has no data

Pear = Apple

If Grape has data and Pear has no data

Pear = Grape

Otherwise: Pear = Pear

*All 3 columns will never be populated, as well as Apple and Grape will never be populated simultaneously

I tried making up a script using Notepad ++ but it is not translating at all and the results are just reading the columns as their original data.

I know this is wrong but I do not know what would be right.

Thanks

Re: Combine rows within table based on if there is any data populated- Using Python

JoshuaBixby — Wed, 26 Apr 2017 21:35:46 GMT

Since Apple and Grape will never be populated simultaneously, and you only want to populate Pear if it has no data, the following should work in the Field Calculator expression (make sure to select Python parser):

(!Apple! or !Grape!) if !Pear! is None else !Pear!‍

The above is using a Python Conditional Expression, a.k.a., ternary operator.

Re: Combine rows within table based on if there is any data populated- Using Python

DanPatterson_Retired — Fri, 10 Dec 2021 21:49:36 GMT

Based on you description, you have limited possibilities of combinations, hence, have a look at this to ensure that you aren't missing any possibilities

rows = [['A', None, None],
        [None, 'G', None],
        [None, None, 'P'],
        [None, None, None]
        ]
for row in rows:
    if row[2] is None:
        row[2] = [row[0], row[1]][row[0] is None]
    print("row... {}".format(row))

# which yields...

row... ['A', None, 'A']
row... [None, 'G', 'G']
row... [None, None, 'P']
row... [None, None, None]‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Combine rows within table based on if there is any data populated- Using Python

DarrenWiens2 — Wed, 26 Apr 2017 21:57:19 GMT

At some point, you'll also have to change your fields list to include strings, not unspecified variables:

fields = ['Apple','Grape','Pear']‍‍

Also, you need to call the following to actually update the row:

cursor.updateRow(row)‍