1 of 30

Query Examples

2 of 30

Original DataFrame

3 of 30

4 of 30

5 of 30

Series containing a True boolean if age is above 5, False otherwise

6 of 30

Series containing a True boolean if age is above 5, False otherwise

7 of 30

Series containing a True boolean if age is above 5, False otherwise

8 of 30

Series containing True if names shorter than 12 characters, False otherwise

Series containing a True boolean if age is above 5, False otherwise

9 of 30

Series containing True if names shorter than 12 characters, False otherwise

Series containing a True boolean if age is above 5, False otherwise

10 of 30

series

Series containing True if names shorter than 12 characters, False otherwise

Series containing a True boolean if age is above 5, False otherwise

11 of 30

12 of 30

&

13 of 30

&

“&” indicates ‘and,’ so we are looking for both cases being True

14 of 30

&

“&” indicates ‘and,’ so we are looking for both cases being True

15 of 30

&

“&” indicates ‘and,’ so we are looking for both cases being True

16 of 30

&

“&” indicates ‘and,’ so we are looking for both cases being True

17 of 30

&

“&” indicates ‘and,’ so we are looking for both cases being True

18 of 30

&

“&” indicates ‘and,’ so we are looking for both cases being True

19 of 30

&

“&” indicates ‘and,’ so we are looking for both cases being True

20 of 30

21 of 30

|

22 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

23 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

24 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

25 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

26 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

27 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

28 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

29 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True

30 of 30

|

“|” indicates ‘or,’ so we are looking for either cases to be True