在Python中从数据帧中的列提取数据

Question

我想从这个专栏中提取“A”（s）。完成后，我希望能够打印来自同一行中与“A”关联的其他列的其他数据。 但是，我的代码打印了以下内容：

outputs:
UniqueCarrier       NaN
CancellationCode    NaN
Name: CancellationCode, dtype: object
None

“CancellationCode”列如下所示

  CancellationCode:
        NaN
         A
        NaN
         B
        NaN

我想让它打印在一个数据帧格式的过滤行和列。 下面是我的代码： 提前谢谢

cancellation_reason = (flight_data_finalcopy["CancellationCode"] == "A") cancellation_reasons_filtered = cancellation_reason[["UniqueCarrier", "AirlineID", "Origin"]] print(display(cancellation_reasons_filtered))

Answer 1

试试这个

cancellation_reason=flight_data_finalcopy[flight_data_finalcopy["CancellationCode"] == "A"]
cancellation_reasons_filtered = cancellation_reason[["UniqueCarrier", "AirlineID", "Origin"]]
print(display(cancellation_reasons_filtered))