/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 vote126 views1 answer
Reportlab python add font style
Python
28 votes118 views3 answers
Pip install specific version
Python
0 vote139 views1 answer
Rotch randn
Python
6 votes187 views1 answer
Button in flask
Python Flask
-2 votes119 views1 answer
Youtube dl python
Python
15 votes135 views2 answers
'jupyter' is not recognized as an internal or external command, operable program or batch file.
Python
0 vote146 views9 answers
Python code checker and corrector
Python
26 votes129 views2 answers
Python year month day hour minute second
Python
0 vote123 views1 answer
Python data frame check if any nan value present
Python
1 vote124 views1 answer
How to get the live website html in python
Python