/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

5 votes270 views3 answers
Print whole dataframe python
Python
5 votes251 views1 answer
Matplotlib change thickness of line
Python
1 vote269 views2 answers
Fast fourier transform python
Python
3 votes234 views2 answers
Python dict order a dict by key
Python
0 vote228 views1 answer
Python remove middle of string
Python
6 votes234 views3 answers
If you have the following data structure, which of the following evaluates to 8? array = [[5,4,2],[4,4,1],[8,9,0],3];
Python
1 vote253 views2 answers
How to print out text in python
Python
0 vote251 views1 answer
Jumpssh execute multiple commands
Python
9 votes257 views4 answers
Sklearn random forest
Python
0 vote239 views1 answer
Setting a conditional variable in python. Using an if else statement in python.
Python