Pandas DataFrame xs() Method
Example
Return the data where the car is a Ford
import pandas as pd
data = {
'weight': [929, 1109, 1112,
1119, 1328, 1584, 1415, 1235],
'co2': [95, 90, 99, 104, 105, 94,
99, 104],
'model': ['Citigo', 'Fabia', 'Fiesta', 'Rapid', 'Focus',
'Mondeo', 'Octavia', 'B-Max'],
'car': ['Skoda', 'Skoda', 'Ford',
'Skoda', 'Ford', 'Ford', 'Skoda', 'Ford']
}
df = pd.DataFrame(data)
df =
df.set_index(['car', 'model'])
print(df.xs('Ford'))
Try it Yourself »
Definition and Usage
The xs() method returns a specified section
of the DataFrame.
Syntax
dataframe.xs(key, axis, level, drop_level)
Parameters
Some parameters are keyword arguments.
| Parameter | Value | Description |
|---|---|---|
| key | Required. The label of the row you want to return. Use a tuple of labels
to return more than one label
|
|
| axis | number/index | Optional. Default 0. The axis to you want to return |
| level | label/position | Optional. Default 1. The level you want to return |
| drop_level | True|False | Optional. Default True. Specifies whether to return objects of same level as itself or not |
Return Value
A DataFrame with the selected result, or a Series if the result only contains one row.
