Revision history [back]

Assuming that the geometric box is defined by minimum and maximum values for each coordinate, we can use the following code to remove the rows in pandas:

import pandas as pd

# create sample data frame
df = pd.DataFrame({'x': [1, 2, 3, 4, 5],
                   'y': [2, 3, 4, 5, 6],
                   'z': [3, 4, 5, 6, 7]})

# define minimum and maximum values for the box
x_min = 2
x_max = 4
y_min = 3
y_max = 5
z_min = 4
z_max = 6

# filter the rows that fall within the box and assign to a new data frame
df_filtered = df.loc[(df['x'] < x_min) | (df['x'] > x_max) |
                     (df['y'] < y_min) | (df['y'] > y_max) |
                     (df['z'] < z_min) | (df['z'] > z_max)]

# display the filtered data frame
print(df_filtered)

In this example, the minimum and maximum values for the box are defined as xmin = 2, xmax = 4, ymin = 3, ymax = 5, zmin = 4 and zmax = 6. The code filters the rows that fall outside of this box using the loc function and logical operators. The filtered data frame is assigned to a new variable called df_filtered, which is then printed to the console.