本文介绍了'dataframe'对象没有属性'str'问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试删除包含某些字符串的行.但是,我得到了错误:
I am trying to delete rows that contain certain strings. However, I am getting the error:
pandas-'dataframe'对象没有属性'str'错误.
pandas - 'dataframe' object has no attribute 'str' error.
这是我的代码:
df = df[~df['colB'].str.contains('Example:')]我该如何解决?
推荐答案第一个问题应该是重复的列名称,因此在选择colB之后,获取的不是Series,而是DataFrame:
First problem shoud be duplicated columns names, so after select colB get not Series, but DataFrame:
df = pd.DataFrame([['Example: s', 'as', 2], ['dd', 'aaa', 3]], columns=['colB','colB','colC']) print (df) colB colB colC 0 Example: s as 2 1 dd aaa 3 print (df['colB']) colB colB 0 Example: s as 1 dd aaa #print (df['colB'].str.contains('Example:')) #>AttributeError: 'DataFrame' object has no attribute 'str'解决方案应将列连接在一起:
Solution should be join columns together:
print (df['colB'].apply(' '.join, axis=1)) 0 Example: s as 1 dd aaa df['colB'] = df.pop('colB').apply(' '.join, axis=1) df = df[~df['colB'].str.contains('Example:')] print (df) colC colB 1 3 dd aaa
第二个问题应该是hidden MultiIndex:
Second problem should be hidden MultiIndex:
df = pd.DataFrame([['Example: s', 'as', 2], ['dd', 'aaa', 3]], columns=['colA','colB','colC']) df.columns = pd.MultiIndex.from_arrays([df.columns]) print (df) colA colB colC 0 Example: s as 2 1 dd aaa 3 print (df['colB']) colB 0 as 1 aaa #print (df['colB'].str.contains('Example:')) #>AttributeError: 'DataFrame' object has no attribute 'str'解决方案已重新分配至第一级:
Solution is reassign first level:
df.columns = df.columns.get_level_values(0) df = df[~df['colB'].str.contains('Example:')] print (df) colA colB colC 0 Example: s as 2 1 dd aaa 3第三个应该是MultiIndex:
df = pd.DataFrame([['Example: s', 'as', 2], ['dd', 'aaa', 3]], columns=['colA','colB','colC']) df.columns = pd.MultiIndex.from_product([df.columns, ['a']]) print (df) colA colB colC a a a 0 Example: s as 2 1 dd aaa 3 print (df['colB']) a 0 as 1 aaa print (df.columns) MultiIndex(levels=[['colA', 'colB', 'colC'], ['a']], codes=[[0, 1, 2], [0, 0, 0]]) #print (df['colB'].str.contains('Example:')) #>AttributeError: 'DataFrame' object has no attribute 'str'解决方案是通过tuple选择MultiIndex:
df1 = df[~df[('colB', 'a')].str.contains('Example:')] print (df1) colA colB colC a a a 0 Example: s as 2 1 dd aaa 3或重新分配:
df.columns = df.columns.get_level_values(0) df2 = df[~df['colB'].str.contains('Example:')] print (df2) colA colB colC 0 Example: s as 2 1 dd aaa 3或删除第二级:
df.columns = df.columns.droplevel(1) df2 = df[~df['colB'].str.contains('Example:')] print (df2) colA colB colC 0 Example: s as 2 1 dd aaa 3更多推荐
'dataframe'对象没有属性'str'问题
发布评论