/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 vote165 views1 answer
Display cv2 image in jupyter notebook
Python
0 vote150 views1 answer
Streamlit headings;streamlit text
Python
86 votes151 views4 answers
How to delete a file in python
Python
0 vote160 views1 answer
After groupby how to add values in two rows to a list
Python
0 vote199 views1 answer
Best algorithm for classification
Python
1 vote179 views1 answer
SystemError: tile cannot extend outside image
Python
2 votes144 views2 answers
Cv2 add text
Python
1 vote156 views2 answers
{:.1%} print one decimal pandas
Python
0 vote157 views1 answer
ImportError: cannot import name 'dedent' from 'matplotlib.cbook'
Python
0 vote143 views1 answer
Discord bot response to private message python
Python