3. String clean up

Question 1

applying string method on df

Answer 1

df[“Col”].str.lower()

df[“Name”].str.lower().str.title()

Question 2

filter something in string

Answer 2

df[“Col”].str.contains(“water”)
startswith
endswith

Question 3

remove white space

Answer 3

strip(), l/r strip()

Question 4

applyin string method on index

Answer 4

df.index = df.index.str.strip().str.title()

Question 5

find first name in a full name string

Answer 5

df[“Name”].str.split(“,”).str.get(0)

note this “get” is pandas specific

df[“Name”].str.split(“,”).str.get(1).str.strip().str.split().str.get(0)

Question 6

expanding a split

Answer 6

df[“Name”].str.split(“,”, expand = True)
return new df

df[[“First Name”,”Last Name”]] = df[“Name”].str.split(“,”, expand = True)

df[[“First Name”,”Last Name”]] = df[“Name”].str.split(“,”, expand = True, n=1)

Question 7

merging

Answer 7

df[“New Name”] = df[“First Name”] + “ “ + df[“Last Name”].str.strip()