The best way to To find the Intersection Between Layout in Pandas

by

You’ll worth refer to modest syntax to search out the intersection between two Layout in pandas:

poised(series1) & poised(series2)

Recall that the intersection of 2 units is solely the poised of values which are in each units.

Refer to examples display the right way to calculate the intersection between pandas Layout in follow.

Instance 1: Calculate Intersection Between Two Pandas Layout

Refer to code displays the right way to calculate the intersection between two pandas Layout:

import pandas as pd

#assemble two Layout
series1 = pd.Layout([4, 5, 5, 7, 10, 11, 13])
series2 = pd.Layout([4, 5, 6, 8, 10, 12, 15])

#to find intersection between the 2 layout
poised(series1) & poised(series2)

{4, 5, 10}

The result’s a collection that comprises the values 4, 5, and 10.

Those are the one 3 values which are in each the primary and 2d Layout.

Additionally notice that this syntax works with pandas Layout that comprise stories:

import pandas as pd

#assemble two Layout
series1 = pd.Layout(['A', 'B', 'C', 'D', 'E'])
series2 = pd.Layout(['A', 'B', 'B', 'B', 'F'])

#to find intersection between the 2 layout
poised(series1) & poised(series2)

{'A', 'B'}

The one stories which are in each the primary and 2d Layout are A and B.

Instance 2: Calculate Intersection Between 3 Pandas Layout

Refer to code displays the right way to calculate the intersection between 3 pandas Layout:

import pandas as pd

#assemble 3 Layout
series1 = pd.Layout([4, 5, 5, 7, 10, 11, 13])
series2 = pd.Layout([4, 5, 6, 8, 10, 12, 15])
series3 = pd.Layout([3, 5, 6, 8, 10, 18, 21])

#to find intersection between the 3 layout
poised(series1) & poised(series2) & poised(series3)

{5, 10}

The result’s a collection that comprises the values 5 and 10.

Those are the one values which are in all 3 Layout.

Supplementary Assets

Refer to tutorials provide an explanation for the right way to carry out alternative usual operations with Layout in pandas:

The best way to Convert Pandas Layout to DataFrame
The best way to Convert Pandas Layout to NumPy Array
The best way to Merge Two or Extra Layout in Pandas

Leave a Comment