Cleaning text data

Data Analysis in Google Sheets

James Chapman

Curriculum Manager, DataCamp

Cleaning text data

 

  • Who's your favorite DataCamp instructor?
james chapman
James
Jamez chapnam
    James   Chapman

A mop and bucket.

Data Analysis in Google Sheets

Changing cases - PROPER()

 

  • Proper case:
    • Example: This Is Proper Case
    • Used for names and addresses

 

= PROPER("neil armstrong")
Neil Armstrong
Data Analysis in Google Sheets

Changing cases - LOWER()

 

  • Lowercase:
    • Example: this is lowercase

 

= LOWER("Neil Armstrong")
neil armstrong
Data Analysis in Google Sheets

Changing cases - UPPER()

 

  • Uppercase:
    • Example: THIS IS UPPERCASE

 

= UPPER("Neil Armstrong")
NEIL ARMSTRONG
Data Analysis in Google Sheets

Removing whitespace

 

  • Extra whitespace:
    • Leading - space before text
    • Trailing - space after text
    • Repeated - >1 space between characters

 

= TRIM("   Neil   Armstrong   ")
Neil Armstrong
Data Analysis in Google Sheets

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Astronaut names.

Data Analysis in Google Sheets

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Astronaut names.

Data Analysis in Google Sheets

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Astronaut names.

Data Analysis in Google Sheets

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Astronaut names.

Data Analysis in Google Sheets

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Astronaut names.

Data Analysis in Google Sheets

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Astronaut names.

Data Analysis in Google Sheets

Combining text data - email addresses

 

Astronaut email addresses.

Data Analysis in Google Sheets

Combining text data - email addresses

 

Astronaut email addresses.

Data Analysis in Google Sheets

Combining text data - email addresses

 

Astronaut email addresses.

Data Analysis in Google Sheets

Combining text data - email addresses

 

Astronaut email addresses.

Data Analysis in Google Sheets

Combining text data - email addresses

 

Astronaut email addresses.

Data Analysis in Google Sheets

Combining text data - email addresses

 

Astronaut email addresses.

Data Analysis in Google Sheets

Combining text data - email addresses

 

Astronaut email addresses.

Data Analysis in Google Sheets

Let's practice!

Data Analysis in Google Sheets

Preparing Video For Download...