Section1

Choose the correct code to display the fourth element of a Series object K.

• (a) K[:4] 

• K[2]

• K[3] 

• K[:2]

Choose the correct option that will import Pandas library.

• import pandas as pd 

•  import pandas as py 

• import pandas as pda

• All of these 

Choose the correct statement about the purpose of the ndim attribute.

• It returns the number of elements in the given data structure. 

•  It returns the Series object in the form of an ndarray.

• It returns a list of the indexes / labels. 

• It returns the number of dimensions of the given data structure. 

Choose the correct argument to specify a separator character with pandas.read_csv( ). 

• delim

• char 

• separator 

• sep

Select the number of rows and columns in a given code dataframe df1.

import pandas as pd 

list_of_dict = [{‘a’:10, ‘b’:20}, {‘a’:5, ‘b’:10, ‘c’:20}, {‘a’:7, ‘d’:10, ‘e’:20}] 

df1 = pd.DataFrame(list_of_dict) 

• 5 rows, 2 columns

• 3 rows, 4 columns

•  3 rows, 5 columns

• None of the above

Choose the correct function you may use to calculate the cumulative sum of a column of a dataframe.

•  sum() 

• sum(cumulative=True) 

• cumsum()

•  None of the above

Choose the correct command to find the minimum values along the columns for each row in the data frame df.

• df.min() 

• df.min(axis=1) 

• df.min(axis=0) 

• df.min(column)

Choose the correct command to delete column ‘Wheat’ from data frame df.

• del df[‘Wheat’]

• del ‘Wheat’

• del df.Wheat 

• del df[4]

Choose the correct function that is used to change the name of the index in dataframe df.

• df.change(index={'Almaty':'Alm','Shymkent':'Sh', 'Karaganda':'KRG', 'Pavlodar':'P', 'Astana' : 'N'}) 

•  df.reindex(index={'Almaty':'Alm','Shymkent':'Sh', 'Karaganda':'KRG', 'Pavlodar':'P', 'Astana' : 'N'}) 

• df.named(index={'Almaty':'Alm','Shymkent':'Sh', 'Karaganda':'KRG', 'Pavlodar':'P', 'Astana' : 'N'})

• df.rename(index={'Almaty':'Alm','Shymkent':'Sh', 'Karaganda':'KRG', 'Pavlodar':'P', 'Astana' : 'N'})

Choose the correct code that will change the value ‘7152’ of Fruits column in the row Pavlodar into 9658. 

• df.Fruits(7152)=9658 

• df.Pavlodar[7152]=9658 

• df.Fruits[‘Pavlodar’]=9658 

• df.Pavlodar[‘Fruits’](7152)=9658