Python Final
To specify unlimited number of parameters in a function, use _____
(*lots_of_parameters )
You can supply multiple column names (col1, col2) to the drop function using
.drop( columns = ['col1', 'col2'] )
df.drop(columns= 'Name' , inplace = True)
Nothing - there is no return value
To find unique records, use ___
df[column].unique()
How would we delete all the rows with invalid cell data?
dropna
A Pandas DataFrame is most resembles _____.
A table of rows and columns
print( data['100']) The line of code above will print:
Data with index 100
Query function modifies the data frame and converts it to contain a subset of the data
Fales
def function_name ( *lots_of_values ): lots_of_values is a _____.
tuple parameter
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
How do you EDIT cell at row 26 and column 'ABC'?
df.loc [26, 'ABC'] = value
A DataFrame ALWAYS has rows and columns
True - it's two dimensional
A query function selects ____ from a data frame.
a subset of rows
A Pandas DataFrame is most similar to ____
a table of data
def exponent(base, exponent): base = 2 exponent = 3 return base ** exponent power = base ** exponent return power
8
Arguments MUST be provided in the order listed in a method definition
Mostly True.... but you can use kwargs to provide arguments in any order.
For a student dataframe that contains student info, the names column has student names.student_df['name'].str.contains("jr.")
One series of boolean values indicating which rows have "jr." in the name
import pandas as pd url="https://raw.githubusercontent.com/xyz.csv" file_df = pd.read_csv(url) df = pd.DataFrame(df )
Program won't run - df is being used before it is defined!
A Pandas series is most similar to ____
a column of data
Column names with spaces should be enclosed in ____ within Pandas queries.
back quotes ''
Which of the following keywords creates a new function?
def
import pandas as pd url="https://raw.githubusercontent.com/xyz.csv" df = pd.read_csv(url) df2 = pd.DataFrame( _____ )
df
How would we drop a row that has a value "adf2234" at index row 26?
df.drop(index=26)
How can you get index numbers for all the rows of a data frame?
df.index
How do we change all na values to a specific value?
fillna
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()
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
A Series in Pandas likely contains ____.
single column and multiple rows
The purpose of keyword arguments is _____.
to allow specification of arguments out of order by using argument names
