6.1. Method Chaining

6.1.1. Inplace

DATA = [1, np.nan, 5, np.nan, 1, 2, 1, np.inf]

s = pd.Series(DATA)
s.fillna(0, inplace=True)
s.drop([2,4,6], inplace=True)
s.drop_duplicates(inplace=True)
s.reset_index(drop=True, inplace=True)
s
# 0    1.0
# 1    0.0
# 2    2.0
# 3    inf
# dtype: float64

6.1.2. Endl

DATA = [1, np.nan, 5, np.nan, 1, 2, 1, np.inf]

s = pd.Series(DATA) \
        .fillna(0) \
        .drop([2,4,6]) \
        .drop_duplicates() \
        .reset_index(drop=True)

s
# 0    1.0
# 1    0.0
# 2    2.0
# 3    inf
# dtype: float64

6.1.3. Chain

DATA = [1, np.nan, 5, np.nan, 1, 2, 1, np.inf]

s = (pd.Series(DATA)
        .fillna(0)
        .drop([2,4,6])
        .drop_duplicates()
        .reset_index(drop=True))

s
# 0    1.0
# 1    0.0
# 2    2.0
# 3    inf
# dtype: float64

6.1.4. Example

DATA = ['ul.Mieszka II',
        'UL. Zygmunta III WaZY',
        '  bolesława chrobrego ',
        'ul Jana III SobIESkiego',
        '\tul. Jana trzeciego Sobieskiego',
        'ulicaJana III Sobieskiego',
        'UL. JA    NA 3 SOBIES  KIEGO',
        'ULICA JANA III SOBIESKIEGO  ',
        'ULICA. JANA III SOBIeskieGO',
        ' Jana 3 Sobieskiego  ',
        'Jana III Sobi  eskiego ']

def clean(text):
    text = text.strip()
    text = text.upper()
    text = text.replace('\t', '')
    text = text.replace('\n', '')
    text = text.replace('    ', '')
    text = text.replace('   ', '')
    text = text.replace('  ', '')
    text = text.replace('.', '')
    text = text.replace(',', '')
    text = text.replace('\\', '')
    text = text.replace('ULICA', '')
    text = text.replace('UL', '')
    text = text.replace('TRZECIEGO', 'III')
    text = text.replace('3', 'III')
    text = text.title()
    text = text.replace('Iii', 'III')
    text = text.replace('Ii', 'II')
    return text.strip()


s = pd.Series(DATA)
s.apply(clean)

DATA = ['ul.Mieszka II',
        'UL. Zygmunta III WaZY',
        '  bolesława chrobrego ',
        'ul Jana III SobIESkiego',
        '\tul. Jana trzeciego Sobieskiego',
        'ulicaJana III Sobieskiego',
        'UL. JA    NA 3 SOBIES  KIEGO',
        'ULICA JANA III SOBIESKIEGO  ',
        'ULICA. JANA III SOBIeskieGO',
        ' Jana 3 Sobieskiego  ',
        'Jana III Sobi  eskiego ']

def clean(text):
    return (text
            .strip()
            .upper()
            .replace('\t', '')
            .replace('\n', '')
            .replace('    ', '')
            .replace('   ', '')
            .replace('  ', '')
            .replace('.', '')
            .replace(',', '')
            .replace('\\', '')
            .replace('ULICA', '')
            .replace('UL', '')
            .replace('TRZECIEGO', 'III')
            .replace('3', 'III')
            .title()
            .replace('Iii', 'III')
            .replace('Ii', 'II')
            .strip())


s = pd.Series(DATA)
s.apply(clean)

6.1.6. Assignments

Todo

Create assignments