w3resource

Pandas: Check whether alpha numeric values present in a given column of a DataFrame

Pandas: String and Regular Expression Exercise-9 with Solution

Write a Pandas program to check whether alpha numeric values present in a given column of a DataFrame.

Note: isalnum() function returns True if all characters in the string are alphanumeric and there is at least one character, False otherwise.

Sample Solution:

Python Code :

import pandas as pd
df = pd.DataFrame({
    'name_code': ['Company','Company a001','Company 123', '1234', 'Company 12'],
    'date_of_birth ': ['12/05/2002','16/02/1999','25/09/1998','12/02/2022','15/09/1997'],
    'age': [18.5, 21.2, 22.5, 22, 23]
})
print("Original DataFrame:")
print(df)
print("\nWhether all characters in the string are alphanumeric?")
df['name_code_is_alphanumeric'] = list(map(lambda x: x.isalnum(), df['name_code']))
print(df)

Sample Output:

Original DataFrame:
      name_code date_of_birth    age
0       Company     12/05/2002  18.5
1  Company a001     16/02/1999  21.2
2   Company 123     25/09/1998  22.5
3          1234     12/02/2022  22.0
4    Company 12     15/09/1997  23.0

Whether all characters in the string are alphanumeric?
      name_code            ...            name_code_is_alphanumeric
0       Company            ...                                 True
1  Company a001            ...                                False
2   Company 123            ...                                False
3          1234            ...                                 True
4    Company 12            ...                                False

[5 rows x 4 columns]

Python Code Editor:


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to find the index of a substring of DataFrame with beginning and end position.
Next: Write a Pandas program to check whether alphabetic values present in a given column of a DataFrame.

What is the difficulty level of this exercise?

Test your Python skills with w3resource's quiz



Python: Tips of the Day

Returns all the elements of a list except the last one

Example:

def tips_initial(lst):
  return lst[0:-1]

print(tips_initial([1, 2, 3, 4]))

Output:

[1, 2, 3]