Explore puzzles designed to enhance your critical thinking and problem-solving skills using pandas. Gain insights into common pitfalls and sharpen your data manipulation techniques.

test.tar.gz

test

test2

Puzzles are a great way to practice your critical thinking and problem-solving skills. This course assumes a basic understanding of pandas.  The teasers and puzzles in this course are designed to help you practice what you already know and help avoid future mistakes.

Pandas Brain Teasers

# Guess the output
Try to guess the output of the code below:


import pandas as pd

df1 = pd.DataFrame({
  'id': [1, 2, 3],
  'name': ['Clark Kent', 'Diana Prince', 'Bruce Wayne'],
})

df2 = pd.DataFrame({
  'id': [2, 1, 4],
  'hero': ['Wonder Woman', 'Superman', 'Aquaman'],
})

df = pd.merge(df1, df2, on='id')
print(df)

```py
    id   name            hero

0   1    Clark Kent      Wonder Woman

1   2    Diana Prince    Superman
```


```py
    id   name            hero

0   1    Clark Kent      Superman

1   2    Diana Prince    Wonder Woman
```


```py
    id   name            hero

0   1    Clark Kent      Wonder Woman

1   2    Diana Prince    Superman

2   3    Bruce Wayne     Aquaman
```

Before We Begin

Puzzles

Wrapping Up

Puzzle 22: Quick, Find a Phone Booth!

Guess the output