/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 vote225 views1 answer
Access field values of form django
Python Django
0 vote211 views1 answer
In python how to end the code after 10 input
Python
0 vote205 views1 answer
Python try script
Python
5 votes187 views4 answers
Ask a question on python
Python
0 vote218 views1 answer
Django.db.utils.ProgrammingError: can't adapt type 'dict_keys'
Python Django
1 vote212 views2 answers
Get the torch version
Python
0 vote187 views1 answer
Recursive python program to print numbers from n to 1
Python
0 vote252 views1 answer
How to create a custom function in python
Python
0 vote225 views3 answers
Django add user to group
Python Django
5 votes213 views1 answer
Python read csv into array
Python