Python Pandas
Which of the following cannot be used to create a Data frame? A tuple of tuples
Which of the following expressions are used to check if each element of a series s is present in the list of elements [67, 32]. Series s is defined as shown below.
s = pd.Series([99, 32, 67],list('abc'))
s.isin([67,32])
What is the shape of the data frame df defined in the below=shown code? import pandas as pd
data = [{'a': 1, 'b': 2}, {'a': 5, 'b': 10, 'c': 20}]
df = pd.DataFrame(data)
(2,3)
What is the output of the following code? import pandas as pd
s = pd.Series([89.2, 76.4, 98.2, 75.9], index=list('abcd'))
print(s[['c', 'a']]) c 98.2
a 89.2
dtype: float64
Which of the following attributes or arguments are used to set column names of a data frame?
columns
What is the output of the expression 'b' in s, where s is the series defined as shown below? s = pd.Series([89.2, 76.4, 98.2, 75.9],
index=list('abcd'))
True
Which of the following is not a Data Structure of Pandas? Dictionary
What is the shape of the data frame df defined in the below shown code? import pandas as pd
data = [{'a': 1, 'b': 2}, {'a': 5, 'b': 10, 'c': 20}]
df = pd.DataFrame(data, columns=['a', 'b']) (2,2)
What is the data type of series s defined in below code? import pandas as pd
s = pd.Series([9.2, 'hello', 89])
object
Which of the following argument is used to label the elements of a series?
Index
Which of the following expression is used to add a new column 'C' to a data frame df, with three rows? df['C'] = [12,98,45]
Which of the following expression is used to delete the column, A from a data frame named df? del df['A']
Which of the following expression returns data of column B of data frame df, defined below? Which of the following expression returns the data of column B in data frame df, defined below. import pandas as pd
df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2', 'r3'])
df.B
Which of the following expression returns the second row of df, defined below?
import pandas
df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2', 'r3'])
df.iloc[1]
Which of the following expression returns the first two rows of df, defined below? import pandas as pd
df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2',
'r3'])
Both df[:2] and df.iloc[:2]
Which of the following expression returns last two rows of df, defined below? import pandas as pd
df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2',
'r3'])
df.loc['r2':'r3']
What does the expression df.loc['r4'] = [67, 78] do for the data frame df, defined below? df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2',
'r3'])
Add a new row
State whether the following statement is true or false? The read_csv method can read multiple columns of an input file as indexes.
True
Which of the following is used as an argument of read_csv method to skip first n lines of an input CSV file?
skiprows
State whether the following statement is true or false? The read_csv method, by default, reads all blank lines of an input CSV file.
False
is used as an argument of the readcsv method to make data of a specific column as an index.
index_col
Which of the following method is used to write a data frame data to an output CSV file?
to_csv
Which of the following is used as argument of read_csv method to treat data of specific columns as dates?
parse_dates
Which of the following method is used to read data from excel files? read_excel
What does the expression d + pd.Timedelta('1 days 2 hours') do to DatetimeIndex object d, defined below?
d = pd.date_range('11-Sep-2017', '17-Sep-2017', freq='2D')
Increases each datetime value by 1 day and 2 hours
What is the output of the following code? import pandas as pd
d = pd.date_range('11-Sep-2017', '17-Sep-2017', freq='2D')
len(d[d.isin(pd.to_datetime(['12-09-2017', '15-09-2017']))])
1
What is the length of DatetimeIndex object created with the below expression? pd.date_range('11-Sep-2017', '17-Sep-2017',
freq='2D')
4
Which of the following method is used to convert a list of dates like strings into datetime objects? to_datetime
What is the length of DatetimeIndex object created with the below expression? pd.bdate_range('11-Sep-2017', '17-Sep-2017',
freq='2D')
4
What is the length of PeriodIndex object created from the expression pd.period_range('11-Sep- 2017', '17-Sep-2017', freq='M')?
1
Which of the following method of pandas is used to check if each value is a null or not?
isnull
By default, missing values in any data set are read as ...........
NaN
Which of the following method is used to fill null values with a deafult value?
fillna
Unrecognized datetime value is treated as _.
NaT
Which of the following argument values are allowed for the method argument of fillna?
All the options
Which of the following method is used to eliminate rows with null values?
dropna
Which of the following methods is used to remove duplicates? drop_duplicates
Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. How many rows are obtained after executing the below expressions
g = df.groupby(df.index.str.len()) g.filter(lambda x: len(x) > 1)
9
Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3'], Which of the following expression is used to extract columns 'C' and 'D'?
Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression is used to extract columns 'C' and 'D'?
df.loc[:, lambda x : x.columns.isin(['C', 'D'])]
Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. What does the expression df[lambda x : x.index.str.endswith('3')]
do? Filters the row labelled r3
Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the aggregate method shown in below code do?
g = df.groupby(df.index.str.len()) g.aggregate({'A':len, 'B':np.sum})
Computes length of column A and Sum of Column B values of each group
Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression filters the rows whose column B values are greater than 45 and column 'C' values are less than 30?
df.loc[(df.B > 45) & (df.C < 30)]
What does the expression df.iloc[:, lambda x : [0,3]] do? Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3'].
Which of the following method can be applied on a groupby object to get the group details?
groups
Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression filters the rows whose column B values are greater than 45?
Conisder a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression filters those rows whose column B values are greater than 45?
df[df.B > 45]
Which of the following methods is used to group data of a data frame, based on specific columns?
Which of the following methods is used to group data of a data frame, based on a specific column?
groupby
Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the expression g = df.groupby(df.index.str.len()) do?
Data frames cannot be grouped by index values. Hence it results in Error.
Which of the following argument is used to set the key to be used for merging two data frames?
on
What is the shape of d defined in below code? import pandas as pd
s1 = pd.Series([0, 1, 2, 3])
s2 = pd.Series([0, 1, 2, 3])
s3 = pd.Series([0, 1, 4, 5])
d = pd.concat([s1, s2, s3], axis=1) (4,3)
Which of the following are allowed values of the argument how of merge method?
Which of the following are allowed values of argument how of merge method?
All the options
Which argument is used to override the existing column names, while using concat method?
keys
Which of the following argument is used to ignore the index while concatenating two data frames?
Which of the following method is used to concatenate two or more data frames?
concat
Post a Comment