Join Example

Join Example

1. Create DataFrame 1:

2. Create DataFrame 2:

3. Inner Join:

4. Outer Join:

5. Left-Outer Join:

6. Right-Outer Join:

Try out below as well:

1.

2.  Create another two DataFrames:

DataFrame 1:

DataFrame 2: 

3.

4. Concat() is similar to Union and Union All in SQL.

Some other experimented try out:

1.  Create DataFrame with the following conditions:

2. stack the DataFrame:

3. Apply conditions as shown below:

4. unstack the dataframe:

This is the basic difference between stack() and unstack().