/Python/Pandas apply check for string length in column

Pandas apply check for string length in column

#The *mask* variable is a dataframe of booleans, giving you True or False for the selected condition
mask = df[['A','B']].applymap(lambda x: len(str(x)) == 10)

#Here you can just use the mask to filter your rows, using the method *.all()* to filter only rows that are all True, but you could also use the *.any()* method for other needs
df = df[mask.all(axis=1)]

Source: stackoverflow.com

Pandas apply check for string length in column

df=pd.read_csv('filex.csv')
df.A=df.A.apply(lambda x: x if len(x)== 10 else np.nan)
df.B=df.B.apply(lambda x: x if len(x)== 10 else np.nan)
df=df.dropna(subset=['A','B'], how='any')

Source: stackoverflow.com

Similar codes

1 vote123 views1 answer
How to check the django version on a mac
Python Django
0 vote90 views1 answer
Ping all IP addresses in a network
Python
0 vote101 views1 answer
Python program to assess if a file is closed or not
Python
0 vote111 views1 answer
Turn false true column into 0 1 pandas
Python
0 vote115 views1 answer
Non venomous snakes
Python
0 vote105 views3 answers
Convert c++ code to python online
Python
1 vote104 views1 answer
Python make file path os
Python
0 vote125 views1 answer
Program to add first and last digit of a number in python
Python
0 vote105 views1 answer
Unpacking using List in Python
Python
0 vote108 views1 answer
Concatenate dataframes using one column
Python