如何在Pandas中操纵字符串

Pandas库提供了多种方法，可用于根据所需的输出来处理字符串。但首先，让我们创建一个Pandas数据框架。

import pandas as pd
  
data = [[1, "ABC KUMAR", "xYZ"], [2, "BCD", "XXY"],
        [3, "CDE KUMAR", "ZXX"], [3, "DEF", "xYZZ"]]
  
cfile = pd.DataFrame(data, columns = ["SN", "FirstName", "LastName"])
  
cfile

输出:

如何在Pandas中操纵字符串？

“Pandas “库提供了一个 “.str() “方法，可以用来将数据框中的任何数据创建为字符串，之后就可以对这些数据使用python文档或本文中定义的任何字符串操作。

以下是说明一些例子的代码

# find firstname starting with 'D'
result = cfile.FirstName.str.startswith('D')
print(result)
  
# find lasttname containing 'XX'
result = cfile.LastName.str.contains('XX')
print(result)
  
  
# split FirstName on the basis of ' '
result = cfile.FirstName.str.split()
print(result)
  
  
# find length of lasttname
result = cfile.LastName.str.len()
print(result)
  
# Capitalize the first Letter of LastName
result = cfile.LastName.str.capitalize()
print(result)
  
# Capitalize all Letter of LastName
result = cfile.LastName.str.upper()
print(result)
  
# Convert all Letter of LastName to lowercase
result = cfile.LastName.str.lower()
print(result)

输出:

0    False
1    False
2    False
3     True
Name: FirstName, dtype: bool
0    False
1     True
2     True
3    False
Name: LastName, dtype: bool
0    [ABC, KUMAR]
1           [BCD]
2    [CDE, KUMAR]
3           [DEF]
Name: FirstName, dtype: object
0    3
1    3
2    3
3    4
Name: LastName, dtype: int64
0     Xyz
1     Xxy
2     Zxx
3    Xyzz
Name: LastName, dtype: object
0     XYZ
1     XXY
2     ZXX
3    XYZZ
Name: LastName, dtype: object
0     xyz
1     xxy
2     zxx
3    xyzz
Name: LastName, dtype: object