joins in pandas
pd.merge(product,customer,left_on='Product_name',right_on='Purchased_Product')joins in pandas
pd.merge(product,customer,left_on='Product_name',right_on='Purchased_Product')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 Fjoin() python
# example of join() function in python
numList = ['1', '2', '3', '4']
separator = ', '
print(separator.join(numList))joins in pandas
pd.merge(product,customer,on='Product_ID')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 Lillyjoin function in python
# use of join function to join list
# elements without any separator.
# Joining with empty separator
list1 = ['g','e','e','k', 's']
print("".join(list1))
#Output:
geeksCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
