/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 vote187 views1 answer
Python program to count all characters in a sentence
Python
-1 vote206 views1 answer
How to reduce the image files size in python
Python
7 votes244 views2 answers
Append record in csv
Python
0 vote193 views4 answers
How to convert array of arrays into single array with unique values in numpy
Python
4 votes187 views2 answers
Python selenium implicit wait
Python
0 vote215 views1 answer
Python program for getting url, hostname, port numbers
Python
14 votes247 views2 answers
Python tim script
Python
1 vote190 views1 answer
Python shortest path of list of nodes site:stackoverflow.com
Python
2 votes241 views2 answers
Python "for in" loop to print the last item in the list
Python
0 vote170 views1 answer
Table and amorization charts using tkinter
Python