CSE 6040 - 7.1 - Merging data frames: join operations - Code

Question 1

Write the code to display the following table as Table A.

Answer 1

See Pic

Question 2

Write the code to display Table B.

Answer 2

See Pic

Question 3

Write the code to display an inner-merge on Tables and and B on keys “country” and “year”.

Answer 3

See pic

Question 4

Given the following tables. Perform a left and right merge on the following tables D and E.

Answer 4

See Pic

Question 5

What’s the command to copy a dataframe named ‘C’ to a new dataframe ‘G’?

Answer 5

G = C.copy() # If you do not use copy function the original data frame is modified

Question 6

use the apply function on the dataframe ‘s’ to this function called fun

import pandas as pd

reading csv

s = pd.read_csv(“stock.csv”, squeeze = True)

defining function to check price

def fun(num):

if num<200:

return “Low”

elif num>= 200 and num<400:

return “Normal”

else:

return “High”

Answer 6