Skip to main content
 首页 » 编程设计

python之过滤 Pandas 数据框的行不起作用

2025年02月15日1398°冷暖

<分区>

我有以下 Pandas 数据框:

In [23]: df 
Out[23]:  
                                                 names 
0                                        Alabama[edit] 
1                        Auburn (Auburn University)[1] 
2               Florence (University of North Alabama) 
3      Jacksonville (Jacksonville State University)[2] 
4           Livingston (University of West Alabama)[2] 
5             Montevallo (University of Montevallo)[2] 
6                            Troy (Troy University)[2] 
7    Tuscaloosa (University of Alabama, Stillman Co... 
8                    Tuskegee (Tuskegee University)[5] 
9                                         Alaska[edit] 
10       Fairbanks (University of Alaska Fairbanks)[2] 
11                                       Arizona[edit] 
12          Flagstaff (Northern Arizona University)[6] 
13                    Tempe (Arizona State University) 
14                      Tucson (University of Arizona) 

如您所见,names 中的某些条目中包含单词 [edit]。我只想过滤这些条目并从中创建一个新的数据框。所以我尝试了:

In [24]: df1 = df[df['names'].str.contains("[edit]")] 

但是,新的数据框 df1 没有给我想要的东西,它仍然包含原始数据框的所有条目:

In [25]: df1.head() 
Out[25]:  
                                             names 
0                                    Alabama[edit] 
1                    Auburn (Auburn University)[1] 
2           Florence (University of North Alabama) 
3  Jacksonville (Jacksonville State University)[2] 
4       Livingston (University of West Alabama)[2] 

我究竟缺少什么,我该如何解决?