import pandas as pd
s = pd.read_csv('sample.csv')

s

%load_ext pandawash

%groupcol s.Category

# Modify the mapping below to group equivalent values
s.Category = s.Category.map({
  'A': 'A',
  'B': 'B',
  'C': 'C',
  'c': 'C',
})

%numbercol s.Wholenum int

# Fill in the replacements below
s.Wholenum = s.Wholenum\
    .fillna(value=0)\
    .replace('four', '4')\
    .replace('<1', '1')\
  .astype(int)

%numbercol s.Decimal float

# Fill in the replacements below
s.Decimal = s.Decimal\
    .replace('>0', '0.1')\
  .astype(float)

%boundscheckcol s.Year 1900-2100

# Fill in the replacements below
s.Year = s.Year\
  .replace(20014, 2014)\
  .replace(210, 2010)

s