How to Manipulate Strings in Pandas?

Pandas Library provides multiple methods that can be used to manipulate string according to the required output. But first, let's create a Pandas dataframe.

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

Output:

"Pandas" library provides a ".str()"  method that can be used to create any data of the data frame into a string,  After that any string operation defined in python documentation or in this article can be used on that data.

Below is  the code that illustrates some examples

# 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)

Output:

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