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

University

•

50 Qs

Similar activities

Aptitude & Math

University - Professional Development

•

50 Qs

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

University

•

46 Qs

Daring Juni 2020

KG - University

•

45 Qs

Latihan Soal UP Pedagogi

University

•

45 Qs

UAS Psikologi Industri_SGanjil 2022/2023211222

University

•

52 Qs

Management Quiz 7/7/2020

University

•

50 Qs

PENDIDIKAN IPS SD MODUL 5

University

•

50 Qs

CHƯƠNG 1: CÁC MÔ HÌNH TRUYỀN THÔNG

University

•

50 Qs

Mastering Python Basics and Libraries

Quiz

•

Professional Development

•

University

•

Practice Problem

•

Hard

Manjunatha M

Used 1+ times

FREE Resource

The 'iloc' function is used for string-based indexing in Pandas.

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

Create a free account and access millions of resources

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

50 questions

Management Foundation Test

Quiz

•

University

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

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Professional Development

9 questions

Principles of the United States Constitution

Interactive video

•

University

Mastering Python Basics and Libraries

50 questions

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?

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Professional Development