首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >无法为Pandas中的某些列赋值

问无法为Pandas中的某些列赋值
EN

Stack Overflow用户
提问于 2017-11-24 08:20:56
回答 0查看 490关注 0票数 1

您好,我正在尝试分配数据帧的列中的某些值。

代码语言:javascript
复制
# Count the number of title counts
full.groupby(['Sex', 'Title']).Title.count()
Sex     Title        
female   Dona              1
         Dr                1
         Lady              1
         Miss            260
         Mlle              2
         Mme               1
         Mrs             197
         Ms                2
         the Countess      1
male     Capt              1
         Col               4
         Don               1
         Dr                7
         Jonkheer          1
         Major             2
         Master           61
         Mr              757
         Rev               8
         Sir               1
Name: Title, dtype: int64

我的dataframe尾部如下所示:

代码语言:javascript
复制
    Age Cabin   Embarked    Fare    Name    Parch   PassengerId Pclass  Sex SibSp   Survived    Ticket  Title
413 NaN NaN S   8.0500  Spector, Mr. Woolf  0   1305    3   male    0   NaN A.5. 3236   Mr
414 39.0    C105    C   108.9000    Oliva y Ocana, Dona. Fermina    0   1306    1   female  0   NaN PC 17758    Dona
415 38.5    NaN S   7.2500  Saether, Mr. Simon Sivertsen    0   1307    3   male    0   NaN SOTON/O.Q. 3101262  Mr
416 NaN NaN S   8.0500  Ware, Mr. Frederick 0   1308    3   male    0   NaN 359309  Mr
417 NaN NaN C   22.3583 Peter, Master. Michael J    1   1309    3   male    1   NaN 2668    Master

我的数据帧的名称是full,我想更改标题的名称。

下面是我写的代码:

代码语言:javascript
复制
# Create a variable rate_title to modify the names of Title
rare_title = ['Dona', "Lady", "the Countess", "Capt", "Col", "Don", "Dr", "Major", "Rev", "Sir", "Jonkheer"]
# Also reassign mlle, ms, and mme accordingly
full[full.Title == "Mlle"].Title = "Miss"
full[full.Title == "Ms"].Title = "Miss"
full[full.Title == "Mme"].Title = "Mrs"
full[full.Title.isin(rare_title)].Title = "Rare Title"

我还在pandas中尝试了以下代码:

代码语言:javascript
复制
full.loc[full['Title'] == "Mlle", ['Sex', 'Title']] = "Miss"

尽管如此,数据帧仍然没有改变。任何帮助都是非常感谢的。

EN

回答

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/47464823

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档