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

# Try it yourself
Try executing the code below to see the result.

import pandas as pd

y3k = pd.Timestamp(3000, 1, 1)
print(f'They arrived to Earth on {y3k:%B %d}.')

# Explanation
Computers and time have a complicated relationship because of timezones, leap years, and in some places, daylight saving times. Computers store time information by recording the number of seconds since January 1, 1970, GMT, a process known as **epoch time**.


>**Note:** Because of how computers store time, time will overflow on 32-bit machines in 2038, a formatting bug known as the **Year 2038 problem**. Ouch!

Python’s `datetime` and `pandas.Timestamp` are designed around the way computers currently store time and are mostly written in C. There is also a fixed amount of space for storing time information. This
means there’s a maximum and minimum value to `datetime`.
```py
In [1]: pd.Timestamp.min
Out[1]: Timestamp('1677-09-21 00:12:43.145225')
In [2]: pd.Timestamp.max
Out[2]: Timestamp('2262-04-11 23:47:16.854775807')
```
The date in this teaser is more than the maximum  `pandas.Timestamp`
value. This is documented under the "Timestamp Limitations" section in the pandas documentation.



import pandas as pd

y3k = pd.Timestamp(2023, 1, 1)
print(f'They arrived to Earth on {y3k:%B %d}.')

Let's find out how pandas Timestamp works in Python.

Before We Begin

Puzzles

Wrapping Up

Create a Pandas Timestamp Object

Try it yourself

Explanation

Solution