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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

45 questions

KEWIRAUSAHAAN Z

Quiz

•

University

52 questions

psicologia general: pensamiento, lenguaje e imaginación

Quiz

•

University

50 questions

Building Laws Preboard 2 of 2

Quiz

•

KG - Professional Dev...

50 questions

FSC (Forest Stewardship Council)

Quiz

•

University

53 questions

La Empresa y su Entorno

Quiz

•

11th Grade - University

55 questions

Powtórzenie z systematyki gleb

Quiz

•

University

46 questions

1er. parcial Fundamentos de la Administración Educativa 2020

Quiz

•

University

50 questions

Management Foundation Test

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Professional Development

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

5 questions

Poetry Interpretation

Interactive video

•

4th Grade - University

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

15 questions

Review1

Quiz

•

University

15 questions

Pre1

Quiz

•

University

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

Discover more resources for Professional Development