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.

from io import StringIO
import pandas as pd

csv_data = '''\
day,hits
2020-01-01,400
2020-02-02,800
2020-02-03,600
'''
df = pd.read_csv(StringIO(csv_data))
print(df['day'].dt.month.unique())

# Explanation
The comma-separated values (CSV) format does not have a schema. Everything
we read from it is a string. Pandas does a great job of guessing the data types inside the CSV, but sometimes it needs help.

We can use `.dtypes` to find out what types a `DataFrame` has, like this:
```py
In [3]: df.dtypes
Out[3]:
day object
hits int64
dtype: object
```
The `object` `dtype` usually means a `str` (Python string). The `read_csv` function has many parameters, including `parse_dates`.

The `parse_dates` use the `dateutil` parser to handle various formats. But, it also needs help sometimes. For example, is 1/5/2020 January 5 (US format) or May 1 (EU format)?

Let's find out how to read CSV data using pandas.

Before We Begin

Puzzles

Wrapping Up

Read CSV Data into Pandas DataFrames

Try it yourself

Explanation