/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

1 vote263 views1 answer
Get wav file in dir
Python
1 vote264 views1 answer
Websocket communitation to another pc python
Python
0 vote271 views1 answer
How to get data after last slash in python
Python
0 vote261 views2 answers
Python send image server
Python
0 vote294 views1 answer
Django.db.utils.ProgrammingError: can't adapt type 'dict_keys'
Python Django
12 votes269 views1 answer
Print matrix eleme
Python
8 votes260 views5 answers
Find common elements in two lists python
Python
0 vote254 views1 answer
List -1 python
Python
0 vote280 views1 answer
Pandas find fifth caracter in field and change cell based on that number
Python
1 vote249 views1 answer
Euclidean division in python
Python