How can you add a new column to a Pandas DataFrame?

Use df['new_column_name'] = value to add a new column.

Apply df.insert('new_column_name', value) to create a new column.

Utilize df.append('new_column_name', value) to add a new column.

Use df.add_column('new_column_name', value) to add a new column.

What is the purpose of the 'with' statement in file handling?

To ensure proper management of file resources by automatically closing the file after its block of code is executed.

To read the file contents into memory for processing.

To create a new file if it does not exist.

To lock the file for exclusive access by the program.

How do you check if a key exists in a dictionary?

Use 'key in dictionary' to check for key existence.

Check if 'dictionary.get(key)' returns None.

Use 'dictionary.key' to access the value directly.

Use 'key.exists()' to verify key presence.

What is the result of the following code: df['A'] + df['B']?

A Series containing the element-wise sum of df['A'] and df['B'].

A DataFrame containing the combined values of df['A'] and df['B'].

A Series containing the difference of df['A'] and df['B'].

A list of the unique values from df['A'] and df['B'].

How do you save a DataFrame to a CSV file?

Use df.to_csv('filename.csv', index=False) to save a DataFrame to a CSV file.

Use df.save('filename.csv') to export a DataFrame.

Use df.to_file('filename.csv') to write a DataFrame to a CSV.

Call df.write.csv('filename.csv') to save a DataFrame.

What is the purpose of the 'return' statement in a function?

The purpose of the 'return' statement is to provide a value from a function to its caller.

To create a loop within the function.

To end the function execution immediately.

To define the function's parameters.

How can you iterate over a list in Python?

Use a for loop: for item in my_list: # process item

Use a forEach method: my_list.forEach(item => # process item)

Use a map function: my_list.map(item => # process item

Use a while loop: while my_list: # process item

What is the output of the following code: df['A'] * df['B']?

A Series containing the element-wise multiplication of df['A'] and df['B'].

A DataFrame containing the product of df['A'] and df['B'].

A list of the values from df['A'] multiplied by df['B'].

A Series containing the combined values of df['A'] and df['B'].

How can you remove a column from a Pandas DataFrame?

Use df.drop('column_name', axis=1) to remove a column.

Apply df.remove('column_name') to delete a column.

Utilize df.delete('column_name') to drop a column.

Use df.pop('column_name') to remove a column.

What is the purpose of the 'apply' function in Pandas?

To apply a function along an axis of the DataFrame.

To merge two DataFrames together.

To filter rows based on a condition.

To create a new DataFrame from existing data.

How can you convert a DataFrame to a NumPy array?

Use df.to_numpy() to convert a DataFrame to a NumPy array.

Apply df.array() to get a NumPy array from a DataFrame.

Utilize df.as_array() to convert a DataFrame to a NumPy array.

Use df.to_list() to convert a DataFrame to a NumPy array.

How do you read a JSON file in Python?

Use json.load(open('filename.json'))

Use json.loads('filename.json')

How can you filter rows in a Pandas DataFrame based on a condition?

Apply df[df['column'] > value] to filter rows based on a condition.

Use df.filter(condition) to filter rows.

Utilize df.select(condition) to filter rows.

Use df.where(condition) to filter rows in a DataFrame.

What method is used to concatenate two DataFrames in Pandas?

Use df.concat(df2) to concatenate two DataFrames.

Apply df.append(df2) to join two DataFrames.

Utilize df.merge(df2) to combine two DataFrames.

Use df.combine(df2) to concatenate two DataFrames.

How do you check for missing values in a Pandas DataFrame?

Use df.isnull() to check for missing values.

Apply df.check_missing() to find missing values.

Utilize df.hasna() to identify missing values.

Use df.missing_values() to check for NaN values.

What is the purpose of the 'strip' method in Python strings?

To remove leading and trailing whitespace from a string.

To convert a string to lowercase.

To split a string into a list of words.

To replace all occurrences of a substring in a string.

How do you create a scatter plot using Matplotlib?

Use plt.scatter(x, y) to create a scatter plot.

Use plt.plot.scatter(x, y) to create a scatter plot.

Use plt.scatterplot(x, y) to create a scatter plot.

Use plt.create_scatter(x, y) to create a scatter plot.

What function is used to read a CSV file into a Pandas DataFrame?

Use pd.read_csv('filename.csv') to read a CSV file.

Apply pd.load_csv('filename.csv') to import a CSV file.

Utilize pd.import_csv('filename.csv') to read a CSV file.

Use pd.open_csv('filename.csv') to load a CSV file.

How do you create a line plot using Matplotlib?

Use plt.plot(x, y) to create a line plot.

Use plt.line(x, y) to create a line plot.

Use plt.draw(x, y) to create a line plot.

Use plt.create_line(x, y) to create a line plot.

What will be the result of df['C'] = df['A'] + df['B']?

A DataFrame with a new column 'C' containing the sum of 'A' and 'B'.

A Series with the combined values of 'A' and 'B'.

A DataFrame with only the 'A' column.

How can you remove duplicates from a DataFrame?

Apply df.drop_duplicates() to remove duplicate rows.

Use df.remove_duplicates() to eliminate duplicates.

Utilize df.unique() to filter out duplicates.

Use df.delete_duplicates() to get rid of duplicates.

What will be the output of np.ones((3, 3))?

[[1, 1, 1], [1, 1, 1], [1, 1, 1]]

[[0, 0, 0], [0, 0, 0], [0, 0, 0]]

[[1.0, 1.0, 1.0], [1.0, 1.0, 1.0], [1.0, 1.0, 1.0]]

[[1, 1, 1], [0, 0, 0], [1, 1, 1]]

How do you create a bar plot using Matplotlib?

Use plt.bar(x, height) to create a bar plot.

Use plt.plot.bar(x, height) to create a bar plot.

Use plt.create_bar(x, height) to create a bar plot.

Use plt.draw_bar(x, height) to create a bar plot.

What is the purpose of the 'map' function in Python?

To apply a function to all items in an iterable.

To filter items from an iterable based on a condition.

To combine two lists into a dictionary.

What method is used to read an Excel file into a Pandas DataFrame?

Use pd.read_excel('filename.xlsx') to read an Excel file.

Apply pd.load_excel('filename.xlsx') to import an Excel file.

Utilize pd.import_excel('filename.xlsx') to read an Excel file.

Use pd.open_excel('filename.xlsx') to load an Excel file.

What is the purpose of the 'filter' function in Python?

To apply a function to filter items from an iterable based on a condition.

To combine two lists into a single list.

To map a function to all items in an iterable.

What is the purpose of the 'groupby' function in Pandas?

To group DataFrame rows based on a specific column.

To merge two DataFrames together.

To filter rows based on a condition.

To sort the DataFrame by a specific column.

Mastering Python Basics and Libraries

Authored by Manjunatha M

Professional Development

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

The 'iloc' function allows for integer-location based indexing in Pandas.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

Q-1050

Quiz

•

University

45 questions

Davinci Resolve 17 Fusion 101

Quiz

•

11th Grade - Professi...

48 questions

Q-1500

Quiz

•

University

50 questions

soal profesional bahasa inggris

Quiz

•

University - Professi...

45 questions

Examen de Grado - Educación Parvularia

Quiz

•

University

47 questions

investasi portofolio

Quiz

•

University

45 questions

Pelayanan Prima

Quiz

•

University

55 questions

Latihan SKD 34

Quiz

•

University

Popular Resources on Wayground

10 questions

HCS SCI 03 Summer School Review 4

Quiz

•

3rd Grade

11 questions

HSMS - Standard Response Protocol

Quiz

•

6th - 8th Grade

16 questions

1.1-1.2 Quiz Review

Quiz

•

9th - 12th Grade

12 questions

Exponent Expressions

Quiz

•

6th Grade

20 questions

Adding and Subtracting Integers

Quiz

•

6th - 7th Grade

11 questions

Northeast States

Quiz

•

3rd - 4th Grade

10 questions

Characterization

Quiz

•

3rd - 7th Grade

10 questions

Common Denominators

Quiz

•

5th Grade

Mastering Python Basics and Libraries

What is the output of the following code: print(type([]))?

Which of the following is a mutable data structure in Python?

What will be the output of len([1, 2, 3])?

How do you create a NumPy array from a list?

What is the result of np.array([1, 2, 3]) + 1?

Which function is used to read a CSV file in Pandas?

What does the 'iloc' function in Pandas do?

How can you add a new column to a Pandas DataFrame?

What is the output of the following code: if 5 > 3: print('Yes') else: print('No')?

Which of the following is a valid way to define a function in Python?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground