Using `sort_naturally`¶

In [2]:

import pandas_flavor as pf
import pandas as pd
import janitor

Let's say we have a pandas DataFrame that contains wells that we need to sort alphanumerically.

In [3]:

data = {
    "Well": ["A21", "A3", "A21", "B2", "B51", "B12"],
    "Value": [1, 2, 13, 3, 4, 7],
}
df = pd.DataFrame(data)
df

Out[3]:

A human would sort it in the order:

A3, A21, A21, B2, B12, B51

However, default sorting in pandas doesn't allow that:

In [4]:

df.sort_values("Well")

Out[4]:

Lexiographic sorting doesn't get us to where we want. A12 shouldn't come before A3, and B11 shouldn't come before B2. How might we fix this?

In [5]:

df.sort_naturally("Well")

Out[5]:

Now we're in sorting bliss! :)

Using sort_naturally¶