PWC_Python_Day 3

The most important object defined in NumPy is an N-dimensional array type called?

• narray

• darray

• nd_array

• ndarray

Pandas deals with following data structures

• Series

• Series and Data Frames

• Series, DataFrames and Panel

• None of Above

Which is the correct Pandas syntax to read in a csv file and assign it to a DataFrame df?

• df = read_csv('file.csv')

• df = read('file.csv', type = 'csv')

• df = pd.read_csv('file.csv')

• df = with open('file.csv') as pd.DataFrame

Give the output of the following code

import pandas as pd

dict1 = {'AR' : 100, 'VR' : 200, 'AI' : 300}

ser = pd.Series(dict1)

print(ser[1])

• AR

• 100

• VR

• 200

Which of the following command is used to display only NAME and DOB from the above dataframe?

• pd.DataFrame(DICT1, columns=["NAME","DOB"])

• pd.DataFrame(DICT1, index=["NAME","DOB"])

• pd.DataFrame(DICT1, index=["NAME":"DOB"])

• pd.DataFrame(DICT1, columns=["NAME":"DOB"])

Which of the following statements is used to check the people whose score >500?

• DICT1[4]>=500

• DICT1["SCORE"]>=500

• DICT1["SCORE"]<=500

• DICT1["SCORE">=500]

pandas is a:

• Data Structure

• Series

• Dataframe

• Library

import matplotlib.pyplot as plt

import pandas as pd

grades = pd.DataFrame([[0, 1, 2, 3, 4, 5, 6, 7, 8, 9],[92, 89, 88, 85, 81, 78, 75, 75, 72, 65]])

print(grades.loc[0, :])

• a.      [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]

• a.      [92, 89, 88, 85, 81, 78, 75, 75, 72, 65]

• [0]

• [92]

In the given chart, box surrounded with red border is called

• Data series

• Chart Title

• Markers

• Legend

Raj has written following code to create a bar chart-

• Instead of using bar() he should use plot() method

• He should add show() function at the end of code

• He should use numpy array to store weekdays and sale data

• No suggestion required