So I have a dataframe that looks like this:
import pandas as pd
df = pd.df[index=['2014', '2015', '2016'], columns = ['Latitude', 'Longitude'], data = ['14.0N', '33.0W'],['22.0S', '12.0E']]
I want to go through and check the cells in the longitude column if they have an N or an S.