/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 vote307 views0 answer
Python
0 vote326 views1 answer
Python resample and interpolate
Python
0 vote308 views1 answer
How to upgrade python from 2.7 to 2.9 on ubuntu 14.04
Python
0 vote315 views1 answer
DRf Representation
Python
0 vote349 views1 answer
Comma separator f string python
Python
0 vote312 views1 answer
Python attributes from string
Python
0 vote342 views1 answer
Sum
Python
0 vote339 views1 answer
Python start process in background and get pid
Python
1 vote328 views1 answer
Model.predict([x_test]) error
Python
0 vote337 views1 answer
Mac big sur and python3 problems
Python