How to check if a cell has a specific character in Pandas

Question

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.

I recommend taking a look at [my answer](https://stackoverflow.com/a/55335207/4909087) to the [linked duplicate](https://stackoverflow.com/questions/11350770/select-by-partial-string-from-a-pandas-dataframe). — cs95, Apr 02 '19 at 00:21

score 2 · Answer 1 · answered Apr 01 '19 at 23:43

2

I will using endswith

df.Longitude.str.endswith(('N','S'))
Out[77]: 
2014    False
2015    False
Name: Longitude, dtype: bool

answered Apr 01 '19 at 23:43

BENY

317,841
20
164
234

score 1 · Answer 2 · answered Apr 01 '19 at 23:23

Use the following:

# Example data
df = pd.DataFrame(index=['2014', '2015'], 
           columns = ['Latitude', 'Longitude'], 
           data = [['14.0N', '33.0W'],['22.0S', '12.0E']])
print(df)

     Latitude Longitude
2014    14.0N     33.0W
2015    22.0S     12.0E

Check if 'N' or 'S' is in each row of Longitude:

df.Longitude.str.contains('|'.join(['N', 'S']))

2014    False
2015    False
Name: Longitude, dtype: bool

How to check if a cell has a specific character in Pandas

2 Answers2