Python IsNull Examples

Example #1

File: worldcup_wrangler.py Project: jeffchan/asciiclass

# Delete  rows where Nation is null
w.add(
    dw.Filter(column=[],
              table=0,
              status="active",
              drop=False,
              row=dw.Row(column=[],
                         table=0,
                         status="active",
                         drop=False,
                         conditions=[
                             dw.IsNull(column=[],
                                       table=0,
                                       status="active",
                                       drop=False,
                                       lcol="Nation",
                                       value=None,
                                       op_str="is null")
                         ])))

# Fold split, split2, split3, split4...  using  header as a key
w.add(
    dw.Fold(column=["split", "split2", "split3", "split4", "split5"],
            table=0,
            status="active",
            drop=False,
            keys=[-1]))

# Drop fold
w.add(dw.Drop(column=["fold"], table=0, status="active", drop=True))

Example #2

File: worldcup_wrangler.py Project: colin2328/asciiclass

              method="copy",
              row=None))

# Delete  rows where extract is null
w.add(dw.Filter(column=[],
                table=0,
                status="active",
                drop=False,
                row=dw.Row(column=[],
             table=0,
             status="active",
             drop=False,
             conditions=[dw.IsNull(column=[],
                table=0,
                status="active",
                drop=False,
                lcol="extract",
                value=None,
                op_str="is null")])))

# Delete  rows where extract = '5'
w.add(dw.Filter(column=[],
                table=0,
                status="active",
                drop=False,
                row=dw.Row(column=[],
             table=0,
             status="active",
             drop=False,
             conditions=[dw.Eq(column=[],
            table=0,

Example #3

File: wrangling_wiki.py Project: EdenBD/How-To-Win-Eurovision

# Delete  rows where song is null
w.add(
    dw.Filter(column=[],
              table=0,
              status="active",
              drop=False,
              row=dw.Row(column=[],
                         table=0,
                         status="active",
                         drop=False,
                         conditions=[
                             dw.IsNull(column=[],
                                       table=0,
                                       status="active",
                                       drop=False,
                                       lcol="song",
                                       value=None,
                                       op_str="is null")
                         ])))

# Set  extract  name to  year
w.add(
    dw.SetName(column=["extract"],
               table=0,
               status="active",
               drop=True,
               names=["year"],
               header_row=None))

w.apply_to_file(sys.argv[1]).print_csv(sys.argv[2])