Pandas

Which of the following DataFrame methods will generate various summary statistics, excluding NaN values?

• .summary( )

• .info()

• .stats()

• .describe()

You have the following DataFrame df:

Month Count

zero Jan 52

one Apr 29

two Mar 46

three Feb 3

Select the code to return the output

Month Count

two Mar 46

three Feb 3

• print(df.loc['zero':]

• print(df.loc['three':]

• print(df.loc['two']

• print(df.loc['two' : ]

Which of the following is the correct way to select the age row and name column from a DataFrame df?

• df['age']['name']

• df['name']['age']

• df[age][name]

• df[name][age]

What is the output of this code?

s1 = pd.Series([1, 2, 3])

s2 = pd.Series([1, 2, 3])

print(pd.concat([s1, s2], ignore_index=True))

• 0 2

  1 4

  2 6

• 0 1

  1 2

  2 3

  0 1

  1 2

  2 3

• 0 1

  1 2

  2 3

  3 1

  4 2

  5 3

• 0 1 1

  1 2 2

  2 3 3

You have the following Series s:

0 2

1 4

2 6

What is the output of this code?

s2 = pd.Series([4, 8, 12])

print(s.append(s2))

• 0 2

  1 4

  2 6

  3 4

  4 8

  5 12

• 0 2

  1 4

  2 6

  0 4

  1 8

  2 12

• 0 2 4

  1 4 8

  2 6 12

• 0 6

  1 12

  2 18

What is the correct code to draw line graph using matplotlib

• plt.line

• plt.plot

• plt.hist

• plt.bar

What is the correct code delete a column from a dataframe?

• df.remove( column_name )

• df.delete( column_name )

• df.drop( column_name, axis = 0 )

• df.drop( column_name, axis = 1)

What is Pandas in Python primarily used for?

• Data visualization

• Machine learning

• Data manipulation and analysis

• Web development

What is the shape of df3, which is the concatenated of df1 and df2

df1 = pd.DataFrame( {'A' : [1, 2, 3, 4] } )

df2 = pd.DataFrame( {'B' : [5, 6, 7,8] } )

df3 = pd.concat( (df1, df2) )

print( df3.shape)

• (8, 2)

• (4, 2)

• (8, 1)

• (2, 4)

In Pandas, what is a DataFrame?

• A 2-dimensional labeled data structure

• A 1-dimensional labeled data structure

• A 3-dimensional labeled data structure

• A data visualization tool