使用
groupby
+
transform
. 转换允许您将序列调用到新列。如果不使用transform,那么您将得到一个与dataframe不匹配的合并序列,而您的列将被填充
NaN
import pandas as pd
# df = pd.read_clipboard('\s\s+', header=None).rename({0: 'Street'}, axis=1) # how I read in your data from your StackOverflow question
df['Count'] = df.groupby('Street')['Street'].transform('count')
df
Out[1]:
Street Count
0 250 EAST HOUSTON STREET 1
1 211 EAST 3RD STREET 1
2 182 EAST 2ND STREET 1
3 511 EAST 11TH STREET 1
4 324 EAST 4TH STREET 8
5 324 EAST 4TH STREET 8
6 324 EAST 4TH STREET 8
7 324 EAST 4TH STREET 8
8 324 EAST 4TH STREET 8
9 324 EAST 4TH STREET 8
10 324 EAST 4TH STREET 8
11 324 EAST 4TH STREET 8
12 754 EAST 6TH STREET 1