You can use .select to project only columns you need

On Wed, Apr 29, 2015 at 9:23 PM, Olivier Girardot <ssab...@gmail.com> wrote:

> Hi everyone,
> what is the most efficient way to filter a DataFrame on a column from
> another Dataframe's column. The best idea I had, was to join the two
> dataframes :
>
> > val df1 : Dataframe
> > val df2: Dataframe
> > df1.join(df2, df1("id") === df2("id"), "inner")
>
> But I end up (obviously) with the "id" column twice.
> Another approach would be to filter df1 but I can't seem to get this to
> work using df2's column as a base
>
> Any idea ?
>
> Regards,
>
> Olivier.
>



-- 
Best Regards,
Ayan Guha

Reply via email to