如何计算series对象中有模式的字符串？

Question

假设数据如下：

>>> data
                x
0   [wdq, sda, q]
1    [q, d, qasd]
2  [d, b, sdaaaa]

我想知道每个列表中有多少个字符串包含a，这意味着我需要这样的答案：

>>> data
                x  count_a
0   [wdq, sda, q]        1
1    [q, d, qasd]        1
2  [d, b, sdaaaa]        1

如何在python中执行此操作？你知道吗

Answer 1

a = ['a', '12asf3', 'sdf']
b = ['gfdg5', '   ', 'vag gfd4']
c = [' fd4 ', 'sfsa fa', 'df4 a']

abc = [a, b, c]

for mem in abc:
  counter = 0
  for str in mem:
    if 'a' in str:
      counter += 1
  print abc.index(mem), mem, counter

输出：

0 ['a', '12asf3', 'sdf'] 2
1 ['gfdg5', '   ', 'vag gfd4'] 1
2 [' fd4 ', 'sfsa fa', 'df4 a'] 2

Answer 2

假设这是pandas.DataFrame，而x是list对象：

df['count_a'] = df['x'].apply(lambda x: sum('a' in e for e in x))

Answer 3

你可以试试这个

for i in my_series:
    print (i.count('a'))

这给了你的每一个系列信