sfu-db / dataprep

Open-source low code data preparation library in python. Collect, clean and visualization your data in python with a few lines of code.
http://dataprep.ai
MIT License
2.07k stars 206 forks source link

clean_au_abn returns an empty frame #986

Open dfxvir opened 6 months ago

dfxvir commented 6 months ago

Describe the bug clean_au_abn returns an empty frame, whereas validate_au_abn works fine

To Reproduce Steps to reproduce the behavior:

import pandas as pd
import numpy as np
from dataprep.clean import *

df = pd.DataFrame(
    {
        "abn": [
            "83 914 571 673",
            "99 999 999 999",
            "51824753556",
            "51 824 753 556",
            "hello",
            np.nan,
            "NULL"
        ],
        "address": [
            "123 Pine Ave.",
            "main st",
            "1234 west main heights 57033",
            "apt 1 789 s maple rd manhattan",
            "robie house, 789 north main street",
            "(staples center) 1111 S Figueroa St, Los Angeles",
            "hello",
        ]
    }
)

df_out=clean_au_abn(df, "abn")

df_out

Expected behavior one dataframe with input records

Desktop (please complete the following information):