Trait polars_ops::prelude::DataFrameJoinOps

pub trait DataFrameJoinOps: IntoDf {
    fn join<I, S>(
        &self,
        other: &DataFrame,
        left_on: I,
        right_on: I,
        how: JoinType,
        suffix: Option<String>
    ) -> PolarsResult<DataFrame>
    where
        I: IntoIterator<Item = S>,
        S: AsRef<str>,
    { ... }
    fn inner_join<I, S>(
        &self,
        other: &DataFrame,
        left_on: I,
        right_on: I
    ) -> PolarsResult<DataFrame>
    where
        I: IntoIterator<Item = S>,
        S: AsRef<str>,
    { ... }
    fn left_join<I, S>(
        &self,
        other: &DataFrame,
        left_on: I,
        right_on: I
    ) -> PolarsResult<DataFrame>
    where
        I: IntoIterator<Item = S>,
        S: AsRef<str>,
    { ... }
    fn outer_join<I, S>(
        &self,
        other: &DataFrame,
        left_on: I,
        right_on: I
    ) -> PolarsResult<DataFrame>
    where
        I: IntoIterator<Item = S>,
        S: AsRef<str>,
    { ... }
}

Provided Methods

fn join<I, S>(
    &self,
    other: &DataFrame,
    left_on: I,
    right_on: I,
    how: JoinType,
    suffix: Option<String>
) -> PolarsResult<DataFrame>where
    I: IntoIterator<Item = S>,
    S: AsRef<str>,

Generic join method. Can be used to join on multiple columns.

Example

let df1: DataFrame = df!("Fruit" => &["Apple", "Banana", "Pear"],
                         "Phosphorus (mg/100g)" => &[11, 22, 12])?;
let df2: DataFrame = df!("Name" => &["Apple", "Banana", "Pear"],
                         "Potassium (mg/100g)" => &[107, 358, 115])?;

let df3: DataFrame = df1.join(&df2, ["Fruit"], ["Name"], JoinType::Inner, None)?;
assert_eq!(df3.shape(), (3, 3));
println!("{}", df3);

Output:

shape: (3, 3)
+--------+----------------------+---------------------+
| Fruit  | Phosphorus (mg/100g) | Potassium (mg/100g) |
| ---    | ---                  | ---                 |
| str    | i32                  | i32                 |
+========+======================+=====================+
| Apple  | 11                   | 107                 |
+--------+----------------------+---------------------+
| Banana | 22                   | 358                 |
+--------+----------------------+---------------------+
| Pear   | 12                   | 115                 |
+--------+----------------------+---------------------+

fn inner_join<I, S>(
    &self,
    other: &DataFrame,
    left_on: I,
    right_on: I
) -> PolarsResult<DataFrame>where
    I: IntoIterator<Item = S>,
    S: AsRef<str>,

Perform an inner join on two DataFrames.

Example

fn join_dfs(left: &DataFrame, right: &DataFrame) -> PolarsResult<DataFrame> {
    left.inner_join(right, ["join_column_left"], ["join_column_right"])
}

fn left_join<I, S>(
    &self,
    other: &DataFrame,
    left_on: I,
    right_on: I
) -> PolarsResult<DataFrame>where
    I: IntoIterator<Item = S>,
    S: AsRef<str>,

Perform a left join on two DataFrames

Example

let df1: DataFrame = df!("Wavelength (nm)" => &[480.0, 650.0, 577.0, 1201.0, 100.0])?;
let df2: DataFrame = df!("Color" => &["Blue", "Yellow", "Red"],
                         "Wavelength nm" => &[480.0, 577.0, 650.0])?;

let df3: DataFrame = df1.left_join(&df2, ["Wavelength (nm)"], ["Wavelength nm"])?;
println!("{:?}", df3);

Output:

shape: (5, 2)
+-----------------+--------+
| Wavelength (nm) | Color  |
| ---             | ---    |
| f64             | str    |
+=================+========+
| 480             | Blue   |
+-----------------+--------+
| 650             | Red    |
+-----------------+--------+
| 577             | Yellow |
+-----------------+--------+
| 1201            | null   |
+-----------------+--------+
| 100             | null   |
+-----------------+--------+

fn outer_join<I, S>(
    &self,
    other: &DataFrame,
    left_on: I,
    right_on: I
) -> PolarsResult<DataFrame>where
    I: IntoIterator<Item = S>,
    S: AsRef<str>,

Perform an outer join on two DataFrames

Example

fn join_dfs(left: &DataFrame, right: &DataFrame) -> PolarsResult<DataFrame> {
    left.outer_join(right, ["join_column_left"], ["join_column_right"])
}

Implementations on Foreign Types

impl DataFrameJoinOps for DataFrame

Implementors