PandasのDataframeにあるデータを対象に分位数を使った足切りをしたい ## PandasDataframe? ## python3.6 Dataframe sensor_name temperature Humidity Pressure sensor1 15.5 67 1001 sensor1 15.8 68 1009 sensor2 13.3 57 1009 sensor2 13.2 55 1008 ... Dataframe(data) data_q = data.grpupby("sensor_name").quantile(0.9) Dataframe(data_q) sensor_name temperature Humidity Pressure sensor1 18.8 75 1014 sensor2 14.5 66 1015 sensor3 15.5 87 1002 ... Dataframedata(90%)NaN? sensor_name temperature Humidity Pressure sensor1 99.9 70 1004 ↓ sensor1data_qsensor1NaN sensor_name temperature Humidity Pressure sensor1 NaN 70 1004

pandas.DataFrame.wherepandas.DataFrame.mask
pandaswhere, mask

numpyimport


import numpy as np


where


data_q['temperature'].where(data_q['temperature'] <= 90.0, np.nan, inplace=True)


mask


data_q['temperature'].mask(data_q['temperature'] > 90.0, np.nan, inplace=True)


python 3.10python 3.6