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.

❮ DataFrame Reference