/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 vote170 views4 answers
Python bool
Python
3 votes180 views1 answer
Draw a single pixel using pygame
Python
10 votes238 views3 answers
Django make migrations
Python Django
2 votes174 views3 answers
Linux python installation wheel
Python
0 vote180 views1 answer
Python Hewwo wowwd
Python
1 vote179 views1 answer
Require http method django view
Python
0 vote167 views1 answer
Python string starts with any char of list
Python
1 vote171 views1 answer
Python number of elements in multidimensional array
Python
0 vote162 views1 answer
Como poner estado a un bot en discord
Python
0 vote163 views1 answer
Python coding for y, you will also display a “bar” of ‘X’ characters to represent the number. For example, the prime number 2 would be represented as “X 2”.
Python