Se7enSquared
1/1/2020 - 8:44 PM

Standard Data Cleaning

# Column headers: Strip whitespace, replace spaces with underscores

lt_columns = laptops.columns
new_columns = []

for c in lt_columns:
  col = c.strip()
  if ' ' in col:
    col = col.replace(' ', '_')
  new_columns.append(col)
  
laptops.columns = new_columns

# rename columns headers
series.rename({'old value': 'new value'}, axis=1, inplace=True)