python pandas loc return empty dataframe

Question

I am trying to get the subset dataframe using the below code:

dprev = "eiffel tower"

df.loc[df['place'] == dprev] -> returns empty

drandom = random.choice(df['place'].unique())

df.loc[df['place'] == drandom] -> returns the subset

why am i not seeing the same thing when dprev is string variable?

Destination MinTime Max Time Les Halles 18 32 Av. des Champs Elysees 23 27 Avenue Victoria, Paris, France 15 28 Aquarium Tropical, 293 Avenue Daumesnil, 75012 Paris 3 7 Avenue de la République, 75011 Paris, France 12 22 Bd Peripherique 8 16 Boulevard de l'hspital 9 18 Eiffel Tower View, 76 BIS rue de la Federation, 75015 Paris, France 23 23 — user3779226, Jun 01 '18 at 10:18
Kindly edit your post and put the data in your post properly. — Sumit S Chawla, Jun 01 '18 at 10:20
In your data , it is "Eiffel Tower View" and you are checking "eiffel tower". Is your data correct? — Sumit S Chawla, Jun 01 '18 at 10:23

score 1 · Accepted Answer · answered Jun 01 '18 at 10:17

1

Can you try using str.contains with case=False

Ex:

import pandas as pd

dprev = "eiffel tower"
df = pd.DataFrame({"place": ["eiffel tower", "Eiffel tower", "Hello"], "data":[1,2,3]})
print(df.loc[df['place'].str.contains(dprev, case=False)])

Output:

   data         place
0     1  eiffel tower
1     2  Eiffel tower

answered Jun 01 '18 at 10:17

Rakesh

81,458
17
76
113

Hi Rakesh, tried with the case = False, but ended with empty dataframe. To help further this time - dprev = Avenue Victoria, Paris, France Is the comma is creating issue? – user3779226 Jun 01 '18 at 10:47
Can you post a sample of you csv in your question... I am not able to understand the data in your comment. – Rakesh Jun 01 '18 at 10:48
Can you post your DF also? – Rakesh Jun 01 '18 at 11:04

Nihal · Answer 2 · 2018-06-01T10:16:55.407

0

for this you don't have to use df.loc

dprev = "eiffel tower"

df[df['place'] == dprev]

See this answer

edited Jun 01 '18 at 10:16

answered Jun 01 '18 at 10:09

Nihal

5,262
7
23
41

Hi Nihal,tried without loc, but still returns empty dataset. – user3779226 Jun 01 '18 at 10:11

Joe · Answer 3 · 2018-06-01T10:38:55.157

0

Try in this way:

dprev = "eiffel tower"
df = df.loc[df['place'].str.lower() == dprev]

or:

df = df.loc[df['place'].str.lower().str.contains(dprev)]

edited Jun 01 '18 at 10:38

answered Jun 01 '18 at 10:32

Joe

12,057
5
39
55

python pandas loc return empty dataframe

3 Answers3