23. Consider the following tables item and customer and answer the questions that follow :
Table:Item
ItemID ItemName Manufacturer Price
PC01 Personal Computer HCL India 42000
LC05 Laptop HP USA 55000
PC03 Personal Computer Dell USA 32000
PC06 Personal Computer Zenith USA 37000
LC03 Laptop Dell USA 57000
Table : Customer
ItemID CustomerName City
LC03 N Roy Delhi
PC03 H Singh Mumbai
PC06 R Pandey Delhi
LC03 C Sharma Chennai
PC01 K Agarwal Bengaluru
Assume that the pandas has been imported as pd.
a. Create a Dataframe called df1 for table Item and df2 for table Customer.
b. Perform the default join operation on itemID using two dataframes : df1,df2
c. Perform the right join operation on itemID using two dataframes : df1,df2
d. Perform the default operation on itemID using two dataframes : df1,df2 with the left index as true.
e. Perform the outer join operation on itemID using two dataframes : df1,df2