遍历行以取消大写字符串单词

Question

我想知道如何转换此列中每个单词的首字母：TestThere is a cat UNDER the table The pen is working WELL.变成小写，为了有Test    there is a cat uNDER the table     the pen is working wELL.对于字符串，可以使用以下代码：" ".join(i[0].lower()+i[1:] for i in line.split(" "))我如何通过列中的行迭代它？

Answer 1

Series.str.replace与正则表达式模式和替换 lambda 函数一起使用。您可以测试正则表达式模式here：

df['Test'] = df['Test'].str.replace(r'((?<=\b)\S)', lambda x: x.group(1).lower())

结果：

                             Test

0  there is a cat uNDER the table

1        the pen is working wELL.

Answer 2

构建您的解决方案：

df["Test"] = [" ".join(entry[0].lower() + entry[1:] 

              for entry in word.split()) 

              for word in df.Test]

df

            Test

0   there is a cat uNDER the table

1   the pen is working wELL.

Answer 3

以下

import pandas as pd

def uncapitalise(x):

  words = x.split(' ')

  result = []

  for word in words:

    print(word)

    if word:

      word = word[0].lower() + word[1:]

    result.append(word)

  return ' '.join(result)

data = ['Test','There is a cat UNDER the table ','The pen is working WELL.']

df = pd.DataFrame(data)

df[0] = df[0].apply(uncapitalise)

print(df)