wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Netligent-1

Total questions: 75

Worksheet time: 1hrs 15mins

Name
Class
Date
1.

Which is true for series.

a)

Size is mutable,Values is mutable

b)

size is immutable,values is mutable

c)

size is mutable,values is immutable.

d)

none

2.

Series.tail(3) will return how many values.

a)

3 values from front

b)

3 values from last

c)

5 values

d)

none

3.

Series.head() will return how many rows.

a)

2

b)

3

c)

4

d)

5

4.

To extract subset from Series,the following function is used

a)

row()

b)

column()

c)

loc()

d)

all

5.

we can analyze the data in pandas with :

a)

Series

b)

Dataframe

c)

Both

d)

none

6.

Series in Pandas is

a)

1 Dimensional Array

b)

2 Dimensional array

c)

3 Dimensional array

d)

none of above

7.

Minimum number of argument we require to pass in pandas series ?

a)

0

b)

1

c)

2

d)

3

8.

In data science, which of the python library are more popular ?

a)

numpy

b)

pandas

c)

django

d)

none

9.

Which is not a feature of series

a)

Homogeneous data

b)

Immutable size

c)

Mutable data

d)

Multiple rows

10.

Series can be created from

a)

Array

b)

Dictionary

c)

Scatter value

d)

All of them

11.

Which package should be needed for series

a)

Maths

b)

Statistic

c)

Pandas

d)

Random

12.

Full form of NaN is

a)

Not a Null

b)

Not a Number

c)

Not a Numeric

d)

None of these

13.

Data structures in Pandas can be mutated in the terms of ____ but not of _____.

a)

size, value

b)

value, size

c)

semantic, size

d)

none of the above

14.

pandas is a:

a)

Data Structure

b)

Series

c)

Dataframe

d)

Library

15.

Write the output for the following:

import pandas as pd1

s = pd1.Series(5, index=[0, 1, 2, 3])

print(s)

a)

0 5

b)

0 5

1 5

2 5

3 5

dtype: int64

c)

1 5

2 5

2 5

4 5

dtype: int64

d)

0 5

1 5

2 5

3 5

dtype: object

16.

write the output:

import pandas as pd1

s = pd1.Series([1,2,3])

t = pd1.Series([1,2,4])

u=s-t

print (u)

a)

0 1

1 0

2 1

dtype: int64

b)

0 0

1 0

2 1

dtype: int64

c)

0 0

1 0

2 -1

dtype: float64

d)

0 0

1 0

2 -1

dtype: int64

17.

write the output:

import pandas as pd

s=pd.Series([1,2,3,4],index=['a','b','c','d'])

print(s.iloc[2:4])

a)

b 2

c 3

d 4

dtype: int64

b)

b 3

c 4

dtype: int64

c)

c 3

d 4

dtype: int64

d)

none of the above

18.

write the output:

import pandas as pd

s=pd.Series([1,2,3,4],index=['a','b','c','d'])

print(s.loc['b':'d'])

a)

b 2

c 3

d 4

dtype: float64

b)

b 2

c 3

d 4

dtype: object

c)

c 3

d 4

dtype: int64

d)

b 2

c 3

d 4

dtype: int64

19.

Pandas deals with following data structures

a)

Series

b)

Series and Data Frames

c)

Series, DataFrames and Panel

d)

None of Above

20.

Best way to import the pandas module in your program ?

a)

1.import pandas

b)

2.import pandas as pd

c)

3.from pandas import *

d)

4.All of the above

21.

DataFrame in pandas is

a)

1. dimensional array

b)

2. dimensional array

c)

3.dimensional array

d)

4.None of the above

22.

All pandas data structures are ___ mutable but not always _______mutable.

a)

a) size, value

b)

b) semantic, size

c)

c) value, size

d)

d) none of the mentioned

23.

Which of the following object you get after reading CSV file?

a)

a) DataFrame

b)

b) Character Vector

c)

c) Panel

d)

d) All of the mentioned

24.

Which of the following library is similar to Pandas?

a)

a) NumPy

b)

b) RPy

c)

c) SciPy

d)

d) None of the mentioned

25.

Which is not a feature of series

a)

Homogeneous data

b)

Immutable size

c)

Mutable data

d)

Multiple rows

26.

Series can be created from

a)

Array

b)

Dictionary

c)

Scaler value

d)

All of them

27.

Full form of CSV file is

a)

Comma Separated Vault

b)

Comma Separated Value

c)

Common Separated Value

d)

Common System Value

28.

Not a function of Dataframe

a)

Head()

b)

Tail()

c)

loc()

d)

multi()

29.

Dataframe can contain multiple series

a)

True

b)

False

30.

Which function from the options given below can read the dataset from a large text file?

a)

read_json

b)

read_pickle

c)

read_hdf

d)

read_csv

31.

Which of the following can be used to make a Dataframe?

a)

Series

b)

DataFrame

c)

Structured ndarray

d)

All of the above

32.

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

a)

df = read_csv('file.csv')

b)

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

c)

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

d)

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

33.

Type the syntax that returns the top 5 rows in DataFrame df with the native Pandas function (not slicing):

(a)  

34.

Among the following functions, which one can be used to combine dataframes when they have similar structure.

a)

combine_first

b)

concat()

c)

merge()

35.

For the concat(), if the axis=1, it will join the dataframes ...............

a)

vertically

b)

horizontally

36.

Which function can be used to combine dataframes based on common fields?

a)

merge()

b)

combine_first()

c)

concat()

37.

Which function views dataframe in the form of vertical subset ie column wise?

a)

iterrows()

b)

iteritems()

38.

Which of the functions can be used to delete column/row from a DataFrame?

a)

pop()

b)

at()

c)

drop()

d)

iloc()

39.

Which is not a feature of series

a)

Homogeneous data

b)

Immutable size

c)

Mutable data

d)

Multiple rows

40.

Dataframe have

a)

2D Array

b)

Mutable size

c)

Mutable data

d)

All of above

41.

Series can be created from

a)

Array

b)

Dictionary

c)

Scatter value

d)

All of them

42.

Which package should be needed for series

a)

Maths

b)

Statistic

c)

Pandas

d)

Random

43.

Full form of NaN is

a)

Not a Null

b)

Not a Number

c)

Not a Numeric

d)

None of these

44.

Dataframe can be created using

a)

Array

b)

Dictionary

c)

List

d)

All of these

45.

Full form of CSV file is

a)

Comma Separated Vault

b)

Comma Separated Value

c)

Common Separated Value

d)

Common System Value

46.

Not a function of Dataframe

a)

Head()

b)

Tail()

c)

loc()

d)

multi()

47.

which functions used to transfer data from dataframe to CSV files

a)

to_data()

b)

to_csv()

c)

df_csv()

d)

from_dataframe()

48.

Dataframe can contain multiple series

a)

True

b)

False

49.

The maximum number that you can assign for the color is ____.

a)

4

b)

3

c)

2

d)

1

50.

This is an example of a ___________.

a)

Scatter Chart

b)

Line Graph

c)

Bar Graph

d)

Pie Chart

51.

The maximum number that you can assign for the color is ____.

a)

4

b)

3

c)

2

d)

1

52.

Which function is used to assign the title of the graph ?

a)

name()

b)

title()

c)

heading()

d)

none

53.

names = np.array(["Reem" , "Salah" , "Haya" , "Maryam" , "Fatema"])

print(names([2))

Mark the right output from the below options

a)

[ 'Haya' ]

b)

[ 'Maryam' ]

c)

[ 'Reem' ]

d)

[ 'Salah' ]

54.

names = np.array(["Reem" , "Salah" , "Haya" , "Maryam" , "Fatema"])

names[2] = "Omar"

print([names])

Mark the right output from the below options

a)

[ "Reem" , "Salah" , "Haya" , "Maryam" , "Fatema" ]

b)

[ "Reem" , "Salah" , "Omar" , "Maryam" , "Fatema" ]

c)

[ "Reem" , "Haya" , "Salah" , "Maryan" , "Fatema" ]

55.

names = np.array(["Reem" , "Salah" , "Haya" , "Maryam" , "Fatema"])

names[2] = "Omar"

print([names])

Mark the right output from the below options

a)

[ "Reem" , "Salah" , "Haya" , "Maryam" , "Fatema" ]

b)

[ "Reem" , "Salah" , "Omar" , "Maryam" , "Fatema" ]

c)

[ "Reem" , "Haya" , "Salah" , "Maryan" , "Fatema" ]

56.

names = np.array(["Reem" , "Salah" , "Haya" , "Maryam" , "Fatema"])

print(names([2))

Mark the right output from the below options

a)

[ 'Haya' ]

b)

[ 'Maryam' ]

c)

[ 'Reem' ]

d)

[ 'Salah' ]

57.

What does these 4 colour boxes on extreme right side called

a)

Title

b)

Legend

c)

Heading

d)

Label

58.

________________function is used to create a horizontal bar chart.

a)

barchart()

b)

barh()

c)

bar()

d)

None of the above

59.

Among the following which chart type is used to visualize a trend in data over intervals of time.

a)

Histogram

b)

Bar chart

c)

Pie chart

d)

Line chart

60.

The ______ argument of legend() provides the location for legend, which by default is one or upper right

a)

Title()

b)

Loc

c)

X label()

d)

Y label()

61.

The graphical or visual representation of information and data using visual elements like charts, graphs, etc are called_____

a)

Data visualization

b)

Pyplot

c)

Line chart

d)

Bar chart

62.

Name the function used to create an array?

a)

np.aray()

b)

np.array()

c)

Np.array()

d)

np.arange()

63.

np.arange(2,8,1) ----> what output will be produced?

a)

2,3,4,5,6,7,8

b)

2,3,4,5,6,7,8,9

c)

2,3,4,5,6,7

d)

2,4,6,8

64.

Which function is used to create a pie chart in Matplotlib?

a)

plt.pie()

b)

plt.piechart()

c)

plt.chart()

d)

plt.pieplot()

65.

How can you explode a slice in a pie chart to emphasize it?

a)

Use the explode parameter in plt.pie()

b)

Use the highlight parameter in plt.pie()

c)

Use the slice parameter in plt.pie()

d)

Use the accent parameter in plt.pie()

66.

What does the plt.scatter() function do?

a)

Creates a line plot

b)

Creates a scatter plot

c)

Creates a histogram

d)

Creates a pie chart

67.

Which function in Matplotlib can be used to customize the size of points in a scatter plot?

a)

plt.scatter()

b)

plt.plot()

c)

plt.bar()

d)

plt.hist()

68.

How can you add a legend to a scatter plot?

a)

plt.legend()

b)

plt.add_legend()

c)

plt.show_legend()

d)

plt.insert_legend()

69.

Which function is used to create a violin plot in Matplotlib?

a)

plt.violin()

b)

plt.boxplot()

c)

plt.violinplot()

d)

plt.plot()

70.

What does the c parameter in plt.scatter() control?

4 lines
71.

Which parameter in plt.pie() defines how much each slice is exploded from the center?

a)

explode

b)

offset

c)

separation

d)

dist

72.

If n is the total number of observations, the class whose cumulative frequency is greater than n2\frac{n}{2}  This class is called the median 

a)

TRUE

b)

FALSE

73.

The wickets taken by a bowler in 10 cricket matches are as follows: 2,6,4,5,0,2,1,3,2,3 Find the mode of the data

a)

2

b)

3

c)

4

d)

5

74.

Can the mean, median and mode of data coincide?

a)

Yes

b)

No

75.

The mean, median and mode of grouped data are always different

a)

TRUE

b)

FALSE