This post shows how to filter a panda dataframe for length of strings in a column. I am looking for a solution that implements this using query().
df = pd.DataFrame({'A': ['aa','bbb','aaaaa']})
#df.query("len(A) >2")
should drop the first row.
Asked
Active
Viewed 452 times
0
safex
- 2,398
- 17
- 40
-
1`df.query('A.str.len() > 2')`? – Shubham Sharma Jun 24 '20 at 15:50
-
try `df.query('A.str.len()>2',engine='python')` – anky Jun 24 '20 at 15:55
-
@anky this works for me. PLease repost as an answer – safex Jun 30 '20 at 11:42