Joins in Python code example

Example 1: joins in pandas

pd.merge(product,customer,left_on='Product_name',right_on='Purchased_Product')

Example 2: SQL joins in python

This was What I intended
 ID Case NxtCase
 1    A        
 2    C        
 3    E      

This is my desired result

 ID Case NxtCase
 1    A        B
 2    C        D
 3    E        F

Example 3: join() python

# example of join() function in python

numList = ['1', '2', '3', '4']
separator = ', '
print(separator.join(numList))

Example 4: joins in pandas

pd.merge(product,customer,on='Product_ID')

Example 5: join method in python

# the join method in python is works like 
# it joins the the string that you provide to it to a sequence types(lists etc..)
flowers = [
    "Daffodil",
    "Evening Primrose",
    "Hydrangea",
    "Iris",
    "Lavender",
    "Sunflower",
    "Tiger Lilly",
]
print(", ".join(flowers))

# what the sbove code does is it joins all the flowers in list by ', '
# output = Daffodil, Evening Primrose, Hydrangea, Iris, Lavender, Sunflower, Tiger Lilly

Example 6: join function in python

"seperator".join(list/tuple)