/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 vote188 views1 answer
Python find center of polygon function
Python
24 votes167 views1 answer
How to replace na values in python
Python
0 vote226 views1 answer
Join a list of items with different types as string in Python
Python
6 votes176 views2 answers
If file exist in folder then delete in python \
Python
2 votes166 views6 answers
Python virtual env
Python
4 votes196 views1 answer
How to find the last item of a list
Python
0 vote177 views1 answer
Insertar en una lista anidada python
Python
4 votes193 views2 answers
ImportError: No module named django.core.wsgi
Python Django
2 votes175 views1 answer
Python read xlsb pandas
Python
3 votes182 views2 answers
Discord.py edit messages
Python