根据列子串删除记录

Question

目标:从Dataframe中删除记录，基于第2列，index 1，子字符串。

我试过了：

df = df[df[1] != '305-1']
df = df[df[1] != '305-2']

但是，这是一个绝对值，而不是一个子字符串。

df

    1   2   3
0   Emissions   305-1~GHG emissions in metric tons of CO2e~Gro...   Emissions for Gross direct (Scope 1) GHG emiss...
1   Emissions   305-3~GHG emissions in metric tons of CO2e~Bio...   Emissions for Biogenic CO2 emissions was 14681...
2   Emissions   305-2~Direct (Scope 1) GHG emissions by gas~CO2 Emissions for CO2 was 107973 tons in year 2014...
3   Emissions   305-2~Direct (Scope 1) GHG emissions by gas~N20 Emissions for N20 was 91661 tons in year 2014,...
4   Emissions   305-3~Direct (Scope 1) GHG emissions by gas~HFCs    Emissions for HFCs was 31744 tons in year 2014...

所需输出df

1   Emissions   305-3~GHG emissions in metric tons of CO2e~Bio...   Emissions for Biogenic CO2 emissions was 14681...
4   Emissions   305-3~Direct (Scope 1) GHG emissions by gas~HFCs    Emissions for HFCs was 31744 tons in year 2014...

如果还有什么我可以添加到帖子中，请让我知道。

Answer 1

将Series.str.contains与|用于按位or与~的反转掩码

df[~df[1].str.contains('305-1|305-2')]

或使用[]中的特定值

df[~df[1].str.contains('305-[12]')]