You can select the rows of a DataFrame one of two ways. One way is with df.loc[...]. df.loc[...] selects rows based on their index value. To select a single row, you can do df.loc[index_value], for example, df.loc[156]. To select multiple rows, you can do df.loc[[index_value1, index_value2]], for example, df.loc[[132, 156]].
Suppose you constructed a DataFrame by
import pandas as pd df = pd.DataFrame({'name': ['Jeff', 'Esha', 'Jia'], 'age': [30, 56, 8]}, index=[132, 156, 27])
Where the index value is the person id in a database.
Giving you the DataFrame
| name | age | |
|---|---|---|
| 132 | Jeff | 30 |
| 156 | Esha | 56 |
| 27 | Jia | 8 |
Complete the function, select_Jia_row(df), by having it return the row with Jia in it. This should involve hard-coding the index value associated with Jia.
df = pd.DataFrame({'name': ['Jeff', 'Esha', 'Jia'], 'age': [30, 56, 8]}, index=[132, 156, 27])
| name | age | |
|---|---|---|
| 132 | Jeff | 30 |
| 156 | Esha | 56 |
| 27 | Jia | 8 |
| 27 | |
|---|---|
| name | Jia |
| age | 8 |