Pandas_Ops

How do you select all rows and only specific columns in a DataFrame using the loc() method?

• df.loc[:, columns]

• df.loc[rows, :]

• df.loc[rows, columns]

• df.loc[:, rows]

Answer explanation

To select all rows and only specific columns in a DataFrame using the loc method, we can pass the : and columns as arguments to the loc method. Using df.loc[:, columns] will select all rows and only the specified columns.

Which slicing operation is used to select rows from index 2 to index 5 (inclusive) in a DataFrame?

• df.loc[2:6]

• df.iloc[2:5]

• df.iloc[2:6]

• df.loc[2:5]

Answer explanation

Slicing notation df.iloc[2:6] is used to select rows from index 2 to index 5 (inclusive) in a DataFrame. The ending index is exclusive, so using [2:6] will select rows with indices 2, 3, 4 and 5.

How do you add a new row to a DataFrame using the loc() method?

• df.loc[row_label] = row_data

• df.loc[:, row_label] = row_data

• df.loc[row_data, row_label]

• df.loc[row_data] = row_label

Answer explanation

To add a new row to a DataFrame using the loc method, we can assign the row data to a new row label. Using df.loc[row_label] = row_data will add a new row with the specified label and corresponding data.

1. 
   Given a DataFrame df, write a code snippet to delete the column named Salary.

• df.drop(Salary, axis=1)

• df.drop('Salary',inplace=True)

• df.remove(Salary)

• df=df.drop('Salary',axis=1,inplace=False)

Answer explanation

To delete a column named "Salary" from a DataFrame, we can use the drop method with axis=1 to indicate that we are dropping a column. Using df=df.drop("Salary", axis=1,inplace=False) will delete the "Salary" column.

How do you delete a third row named row_3 from a DataFrame using the drop() method?

• df.drop(row_3,inplace=True)

• df.drop(df.index[2],inplace='True')

• df.drop('row_3',axis=1,inplace='True')

• df.drop('row_3')

Answer explanation

To delete a specific row named "row_3" from a DataFrame, we can use the drop method with:

df.index[2] to get the label of third row.

axis=0

and

inplace=True

Given a DataFrame df with columns A and B, write a code snippet to rename the row index from 'old_index' to 'new_index'.

• df=df.rename(index={'old_index': 'new_index'})

• df=df.rename(index=['old_index', 'new_index'])

• df=df.rename(index='old_index', new_index='new_index')

• df.rename({'old_index': 'new_index'},axis=0)

Answer explanation

To rename the row index from "old_index" to "new_index" in a DataFrame, we can use the rename method and pass a dictionary to the index parameter. Using df.rename(index={'old_index': 'new_index'}) will rename the row index accordingly.
As iplace is false by default save the copy in the df itself.

How do you delete columns with names ['col1', 'col2', 'col3'] from a DataFrame df using the drop() method?

• df.drop(['col1', 'col2', 'col3'])

• df=df.drop(['col1', 'col2', 'col3'], axis=0)

• df.drop(['col1', 'col2', 'col3'], axis=1)

• df.drop(['col1', 'col2', 'col3'],axis=1, inplace=True)

Answer explanation

To delete columns with names "col1", "col2", and "col3" from a DataFrame, we can use the drop method with axis=1 to indicate that we are dropping columns. Using

df.drop(['col1', 'col2', 'col3'],axis=1, inplace=True) will delete the specified columns.

import pandas as pd

data = { 'Name': ['John', 'Emma'], 'Age': [25, 30], 'City': ['New York', 'London'] }

df = pd.DataFrame(data)

What is the resulting DataFrame after performing the following operations on the original DataFrame?

1. 1, Addition of a new row with the data ['Mike', 35, 'Paris']

2. 2. Deletion of the column named "City"

3. 3. Renaming the row index 1 to "Row2" and column name 'Name' to 'First Name'

• Name Age

  0 John 25

  Row2 Emma 30

  2 Mike 35

• First Name Age

  0 John 25

  Row2 NaN 30

  2 NaN 35

• First Name Age

  0 John 25

  Row2 Emma 30

  2 Mike 35

• First Name Age City

  0 John 25 New York

  Row2 NaN 30 NaN

  2 NaN 35 NaN

Answer explanation

The original DataFrame df is modified by adding a new row with the data ['Mike', 35, 'Paris'], deleting the column named "City," and renaming the row index 1 to "Row2" and column name 'Name' to 'First Name'. The resulting DataFrame after these operations is as shown in option c).

Given the DataFrame:

import pandas as pd

data = { 'Name': ['John', 'Emma'], 'Age': [25, 30], 'City': ['New York', 'London'] }

df = pd.DataFrame(data)

Write down the code to perform the following operations on the original DataFrame:

1. 1. Addition of a new row with the data ['Mike', 35, 'Paris']

2. 2. Deletion of the column named "City"

3. 3. Renaming the row index 1 to "Row2" and column name 'Name' to 'First Name'.

Answer explanation

1. 1. Addition of a new row with the data ['Mike', 35, 'Paris']

2. df.loc[2] = ['Mike', 35, 'Paris']

3. 2. Deletion of the column named "City".

4. df = df.drop('City', axis=1)

5. 3. Renaming the row index 1 to "Row2" and column name 'Name' to 'First Name'.

6. df = df.rename(index={1: 'Row2'}, columns={'Name': 'First Name'})