我有一个数据框,其中一列的形式是
Mat_Headers_Turbine = df_2['1'].unique().tolist()
print(Mat_Headers_Turbine)
['TURBINE , GAS ', 'TURBINE ', 'TURBINE,STEAM ', 'TURBINE, STEAM ', 'TURBINE,EXPANSION ', 'TURBINE STEAM ', 'STEAM TURBINE ', 'TURATING ', 'PUMPS, RECIPROCATING ', 'BLOWERS ', 'REGENERATOR CYLONE SEPERATOR ', 'MOBILE CRANE ', 'MECHANICAL SEAL ', 'TOOLS - MISCELLANEOUS', 'LADDERS ', 'TRANSDUCER ', 'FLAME SCANNERS AND PARTS:', 'VALVE, CONTROL, GLOBE ']
我只需要将对应的值提取到“TURBINE”,即“gas/steam/air/engine/expansion”的新列中。 行数约为50000。我如何才能做到这一点
您只需要使用以下查询
这将在所需列上显示包含
'TURBINE'
的所有行,然后显示相应的值相关问题 更多 >
编程相关推荐