Pandas Brain Teasers/

...

/

Implicit Line Joining

Implicit Line Joining

Let’s learn how to perform different operations with pandas DataFrame values.

We'll cover the following...

Try it yourself

Try executing the code below to see the result.

Press + to interact
import pandas as pd
df = pd.DataFrame([
  ['133.43.96.45', pd.Timedelta('3s')],
  ['133.68.18.180', pd.Timedelta('2s')],
  ['133.43.96.45', pd.NaT],
  ['133.43.96.45', pd.Timedelta('4s')],
  ['133.43.96.45', pd.Timedelta('2s')],
], columns=['ip', 'duration'])
by_ip = (
  df['duration']
  .fillna(pd.Timedelta(seconds=1))
  .groupby(df['ip'])
  .sum()
)
print(by_ip)

Explanation

The surprising fact here is that the teaser contains valid Python code. Python’s use of white space is pretty unique in programming languages. Some programmers don’t like it. However, the white space does make the code more readable.

The Python ...