Jan-08-2023, 05:44 AM
Hi! I have a column of a dataframe with city names in capital letters and I wanted to compare it with the cities column of another dataframe with regular letters. It would be like a join. Join the two columns to compare the values and search if any of them are missing. Below an example of the columns and values:
df1([CITY])
df1
CITY
WASHINGTON D.C.
NEW YORK
SAN DIEGO
df2([City])
df2
City
Washington D.C.
New York
San Diego
df1([CITY])
df1
CITY
WASHINGTON D.C.
NEW YORK
SAN DIEGO
df2([City])
df2
City
Washington D.C.
New York
San Diego