Altaf final

To specify unlimited number of parameters in a function, use _____

( *lots_of_parameters )

Name and ID are columns to be removed from a data frame, df1. Which of the following is the proper way to do it?

.drop( columns = ​['ID', 'Name'] )

You can supply multiple column names (col1, col2) to the drop function using

.drop( columns = ​['col1', 'col2'] )

Range (0, 5, 2) will give the range of numbers ___.

0, 2, 4

Range (4) will give the range of numbers:

0,1,2,3

Assume the following is the information of a function: ABC ( number1, [number2], [number3], [number4] ) How many arguments must be given to this function at minimum?

1

How many NA values are there in the Team Size column?

1

Will the following line of code work to change the name at index 13? df[13, 'Name'] = "Preeti"

No, this won't work because of another error

df.drop(columns= 'Name' , inplace = True)What does the drop function return?

Nothing - there is no return value

which of the following is false?

a) function can have two return values b) A function can be recognized using parentheses c) A function can return a list of values a

Write one line of code for a data frame, df that changes the value for the Name column at row 5 to 'Mike'.

df.loc​[5,'Name']='Mike'

To see the full data in row indexes 18 to 25 of a data frame, df, you can use ____.

df[18:25]

To find unique records, use ___

df​[column].unique()

Assume, you have the following data about one Amazon product: Amazon ID Number, Product Name, Product Rating, Number of ReviewsWhat data structure is this data best suited

dictionary

How would we delete all the rows with invalid cell data?

dropna

Which of the following can be used to delete a row with an NA value?

dropna()

To link multiple if conditions, use an __

elif

The function dropna() will drop ___

every row where any column value has an na value.

Which of the following is the ideal candidate for using dictionaries?

Data about one student Series of logically related values that can be described with a name or a label

print( data​['100'])The line of code above will print:

Data with index 100

A Query function will ALWAYS return subset of the data from the data frame you are working with.

False

A function with 3 arguments must return three values.

False

Back quotes are REQUIRED for column names within a query

False

Query function modifies the data frame and converts it to contain a subset of the data

False

Variables have data types in Python

False

person = {"name": "Fred", "id": "23423" }for each_item in person: print( person​[each_item] )What values would get printed out?

Fred 23423

Which is the correct way to specify keyword arguments?

method(arg1= 1, arg2 = 2)

Arguments MUST be provided in the order listed in a method definition

mostly true...but you can use kwargs to provide keyword arguments

movie = "Lord of the Rings"How would we extract "Lord" from the string?

movie​[:4] movie​[0:4]

the data type of 'is_empty' variable is

na-doesnt have a type

Which of the following properly sets up a dictionary?

name = { 'name': 'Adam', 'id': 2300 }

Which of the following would generate an error?

numbers = ​[1, 2, 3]numbers.append(4)

Using the following code, how will you print only the name?data = { 'name': 'Adam', 'id': 2300 }

print ( data​['name'])

state = "Colorado" Which of the following will return the substring "Co" in Python?

state[:2]

def function_name ( *lots_of_values ):lots_of_values is a _____

tuple parameter

How would we find out if an item is contained in a list?

use an "if" with an "in"

A CSV file contains ___

values separated by commas

Which of the following are true about return values?

A function can return only one value A function can return only one value, which can in turn contain multiple values

df.loc[10, 'Name'] = 'John' df.loc[10, 'ID'] = 200 df = df['Name'].replace('John', 'Mike') print ( df.loc[10, 'ID' ] ) What is the output?

N/A - Error

title = "Netflix and Chill"print ( title​​[0:3] )

Net

How can you get index numbers for all the rows of a data frame?

df.index

How do you EDIT cell at row 26 and column 'ABC'?

df.loc ​[26, 'ABC'] = value

How do you EDIT cell at column 'PQR' and row 27?

df.loc ​[27, 'PQR'] = value

To see row numbers 10 to 15 in data frame, df, you would use: _____.

df.loc​[10: 15]

A DataFrame ALWAYS has rows and columns

True - it's two dimensional

To convert a string to all upper case, use ___.

UPPER()

state = "Pennsylvania" Which of the following will return the substring "Penn" in Python?

state[0:4]

A Pandas series is most similar to ____

a column of data

A query function selects ____ from a data frame.

a subset of rows

A Pandas DataFrame is most similar to ____

a table of data

A pandas data frame is most resembles

a table of rows and columns

What will be the output of the following lines of code in Python?ssn = "982-23-2324" print(ssn.replace("2", "3"))

983-33-3334

Assume the following is the information of a function: ABC ( number1, number2, [number3], [number4] ) How many arguments must be given to this function at minimum?

2

numbers = ​[3, 2, 1]for i in range (0, len(numbers) ): print( numbers ​[i] )What would get printed out?

3 2 1

list_of_numbers = [ 34, 56, 67, 53, 24] print( list_of_numbers[ 2: ] ) Which numbers would be selected?

67, 53, 24

number_list = [5, 10, 15, 20] print(number_list[0] + 2) What would be the output of the statements above?

7

df.loc​[5, 'Name'] = 'Mike'df​['Name'].replace('Mike', 'Sam')print ( df.loc​[5, 'Name'] )What is the output?

Mike

For a student dataframe that contains student info, the names column has student names.student_df​['name'].str.contains("jr.")What will this code return or result in?

One series of boolean values indicating which rows have "jr." in the name

number = 5if number > 5 :print ("a")else:print("b")What is the output of the code above?

Something else / error

A CSV consists of only one value, 50. When imported as a Data Frame, it would have rows and columns. Incorrect answer:

True

Column names with spaces should be enclosed in ____ within Pandas queries.

back quotes ``

A TUPLE _____, whereas a LIST ____.

cannot be modified , can be modified

Create a new method using the keyword ___

def

Which of the following keywords creates a new function?

def

How would we drop a row that has a value "adf2234" at index row 26?

df.drop(index=26)

Which of the following results in a series of True/False values?

df.duplicated( )

name = "Smurfette" print (name[4:]) What would be the output of the above set of statements in Python?

fette

How do we change all na values to a specific value?

fillna

Which of the following can be used to replace an NA value with a zero?

fillna()

A(n) _____ name is followed by parentheses in Python.

function

A query is run on a DataFrame df. The result of the query are stored in a variable, df2.df2 will ____.

have same or fewer rows AND same columns as df.

If you want to be able to have items in a data structure ordered by index numbers and be able to remove some elements later on as well, you would choose ____.

lists

How would we look up how many null values there are in the dataframe?

info()

To look at column headers for a DataFrame, you can use ___

info() head() tail()

Which of the following would cause an original DataFrame to be modified?

inplace = True

If you want to make changes to the original dataframe, use ___.

inplace=true

When a function returns a value, it ______.

is given back to the caller function invisibly

Be default, if to_numeric() function encounters a string, it ____

is unable to do the conversion and the function crashes with an error

a _ name is not followed by parentheses in a function

property, variable,attribute

Which of the following generates range numbers from 0 to 4 (inclusive of 4)?

range (0, 5) range(5)

To get numbers4, 2, 0use

range (4, -1, -2)

numbers = ​[1, 2, 3]for i in _________: print( numbers ​[i] )Fill in the blank so that the loop above works properly.

range( 0, len(numbers) range( len(numbers) )

To open a CSV file in Pandas, use ___

read_csv(url)

If you were given a file which had data separated by semi-colons, i.e. a ';' character, you could load it in Pandas by using ____.

read_csv(url, sep = ';')

For a tab-delimitted file, how would you specify that the values are delimited using a tab character?

sep = '\t'

df​[column].isna() will return you ____.

series of booleans

You are importing customer data from 4 sources. If you want a non-repetitive listing of only those states that your customers are in, you should import or copy customer data into ____.

sets

A Series in Pandas likely contains ____.

single column and multiple rows

How do we get the character with index 4 from the string?star = "Maverick"

star​[4]

To type for the value of "99.32" is

string

In Python to extract leading/trailing spaces, use ___.

strip

What does the following code result in?name = Peterprint ( name​[2:] )

ter

list of products = ​[ { 'product': 'Paper', 'id': '243098', 'rating': '4.5' }, { 'product': 'Pens', 'id': '7678', 'rating': '3.2' }, { 'product': 'Markers', 'id': '43263', 'rating': '3.8' } ]for each_product in list_of_products:print( each_product )What will the for loop print in the first iteration? (first time it loops)

the first dictionary literal

The purpose of keyword arguments is _____.

to allow specification of arguments out of order by using argument names