Pandas:添加具有其他列长度的列作为值 [英] Pandas: adding column with the length of other column as value

问题描述

我想向现有数据框添加一个附加列，该列的值是seller_name"列的长度.

I want to add an additional column to an existing dataframe that has the length of the 'seller_name' column as its value.

输出应该是这样的:

seller_name    name_length
-------------|-------------
Rick         |      4
Hannah       |      6

但是，我很难获得正确的代码.

However, I'm having difficulty getting the code right.

df['name_length']  = len(df['seller_name'])

只给我整列的长度 (6845)和

just gives me the length of the entire column (6845) And

df['nl']  = df[len('seller_name')]

抛出一个 KeyError.

Throws a KeyError.

有人知道实现我的目标的正确命令吗?

Does anyone know the correct command to achieve my goal?

非常感谢！

推荐答案

使用 .str 字符串访问器对 DataFrame 执行字符串操作.特别是，您需要 .str.len:

Use the .str string accessor to perform string operations on DataFrames. In particular, you want .str.len:

df['name_length']  = df['seller_name'].str.len()

结果输出:

  seller_name  name_length
0        Rick            4
1      Hannah            6

这篇关于Pandas:添加具有其他列长度的列作为值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！