CSC500 Unit 1 Quiz Reset

Khalid has a shop that sells computer parts. The prices for

each part are listed in the table below.

Which of the following is the correct way to declare a DataFrame horizontally to store the prices?

• prices = [250,1000,250,500]

• prices = pd.DataFrame( [[250,1000,250,500]] )

• prices = pd.DataFrame( [250,1000,250,500] )

• prices = [[250,1000,250,500]]

Amani is conducting a chemistry experiment. She collected the weight and volume data for 3 different objects as shown in the table.

Which of the following are the correct indices for the columns?

• 0, 1

• 0, 1, 2, 3

• 1, 2

• 1, 2, 3, 4

Using the table in question 2 fill in the blank the numbers that will make the output 4:

print(weight_volume.loc[___ , ___])

• 0, 3

• 1, 4

• 1, 3

• 0, 4

Ahmad wants to track his weekly activity by measuring the distance he covers. He created a table to store his activity for each week, as shown below.

Assume this was stored in a DataFrame called running, Append week 3’s distance to the data (week 3 – 28 km) as a new column.

• running[2] = [3, 28]

• running[3] = [3, 28]

• running.append([3,28], ignore_index=True)

• running.append([3,28])

Kholoud is doing a physics experiment that requires her to measure the density of different objects. Information about the objects is shown in the table below.

Which of the following will store data in a pandas DataFrame.

• objects = [ [5000,10000,1000] , [2,3,1] ]

• objects = pd.DataFrame( [ [5000,10000,1000] , [2,3,1] ] )

• objects = pd.DataFrame( [ [5000,2] , [10000,3] , [1000,1] ] )

• objects = [ [5000,2] , [10000,3] , [1000,1] ]

Based on the table in Q5, which of the following lines of code change the weight unit from gram to kilogram by dividing the values by 1000.

• objects.loc[0,0:2] = objects.loc[0, 0:2] / 1000

• objects.loc[1,0:2] = objects.loc[1, 0:2] / 1000

• weight_kg = weight/1000

• objects = objects / 1000

Based on Q5, calculate the density by dividing the weight in kg over the volume in liters.

• density = objects[weight] / objects[volume]

• density = weight / volume

• density = objects.loc[0, 0:2] / objects.loc[1, 0:2]

• density = objects.loc[1, 0:2] / objects.loc[0, 0:2]