/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

6 votes299 views5 answers
Django logout
Python Django
0 vote222 views1 answer
Open google chrome from python
Python
0 vote293 views1 answer
Get source selenium python
Python
12 votes274 views3 answers
Get size of window tkinter
Python
1 vote345 views1 answer
Pig latin translator python
Python
0 vote341 views1 answer
Python Entry default text
Python
0 vote282 views1 answer
How to edit a pdf file in python
Python
0 vote284 views1 answer
How to duplicate a row in python
Python
1 vote276 views1 answer
Apostrophe in python
Python
6 votes310 views2 answers
Isnumeric
Python