Skip to main content
`Ctrl`+`K`

# pandas.col

pandas.col(col_name)

  Generate deferred object representing a column of a DataFrame.

  Any place which accepts `lambda df: df[col_name]`, such as `DataFrame.assign()` or `DataFrame.loc()`, can also accept `pd.col(col_name)`.

  Added in version 3.0.0.

  Parameters:
    col_name Hashable

      Column name.

  Returns:
    pandas.api.typing.Expression

      A deferred object representing a column of a DataFrame.

  See also

  `DataFrame.query`

    Query columns of a dataframe using string expressions.

  Examples

  You can use col in assign.

      >>> df = pd.DataFrame({"name": ["beluga", "narwhal"], "speed": [100, 110]})
      >>> df.assign(name_titlecase=pd.col("name").str.title())
            name  speed name_titlecase
      0   beluga    100         Beluga
      1  narwhal    110        Narwhal

  You can also use it for filtering.

      >>> df.loc[pd.col("speed") > 105]
            name  speed
      1  narwhal    110