/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

0 vote222 views1 answer
Python zip folder and subfolders
Python
0 vote209 views1 answer
Ad background image with tkinter
Python
0 vote232 views1 answer
Python program to calculate area of a rectangle using function
Python
1 vote204 views1 answer
Split a path into all subpaths
Python
23 votes276 views6 answers
Average python
Python
0 vote196 views1 answer
Annot identify image file '/home/ellis/CB/Django-Ecommerce/media_root/default.jpg'
Python
0 vote222 views1 answer
Python pandas convert comma separated number string to integer list
Python
21 votes203 views1 answer
Plot x y graph python
Python
0 vote239 views1 answer
Convert float with missing values to integer
Python
2 votes213 views1 answer
Python how to get number of strings in a list
Python